Hi,
>Jayadevan, can you tell us what version you are running (which works) and
>what release you where using before? Just double checking that commit
>212f778d6 fixed that problem ...
Initial - HA-Proxy version 1.4.9 2010/10/28
Now - HA-Proxy version 1.4.24 2013/06/17
>I guess you had to do both
Hello Lukas,
Yes, the plugin was introduced in 5.6.6 as seen on [1]. I have uploaded
the .cap file (tcpdump -A -r capture.cap) to
http://nimzo[dot]info/files/capture{dot}cap
I don't think it is worth the effort as sha256 is used for password auth
and HAproxy doesn't do that. Further, using plugin
Hi!
> I moved to the latets version of HAProxy and now it is working.
Jayadevan, can you tell us what version you are running (which works)
and what release you where using before? Just double checking that
commit 212f778d6 fixed that problem ...
> I did. But that did not help. So I used late
Hello,
It is due to the plugin and it should be document IMHO (or even fixed,
although not much benefit from it):
haproxy[8258]: Server testback_mysql/localmysql-1 is UP, reason: Layer7
check passed, code: 0, info: "5.6.11-rc60.3", check duration: 0ms. 1
active and 0 backup servers online. 0 sess
Ok so it looks like changes i made a while ago to support mysql >=5.5,
must be ok since haproxy 1.4.16 :
http://git.1wt.eu/web?p=haproxy.git;a=commitdiff;h=212f778d6
Regards,
Hervé.
On 06/18/2013 12:01 PM, Jayadevan M wrote:
>>
>> Did you change authentication plugin to make it work ? If this is
>
>Did you change authentication plugin to make it work ? If this is due to auth
>plugin, we definitely need to update the documentation.
>
I did. But that did not help. So I used latest version of HAProxy. That worked.
This is the status now -
mysql> select distinct user,HOST,plugin from mysql.u
On 06/18/2013 09:29 AM, Jayadevan M wrote:
> [...]
>> CREATE USER monitor@ IDENTIFIED WITH
>> 'mysql_native_password';
>>
>> Verify it is working by doing:
>>
>> select plugin from mysql.user where user='monitor' \G
>> *** 1. row ***
>> plugin: mysq
Hi,
>
>Verify this for the user you specified in option mysql-check:
>
>select plugin from mysql.user where user='monitor' \G
>*** 1. row ***
>plugin: sha256_password
>1 row in set (0.00 sec)
>
>If you see sha256_password, it won't work.
>
>Since pass
Hello,
I have tracked this down to the new authentication method used in MySQL
5.6 since version 5.6.6.
Verify this for the user you specified in option mysql-check:
select plugin from mysql.user where user='monitor' \G
*** 1. row ***
plugin: sha25
Hi Jayadevan,
On Mon, Jun 17, 2013 at 11:50:10AM +, Jayadevan M wrote:
> One error to another - How can I make HAProxy use a new MySQL
> client/libraries?
Haproxy doesn't use a mysql library, it only does health checks and
verifies the handshake.
> I am getting the error -
>
> [WARNING] 16
Hi,
> listen stats :1936
> mode http
> stats enable
> stats realm Haproxy\ Statistics
> stats uri /
>
> frontend mysql_proxy *:3309
> mode tcp
> default_backend request_mysql
One error to another - How can I make HAProxy use a new MySQL client/libraries?
I am getting
On Mon, Jun 17, 2013 at 06:57:15AM +, Jayadevan M wrote:
> HI,
>
> >It should not because as you can see in the trace, the whole check happens in
> >only 2 milliseconds, which is quite fast. What are the other parameters you
> >changed ? Could you also please share all your timeouts ? Maybe so
HI,
>It should not because as you can see in the trace, the whole check happens in
>only 2 milliseconds, which is quite fast. What are the other parameters you
>changed ? Could you also please share all your timeouts ? Maybe some of
>them are wrong ?
>
I am getting a layer 4 timeout in the environ
On Mon, Jun 17, 2013 at 06:29:55AM +, Jayadevan M wrote:
> Hi,
>
> >OK. That's really strange. I'll recheck here by copy-pasting your data to a
> >fake
> >responder, just in case we missed something.
>
> Does the following parameter have anything to do with this? I tried changing
> a few pa
Hi,
>OK. That's really strange. I'll recheck here by copy-pasting your data to a
>fake
>responder, just in case we missed something.
Does the following parameter have anything to do with this? I tried changing a
few parameters and now it seems to be working. Will test some more. In the real
sc
On Mon, Jun 17, 2013 at 05:50:29AM +, Jayadevan M wrote:
> >What version of haproxy is this ?
> >
> It is haproxy-1.4.22
OK. That's really strange. I'll recheck here by copy-pasting your
data to a fake responder, just in case we missed something.
> What does " MSG_DONTWAIT|MSG_NOSIGNAL, NULL,
HI,
>OK so linux part here :
>
>> 10:25:57.474629 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) <0.000202>
>> 10:25:57.475000 sendto(5,
>> "\16\0\0\1\0\200\0\0\1haproxy\0\0\1\0\0\0\1", 23,
>> MSG_DONT
Hi Jayadevan,
On Mon, Jun 17, 2013 at 04:55:42AM +, Jayadevan M wrote:
> Here is the output. 192.168.2.27 (MySQL on linux) works. 192.168.8.37 (MySQL
> on Windows) does not.
OK so linux part here :
> 10:25:57.474629 connect(5, {sa_family=AF_INET, sin_port=htons(3306),
> sin_addr=inet_addr(
Hi,
>-Original Message-
>From: Willy Tarreau [mailto:w...@1wt.eu]
>Sent: Friday, June 14, 2013 5:53 PM
>To: Jayadevan M
>Cc: Jayadevan M; haproxy@formilux.org
>Subject: Re: haproxy mysql-check
>
>On Fri, Jun 14, 2013 at 10:30:14AM +, Jayadevan M wrote:
>>
On Fri, Jun 14, 2013 at 10:30:14AM +, Jayadevan M wrote:
> 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
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, Jayadev
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 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 wi
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
>
23 matches
Mail list logo