Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.4.1
-
None
-
three node Xpand 6.0.5 with Maxscale 6.4.1
-
MXS-SPRINT-165
Description
We should add following permission as a must have for Xpand service to work. Without it, tools like sysbench throw "Unknown database" error even though database exists on Xpand backend.
I could not find this permission in the required grants in the docs.
grant SHOW DATABASES on *.* to maxscale@'maxscalehost';
|
I get following error when I run Sysbench via maxscale on Xpand (without SHOW DATABASES) even though database exists on the server:
2022-08-24 19:46:32 info : (43) Found matching user entry 't1'@'vqc008a.colo.sproutsys.com' for client 't1'@'10.2.14.193' but user tried to access non-existing database 'sysbench'.
|
2022-08-24 19:46:32 warning: (49) [MariaDBProtocol] Authentication failed for user 't1'@[10.2.14.193] to service 'Read-Only-Service'. Originating listener: 'Read-Only-Listener'. MariaDB error: 'Unknown database 'sysbench''.
|
Database Exists on Xpand server:
MySQL [(none)]> show databases;
|
+--------------------+
|
| Database |
|
+--------------------+
|
| information_schema |
|
| sysbench |
|
| test |
|
+--------------------+
|
3 rows in set (0.01 sec)
|
All tools work fine once SHOW DATABASE permissions are granted.