Page 1 of 1

SQL Error [ndoutils] : Incorrect file format 'nagios_service

Posted: Thu Oct 04, 2018 9:25 am
by 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.

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_ser

Posted: Thu Oct 04, 2018 9:52 am
by 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