Page 1 of 1

Services not visible after upgrade to XI 5.8.5

Posted: Tue Jul 20, 2021 11:04 am
by snapier3
After upgrade to NagiosXI XI 5.8.5 using the upgrade script

Code: Select all

"wget -O upgrade.sh https://assets.nagios.com/downloads/nagiosxi/upgrade.sh
sh ./upgrade.sh"
The configured services are no longer visible in the NagiosXI Interface but, remain visible in CCM and Nagios Core.
XI Services
XI Services
NagiosXI CCM Services
Known Services
Known Services
Nagios Core
Core - Known Critical Fail
Core - Known Critical Fail
I have tried to run repair scripts and while they do complete this error is presented:

Code: Select all

---------

myisamchk: error: 'nagios_servicestatus' is not a MyISAM-table

---------
Any silver bullets for this one?

Re: Services not visible after upgrade to XI 5.8.5

Posted: Tue Jul 20, 2021 11:33 am
by mcapra
NDO uses MyISAM for the storage engine. Looks like this table (and potentially others) got flipped to InnoDB, when it should be using MyISAM.

Code: Select all

ALTER TABLE my_table ENGINE = MyISAM;
Definitely don't alter the database tables while Nagios XI / NDOUtils is "doing stuff".
snapier3 wrote: The configured services are no longer visible in the NagiosXI Interface but, remain visible in CCM and Nagios Core.
Probably because the NDO database (all those nagios_* tables) is honked up.