Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.1
-
None
-
Maxscale 1.2.1 , Mysql >= 5.7.6 Linux (inside docker)
Description
Hi,
when use Maxscale 1.2.1 and >= Mysql 5.7.6 on loggin from Maxscale an error is reported
MariaDB Corporation MaxScale /var/log/maxscale/error1.log Mon Jul 27 14:30:09 2015
-----------------------------------------------------------------------
— Logging is enabled.
2015-07-27 14:30:10 Error : Loading users for service [MyService] encountered error: [Unknown column 'user.password' in 'field list'].
2015-07-27 14:30:10 Error : Unable to load users from 0.0.0.0:4008 for service MyService.
2015-07-27 14:30:10 Error : Failed to start service 'MyService'.
2015-07-27 14:30:10 Error : Failed to start any MaxScale services. Exiting.
2015-07-27 14:30:10 MaxScale is shut down.
------------------------------------------------------
The MaxScale sql is wrong for table user on mysql from Mysql >= 5.7.6
(from mysql general log)
2015-07-27T14:56:26.014577Z 2 Query SELECT COUNT(1) AS nusers_db FROM (SELECT user.user AS user,user.host AS host,user.password AS password,concat(user.user,user.host,user.password,user.Select_priv,IFNULL(db,'')) AS userdata, user.Select_priv AS anydb,db.db AS db FROM mysql.user LEFT JOIN mysql.db ON user.user=db.user AND user.host=db.host WHERE user.user IS NOT NULL AND user.user <> '' ORDER BY host DESC) AS tbl_count
because mysql.user table use authentication_string instead password field
http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html ->
"The authentication_string column in the mysql.user table now stores credential information for all accounts.
The Password column, previously used to store password hash values for accounts authenticated with the mysql_native_password and mysql_old_password plugins, is removed."
Attachments
Issue Links
- is duplicated by
-
MXS-341 MaxScale won't work on MySQL 5.7 due to missing password column in mysql.user table
-
- Closed
-