[MXS-3928] MaxScale logs a warning when users are loaded from a Xpand cluster Created: 2021-12-22  Updated: 2022-01-12  Resolved: 2022-01-12

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.5.17
Fix Version/s: 2.5.18, 6.2.1

Type: Bug Priority: Minor
Reporter: markus makela Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Sprint: 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.
Generated at Thu Feb 08 04:24:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.