Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1750

Add SHOW GRANTS support to MaxInfo

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Trivial
    • Resolution: Won't Do
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: maxinfo
    • Labels:
      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

        Attachments

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            massimo.disaro Massimo
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.