Page 1 of 3
Host details is not working for particular host
Posted: Tue May 12, 2015 9:04 pm
by 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.
Re: Host details is not working for particular host
Posted: Wed May 13, 2015 2:11 am
by 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
Re: Host details is not working for particular host
Posted: Thu May 14, 2015 12:51 am
by 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
Re: Host details is not working for particular host
Posted: Thu May 14, 2015 10:10 am
by 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?
Re: Host details is not working for particular host
Posted: Thu May 21, 2015 12:47 am
by phyo
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
[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.
Re: Host details is not working for particular host
Posted: Thu May 21, 2015 9:19 am
by 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
Re: Host details is not working for particular host
Posted: Mon May 25, 2015 8:38 pm
by phyo
tgriep wrote: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.
Re: Host details is not working for particular host
Posted: Mon May 25, 2015 8:48 pm
by Box293
Can you answer this:
tgriep wrote: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
Re: Host details is not working for particular host
Posted: Tue May 26, 2015 1:05 pm
by phyo
Box293 wrote:Can you answer this:
tgriep wrote: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.
Re: Host details is not working for particular host
Posted: Tue May 26, 2015 1:45 pm
by 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.