[SOGo] BTS activities for Monday, April 15 2024

2024-04-15 Thread SOGo reporter
Title: BTS activities for Monday, April 15 2024





  
BTS Activities

  Home page: https://bugs.sogo.nu
  Project: SOGo
  For the period covering: Monday, April 15 2024

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5954
	2024-04-15 20:39:22
	updated (open)
	Backend Address Book
	CardDAV addressbook-query report does not evaluate prop-filter test for (non-)existence of a property
	
	  
	
5508
	2024-04-15 15:28:06
	updated (open)
	Web Mail
	LDAPException REASON:operation bind failed
	
	  
	
  
  




[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] Adding contacs fails

2024-04-15 Thread Richard
Hi,
I'm trying to enable users to be able to save new contacts into their
address books. But when clicking on save, the form for filling out the
contact data disappears but the contact is never shown. The server shows
these errors for that time stamp:

Apr 15 15:09:01 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key '/Users/user/Contacts/personal':
> "SERVER HAS FAILED AND IS\
>  DISABLED UNTIL TIMED RETRY"
> Apr 15 15:09:01 sogod [620575]: [ERROR] <0x0x560e14f21560[GCSFolder]>
>  could not open storage channel!
> Apr 15 15:09:01 sogod [620575]: 127.0.0.1 "POST
> /SOGo/so/user/Contacts/personal/view HTTP/1.1" 200 209/46 0.024 - - 0 - 13
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'session:azs7xxx': "SERVER HAS
> FAILED AND IS DISABLE\
> D UNTIL TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'user+dn': "SERVER HAS FAILED AND IS
> DISABLED UNTIL TIMED \
> RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'user+attributes': "SERVER HAS FAILED
> AND IS DISABLED UNTI\
> L TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'user+attributes': "SERVER HAS FAILED
> AND IS DISABLED UNTI\
> L TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'u...@domain.de+attributes': "SERVER
> HAS FAILED\
>  AND IS DISABLED UNTIL TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'session:azs7xxx': "SERVER HAS
> FAILED AND IS DISABLE\
> D UNTIL TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'user+defaults': "SERVER HAS FAILED AND
> IS DISABLED UNTIL \
> TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: <0x0x560e14c461e0[SOGoCache]> an error
> occurred when caching value for key 'session:azs7xxx': "SERVER HAS
> FAILED AND IS DISABLE\
> D UNTIL TIMED RETRY"
> Apr 15 15:09:04 sogod [620575]: 127.0.0.1 "POST
> /SOGo/so/user/Contacts/users/view HTTP/1.1" 200 66/46 0.048 - - 0 - 13


This is the database config for sogo:

> SOGoProfileURL = "postgresql://
> sogo:password@127.0.0.1:5432/sogo/sogo_user_profile";
> OCSFolderInfoURL = "postgresql://
> sogo:password@127.0.0.1:5432/sogo/sogo_folder_info";
> OCSSessionsFolderURL = "postgresql://
> sogo:password@127.0.0.1:5432/sogo/sogo_sessions_folder";
> OCSEMailAlarmsFolderURL = "postgresql://
> sogo:password@127.0.0.1:5432/sogo/sogo_alarms_folder";


So what exactly is going wrong?