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
