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
Permission changes in MYSQL directory are causing files not to be read/show as missing.
"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.
https://ubuntuforums.org/showthread.php?t=1811158