Hello Ton I get Version 0.08012.
A "dpkg -p opsview-perl" shows me Version 3.7.0.318-1lenny1 Bye Michael opsview-users-boun...@lists.opsview.org schrieb am 27.05.2010 16:20:11: > Von: > > Ton Voon <ton.v...@opsera.com> > > An: > > Opsview Users <opsview-users@lists.opsview.org> > > Datum: > > 27.05.2010 16:21 > > Betreff: > > Re: [opsview-users] Antwort: Re: Problem edit/create contact > > Gesendet von: > > opsview-users-boun...@lists.opsview.org > > On 27 May 2010, at 15:03, Michael Stecker wrote: > The system was upgraded from 3.6 to 3.7 and works without problems. > Yesterday I moved a User to our Admin group in Active directory and > tried to resync with "opsview-sync-ldap -y". But I only got the > following error for all our Users: > > Error synchronising m.stecker: DBIx::Class::ResultSet::delete(): DBI > Exception: DBD::mysql::st execute failed: Unknown column 'contactid' > in 'where clause' [for Statement "DELETE FROM > notificationprofile_hostgroups WHERE ( ( hostgroupid NOT IN ( ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ? ) AND contactid = ? ) )" with ParamValues: > 0='149', 1='96', 2='147', 3='127', 4='141', 5='122', 6='121', > 7='156', 8='58', 9='157', 10='68', 11='90', 12='94', 13='19', > 14='148', 15='98', 16='130', 17='159', 18='139', 19='67', 20='89', > 21='124', 22='125', 23='108', 24='111', 25='91', 26='31', 27='71', > 28='65', 29='95', 30='129', 31='20', 32='123', 33='103', 34='76', > 35='126', 36='77', 37='33', 38='138', 39='99', 40='118', 41='112', > 42='114', 43='155', 44='5', 45='116', 46='153', 47='158', 48='151', > 49='78', 50='113', 51='154', 52='115', 53='22', 54='117', 55='56', > 56='133', 57='100', 58='41', 59='120', 60='142', 61='64', 62='93', > 63='8', 64='69', 65='29', 66='81', 67='131', 68='74', 69='79', > 70='101', 71='36', 72='62', 73='24', 74='135', 75='92', 76='160', > 77='140', 78='72', 79='1002'] at /usr/drbdfs/usr/local/nagios/ > bin/../lib/Opsview/ResultSet/Contacts.pm line 103 > > > Then I tried to edit an user directly in Opsview, but no luck. I > always get the same error. Even creating new users or only changing > the password of an local user doesn't work. I only can delete users :-( > > I checked the table notificationprofile_hostgroups, too but my table > looks exactly like in Emilios post. > > In conclusion, I didn't change anything since the update to 3.7. > > Can you run this as the nagios user? > > perl -MDBIx::Class -e 'print DBIx::Class->VERSION,$/' > > I get 0.08120. What version do you get? If it is lower, what is the > package version for opsview-perl? > > Ton > _______________________________________________ > Opsview-users mailing list > Opsview-users@lists.opsview.org > http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users
