Currently, for some reason, I can't create address book entries. When saving the entry, it just disappears. The SOGo logs show this:
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'session:7ct8NbY9G9h/lXAA': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+dn': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user@fsmuw.rwth-aachen.de+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'session:7ct8NbY9G9h/lXAA': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+defaults': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key '/Users/user/Contacts/personal': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
2024-05-27 12:10:48.489 sogod[1663:1663] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a5d607080[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x561a5fe27a10] connection=0x(null)> for mysql://localhost/sogo/sogouser0034265f6a9
May 27 12:10:48 sogod [1663]: [WARN] <0x0x561a5d607080[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2024-05-27 12:10:48 +0200
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a5fce9050[GCSFolder]> could not open storage channel!
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'session:7ct8NbY9G9h/lXAA': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a5fce9050[GCSFolder]> could not open storage channel!
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a5fce9050[GCSFolder]> could not open storage channel!
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a5fce9050[GCSFolder]> -[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]: could not open storage channel!
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a5fce9050[GCSFolder]> could not open storage channel!
May 27 12:10:48 sogod [1663]: 127.0.0.1 "POST /SOGo/so/user/Contacts/personal/680-66545C00-23-2AB64000.vcf/saveAsContact HTTP/1.1" 200 54/289 0.043 - - 324K - 14
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'session:7ct8NbY9G9h/lXAA': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+dn': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user@fsmuw.rwth-aachen.de+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'session:7ct8NbY9G9h/lXAA': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+defaults': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'session:7ct8NbY9G9h/lXAA': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+settings': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key 'user+settings': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: <0x0x561a5d860f60[SOGoCache]> an error occurred when caching value for key '/Users/user/Contacts/personal': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
May 27 12:10:48 sogod [1663]: [ERROR] <0x0x561a6039da80[GCSFolder]> could not open storage channel!
May 27 12:10:48 sogod [1663]: 127.0.0.1 "POST /SOGo/so/user/Contacts/personal/view HTTP/1.1" 200 209/46 0.026 - - 0 - 14
The sogo config has these lines:
SOGoProfileURL = "postgresql://sogo:password@127.0.0.1:5432/sogo/sogo_user_profile";
OCSFolderInfoURL = "postgresql://sogo:password@127.0.0.1:5432/sogo/sogo_folder_info";
OCSSessionsFolderURL = "postgresql://sogo:password@127.0.0.1:5432/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL = "postgresql://sogo:password@127.0.0.1:5432/sogo/sogo_alarms_folder";
MySQL4DebugEnabled is set to YES
The issue already existed before migrating from mysql/MariaDB to Postgres. Also, what very much irritates me is the error that sogo supposedly can't connect to the database. Doing it manually with sudo -u sogo psql --username=sogo and then entering the password isn't an issue. The user sogo is listed as the owner of the database and every table. |