Nagios Support Forum

Posted: **Tue Feb 14, 2017 6:13 am**

Hello Support,

The hosts configured on my NagiosXI suddenly are not appearing and my console page is grayed out. I still get status notifications about them on my email though. Find attached a screen shot of the nagiosxi landing page with specific reference to the SQL error message being displayed:

SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus'[/b][/i][/b][/i][/u]

Posted: **Tue Feb 14, 2017 10:24 am**

You'll want to repair the database with the following script.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

If you persist to see the Incorrect file format error, then following the remaining instructions on this guide - https://assets.nagios.com/downloads/nag ... tabase.pdf - that mentions -

Code: Select all

If you receive an error, similar to this one:
Error : Incorrect file format 'nagios_systemcommands'
error : Corrupt
you will need to execute the following command to fix the table:

Posted: **Mon Feb 20, 2017 7:15 am**

Hello,

Thanks for the support, I was able to restore with an earlier backup and all was working fine. Thanks.

Posted: **Mon Feb 20, 2017 10:28 am**

I'll be closing this thread now, but feel free to open another if you need anything in the future!

Nagios Support Forum

All Host on NagiosXI disappeared_grayed out

All Host on NagiosXI disappeared_grayed out

Re: All Host on NagiosXI disappeared_grayed out

Re: All Host on NagiosXI disappeared_grayed out

Re: All Host on NagiosXI disappeared_grayed out