Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.4.1
-
None
-
Debian GNU/Linux 8.2 (jessie)
MaxScale 1.4.1
MySQL 5.7.12-log
Description
2016-04-22 10:59:31 info : Started session [0] for Read-Only Service service
2016-04-22 10:59:31 error : Read-Write Service: Error: Failed to query from mysql.user table. MySQL error message: Unknown column 'password' in 'field list'
2016-04-22 10:59:31 debug : Dbusers : Loading data from backend database with Master role [10.0.3.26:3306] for service [Read-Write Service]
2016-04-22 10:59:31 error : Failed to retrieve database names:
2016-04-22 10:59:31 error : Read-Write Service: Unable to load database grant information, MaxScale authentication will proceed without including database permissions. See earlier error messages for user 'manager' for more information.
2016-04-22 10:59:31 debug : Loaded 0 MySQL Database Names for service [Read-Write Service]
In server/core/dbusers.c the function check_service_permissions still uses the hardcoded password field:
if (mysql_query(mysql, "SELECT user, host, password,Select_priv FROM mysql.user limit 1") != 0)