Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.1.3
-
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.
|