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

Maxscale selecting extra whitespace while loading users

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.3
    • Fix Version/s: 2.1.5
    • Component/s: Core
    • Labels:
      None

      Description

      Maxscale selecting extra whitespce while loading users when sql_mode=PAD_CHAR_TO_FULL_LENGTH.

      MariaDB [(none)]> show global variables like 'sql_mode';
      +---------------+---------------------+
      | Variable_name | Value               |
      +---------------+---------------------+
      | sql_mode      | STRICT_TRANS_TABLES |
      +---------------+---------------------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> 
      MariaDB [(none)]> select user, host from mysql.user;
      +----------------------------------------------------------------------------------+--------------------------------------------------------------+
      | user                                                                             | host                                                         |
      +----------------------------------------------------------------------------------+--------------------------------------------------------------+
      | maxscale                                                                         | %                                                            |
      | root                                                                             | %                                                            |
      | msandbox                                                                         | 127.%                                                        |
      ...
      | root                                                                             | localhost                                                    |
      +----------------------------------------------------------------------------------+--------------------------------------------------------------+
      10 rows in set (0.01 sec)
      

      Maxscale error log,

       
      [root@centos68 ~]# mysql -umaxscale -h127.0.0.1 -p -P4006
      Enter password: 
      ERROR 1045 (28000): Access denied for user 'maxscale'@'127.0.0.1' (using password: YES)
      [root@centos68 ~]# 
       
      [root@centos68 ~]# tail -f /var/log/maxscale/maxscale.log 
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('maxscale                                                                        ', '%                                                           ', NULL, 1, '53E5D0C7885BD540911663B04133F20C94AD4306')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('msandbox                                                                        ', '127.%                                                       ', NULL, 1, '6C387FC3893DBA1E3BA155E74754DA6682D04747')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('msandbox                                                                        ', 'localhost                                                   ', NULL, 1, '6C387FC3893DBA1E3BA155E74754DA6682D04747')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('msandbox_rw                                                                     ', 'localhost                                                   ', NULL, 1, '6C387FC3893DBA1E3BA155E74754DA6682D04747')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('msandbox_rw                                                                     ', '127.%                                                       ', NULL, 1, '6C387FC3893DBA1E3BA155E74754DA6682D04747')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('msandbox_ro                                                                     ', '127.%                                                       ', NULL, 1, '6C387FC3893DBA1E3BA155E74754DA6682D04747')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('msandbox_ro                                                                     ', 'localhost                                                   ', NULL, 1, '6C387FC3893DBA1E3BA155E74754DA6682D04747')
      2017-06-18 00:41:27   info   : [MySQLAuth] Added user: INSERT OR REPLACE INTO mysqlauth_users VALUES ('rsandbox                                                                        ', '127.%                                                       ', NULL, 0, 'B07EB15A2E7BD9620DAE47B194D5B9DBA14377AD')
      2017-06-18 00:41:27   notice : [MySQLAuth] [Read-Write Service] Loaded 8 MySQL users for listener Read-Write Listener.
      2017-06-18 00:41:27   warning: [MySQLAuth] Read-Write Service: login attempt for user 'maxscale'@[127.0.0.1]:51584, authentication failed.
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            niljoshi Nilnandan Joshi
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration