Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.2
-
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.