Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3110

bad handshake error in maxscale 2.5.1

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.1
    • Fix Version/s: 2.5.4
    • Labels:
      None
    • Environment:
      Running rhel 7.8, php 7.1.30 from redhat software collections with mariadb 10.1 backends

      Description

      When attempting to connect to a db using php with either mysqli or PDO I get the errors

      Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1043] Bad handshake in /opt/app/etddev/releases/20200710192026/www/test1.php:4 Stack trace: #0 /opt/app/etddev/releases/20200710192026/www/test1.php(4): PDO->__construct('mysql:host=maxs...', '****', '*****') #1

      {main}

      thrown in /opt/app/etddev/releases/20200710192026/www/test1.php on line 4

      And

      Warning: mysqli::__construct(): (HY000/1043): Bad handshake in /opt/app/etddev/releases/20200710192026/www/test.php on line 11
      Connection failed: Bad handshake

      receptively

      This is my config file

      [maxscale]
      threads=auto
      admin_host=0.0.0.0
      admin_secure_gui=false
      log_debug=1

      [mysqlcl-dev01]
      type=server
      address=10.76.10.171
      port=3306
      protocol=MariaDBBackend

      [mysqlcl-dev02]
      type=server
      address=10.76.10.172
      port=3306
      protocol=MariaDBBackend

      [mysqlcl-dev03]
      type=server
      address=10.76.10.173
      port=3306
      protocol=MariaDBBackend

      [Galera-Monitor]
      type=monitor
      module=galeramon
      servers=mysqlcl-dev01,mysqlcl-dev02,mysqlcl-dev03
      user=monitor_user
      password=************
      monitor_interval=2000ms

      [Splitter-Service]
      type=service
      router=readwritesplit
      servers=mysqlcl-dev01,mysqlcl-dev02,mysqlcl-dev03
      user=maxscale
      password=***************
      master_failure_mode=fail_on_write
      master_reconnection=true

      [Splitter-Listener]
      type=listener
      service=Splitter-Service
      protocol=MariaDBClient
      #protocol=MariaDBBackend
      address=0.0.0.0
      port=3306

      We are attempting to switch from haproxy to maxscale after talk from your people

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              esa.korhonen Esa Korhonen
              Reporter:
              thaylin Christopher E Bowen
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration