Hi, > >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) > > I moved to the latets version of HAProxy and now it is working. Need to do some more testing. Thanks for all the input/directions. 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."
