It actualy looks like it is supported according to that error:
Feb 19 22:12:07 auth: Error: pgsql(/run/postgresql): Connect failed to database sogo: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: Permission denied Feb 19 22:12:07 auth: Error: Is the server running locally and accepting connections on that socket?
Am Montag, dem 19.02.2024 um 21:57 +0100 schrieb r.barclay@habmalnefrage.de: Hi Richi,
You create a user in PostgreSQL (arbitrary name, e.g. dbuserofdovecot) and use it in the Dovecot settings in the connection string:
/etc/dovecot/dovecot-sql.conf.ext
driver = pgsql connect = host=127.0.0.1 dbname=mymailserverdb user=dbuserofdovecot password=P4ssw0rdForDBUserOfDovecot ...
This way the connection is made through TCP to a host of your choice, not a Unix socket.
Yours, Reg Barclay
Gesendet: Montag, 19. Februar 2024 um 21:26 Uhr
Von: "burkhardt@konsultaner.demailto:burkhardt@konsultaner.de"
Hi! The docs for dovecot with postgres are outdated and I somehow cannot connect from my dovecot instance to my postgresql database.
I tried a lot but the debug output dosn't help me.
What user is actually trying to connect to the postgresql? the dovecot user or root or the actual user from the connection config? I want to connect locally. Do I use password or md5 or peer with a map to connect? (tried all)
simple console with pgsql command works fine.
I found a couple of "How tos" but nothing helped. Are there any potential version conflict? I'm on 2.3.16 with postgresql 16.
Thanks! Richi
dovecot mailing list -- dovecot@dovecot.orgmailto:dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.orgmailto:dovecot-leave@dovecot.org
It actualy looks like it is supported according to that error:
Feb 19 22:12:07 auth: Error: pgsql(/run/postgresql): Connect failed to database sogo: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: Permission denied Feb 19 22:12:07 auth: Error: Is the server running locally and accepting connections on that socket?
Am Montag, dem 19.02.2024 um 21:57 +0100 schrieb r.barclay@habmalnefrage.de: Hi Richi,
You create a user in PostgreSQL (arbitrary name, e.g.
dbuserofdovecot) and use it in the Dovecot settings in the connection
string:
/etc/dovecot/dovecot-sql.conf.ext
driver = pgsql
connect = host=127.0.0.1 dbname=mymailserverdb user=dbuserofdovecot
password=P4ssw0rdForDBUserOfDovecot
...
This way the connection is made through TCP to a host of your choice,
not a Unix socket.
Yours,
Reg Barclay
Gesendet: Montag, 19. Februar 2024 um 21:26 Uhr
Von: "burkhardt@konsultaner.de" <burkhardt@konsultaner.de>
An: "dovecot@dovecot.org" <dovecot@dovecot.org>
Betreff: Valid Docs for Dovecot with postgresql
Hi! The docs for dovecot with postgres are outdated and I
somehow cannot
connect from my dovecot instance to my postgresql database.
I tried a lot but the debug output dosn't help me.
What user is actually trying to connect to the postgresql?
the dovecot user or
root or the actual user from the connection config?
I want to connect locally. Do I use password or md5 or peer
with a map to
connect? (tried all)
simple console with pgsql command works fine.
I found a couple of "How tos" but nothing helped. Are
there any potential
version conflict? I'm on 2.3.16 with postgresql 16.
Thanks!
Richi
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-leave@dovecot.org