I just did a an update monitored_by='3' where hostgroup='5', and regened the config, all appears to be well, aside from what I believe to be an unrelated issue or two, which I'll post with a different Subject:...
Thanks! Ryan > -----Original Message----- > From: [email protected] [mailto:opsview-users- > [email protected]] On Behalf Of Rafael Carneiro > Sent: Tuesday, February 02, 2010 8:12 AM > To: Opsview Users > Subject: Re: [opsview-users] move hosts to slave > > Changing only the monitored_by column does work, I've done it many > times - no connectivity to that slave, so in order reload Opsview I > would sleep the hostgroup, move all slaves to my master and then > reload. > But James does have a point there, and that's the right way of doing > it. > > Rafael > > > > On Mon, Feb 1, 2010 at 3:41 PM, James Whittington > <[email protected]> wrote: > > > You might also have to set the uncommitted column to 1 for each > host in question so Opsview will know the config has changed. > > I'm not sure if Opsview selectively build's configs based on the > uncommitted column but it must be there for a reason. > > > > Anytime I've done mass changes to hosts at the database level > I've done it but can't remember if it is required? > > > > If you are just moving all hosts to a monitoring server it should > be pretty easy, otherwise you will have to match on a pattern or > patterns as Rafael suggested.. > > > > James Whittington > > VC3, Inc. > > > > From: [email protected] [mailto:opsview- > [email protected]] On Behalf Of Rafael Carneiro > Sent: Monday, February 01, 2010 2:51 PM > To: Opsview Users > Subject: Re: [opsview-users] move hosts to slave > > > > If your hostnames have a pattern, this may help: > UPDATE opsview.hosts SET monitored_by = 6 WHERE name LIKE 'PHX%' > (don't forget to replace 6 with the id for your slave) > > This is not supported/recommended, so make sure that you either > know what you're doing or backup your opsview DB before doing this. > > Rafael > > > > On Mon, Feb 1, 2010 at 2:35 PM, Ryan Goldberg > <[email protected]> wrote: > > Just wondering if there's anything more I need to do aside from > updating the "monitored_by" in the "hosts" table to the correct value > in order to move them around. I have to update about 1000 hosts, and > doing it by hand, hmm, painful... > > Ryan > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users > > > > > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users > > > _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
