Page 1 of 2
Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 10:20 am
by JohnFLi
I am trying to remove a Host from Nagios as it no longer exists.
When trying to remove teh service check for Ping, it says it can't becasue it has a service Escalation tied to it.
I go to the Service escalation that it named.....I don't see it in the 'included' side. I see it on the left side of the two columns.
I added it....applied config.....removed it...applied config.
THen when I try to remove the ping check fo that host.....it still says there is a service escalation tied to it.....
ANy ideas?
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 11:30 am
by jdalrymple
Is it possible you have something lurking in the static or import directory that is causing you grief?
If not, click the disk icon next to the escalation and let us take a look at the text config.
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 11:37 am
by JohnFLi
Everything was entered manually, so it wouldn't be stuck in an import.
I looked at the text version....it isn't in there.
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 2:56 pm
by tgriep
Can you click on the blue circle with the letter i next to the service to get a list of relationships for that service and post that here?
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 3:30 pm
by JohnFLi
yes, I go there and it shows me
Relation to Serviceescalations, entry: Service Ping Escalation - Dependent relationship
so I go to that location, and the host is not listed in there.
I added it, applied I removed it, applied
still same outcome
When I do that for the service escalation I see
Relation to Hosts, entry: G1PPTSS06
Relation to Hosts, entry: G1PPTSS07
Relation to Hosts, entry: G1VPTSS04
Relation to Services, entry: BearCam-Ping
it is the BearCam is what I'm trying to get rid of. I can't find out how to do that.
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 4:05 pm
by tgriep
If you go to the BearCam-Ping service in Core Config Manager, click on hosts, is it there?
If not, can you post all of the configs so we can review them?
Can you run this to rule out a database corruption? Please post the output.
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 4:16 pm
by JohnFLi
In Services, I do a search for Bear, and it comes up with the ping service check for that host. As I would expect.
tail -50 /var/log/mysqld.log
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [Note] /usr/libexec/mysqld: Normal shutdown
150731 14:15:03 [Note] Event Scheduler: Purging the queue. 0 events
150731 14:15:05 InnoDB: Starting shutdown...
150731 14:15:09 InnoDB: Shutdown completed; log sequence number 0 44233
150731 14:15:09 [Note] /usr/libexec/mysqld: Shutdown complete
150731 14:15:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150731 14:15:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150731 14:15:17 InnoDB: Initializing buffer pool, size = 8.0M
150731 14:15:17 InnoDB: Completed initialization of buffer pool
150731 14:15:17 InnoDB: Started; log sequence number 0 44233
150731 14:15:17 [Note] Event Scheduler: Loaded 0 events
150731 14:15:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 4:29 pm
by JohnFLi
I followed the direction from
https://deangrant.wordpress.com/tag/nagios/
Nagios XI: Host and Service details not being displayed
June 7, 2014Dean GrantLeave a comment
Recently, I was troubleshooting an issue with Nagios XI where host and service details where not being displayed from the web management console.
On investigating the log file at ‘/var/log/messages’ there was a number of errors identifying that a table in the MySQL database was crashed and was required to be repaired.
ndo2db: mysql_error: 'Table './nagios/nagios_timedeventqueue' is marked as crashed and should be repaired'
In order to repair the table marked as crashed, I ran the below on the Nagios XI monitoring server , reconnected to the web management console and both host and service details were displayed as expected.
myisamchk --safe-recover /var/lib/mysql/*/*.MYI
And now it only reads as errors
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 4:30 pm
by tgriep
If the host is in that service check, delete it and apply the config.
Re: Cannot find Host in service escalation
Posted: Thu Aug 27, 2015 4:38 pm
by JohnFLi
That's what I have been trying to do.