Hosts/services stuck "Not applied"

[daq]

Very similar to https://support.nagios.com/forum/viewto ... =7&t=29833 but opening a new one since that thread is locked without any resolution that works.

After making changes to the CCM, changes apply successfully, but continue to display "Not applied" status in the CCM.

Already tried deleting config files and re-writing from DB.
Also tried restarting Nagios.
Time zone on the server is set to UTC. PHP correctly has PST timezone set up.

What else can we try?

Thanks.

[rkennedy]

Can you navigate to Admin -> System Settings -> from there, what do you have your Program URL, and External URL set to?

[daq]

Can you navigate to Admin -> System Settings -> from there, what do you have your Program URL, and External URL set to?

External was not set. I tried setting it to an external address, but nothing changed in the CCM. Still shows not applied.
I set both to the same value that resolves in our internal DNS server.

[hsmith]

Are you using SSL on this system?

[daq]

Are you using SSL on this system?

No.

[hsmith]

On your Admin page, can you please browse to System Status and let us know if all of those check marks are green?

[daq]

On your Admin page, can you please browse to System Status and let us know if all of those check marks are green?

Yes, everything is green.

[hsmith]

Did you change any database credentials?

[daq]

Did you change any database credentials?

Not since installation, but this problem existed since we originally installed Nagios.
We have 2 separate deployments both affected by this issue since Nagios was originally installed.

[ssax]

What version of XI are you using? You can grab it from the bottom left hand side of the web interface. Maybe there's a known bug, I've seen this in older versions.

The likely issue is that the DB timestamp for last_modified date/time is either not being updated or is wrong.

What is the output of this:
- Note: Change CONFIGNAME to a config name of the services that are experiencing the issue

Code: Select all

echo "SELECT DATE_FORMAT(last_modified, '%Y-%m-%d %H:%i:%s'), service_description FROM tbl_service WHERE config_name = 'CONFIGNAME' ORDER BY last_modified DESC LIMIT 1;" | mysql -pnagiosxi nagiosql