monitoring and reporting stopped. ndoutils error on console

[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

[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

[albertaarts]

thanks! that didn't work but that is all good information. i'll get more familiar with database backups and maintenance.

[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.

[albertaarts]

thank you. it did not fix it but this is good to know.

[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.

[lmiltchev]

albertaarts, did you follow the document, referenced by tacolover101? Did this help?