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

Authentication failed for older clients after upgrading to 2.5.4

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 2.5.4
    • N/A
    • Authenticator
    • None
    • centos 7, python MySQLdb 1.3.10

    Description

      after upgrading from 2.4 to 2.5 series of maxscale older clients get the following error:

      2020-10-02 14:48:29 warning: (7131) [mariadbclient] Authentication failed for user 'centralqueue'@[138.203.8.180] to service 'ReadSVC'. Originating listener: 'ReadLST-129'. MariaDB error: 'Access denied for user 'centralqueue'@'138.203.8.180' (using password: YES)'.

      downgrading to 2.4 solves the problem

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          markus makela markus makela added a comment -

          What connector do you use?

          markus makela markus makela added a comment - What connector do you use?
          Maikel Punie Maikel Punie added a comment - - edited

          python MySQLdb 1.3.10

          Maikel Punie Maikel Punie added a comment - - edited python MySQLdb 1.3.10
          markus makela markus makela added a comment -

          Can you execute SHOW GRANTS for that user?

          markus makela markus makela added a comment - Can you execute SHOW GRANTS for that user?
          Maikel Punie Maikel Punie added a comment -

          MariaDB [(none)]> show grants for centralqueue@'%';
          -------------------------------------------------------------------------------------------------------------

          Grants for centralqueue@%

          -------------------------------------------------------------------------------------------------------------

          GRANT USAGE ON . TO `centralqueue`@`%` IDENTIFIED BY PASSWORD '*9AEE5DB1EE0AB49373ADEAFBFCF8F0E4063F03A3'
          GRANT SELECT, EXECUTE, SHOW VIEW ON `regressiondb`.* TO `centralqueue`@`%`

          -------------------------------------------------------------------------------------------------------------
          2 rows in set (0.000 sec)

          Maikel Punie Maikel Punie added a comment - MariaDB [(none)] > show grants for centralqueue@'%'; ------------------------------------------------------------------------------------------------------------- Grants for centralqueue@% ------------------------------------------------------------------------------------------------------------- GRANT USAGE ON . TO `centralqueue`@`%` IDENTIFIED BY PASSWORD '*9AEE5DB1EE0AB49373ADEAFBFCF8F0E4063F03A3' GRANT SELECT, EXECUTE, SHOW VIEW ON `regressiondb`.* TO `centralqueue`@`%` ------------------------------------------------------------------------------------------------------------- 2 rows in set (0.000 sec)
          markus makela markus makela added a comment -

          Maikel Punie does this happen with the latest release?

          markus makela markus makela added a comment - Maikel Punie does this happen with the latest release?
          Maikel Punie Maikel Punie added a comment -

          with the latest version this seems to be solved

          Maikel Punie Maikel Punie added a comment - with the latest version this seems to be solved
          markus makela markus makela added a comment -

          Closing as this seems to have been fixed, as mentioned by Maikel Punie.

          markus makela markus makela added a comment - Closing as this seems to have been fixed, as mentioned by Maikel Punie .

          People

            Unassigned Unassigned
            Maikel Punie Maikel Punie
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.