[MDEV-3579] LP:982664 - Bad handshake error when using 5.5.23 with mysql-proxy Created: 2012-04-15  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Bernhard Valenti (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug982664.xml    

 Description   

I just updated a couple of server from 5.2.4 to 5.5.23. Now when I try to connect to them through mysql-proxy (using mysql CLI) I get:

ERROR 1043 (08S01): Bad handshake

the mysql-proxy (0.8.2) log shows:

2012-04-15 17:49:28: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

connecting to the 5.5.23 servers directly works fine. Also some client libraries seem to work (my local php installation for example can connect fine through the proxy)

 Comments   
Comment by Elena Stepanova [ 2012-04-15 ]

Re: Bad handshake error when using 5.5.23 with mysql-proxy
The problem exists in latest releases of 5.2, 5.3, 5.5.
5.1.62 works all right.
In 5.2 line, it started between 5.2.7 and 5.2.8 – 5.2.7 works fine, 5.2.8 does not.
MySQL 5.5.21 works okay.

We looked into a similar problem some time ago, see bug #904097. That time it was deduced that starting from 5.2.8, server applies stricter requirements to handshake packets and does not accept what it finds malformed, as it did in versions 5.2.7 and earlier. Manifestation of the problem is similar to what is described here, so it may be the same, or have the same root cause.

Bug #904097 was closed because the problem had already been fixed on the client side. This time, the client is mysql-proxy of the latest version (I tried the binary package), so it's probably hard to expect that it will be fixed there.

Comment by Bernhard Valenti (Inactive) [ 2012-04-18 ]

Re: Bad handshake error when using 5.5.23 with mysql-proxy
Is there any easy way I can test that fix?

Comment by Sergei Golubchik [ 2012-04-19 ]

Re: Bad handshake error when using 5.5.23 with mysql-proxy
you can apply the patch to your tree. Here it is:

http://bazaar.launchpad.net/~maria-captains/maria/5.2-serg/revision/3138

Comment by Rasmus Johansson (Inactive) [ 2012-04-19 ]

Launchpad bug id: 982664

Generated at Thu Feb 08 06:49:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.