[Dovecot] Dovecot pgsqlauthentication database reconnection/failover problem

[Timo Sirainen]

On Sat, 2008-02-16 at 21:46 +0800, Frank Wang wrote:
> Hi,
>     Our mail system uses dovecot-1.0-1.2.rc15.el5 in Centos-5.1 as our imap 
> server. It connects to a pgsql database in another server as authentication 
> backend. It works fine except occasionally fails to reconnect to the database 
> after temporary network block, and dovecot has to be restarted to work again 
> in such case. 

It's most likely fixed in newer versions. For example there is one
PostgreSQL fix in v1.0.4 and another in v1.0.rc26. There may be other
fixes as well.

You can find newer Dovecot RPMs for CentOS 5 from atrpms.net.

> Google led me to  
> http://www.dovecot.org/list/dovecot/2008-January/027899.html.  I followed the 
> thread to modify my dovecot-sql.conf containing "connect = host=pgsql1 
> host=pgsql2 dbname=xxxx user=xxxx"

Currently this works only with MySQL.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20080216/7953379f/attachment.bin