859
edits
Changes
From SME Server
Jump to navigationJump to searchUpdate Port notes
<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===
====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 maridb55-mysqld TCPPort 3307
config setprop mariadb55-mysqld UDPPort 3307
config setprop mariadb55-mysqld UDPPort 3307
