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

Maxscale 2.5 not handle single quotes via mysql client throw incorrect "Access denied error"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 2.5.10, 2.5
    • N/A
    • N/A

    Description

      Connecting via mysql client, where the arguments will be wrapped into backticks leads to not valid
      "Access not ednied "error.

      To reproduce:

      Use docker-.compose setup

      https://github.com/mariadb-corporation/maxscale-docker

      Change maxscale version in docker-compose.yml from 2.4 to 2.5

      With backticks... it throws an error

      ~/mt2/maxscale-docker/maxscale$ mysql -u maxuser -h'127.0.0.1' -p'maxpwd' -P4006 -D'test'
      ERROR 1045 (28000): Access denied for user 'maxuser'@'::ffff:192.168.112.1' (using password: YES)
      

      Without backticks, it works without issue.

      ~/mt2/maxscale-docker/maxscale$ mysql -u maxuser -h127.0.0.1 -pmaxpwd -P4006 -Dtest
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 4
      Server version: 10.3.5-MariaDB-10.3.5+maria~jessie-log mariadb.org binary distribution
      

      Note:

      It works with 22.4 without issue also with backticks.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Richard Richard Stracke
              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.