[MXS-288] Error on login for Mysql >= 5.7.6 Created: 2015-07-27  Updated: 2017-12-01  Resolved: 2015-11-12

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 1.2.1
Fix Version/s: 1.3.0

Type: New Feature Priority: Major
Reporter: Fustini Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None
Environment:

Maxscale 1.2.1 , Mysql >= 5.7.6 Linux (inside docker)


Issue Links:
Duplicate
is duplicated by MXS-341 MaxScale won't work on MySQL 5.7 due ... Closed

 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."



 Comments   
Comment by Dipti Joshi (Inactive) [ 2015-07-27 ]

Thank you for trying MaxScale with MySQL 5.7.6

MaxScale will be tested with MySQL 5.7 when it goes GA.
Currently MySQL 5.7 is not officially supported for MaxScale, all though will be after MySQL 5.7 goes GA.

Comment by markus makela [ 2015-11-12 ]

MaxScale now supports the 5.7 layout of the mysql.user table.

Generated at Thu Feb 08 03:58:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.