Dec 12 02:39:45 sogod [27825]: |SOGo| starting method 'GET' on uri '/SOGo/so/test1.test1@x2.local/Calendar/personal/6CAF-63968600-1-221AAAC0.ics/delete' Dec 12 02:39:45 sogod [27825]: |SOGo| lookup name: test1.test1@x2.local Dec 12 02:39:45 sogod [27825]: |SOGo| did not find key 'test1.test1@x2.local' in SoClass: <0x0x5628bdcab410[SoObjCClass]: super=0x0x5628bdcaa600 objc=SOGo slots=passwordRecovery,changePassword,toolbar,passwordRecoveryCheck,Microsoft-Server-ActiveSync,saml2-metadata,saml2-sls,loading,view,GET,casProxy,saml2-signon-post,passwordRecoveryEnabled,connect,index,passwordRecoveryEmail> Dec 12 02:39:45 sogod [27825]: |SOGo| looked up value: (null) Dec 12 02:39:45 sogod [27825]: |SOGo| lookup in root object: (null) Dec 12 02:39:45 sogod [27825]: |SOGo| GOT: (null) 2022-12-12 02:39:45.301 sogod[27825:27825] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'test1.test1@x2.local' AND c_folder_type = 'Appointment'; 2022-12-12 02:39:45.301 sogod[27825:27825] query has results, entering fetch-mode. 2022-12-12 02:39:45.302 sogod[27825:27825] SQL: SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 32 AND b.c_folder_id = 32) AND (a.c_name = '6CAF-63968600-1-221AAAC0.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2022-12-12 02:39:45.302 sogod[27825:27825] query has results, entering fetch-mode. 2022-12-12 02:39:45.429 sogod[27825:27825] SMTP: STARTTLS successfully performed 2022-12-12 02:39:45.710 sogod[27825:27825] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/test1.test1@x2.local/Calendar/personal'; 2022-12-12 02:39:45.710 sogod[27825:27825] query has results, entering fetch-mode. 2022-12-12 02:39:45.716 sogod[27825:27825] SQL: BEGIN; 2022-12-12 02:39:45.716 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.716 sogod[27825:27825] SQL: BEGIN; 2022-12-12 02:39:45.717 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.717 sogod[27825:27825] SQL: UPDATE sogo_store SET c_deleted = 1, c_lastmodified = 1670809185 WHERE c_name='6CAF-63968600-1-221AAAC0.ics' AND c_folder_id = 32; 2022-12-12 02:39:45.717 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.717 sogod[27825:27825] SQL: DELETE FROM sogo_quick_appointment WHERE c_name='6CAF-63968600-1-221AAAC0.ics' AND c_folder_id = 32; 2022-12-12 02:39:45.718 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.718 sogod[27825:27825] SQL: COMMIT; 2022-12-12 02:39:45.720 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.720 sogod[27825:27825] SQL: COMMIT; 2022-12-12 02:39:45.721 sogod[27825:27825] query has no results. Dec 12 02:39:45 sogod [27825]: |SOGo| request took 0.426485 seconds to execute Dec 12 02:39:45 sogod [27825]: 172.28.10.1 "GET /SOGo/so/test1.test1@x2.local/Calendar/personal/6CAF-63968600-1-221AAAC0.ics/delete HTTP/1.1" 204 0/0 0.429 - - 1M - 17 Dec 12 02:39:45 sogod [27825]: |SOGo| starting method 'GET' on uri '/SOGo/so/test1.test1@x2.local/Calendar/eventslist?asc=1&day=20221212&filterpopup=view_next7&search=title_Category_Location&sort=start&value=' Dec 12 02:39:45 sogod [27823]: |SOGo| starting method 'GET' on uri '/SOGo/so/test1.test1@x2.local/Calendar/eventsblocks?ed=20221218&sd=20221212&view=weekview' Dec 12 02:39:45 sogod [27825]: |SOGo| lookup name: test1.test1@x2.local Dec 12 02:39:45 sogod [27825]: |SOGo| did not find key 'test1.test1@x2.local' in SoClass: <0x0x5628bdcab410[SoObjCClass]: super=0x0x5628bdcaa600 objc=SOGo slots=passwordRecovery,changePassword,toolbar,passwordRecoveryCheck,Microsoft-Server-ActiveSync,saml2-metadata,saml2-sls,loading,view,GET,casProxy,saml2-signon-post,passwordRecoveryEnabled,connect,index,passwordRecoveryEmail> Dec 12 02:39:45 sogod [27825]: |SOGo| looked up value: (null) Dec 12 02:39:45 sogod [27825]: |SOGo| lookup in root object: (null) Dec 12 02:39:45 sogod [27825]: |SOGo| GOT: (null) Dec 12 02:39:45 sogod [27823]: |SOGo| lookup name: test1.test1@x2.local Dec 12 02:39:45 sogod [27823]: |SOGo| did not find key 'test1.test1@x2.local' in SoClass: <0x0x5628bdcab410[SoObjCClass]: super=0x0x5628bdcaa600 objc=SOGo slots=passwordRecovery,changePassword,toolbar,passwordRecoveryCheck,Microsoft-Server-ActiveSync,saml2-metadata,saml2-sls,loading,view,GET,casProxy,saml2-signon-post,passwordRecoveryEnabled,connect,index,passwordRecoveryEmail> Dec 12 02:39:45 sogod [27823]: |SOGo| looked up value: (null) Dec 12 02:39:45 sogod [27823]: |SOGo| lookup in root object: (null) Dec 12 02:39:45 sogod [27823]: |SOGo| GOT: (null) 2022-12-12 02:39:45.738 sogod[27825:27825] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'test1.test1@x2.local' AND c_folder_type = 'Appointment'; 2022-12-12 02:39:45.738 sogod[27825:27825] query has results, entering fetch-mode. 2022-12-12 02:39:45.740 sogod[27825:27825] SQL: BEGIN; 2022-12-12 02:39:45.740 sogod[27823:27823] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'test1.test1@x2.local' AND c_folder_type = 'Appointment'; 2022-12-12 02:39:45.740 sogod[27823:27823] query has results, entering fetch-mode. 2022-12-12 02:39:45.740 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.740 sogod[27825:27825] SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"SelectedList":"eventsListView","FoldersOrder":["personal"],"PreventInvitationsWhitelist":{},"EventsFilterState":"view_next7","EventsSortingState":["start", "1"],"View":"weekview"},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"54b44c8ebfbdd664c6bed735c98ae9a78c7f8238"},"Mail":{"folderForExpunge":"imaps://test1.test1%40x2.local@127.0.0.1:2143/INBOX/","ExpandedFolders":["/0", "/0/folderShared_SP_Folders"]}}' WHERE c_uid = 'test1.test1@x2.local'; 2022-12-12 02:39:45.740 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.741 sogod[27825:27825] SQL: COMMIT; 2022-12-12 02:39:45.741 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.742 sogod[27825:27825] SQL: BEGIN; 2022-12-12 02:39:45.742 sogod[27823:27823] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 32 AND b.c_folder_id = 32) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1671404399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1670799600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2022-12-12 02:39:45.742 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.742 sogod[27825:27825] SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"SelectedList":"eventsListView","FoldersOrder":["personal"],"PreventInvitationsWhitelist":{},"EventsFilterState":"view_next7","EventsSortingState":["start", "1"],"View":"weekview"},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"54b44c8ebfbdd664c6bed735c98ae9a78c7f8238"},"Mail":{"folderForExpunge":"imaps://test1.test1%40x2.local@127.0.0.1:2143/INBOX/","ExpandedFolders":["/0", "/0/folderShared_SP_Folders"]}}' WHERE c_uid = 'test1.test1@x2.local'; 2022-12-12 02:39:45.742 sogod[27823:27823] query has results, entering fetch-mode. 2022-12-12 02:39:45.743 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.743 sogod[27825:27825] SQL: COMMIT; 2022-12-12 02:39:45.743 sogod[27823:27823] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 32 AND b.c_folder_id = 32) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1671404399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1670799600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2022-12-12 02:39:45.743 sogod[27825:27825] query has no results. 2022-12-12 02:39:45.743 sogod[27825:27825] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 32 AND b.c_folder_id = 32) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1671404399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1670809185)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2022-12-12 02:39:45.744 sogod[27823:27823] query has results, entering fetch-mode. 2022-12-12 02:39:45.744 sogod[27825:27825] query has results, entering fetch-mode. Dec 12 02:39:45 sogod [27823]: |SOGo| request took 0.010192 seconds to execute Dec 12 02:39:45 sogod [27823]: 172.28.10.1 "GET /SOGo/so/test1.test1@x2.local/Calendar/eventsblocks?ed=20221218&sd=20221212&view=weekview HTTP/1.1" 200 714/0 0.012 - - 0 - 17 2022-12-12 02:39:45.745 sogod[27825:27825] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 32 AND b.c_folder_id = 32) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1671404399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1670809185)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2022-12-12 02:39:45.746 sogod[27825:27825] query has results, entering fetch-mode. Dec 12 02:39:45 sogod [27825]: |SOGo| request took 0.012375 seconds to execute Dec 12 02:39:45 sogod [27825]: 172.28.10.1 "GET /SOGo/so/test1.test1@x2.local/Calendar/eventslist?asc=1&day=20221212&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 449/0 0.014 - - 0 - 17