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

Password field still used with MySQL 5.7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.4.1
    • 1.4.2
    • Core
    • 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)

      Attachments

        Activity

          People

            markus makela markus makela
            osteenbergen Onno Steenbergen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.