"Error connecting to database" after changing CCM settings

[cwscribner]

Hi all.

I recently attempted to offload MySQL to a separate server. I changed the IP address in the Config Manager Settings to the server holding the new MySQL database and now get an "Error connecting to database" message in the CCM. How can I fix this?

[nscott]

The biggest cause of this is:

Bad password / Firewall settings

Can you drop down the terminal and try some stuff out:

In these examples I'm going to use the variables REMOTEIP will be the IP of the MySQL server you offloaded to, PASSWORD, USERNAME are the password and username for the REMOTE MySQL server, and NAGIOS is the name of the NAGIOS database and NAGIOSQL is the name of the nagiosql database

mysql -u USERNAME -p PASSWORD -h REMOTEIP

Does this connect?

mysql -u USERNAME -pPASSWORD -h REMOTEIP NAGIOS
mysql -u USERNAME -pPASSWORD -h REMOTEIP NAGIOSQL

Does these connect?

If none of those connect look at the firewall/authentication.

[cwscribner]

Both of those successfully connect.

[mguthrie]

The DB settings for the CCM may be trying to connect with the settings located in the following file:
/var/www/html/nagiosql/config/settings.php

Update the credentials and address in this file and see if it connects.

[cwscribner]

That fixed it. Thanks!

[mguthrie]

Good deal!