It seems that you have SQL error. You have to enable SOGoDebugRequests in your configuration and check the request and your structure.
Sebastien Le Lundi, Janvier 23, 2023 21:37 CET, "SCNR DevOps" ([email protected]) <[email protected]> a écrit: Hi, Some more errors... Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/ HTTP/1.1" 401 0/819 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/ HTTP/1.1" 207 2497/819 0.004 25414 90% 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "OPTIONS /SOGo/dav/sogo-user/ HTTP/1.1" 401 0/0 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "OPTIONS /SOGo/dav/sogo-user/ HTTP/1.1" 200 0/0 0.002 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/ HTTP/1.1" 401 0/89 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/ HTTP/1.1" 207 300/89 0.002 1210 75% 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/sogo-user/ HTTP/1.1" 401 0/768 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/sogo-user/ HTTP/1.1" 207 431/768 0.076 1431 69% 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/Calendar/ HTTP/1.1" 401 0/2237 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/Calendar/ HTTP/1.1" 207 1478/2237 0.023 10067 85% 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/ HTTP/1.1" 401 0/267 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/ HTTP/1.1" 207 2218/267 0.003 24199 90% 0 - 13Jan 23 20:33:20 sogod [970]: 10.70.0.9 "MKCALENDAR /SOGo/dav/sogo-user/Calendar/E254FD01-492A-4C79-A118-1B2A3AE2C35C/ HTTP/1.1" 401 0/1100 0.001 - - 0 - 13Jan 23 20:33:20 sogod [970]: [ERROR] <0x55829dce4c20[SOGoAppointmentFolders]:Calendar> An error occured when creating a folder: PostgreSQL72FatalError - fatal pgsql error (channel=<0x0x55829dd78800[PostgreSQL72Channel]: connection=<0x0x55829df04da0[PGConnection]: connection=0x0x55829ddc04b0>>): ERROR: invalid input syntax for integer: "postgresql://sogo3:XYZ@1IP:5432/sogo3/sogosogo-user0033088cb6b"LINE 1: ...254FD01-492A-4C79-A118-1B2A3AE2C35C', 'Calendar', 'postgresq... ^ Jan 23 20:33:20 sogod [970]: 10.70.0.9 "MKCALENDAR /SOGo/dav/sogo-user/Calendar/E254FD01-492A-4C79-A118-1B2A3AE2C35C/ HTTP/1.1" 400 107/1100 0.011 - - 0 - 14Jan 23 20:33:21 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/Calendar/inbox/ HTTP/1.1" 401 0/181 0.001 - - 0 - 14Jan 23 20:33:21 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/Calendar/inbox/ HTTP/1.1" 207 333/181 0.003 - - 0 - 14Jan 23 20:33:21 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/Calendar/inbox/ HTTP/1.1" 401 0/145 0.001 - - 0 - 14Jan 23 20:33:21 sogod [970]: [ERROR] <0x55829dec5c80[SOGoAppointmentInboxFolder]:inbox> (-[SOGoGCSFolder toOneRelationshipKeys]): fetch failed!Jan 23 20:33:21 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/Calendar/inbox/ HTTP/1.1" 207 333/145 0.003 - - 0 - 14 Weird thing is... - SQL Server has NOT been updated or changed in the last five months- sogo3 update... has been carried out yesterday... before that in december... Other applications using the postgresql server (purely internal) still run without any problems... Why did it manifest itself not before today is a miracle to me... Tobias -- E = M * C^2 +/- 3db On 23 Jan 2023, at 21:29, SCNR DevOps <[email protected]> wrote: Hi Sebastien, Thanks for your reply! I run OS X Ventura... Problems have been detected this morning (I did run an update yesterday night before I went to bed). As said... it was running OK until yesterday. iPhone / iPad still does run perfectly well... Yes, the ticket (https://bugs.sogo.nu/view.php?id=5639) looks 100% what I experience as well. The Error I can identify in the log is:"PROPFIND /SOGo/dav/XYZ/Calendar/ HTTP/1.1" 401 0/2237 0.001 - - 0 - 13 The Error I get on my os x systems is:The calendar “Calendar” could not be created on the server with an unexpected error. The request for “Calendar” in account “xxxx” failed. The server responded with“400” I have now (as a work-around) switched calendars to a nextcloud instance (this is our family calendar.... and my wife is not thrilled if that one doesn't work). Goal would be to switch it back as soon as it works again. Database is on a separate system (postgresql) CUTobias-- E = M * C^2 +/- 3db On 23 Jan 2023, at 20:44, [email protected] ([email protected]) <[email protected]> wrote: Hi Tobias, No commit since January 17 which affects Apple's Calendar on Mac OSX so this is strange it doesn't work today. What is your Mac OS X version ? There is a ticket for this issue : https://bugs.sogo.nu/view.php?id=5639 Maybe you can provide logs and useful informations. Sebastien Le Lundi, Janvier 23, 2023 19:29 CET, "SCNR DevOps" ([email protected]) <[email protected]> a écrit: Hi All, I am running a smaller sogo instances (mainly for development) and using the nightly builds.... As of today, Jan 23rd 2023 I have observed two problems: 1) Apple MacOS Calendar is no longer working in combination with sogo. i-Devices still work perfectly... but not macOS. 2) When I try to create a new calendar in my Sogo Web-Gui I get: "Request Failed" Any (?) idea on what happened? Kind Regards Tobias -- E = M * C^2 +/- 3db
