[Dovecot] overriding userdb connection host for doveadm-user

[micah anderson]

On Thu, 08 Dec 2011 06:22:58 +0200, Timo Sirainen <tss at iki.fi> wrote:
> On Wed, 2011-12-07 at 13:02 -0500, Micah Anderson wrote:
> > I've got my users in a replicated database setup and dovecot configured
> > with two connect lines in dovecot-sql.conf:
> > 
> > connect = host=127.0.0.1 port=3306 dbname=users user=user password=pass
> > connect = host=127.0.0.2 port=3306 dbname=users user=user password=pass
> > 
> > this works really well to help balance the load. 
> 
> If you actually have it like that, it should only be using 127.0.0.2, as
> the second connect setting overrides the first one.. 

What I actually have is:

connect = host=127.0.0.1 port=3306 dbname=users user=user password=pass
connect = host=127.0.0.1 port=3307 dbname=users user=user password=pass

two different port configurations (I'm running stunnel), rather than two
different host entries[0]. 

>The right way would have been:
> 
> connect = host=127.0.0.1 host=127.0.0.2 port=...

So, if I just have two different ports, would the right way be:

connect = host=127.0.0.1 port=3306 port=3307 dbname...

?

micah


0. When I was anonymizing the db connection information in the original
post, I accidentally changed the ip and decided it didn't matter for the
question I was asking, so just left it. Now I see that might be
confusing.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 835 bytes
Desc: not available
URL: <http://dovecot.org/pipermail/dovecot/attachments/20111208/5b8bfba4/attachment-0004.bin>