NagiosXI dosn't show any Service or host

[rishikesh.singh]

Hi We had some space Issue on server, After clearing all the space we tried ti Repair DB and also tried to restoreXI

But Now we are not able to get any service or host on portal although when we try to repair The DB we get some alerts, dont know How as The notification were disabled before the Crash

Getting below on the portal while trying Look for any service

SQL: SQL Error [ndoutils] : Table 'nagios.nagios_programstatus' doesn't exist SQL: SQL Error [ndoutils] : Table 'nagios.nagios_programstatus' doesn't exist SQL: SQL Error [ndoutils] : Table 'nagios.nagios_programstatus' doesn't exist SQL: SQL Error [ndoutils] : Table 'nagios.nagios_programstatus' doesn't exist SQL: SQL Error [ndoutils] : Table 'nagios.nagios_programstatus' doesn't exist SQL: SQL Error [ndoutils] : Table 'nagios.nagios_programstatus' doesn't exist

[abrist]

After clearing all the space we tried ti Repair DB and also tried to restoreXI

Did you run into space issues during the restore? If the database tables even exist, I bet they are seriously corrupt. What is the output of:

Code: Select all

ls -la /var/lib/mysql/nagios

And:

Code: Select all

tail -10 /var/log/mysqld.log

Do you have less recent backups?