all host pending

[scottwilkerson]

You may need to restart the nagios service

Code: Select all

service nagios restart

Has this ever worked since you offloaded the database?

[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.

[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

[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.

[kyang]

can you run Apply Configuration?

Did you try this? Does it apply successfully? Or what errors?

[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

[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

[sangmin]

There is no problem with nagios conifg

1.PNG

[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

[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