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

access denied Intermittently for a particular user while trying to connect through Maxscale.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.2, 2.4.6
    • Fix Version/s: 2.4.8
    • Component/s: mariadbmon
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-100, MXS-SPRINT-101

      Description

      Setup : Master --> Slave

      The passwords for users in the database are the same on all nodes. Still authentication issue for user access denied intermittently for this particular user while trying to connect through Maxscale.

      Scenario :-

      Scenario 1 with ID testuser: Updated the application configuration to connect to database through maxscale (UserID & Password not changed, only IP/SLB) - Intermittent Access Denied Issue
      

      Scenario 2 with ID testuser: Updated the application configuration to connect to database directly i.e Master Server xxx.xxx.xxx.xxx (UserID & Password not changed, only IP/SLB) - No Issue
      
      

      Scenario 3 with ID testuser02: Updated the application configuration to connect to database through maxscale (UserID & Password not changed, only IP/SLB) - Intermittent Access Denied Issue
      
      

      Scenario 4 with ID testuser02: Updated the application configuration to connect to database directly i.e Master Server xxx.xxx.xxx.xxx (UserID & Password not changed, only IP/SLB) - No Issue
      

      Direct Connection from App Server to Master and Slave

       
      mysql -h <Master-IP> -testuser02 -p -P 6603
      Enter password:
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 6170995
      Server version: 10.2.14-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]>
       
      -sh-4.2$ mysql -h <slave-IP> -testuser02 -p -P 6603
      Enter password:
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 343111
      Server version: 10.2.14-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]>
      
      

      Error log :-
      ---------------------------------------------------------------------------------------

       
      2020-02-05 20:20:55   notice : syslog logging is enabled.
      2020-02-05 20:20:55   notice : maxlog logging is enabled.
      2020-02-05 20:20:55   notice : Using up to 4.69GiB of memory for query classifier cache
      2020-02-05 20:20:55   notice : Working directory: /maxscale/logs/maxscale_logs
      2020-02-05 20:20:55   notice : The collection of SQLite memory allocation statistics turned off.
      2020-02-05 20:20:55   notice : Threading mode of SQLite set to Multi-thread.
      2020-02-05 20:20:55   notice : MariaDB MaxScale 2.4.6 started (Commit: 714dece7ddb025d2ed2cca945a607a02b80bc7a2)
      2020-02-05 20:20:55   notice : MaxScale is running in process 104967
      ..
      .....
      ........
      

      2020-02-11 13:28:14   warning: (218168) [MariaDBAuth] ReadWriteMasterService: login attempt for user 'XXXXXX'@[XX.XX.XXX.XXX]:XXXXX to database 'XXXX', authentication failed. Wrong password.
      

      Is this due to delay in validation of users at the backend from Maxscale or something else ?

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            pramod.mahto@mariadb.com Pramod Mahto
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: