SQL Error [ndoutils] : Incorrect file format 'nagios_service

[amane]

Hi,
Getting below mentioned error on NagiosXI console.

Error: - SQL Error [ndoutils] : Incorrect file format 'nagios_servicestatus'

removed the .lock file .log file and restarted the ndo2db but same issue.

Tried to repair database with using '/usr/local/nagiosxi/scripts/repair_databases.sh' but issue not resolved.

Could you please check and let u sknow why this issue is coming and how we can resolve.

[scottwilkerson]

You can use the following command to fix this table

Code: Select all

echo 'repair table nagios_servicestatus use_frm;' | mysql -u root -pnagiosxi nagios

Then I would suggest restarting nagios

Code: Select all

service nagios restart