LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 03-23-2011, 08:01 PM   #1
wademac
Member
 
Registered: Apr 2008
Posts: 37

Rep: Reputation: 15
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
 
Old 03-24-2011, 01:22 PM   #2
repo
LQ 5k Club
 
Registered: May 2001
Location: Belgium
Distribution: Linux Mint
Posts: 8,497

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

Kind regards
 
Old 03-24-2011, 08:25 PM   #3
wademac
Member
 
Registered: Apr 2008
Posts: 37

Original Poster
Rep: Reputation: 15
ownership and permissions where wrong
 
  


Reply

Tags
haproxy, mysql, replication


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
shell script to check whether mysql server is running or not vinaytp Linux - Newbie 3 01-18-2011 08:39 AM
Script to run at Boot for Auto Mysql database check Alan87i Linux - Server 6 10-30-2010 04:44 AM
Mysql replication failed after mysql reboot ajayan Linux - Newbie 8 09-08-2010 11:00 AM
Haproxy ,memcached ,mysql strange problem Eazy-Snatch Linux - Server 1 05-14-2008 02:54 AM
script to check instance of PHP & mySQL running on Unix platform kushalkoolwal Programming 7 04-26-2006 09:40 PM


All times are GMT -5. The time now is 09:46 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration