Nagios XI 2014R1.1 to Nagios 5.4.2 Offloaded Mysql

[mlopez]

Hi All,
Yesterday I tried upgrading to 5.4.2 which everything went fine but I wasn't receiving new SNMP traps and ndo2db queue was accumulating and was wondering if there is a way for me to confirm the new sql schema was updated on the offloaded server.

Also if it isn't upgraded how would I manually upgrade it.

BTW everything loaded fine except for some odd reason all the Monitoring Engine Check Services were off + Notification (which might be the cause of the issue).
- All hosts had all content loaded and old alerts appeared
- Tried rebooting the server
- Tried restarting snmptrapd + snmptt, ndo2db, nagios and no luck
- snmptt.log was being populated with new alerts

Any help would be greatly appreciated, thanks again!

[tgriep]

Did you run through the Manual Upgrade procedure to upgrade your XI server or did you do the Upgrade is the XI GUI?

Depending on how it was run, there should be an upgrade.log file we would have to see if the upgrade had any errors.
Can you post the upgrade.log file from one of the following folders?

Code: Select all

/tmp/nagiosxi
/usr/local/nagiosxi/tmp

Then, can you run the following to dump the table schema fron your offloaded mysql server and then post the /tmp/nagios.txt and /tmp/nagiosql.txt files?

Code: Select all

mysqldump --no-data nagios -u nagios -pnagios >/tmp/nagios.txt  -h xxx.xxx.xxx.xxx
mysqldump --no-data nagiosql -u nagios -pnagios >/tmp/nagiosql.txt  -h xxx.xxx.xxx.xxx

Replace xxx.xxx.xxx.xxx with the IP address of your remote mysql server.