Re: [SOGo] Debian 13 / SOGo / 500 error

Tue, 23 Dec 2025 03:02:27 -0800

I am not exactly sure what you mean. My users are in mariadb, the database is called "postfixadmin" because i set this email server up about 15 years ago and did not know that its a bad idea to call the db like the product thats in use :D I have about 7 users (friends). Next time i would call it "mailbox_users" or so. Anyway... i followed this guide https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL and the authentication works. When i log in to SOGo, it shows a green splash with my name, and then the white page appears. So authentication against SQL works. But i did not run any other SQL to populate the SOGo DB. I was not aware that anything like this is required. Thats why i migrated this mysql sql script to postgresql so that i have at least the sogo_user_profile table. I have the feeling there is a lot missing in the documentation... or i am blind. Or both 😉
Maybe something in the log shows something that i dont see, which might be a problem or relevant. 

Thanks in advance!

Dec 22 11:17:25 sogod [44393]: |SOGo| starting method 'GET' on uri '/SOGo'

2025-12-22 11:17:25.458 sogod[44393:44393] PostgreSQL72 connection 
established: <0x0x55b8081d80d0[PGConnection]: connection=0x0x55b808b0dc40>
2025-12-22 11:17:25.459 sogod[44393:44393] PostgreSQL72 channel 
0x0x55b80891c870 opened (connection=<0x0x55b8081d80d0[PGConnection]: 
connection=0x0x55b808b0dc40>, count=1)
2025-12-22 11:17:25.459 sogod[44393:44393] PG0x0x55b80891c870 SQL: 
SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'anonymous'
2025-12-22 11:17:25.462 sogod[44393:44393] PG0x0x55b80891c870 SQL: 
select character_octet_length as CHARACTER_MAXIMUM_LENGTH from 
information_schema.columns where table_name = 'sogo_user_profile' AND 
column_name = 'c_defaults'
2025-12-22 11:17:25.475 sogod[44393:44393] PostgreSQL72 connection 
dropped 0x0x55b8081d80d0 (channel=0x0x55b80891c870, count=0)
Dec 22 11:17:25 sogod [44393]: |SOGo| request took 0.058991 seconds to 
execute
Dec 22 11:17:25 sogod [44393]: xx.xxx.xxx.xx "GET /SOGo HTTP/1.1" 302 
0/0 0.066 - - 0 - 11

Dec 22 11:17:25 sogod [44393]: |SOGo| starting method 'GET' on uri '/SOGo/'

2025-12-22 11:17:25.554 sogod[44393:44393] PostgreSQL72 connection 
established: <0x0x55b8088f64f0[PGConnection]: connection=0x0x55b808b0dc40>
2025-12-22 11:17:25.554 sogod[44393:44393] PostgreSQL72 channel 
0x0x55b8081c5480 opened (connection=<0x0x55b8088f64f0[PGConnection]: 
connection=0x0x55b808b0dc40>, count=1)
2025-12-22 11:17:25.555 sogod[44393:44393] PG0x0x55b8081c5480 SQL: BEGIN 
TRANSACTION
2025-12-22 11:17:25.555 sogod[44393:44393] PG0x0x55b8081c5480 SQL: 
SELECT t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'
2025-12-22 11:17:25.557 sogod[44393:44393] PG0x0x55b8081c5480 SQL: 
ROLLBACK TRANSACTION
2025-12-22 11:17:25.557 sogod[44393:44393] PostgreSQL72 connection 
dropped 0x0x55b8088f64f0 (channel=0x0x55b8081c5480, count=0)

Dec 22 11:17:25 sogod [44393]: |SOGo|  constructed root-url: /SOGo/
Dec 22 11:17:25 sogod [44393]: |SOGo|  setting root-url in context: /SOGo/

Dec 22 11:17:25 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/

