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

Add permission for SHOW DATABASES for Xpand Service to work

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.1
    • 6.4.2
    • Documentation, xpandmon
    • 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.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            msnijjar Manjinder Nijjar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.