New CCM doesn't work after MySQL offload

[BanditBBS]

I followed the instructions to offload mysql to another server. everything went fine until it was time to change the setting in CCM. Legacy CCM works fine and has the proper settings in it. However, the new CCM won't load, just blank pages.

Nagios 2012R1.0
Manual Insatll Redhat Enterprise

[BanditBBS]

Wow, after a couple minutes the login screen finally came up for CCM with a "Error connecting to database" message as well. Trying to login but I suspect it is going to be broken as well.

I'm guessing there is a setting in some file I have to change for the new CCM to work, but no clue which file.

[mguthrie]

Did you previously have the CCM beta version installed on this system?

Try making an update (add a comment) to the following file and see if the CCM picks up the changes:
/usr/local/nagiosxi/html/config.inc.php

Verify the DB credentials in this script as well since this is what the new CCM will use to connect.

[BanditBBS]

Updating that file was part of the documentation I followed(from the exchange).

If I go into Legacy CCM and into CCM Settings, it shows all the proper settings. New CCM just never loads anything.

This is a machine that is brand new, no Nagios was ever on it.

[BanditBBS]

Further information.

MySQL is stopped on the NagiosXI server.
I went into Legacy CCM, changed a description on a host, applied settings and verified the change does show up when browsing to that host.

[BanditBBS]

I think I found the issue. The linux admin had typo'd the IP in the config.inc.php file. But nothing was working after that. Once we fixed that, we got to the pint we are at now. In Legacy CCM, it shows all the right settings. In the new CCM if I select Config Manager Settings and wait forever for it to time out, it has the typo IP in there. I click save and I get this error:

Code: Select all

An error occured while writing settings to database
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)Unable to save to file: config/settings.php

[mguthrie]

The new CCM connects with the values in the following file. This file is auto-generated each time the /usr/local/nagiosxi/html/config.inc.php is updated (or at least it's supposed to).

/usr/local/nagiosxi/etc/components/ccm_config.inc.php

[BanditBBS]

Mike,

I edited that file and all is good now. So under some circumstance I caused, it did not auto update that file.

[mguthrie]

Ok, thanks for the update!