[Dovecot] MySQL server has gone away / dict ?

[Robert Schetterer]

Am 28.01.2012 22:06, schrieb Robert Schetterer:
> Am 28.01.2012 21:07, schrieb Timo Sirainen:
>> On 13.1.2012, at 20.29, Mark Moseley wrote:
>>
>>> If there are multiple hosts, it seems like the most robust thing to do
>>> would be to exhaust the existing connections and if none of those
>>> succeed, then start a new connection to one of them. It will probably
>>> result in much more convoluted logic but it'd probably match better
>>> what people expect from a retry.
>>
>> Done: http://hg.dovecot.org/dovecot-2.0/rev/4e7676b890f1
>>
> 
> Hi Timo
> 
> doc/example-config/dovecot-sql.conf.ext
> from hg
> has something like
> 
> # Database connection string. This is driver-specific setting.
> # HA / round-robin load-balancing is supported by giving multiple host
> # settings, like: host=sql1.host.org host=sql2.host.org
> 
> but i dont find it in
> http://wiki2.dovecot.org/AuthDatabase/SQL
> 
> 

Hi Timo,just to make sure
i have an extra
dovecot-dict-quota-sql.conf.ext ( dove 2.0.18 )

connect = host=192.168.123.150 dbname=.. user=... password=...


map {
  pattern = priv/quota/storage
  table = quota2
  username_field = username
  value_field = bytes
}
map {
  pattern = priv/quota/messages
  table = quota2
  username_field = username
  value_field = messages
}

is it possible to have i.e

connect = host=192.168.123.150 host=127.0.0.1 dbname=.. user=...
password=...

there too?

-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria