Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3579

LP:982664 - Bad handshake error when using 5.5.23 with mysql-proxy

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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)

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            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.

            Show
            elenst Elena Stepanova added a comment - 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.
            Hide
            bernhardvalenti Bernhard Valenti added a comment -

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

            Show
            bernhardvalenti Bernhard Valenti added a comment - Re: Bad handshake error when using 5.5.23 with mysql-proxy Is there any easy way I can test that fix?
            Hide
            serg Sergei Golubchik added a comment -

            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

            Show
            serg Sergei Golubchik added a comment - 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
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 982664

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 982664

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                bernhardvalenti Bernhard Valenti
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: