dovecot - Nov 2010 - Multiple MYSQL hosts as passdb backend

Hello,

I use mysql as passdb backend for my dovecot 2.0.6 installation. I have 2
mysql 5.0.77 servers with master/slave replication enabled. My goal is to
ensure dovecot's ability to provide its services even when one of the mysql
hosts are unavailable. Here is my passdb backend conf:

passdb {
  driver                        = sql
  args                          = /etc/dovecot/mysql.conf
}

and mysql.conf:

default_pass_scheme = PLAIN
driver = mysql
connect = host=10.0.0.3 host=10.0.0.4 dbname=some_database user=some_user
password=some_password

password_query          = some_query

Everything works fine as long as 10.0.0.3 is up and running. However, when I
shutdown mysql server on 10.0.0.3, dovecot won't even try the other host
10.0.0.4 as it is told to do in the conf.

My dovecot verbose log says:

Nov 16 14:29:24 auth: Error: mysql: Query failed, retrying: MySQL server has
gone away
Nov 16 14:29:24 auth: Error: mysql: Connect failed to 10.0.0.3
(some_database): Can't connect to MySQL server on '10.0.0.3' (111) -
waiting
for 1 seconds before retry
Nov 16 14:30:28 auth-worker: Error: mysql: Query timed out (no free
connections for 64 secs): some_sql_query
Nov 16 14:30:28 auth-worker: Error: sql(mail_user,127.0.0.1): Password query
failed: Not connected to database
Nov 16 14:30:28 auth: Error: auth worker: Aborted request: Lookup timed out
Nov 16 14:30:28 auth: Error: mysql: Connect failed to 10.0.0.3
(some_database): Can't connect to MySQL server on '10.0.0.3' (111) -
waiting
for 1 seconds before retry
Nov 16 14:31:33 pop3-login: Info: Disconnected (auth failed, 1 attempts):
user=<mail_user>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured


What am I doing wrong? Thanks for reply in advance.






-- 
View this message in context:
http://old.nabble.com/Multiple-MYSQL-hosts-as-passdb-backend-tp30234196p30234196.html
Sent from the Dovecot mailing list archive at Nabble.com.

On Tue, 2010-11-16 at 15:44 -0800, moody_cz wrote:
> Everything works fine as long as 10.0.0.3 is up and running. However, when
I
> shutdown mysql server on 10.0.0.3, dovecot won't even try the other
host
> 10.0.0.4 as it is told to do in the conf.
That was a bug, fixed:
http://hg.dovecot.org/dovecot-2.0/rev/666fd046ab7f

Also this improves the failure handling for both mysql/pgsql:
http://hg.dovecot.org/dovecot-2.0/rev/990abbb6d3dd