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

Error on login for Mysql >= 5.7.6

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.1
    • 1.3.0
    • Core
    • 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

          Activity

            People

              markus makela markus makela
              Alessandro Fustini
              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.