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

MaxScale failed to login mysql user with empty password

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.4
    • Fix Version/s: None
    • Component/s: Authenticator
    • Labels:
      None

      Description

      Reproduce steps:
      1.Set mysql default auth plugin to caching_sha2_password.
      2.create user 'nopass'@'%' identified with mysql_native_password by '';
      3. login with -u nopass.

      Reason:
      The function send_mysql_native_password_response didn't handle user with empty password, it just add a 20-bytes scramble regardless of whether the password is null.

      Solve:
      After add some ugly code(see attachment), it worked for me.

        Attachments

          Activity

            People

            Assignee:
            esa.korhonen Esa Korhonen
            Reporter:
            bookding Kevin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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