Difference between revisions of "Software Collections:MySQL"

From SME Server
Jump to navigationJump to search
(Page init)
Line 4: Line 4:
 
</blockquote>
 
</blockquote>
  
Placeholder.  
+
'''Installing and running MySQL via [[Software collections]]'''
 +
 
 +
Software Collections has been introduced by Redhat as a safe way to run selective applications on Redhat based distributions in an isolated environment (separate directory), thus not effecting the base installation of the OS. This provides the possibility to e.g. test an application, install a higher version then the version installed by the base system (e.g. PHP), or temporarily use an application.
 +
 
 +
Software Collections applications can be started at boot as a system service, manually or in a specific shell.
 +
 
 +
==MySQL==
 +
===Installation===
 +
To be able to install an application from the Software Collections, one '''must''' install software collections first. Please see [[Software collections]] on how to install this.
 +
 
 +
 
 +
====Required repository====
 +
After installing Software Collections, the [http://wiki.contribs.org/Scl#tab=MySQL55 '''scl'''] repository for PostgreSQL has to added to the yum repositories. Please see [http://wiki.contribs.org/Scl#tab=MySQL55 '''here'''] on how the enable the [http://wiki.contribs.org/Scl#tab=MySQL55 '''scl-mysql55'''] repository.
 +
 
 +
 
 +
====Install application====
 +
After installing the scl-mysql55 repository, MySQL can be installed by issuing the following command:
 +
yum install mysql55 --enablrepo=scl-mysql55
 +
Once installed, the application is installed on your SME Server at '''/opt/rh/mysql55-''' as an isolated environment for the application.
 +
 
 +
Only '''1''' service script has been installed on your base SME Server which is '''/etc/rc.d/init.d/mysql55-mysqld'''. This script will start and stop the installed application.
 +
 
 +
 
 +
====Test installed application====
 +
Once MySQL has been installed, you can check if it is correctly installed by issuing:
 +
scl -l
 +
which will provide you a listing of all applications that are available on your system installed via Software Collections.
 +
 
 +
A simple man page about the installed application is now available via:
 +
scl enable mysql55 'man mysql55'
 +
press 'q' to leave the man page
 +
 
 +
 
 +
===Start/Stop MySQL===
 +
PostgreSQL is now installed and initialized, and can be started and stopped manually via:
 +
/etc/rc.d/init.d/mysql55-mysqld start
 +
and
 +
/etc/rc.d/init.d/mysql55-mysqld stop
 +
 
 +
 
 +
====Start/Stop PostgreSQL as a system service====
 +
Issue the following commands as root:
 +
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99mysql55-mysqld
 +
chkconfig mysql55-mysqld on
 +
config set mysql55-mysqld service
 +
config setprop mysql55-mysqld status enabled
 +
The application will now automatically start at boot time as a system service.
 +
 
 +
 
 +
====Configure private/public access====
 +
If your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN) the ports and access privileges need to be set. For this issue the following commands (where 5432 is the port that MySQL can be reached on):
 +
config setprop mysql55-mysqld TCPPort 5432
 +
config setprop mysql55-mysqld UDPPort 5432
 +
config setprop mysql55-mysqld access private
 +
followed by the event to update the firewall rules:
 +
signal-event remoteaccess-update
 +
You can toggle between private and public access followed by the remoteaccess-update command.
 +
 
  
 
==Other articles in this category==
 
==Other articles in this category==

Revision as of 09:24, 7 January 2015

Warning.png Work in Progress:
This page is a Work in Progress. The contents off this page may be in flux, please have a look at this page history the to see list of changes.


Mysql.png

Installing and running MySQL via Software collections

Software Collections has been introduced by Redhat as a safe way to run selective applications on Redhat based distributions in an isolated environment (separate directory), thus not effecting the base installation of the OS. This provides the possibility to e.g. test an application, install a higher version then the version installed by the base system (e.g. PHP), or temporarily use an application.

Software Collections applications can be started at boot as a system service, manually or in a specific shell.

MySQL

Installation

To be able to install an application from the Software Collections, one must install software collections first. Please see Software collections on how to install this.


Required repository

After installing Software Collections, the scl repository for PostgreSQL has to added to the yum repositories. Please see here on how the enable the scl-mysql55 repository.


Install application

After installing the scl-mysql55 repository, MySQL can be installed by issuing the following command:

yum install mysql55 --enablrepo=scl-mysql55

Once installed, the application is installed on your SME Server at /opt/rh/mysql55- as an isolated environment for the application.

Only 1 service script has been installed on your base SME Server which is /etc/rc.d/init.d/mysql55-mysqld. This script will start and stop the installed application.


Test installed application

Once MySQL has been installed, you can check if it is correctly installed by issuing:

scl -l

which will provide you a listing of all applications that are available on your system installed via Software Collections.

A simple man page about the installed application is now available via:

scl enable mysql55 'man mysql55'

press 'q' to leave the man page


Start/Stop MySQL

PostgreSQL is now installed and initialized, and can be started and stopped manually via:

/etc/rc.d/init.d/mysql55-mysqld start

and

/etc/rc.d/init.d/mysql55-mysqld stop


Start/Stop PostgreSQL as a system service

Issue the following commands as root:

ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99mysql55-mysqld
chkconfig mysql55-mysqld on
config set mysql55-mysqld service
config setprop mysql55-mysqld status enabled

The application will now automatically start at boot time as a system service.


Configure private/public access

If your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN) the ports and access privileges need to be set. For this issue the following commands (where 5432 is the port that MySQL can be reached on):

config setprop mysql55-mysqld TCPPort 5432
config setprop mysql55-mysqld UDPPort 5432
config setprop mysql55-mysqld access private

followed by the event to update the firewall rules:

signal-event remoteaccess-update

You can toggle between private and public access followed by the remoteaccess-update command.


Other articles in this category

Mysql57, PHP Software Collections, Software Collections, Software Collections Repositories, Software Collections:MariaDB, Software Collections:MongoDB, Software Collections:MySQL, Software Collections:MySQL55, Software Collections:Nodejs, Software Collections:PHP, Software Collections:PostgreSQL, Software Collections:Python, Software Collections:Ruby on Rails