CCM Services not syncing if bulk editing database

[cscholz]

When setting services in CCM to Active = 0, then applying config, the config syncs just fine.

When setting active=0 in bulk on table tbl_services in database nagiosql, then applying configuration, it continually says Out of Sync for each service affected. I've also tried manually writing configs through the Tools menu, but it doesn't deactivate them.

Any ideas on what's going on? I am aware that this method is not officially supported.

Can I disable all services associated with entire hosts in an easier way, without deleting them?

[scottwilkerson]

What are you doing differently from this thread where it worked?
http://support.nagios.com/forum/viewtop ... f=6&t=5284

Also, it could be possible that you have a permissions error that is not allowing the writing of the cfg files
http://library.nagios.com/library/produ ... -nagios-xi

[cscholz]

Here is the exact sql that I'm running:

update tbl_service set active='0' where config_name like '%sw%';

I'm not doing anything different from the other thread where it worked correctly, which is why I'm so confused. I'll try the permissions trick.

Edit: Fixing permissions did not fix the issue.

[mguthrie]

Any interest in testing our new beta CCM which has this feature built in? It installs alongside the existing CCM.

[cscholz]

Any interest in testing our new beta CCM which has this feature built in? It installs alongside the existing CCM.

Absolutely.

[cscholz]

Any chance I can do this today? Is it ready for public beta yet?

[mguthrie]

Sure thing, sent you to the new component zip in a PM. Let me know if you have any issues with it. You should be able to select your list of configs, and then activate / deactive them from the dropdown menu at the bottom of the page.

[cscholz]

After using the beta CCM (very nice, by the way), I'm still having problems when updating these services. It works on some, but not all. See the screenshot attached to see where it gets stuck.

Any ideas why this is happening, or what logs I can look at to find out?

[mguthrie]

Do these items fail to sync up even after you Apply Configuration?

[cscholz]

Do these items fail to sync up even after you Apply Configuration?

Yes. I have used Apply configuration in both CCM->quick tools->Apply and CCM->Monitoring->services views. This is the same exact problem I had when trying to do it manually by editing the database.

Note that I returned the database to a clean state (from before I messed around with it) before attempting to use the CCM Beta, so I don't believe it would be due to corrupt data.