Services not visible after upgrade to xi 5.8.5

snapier3 · Post by **snapier3** » Tue Jul 20, 2021 11:04 am

After upgrade to Nagiosxi xi 5.8.5 using the upgrade script

"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.

services_missing.PNG

Nagiosxi CCM Services

services_configured.PNG

Nagios Core

core_asExpected.PNG

I have tried to run repair scripts and while they do complete this error is presented:

---------

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

---------

Any silver bullets for this one?

Post by **mcapra** » Tue Jul 20, 2021 11:33 am

NDO uses MyISAM for the storage engine. Looks like this table (and potentially others) got flipped to InnoDB, when it should be using MyISAM.

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.

Nagios Support Forum