Page 1 of 1
Nagios XI R5 - Determine Unapplied Changes Pending
Posted: Tue Oct 13, 2015 4:03 pm
by 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.
Re: Nagios XI R5 - Determine Unapplied Changes Pending
Posted: Tue Oct 13, 2015 5:15 pm
by Box293
I will get the developers to get back to you with an answer on this.
Re: Nagios XI R5 - Determine Unapplied Changes Pending
Posted: Wed Oct 14, 2015 8:28 am
by 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.
Re: Nagios XI R5 - Determine Unapplied Changes Pending
Posted: Wed Oct 14, 2015 10:30 am
by 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.
Re: Nagios XI R5 - Determine Unapplied Changes Pending
Posted: Fri Oct 16, 2015 7:51 am
by 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.
Re: Nagios XI R5 - Determine Unapplied Changes Pending
Posted: Fri Oct 16, 2015 9:15 am
by hsmith
mp4783 wrote:That's all I was concerned with at this point.
Does that mean we are all right to consider this one resolved?