Warning: World-writable config file '/opt/CA/spectrum/mysql/my-spectrum.cnf' is ignored

Document ID : KB000008596
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Archive Manager will not start. We are seeing an error in the MYSQL log:

 

Warning: World-writable config file '/opt/CA/spectrum/mysql/my-spectrum.cnf' is ignored 

170914 16:06:25 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 

170914 16:06:25 [Note] /opt/CA/spectrum/mysql/bin//mysqld (mysqld 5.5.53-enterprise-commercial-advanced) starting as process 124924 ... 

170914 16:06:25 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys' 

170914 16:06:25 [Warning] Can't create test file /usr/local/mysql/data/epslx1045.lower-test 

170914 16:06:25 [Warning] Can't create test file /usr/local/mysql/data/epslx1045.lower-test 

^G/opt/CA/spectrum/mysql/bin//mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 

170914 16:06:25 [ERROR] Aborting 

Environment:
Linux OSSpectrum 10.2.1
Cause:

Permission changes in MYSQL directory are causing files not to be read/show as missing. 

Resolution:

"Warning: World-writable config file '/opt/CA/spectrum/mysql/my-spectrum.cnf' is ignored " 

 

This error in the log indicates the permissions on my-spectrum.cnf are open to any user. It should only be access by the file owner (in this case, the Spectrum install user) 

Run this command to revert permissions back to default: 

 

sudo chmod 0644 /opt/CA/spectrum/mysql/my-spectrum.cnf 

 

Then try restarting MySQL. 

 

If MySQL starts, then try starting Archive Manager. 

Additional Information:

https://ubuntuforums.org/showthread.php?t=1811158