ClearFoundation Tracker - ClearOS
View Issue Details
0020071ClearOSsystem-mariadbpublic2018-04-23 09:122020-04-01 08:23
bchambers 
NickH 
lowminorsometimes
closedsuspended 
7.4.0 
 
0020071: MariaDB not completely sandboxed
Had a support ticket come in where system-mariadb failed to start.

Customer had installed MySQL packages from outside the ClearOS/CentOS repository.

It was a new version (5.6.40) and wrote some errmsg.sys files to basedir default which is /usr/share/mysql

System Database mariadb also uses this default basedir, and the updated errmsg.sys file(s) barf at:

180423 16:54:05 [ERROR] Incompatible header in messagefile '/usr/share/mysql/english/errmsg.sys'. Probably from another version of MariaDB
180423 16:54:05 [ERROR] Aborting

My hack was to create /usr/share/system-mysql/

and edit the systemd unit file from:

ExecStart=/usr/clearos/sandbox/usr/bin/mysqld_safe --basedir=/usr

to:
ExecStart=/usr/clearos/sandbox/usr/bin/mysqld_safe --basedir=/usr/share/system-mysql

Which made me require a relative path of :

/usr/share/system-mysql/share/mysql

Restoring some original errmsg.sys files allowed both daemons to start in parallel.

It would be better/complete to find out where MariaDB stores and sets the basedir path, and change it from 'mysql' to 'system-mysql' so that /usr/share/system-mysql was created and used by default and would not interfere with someone installing MySQL from outside our repos.
No tags attached.
Issue History
2018-04-23 09:12bchambersNew Issue
2018-04-23 09:36user2Statusnew => confirmed
2018-04-23 09:36user2Prioritynormal => low
2018-04-23 09:37user2Categoryapp-system-database - System Database => system-mariadb
2020-04-01 08:23NickHNote Added: 0013761
2020-04-01 08:23NickHStatusconfirmed => closed
2020-04-01 08:23NickHAssigned To => NickH
2020-04-01 08:23NickHResolutionopen => suspended

Notes
(0013761)
NickH   
2020-04-01 08:23   
Migrated to https://gitlab.com/clearos/upstream/centos/system-mariadb/-/issues/1 [^]