Page 1 of 1

No Hosts, No Services, notification disabled

Posted: Mon Mar 16, 2015 2:36 am
by botswanamtc
Morning,

I have a problem with NagiosXI, I schedulled a downtime for the weekend as we had a power maintenance over the weekend. Now I have the following problems.....all hosts (1000+) have notifications diabled. I cannot access services for a single host by clicking on service detail for any host.

the system shows no hosts and no services under System Profile.

Kindly help.

Regards,

Re: No Hosts, No Services, notification disabled

Posted: Mon Mar 16, 2015 9:54 am
by lmiltchev
the system shows no hosts and no services under System Profile.
Check the mysqld.log for errors/crashed tables:

Code: Select all

tail -50 /var/log/mysqld.log
Run the database repair script if you need to:

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh
Stop/start services:

Code: Select all

service nagios stop
service ndo2db stop
service ndo2db start
service nagios start
service mysqld restart
Check the number of hosts/services from the CLI:

Code: Select all

echo 'select count(*) from nagios.nagios_hosts;' | mysql -t -pnagiosxi
echo 'select count(*) from nagios.nagios_services;' | mysql -t -pnagiosxi
Are you getting the correct numbers?