Page 1 of 1
New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 10:17 am
by 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
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 10:22 am
by 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.
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 10:30 am
by 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.
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 10:35 am
by 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.
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 10:44 am
by 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.
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 11:46 am
by 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
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 12:55 pm
by 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
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 1:14 pm
by BanditBBS
Mike,
I edited that file and all is good now. So under some circumstance I caused, it did not auto update that file.
Re: New CCM doesn't work after MySQL offload
Posted: Fri Oct 19, 2012 2:19 pm
by mguthrie
Ok, thanks for the update!