Just a short note to say thanks for getting the Contact View Rights issues figured out. I was bit by it long ago I think under Opsview 2.x but I thought the issue went away with Opsview 3.x.
I'm guessing now during the 2.x to 3.x upgrade the table in question got cleared out so it seemed like the issue was solved. Just this morning I was testing out some accounts in opsview and was a bit shocked at what those accounts could suddenly see. I thought I remembered seeing this discussion recently so I was glad to see there was a short term fix. Hopefully that next version of Opsview will include the fix and will be coming out soon so I don't have to worry about periodically clearing the nagios_service_contactgroups table. Anyway thanks again for indentifying the issue, I hope these simple instructions made it out to a FAQ somewhere.. James Whittington VC3, Inc. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Duncan Ferguson Sent: Tuesday, April 21, 2009 11:38 AM To: Opsview Users Subject: Re: [opsview-users] BIG ISSUE / BUG in Opsview: Contact viewrightsbroken !!! Unable to repair. Thanks to Mr Ian Yates for testing this, we now have a fix for this bug. This is a bug in ndoutils not clearing out a runtime table on a reload. To fix this on your system (until we get the next version out with the fix included): $ mysqldump -u nagios -p -h localhost runtime | gzip -9 -c > /tmp/ db_runtime.sql.bk <enter password> $ mysql -u nagios -p -h localhost runtime <enter password> mysql> truncate table nagios_service_contactgroups; exit At this point you should be able to run a reload within the UI. The first step above takes a full backup of the runtime database - the backup file can be removed after the reload has completed successfully. Duncs -- Duncan Ferguson Senior Developer _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
