[MXS-2064] Loading of users with MariaDB 10.2.10 fails Created: 2018-09-20  Updated: 2018-09-21  Resolved: 2018-09-21

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.2.14
Fix Version/s: 2.2.15

Type: Bug Priority: Minor
Reporter: Kyle Joiner (Inactive) Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-13453 Executing a query via CTE requires mo... Closed

 Description   

When Maxscale logs an error that is server specific add the server name to the error:

For Example:
2018-09-20 12:07:55 error : [MySQLAuth] Failed to load users: SELECT command denied to user 'maxscale'@'xxxx' for table 'users'
2018-09-20 12:07:55 error : [MySQLAuth] Failed to load users: SELECT command denied to user 'maxscale'@'xxxx' for table 'users'
2018-09-20 12:07:55 error : [MySQLAuth] Failed to load users: SELECT command denied to user 'maxscale'@'xxxx' for table 'users'

Would be very useful to be:
2018-09-20 12:07:55 error : [MySQLAuth] Failed to load users: SELECT command denied to user 'maxscale'@'xxxx' for table 'users' on server 'xyz'

Please also note changing the table from 'users' to 'user' would also minimize some confusion.



 Comments   
Comment by markus makela [ 2018-09-21 ]

This is actually caused by a bug in MariaDB (MDEV-13453) versions prior to 10.2.11. The solution to the problem is to GRANT SELECT ON mysql.* TO 'maxscale'@'xxxx'.

Comment by markus makela [ 2018-09-21 ]

The server name is now logged with the user loading error message. In addition to this, a workaround to MDEV-13453 is logged as a message to help the user resolve issues with older versions.

Generated at Thu Feb 08 04:11:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.