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

In Maxscale 2.2.2 getting users with native password from mysql backends does not work

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.2
    • Fix Version/s: 2.2.3
    • Component/s: Authenticator
    • Labels:
    • Environment:
      Ubuntu 16.04 with latest Maxscale 2.2.2

      Description

      Hi,

      In Maxscale 2.2.2 getting users with native password from mysql backends does not work. As you can see here: https://github.com/mariadb-corporation/MaxScale/blob/2.2.2/server/modules/authenticator/MySQLAuth/dbusers.c new query for getting users (for Mysql > 5.7) is

      SELECT u.user, u.host, d.db, u.select_priv, u.authentication_string
          FROM mysql.user AS u LEFT JOIN mysql.db AS d
          ON (u.user = d.user AND u.host = d.host) WHERE u.plugin = ''
          UNION
          SELECT u.user, u.host, t.db, u.select_priv, u.authentication_string
          FROM mysql.user AS u LEFT JOIN mysql.tables_priv AS t
          ON (u.user = t.user AND u.host = t.host) WHERE u.plugin = '';
      

      This part is added (this was not in 2.1.x versions): WHERE u.plugin = ''

      And in my user.plugin column all users have 'mysql_native_password' value, so maxscale does not get them and 'maxadmin show dbusers <service-name>' is always empty so my clients can't connect to DB through maxscale.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                markus makela markus makela
                Reporter:
                Petanjek Goran
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: