Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
snapier3
Posts: 62 Joined: Tue Apr 23, 2019 7:12 pm
Post
by snapier3 » Tue Jul 20, 2021 11:04 am
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
Posts: 3739 Joined: Thu May 05, 2016 3:54 pm
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.
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.