[SOGo] Account mixup in SOGo Calendar when accessing via Apple Calendar

2024-04-15 Thread Andreas Kesenheimer
Hi Folks,

I meanwhile investigated further and found out that the Organizer name and 
e-mail-address is taken from the first alias I am member of (in alphabetic 
order). Since an alias may contain several e-mail-addesses the person of the 
organiser varies - see „ORGANZIZER“ entry below; by accident it can be me as 
well. A resulting insert statement into the sogo_store table looks like the 
following:

— cut here —

INSERT INTO sogo_store (c_content, c_folder_id, c_version, c_lastmodified, 
c_name, c_creationdate) VALUES ('BEGIN:VCALENDAR^M
PRODID:-//Apple Inc.//macOS 14.4.1//EN^M
VERSION:2.0^M
CALSCALE:GREGORIAN^M
BEGIN:VTIMEZONE^M
TZID:Europe/Berlin^M
BEGIN:DAYLIGHT^M
DTSTART:19810329T02^M
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU^M
TZNAME:MESZ^M
TZOFFSETFROM:+0100^M
TZOFFSETTO:+0200^M
END:DAYLIGHT^M
BEGIN:STANDARD^M
DTSTART:19961027T03^M
RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU^M
TZNAME:MEZ^M
TZOFFSETFROM:+0200^M
TZOFFSETTO:+0100^M
END:STANDARD^M
END:VTIMEZONE^M
BEGIN:VEVENT^M
CREATED:20240415T162700Z^M
DTEND;TZID=Europe/Berlin:20240416T14^M
DTSTAMP:20240415T162701Z^M
DTSTART;TZID=Europe/Berlin:20240416T13^M
LAST-MODIFIED:20240415T162700Z^M
SEQUENCE:0^M
SUMMARY:Dienstagstermin 1^M
TRANSP:OPAQUE^M
UID:056A6B0C-8C79-420D-B2BF-A33B29AB288F^M
X-APPLE-CREATOR-IDENTITY:com.apple.calendar^M
X-APPLE-CREATOR-TEAM-IDENTITY:00^M
BEGIN:VALARM^M
ACTION:NONE^M
TRIGGER;VALUE=DATE-TIME:19760401T005545Z^M
END:VALARM^M
ATTENDEE;EMAIL=attendee@another_domain.tld;PARTSTAT=NEEDS-ACTION;CN=Attendee 
Name;^M
RSVP=TRUE;CUTYPE=INDIVIDUAL:mailto:attendee@aonther_domain.tld^M
ORGANIZER;CN=Wrong 
Name;EMAIL=first_alias@my_domain.tld:mailto:wrong_name@my_domain.tld^M
CLASS:PUBLIC^M
END:VEVENT^M
END:VCALENDAR', 15, 0, 1713198421, ‚.ics', 1713198421);

— cut here —

I already cleared and rebuilt the cache of the Mac-Calendar, temporarily 
deleted the respective alias - in this case another alias is taken, where I am 
member of.

Any hint will be gently appreciated.

Best, Andreas


[SOGo] Account mixup in SOGo Calendar when accessing via Apple Calendar

2024-04-08 Thread Andreas Kesenheimer
Dears,

We recently migrated from Kerio Connect to dockerized MailCow (release 2024-04) 
/ SOGo (version 5.10.0) are very happy with it in general, but, face one 
serious issue when creating invitations from our Apple Calendar. The client 
integration is configured by installing the respective profile (IMAP, SMTP, 
Cal/CardDAV with App-Password).

Everything works fine (mail and address book in total, accessing / updating the 
calendar, calendar subscriptions / delegation etc.) except when I create an 
invitation with other persons: The organizator is chosen randomly and the 
availability does not correspond to the invited either. The invitation is not 
sent to the invited as well. When I then open the Calendar entry in SOGo web 
interface for editing and save it without any change, the invitation is sent 
out and at least the correct organizator (me) shows up, the availability 
neither mine nor of the invited still does not match.

Any hint to tackle down the issue will be gently appreciated.

Best, Andreas