Nagios SQL Error [ndoutils]

[iamroot]

I logged onto Nagios XI today and I saw

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

As well as an issue where it says three of the tables are not tables when I try to repair them using

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios

I have uploaded a picture to clarify.

Does anyone know how to fix this?

[abrist]

Try:

Code: Select all

echo "use nagios;repair table nagios_servicestatus use_frm;" | mysql -pnagiosxi

[iamroot]

Ok, so I tried

Code: Select all

echo "use nagios;repair table nagios_servicestatus use_frm;" | mysql -pnagiosxi

and I got the response below, I am still seeing the SQL Error on other pages on the Nagios XI site.



I will also add that the log file created has the same error over and over and is making the file size a ridiculous size of almost 4GB.

[abrist]

Can you open a ticket by sending an email to [email protected]? I would like to escalate this to a remote session.