Valid Docs for Dovecot with postgresql

newer
User-configurable time-based mail...

older
[Dovecot] doveadm delete folders ?

burkhardt＠konsultaner.de

19 Feb 2024 19 Feb '24

10:26 p.m.

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.

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

Show replies by thread

Aki Tuomi

19 Feb 19 Feb

10:46 p.m.

...

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

r.barclay＠habmalnefrage.de

10:57 p.m.

New subject: Aw: Valid Docs for Dovecot with postgresql

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

burkhardt＠konsultaner.de

11:46 p.m.

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<mailto:burkhardt@konsultaner.de>" <burkhardt@konsultaner.de<mailto:burkhardt@konsultaner.de>> An: "dovecot@dovecot.org<mailto:dovecot@dovecot.org>" <dovecot@dovecot.org<mailto: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.

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<mailto:dovecot@dovecot.org> To unsubscribe send an email to dovecot-leave@dovecot.org<mailto: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" &lt;burkhardt@konsultaner.de>
      An: "dovecot@dovecot.org" &lt;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

burkhardt＠konsultaner.de

11:52 p.m.

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

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.

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<mailto:dovecot@dovecot.org> To unsubscribe send an email to dovecot-leave@dovecot.org<mailto:dovecot-leave@dovecot.org>

It actualy looks like it is supported according to that error:

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" &lt;burkhardt@konsultaner.de>
      An: "dovecot@dovecot.org" &lt;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

449

Age (days ago)

449

Last active (days ago)

List overview

4 comments

3 participants

participants (3)

Aki Tuomi
burkhardt＠konsultaner.de
r.barclay＠habmalnefrage.de