Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
0000692SOGoWeb Calendarpublic2012-04-10 08:11
Reportergienger Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.2 
Summary0000692: 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:

  1. Create a new calendar, e.g. "Test".
  2. Create an event in "Test". Save it.
  3. Reopen the created event.
  4. The "Calendar" tab will show "Personal" - and not "Test".
  5. Save the event again.
  6. The event will be in the personal calendar now.
  7. Reopen the event.
  8. Save it again.
  9. 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:

  1. new event created in "test" (red color) - the balloon help just does it right
  2. 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).

TagsNo tags attached.

Relationships

child of 0000956 resolvedwsourdeau Vanishing calendar events on update when loginname != uid 

Activities

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

gienger

2010-07-20 13:40

reporter   ~0001197

I attached a postgresql statement log. Perhaps it can be helpful.

gienger

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

gienger

2010-07-22 06:42

reporter   ~0001213

This seems to be always the case if

bindfields is not the same as UIDFieldName.

Issue History

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