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

"show dbusers ...service..." returns empty list when using PAMAuth

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.2.3
    • 2.2.4
    • Authenticator
    • None

    Description

      The PAM authenticator retrieves users from the MariaDB server side in a similar way as the MySQL authenticator, retrieving all candidate users from the MariaDB side mysql.user table, just restricting the related query to users with "WHERE plugin = 'pam'".

      So I'd expect it to return a list of users found this way on "show dbusers", but it just returns an empty list instead.

      Looking at the code I can see that MyQLAuth implements its own mysql_auth_diagnostics() and mysql_auth_diagnostic_json() functions, while PAMAuth just uses the default users_default_diagnostic() and users_default_diagnostic_json() implementations.

      Attachments

        Issue Links

          Activity

            People

              esa.korhonen Esa Korhonen
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.