Host details is not working for particular host

[phyo]

Hi,

I am using Nagios XI 2014R1.0 with RHEL 6.6 64bit. And we have to Nagios server as Active/Standby. On Server1 with Xi, the particular host, i can't open and see Host status detail. But I can open and see at Core. At second server, everything is fine.

XI:


Core:


Let me know how can i fix this issue.
PS. I can't update to latest version of Nagios XI because of maintenance license.

Thanks.

[Box293]

Under Admin > System Config > Manage System Config is the address in Program URL correct?

Are you using a proxy server? If so have you configured XI to allow for this?

http://support.nagios.com/wiki/index.ph ... th_Proxies

Also, after accessing the XI page that is blank, can you please run this command and post the output in a code block:

Code: Select all

tail /var/log/httpd/error_log -n 100

[phyo]

Currently I have monitored 45 hosts. Other 44 hosts are ok. I can see host status details for other 44 hosts. This host only i can't see the host status details.
I have attached the file of the output of the below command.

tail /var/log/httpd/error_log -n 100

[lmiltchev]

I can see bunch of timezone issues in the error log. I don't think that this is causing the issue, but I would recommend that you fix this first. This will clear most of these errors.

https://assets.nagios.com/downloads/nag ... m_Time.pdf

Have you tried stopping/starting services?

Code: Select all

service mysqd restart
service nagios stop
killall nagios
service ndo2db stop
service ndo2db start
service nagios start

Do you have any errors in the mysqld.log?

Code: Select all

tail -20 /var/log/mysqld.log

[phyo]

I can see bunch of timezone issues in the error log. I don't think that this is causing the issue, but I would recommend that you fix this first. This will clear most of these errors.
https://assets.nagios.com/downloads/nag ... m_Time.pdf

I already change all of the time zone setting according to Changing_The_XI_System_Time.pdf

Have you tried stopping/starting services?

Code: Select all

service mysqd restart
service nagios stop
killall nagios
service ndo2db stop
service ndo2db start
service nagios start

I haven't try the following command.

Code: Select all

service nagios stop
killall nagios
service ndo2db stop
service ndo2db start
service nagios start

Because now this server is live and the operator is watching the status. Later we will arrange to run those commands.

Do you have any errors in the mysqld.log?

Code: Select all

tail -20 /var/log/mysqld.log

Code: Select all

[root@nagios01 httpd]# tail -20 /var/log/mysqld.log
150520 16:19:53 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1325' LIMIT 1
150520 16:20:04 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1326' LIMIT 1
150520 16:20:15 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1327' LIMIT 1
150520 16:20:24 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1328' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1570' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1571' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1642' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1641' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1556' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1557' LIMIT 1
150520 17:23:55 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1650' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1649' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1598' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1599' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1618' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1617' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1584' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1585' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1620' LIMIT 1
150520 17:23:56 [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM `tbl_service` WHERE `id`='1619' LIMIT 1
[root@nagios01 httpd]#

So far, i can't see the host details status for this host.

[tgriep]

Lets try and repair the mysql database. Run the following to do that.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh

Let us know if this fixes it for you.

Edit.
Are you using a database replication? If you do, you may want to turn it off for a while to see if the problem will go away. FYI, we don't support MYSQL replication for Nagios XI.
lmiltchev

[phyo]

Lets try and repair the mysql database. Run the following to do that.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh

Let us know if this fixes it for you.

Still the same.

[Box293]

Can you answer this:

Are you using a database replication? If you do, you may want to turn it off for a while to see if the problem will go away. FYI, we don't support MYSQL replication for Nagios XI.
lmiltchev

[phyo]

Can you answer this:

Are you using a database replication? If you do, you may want to turn it off for a while to see if the problem will go away. FYI, we don't support MYSQL replication for Nagios XI.
lmiltchev

Previously we used. Now totally disable the replication.

[tgriep]

Try going in to Core Config Manager and editing the host you cannot see in XI. Change the description, save it and apply the configuration to see if that updates the view.