[MXS-3351] When using .net program to connect to maxscale, it prompts authentication failure (occasionally) Created: 2020-12-23  Updated: 2021-08-25  Resolved: 2021-08-25

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.5.5
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: he Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: .net, authentication, maxscale, mysql_native_password
Environment:

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


Attachments: PNG File 20201223140604.png     PNG File 20201223140629.png     PNG File 20201223140856.png     PNG File 20201223140924.png    

 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



 Comments   
Comment by markus makela [ 2021-08-02 ]

Have you tried this with the latest 2.5 release? I think we might have fixed this.

Comment by markus makela [ 2021-08-25 ]

I'll close this as a potential Duplicate as it's possible this has been fixed in a more recent release.

Generated at Thu Feb 08 04:20:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.