Notifications Disabled/No Services mapped to nodes

[kotterbein]

Having an issue here:

Nagios XI 2012R1.6, Redhat el5 server.

Checks are occuring, and notifications on are showing up under "Problems" but are not being mapped to any nodes. when I click to look at services under nodes, it shows "No Matching Services Found"- I'm not sure how long this problem has been occuring, but I did run "repairmysql.sh" to see if this would remedy the issue, but to no avail. I have rebooted a couple of times to try and see if there was an issue, but again, nothing comes back as a service linked to a node.

looking for more possiblilities

[kotterbein]

also notice that httpd is taking a HUGE amount of resources:

29410 apache 20 0 2428m 2.0g 13m R 99.5 8.6 1:05.07 httpd
4052 apache 15 0 1746m 1.4g 17m S 2.0 5.8 1:08.08 httpd
14835 apache 15 0 2406m 2.0g 14m S 2.0 8.5 1:27.52 httpd
4051 apache 15 0 1920m 1.5g 20m S 1.3 6.5 1:36.83 httpd
4056 apache 16 0 1920m 1.5g 17m S 1.3 6.5 1:52.48 httpd
4060 apache 15 0 1920m 1.5g 21m S 1.3 6.5 1:24.02 httpd
4053 apache 16 0 1920m 1.5g 20m S 1.0 6.5 1:23.10 httpd
4055 apache 15 0 2058m 1.7g 17m S 0.7 7.1 1:33.62 httpd

[scottwilkerson]

please run

Code: Select all

tail /var/log/mysqld.log

and report the output

[kotterbein]

reboot (3rd time) worked after running the mysql repair again.

sorry for the inconvenience- just an fyi, the output you requested:

Code: Select all

130322  9:38:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed
130322  9:38:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed
130322  9:38:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed
130322  9:38:20 [Note] /usr/libexec/mysqld: Normal shutdown

130322  9:38:22  InnoDB: Starting shutdown...
130322  9:38:23  InnoDB: Shutdown completed; log sequence number 0 43655
130322  9:38:23 [Note] /usr/libexec/mysqld: Shutdown complete

130322 09:38:23  mysqld ended

130322 09:44:13  mysqld started
130322  9:44:13  InnoDB: Started; log sequence number 0 43655
130322  9:44:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
130322 10:09:40 [Note] /usr/libexec/mysqld: Normal shutdown

130322 10:09:40  InnoDB: Starting shutdown...
130322 10:09:41  InnoDB: Shutdown completed; log sequence number 0 43655
130322 10:09:41 [Note] /usr/libexec/mysqld: Shutdown complete

130322 10:09:41  mysqld ended

130322 10:13:20  mysqld started
130322 10:13:20  InnoDB: Started; log sequence number 0 43655
130322 10:13:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

[nscott]

Just to be overtly clear (you may have already read it), but the detailed documentation on this is here:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Please make sure you're following the details exactly. If that fails, you may need to do the repairs manually, which is outlined in this part of the doc:

Code: Select all

service mysqld stop
cd /var/lib/mysql/nagios
myisamchk -r -f nagios_notifications
service mysqld start
rm -f /usr/local/nagiosxi/var/dbmaint.lock
/usr/local/nagiosxi/cron/dbmaint.php

Where I have filled in the table that is marked as corrupted as indicated by your log entries.

[kotterbein]

Thank you Nicholas- you can mark this as resolved!

K