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

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

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/#####.lower-test 

170914 16:06:25 [Warning] Can't create test file /usr/local/mysql/data/#####.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

Release:
Component:

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