FYI to save some headache in upgrading to 2014
Here is the solution since the thread below was locked
How to upgrade XI with offloaded DB
http://support.nagios.com/forum/viewtop ... 16&t=27657
My connection problem to MySQL was resolved by using the following instructions
Code: Select all
You will need to copy the script below to the remote database server:
/usr/local/nagiosxi/scripts/repairmysql.sh
Then run the script on the remote db server against both dbs:
./repairmysql.sh nagios
./repairmysql.sh nagiosql
Then try to run the upgrade again.
Anyway the end result was a successful upgrade.
Things to look out for.
Configuration script check for version 2014 is stricter than 2012.
It is best to resolve all warnings before the upgrade else you are going to end up running the upgrade a few times like me.
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
If any your services does not have any hosts assigned to it, it will fail.
After upgrade, all the hosts had missing schedule immediate check and the Response Time graphs was showing "You have no access .."
A simple Apply Configuration without making any changes fixed all this problem.
Glad the upgrade headache was resolved.