0005674: No CalDav sync with Asterisk 18 - SOGo

ID	Project	Category	View Status	Date Submitted	Last Update

0005674	SOGo	Backend Calendar	public	2023-01-16 20:15	2023-09-08 07:09

Reporter	mypbx	Assigned To
Priority	normal	Severity	major	Reproducibility	always
Status	new	Resolution	open
Platform	[Server] Linux	OS	RHEL/CentOS	OS Version	7
Product Version	5.8.0

Summary	0005674: No CalDav sync with Asterisk 18
Description	In my asterisk 18 dailplan (VOIP) I use a time dependent logic based on a Sogo CalDav calendar / Iredmail Server. CalDav unexpectedly stopped working (possible with the upgrade to Sogo 5.8.0) The calendar function in Asterisk still works fine with Google Calendar and provides the schedule, making it an Asterisk issue very unlikely because Asterisk was not updated (OS was). Sogo CalDav still works fine with email client Thunderbird. Same setting used in Asterisk is not working. I can reproduce this issue if needed.
Steps To Reproduce	Login in asterisk via asterisk -r, calendar show calendars Ical google show the activity planned, Sogo Caldev activity does not show
Additional Information	I can downgrade sogo to a previous version if someone provides some hints. Also able to restore a backup to check if issue is gone.
Tags	No tags attached.

sebastien 2023-01-17 08:41 administrator ~0016555	Maybe you can provide logs with `SOGoDebugRequests = YES; SoDebugBaseURL = YES; MySQL4DebugEnabled = YES;` Did you check also with asterisk support ? Sebastien

