Page 1 of 1

NagiosXI dosn't show any Service or host

Posted: Tue Mar 03, 2015 10:33 am
by 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

Re: NagiosXI dosn't show any Service or host

Posted: Tue Mar 03, 2015 11:46 am
by abrist
rishikesh.singh wrote: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?