[MXS-3261] password will be changed every login time Created: 2020-10-27  Updated: 2021-08-02  Resolved: 2021-08-02

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

Type: Bug Priority: Major
Reporter: ZhenweiYang Assignee: Esa Korhonen
Resolution: Cannot Reproduce Votes: 0
Labels: expected, hashcode
Environment:

centos 7.6



 Description   

HI All,
I am confusing by the issue.

My maxscale version is 2.5.5,
when I login with the correct password by DBeaver 7.2.2 (mysql jdbc 5.1.48 ), I got the same error: Access denied for user xxx

I checked log and found that the password is changing every time when I login.

And every thing is ok when use maxscale 2.4.1.

How I can fix this issue ? or any jdbc parameters control this?

[root@db_1111_middle_02-210-37 maxscale]# maxscale -V
MaxScale 2.5.5 - 91c3b76195d0057ddbe572bbb8d17f6ac6b09d5e
CMake flags: -DBUILD_TESTS=N -DBUILD_MMMON=Y -DBUILD_CDC=Y -DBUILD_GUI=Y -DPACKAGE=Y -DDISTRIB_SUFFIX=rhel.7
 
2020-10-27 16:45:15 info : (2) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 16:45:15 warning: (2) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash D3F74539A8551F9E63802480A1CED6F100145437, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 16:45:15 info : (session_free): Stopped EC-Read-Write-Service client session [2]
2020-10-27 16:45:15 info : (update_users): Read 31 user@host entries from 'EC-server1' for service 'EC-Read-Write-Service'. The data was identical to existing user data.
2020-10-27 16:45:21 info : (3) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 16:45:21 warning: (3) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash 477016F41A29F2EB2597BEABD5C9CB0278ACCA4B, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 17:15:02   info   : (session_free): Stopped EC-Read-Write-Service client session [10]
2020-10-27 17:15:05   info   : (fetch_server_variables): Server variables loaded from 'EC-server1', next update in 600 seconds.
2020-10-27 17:15:15   info   : (update_users): Read 31 user@host entries from 'EC-server1' for service 'EC-Read-Write-Service'. The data was identical to existing user data.
2020-10-27 17:16:29   info   : (11) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 17:16:29   warning: (11) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash 5F0BD0F687AF6C119FDE3B844291712AF04751B0, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 17:16:29   info   : (session_free): Stopped EC-Read-Write-Service client session [11]
2020-10-27 17:16:29   info   : (update_users): Read 31 user@host entries from 'EC-server1' for service 'EC-Read-Write-Service'. The data was identical to existing user data.
2020-10-27 17:17:42   info   : (12) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 17:17:42   warning: (12) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash DBF0EE2C16472D079C67B512237D7C59CB4B7E6A, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 17:17:42   info   : (session_free): Stopped EC-Read-Write-Service client session [12]
2020-10-27 17:17:42   info   : (update_users): Read 31 user@host entries from 'EC-server1' for service 'EC-Read-Write-Service'. The data was identical to existing user data.
2020-10-27 17:17:50   info   : (13) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 17:17:50   warning: (13) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash 3A6550232EA534691F195E534BA782A00B5F77D8, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 17:17:50   info   : (session_free): Stopped EC-Read-Write-Service client session [13]
2020-10-27 17:17:53   info   : (14) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 17:17:53   warning: (14) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash 0F4A92324880AB377F93A7B6544220DF49B82AFD, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 17:17:53   info   : (session_free): Stopped EC-Read-Write-Service client session [14]
2020-10-27 17:18:12   info   : (update_users): Read 31 user@host entries from 'EC-server1' for service 'EC-Read-Write-Service'. The data was identical to existing user data.



 Comments   
Comment by markus makela [ 2020-10-27 ]

It looks like the client application is seding a different password every time it connects. Can you reproduce this with the MariaDB JDBC connector?

Comment by ZhenweiYang [ 2020-10-27 ]

@markus you are right
I had tested mariadb jdbc 2.4.3 , it works find.
In addition, I try mysql jdbc 5.1.48 and latest 8.x, the same issue as above.

In other words, I need to replace mysql jdbc with mariadb driver for my APP.

Oh no

Comment by markus makela [ 2020-11-09 ]

esa.korhonen I'll assign this to you since you already fixed something related to this. If this is a duplicate, you can close it.

Comment by markus makela [ 2021-08-02 ]

Closing as Cannot Reproduce as we haven't received any feedback on whether the more recent fixes in 2.5 solve this. If you can reproduce this with the latest 2.5 release, we'll reopen this issue.

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