SYSTEM WARNING: 'file_get_contents(https://www.clearos.com/?rendertype=json&get=header): failed to open stream: Connection refused' in '/var/www/virtual/newwrapper/cf_topmenu.inc' line 5

ClearOS Bug Tracker


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0020071ClearOSsystem-mariadbpublic2018-04-23 09:122020-04-01 08:23
Reporterbchambers 
Assigned ToNickH 
PrioritylowSeverityminorReproducibilitysometimes
StatusclosedResolutionsuspended 
PlatformOSOS Version
Product Version7.4.0 
Target VersionFixed in Version 
Summary0020071: MariaDB not completely sandboxed
DescriptionHad 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.
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0013761)
NickH (developer)
2020-04-01 08:23

Migrated to https://gitlab.com/clearos/upstream/centos/system-mariadb/-/issues/1 [^]

- Issue History
Date Modified Username Field Change
2018-04-23 09:12 bchambers New Issue
2018-04-23 09:36 user2 Status new => confirmed
2018-04-23 09:36 user2 Priority normal => low
2018-04-23 09:37 user2 Category app-system-database - System Database => system-mariadb
2020-04-01 08:23 NickH Note Added: 0013761
2020-04-01 08:23 NickH Status confirmed => closed
2020-04-01 08:23 NickH Assigned To => NickH
2020-04-01 08:23 NickH Resolution open => suspended

SYSTEM WARNING: 'file_get_contents(https://www.clearos.com/?rendertype=json&get=footer): failed to open stream: Connection refused' in '/var/www/virtual/newwrapper/cf_footer.inc' line 7