0000692: Disappearing events and edit failures when UIDFieldName != login name (bindFields) - SOGo | BTS

ID	Project	Category	View Status	Date Submitted	Last Update

0000692	SOGo	Web Calendar	public	2010-07-20 12:25	2012-04-10 08:11

Reporter	gienger	Assigned To
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.2.2

Summary	0000692: Disappearing events and edit failures when UIDFieldName != login name (bindFields)
Description	First, the LDAP config in my .GNUStepdefaults: `SOGoUserSources = ( { CNFieldName = cn; IDFieldName = calendaringFirstLastNameForm; UIDFieldName = uid; baseDN = "ou=users,o=Universitaet Konstanz,c=DE"; bindFields = ( uid, calendaringFirstLastNameForm ); canAuthenticate = YES; displayName = "Benutzerliste Universit\U00E4t Konstanz"; hostname = "our.ldap.server"; id = unikn_users; isAddressBook = YES; port = 389; } );` "calendaringFirstLastNameForm" is a special attribute used here to have alternative login names - e.g. instead of typing my cryptic uid I can logon with "pascal.gienger" - so "calendaringFirstLastNameForm" is in bindFields. Postgres Tables are created with my cryptic uid - that is correct. As our mail server also uses these uids, folder sharing works, too. The problem arises when it comes to the web calendar. To reproduce: Create a new calendar, e.g. "Test". Create an event in "Test". Save it. Reopen the created event. The "Calendar" tab will show "Personal" - and not "Test". Save the event again. The event will be in the personal calendar now. Reopen the event. Save it again. The event disappears. In the postgres tables I am still seeing the event in long form but it disappeared in the..._quick-Table. So it will never show up again in the calendar. The problem just disappears when I am using my cryptic uid "uid" to log in into the web interface. is it using the login id the user typed in at login somewhere in the code where it should be using UIDFieldName (uid) from LDAP?
Additional Information	Attachment: A PNG picture showing: new event created in "test" (red color) - the balloon help just does it right the reopened event with the pull down menu stating "Agenda personnel" (personal calendar). After clicking "Enregistrer et fermer" (Save and Exit) it will move the event to the personal calendar. Another save will destroy it in the index (_quick - table).
Tags	No tags attached.

2010-07-20 12:25	sogo-calendar-bug-gienger.png (59,754 bytes) sogo-calendar-bug-gienger.png (59,754 bytes)

