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

mysql shell client can't connect to maxscale

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 1.0.5
    • 1.1.0
    • Core
    • None
    • 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

            Massimiliano Pinto Massimiliano Pinto (Inactive)
            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.