Nagios Support Forum

Hi

I am running Nagios XI 5.6.2 from VMWare on Windows 10 PC, currently only monitoring a single windows 10 PC as we finalise configurations.

The monitoring PC was subject to a power cycle and it now appears the Nagios DB is corrupt and the standard repair script fails.
error seen on Nagios is
SQL Error [ndoutils]: incorrect File format 'nagios_service_status'
the script does output 5 lines indicating a particular table is not a MyISAM-table, they are:
nagios_eventhandlers
nagios_logentries
nagios_notifications
nagios_servicestatus
nagios_systemcommands
full example:
myisamchk: error: 'nagios_eventhandlers' is not a MyISAM-table

NOTE that the warning text does not include .MYI as per nagios database repair guide which would have indicated they were of the wrong format and needed to be converted.

This instance of Nagios has been running for about 2 months, and was created using the 5.6.2 VM, it hasnt been updated except for a plugin.

Thanks for your help

Chris

Hi Chris,

Can you give me the output of this command?
The fact that 5 of the tables aren't reporting as MyISAM, and 2 critical databases are missing has me worried that there is actual lost data here.

Hi

output is as follows Thanks

Chris

Okay, the directories for those databases are there. That's good. We should check to make sure that the database files exist as well.
Let's also check to make sure that they've been imported into MySQL.