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

MaxScale does not let mysql client 8.0.15 to connect with password

    Details

    • Sprint:
      MXS-SPRINT-77, MXS-SPRINT-78

      Description

      In the following simple setup with MariaDB 10.3.13 as a signle back end server:

      [maxscale]
      threads=auto
       
      ...
       
      [server3]
      type=server
      address=127.0.0.1
      port=3308
      protocol=MariaDBBackend
       
      ...
       
      [Monitor]
      type=monitor
      module=mariadbmon
      servers=server3
      user=myuser
      passwd=mypwd
      monitor_interval=100
       
      ...
       
      [RW-Service]
      type=service
      router=readwritesplit
      servers=server3
      user=myuser
      passwd=mypwd
      enable_root_user=1
       
      ...
       
      [RWS-Listener]
      type=listener
      service=RW-Service
      protocol=MariaDBClient
      port=4006
      address=127.0.0.1
       
      ...
      

      with a user defined as follows:

      MySQL [(none)]> select user, host, password from mysql.user where user like 'u1';
      +------+-----------+-------------------------------------------+
      | user | host      | password                                  |
      +------+-----------+-------------------------------------------+
      | u1   | localhost | *556BEF296211C2AF58F53DA3EDDD0A3371B6ECD5 |
      | u1   | %         | *556BEF296211C2AF58F53DA3EDDD0A3371B6ECD5 |
      +------+-----------+-------------------------------------------+
      2 rows in set (0.001 sec)
      

      MaxScale does NOT let user u1 to connect with password u1 when mysql client from version 8.0.15 is used. Check these:

      [openxs@fc23 maria10.3]$ bin/mysql -uu1 -pu1 --host=127.0.0.1 --port=4006
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MySQL connection id is 7
      Server version: 10.2.12 2.2.15-maxscale Source distribution
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MySQL [(none)]> select current_user();
      +----------------+
      | current_user() |
      +----------------+
      | u1@localhost   |
      +----------------+
      1 row in set (0.000 sec)
       
      MySQL [(none)]> select version();
      +-----------------+
      | version()       |
      +-----------------+
      | 10.3.13-MariaDB |
      +-----------------+
      1 row in set (0.000 sec)
       
      MySQL [(none)]> select @@port, @@socket;
      +--------+-------------------+
      | @@port | @@socket          |
      +--------+-------------------+
      |   3308 | /tmp/mariadb.sock |
      +--------+-------------------+
      1 row in set (0.000 sec)
       
      MySQL [(none)]> exit
      Bye
      [openxs@fc23 maria10.3]$ ../8.0/bin/mysql -uu1 -pu1 --host=127.0.0.1 --port=4006
      mysql: [Warning] Using a password on the command line interface can be insecure.
      ERROR 1045 (28000): Access denied for user 'u1'@'127.0.0.1' (using password: NO)
      [openxs@fc23 maria10.3]$ ../8.0/bin/mysql -uu1 -pu1 --host=127.0.0.1 --port=3308
      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 30
      Server version: 5.5.5-10.3.13-MariaDB Source distribution
       
      Copyright (c) 2000, 2019, 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 current_user();
      +----------------+
      | current_user() |
      +----------------+
      | u1@localhost   |
      +----------------+
      1 row in set (0.00 sec)
       
      mysql> \s
      --------------
      ../8.0/bin/mysql  Ver 8.0.15 for Linux on x86_64 (Source distribution)
       
      Connection id:          30
      Current database:
      Current user:           u1@localhost
      SSL:                    Not in use
      Current pager:          stdout
      Using outfile:          ''
      Using delimiter:        ;
      Server version:         5.5.5-10.3.13-MariaDB Source distribution
      Protocol version:       10
      Connection:             127.0.0.1 via TCP/IP
      Server characterset:    latin1
      Db     characterset:    latin1
      Client characterset:    latin1
      Conn.  characterset:    latin1
      TCP port:               3308
      Uptime:                 36 min 54 sec
       
      Threads: 8  Questions: 17017  Slow queries: 0  Opens: 22  Flush tables: 1  Open tables: 16  Queries per second avg: 7.686
      --------------
      

      Connection with mysql client from 10.3.13 works via MaxScale. Direct connection with mysql 8.0.15 client also works. Note "(using password: NO)" in the failed connection attempt. Looks like MaxScale for some reason does not pass the password while connecting to the back end.

        Attachments

          Activity

            People

            • Assignee:
              esa.korhonen Esa Korhonen
              Reporter:
              valerii Valerii Kravchuk
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: