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

mysql shell client can't connect to maxscale

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 1.0.5
    • Fix Version/s: 1.1.0
    • Component/s: Core
    • Labels:
      None
    • Environment:
      Ubuntu 14.04
      MariaDB 10.0.0.17 / Galera

      Description

      I just moved from haproxy to maxscale in front of a 3 node mariadb 10.0.17 galera cluster.
      Now it seems the mysql shell client is broken, when connecting to maxscale:

      mysql -utestuser -ppassword -h mysql.local.net mydatabase -e "show tables;"

      ERROR 1045 (28000): Access denied for user 'root'@'192.168.111.31' (using password: YES) to database 'mydatabase'

      when i connect to one of the mariadb servers directly it works:

      mysql -utestuser -ppassword -h mysql1.local.net mydatabase -e "show tables;"

      --------------------------

      Tables_in_mydatabase

      --------------------------

      table1
      table2

      --------------------------

      Whats the problem here?

      In skygw_msg1.log i also found some entries like:

      "2015-03-16 15:09:01 Galera Service: login attempt for user testuser, user not found."

        Attachments

          Activity

            People

            Assignee:
            Massimiliano Pinto Massimiliano Pinto (Inactive)
            Reporter:
            monotek André Bauer
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.