Hello, I have tracked this down to the new authentication method used in MySQL 5.6 since version 5.6.6.
Verify this for the user you specified in option mysql-check: select plugin from mysql.user where user='monitor' \G *************************** 1. row *************************** plugin: sha256_password 1 row in set (0.00 sec) If you see sha256_password, it won't work. Since password authentication is not used in health checks by HAproxy, you can just create a new user that is not using this kind of authentication to be used by the HAproxy: CREATE USER monitor@<haproxy_ip> IDENTIFIED WITH 'mysql_native_password'; Verify it is working by doing: select plugin from mysql.user where user='monitor' \G *************************** 1. row *************************** plugin: mysql_native_password 1 row in set (0.00 sec) Let me know if this fixes the issue. Regards, Nenad On 06/17/2013 01:50 PM, Jayadevan M wrote: > Hi, > >> listen stats :1936 >> mode http >> stats enable >> stats realm Haproxy\ Statistics >> stats uri / >> >> frontend mysql_proxy *:3309 >> mode tcp >> default_backend request_mysql > One error to another - How can I make HAProxy use a new MySQL > client/libraries? I am getting the error - > > [WARNING] 167/224803 (20008) : Server request_mysql/svr1 is DOWN, reason: > Layer7 wrong status, code: 0, info: "Client does not support authentication > protocol requested by server; consider upgrading MySQL client", check > duration: 2ms. 0 active and 0 backup servers left. 0 sessions active, 0 > requeued, 0 remaining in queue. > > I have MySQL 5.6.10 > > Regards, > Jayadevan > > > DISCLAIMER: "The information in this e-mail and any attachment is intended > only for the person to whom it is addressed and may contain confidential > and/or privileged material. If you have received this e-mail in error, kindly > contact the sender and destroy all copies of the original communication. IBS > makes no warranty, express or implied, nor guarantees the accuracy, adequacy > or completeness of the information contained in this email or any attachment > and is not liable for any errors, defects, omissions, viruses or for > resultant loss or damage, if any, direct or indirect." > -- Nenad Merdanovic | PGP: 0x423edcb2 | Web: http://nimzo.info Linkedin: http://www.linkedin.com/in/nenadmerdanovic
