I installed it with apt-get install sogo and configured it to use sql auth (already have a dovecot/postfix setup, my users are in mariadb). I also use apache2 as reverse-proxy. I have mariadb and postgresql running on that machine and would prefer to use postgresql. I got a lot of errors like:
Dec 21 11:26:15 sogod [42230]: 85.195.252.20 "GET /SOGo/so/[email protected]/Calendar/alarmslist?browserTime=1766316375 HTTP/1.1" 500 36/0 0.023 - - 336K - 14 Dec 21 11:26:15 sogod [42232]: [ERROR] <0x0x5643f0c49220[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = '[email protected]'': <PostgreSQL72Exception: 0x5643f0c53690> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x5643f0b801b0[PostgreSQL72Channel]: connection=<0x0x5643f094bae0[PGConnection]: connection=0x0x5643f0b68e50>>): FEHLER: Relation »sogo_user_profile« existiert nicht LINE 1: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'me...
I used https://github.com/Alinto/sogo/blob/master/Scripts/mysql-utf8mb4.sql, put that into chatgpt and let it convert to postgresql, executed that and the errors are gone. But i dont know if its now because something is wrong in the postgresql script or its something else. I get a 500 after logging in with the web ui. The sogo.log contains:
Dec 21 14:42:55 sogod [44393]: |SOGo| request took 0.155770 seconds to execute Dec 21 14:42:55 sogod [44393]: 85.195.xxx.xxx "GET /SOGo/so/[email protected]/Mail/view HTTP/1.1" 200 109157/0 0.159 - - 9M - 13 Dec 21 14:42:55 sogod [44391]: |SOGo| starting method 'POST' on uri '/SOGo/so/[email protected]/Mail/0/folderINBOX/changes' Dec 21 14:42:55 sogod [44391]: <0x0x55b808603e40[SOGoCache]> Cache cleanup interval set every 300.000000 seconds Dec 21 14:42:55 sogod [44391]: <0x0x55b808603e40[SOGoCache]> Using host(s) '127.0.0.1' as server(s) Dec 21 14:42:55 sogod [44393]: |SOGo| starting method 'GET' on uri '/SOGo/so/[email protected]/Calendar/alarmslist?browserTime=1766324575' Dec 21 14:42:55 sogod [44393]: <0x0x55b8081a8180[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table Dec 21 14:42:55 sogod [44393]: <0x0x55b8081a8180[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table Dec 21 14:42:55 sogod [44393]: <0x0x55b8081a8180[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table Dec 21 14:42:55 sogod [44392]: |SOGo| starting method 'GET' on uri '/SOGo/so/[email protected]/Mail/0/view' Dec 21 14:42:55 sogod [44392]: <0x0x55b8085ff6b0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds Dec 21 14:42:55 sogod [44392]: <0x0x55b8085ff6b0[SOGoCache]> Using host(s) '127.0.0.1' as server(s) 2025-12-21 14:42:55.577 sogod[44393:44393] PG0x0x55b8083ab700 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = '[email protected]' AND c_folder_type = 'Appointment' Dec 21 14:42:55 sogod [44393]: |SOGo| request took 0.026265 seconds to execute Dec 21 14:42:55 sogod [44393]: 85.195.xxx.xxx "GET /SOGo/so/[email protected]/Calendar/alarmslist?browserTime=1766324575 HTTP/1.1" 500 36/0 0.034 - - 3M - 13 Dec 21 14:42:55 sogod [44391]: |SOGo| request took 0.092678 seconds to execute Dec 21 14:42:55 sogod [44391]: 85.195.xxx.xxx "POST /SOGo/so/[email protected]/Mail/0/folderINBOX/changes HTTP/1.1" 500 36/126 0.098 - - 8M - 13 Dec 21 14:42:55 sogod [44392]: |SOGo| request took 0.093704 seconds to execute Dec 21 14:42:55 sogod [44392]: 85.195.xxx.xxx "GET /SOGo/so/[email protected]/Mail/0/view HTTP/1.1" 500 36/0 0.100 - - 8M - 13
Anyone an idea whats wrong? Regards Oli
smime.p7s
Description: Kryptografische S/MIME-Signatur
