Page 2 of 3
Re: all host pending
Posted: Tue Oct 10, 2017 8:51 am
by scottwilkerson
You may need to restart the nagios service
Has this ever worked since you offloaded the database?
Re: all host pending
Posted: Tue Oct 10, 2017 10:51 pm
by sangmin
nagios is restarted when the repair_databases script finishes running.
The problem is the same even if you restart nagios.
I did not do anything to DB.
There is still only one host, and host information is marked as changing from time to time.
Re: all host pending
Posted: Wed Oct 11, 2017 9:34 am
by scottwilkerson
if you look at the CCM do you see all your hosts?
If so can you run Apply Configuration?
If not, my guess is that somehow the nagiosql database didn't get moved when you offloaded the DB and you would want to check all the steps in this doc
https://assets.nagios.com/downloads/nag ... Server.pdf
Re: all host pending
Posted: Wed Oct 11, 2017 8:24 pm
by sangmin
ccm shows all hosts.
I restart Nagios, restart the Nagios server and restart the DB, but the result is the same.
Also, I have not changed my settings for a year after setting offloading_MySQL.
And we use memcached.
(
https://assets.nagios.com/downloads/nag ... ios_XI.pdf)
I did not let you use memcached, but the result was the same.
Re: all host pending
Posted: Thu Oct 12, 2017 10:35 am
by kyang
can you run Apply Configuration?
Did you try this? Does it apply successfully? Or what errors?
Re: all host pending
Posted: Thu Oct 12, 2017 9:05 pm
by sangmin
Apply Configuration succeeded.
I have tried many things but still have problems.
Only one host is normal and all other hosts are pending.
And the hosts that come out normally change.
Service Status.png
Re: all host pending
Posted: Fri Oct 13, 2017 12:40 pm
by dwasswa
Hi
@sangmin,
Lets begin by trying to check you nagios configuration.
Please post the output pf this command:
Code: Select all
/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
Re: all host pending
Posted: Fri Oct 13, 2017 7:49 pm
by sangmin
There is no problem with nagios conifg
1.PNG
Re: all host pending
Posted: Mon Oct 16, 2017 11:16 am
by dwasswa
Hi [user]@sangmin[/user],
There might be a problem with your time.
Please run the following commands to check those settings
Code: Select all
date
hwclock
grep date.timezone /etc/php.ini
mysql -unagiosxi -pn@gweb -e "SELECT NOW();"
service ntpd status
Also, can you send a screenshot of
http://YOURSERVER/nagiosxi/admin/globalconfig.php
Re: all host pending
Posted: Mon Oct 16, 2017 11:38 pm
by sangmin
Hi,
Time seems to be no problem.
thanks
Tue Oct 17 13:32:26 KST 2017
Tue 17 Oct 2017 01:32:27 PM KST -0.828315 seconds
;
http://www.php.net/manual/en/datetime.c ... e.timezone
date.timezone = Asia/Seoul
NOW()
2017-10-17 13:32:27
ntpd (pid 3735) is running...
config.png