On Mon, Dec 22, 2025 at 10:46 AM "Oli Z." <[email protected]> wrote:
> Hi, i thought i'll test SOGo if its a good replacement for my current > roundcube-installation (looking for something with a calendar and > contacts). > > 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 > The big question is: Did you populate your DB with user data already? For example, [email protected] - did you create this use in the DB? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
