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 password
On 06/18/2013 09:29 AM, Jayadevan M wrote:
[...]
CREATE USER monitor@haproxy_ip IDENTIFIED WITH
'mysql_native_password';
Verify it is working by doing:
select plugin from mysql.user where user='monitor' \G
*** 1. row ***
plugin:
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.user
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 due
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
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
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
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
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, 0) =
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
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 parameters
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 environment
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 some of
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 the
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]
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:
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:
Telnet works -
-bash-3.00# telnet
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),
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_DONTWAIT|MSG_NOSIGNAL,
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
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
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 w...@1wt.eu 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
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
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.
OK.
24 matches
Mail list logo
