Re: [Dovecot] MySQL server has gone away / dict ? tests done
Am 15.02.2012 20:10, schrieb Robert Schetterer: > Am 15.02.2012 19:43, schrieb Timo Sirainen: >> On 15.2.2012, at 20.22, Robert Schetterer wrote: >> >>> sorry for some more question >>> what is the default behave if dict quota over sql cant be reached >>> i.e with lmtp >>> >>> something like log warning and deliver anyway ? >> >> I think it tempfails. Try. > > hm, test servers arent up recently > cant do it on production > > but i will test before i go try dove 2.1 > and report, @list perhaps anyone other having it tested before? >> > ok the test server was good enough for small tests with 2.0.13 dove private/dovecot-lmtp] said: 451 4.2.0 <@com> Internal error occurred. Refer to server log for more information. dict: Error: mysql(localhost2): Connect failed to database (postfix): Unknown MySQL server host '...' (1) - waiting for 125 seconds before retry youre right looks like default is tempfail 451 so it stays in postfix queue and is permanent retry after sql comming back , its getting delivered i.e force with Flush Queue so thats good enough for me i think -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
Re: [Dovecot] MySQL server has gone away / dict ?
Am 15.02.2012 19:43, schrieb Timo Sirainen: > On 15.2.2012, at 20.22, Robert Schetterer wrote: > >> sorry for some more question >> what is the default behave if dict quota over sql cant be reached >> i.e with lmtp >> >> something like log warning and deliver anyway ? > > I think it tempfails. Try. hm, test servers arent up recently cant do it on production but i will test before i go try dove 2.1 and report, @list perhaps anyone other having it tested before? > -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
Re: [Dovecot] MySQL server has gone away / dict ?
On 15.2.2012, at 20.22, Robert Schetterer wrote: > sorry for some more question > what is the default behave if dict quota over sql cant be reached > i.e with lmtp > > something like log warning and deliver anyway ? I think it tempfails. Try.
Re: [Dovecot] MySQL server has gone away / dict ?
Am 15.02.2012 17:10, schrieb Robert Schetterer: > Am 15.02.2012 14:07, schrieb Timo Sirainen: >> On Wed, 2012-02-15 at 09:10 +0100, Robert Schetterer wrote: >>> 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=... >> .. >>> is it possible to have i.e >>> >>> connect = host=192.168.123.150 host=127.0.0.1 dbname=.. user=... >>> password=... >>> >>> there too? >> >> Assuming your SQL database is configured to do synchronous multi-master >> replication, sure. >> >> > jep ,thx Timo > Hi Timo, sorry for some more question what is the default behave if dict quota over sql cant be reached i.e with lmtp something like log warning and deliver anyway ? -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
Re: [Dovecot] MySQL server has gone away / dict ?
Am 15.02.2012 14:07, schrieb Timo Sirainen: > On Wed, 2012-02-15 at 09:10 +0100, Robert Schetterer wrote: >> 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=... > .. >> is it possible to have i.e >> >> connect = host=192.168.123.150 host=127.0.0.1 dbname=.. user=... >> password=... >> >> there too? > > Assuming your SQL database is configured to do synchronous multi-master > replication, sure. > > jep ,thx Timo -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
Re: [Dovecot] MySQL server has gone away / dict ?
On Wed, 2012-02-15 at 09:10 +0100, Robert Schetterer wrote: > 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=... .. > is it possible to have i.e > > connect = host=192.168.123.150 host=127.0.0.1 dbname=.. user=... > password=... > > there too? Assuming your SQL database is configured to do synchronous multi-master replication, sure.
Re: [Dovecot] MySQL server has gone away / dict ?
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