Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
2.5.5
-
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.
|