Dec 22 11:17:25 sogod [44393]: |SOGo| request took 0.057146 seconds to 
execute
Dec 22 11:17:25 sogod [44393]: xx.xxx.xxx.xx "GET /SOGo/ HTTP/1.1" 200 
42962/0 0.058 - - 0 - 11
Dec 22 11:17:25 sogod [44393]: |SOGo| starting method 'POST' on uri 
'/SOGo/so/passwordRecoveryEnabled'
Dec 22 11:17:25 sogod [44393]: |SOGo| request took 0.000846 seconds to 
execute
Dec 22 11:17:25 sogod [44393]: xx.xxx.xxx.xx "POST 
/SOGo/so/passwordRecoveryEnabled HTTP/1.1" 403 0/46 0.004 - - 0 - 11
Dec 22 11:17:27 sogod [44393]: |SOGo| starting method 'POST' on uri 
'/SOGo/connect'
Dec 22 11:17:27 sogod [44393]: SOGoRootPage successful login from 
'xx.xxx.xxx.xx' for user '[email protected]' - expire = -1 grace = -1
2025-12-22 11:17:27.385 sogod[44393:44393] PostgreSQL72 connection 
established: <0x0x55b80897a280[PGConnection]: connection=0x0x55b808410160>
2025-12-22 11:17:27.386 sogod[44393:44393] PostgreSQL72 channel 
0x0x55b808978aa0 opened (connection=<0x0x55b80897a280[PGConnection]: 
connection=0x0x55b808410160>, count=1)
2025-12-22 11:17:27.386 sogod[44393:44393] PG0x0x55b808978aa0 SQL: 
SELECT c_defaults FROM sogo_user_profile WHERE c_uid = '[email protected]'
2025-12-22 11:17:27.390 sogod[44393:44393] PG0x0x55b808978aa0 SQL: 
SELECT c_settings FROM sogo_user_profile WHERE c_uid = '[email protected]'
2025-12-22 11:17:27.409 sogod[44393:44393] PostgreSQL72 connection 
established: <0x0x55b8088f2d70[PGConnection]: connection=0x0x55b808b0dc40>
2025-12-22 11:17:27.409 sogod[44393:44393] PostgreSQL72 channel 
0x0x55b808982c50 opened (connection=<0x0x55b8088f2d70[PGConnection]: 
connection=0x0x55b808b0dc40>, count=2)
2025-12-22 11:17:27.409 sogod[44393:44393] PG0x0x55b808982c50 SQL: BEGIN 
TRANSACTION
2025-12-22 11:17:27.409 sogod[44393:44393] PG0x0x55b808982c50 SQL: 
SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM 
sogo_sessions_folder t1 WHERE t1.c_id='TKDUYGymIydHZKio'
2025-12-22 11:17:27.411 sogod[44393:44393] PG0x0x55b808982c50 SQL: 
ROLLBACK TRANSACTION
2025-12-22 11:17:27.411 sogod[44393:44393] PG0x0x55b808978aa0 SQL: BEGIN 
TRANSACTION
2025-12-22 11:17:27.411 sogod[44393:44393] PG0x0x55b808978aa0 SQL: 
INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, 
c_id) VALUES (1766398647, 1766398647, 
'xLN2mSfddLjQR9ee7jCwwteWuSVwlGjHD17dXmd/ZrmOGm20RgQXDuwTMdgTGqy1ZNt57hQ/oSU89SlfQ5IxslZKQXMjLtPDzuTc+TC', 
'TKDUYGymIydHZKio')
2025-12-22 11:17:27.412 sogod[44393:44393] PG0x0x55b808978aa0 SQL: 
COMMIT TRANSACTION
Dec 22 11:17:27 sogod [44393]: |SOGo| request took 0.058400 seconds to 
execute
Dec 22 11:17:27 sogod [44393]: xx.xxx.xxx.xx "POST /SOGo/connect 
HTTP/1.1" 200 76/90 0.060 - - 0 - 14
Dec 22 11:17:28 sogod [44393]: |SOGo| starting method 'GET' on uri 
'/SOGo/me%40mydomain.de'
Dec 22 11:17:28 sogod [44393]: |SOGo| request took 0.003576 seconds to 
execute
Dec 22 11:17:28 sogod [44393]: xx.xxx.xxx.xx "GET /SOGo/me%40mydomain.de 
HTTP/1.1" 302 0/0 0.005 - - 0 - 14
Dec 22 11:17:28 sogod [44393]: |SOGo| starting method 'GET' on uri 
'/SOGo/me%40mydomain.de/view'

Dec 22 11:17:28 sogod [44393]: |SOGo|  constructed root-url: /SOGo/
Dec 22 11:17:28 sogod [44393]: |SOGo|  setting root-url in context: /SOGo/

Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/

