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

encrypted passwords containing special characters appear to not work

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.4.3
    • 2.0.0
    • test
    • None
    • RHEL 6 64-bit
    • 2016-20, 2016-21

    Description

      Encrypted passwords which have a special character (such as $) appear to not work to auth to the backend servers.

      To reproduce:

      • use maxkeys to create maxscale keys
        maxkeys /var/lib/maxscale
      • create maxscale database user with $ in the password
        grant all privileges on . to 'maxscale'@'localhost' identified by 'aaaaaaaaa$aaaaaaaaaa';
      • use maxpasswd to generate encrypted version of password
        maxpassword /var/lib/maxscale aaaaaaaaa$aaaaaaaaaa
      • use encrypted password in maxscale.cnf
        EED7D82309F2898C7BE84E389D8C70B1
      • restart maxscale
        service maxscale start
      • log into maxadmin and list servers, auth failed
        Auth Error, Down
      • change maxscale database user password to not contain special characters
        set password for 'maxscale'@'localhost' = password('aaaaaaaaaaaaaaaaaaaa');
      • use maxpasswd to generate encrypted version of password
        maxpasswd /var/lib/maxscale aaaaaaaaaaaaaaaaaaaa
      • use encrypted password in maxscale.cnf
        059F56E071BFA3BFDA8FE4C832D8B7E94D2499B099C8BA3ADED096BB298239A1
      • restart maxscale
        service mysql restart
      • log into maxadmin and list servers, auth succeeded and all works
        Master, Running

      Attachments

        Activity

          People

            tturenko Timofey Turenko
            ben Ben Stillman
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.