LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   HAPROXY - MySql Replication check script (http://www.linuxquestions.org/questions/linux-server-73/haproxy-mysql-replication-check-script-870606/)

wademac 03-23-2011 08:01 PM

HAPROXY - MySql Replication check script
 
I am testing HAProxy to load balance some test mysql servers and I am review the instruction on Alex Williams blog (http://www.alexwilliams.ca/blog/2009...nd-redundancy/) on the setup I have everything almost working but the replication check script which is from http://forge.mysql.com/tools/tool.php?id=6

I am getting to my question :)

I can get the script to run localhost on both the mysql servers but not check from off the box or even one mysql box to the other..

here is what I get when I run the telnet local to the script setup on port 25001

telnet localhost 25001
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
Replication slave is running
Removed Alert Lock
Connection closed by foreign host.

but if I run it from the HAProxy server I get:

telnet 192.168.1.141 25001
Trying 192.168.1.141...
Connected to 192.168.1.141.
Escape character is '^]'.
ERROR 1227 (42000) at line 1: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation
ERROR 1227 (42000) at line 1: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation
ERROR 1227 (42000) at line 1: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation
Replication is not configured or you do not have the required access to MySQL
Connection closed by foreign host.

because this is test I have the root mysql user and password setup in the my.cnf files on both server and I have the IP of the HAProxy setup with full access to both MySql server any advice or direct would be a big help

repo 03-24-2011 01:22 PM

Fine you sorted it out, perhaps you can share the solution, so other people can benefit?

Kind regards

wademac 03-24-2011 08:25 PM

ownership and permissions where wrong :)


All times are GMT -5. The time now is 03:47 AM.