Dec 22 11:17:28 sogod [44393]: 
<0x55b80823cb70[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)

  container: /SOGo -- https://sogo.mydomain.de/SOGo/me%40mydomain.de/view
  own: /SOGo/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo| request took 0.005669 seconds to 
execute
Dec 22 11:17:28 sogod [44393]: xx.xxx.xxx.xx "GET 
/SOGo/me%40mydomain.de/view HTTP/1.1" 302 0/0 0.007 - - 0 - 14
Dec 22 11:17:28 sogod [44393]: |SOGo| starting method 'GET' on uri 
'/SOGo/so/[email protected]/Mail'
Dec 22 11:17:28 sogod [44393]: |SOGo| request took 0.003366 seconds to 
execute
Dec 22 11:17:28 sogod [44393]: xx.xxx.xxx.xx "GET 
/SOGo/so/[email protected]/Mail HTTP/1.1" 302 0/0 0.005 - - 0 - 14
Dec 22 11:17:28 sogod [44393]: |SOGo| starting method 'GET' on uri 
'/SOGo/so/[email protected]/Mail/view'

Dec 22 11:17:28 sogod [44393]: |SOGo|  constructed root-url: /SOGo/

Dec 22 11:17:28 sogod [44393]: |SOGo|  setting root-url in context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: <0x55b808937670[SOGoMailAccounts]:Mail> 
baseURL: name=Mail (container=SOGoUserFolder)

  container: /SOGo/so/[email protected]/
  own: /SOGo/so/[email protected]/Mail

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo|  using root-url from context: 
/SOGo/so/
Dec 22 11:17:28 sogod [44393]: |SOGo| ROOT baseURL(no container, 
name=(null)):

  own: /SOGo/so/

Dec 22 11:17:28 sogod [44393]: 
<0x55b808971b90[SOGoUserFolder]:[email protected]> baseURL: 
[email protected] (container=SOGo)
  container: /SOGo -- 
https://sogo.mydomain.de/SOGo/so/[email protected]/Mail/view

  own: /SOGo/so/[email protected]

Dec 22 11:17:28 sogod [44393]: |SOGo| request took 0.039929 seconds to 
execute
Dec 22 11:17:28 sogod [44393]: xx.xxx.xxx.xx "GET 
/SOGo/so/[email protected]/Mail/view HTTP/1.1" 200 109156/0 0.042 - - 640K 
- 14
Dec 22 11:17:28 sogod [44393]: |SOGo| starting method 'GET' on uri 
'/SOGo/so/[email protected]/Calendar/alarmslist?browserTime=1766398648'
Dec 22 11:17:28 sogod [44391]: |SOGo| starting method 'GET' on uri 
'/SOGo/so/[email protected]/Mail/0/view'
2025-12-22 11:17:28.926 sogod[44393:44393] PG0x0x55b808982c50 SQL: 
SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = '[email protected]' 
AND c_folder_type = 'Appointment'
Dec 22 11:17:28 sogod [44392]: |SOGo| starting method 'POST' on uri 
'/SOGo/so/[email protected]/Mail/0/folderINBOX/changes'
Dec 22 11:17:28 sogod [44393]: |SOGo| request took 0.013802 seconds to 
execute
Dec 22 11:17:28 sogod [44393]: xx.xxx.xxx.xx "GET 
/SOGo/so/[email protected]/Calendar/alarmslist?browserTime=1766398648 
HTTP/1.1" 500 36/0 0.015 - - 0 - 14
S[0x55b8086e7c90]: * OK [CAPABILITY IMAP4rev1 LOGIN-REFERRALS ID ENABLE 
IDLE SASL-IR LITERAL+ AUTH=PLAIN AUTH=LOGIN] Dovecot ready.

C[0x55b8086bdb60]: 1 login "[email protected]" "xxx"

S[0x55b8086e7c90]: 1 OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID 
ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH 
ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE REPLACE 
SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW SPECIAL-USE STATUS=SIZE SAVEDATE 
COMPRESS=DEFLATE INPROGRESS NOTIFY LITERAL+] Logged in

C[0x55b8086bdb60]: 2 capability

S[0x55b8086e7c90]: * CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID 
ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH 
ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE REPLACE 
SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW SPECIAL-USE STATUS=SIZE SAVEDATE 
COMPRESS=DEFLATE INPROGRESS NOTIFY LITERAL+

