Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.5.17
-
None
-
MXS-SPRINT-148
Description
When MaxScale loads users from a Xpand cluster, the following warning is logged for the service user even it the grants are correct.
Service user 'maxskysql' of service 'RCR' does not have 'SHOW DATABASES' or a similar global privilege on '@@Xpand-Monitor:node-1'. This may cause authentication errors on clients logging in to a specific database.
|
The reason this happens is that the result for SELECT CURRENT_USER() differs between Xpand and MariaDB:
Xpand:
|
|
MySQL [(none)]> select current_user();
|
+--------------------+
|
| current_user() |
|
+--------------------+
|
| 'root'@'127.0.0.1' |
|
+--------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB:
|
|
MariaDB [test]> select current_user();
|
+-------------------+
|
| current_user() |
|
+-------------------+
|
| maxuser@127.0.0.1 |
|
+-------------------+
|
1 row in set (0.000 sec)
|
Xpand quotes the values whereas MariaDB does not.