859
edits
Changes
From SME Server
Jump to navigationJump to search→Start/Stop MariaDB as a system service
<nowiki>
<nowiki>
[mariadbd]
[mariadbd]
datadir=/opt/rh/mariadb55/root/var/lib/mysql
datadir=/opt/rh/mariadb55/root/var/lib/mysql
socket=/var/lib/mysql/mariadb55.sock
socket=/var/lib/mysql/mariadb55.sock
port=3307
port=3307
# Disabling symbolic-links is recommended to prevent assorted security risks
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under different user or group,
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
# instructions in http://fedoraproject.org/wiki/Systemd
[mariadbd_safe]
[mariadbd_safe]
log-error=/var/log/mariadb55-mariadbd.log
log-error=/var/log/mariadb55-mariadbd.log
pid-file=/opt/rh/mariadb55/root/var/run/mysqld/mariadbd.pid
pid-file=/opt/rh/mariadb55/root/var/run/mysqld/mariadbd.pid
</nowiki>
</nowiki>
===Start/Stop MariaDB===
===Start/Stop MariaDB===
Issue the following commands as root:
Issue the following commands as root:
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99mariadb55-mariadbd
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99mariadb55-mariadbd
chkconfig maridb55-mysqld on
chkconfig mariadb55-mysqld on
config set maria55-mysqld service
config set mariadb55-mysqld service
config setprop mariadb55-mysqld status enabled
config setprop mariadb55-mysqld status enabled
The application will now automatically start at boot time as a system service.
The application will now automatically start at boot time as a system service.
====Configure private/public access====
====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 MariaDB can be reached on):
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 3307 is the port that MariaDB can be reached on as set in my.conf above - please check if this port is already in use e.g mysql55 from SCL):
config setprop maridb55-mysqld TCPPort 3307
config setprop mariadb55-mysqld TCPPort 3307
config setprop mariadb55-mysqld UDPPort 3307
config setprop mariadb55-mysqld UDPPort 3307
config setprop mariadb55-mysqld access private
config setprop mariadb55-mysqld access private