2010-07-20 13:39	postgres-sogo-log-gienger.txt (23,873 bytes) 1. First, create an event with (e.g.) Apple iCal and store it in Calendar "Test" "Test" is "sogopg3820180013687ac98{_quick,_acl}". For reference: My personal calendar is "sogopg3820180011785c1ee{_quick,_acl}". my normal login id for the web frontend is "pascal.gienger", my UIDField (uid) is "pg382018". BEGIN TRANSACTION INSERT INTO sogopg3820180013687ac98_quick (c_partstates, c_orgmail, c_uid, c_sequence, c_nextalarm, c_title, c_classification, c_location, c_name, c_component, c_iscycle, c_enddate, c_priority, c_status, c_isopaque, c_startdate, c_isallday) VALUES ('', '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097', 2, 0, 'Test dans calendrier Test', 0, '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 'vevent', 0, 1279785600, 0, 1, 1, 1279782000, 0) INSERT INTO sogopg3820180013687ac98 (c_creationdate, c_lastmodified, c_name, c_version, c_content) VALUES (1279631349, 1279631349, 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 0, 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 END:VEVENT END:VCALENDAR ') COMMIT TRANSACTION 2. Open in Web Calendar, login with "pascal.gienger": (remark the use of "pg382018" which is "UIDField", correct!) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' 3. Drop Down Menu is on "Personal Calendar" (which is already an error) and now hitting Save: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279631637, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 1, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131357Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279631637, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 2, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131357Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION INSERT INTO sogopg3820180011785c1ee_quick (c_partstates, c_orgmail, c_uid, c_sequence, c_nextalarm, c_title, c_classification, c_location, c_name, c_component, c_iscycle, c_enddate, c_priority, c_status, c_isopaque, c_startdate, c_isallday) VALUES ('', '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097', 2, 0, 'Test dans calendrier Test', 0, '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 'vevent', 0, 1279785600, 0, 1, 1, 1279782000, 0) INSERT INTO sogopg3820180011785c1ee (c_creationdate, c_lastmodified, c_name, c_version, c_content) VALUES (1279631637, 1279631637, 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 0, 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131357Z END:VEVENT END:VCALENDAR') COMMIT TRANSACTION COMMIT TRANSACTION BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98 SET c_deleted = 1, c_lastmodified = 1279631637 WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' DELETE FROM sogopg3820180013687ac98_quick WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION 4. Reopen the event: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180011785c1ee_quick a, sogopg3820180011785c1ee b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180011785c1ee_quick a, sogopg3820180011785c1ee b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' 5. Save it again: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180011785c1ee_quick a, sogopg3820180011785c1ee b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180011785c1ee SET c_lastmodified = 1279631977, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 1, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131937Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180011785c1ee SET c_lastmodified = 1279631977, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 2, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131937Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180011785c1ee SET c_lastmodified = 1279631977, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 3, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131937Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee SET c_deleted = 1, c_lastmodified = 1279631977 WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' DELETE FROM sogopg3820180011785c1ee_quick WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION And the entry has gone. Now the SAME thing done with login as "pg382018" in the web interface. 2a: Open the event in web calendar (the drop down menu is showing "Test" as calendar which is correct for this event, compare with step 2 at the beginning!): SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' 3a: Save the event. SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F', c_sequence = 2, c_nextalarm = 0, c_title = 'Test, la deuxième', c_classification = 0, c_location = '', c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279701000, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279695600, c_isallday = 0 WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279632579, c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_version = 1, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T132553Z UID:0E0B830B-4EAF-45BD-9E3D-E6F839AD150F DTEND;TZID=Europe/Berlin:20100721T103000 TRANSP:OPAQUE SUMMARY:Test, la deuxième DTSTART;TZID=Europe/Berlin:20100721T090000 DTSTAMP:20100720T132605Z SEQUENCE:2 LAST-MODIFIED:20100720T132939Z END:VEVENT END:VCALENDAR' WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F', c_sequence = 2, c_nextalarm = 0, c_title = 'Test, la deuxième', c_classification = 0, c_location = '', c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279701000, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279695600, c_isallday = 0 WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279632579, c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_version = 2, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T132553Z UID:0E0B830B-4EAF-45BD-9E3D-E6F839AD150F DTEND;TZID=Europe/Berlin:20100721T103000 TRANSP:OPAQUE SUMMARY:Test, la deuxième DTSTART;TZID=Europe/Berlin:20100721T090000 DTSTAMP:20100720T132605Z SEQUENCE:2 LAST-MODIFIED:20100720T132939Z END:VEVENT END:VCALENDAR' WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' COMMIT TRANSACTION COMMIT TRANSACTION postgres-sogo-log-gienger.txt (23,873 bytes)

gienger 2010-07-20 13:40 reporter ~0001197	I attached a postgresql statement log. Perhaps it can be helpful.

gienger 2010-07-20 14:10 reporter ~0001198	https://mysogohost/SOGo/so/pg382018/Calendar/view works but https://mysogohost/SOGo/so/pascal.gienger/Calendar/view has the fuzzy behaviour described above. I retried with `SOGoUserSources = ( { CNFieldName = cn; IDFieldName = uid; UIDFieldName = uid; baseDN = "ou=users,o=Universitaet Konstanz,c=DE"; bindFields = ( uid, mail, calendaringFirstLastNameForm );` [... rest omitted ...] to have "uid" all over there (and mail and calendaringFirstlastNameForm as valid login identifiers for indirect bind) but the problem persists. "bindFields" works as I can log on with my mail address for example (or my pascal.gienger form). i dropped the sogo database, recreated it, restarted memcached, but still no go. The Web Calendar seems to use the "user name" in the URL directly somewhere in the code where it should not do it.

gienger 2010-07-22 06:42 reporter ~0001213	This seems to be always the case if bindfields is not the same as UIDFieldName.

Date Modified	Username	Field	Change
2010-07-20 12:25	gienger	New Issue
2010-07-20 12:25	gienger	File Added: sogo-calendar-bug-gienger.png
2010-07-20 13:39	gienger	File Added: postgres-sogo-log-gienger.txt
2010-07-20 13:40	gienger	Note Added: 0001197
2010-07-20 14:10	gienger	Note Added: 0001198
2010-07-22 06:42	gienger	Note Added: 0001213
2010-11-11 22:59	ludovic	Relationship added	child of 0000956
2012-04-10 08:11	Christian Mack	Status	new => closed
2012-04-10 08:11	Christian Mack	Resolution	open => fixed