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