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

MaxScale logs a warning when users are loaded from a Xpand cluster

    XMLWordPrintable

Details

    • MXS-SPRINT-148

    Description

      When MaxScale loads users from a Xpand cluster, the following warning is logged for the service user even it the grants are correct.

       Service user 'maxskysql' of service 'RCR' does not have 'SHOW DATABASES' or a similar global privilege on '@@Xpand-Monitor:node-1'. This may cause authentication errors on clients logging in to a specific database.
      

      The reason this happens is that the result for SELECT CURRENT_USER() differs between Xpand and MariaDB:

      Xpand: 
       
      MySQL [(none)]> select current_user();
      +--------------------+
      | current_user()     |
      +--------------------+
      | 'root'@'127.0.0.1' |
      +--------------------+
      1 row in set (0.00 sec)
       
       
      MariaDB:
       
      MariaDB [test]> select current_user();
      +-------------------+
      | current_user()    |
      +-------------------+
      | maxuser@127.0.0.1 |
      +-------------------+
      1 row in set (0.000 sec)
      

      Xpand quotes the values whereas MariaDB does not.

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.