Nagios XI R5 - Determine Unapplied Changes Pending

[mp4783]

In past Nagios XI releases you could determine if there were changes pending by querying the PostgreSQL database.

Now that the PostgreSQL database has been dropped (thank you!), how do we determine if unapplied changes are pending?

Thank you.

[Box293]

I will get the developers to get back to you with an answer on this.

[mp4783]

I think I found the answer (and it would have been obvious if I'd just looked):

MySQL Query:

Code: Select all

SELECT value FROM nagiosxi.xi_options WHERE name = 'ccm_apply_config_needed';

If the value is '0', then no changes are pending. If it is '1', there are pending changes. I tested this and it appears to be the case.

Confirmation would be nice, but this correct.

[hsmith]

The answer that I got from the developers is that your query would only show whether or not an apply config is needed. If you needed to figure out exactly 'what' needed an apply config you would need to check file timestamps and last_modified in nagiosql.

[mp4783]

That's all I was concerned with at this point. I have external configuration management tool that I want to "wait" until all changes have been applied before it attempts to execute it's changes. I use this in conjunction with the reconfiguration lock file to ensure only one set of changes are applied at a time to the system.

[hsmith]

That's all I was concerned with at this point.

Does that mean we are all right to consider this one resolved?