Services not visible after upgrade to XI 5.8.5

[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

NagiosXI CCM Services

Known Services

Nagios Core

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?

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

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.