Host alerting, but not in Nagios core or the CCM

[MrWoodward]

It appears that one of the hosts in our Nagios XI system is in a weird state such that it is alerting, but is not in the CCM or in Nagios Core.

How do we remove this entry from Nagios XI?

I tried running the "repair_database.sh" script, but that didn't fix the problem.

[npolovenko]

Hello, @MrWoodward. Are you seeing this service on the Nagios XI home page under the Service Status dashboard? Please try this repair mysql command instead:

mysqlcheck -r -f -uroot -pnagiosxi --all-databases --use_frm

Also, please run these commands if you are on CentOS/RHEL 6.X:

service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart
service ndo2db start
service nagios start
service npcd start
service crond start

Run these commands if you are on CentOS/RHEL 7.X:

systemctl stop crond
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
systemctl restart mariadb
systemctl start ndo2db
systemctl start nagios
systemctl start npcd
systemctl start crond

Let me know if this fixes your problem.

[MrWoodward]

Ran the scripts and Everything appears normal again!

Thanks so much for the support!

[scottwilkerson]

Ran the scripts and Everything appears normal again!

Thanks so much for the support!

excellent!

Locking thread