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
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
On 19/02/2024 22:26 EET burkhardt@konsultaner.de burkhardt@konsultaner.de wrote:
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 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
You can use password authentication. The user connecting will be dovecot, not root.
connect = host=localhost dbname=mails user=admin password=pass
Aki
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
So connecting via the socket is not supported? because it is with mysql according to the docs?
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
So connecting via the socket is not supported? because it is with mysql according to the docs?
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.orgIt 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
participants (3)
-
Aki Tuomi
-
burkhardt＠konsultaner.de
-
r.barclay＠habmalnefrage.de