CCM hosts status issue

[operations]

When using CCM to make changes to hosts, the status changes to "Not Applied", and the "Changes Detected Apply Configuration" message doesn't go away, even after applying the new config successfully. I have used the Write Config Files tool, upgraded to 2014R2.0 and restarted the server. Viewing the hosts in the Host Detail view shows them all as being Up. Any ideas is appreciated....

nagiosxi-hosts.JPG

[abrist]

Check your system date vs mysql and then restart mysql. If ntp altered the date/time after sql started, you may see this issue:

Code: Select all

date
echo "NOW()" | mysql -pnagiosxi
ntpdate pool.ntp.org
service mysqld restart

[operations]

thanks for the quick update. However, running echo "NOW()" | mysql -pnagiosxi results in an error:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOW()' at line 1

[Box293]

Please try these commands and post all the output:

Code: Select all

date
echo "select now()" | mysql -pnagiosxi
ntpdate pool.ntp.org
service mysqld restart
tail -n 20 /var/log/mysqld.log

[operations]

date and select NOW() are only out by approx 9 seconds.
the results of tail -n 20 /var/log/mysqld.log is

Code: Select all

141113 18:51:45  InnoDB: Completed initialization of buffer pool
141113 18:51:45  InnoDB: Started; log sequence number 0 44233
141113 18:51:45 [Note] Event Scheduler: Loaded 0 events
141113 18:51:45 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
141114 14:50:02 [Note] /usr/libexec/mysqld: Normal shutdown

141114 14:50:02 [Note] Event Scheduler: Purging the queue. 0 events
141114 14:50:04  InnoDB: Starting shutdown...
141114 14:50:07  InnoDB: Shutdown completed; log sequence number 0 44233
141114 14:50:07 [Note] /usr/libexec/mysqld: Shutdown complete

141114 14:50:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141114 14:50:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141114 14:50:07  InnoDB: Initializing buffer pool, size = 8.0M
141114 14:50:07  InnoDB: Completed initialization of buffer pool
141114 14:50:08  InnoDB: Started; log sequence number 0 44233
141114 14:50:08 [Note] Event Scheduler: Loaded 0 events
141114 14:50:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

After waiting a number of hours it appeared the hosts issue had resolved itself (orininally the time was out by about 15 minutes) but now I'm seeing the same thing happen under both hosts and services. Any modification or addition of a host or service stays as 'Not Applied'

[abrist]

Is your db crashed?

Code: Select all

tail -25 /var/log/mysqld.log

You can try deleting all the configs and rewriting them out:
G to --> Configure --> CCM --> Write config files --> Click "delete" and then "write" and the "verify". If all is well, try to "apply configuration" and then check the ccm lists for "not applied".

[operations]

results of tail -25 /var/log/myslqd.log:

Code: Select all

141113 18:51:44 [Note] /usr/libexec/mysqld: Shutdown complete

141113 18:51:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141113 18:51:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141113 18:51:45  InnoDB: Initializing buffer pool, size = 8.0M
141113 18:51:45  InnoDB: Completed initialization of buffer pool
141113 18:51:45  InnoDB: Started; log sequence number 0 44233
141113 18:51:45 [Note] Event Scheduler: Loaded 0 events
141113 18:51:45 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
141114 14:50:02 [Note] /usr/libexec/mysqld: Normal shutdown

141114 14:50:02 [Note] Event Scheduler: Purging the queue. 0 events
141114 14:50:04  InnoDB: Starting shutdown...
141114 14:50:07  InnoDB: Shutdown completed; log sequence number 0 44233
141114 14:50:07 [Note] /usr/libexec/mysqld: Shutdown complete

141114 14:50:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141114 14:50:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141114 14:50:07  InnoDB: Initializing buffer pool, size = 8.0M
141114 14:50:07  InnoDB: Completed initialization of buffer pool
141114 14:50:08  InnoDB: Started; log sequence number 0 44233
141114 14:50:08 [Note] Event Scheduler: Loaded 0 events
141114 14:50:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

I have tried deleting and rewriting the configs multiple times...

[Box293]

I suggest we move this to a support ticket (assuming you have a valid support contract).

Please email [email protected] along with sending us your system profile:

Click the Admin menu
System Config > System Profile
Click the Download Profile button and send us that file