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 - 13
Jan 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 - 13
Jan 23 20:33:20 sogod [970]: 10.70.0.9 "OPTIONS /SOGo/dav/sogo-user/ HTTP/1.1"
401 0/0 0.001 - - 0 - 13
Jan 23 20:33:20 sogod [970]: 10.70.0.9 "OPTIONS /SOGo/dav/sogo-user/ HTTP/1.1"
200 0/0 0.002 - - 0 - 13
Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/ HTTP/1.1" 401 0/89
0.001 - - 0 - 13
Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/ HTTP/1.1" 207 300/89
0.002 1210 75% 0 - 13
Jan 23 20:33:20 sogod [970]: 10.70.0.9 "REPORT /SOGo/dav/sogo-user/ HTTP/1.1"
401 0/768 0.001 - - 0 - 13
Jan 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 - 13
Jan 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 - 13
Jan 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 - 13
Jan 23 20:33:20 sogod [970]: 10.70.0.9 "PROPFIND /SOGo/dav/sogo-user/ HTTP/1.1"
401 0/267 0.001 - - 0 - 13
Jan 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 - 13
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"
401 0/1100 0.001 - - 0 - 13
Jan 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 - 14
Jan 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 - 14
Jan 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 - 14
Jan 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 - 14
Jan 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)
>
> CU
> Tobias
> --
> 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
>>>
>>>
>>>
>>
>>
>>
>
