ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 8596

calendar_today

Updated On:

Products

CA Spectrum

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/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 

Cause

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

Environment

Release:
Component:

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