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

Maxscale doesn't match regex user's host

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 6.3.1
    • 6.3.1
    • mariadbbackend
    • Red Hat Enterprise Linux release 8.6 (Ootpa)
    • MXS-SPRINT-164, MXS-SPRINT-165

    Description

      Hi Team,

      When I try to connect from host "maxscalecrit2.test.mariadb.it" to our database with user 'ejbca_text'@'max%' we receive: 'access denied'.

      1. mysql -u ejbca_text -p'xxx' -h 'maxscalecrit2.test.mariadb.it' -P4006 -e "select @@hostname;"
        ERROR 1927 (HY000) at line 1: Authentication to 'server1' failed: 1698, #28000: Access denied for user 'ejbca_text'@'ip-172-31-25-182.ec2.internal' (server1)

      Here I have attached my config file for your reference please check it..

      MariaDB user details..

      MariaDB [(none)]> select user,host from mysql.user;
      +--------------+-----------+
      | User         | Host      |
      +--------------+-----------+
      | mariadb_test | %         |
      | max_user     | %         |
      | mariadb.sys  | localhost |
      | mysql        | localhost |
      | root         | localhost |
      | ejbca_text        | max%      |
      +--------------+-----------+
      6 rows in set (0.001 sec)
      

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.