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

Regression: Error "authentication failed. Unknown database" when DB specified while connecting with rwsplit router

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: xpandmon
    • Labels:
    • Environment:

      Description

      [root@karma182 ~]# maxctrl list servers
      ┌───────────────────────────┬─────────────┬──────┬─────────────┬─────────────────┬──────┐
      │ Server                    │ Address     │ Port │ Connections │ State           │ GTID │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ @@Cluster-Monitor:node-2  │ 10.2.15.89  │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ @@Cluster-Monitor:node-3  │ 10.2.15.180 │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ @@Cluster-Monitor:node-1  │ 10.2.13.91  │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ @@Cluster-Monitor1:node-2 │ 10.2.15.75  │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ @@Cluster-Monitor1:node-3 │ 10.2.12.218 │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ @@Cluster-Monitor1:node-1 │ 10.2.15.40  │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ BS1                       │ 10.2.13.91  │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ BS4                       │ 10.2.15.40  │ 3306 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ MBS                       │ 127.0.0.1   │ 4006 │ 0           │ Master, Running │      │
      ├───────────────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤
      │ MBS2                      │ 127.0.0.1   │ 4007 │ 0           │ Slave, Running  │      │
      └───────────────────────────┴─────────────┴──────┴─────────────┴─────────────────┴──────┘
      

      [root@vqc008c vqc008c]# mysql -h karma182 -umaxscale -pmaxscale_pw -P 4008 test
      mysql: [Warning] Using a password on the command line interface can be insecure.
      ERROR 1049 (42000): Unknown database 'test'
      

      If connection is created without specifying the DB, it works.

      [root@vqc008c vqc008c]# mysql -h karma182 -umaxscale -pmaxscale_pw -P 4008
      mysql: [Warning] Using a password on the command line interface can be insecure.
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 9
      Server version: 5.5.5-10.2.12 2.4.1-maxscale
       
      Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
       
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      mysql> use test;
      Database changed
      

      karma136 has older MaxScale server installed and run with same conf file as karma182.

      [root@karma136 ~]# maxscale -V
      MaxScale 2.4.1 - 3940547cc20a15af0a8c420b55fe0cf39bdc4549
      

      The same works on that version:

       [root@vqc008c vqc008c]# mysql -h karma136 -umaxscale -pmaxscale_pw -P 4008 test
      mysql: [Warning] Using a password on the command line interface can be insecure.
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 15
      Server version: 5.0.45-clustrix-elk-14841
       
      Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
       
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      mysql> select @@version;
      +---------------------------------+
      | @@version                       |
      +---------------------------------+
      | 5.0.45-clustrix-fredonyer-16045 |
      +---------------------------------+
      1 row in set (0.01 sec)
      

      It seems to be looking for mysql tables:

      2019-08-15 06:13:04   info   : (4) [readwritesplit] Session command no. 2 failed: #HY000: [8192] Relation not found: "mysql"."roles_mapping"
      2019-08-15 06:13:04   info   : (4) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 14, type: QUERY_TYPE_SESSION_WRITE, stmt: USE mysql
      2019-08-15 06:13:04   info   : (4) [readwritesplit] Session write, routing to all servers.
      2019-08-15 06:13:04   info   : (4) [readwritesplit] Route query to master: @@Cluster-Monitor:node-1     [10.2.13.91]:3306
      2019-08-15 06:13:04   info   : (4) [readwritesplit] Reply complete, last reply from @@Cluster-Monitor:node-1
      2019-08-15 06:13:04   info   : (4) [readwritesplit] Session command no. 3 failed: #42000: [11267] No such database: "mysql"
      2019-08-15 06:13:04   error  : (3) [MariaDBAuth] Failed to load users from server 'MBS': [11267] No such database: "mysql"
      

      ERROR:

      2019-08-15 06:13:04   warning: (3) [MariaDBAuth] Read-Write-Service_rwsrvc: login attempt for user 'maxscale'@[::ffff:10.2.14.197]:38730, authentication failed. Unknown database: test
      

      Log and cnf file attached.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            rahul.joshi@mariadb.com Rahul Joshi
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration