View Issue Details

IDProjectCategoryView StatusLast Update
0005674SOGoBackend Calendarpublic2023-09-08 07:09
Reportermypbx Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Version5.8.0 
Summary0005674: 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.

TagsNo tags attached.

Activities

sebastien

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

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

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

mypbx

2023-01-19 10:16

reporter   ~0016569

Sogo.log added

sogo.log (363,627 bytes)
Christian Mack

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

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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {&quot;Contact&quot;:{&quot;SortingState&quot;:[&quot;c_cn&quot;, &quot;1&quot;]},&quot;Calendar&quot;:{&quot;FoldersOrder&quot;:[&quot;580-621D3400-3-4A7CF080&quot;, &quot;580-621CFE80-1-4A7CF080&quot;, &quot;personal&quot;],&quot;View&quot;:&quot;weekview&quot;,&quot;FolderColors&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;#AAAAAA&quot;},&quot;NotifyOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;EventsFilterState&quot;:&quot;view_next7&quot;,&quot;SelectedList&quot;:&quot;eventsListView&quot;,&quot;FreeBusyExclusions&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;WebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621D3400-3-4A7CF080&quot;:&quot;https://www.mozilla.org/media/caldata/DutchHolidays.ics&quot;,&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com&quot;},&quot;InactiveFolders&quot;:[],&quot;NotifyOnExternalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;AutoReloadedWebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;NotifyUserOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;PreventInvitationsWhitelist&quot;:{},&quot;EventsSortingState&quot;:[&quot;start&quot;, &quot;1&quot;]},&quot;Mail&quot;:{},&quot;General&quot;:{&quot;PrivateSalt&quot;:&quot;5cb1a712d53af24e3a142340093e3e77bcf0bdba&quot;}} |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
mypbx

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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {&quot;Calendar&quot;:{&quot;FoldersOrder&quot;:[&quot;580-621D3400-3-4A7CF080&quot;, &quot;580-621CFE80-1-4A7CF080&quot;, &quot;personal&quot;],&quot;View&quot;:&quot;weekview&quot;,&quot;FolderColors&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;#AAAAAA&quot;},&quot;NotifyOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;EventsFilterState&quot;:&quot;view_next7&quot;,&quot;SelectedList&quot;:&quot;eventsListView&quot;,&quot;FreeBusyExclusions&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;WebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621D3400-3-4A7CF080&quot;:&quot;https://www.mozilla.org/media/caldata/DutchHolidays.ics&quot;,&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com&quot;},&quot;InactiveFolders&quot;:[],&quot;NotifyOnExternalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;AutoReloadedWebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;NotifyUserOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;PreventInvitationsWhitelist&quot;:{},&quot;EventsSortingState&quot;:[&quot;start&quot;, &quot;1&quot;]},&quot;Contact&quot;:{&quot;SortingState&quot;:[&quot;c_cn&quot;, &quot;1&quot;]},&quot;General&quot;:{&quot;PrivateSalt&quot;:&quot;5cb1a712d53af24e3a142340093e3e77bcf0bdba&quot;},&quot;Mail&quot;:{}} |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [sogo]>

2023-01-20 10:25:44.581 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has no results.
2023-01-20 10:25:44.581 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: COMMIT;
2023-01-20 10:25:44.593 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has no results.
2023-01-20 10:25:44.593 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: COMMIT;
2023-01-20 10:25:44.597 sogod[703613:703613] &lt;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 &quot;POST /SOGo/so/user@domain.com/Calendar/personal/ABC7B-63CA5E00-1-45479D80.ics/saveAsAppointment HTTP/1.0&quot; 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] &lt;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] &lt;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] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760>   query has results, entering fetch-mode.
2023-01-20 10:25:44.622 sogod[703611:703611] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.623 sogod[703617:703617] &lt;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] &lt;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] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760>   query has results, entering fetch-mode.
2023-01-20 10:25:44.624 sogod[703617:703617] &lt;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] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.624 sogod[703611:703611] &lt;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] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760>   query has results, entering fetch-mode.
2023-01-20 10:25:44.626 sogod[703611:703611] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.629 sogod[703617:703617] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogo_quick_appointment WHERE c_folder_id = 8 AND (((c_nextalarm &lt;= 1674379548) AND (c_nextalarm >= 1674206748)) OR ((c_nextalarm > 0) AND (c_nextalarm &lt;= 1674206748) AND (c_enddate > 1674206748)));
2023-01-20 10:25:44.629 sogod[703611:703611] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760>   query has results, entering fetch-mode.
2023-01-20 10:25:44.631 sogod[703617:703617] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogo_quick_appointment WHERE c_folder_id = 13 AND (((c_nextalarm &lt;= 1674379548) AND (c_nextalarm >= 1674206748)) OR ((c_nextalarm > 0) AND (c_nextalarm &lt;= 1674206748) AND (c_enddate > 1674206748)));
2023-01-20 10:25:44.632 sogod[703611:703611] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.632 sogod[703611:703611] &lt;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 &lt;= 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] &lt;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] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760>   query has results, entering fetch-mode.
2023-01-20 10:25:44.634 sogod[703617:703617] &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogo_quick_appointment WHERE c_folder_id = 9 AND (((c_nextalarm &lt;= 1674379548) AND (c_nextalarm >= 1674206748)) OR ((c_nextalarm > 0) AND (c_nextalarm &lt;= 1674206748) AND (c_enddate > 1674206748)));
2023-01-20 10:25:44.634 sogod[703611:703611] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.646 sogod[703611:703611] &lt;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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.646 sogod[703617:703617] &lt;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 &quot;GET /SOGo/so/user@domain.com/Calendar/alarmslist?browserTime=1674206748 HTTP/1.0&quot; 200 60/0 0.030 - - 168K - 14
2023-01-20 10:25:44.648 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.649 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.651 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: BEGIN;
2023-01-20 10:25:44.651 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has no results.
2023-01-20 10:25:44.651 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: UPDATE sogo_user_profile     SET c_settings = '{&quot;Calendar&quot;:{&quot;FoldersOrder&quot;:[&quot;580-621D3400-3-4A7CF080&quot;, &quot;580-621CFE80-1-4A7CF080&quot;, &quot;personal&quot;],&quot;View&quot;:&quot;weekview&quot;,&quot;FolderColors&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;#AAAAAA&quot;},&quot;NotifyOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;EventsFilterState&quot;:&quot;view_next7&quot;,&quot;SelectedList&quot;:&quot;eventsListView&quot;,&quot;FreeBusyExclusions&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;WebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621D3400-3-4A7CF080&quot;:&quot;https://www.mozilla.org/media/caldata/DutchHolidays.ics&quot;,&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com&quot;},&quot;InactiveFolders&quot;:[],&quot;NotifyOnExternalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;AutoReloadedWebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;NotifyUserOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;PreventInvitationsWhitelist&quot;:{},&quot;EventsSortingState&quot;:[&quot;start&quot;, &quot;1&quot;]},&quot;Contact&quot;:{&quot;SortingState&quot;:[&quot;c_cn&quot;, &quot;1&quot;]},&quot;General&quot;:{&quot;PrivateSalt&quot;:&quot;5cb1a712d53af24e3a142340093e3e77bcf0bdba&quot;},&quot;Mail&quot;:{}}'   WHERE c_uid = 'user@domain.com';
2023-01-20 10:25:44.652 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has no results.
2023-01-20 10:25:44.652 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0> SQL: COMMIT;
2023-01-20 10:25:44.652 sogod[703611:703611] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.654 sogod[703611:703611] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.656 sogod[703611:703611] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.671 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has no results.
2023-01-20 10:25:44.672 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: BEGIN;
2023-01-20 10:25:44.672 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has no results.
2023-01-20 10:25:44.672 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: UPDATE sogo_user_profile     SET c_settings = '{&quot;Calendar&quot;:{&quot;FoldersOrder&quot;:[&quot;580-621D3400-3-4A7CF080&quot;, &quot;580-621CFE80-1-4A7CF080&quot;, &quot;personal&quot;],&quot;View&quot;:&quot;weekview&quot;,&quot;FolderColors&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;#AAAAAA&quot;},&quot;NotifyOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;EventsFilterState&quot;:&quot;view_next7&quot;,&quot;SelectedList&quot;:&quot;eventsListView&quot;,&quot;FreeBusyExclusions&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;WebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621D3400-3-4A7CF080&quot;:&quot;https://www.mozilla.org/media/caldata/DutchHolidays.ics&quot;,&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:&quot;https://www.google.com/calendar/render?cid=feestdagenbelgie%40gmail.com&quot;},&quot;InactiveFolders&quot;:[],&quot;NotifyOnExternalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;AutoReloadedWebCalendars&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:1},&quot;NotifyUserOnPersonalModifications&quot;:{&quot;user@domain.com:Calendar/580-621CFE80-1-4A7CF080&quot;:0},&quot;PreventInvitationsWhitelist&quot;:{},&quot;EventsSortingState&quot;:[&quot;start&quot;, &quot;1&quot;]},&quot;Contact&quot;:{&quot;SortingState&quot;:[&quot;c_cn&quot;, &quot;1&quot;]},&quot;General&quot;:{&quot;PrivateSalt&quot;:&quot;5cb1a712d53af24e3a142340093e3e77bcf0bdba&quot;},&quot;Mail&quot;:{}}'   WHERE c_uid = 'user@domain.com';
2023-01-20 10:25:44.672 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has no results.
2023-01-20 10:25:44.672 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> SQL: COMMIT;
2023-01-20 10:25:44.673 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has no results.
2023-01-20 10:25:44.673 sogod[703613:703613] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.674 sogod[703613:703613] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.678 sogod[703611:703611] &lt;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 &lt;= 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] &lt;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] &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.689 sogod[703611:703611] &lt;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 &lt;= 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] &lt;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 &quot;GET /SOGo/so/user@domain.com/Calendar/eventsblocks?ed=20230122&sd=20230116&view=weekview HTTP/1.0&quot; 200 1636/0 0.083 - - 0 - 14
2023-01-20 10:25:44.700 sogod[703613:703613] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.702 sogod[703613:703613] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.705 sogod[703613:703613] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.720 sogod[703613:703613] &lt;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 &lt;= 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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:25:44.722 sogod[703613:703613] &lt;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 &lt;= 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] &lt;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 &quot;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&quot; 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] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:26:21.099 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:26:21.100 sogod[703613:703613] &lt;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] &lt;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  &quot;REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 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 &quot;GET /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 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] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:27:07.701 sogod[703613:703613] &lt;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] &lt;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 &quot;GET /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 404 76/0 0.004 - - 0 - 15
2023-01-20 10:28:02.580 sogod[703611:703611] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;MySQL4Channel[0x0x560e84e850c0] connection=0x0x560e84e7ece0> close channel count[2]
2023-01-20 10:28:02.617 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;MySQL4Channel[0x0x560e8514e4d0] connection=0x0x560e84e1e5e0> close channel count[3]
2023-01-20 10:28:02.663 sogod[703617:703617] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;MySQL4Channel[0x0x560e84e3e9f0] connection=0x0x560e84e9d760> close channel count[2]
2023-01-20 10:28:02.710 sogod[703620:703620] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;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] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:28:22.180 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:28:22.181 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:28:22.182 sogod[703613:703613] &lt;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] &lt;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 &quot;REPORT /SOGo/dav/kalendar%40foobar.com/Calendar/personal/ HTTP/1.0&quot; 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] &lt;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] &lt;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]: &lt;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]: &lt;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]: &lt;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]: &lt;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]: &lt;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]: &lt;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]: &lt;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] &lt;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] &lt;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 &quot;REPORT /SOGo/dav/kalendar%40foobar.com/Calendar/personal/ HTTP/1.0&quot; 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] &lt;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] &lt;MySQL4Channel[0x0x560e853b1920] connection=0x0x560e853b1fa0>   query has results, entering fetch-mode.
2023-01-20 10:31:21.050 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;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]: &lt;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] &lt;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] &lt;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]: &lt;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] &lt;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] &lt;MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660>   query has results, entering fetch-mode.
2023-01-20 10:31:21.053 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:31:21.054 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660>   query has results, entering fetch-mode.
2023-01-20 10:31:21.055 sogod[703613:703613] &lt;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] &lt;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  &quot;REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 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] &lt;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] &lt;MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660>   query has results, entering fetch-mode.
2023-01-20 10:32:07.004 sogod[703613:703613] &lt;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] &lt;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 &quot;GET /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 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] &lt;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] &lt;MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:33:22.187 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660>   query has results, entering fetch-mode.
2023-01-20 10:33:22.188 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:33:22.188 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660>   query has results, entering fetch-mode.
2023-01-20 10:33:22.189 sogod[703613:703613] &lt;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] &lt;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 &quot;REPORT /SOGo/dav/kalendar%40foobar.com/Calendar/personal/ HTTP/1.0&quot; 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 &quot;REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 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] &lt;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] &lt;MySQL4Channel[0x0x560e851e54c0] connection=0x0x560e853ac660>   query has results, entering fetch-mode.
2023-01-20 10:35:32.666 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:35:32.666 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;MySQL4Channel[0x0x560e85130bc0] connection=0x0x560e84e1e5e0> close channel count[3]
2023-01-20 10:35:32.667 sogod[703613:703613] ---------- -[MySQL4Channel primaryCloseChannel]: &lt;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 &quot;REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 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]: &lt;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] &lt;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] &lt;MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:36:21.059 sogod[703613:703613] &lt;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] &lt;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]: &lt;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] &lt;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] &lt;MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190>   query has results, entering fetch-mode.
2023-01-20 10:36:21.062 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e851128c0] connection=0x0x560e84e1e5e0>   query has results, entering fetch-mode.
2023-01-20 10:36:21.063 sogod[703613:703613] &lt;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] &lt;MySQL4Channel[0x0x560e852f2af0] connection=0x0x560e850d1190>   query has results, entering fetch-mode.
2023-01-20 10:36:21.063 sogod[703613:703613] &lt;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] &lt;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  &quot;REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0&quot; 404 76/484 0.008 - - 0 - 14
mypbx

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

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

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

mypbx

2023-09-07 10:45

reporter   ~0017246

Thanks for the feedback. Currently testing this. Will provide an update later

mypbx

mypbx

2023-09-08 07:06

reporter   ~0017251

No improvements. See analysis attached

mypbx

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

Issue History

Date Modified Username Field Change
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