Nagios Support Forum

Posted: **Tue Nov 25, 2014 3:11 pm**

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?

Posted: **Tue Nov 25, 2014 5:22 pm**

Try:

Code: Select all

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

Posted: **Wed Nov 26, 2014 9:32 am**

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.

Posted: **Wed Nov 26, 2014 11:56 am**

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

Nagios Support Forum

Nagios SQL Error [ndoutils]

Nagios SQL Error [ndoutils]

Re: Nagios SQL Error [ndoutils]

Re: Nagios SQL Error [ndoutils]

Re: Nagios SQL Error [ndoutils]