Hi, The port is correct. I am running MySQL on 3406. Will try to take tcpdum. Regards, Jayadevan
On Fri, Jun 14, 2013 at 3:43 PM, Willy Tarreau <[email protected]> wrote: > Hi, > > On Fri, Jun 14, 2013 at 03:38:25PM +0530, Jayadevan M wrote: > > Hi, > > > > I was trying to make HAProxy's mysql-check option work with the MySQL > > Servers on Windows. HAProxy is on linux, MySQL on windows.There are 2 > MySQL > > servers - Server1 and Server2. It was not working (HAProxy was always > > marking the servers down). I tried changing one of the MySQL server > entries > > point to MySQL on a linux box and it was working. Won't HAProxy's > > mysql-check work if the target MySQL is on windows? Output from a strace > of > > HAProxy - > > > > connect(5, {sa_family=AF_INET, sin_port=htons(3406), > > sin_addr=inet_addr("192.168.8.37")}, 16) = -1 EINPROGRESS (Operation now > in > > progress) > > sendto(5, "\16\0\0\1\0\200\0\0\1haproxy\0\0\1\0\0\0\1", 23, > > MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = -1 EAGAIN (Resource temporarily > > unavailable) > > > > connect(5, {sa_family=AF_INET, sin_port=htons(3306), > > sin_addr=inet_addr("192.168.2.27")}, 16) = -1 EINPROGRESS (Operation now > in > > progress) > > sendto(5, "\16\0\0\1\0\200\0\0\1haproxy\0\0\1\0\0\0\1", 23, > > MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = 23 > > > > 192.168.2.27 is linux and 192.168.8.37 windows. I am able to connect to > the > > MySQL server on windows, from mysql command line client on 192.168.2.27. > So > > it is not a port blocked issue. > > But from what I understand, it means that the windows server is not > responding > to the connection request. I don't know if this is intentional or a > mistake, > but the port is different on your windows config (3406). Could you check > with telnet from the haproxy host that the connection establishes on this > port : > > # telnet 192.168.8.37 3406 > > That way we'll be sure that the same parameters are used. Also, it would > be nice > to take a tcpdump capture from the haproxy machine, maybe it will reveal > why > this does not work. > > Regards, > Willy > >
