No Hosts, No Services, notification disabled

[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,

[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?