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

before upgrade to 2.3, all works well ,after upgrade maxscale to 2.3.7,some programing drivers can not work well

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.1, 2.3.5
    • Fix Version/s: 2.2.22, 2.3.8
    • Component/s: Protocol
    • Labels:
      None

      Description

      mysql 5.7 client work ok as follows

      mysql 5.1 client not work well

      harbor 1.3 which write in go , report error as follows

      ####
      May 25 11:37:27 172.20.0.1 jobservice[785]: 2019-05-25T03:37:27Z [FATAL] [main.go:41]: failed to initialize database: register db Ping `default`, This server only supports the insecure old password authentication. If you still want to use it, please add 'allowOldPasswords=1' to your DSN. See also https://github.com/go-sql-driver/mysql/wiki/old_passwords
      May 25 11:37:27 172.20.0.1 jobservice[785]: [ORM]register db Ping `default`, This server only supports the insecure old password authentication. If you still want to use it, please add 'allowOldPasswords=1' to your DSN. See also https://github.com/go-sql-driver/mysql/wiki/old_passwords
      ####
      *

      php report as follows*

      Failed to issue SQL query: query = SET NAMES 'utf8' COLLATE 'utf8_unicode_ci', mysql_error = Bad handshake, mysql_errno = 1045.

      node report as follows

      MySQL server is requesting the old and insecure pre-4.1 auth mechanism.Upgrade the user password or use the

      {insecureAuth: true}

      option

      Other tools

        Attachments

        1. image-2019-05-29-16-11-58-689.png
          94 kB
          xqzt
        2. image-2019-05-29-16-13-28-344.png
          427 kB
          xqzt
        3. screenshot-1.png
          8 kB
          xqzt
        4. screenshot-2.png
          129 kB
          xqzt

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            xqzt xqzt
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration