Hello Ton
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.
Thanks
Michael
_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users
