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

When using .net program to connect to maxscale, it prompts authentication failure (occasionally)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 2.5.5
    • N/A
    • Authenticator
    • Development tools: netcore3.1
      Framework: sqlsugar 5.0.1,
      Database connection driver: mysql8.0.22
      mysql version: mysql8.0.16
      maxscale version: maxscale 2.5.5

    Description

      When the .net programs are directly connected to the mysql database, all are normal, and there is no error reported for 1 million pressure tests, but the following errors are occasionally reported when connecting through maxscale:
      SqlSugar.SqlSugarException: English Message : Connection open error . Authentication method '' not supported by any of the available plugins.
      Chinese Message : 连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,实在找不到原因请先Google错误信息:Authentication method '' not supported by any of the available plugins..
      at SqlSugar.AdoProvider.GetDataSetAll(String sql, SugarParameter[] parameters)
      at SqlSugar.AdoProvider.GetDataTable(String sql, SugarParameter[] parameters)
      at IM.Admin.Controllers.TestController.getUser() in /home/jenkins/agent/workspace/Dev-YallaChat-NetCore-Admin-Build/IM.Admin/Controllers/TestController.cs:line 29

      执行SQL错误:English Message : Connection open error . Authentication to host '192.168.1.x' for user 'ht_v1' using method 'mysql_native_password' failed with message: Bad handshake
      Chinese Message : 连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,实在找不到原因请先Google错误信息:Authentication to host '192.168.1.x' for user 'ht_v1' using method 'mysql_native_password' failed with message: Bad handshake. | select ui.user_id,ui.user_name,ui.id from iden_account ia
      left join user_info as ui on ia.id = ui.user_id |

      The mysql user account uses the standard authentication method:mysql_native_password

      Not sure of the cause of the problem, please help

      Attachments

        1. 20201223140924.png
          20201223140924.png
          53 kB
        2. 20201223140856.png
          20201223140856.png
          47 kB
        3. 20201223140629.png
          20201223140629.png
          93 kB
        4. 20201223140604.png
          20201223140604.png
          70 kB

        Activity

          People

            Unassigned Unassigned
            shan he
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.