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

Add caching_sha2_password Support in MaxScale

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • Authenticator
    • None

    Description

      MaxScale currently does not support MariaDB users using the caching_sha2_password authentication plugin.

      When a user is changed from mysql_native_password to caching_sha2_password, connections through MaxScale fail with:

      ERROR 1045 (28000): Access denied
      

      MaxScale logs show:

      Authentication plugin error.

      Last error: Error from 'server1': Authentication plugin error.
      

      Steps to Reproduce

      1. Create a MariaDB user using mysql_native_password.
      2. Confirm that the user can connect through MaxScale.
      3. Change the user to caching_sha2_password.
      4. Reload the MaxScale service.
      5. Try connecting through the MaxScale listener.
      6. The connection fails with an authentication error.

      Attachments

        Activity

          People

            Unassigned Unassigned
            pramod.mahto@mariadb.com Pramod Mahto
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.