S[0x55b8086e7c90]: 2 OK Capability completed (0.001 + 0.000 secs).
C[0x55b8086bdb60]: 3 ID ("x-originating-ip" "xx.xxx.xxx.xx")
S[0x55b8086e7c90]: * ID ("name" "Dovecot")
S[0x55b8086e7c90]: 3 OK ID completed (0.001 + 0.001 secs).
C[0x55b8086bdb60]: 4 namespace
S[0x55b8086e7c90]: * NAMESPACE (("" ".")) NIL NIL
S[0x55b8086e7c90]: 4 OK Namespace completed (0.001 + 0.001 secs).
C[0x55b8086bdb60]: 5 LIST "" ""
S[0x55b8086e7c90]: * LIST (\Noselect) "." ""
S[0x55b8086e7c90]: 5 OK List completed (0.001 + 0.001 secs).
C[0x55b8086bdb60]: 6 logout
S[0x55b8086e7c90]: * BYE Logging out

S[0x55b80870eea0]: * OK [CAPABILITY IMAP4rev1 LOGIN-REFERRALS ID ENABLE 
IDLE SASL-IR LITERAL+ AUTH=PLAIN AUTH=LOGIN] Dovecot ready.

C[0x55b8087a4b10]: 1 login "[email protected]" "xxx"

S[0x55b80870eea0]: 1 OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID 
ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH 
ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE REPLACE 
SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW SPECIAL-USE STATUS=SIZE SAVEDATE 
COMPRESS=DEFLATE INPROGRESS NOTIFY LITERAL+] Logged in

C[0x55b8087a4b10]: 2 capability

S[0x55b80870eea0]: * CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID 
ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH 
ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE REPLACE 
SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW SPECIAL-USE STATUS=SIZE SAVEDATE 
COMPRESS=DEFLATE INPROGRESS NOTIFY LITERAL+

S[0x55b80870eea0]: 2 OK Capability completed (0.001 + 0.001 secs).
C[0x55b8087a4b10]: 3 ID ("x-originating-ip" "xx.xxx.xxx.xx")
S[0x55b80870eea0]: * ID ("name" "Dovecot")
S[0x55b80870eea0]: 3 OK ID completed (0.001 + 0.001 secs).
C[0x55b8087a4b10]: 4 namespace
S[0x55b80870eea0]: * NAMESPACE (("" ".")) NIL NIL
S[0x55b80870eea0]: 4 OK Namespace completed (0.001 + 0.001 secs).
C[0x55b8087a4b10]: 5 LIST "" ""
S[0x55b80870eea0]: * LIST (\Noselect) "." ""
S[0x55b80870eea0]: 5 OK List completed (0.001 + 0.001 secs).
C[0x55b8087a4b10]: 6 logout
S[0x55b80870eea0]: * BYE Logging out

S[0x55b808758a80]: * OK [CAPABILITY IMAP4rev1 LOGIN-REFERRALS ID ENABLE 
IDLE SASL-IR LITERAL+ AUTH=PLAIN AUTH=LOGIN] Dovecot ready.

C[0x55b8087214a0]: 1 login "[email protected]" "xxx"

S[0x55b808758a80]: 1 OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID 
ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH 
ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE REPLACE 
SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW SPECIAL-USE STATUS=SIZE SAVEDATE 
COMPRESS=DEFLATE INPROGREDec 22 11:17:29 sogod [44391]: |SOGo| request 
took 0.080220 seconds to execute
Dec 22 11:17:29 sogod [44391]: xx.xxx.xxx.xx "GET 
/SOGo/so/[email protected]/Mail/0/view HTTP/1.1" 500 36/0 0.086 - - 0 - 12
Dec 22 11:17:29 sogod [44392]: |SOGo| request took 0.102545 seconds to 
execute
Dec 22 11:17:29 sogod [44392]: xx.xxx.xxx.xx "POST 
/SOGo/so/[email protected]/Mail/0/folderINBOX/changes HTTP/1.1" 500 36/126 
0.111 - - 0 - 12



ps.: resent that email coz i leaked the password from that test account 
in it ;)


Am 22.12.25 um 08:59 schrieb Washington Odhiambo ([email protected]):



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://[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://[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
    <http://[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
    <http://[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 <http://[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://[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://[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://[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]



Attachment:
smime.p7s

Description: Kryptografische S/MIME-Signatur






















					Reply via email to