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

password will be changed every login time

    XMLWordPrintable

    Details

      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.
      

        Attachments

          Activity

            People

            Assignee:
            esa.korhonen Esa Korhonen
            Reporter:
            Jenvid ZhenweiYang
            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.