Host Detail no longer working

[scott.steves]

I'll preface this by saying I'm still very new to Nagios, so I may just be overlooking something.

We just had an extended maintenance period that required all VM's to be shutdown. When I brought Nagios back online I saw I had some database issues that required a repair. After using "http://assets.nagios.com/downloads/nagi ... tabase.pdf" to repair the database, I found that when I click the "Host Detail" link, it just sits and spins. I can go to all the other host links and they work just fine. It's specifically the host detail link.

Is there something else I need to repair maybe?

Thanks!

-Scott

[slansing]

Is this happening at all times? Can you run the following and share the output:

Code: Select all

tail -f /var/log/httpd/error_log

Then, try clicking on the Host Detail link. Give it about 10 seconds and send us the output that was placed in your terminal from the tail.

Also share:

Code: Select all

tail -30 /var/log/mysqld.log

Please

Have you tried running another repair?

[scott.steves]

Thanks for the reply

Yes, the problem happens for every attempt.

Output from error_log and mysqld.log are attached.

The second repair had no effect on the Host Detail page.

error_log.txt

mysqld.log

[lmiltchev]

Can you see hosts fine in Nagios Core?

[url]http://<nagios_server_IP>/nagios/cgi-bin/status.cgi?hostgroup=all&style=hostdetail[/url]

[scott.steves]

Yes, that came up just fine.

OK so after opening the Nagios core host page, it seems that the Host Detail page is working again. I'm not sure why, but I'll take the fix.

Thank you all for the help!


Scott

[abrist]

Could you post the output of:

Code: Select all

grep "latency\|execution" /etc/php.ini

You have a number of errors pertaining to php execution time and latency.

[scott.steves]

It's showing max_execution_time = 30 (Also comments)

[abrist]

Yes, that came up just fine.

OK so after opening the Nagios core host page, it seems that the Host Detail page is working again. I'm not sure why, but I'll take the fix.

Thank you all for the help!


Scott

Glad you got it working. Locking 'er up.

[lmiltchev]

Run the following commands in the exact order:

Code: Select all

service nagios stop
killall -9 nagios
service ndo2db stop
service nagios start
service ndo2db start

then clicked on the Host Detail from the Nagios XI web interface, and let us know if you can view hosts.