Details
-
New Feature
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Won't Do
-
None
-
None
Description
Overview
Adding a dummy response to SHOW GRANTS allows monyog to monitor MaxScale.
Original description
In order to get external tool that monitor Mysql compatible with maxscale instance, we need to have the command :
"show grants;" get a result while we query [MaxInfo]
maxscale ~]$ mysql -u monitor -h 127.0.0.1 -p -P9003
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 22785
Server version: 10.0.0 2.1.5-maxscale 2.1.5
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> show grants;
ERROR: Unsupported show command 'grants'
MySQL [(none)]>
[MaxInfo]
type=service
router=maxinfo
user=monitor