Page 1 of 1
monitoring and reporting stopped. ndoutils error on console
Posted: Tue Jun 27, 2017 2:03 pm
by albertaarts
Hi there. I'm hoping someone can help me out. Recently our Nagiox XI stopped reporting issues and the homepage of the web interface has the following message repeated many times over: SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL
Re: monitoring and reporting stopped. ndoutils error on cons
Posted: Tue Jun 27, 2017 2:20 pm
by dwhitfield
You need to run the following:
Code: Select all
service mysqld start
echo 'repair table nagios_programstatus use_frm;' | mysql -t -u root -pnagiosxi nagios
service mysqld restart
If that doesn't work, you may need to run the following
mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_programstatus'
You may get some other ideas by looking at
https://assets.nagios.com/downloads/nag ... tabase.pdf
Re: monitoring and reporting stopped. ndoutils error on cons
Posted: Tue Jun 27, 2017 6:38 pm
by albertaarts
thanks! that didn't work but that is all good information. i'll get more familiar with database backups and maintenance.
Re: monitoring and reporting stopped. ndoutils error on cons
Posted: Wed Jun 28, 2017 12:52 pm
by tgriep
There is a script on the Nagios server that you can use to repair all of the databases on the server.
To use it, login to the server as root and run the following
Code: Select all
cd /usr/local/nagiosxi/scripts
./repair_databases.sh
If it works, it should fix the invalid file format error for you.
Re: monitoring and reporting stopped. ndoutils error on cons
Posted: Thu Jun 29, 2017 7:06 pm
by albertaarts
thank you. it did not fix it but this is good to know.
Re: monitoring and reporting stopped. ndoutils error on cons
Posted: Thu Jun 29, 2017 9:37 pm
by tacolover101
look at
https://assets.nagios.com/downloads/nag ... tabase.pdf under the 'troubleshooting' section, the second example is the same issue you're facing, so this should help you resolve it.
Re: monitoring and reporting stopped. ndoutils error on cons
Posted: Fri Jun 30, 2017 9:47 am
by lmiltchev
albertaarts, did you follow the document, referenced by tacolover101? Did this help?