Hi,
>-----Original Message----- >From: Willy Tarreau [mailto:w...@1wt.eu] >Sent: Friday, June 14, 2013 3:44 PM >To: Jayadevan M >Cc: haproxy@formilux.org; Jayadevan M >Subject: Re: haproxy mysql-check > >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 Telnet works - -bash-3.00# telnet 192.168.8.37 3406 Trying 192.168.8.37... Connected to 192.168.8.37. Escape character is '^]'. B 5.1.34-community-logÂBjon[]Ax<`OI_&<;Qg3^CConnection to 192.168.8.37 closed by foreign host. Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."