Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
2.5.5
-
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
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
.net的程序直连到mysql数据库时全部正常，压测100万次请求无报错，但通过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.208' for user 'ht_v1' using method 'mysql_native_password' failed with message: Bad handshake Chinese Message : 连接数据库过程中发生错误，检查服务器是否正常连接字符串是否正确，实在找不到原因请先Google错误信息：Authentication to host '192.168.1.208' 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 | 用户账号使用的是标准验证方式：mysql_native_password |
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 | 用户账号使用的是标准验证方式：mysql_native_password |
| Environment |
开发工具：netcore3.1
框架：sqlsugar 5.0.1, 数据库连接驱动：mysql8.0.22 mysql版本：mysql8.0.16 maxscale版本：maxscale 2.5.5 |
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 |
| Summary | 使用.net程序连接到maxscale时提示身份验证失败（偶现） | When using .net program to connect to maxscale, it prompts authentication failure (occasionally) |
| Attachment | 微信图片_20201223140604.png [ 55442 ] |
| Attachment | 微信图片_20201223140856.png [ 55440 ] |
| Attachment | 微信图片_20201223140629.png [ 55441 ] |
| Attachment | 微信图片_20201223140924.png [ 55439 ] |
| Attachment | 20201223140604.png [ 55443 ] | |
| Attachment | 20201223140629.png [ 55444 ] | |
| Attachment | 20201223140856.png [ 55445 ] | |
| Attachment | 20201223140924.png [ 55446 ] |
| 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 | 用户账号使用的是标准验证方式：mysql_native_password |
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 |
| Epic/Theme | service |
| Rank | Ranked higher |
| Rank | Ranked lower |
| Priority | Blocker [ 1 ] | Minor [ 4 ] |
| Rank | Ranked lower |
| Rank | Ranked higher |
| Fix Version/s | Icebox [ 22648 ] |
| Rank | Ranked higher |
I'll close this as a potential Duplicate as it's possible this has been fixed in a more recent release.
| Fix Version/s | N/A [ 22001 ] | |
| Fix Version/s | Icebox [ 22648 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 117314 ] | MariaDB v4 [ 139075 ] |
Have you tried this with the latest 2.5 release? I think we might have fixed this.