Hi all, New user here of SOGo (version 5) for a small office with 5-6 users. As a real life test, I've set up SOGo on top of our mail server running virtual users in a MySQL database with a Postfix MTA and Dovecot IMAP server.
I installed SOGo5 a couple of days ago and had it up and running fairly easily. The platform looks great and everything seems to be working well on the email side. All in all, I am very impressed with the platform, congrats to the dev team for creating this great product! The main point of using SOGo was to be able to give read access to office members to each other's calendar. I got this figured out easily, however, I am running into an issue when synchronizing my Outlook calendar with SOGo. Of the 1200 or so events sync'd, 280 present errors in Outlook Caldav Synchronizer. In reviewing them, all of them are events created by one of my colleagues where I was invited. At first I thought it had something to do with him using OsX and Outlook for Mac, but after enabling debugging and reviewing the logs, it appears that the sync fails after 2 queries on each user's calendar: Sep 18 00:51:26 sogod [241180]: 190.104.126.222 "PUT /SOGo/dav/ > [email protected]/Calendar/personal/e43875e8-6bf4-4f72-b909-ca14e6b75ee8.ics > HTTP/1.1" 412 91/1168 0.017 - - 0 - 14 > Sep 18 00:51:26 sogod [241180]: |SOGo| starting method 'PUT' on uri > '/SOGo/dav/ > [email protected]/Calendar/personal/d3471401-805f-4485-8c58-1e01c71be725.ics > ' > 2022-09-18 00:51:26.382 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> SQL: SELECT > c_path4 FROM sogo_folder_info WHERE c_path2 = '[email protected]' AND > c_folder_type = 'Appointment'; > 2022-09-18 00:51:26.382 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.385 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> SQL: SELECT > b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content > FROM sogouser1002364e933d_quick a, sogouser1002364e933d b WHERE (a.c_name = > 'd3471401-805f-4485-8c58-1e01c71be725.ics') AND a.c_name = b.c_name AND > (c_deleted != 1 OR c_deleted IS NULL); > 2022-09-18 00:51:26.386 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.391 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> SQL: SELECT > c_path4 FROM sogo_folder_info WHERE c_path2 = '[email protected]' AND > c_folder_type = 'Appointment'; > 2022-09-18 00:51:26.392 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.392 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> SQL: SELECT > c_foldername FROM sogo_folder_info WHERE c_path = '/Users/ > [email protected]/Calendar/personal'; > 2022-09-18 00:51:26.392 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.393 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> SQL: SELECT > b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content > FROM sogouser2as0013ab56630_quick a, sogouser2as0013ab56630 b WHERE > (a.c_name = 'd3471401-805f-4485-8c58-1e01c71be725.ics') AND a.c_name = > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); > 2022-09-18 00:51:26.394 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.394 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> SQL: SELECT > c_name FROM sogouser2as0013ab56630_quick WHERE (c_uid = > 'd3471401-805f-4485-8c58-1e01c71be725'); > 2022-09-18 00:51:26.395 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> query has > results, entering fetch-mode. > Sep 18 00:51:26 sogod [241180]: |SOGo| request took 0.016227 seconds to > execute > Sep 18 00:51:26 sogod [241180]: 190.104.126.222 "PUT /SOGo/dav/ > [email protected]/Calendar/personal/d3471401-805f-4485-8c58-1e01c71be725.ics > HTTP/1.1" 412 91/1441 0.018 - - 0 - 14 > Sep 18 00:51:26 sogod [241180]: |SOGo| starting method 'PUT' on uri > '/SOGo/dav/ > [email protected]/Calendar/personal/239c5792-ed34-4882-823b-f0b274a03218.ics > ' > 2022-09-18 00:51:26.562 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> SQL: SELECT > c_path4 FROM sogo_folder_info WHERE c_path2 = '[email protected]' AND > c_folder_type = 'Appointment'; > 2022-09-18 00:51:26.563 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.566 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> SQL: SELECT > b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content > FROM sogouser1002364e933d_quick a, sogouser1002364e933d b WHERE (a.c_name = > '239c5792-ed34-4882-823b-f0b274a03218.ics') AND a.c_name = b.c_name AND > (c_deleted != 1 OR c_deleted IS NULL); > 2022-09-18 00:51:26.567 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.571 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> SQL: SELECT > c_path4 FROM sogo_folder_info WHERE c_path2 = '[email protected]' AND > c_folder_type = 'Appointment'; > 2022-09-18 00:51:26.572 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.572 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> SQL: SELECT > c_foldername FROM sogo_folder_info WHERE c_path = '/Users/ > [email protected]/Calendar/personal'; > 2022-09-18 00:51:26.572 sogod[241180:241180] > <MySQL4Channel[0x0x55873519dc40] connection=0x0x55873524c5a0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.573 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> SQL: SELECT > b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content > FROM sogouser2as0013ab56630_quick a, sogouser2as0013ab56630 b WHERE > (a.c_name = '239c5792-ed34-4882-823b-f0b274a03218.ics') AND a.c_name = > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); > 2022-09-18 00:51:26.574 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> query has > results, entering fetch-mode. > 2022-09-18 00:51:26.574 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> SQL: SELECT > c_name FROM sogouser2as0013ab56630_quick WHERE (c_uid = > '239c5792-ed34-4882-823b-f0b274a03218'); > 2022-09-18 00:51:26.575 sogod[241180:241180] > <MySQL4Channel[0x0x558735277040] connection=0x0x558735154bb0> query has > results, entering fetch-mode. > Sep 18 00:51:26 sogod [241180]: |SOGo| request took 0.015525 seconds to > execute After unchecking the "Map organizer and attendees" option in Caldav Synchronizer, 100% of these events sync'd without error. Re-enabling the option afterwards does not throw errors but the organizer/attendees do not seem to get updated in SOGo for these events. I tried finding similar issues in Google and the archive to no avail, so I thought I'd ask here if this is an expected behavior or a bug and if there might be a workaround that would allow for full invite information (including organizer/invitee) to be sync'd between Outlook and SOGo (knowing that 99.9% of the cases, Outlook will be the client creating the event)? Thanks in advance for any possible help with this matter.
