Re: [Dovecot] mysql auth failover failing

2012-07-28 Thread Noel Butler
On Sat, 2012-07-28 at 19:53 +0300, Timo Sirainen wrote: > It's in my TODO, but I don't know when I'll get around to implementing it. So > many things to do right now.. > Thanks signature.asc Description: This is a digitally signed message part

Re: [Dovecot] mysql auth failover failing

2012-07-28 Thread Timo Sirainen
It's in my TODO, but I don't know when I'll get around to implementing it. So many things to do right now.. On 25.7.2012, at 14.47, Noel Butler wrote: > As per this discussion almost a year ago, was there any attempt to > introduce failover mode planned Timo? > > > On Mon, 2011-09-12 at 13:26

Re: [Dovecot] mysql auth failover failing

2012-07-25 Thread Noel Butler
As per this discussion almost a year ago, was there any attempt to introduce failover mode planned Timo? On Mon, 2011-09-12 at 13:26 -0700, Paul B. Henson wrote: > > Perhaps it could be an option, either load balancing between all > available servers, or only using later listed servers when th

Re: [Dovecot] mysql auth failover failing

2011-09-16 Thread Paul B. Henson
On 9/16/2011 2:21 AM, Timo Sirainen wrote: As far as I can tell, it still doesn't do load balancing. Oh. http://hg.dovecot.org/dovecot-2.0/rev/327698228158 should finally fix it. :) I installed the new 2.0.15 release including this change, and can confirm it does now successfully load balan

Re: [Dovecot] mysql auth failover failing

2011-09-16 Thread Timo Sirainen
On Thu, 2011-09-15 at 17:03 -0700, Paul B. Henson wrote: > > I did several fixes related to this in v2.0 hg. > > I patched version 2.0.13 with these fixes and tested it out. > > As far as I can tell, it still doesn't do load balancing. Oh. http://hg.dovecot.org/dovecot-2.0/rev/327698228158 sho

Re: [Dovecot] mysql auth failover failing

2011-09-15 Thread Paul B. Henson
On 9/15/2011 3:53 AM, Timo Sirainen wrote: I did several fixes related to this in v2.0 hg. I patched version 2.0.13 with these fixes and tested it out. As far as I can tell, it still doesn't do load balancing. When started, it only connects to the primary server, and as long as that server i

Re: [Dovecot] mysql auth failover failing

2011-09-15 Thread Paul B. Henson
On 9/15/2011 3:53 AM, Timo Sirainen wrote: I did several fixes related to this in v2.0 hg. Cool, thanks. Any thoughts on when you'll release a new version including them? Looks like the relevant changesets are 0dffdc3bfad1, 3334c12a2b1a, c056bd23fdcc, 11273f581686, 1b829680dce4, 2b4e8c

Re: [Dovecot] mysql auth failover failing

2011-09-15 Thread Robert Schetterer
Am 15.09.2011 13:43, schrieb Timo Sirainen: > On Thu, 2011-09-15 at 13:39 +0200, Robert Schetterer wrote: >> >> is there really a native failover mysql in dovecot ? >> cant remember this , i only remember this as part of dovecot proxiing > > For SQL authentication it can use multiple SQL server ho

Re: [Dovecot] mysql auth failover failing

2011-09-15 Thread Timo Sirainen
On Thu, 2011-09-15 at 13:39 +0200, Robert Schetterer wrote: > > is there really a native failover mysql in dovecot ? > cant remember this , i only remember this as part of dovecot proxiing For SQL authentication it can use multiple SQL server hosts (with both MySQL and PostgreSQL) and do HA/load

Re: [Dovecot] mysql auth failover failing

2011-09-15 Thread Robert Schetterer
Am 15.09.2011 12:53, schrieb Timo Sirainen: > On Fri, 2011-09-09 at 19:33 -0700, Paul B. Henson wrote: > >> Sep 9 15:47:34 tweak dovecot: auth: Error: >> mysql(mysql-1.unx.csupomona.edu): Connect failed to database (idmgmt): >> Can't connect to MySQL server on 'mysql-1.unx.csupomona.edu' (111)

Re: [Dovecot] mysql auth failover failing

2011-09-15 Thread Timo Sirainen
On Fri, 2011-09-09 at 19:33 -0700, Paul B. Henson wrote: > Sep 9 15:47:34 tweak dovecot: auth: Error: > mysql(mysql-1.unx.csupomona.edu): Connect failed to database (idmgmt): > Can't connect to MySQL server on 'mysql-1.unx.csupomona.edu' (111) - > waiting for 1 seconds before retry I did seve

Re: [Dovecot] mysql auth failover failing

2011-09-13 Thread Timo Sirainen
On Mon, 2011-09-12 at 13:26 -0700, Paul B. Henson wrote: > > I'll try to debug this soon. > > Thanks; let me know if there's anything I could do to help, or if there > are any potential fixes you would like tested. I can't seem to be able to reproduce this. It always connects to the second MySQL

Re: [Dovecot] mysql auth failover failing

2011-09-12 Thread Paul B. Henson
On 9/12/2011 5:30 AM, Timo Sirainen wrote: This works okay enough with PostgreSQL because it does asynchronous lookups, so two simultaneous lookups create a second connection. MySQL does synchronous lookups though, so the second connection is normally never created. If I could, I think I'd rat

Re: [Dovecot] mysql auth failover failing

2011-09-12 Thread Timo Sirainen
On Fri, 2011-09-09 at 19:33 -0700, Paul B. Henson wrote: > According to the sample SQL configuration file "HA / round-robin > load-balancing is supported by giving multiple host settings, like: > host=sql1.host.org host=sql2.host.org". > > However, as far as I can tell dovecot only connects to

Re: [Dovecot] mysql auth failover failing

2011-09-11 Thread Paul B. Henson
On Sat, Sep 10, 2011 at 01:49:59AM -0700, Noel Butler wrote: > Sounds like you have bigger issues, maybe relating as to why the primary > fails? For testing purposes, it fails because I stick a firewall rule in place preventing access to it ;). In production, it came to our attention because a h

Re: [Dovecot] mysql auth failover failing

2011-09-10 Thread Noel Butler
On Fri, 2011-09-09 at 20:16 -0700, Paul B. Henson wrote: > On Fri, Sep 09, 2011 at 08:02:57PM -0700, Noel Butler wrote: > > suggest, having just one master server, after all, dovecot and postfix > > just need to read, not alter/update/insert etc. > > True; but the pieces that are altering/upda

Re: [Dovecot] mysql auth failover failing

2011-09-09 Thread Paul B. Henson
On Fri, Sep 09, 2011 at 08:02:57PM -0700, Noel Butler wrote: > Uhg i'll pretend I didnt see that :) We only use dovecot to provide sasl authentication to postfix smtp clients, using a separate password just for that purpose. Storing it in plaintext is the only way to support all authentication

Re: [Dovecot] mysql auth failover failing

2011-09-09 Thread Noel Butler
On Fri, 2011-09-09 at 19:33 -0700, Paul B. Henson wrote: > default_pass_scheme = PLAIN Uhg i'll pretend I didnt see that :) > > According to the sample SQL configuration file "HA / round-robin > load-balancing is supported by giving multiple host settings, like: > host=sql1.host.org host

[Dovecot] mysql auth failover failing

2011-09-09 Thread Paul B. Henson
We are running dovecot to provide authentication for postfix, using two mysql servers in a multi-master replication set as the password source: # 2.0.13: /etc/dovecot/dovecot.conf # OS: Linux 2.6.37-gentoo-r4 x86_64 Gentoo Base System release 2.0.2 auth