Re: Valid Docs for Dovecot with postgresql

2024-02-19 Thread burkha...@konsultaner.de
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 a

Re: Valid Docs for Dovecot with postgresql

2024-02-19 Thread burkha...@konsultaner.de
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.barc...@habmalnefrage.de: Hi Richi, You create a user in PostgreSQL (arbitrary name, e.g. dbuserofdovecot) and use it in the Dovecot se

Re: virtual user list in a passwd file (without linux user)

2024-02-19 Thread paul
It seems the problem was because I am running postfix with chroot so I need to perform this kind of fix: https://serverfault.com/questions/1003885/postfix-in-docker-host-or-domain-name-not-found-dns-and-docker After this fix, I am getting other errors, but the SASL errors are gone at least. ___

Aw: Valid Docs for Dovecot with postgresql

2024-02-19 Thread r.barclay--- via dovecot
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=P4ssw0rdForDBUserOfDoveco

Re: Valid Docs for Dovecot with postgresql

2024-02-19 Thread Aki Tuomi via dovecot
> On 19/02/2024 22:26 EET burkha...@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 t

Re: [Dovecot] doveadm delete folders ? / unsubscribe ?

2024-02-19 Thread Aki Tuomi via dovecot
> On 19/02/2024 22:17 EET Ryan Ford wrote: > > > Hello, > Would you be able to show what you did in order to make this command > unsubscribe as well? The link provided with the answer, no longer works. > > Thank you, Ryan > doveadm mailbox unsubscribe -u Aki

Valid Docs for Dovecot with postgresql

2024-02-19 Thread burkha...@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 c

Re: [Dovecot] doveadm delete folders ? / unsubscribe ?

2024-02-19 Thread Ryan Ford
Hello, Would you be able to show what you did in order to make this command unsubscribe as well? The link provided with the answer, no longer works. Thank you, Ryan ___ dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot

Re: virtual user list in a passwd file (without linux user)

2024-02-19 Thread paul
Thanks for helping! Good find, for sure the ':' was missing. I am surprised dovecot did not complain about the user names with a {plain} in them or that users did not have a password defined in the password file. Now the query with doveadm works if I specify us...@site1.com. I am still strug