Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.4.3
-
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