mypbx 2023-01-17 19:32 reporter ~0016562	I also created a ticket for asterisk support, but found out that at least Ical functionality is working in asterisk. Will look into creating detailed debugging info (for the first time in Iredmail/Sogo, but that shouldn't matter) Keep you updated

mypbx 2023-01-17 19:50 reporter ~0016563	192.168.1.5 = asterisk server Jan 17 20:32:49 sogod [1377]: 192.168.1.243 "REPORT /SOGo/dav/kalendar%40secret.com/Calendar/personal/ HTTP/1.0" 207 125/188 0.007 - - 0 - 13 Jan 17 20:32:53 sogod [1377]: non.private.IP.address "REPORT /SOGo/dav/kalendar@secret.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.008 - - 0 - 14 Jan 17 20:37:50 sogod [1377]: 192.168.1.243 "REPORT /SOGo/dav/kalendar%40secret.com/Calendar/personal/ HTTP/1.0" 207 125/188 0.007 - - 0 - 13 Jan 17 20:37:53 sogod [1377]: non.private.IP.address "REPORT /SOGo/dav/kalendar@secret.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.007 - - 0 - 14 Jan 17 20:39:07 sogod [1377]: 192.168.1.5 "REPORT /SOGo/dav/kalendar@secret.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.004 - - 0 - 14 Jan 17 20:42:50 sogod [1377]: 192.168.1.243 "REPORT /SOGo/dav/kalendar%40secret.com/Calendar/personal/ HTTP/1.0" 207 125/188 0.006 - - 0 - 13 Jan 17 20:42:53 sogod [1377]: non.private.IP.address "REPORT /SOGo/dav/kalendar@secret.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.007 - - 0 - 14 Jan 17 20:43:01 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:01 sogod [1322]: <0x0x56033a3044a0[WOWatchDogChild]> sending terminate signal to pid 1378 Jan 17 20:43:01 sogod [1322]: <0x0x560339f86a50[WOWatchDogChild]> sending terminate signal to pid 1377 Jan 17 20:43:01 sogod [1322]: <0x0x56033a1f7140[WOWatchDogChild]> sending terminate signal to pid 1376 Jan 17 20:43:01 sogod [1322]: <0x0x56033a208e30[WOWatchDogChild]> sending terminate signal to pid 1375 Jan 17 20:43:01 sogod [1322]: <0x0x56033a201660[WOWatchDogChild]> sending terminate signal to pid 1374 Jan 17 20:43:01 sogod [1322]: <0x0x56033a201c20[WOWatchDogChild]> sending terminate signal to pid 1371 Jan 17 20:43:01 sogod [1322]: <0x0x56033a201ef0[WOWatchDogChild]> sending terminate signal to pid 1370 Jan 17 20:43:01 sogod [1322]: <0x0x56033a2029f0[WOWatchDogChild]> sending terminate signal to pid 1369 Jan 17 20:43:01 sogod [1322]: <0x0x56033a202ea0[WOWatchDogChild]> sending terminate signal to pid 1368 Jan 17 20:43:01 sogod [1322]: <0x0x56033a1f5f40[WOWatchDogChild]> sending terminate signal to pid 1367 Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a208e30[WOWatchDogChild]> child 1375 exited Jan 17 20:43:02 sogod [1322]: <0x0x560339f86a50[WOWatchDogChild]> child 1377 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a3044a0[WOWatchDogChild]> child 1378 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a1f7140[WOWatchDogChild]> child 1376 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a2029f0[WOWatchDogChild]> child 1369 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a202ea0[WOWatchDogChild]> child 1368 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a201c20[WOWatchDogChild]> child 1371 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a201ef0[WOWatchDogChild]> child 1370 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a1f5f40[WOWatchDogChild]> child 1367 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> Terminating with SIGINT or SIGTERM Jan 17 20:43:02 sogod [1322]: <0x0x56033a201660[WOWatchDogChild]> child 1374 exited Jan 17 20:43:02 sogod [1322]: <0x0x56033a12dd30[WOWatchDog]> all children exited. We now terminate. Jan 17 20:43:02 sogod [703610]: version 5.8.0 (build root@ 202301082210) -- starting Jan 17 20:43:02 sogod [703610]: vmem size check enabled: shutting down app when vmem > 500 MB. Currently at 243 MB Jan 17 20:43:02 sogod [703610]: <0x0x560e848de950[SOGoProductLoader]> SOGo products loaded from '/usr/lib64/GNUstep/SOGo': Jan 17 20:43:02 sogod [703610]: <0x0x560e848de950[SOGoProductLoader]> AdministrationUI.SOGo, Appointments.SOGo, CommonUI.SOGo, Contacts.SOGo, ContactsUI.SOGo, MailPartViewers.SOGo, Mailer.SOGo, MailerUI.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, ActiveSync.SOGo Jan 17 20:43:02 sogod [703610]: All products loaded - current memory usage at 295 MB Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> listening on 127.0.0.1:20000 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> watchdog process pid: 703610 Jan 17 20:43:02 sogod [703610]: <0x0x7f23c1386f80[WOWatchDogChild]> watchdog request timeout set to 61 minutes Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> preparing 10 children Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703611 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703612 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703613 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703614 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703615 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703616 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703617 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703618 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703619 Jan 17 20:43:02 sogod [703610]: <0x0x560e849032a0[WOWatchDog]> child spawned with pid 703620 2023-01-17 20:43:02.609 sogod[703616:703616] MySQL4 connection established 0x0x560e84a724d0 2023-01-17 20:43:02.609 sogod[703616:703616] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> opens channel count[0] 2023-01-17 20:43:02.609 sogod[703616:703616] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84a724d0,sogo) 2023-01-17 20:43:02.609 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.609 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.609 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.610 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.612 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.612 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.612 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.612 sogod[703616:703616] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.613 sogod[703616:703616] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> close channel count[1] Jan 17 20:43:02 sogod [703616]: <0x0x560e84703020[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.738 sogod[703614:703614] MySQL4 connection established 0x0x560e846d4340 2023-01-17 20:43:02.738 sogod[703614:703614] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> opens channel count[0] 2023-01-17 20:43:02.738 sogod[703614:703614] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e846d4340,sogo) 2023-01-17 20:43:02.738 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.738 sogod[703615:703615] MySQL4 connection established 0x0x560e84702d30 2023-01-17 20:43:02.739 sogod[703615:703615] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> opens channel count[0] 2023-01-17 20:43:02.739 sogod[703615:703615] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84702d30,sogo) 2023-01-17 20:43:02.739 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.739 sogod[703617:703617] MySQL4 connection established 0x0x560e84702bc0 2023-01-17 20:43:02.739 sogod[703617:703617] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> opens channel count[0] 2023-01-17 20:43:02.739 sogod[703617:703617] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84702bc0,sogo) 2023-01-17 20:43:02.739 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.739 sogod[703619:703619] MySQL4 connection established 0x0x560e84a72540 2023-01-17 20:43:02.740 sogod[703619:703619] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> opens channel count[0] 2023-01-17 20:43:02.740 sogod[703619:703619] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84a72540,sogo) 2023-01-17 20:43:02.740 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.740 sogod[703618:703618] MySQL4 connection established 0x0x560e84b425b0 2023-01-17 20:43:02.741 sogod[703618:703618] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> opens channel count[0] 2023-01-17 20:43:02.741 sogod[703618:703618] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84b425b0,sogo) 2023-01-17 20:43:02.741 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.741 sogod[703612:703612] MySQL4 connection established 0x0x560e84a72540 2023-01-17 20:43:02.741 sogod[703612:703612] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> opens channel count[0] 2023-01-17 20:43:02.741 sogod[703612:703612] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84a72540,sogo) 2023-01-17 20:43:02.741 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.741 sogod[703611:703611] MySQL4 connection established 0x0x560e84a724d0 2023-01-17 20:43:02.742 sogod[703611:703611] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> opens channel count[0] 2023-01-17 20:43:02.742 sogod[703611:703611] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84a724d0,sogo) 2023-01-17 20:43:02.742 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.742 sogod[703613:703613] MySQL4 connection established 0x0x560e84a72540 2023-01-17 20:43:02.742 sogod[703613:703613] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> opens channel count[0] 2023-01-17 20:43:02.742 sogod[703613:703613] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84a72540,sogo) 2023-01-17 20:43:02.743 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.743 sogod[703620:703620] MySQL4 connection established 0x0x560e84a724d0 2023-01-17 20:43:02.743 sogod[703620:703620] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> opens channel count[0] 2023-01-17 20:43:02.743 sogod[703620:703620] MySQL4 channel 0x0x560e84a03cf0 opened (connection=0x0x560e84a724d0,sogo) 2023-01-17 20:43:02.743 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2; 2023-01-17 20:43:02.743 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.743 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.743 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.744 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.744 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.744 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.744 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.744 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.744 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.744 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.744 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.745 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.750 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.750 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.750 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.750 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.751 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.751 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.751 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.751 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.751 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.751 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.751 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.751 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.752 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.752 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2; 2023-01-17 20:43:02.752 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.752 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.752 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.752 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.752 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.752 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.753 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.753 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.753 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.753 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.753 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.753 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.753 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.753 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.753 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.753 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.754 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.754 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.754 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.754 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_store WHERE 1 = 2; 2023-01-17 20:43:02.754 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.754 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.754 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.754 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.754 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.755 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.755 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.755 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.755 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.755 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.755 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.755 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.755 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.755 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.756 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.756 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.756 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.756 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_acl WHERE 1 = 2; 2023-01-17 20:43:02.756 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.756 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.756 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.756 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.756 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.756 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.757 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.757 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.757 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.757 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.757 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.757 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.757 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.757 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.757 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.758 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.758 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.758 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_cache_folder WHERE 1 = 2; 2023-01-17 20:43:02.758 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.758 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.758 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.758 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.758 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.758 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.758 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.759 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.759 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.759 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.759 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.759 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.759 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.759 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.759 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.759 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.759 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.760 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_quick_contact WHERE 1 = 2; 2023-01-17 20:43:02.760 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.760 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.760 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.762 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.762 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.763 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.764 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.765 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.765 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.767 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.767 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.767 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.767 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.767 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.767 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.768 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_quick_appointment WHERE 1 = 2; 2023-01-17 20:43:02.768 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.769 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.769 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.771 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.771 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.773 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.773 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.775 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.775 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.776 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2; 2023-01-17 20:43:02.777 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.777 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.777 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.777 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.777 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.778 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.778 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.778 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.778 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.778 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.778 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.778 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.778 sogod[703619:703619] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.779 sogod[703619:703619] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> close channel count[1] Jan 17 20:43:02 sogod [703619]: <0x0x560e847030b0[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.779 sogod[703614:703614] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> query has results, entering fetch-mode. 2023-01-17 20:43:02.779 sogod[703614:703614] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e846d4340> close channel count[1] Jan 17 20:43:02 sogod [703614]: <0x0x560e84b42910[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.779 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.780 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.780 sogod[703615:703615] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> query has results, entering fetch-mode. 2023-01-17 20:43:02.780 sogod[703615:703615] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702d30> close channel count[1] Jan 17 20:43:02 sogod [703615]: <0x0x560e84a72530[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.780 sogod[703618:703618] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> query has results, entering fetch-mode. 2023-01-17 20:43:02.780 sogod[703618:703618] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84b425b0> close channel count[1] Jan 17 20:43:02 sogod [703618]: <0x0x560e8496bde0[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.781 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.781 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.781 sogod[703612:703612] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.781 sogod[703612:703612] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> close channel count[1] Jan 17 20:43:02 sogod [703612]: <0x0x560e84703090[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.781 sogod[703617:703617] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> query has results, entering fetch-mode. 2023-01-17 20:43:02.781 sogod[703617:703617] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84702bc0> close channel count[1] Jan 17 20:43:02 sogod [703617]: <0x0x560e84703100[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.782 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.782 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> SQL: SELECT 1 FROM sogo_alarms_folder WHERE 1 = 2; 2023-01-17 20:43:02.782 sogod[703611:703611] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.782 sogod[703611:703611] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> close channel count[1] Jan 17 20:43:02 sogod [703611]: <0x0x560e846f4fd0[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.782 sogod[703620:703620] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> query has results, entering fetch-mode. 2023-01-17 20:43:02.783 sogod[703620:703620] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a724d0> close channel count[1] Jan 17 20:43:02 sogod [703620]: <0x0x560e84703050[WOHttpAdaptor]> notified the watchdog that we are ready 2023-01-17 20:43:02.783 sogod[703613:703613] <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> query has results, entering fetch-mode. 2023-01-17 20:43:02.783 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84a03cf0] connection=0x0x560e84a72540> close channel count[1] Jan 17 20:43:02 sogod [703613]: <0x0x560e84703090[WOHttpAdaptor]> notified the watchdog that we are ready

mypbx 2023-01-19 10:16 reporter ~0016569	Sogo.log added sogo.log (363,627 bytes)

Christian Mack 2023-01-19 13:35 developer ~0016572 Last edited: 2023-01-19 13:36	Could you please check the result from the following query in your mysql? SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'user@domain.com';

mypbx 2023-01-19 20:01 reporter ~0016574 Last edited: 2023-01-20 08:22	As requested MariaDB [(none)]> use sogo Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [sogo]> SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ \| c_settings \| +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ \| {"Contact":{"SortingState":["c_cn", "1"]},"Calendar":{"FoldersOrder":["580-621D3400-3-4A7CF080", "580-621CFE80-1-4A7CF080", "personal"],"View":"weekview","FolderColors":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"#AAAAAA"},"NotifyOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"EventsFilterState":"view_next7","SelectedList":"eventsListView","FreeBusyExclusions":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"WebCalendars":{"user@domain.com:Calendar/580-621D3400-3-4A7CF080":"https://www.mozilla.org/media/caldata/DutchHolidays.ics","user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com"},"InactiveFolders":[],"NotifyOnExternalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"AutoReloadedWebCalendars":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"NotifyUserOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"]},"Mail":{},"General":{"PrivateSalt":"5cb1a712d53af24e3a142340093e3e77bcf0bdba"}} \| +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec)

mypbx 2023-01-20 09:51 reporter ~0016575 Last edited: 2023-01-25 20:00	I did a second check.. find attached the results from the log and sql [root@IredMail ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 76554 Server version: 10.3.28-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use sogo Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [sogo]> SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ \| c_settings \| +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ \| {"Calendar":{"FoldersOrder":["580-621D3400-3-4A7CF080", "580-621CFE80-1-4A7CF080", "personal"],"View":"weekview","FolderColors":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"#AAAAAA"},"NotifyOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"EventsFilterState":"view_next7","SelectedList":"eventsListView","FreeBusyExclusions":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"WebCalendars":{"user@domain.com:Calendar/580-621D3400-3-4A7CF080":"https://www.mozilla.org/media/caldata/DutchHolidays.ics","user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com"},"InactiveFolders":[],"NotifyOnExternalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"AutoReloadedWebCalendars":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"NotifyUserOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"]},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"5cb1a712d53af24e3a142340093e3e77bcf0bdba"},"Mail":{}} \| +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [sogo]> 2023-01-20 10:25:44.581 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: INSERT INTO sogo_store (c_content, c_folder_id, c_version, c_lastmodified, c_name, c_creationdate) VALUES ('BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 5.8.0//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Brussels LAST-MODIFIED:20221129T123233Z X-LIC-LOCATION:Europe/Brussels BEGIN:DAYLIGHT TZNAME:CEST TZOFFSETFROM:+0100 TZOFFSETTO:+0200 DTSTART:19700329T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZNAME:CET TZOFFSETFROM:+0200 TZOFFSETTO:+0100 DTSTART:19701025T030000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:ABC7B-63CA5E00-1-45479D80 SUMMARY:test LOCATION:thuis DESCRIPTION:Test CLASS:PUBLIC X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO TRANSP:OPAQUE DTSTART;TZID=Europe/Brussels:20230120T103000 DTEND;TZID=Europe/Brussels:20230120T133000 CREATED:20230120T092544Z DTSTAMP:20230120T092544Z LAST-MODIFIED:20230120T092544Z END:VEVENT END:VCALENDAR', 8, 0, 1674206744, 'ABC7B-63CA5E00-1-45479D80.ics', 1674206744); 2023-01-20 10:25:44.581 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has no results. 2023-01-20 10:25:44.581 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: COMMIT; 2023-01-20 10:25:44.593 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has no results. 2023-01-20 10:25:44.593 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: COMMIT; 2023-01-20 10:25:44.597 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has no results. Jan 20 10:25:44 sogod [703613]: \|SOGo\| request took 0.083818 seconds to execute Jan 20 10:25:44 sogod [703613]: 192.168.1.243 "POST /SOGo/so/user@domain.com/Calendar/personal/ABC7B-63CA5E00-1-45479D80.ics/saveAsAppointment HTTP/1.0" 200 20/522 0.086 - - 676K - 15 Jan 20 10:25:44 sogod [703613]: \|SOGo\| starting method 'GET' on uri '/SOGo/so/user@domain.com/Calendar/eventslist?asc=1&day=20230120&filterpopup=view_next7&search=title_Category_Location&sort=start&value=' Jan 20 10:25:44 sogod [703611]: \|SOGo\| starting method 'GET' on uri '/SOGo/so/user@domain.com/Calendar/eventsblocks?ed=20230122&sd=20230116&view=weekview' Jan 20 10:25:44 sogod [703617]: \|SOGo\| starting method 'GET' on uri '/SOGo/so/user@domain.com/Calendar/alarmslist?browserTime=1674206748' 2023-01-20 10:25:44.621 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:25:44.622 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:25:44.622 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> query has results, entering fetch-mode. 2023-01-20 10:25:44.622 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.623 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/580-621D3400-3-4A7CF080'; 2023-01-20 10:25:44.623 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/580-621D3400-3-4A7CF080'; 2023-01-20 10:25:44.624 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> query has results, entering fetch-mode. 2023-01-20 10:25:44.624 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/580-621CFE80-1-4A7CF080'; 2023-01-20 10:25:44.624 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.624 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/580-621CFE80-1-4A7CF080'; 2023-01-20 10:25:44.625 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> query has results, entering fetch-mode. 2023-01-20 10:25:44.626 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.629 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogo_quick_appointment WHERE c_folder_id = 8 AND (((c_nextalarm <= 1674379548) AND (c_nextalarm >= 1674206748)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1674206748) AND (c_enddate > 1674206748))); 2023-01-20 10:25:44.629 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> 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 = 8 AND b.c_folder_id = 8) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674428399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1673823600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.631 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> query has results, entering fetch-mode. 2023-01-20 10:25:44.631 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogo_quick_appointment WHERE c_folder_id = 13 AND (((c_nextalarm <= 1674379548) AND (c_nextalarm >= 1674206748)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1674206748) AND (c_enddate > 1674206748))); 2023-01-20 10:25:44.632 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.632 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> 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 = 8 AND b.c_folder_id = 8) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674428399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1673823600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.633 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:25:44.634 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> query has results, entering fetch-mode. 2023-01-20 10:25:44.634 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogo_quick_appointment WHERE c_folder_id = 9 AND (((c_nextalarm <= 1674379548) AND (c_nextalarm >= 1674206748)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1674206748) AND (c_enddate > 1674206748))); 2023-01-20 10:25:44.634 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.646 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/personal'; 2023-01-20 10:25:44.646 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:25:44.646 sogod[703617:703617] <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> query has results, entering fetch-mode. Jan 20 10:25:44 sogod [703617]: \|SOGo\| request took 0.029246 seconds to execute Jan 20 10:25:44 sogod [703617]: 192.168.1.243 "GET /SOGo/so/user@domain.com/Calendar/alarmslist?browserTime=1674206748 HTTP/1.0" 200 60/0 0.030 - - 168K - 14 2023-01-20 10:25:44.648 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/580-621D3400-3-4A7CF080'; 2023-01-20 10:25:44.648 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:25:44.649 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/580-621CFE80-1-4A7CF080'; 2023-01-20 10:25:44.649 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:25:44.651 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: BEGIN; 2023-01-20 10:25:44.651 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has no results. 2023-01-20 10:25:44.651 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"FoldersOrder":["580-621D3400-3-4A7CF080", "580-621CFE80-1-4A7CF080", "personal"],"View":"weekview","FolderColors":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"#AAAAAA"},"NotifyOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"EventsFilterState":"view_next7","SelectedList":"eventsListView","FreeBusyExclusions":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"WebCalendars":{"user@domain.com:Calendar/580-621D3400-3-4A7CF080":"https://www.mozilla.org/media/caldata/DutchHolidays.ics","user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com"},"InactiveFolders":[],"NotifyOnExternalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"AutoReloadedWebCalendars":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"NotifyUserOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"]},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"5cb1a712d53af24e3a142340093e3e77bcf0bdba"},"Mail":{}}' WHERE c_uid = 'user@domain.com'; 2023-01-20 10:25:44.652 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has no results. 2023-01-20 10:25:44.652 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: COMMIT; 2023-01-20 10:25:44.652 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.654 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> 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 = 13 AND b.c_folder_id = 13) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674428399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1673823600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.656 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.656 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> 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 = 13 AND b.c_folder_id = 13) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674428399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1673823600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.659 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.671 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has no results. 2023-01-20 10:25:44.672 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: BEGIN; 2023-01-20 10:25:44.672 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has no results. 2023-01-20 10:25:44.672 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"FoldersOrder":["580-621D3400-3-4A7CF080", "580-621CFE80-1-4A7CF080", "personal"],"View":"weekview","FolderColors":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"#AAAAAA"},"NotifyOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"EventsFilterState":"view_next7","SelectedList":"eventsListView","FreeBusyExclusions":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"WebCalendars":{"user@domain.com:Calendar/580-621D3400-3-4A7CF080":"https://www.mozilla.org/media/caldata/DutchHolidays.ics","user@domain.com:Calendar/580-621CFE80-1-4A7CF080":"https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com"},"InactiveFolders":[],"NotifyOnExternalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"AutoReloadedWebCalendars":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":1},"NotifyUserOnPersonalModifications":{"user@domain.com:Calendar/580-621CFE80-1-4A7CF080":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"]},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"5cb1a712d53af24e3a142340093e3e77bcf0bdba"},"Mail":{}}' WHERE c_uid = 'user@domain.com'; 2023-01-20 10:25:44.672 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has no results. 2023-01-20 10:25:44.672 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: COMMIT; 2023-01-20 10:25:44.673 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has no results. 2023-01-20 10:25:44.673 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> 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 = 8 AND b.c_folder_id = 8) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674773999)) AND ((c_enddate IS NULL) OR (c_enddate >= 1674206744)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.674 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:25:44.674 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> 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 = 8 AND b.c_folder_id = 8) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674773999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1674206744)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.675 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:25:44.678 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> 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 = 9 AND b.c_folder_id = 9) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674428399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1673823600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.688 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/user@domain.com/Calendar/personal'; 2023-01-20 10:25:44.689 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. 2023-01-20 10:25:44.689 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> 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 = 9 AND b.c_folder_id = 9) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674428399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1673823600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.690 sogod[703611:703611] <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> query has results, entering fetch-mode. Jan 20 10:25:44 sogod [703611]: \|SOGo\| request took 0.081464 seconds to execute Jan 20 10:25:44 sogod [703611]: 192.168.1.243 "GET /SOGo/so/user@domain.com/Calendar/eventsblocks?ed=20230122&sd=20230116&view=weekview HTTP/1.0" 200 1636/0 0.083 - - 0 - 14 2023-01-20 10:25:44.700 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:25:44.702 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> 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 = 13 AND b.c_folder_id = 13) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674773999)) AND ((c_enddate IS NULL) OR (c_enddate >= 1674206744)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.704 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:25:44.705 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> 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 = 13 AND b.c_folder_id = 13) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674773999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1674206744)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.707 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:25:44.720 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> 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 = 9 AND b.c_folder_id = 9) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674773999)) AND ((c_enddate IS NULL) OR (c_enddate >= 1674206744)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.721 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:25:44.722 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> 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 = 9 AND b.c_folder_id = 9) AND ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1674773999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1674206744)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:25:44.722 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. Jan 20 10:25:44 sogod [703613]: \|SOGo\| request took 0.115710 seconds to execute Jan 20 10:25:44 sogod [703613]: 192.168.1.243 "GET /SOGo/so/user@domain.com/Calendar/eventslist?asc=1&day=20230120&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.0" 200 1459/0 0.118 - - 1M - 15 Jan 20 10:26:21 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' 2023-01-20 10:26:21.098 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; 2023-01-20 10:26:21.098 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:26:21.099 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:26:21.099 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:26:21.100 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:26:21.100 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. Jan 20 10:26:21 sogod [703613]: \|SOGo\| request took 0.004062 seconds to execute Jan 20 10:26:21 sogod [703613]: public ip address "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.005 - - 0 - 15 Jan 20 10:27:07 sogod [703613]: \|SOGo\| starting method 'GET' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' Jan 20 10:27:07 sogod [703613]: \|SOGo\| request took 0.000651 seconds to execute Jan 20 10:27:07 sogod [703613]: IP-asterisk-server "GET /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 401 0/0 0.001 - - 0 - 15 Jan 20 10:27:07 sogod [703613]: \|SOGo\| starting method 'GET' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' 2023-01-20 10:27:07.700 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:27:07.701 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:27:07.701 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:27:07.702 sogod[703613:703613] <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. Jan 20 10:27:07 sogod [703613]: \|SOGo\| request took 0.003647 seconds to execute Jan 20 10:27:07 sogod [703613]: IP-asterisk-server "GET /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 404 76/0 0.004 - - 0 - 15 2023-01-20 10:28:02.580 sogod[703611:703611] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> close channel count[2] 2023-01-20 10:28:02.617 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> close channel count[3] 2023-01-20 10:28:02.663 sogod[703617:703617] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> close channel count[2] 2023-01-20 10:28:02.710 sogod[703620:703620] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e84aa9fa0] connection=0x0x560e84bfe820> close channel count[2] Jan 20 10:28:22 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/kalendar%40foobar.com/Calendar/personal/' 2023-01-20 10:28:22.179 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:28:22.179 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:28:22.180 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_lastmodified FROM sogo_store WHERE c_folder_id = 8 ORDER BY c_lastmodified DESC; 2023-01-20 10:28:22.181 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:28:22.181 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT b.c_name,a.c_component,b.c_creationdate,b.c_lastmodified,a.c_enddate,a.c_cycleenddate,b.c_version FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 8 AND b.c_folder_id = 8) AND (c_lastmodified > 1673787493) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:28:22.181 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:28:22.182 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_name, c_lastmodified, c_deleted FROM sogo_store WHERE c_folder_id = 8 AND ((c_lastmodified > 1673787493) AND (c_deleted = 1)); 2023-01-20 10:28:22.182 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. Jan 20 10:28:22 sogod [703613]: \|SOGo\| request took 0.004835 seconds to execute Jan 20 10:28:22 sogod [703613]: 192.168.1.243 "REPORT /SOGo/dav/kalendar%40foobar.com/Calendar/personal/ HTTP/1.0" 207 427/188 0.006 - - 0 - 14 Jan 20 10:28:22 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/kalendar%40foobar.com/Calendar/personal/' 2023-01-20 10:28:22.192 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:28:22.192 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. Jan 20 10:28:22 sogod [703613]: \|SOGo\| constructed root-url: /SOGo/ Jan 20 10:28:22 sogod [703613]: \|SOGo\| setting root-url in context: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: \|SOGo\| ROOT baseURL(no container, name=(null)): own: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: <0x560e851d2960[SOGoUserFolder]:user@domain.com> baseURL: name=user@domain.com (container=SOGo) container: /SOGo -- https://192.168.1.198/SOGo/dav/kalendar%40foobar.com/Calendar/personal/ own: /SOGo/dav/user@domain.com Jan 20 10:28:22 sogod [703613]: \|SOGo\| using root-url from context: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: \|SOGo\| ROOT baseURL(no container, name=(null)): own: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: <0x560e851d2960[SOGoUserFolder]:user@domain.com> baseURL: name=user@domain.com (container=SOGo) container: /SOGo -- https://192.168.1.198/SOGo/dav/kalendar%40foobar.com/Calendar/personal/ own: /SOGo/dav/user@domain.com Jan 20 10:28:22 sogod [703613]: <0x560e8512dca0[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder) container: /SOGo/dav/user@domain.com/ own: /SOGo/dav/user@domain.com/Calendar Jan 20 10:28:22 sogod [703613]: \|SOGo\| using root-url from context: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: \|SOGo\| ROOT baseURL(no container, name=(null)): own: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: <0x560e851d2960[SOGoUserFolder]:user@domain.com> baseURL: name=user@domain.com (container=SOGo) container: /SOGo -- https://192.168.1.198/SOGo/dav/kalendar%40foobar.com/Calendar/personal/ own: /SOGo/dav/user@domain.com Jan 20 10:28:22 sogod [703613]: \|SOGo\| using root-url from context: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: \|SOGo\| ROOT baseURL(no container, name=(null)): own: /SOGo/dav/ Jan 20 10:28:22 sogod [703613]: <0x560e851d2960[SOGoUserFolder]:user@domain.com> baseURL: name=user@domain.com (container=SOGo) container: /SOGo -- https://192.168.1.198/SOGo/dav/kalendar%40foobar.com/Calendar/personal/ own: /SOGo/dav/user@domain.com Jan 20 10:28:22 sogod [703613]: <0x560e8512dca0[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder) container: /SOGo/dav/user@domain.com/ own: /SOGo/dav/user@domain.com/Calendar Jan 20 10:28:22 sogod [703613]: <0x560e8522ab70[SOGoAppointmentFolder]:personal> baseURL: name=personal (container=SOGoAppointmentFolders) container: /SOGo/dav/user@domain.com/Calendar/ own: /SOGo/dav/user@domain.com/Calendar/personal 2023-01-20 10:28:22.194 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT b.c_name,a.c_component,b.c_content,b.c_version FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 8 AND b.c_folder_id = 8) AND (a.c_name = 'ABC7B-63CA5E00-1-45479D80.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:28:22.194 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. Jan 20 10:28:22 sogod [703613]: \|SOGo\| request took 0.004384 seconds to execute Jan 20 10:28:22 sogod [703613]: 192.168.1.243 "REPORT /SOGo/dav/kalendar%40foobar.com/Calendar/personal/ HTTP/1.0" 207 679/289 0.005 1219 44% 0 - 14 Jan 20 10:31:21 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' 2023-01-20 10:31:21.049 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: SELECT c_password FROM users WHERE c_uid = 'user@domain.com'; 2023-01-20 10:31:21.049 sogod[703613:703613] <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> query has results, entering fetch-mode. 2023-01-20 10:31:21.050 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> close channel count[2] 2023-01-20 10:31:21.050 sogod[703613:703613] MySQL4 connection established 0x0x560e84e1e5e0 2023-01-20 10:31:21.050 sogod[703613:703613] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> opens channel count[1] 2023-01-20 10:31:21.051 sogod[703613:703613] MySQL4 channel 0x0x560e85130bc0 opened (connection=0x0x560e84e1e5e0,sogo) 2023-01-20 10:31:21.051 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT * FROM users WHERE (c_uid = 'user@domain.com') OR (mail = 'user@domain.com'); 2023-01-20 10:31:21.051 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:31:21.052 sogod[703613:703613] MySQL4 connection established 0x0x560e853ac660 2023-01-20 10:31:21.052 sogod[703613:703613] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> opens channel count[2] 2023-01-20 10:31:21.052 sogod[703613:703613] MySQL4 channel 0x0x560e851e54c0 opened (connection=0x0x560e853ac660,sogo) 2023-01-20 10:31:21.053 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; 2023-01-20 10:31:21.053 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. 2023-01-20 10:31:21.053 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:31:21.054 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:31:21.054 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:31:21.054 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. 2023-01-20 10:31:21.055 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; 2023-01-20 10:31:21.055 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. Jan 20 10:31:21 sogod [703613]: \|SOGo\| request took 0.007175 seconds to execute Jan 20 10:31:21 sogod [703613]: public ip address "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.008 - - 0 - 15 Jan 20 10:32:07 sogod [703613]: \|SOGo\| starting method 'GET' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' 2023-01-20 10:32:07.003 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:32:07.003 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. 2023-01-20 10:32:07.004 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:32:07.006 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. Jan 20 10:32:07 sogod [703613]: \|SOGo\| request took 0.005026 seconds to execute Jan 20 10:32:07 sogod [703613]: IP-asterisk-server "GET /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 404 76/0 0.006 - - 0 - 15 Jan 20 10:33:22 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/kalendar%40foobar.com/Calendar/personal/' 2023-01-20 10:33:22.185 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:33:22.186 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:33:22.187 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: 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 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:33:22.187 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. 2023-01-20 10:33:22.188 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT c_lastmodified FROM sogo_store WHERE c_folder_id = 8 ORDER BY c_lastmodified DESC; 2023-01-20 10:33:22.188 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:33:22.188 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: SELECT b.c_name,a.c_component,b.c_creationdate,b.c_lastmodified,a.c_enddate,a.c_cycleenddate,b.c_version FROM sogo_quick_appointment a, sogo_store b WHERE (a.c_folder_id = 8 AND b.c_folder_id = 8) AND (c_lastmodified > 1674206744) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-01-20 10:33:22.189 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. 2023-01-20 10:33:22.189 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT c_name, c_lastmodified, c_deleted FROM sogo_store WHERE c_folder_id = 8 AND ((c_lastmodified > 1674206744) AND (c_deleted = 1)); 2023-01-20 10:33:22.189 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. Jan 20 10:33:22 sogod [703613]: \|SOGo\| request took 0.005366 seconds to execute Jan 20 10:33:22 sogod [703613]: 192.168.1.243 "REPORT /SOGo/dav/kalendar%40foobar.com/Calendar/personal/ HTTP/1.0" 207 125/188 0.006 - - 0 - 15 Jan 20 10:35:32 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' Jan 20 10:35:32 sogod [703613]: \|SOGo\| request took 0.000730 seconds to execute Jan 20 10:35:32 sogod [703613]: IP-asterisk-server "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 401 0/484 0.002 - - 0 - 14 Jan 20 10:35:32 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' 2023-01-20 10:35:32.665 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:35:32.665 sogod[703613:703613] <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> query has results, entering fetch-mode. 2023-01-20 10:35:32.666 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:35:32.666 sogod[703613:703613] <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:35:32.666 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> close channel count[3] 2023-01-20 10:35:32.667 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: <MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660> close channel count[2] Jan 20 10:35:32 sogod [703613]: \|SOGo\| request took 0.004418 seconds to execute Jan 20 10:35:32 sogod [703613]: IP-asterisk-server "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.005 - - 0 - 12 Jan 20 10:36:21 sogod [703613]: \|SOGo\| starting method 'REPORT' on uri '/SOGo/dav/user@domain.com/Calendar/personal/' 2023-01-20 10:36:21.058 sogod[703613:703613] MySQL4 connection established 0x0x560e84e1e5e0 2023-01-20 10:36:21.058 sogod[703613:703613] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> opens channel count[1] 2023-01-20 10:36:21.058 sogod[703613:703613] MySQL4 channel 0x0x560e851128c0 opened (connection=0x0x560e84e1e5e0,sogo) 2023-01-20 10:36:21.058 sogod[703613:703613] <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> SQL: SELECT c_password FROM users WHERE c_uid = 'user@domain.com'; 2023-01-20 10:36:21.059 sogod[703613:703613] <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:36:21.059 sogod[703613:703613] <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> SQL: SELECT * FROM users WHERE (c_uid = 'user@domain.com') OR (mail = 'user@domain.com'); 2023-01-20 10:36:21.059 sogod[703613:703613] <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:36:21.061 sogod[703613:703613] MySQL4 connection established 0x0x560e850d1190 2023-01-20 10:36:21.061 sogod[703613:703613] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> opens channel count[2] 2023-01-20 10:36:21.061 sogod[703613:703613] MySQL4 channel 0x0x560e852f2af0 opened (connection=0x0x560e850d1190,sogo) 2023-01-20 10:36:21.061 sogod[703613:703613] <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; 2023-01-20 10:36:21.061 sogod[703613:703613] <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> query has results, entering fetch-mode. 2023-01-20 10:36:21.062 sogod[703613:703613] <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@domain.com' AND c_folder_type = 'Appointment'; 2023-01-20 10:36:21.062 sogod[703613:703613] <MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0> query has results, entering fetch-mode. 2023-01-20 10:36:21.063 sogod[703613:703613] <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'user@domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-01-20 10:36:21.063 sogod[703613:703613] <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> query has results, entering fetch-mode. 2023-01-20 10:36:21.063 sogod[703613:703613] <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'user@domain.com'; 2023-01-20 10:36:21.064 sogod[703613:703613] <MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190> query has results, entering fetch-mode. Jan 20 10:36:21 sogod [703613]: \|SOGo\| request took 0.007450 seconds to execute Jan 20 10:36:21 sogod [703613]: public ip address "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 404 76/484 0.008 - - 0 - 14

mypbx 2023-02-01 10:19 reporter ~0016633	See comments from the other side (asterisk) https://community.asterisk.org/t/asterisk-18-calendar-stopped-working/95401

mypbx 2023-02-02 06:54 reporter ~0016639	Starting logging on requesting machine which returns the following error [2023-02-02 06:26:07] DEBUG[1867] res_calendar_caldav.c: Unexpected response from server, 404: Not Found Url used: url=https://sogo.server/SOGo/dav/kalendar@sogo.server/Calendar/personal/ (domain name replaced by sogo.server)

Christian Mack 2023-09-07 07:44 developer ~0017245	Seems, you use the wrong URL. ICS-URL: https://sogo.server/SOGo/dav/kalendar@sogo.server/Calendar/personal.ics This will give you a read-only copy of your personal caledar,

mypbx 2023-09-07 10:45 reporter ~0017246	Thanks for the feedback. Currently testing this. Will provide an update later

mypbx 2023-09-08 07:06 reporter ~0017251	No improvements. See analysis attached

mypbx 2023-09-08 07:09 reporter ~0017252	2023-09-08 08:12:09.012 sogod[1285:1326] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x563bac6a7070] connection=0x0x563bacf7cac0> opens channel count[2] 2023-09-08 08:12:09.012 sogod[1285:1326] MySQL4 channel 0x0x563bac6a7070 opened (connection=0x0x563bacf7cac0,sogo) 2023-09-08 08:12:09.012 sogod[1285:1326] <MySQL4Channel[0x0x563bac6a7070] connection=0x0x563bacf7cac0> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'kalendar@sogo.domain.com' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-09-08 08:12:09.012 sogod[1285:1326] <MySQL4Channel[0x0x563bac6a7070] connection=0x0x563bacf7cac0> query has results, entering fetch-mode. 2023-09-08 08:12:09.012 sogod[1285:1326] <MySQL4Channel[0x0x563bac6a7070] connection=0x0x563bacf7cac0> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'kalendar@sogo.domain.com'; 2023-09-08 08:12:09.013 sogod[1285:1326] <MySQL4Channel[0x0x563bac6a7070] connection=0x0x563bacf7cac0> query has results, entering fetch-mode. Sep 08 08:12:09 sogod [1326]: [obj-dav-dispatch] did not find a method to serve the REPORT ({urn:ietf:params:xml:ns:caldav}calendar-query) Sep 08 08:12:09 sogod [1326]: \|SOGo\| request took 0.008501 seconds to execute Sep 08 08:12:09 sogod [1326]: 192.168.1.5 "REPORT /SOGo/dav/kalendar@sogo.domain.com/Calendar/ HTTP/1.0" 501 201/484 0.009 - - 0 - 14 asterisk -> calendar.conf [Openingsurentest] type=ical url=https://mail.sogo.domain.com/SOGo/dav/kalendar@sogo.domain.com/Calendar/personal.ics user=kalendar@sogo.domain.com secret=<********> (replaced) refresh=5 timeframe=120

Date Modified	Username	Field
2023-01-16 20:15	mypbx	New Issue
2023-01-17 08:41	sebastien	Note Added: 0016555
2023-01-17 19:32	mypbx	Note Added: 0016562
2023-01-17 19:50	mypbx	Note Added: 0016563
2023-01-19 10:16	mypbx	Note Added: 0016569
2023-01-19 10:16	mypbx	File Added: sogo.log
2023-01-19 13:35	Christian Mack	Note Added: 0016572
2023-01-19 13:36	Christian Mack	Note Edited: 0016572
2023-01-19 20:01	mypbx	Note Added: 0016574
2023-01-20 08:22	Christian Mack	Note Edited: 0016574
2023-01-20 09:51	mypbx	Note Added: 0016575
2023-01-25 20:00	sebastien	Note Edited: 0016575
2023-02-01 10:19	mypbx	Note Added: 0016633
2023-02-02 06:54	mypbx	Note Added: 0016639
2023-09-07 07:44	Christian Mack	Note Added: 0017245
2023-09-07 10:45	mypbx	Note Added: 0017246
2023-09-08 07:06	mypbx	Note Added: 0017251
2023-09-08 07:09	mypbx	Note Added: 0017252

View Issue Details

Activities

Issue History