Can't exec "mysqlbinlog": No such file or directory

[GoogleCodeExporter]

What steps will reproduce the problem?
1. on the mha manager box, running the following command: masterha_manager 
--conf=/vol/mapi_qa.cnf
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?

CentOS 5 (Amazon ami image)

Please provide any additional information below.

Fri Feb 17 05:59:15 2012 - [info]   Connecting to 
[email protected](xx.xx.xxx.xxx:22).. 
Can't exec "mysqlbinlog": No such file or directory at 
/usr/local/share/perl5/MHA/BinlogManager.pm line 99.
mysqlbinlog version not found!
 at /usr/local/bin/apply_diff_relay_logs line 463

Original issue reported on code.google.com by [email protected] on 17 Feb 2012 at 6:02

[GoogleCodeExporter]

Where is mysqlbinlog installed on the target machine (xx.xx.xxx.xxx)? 

Original comment by [email protected] on 17 Feb 2012 at 6:05

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

You need to install mysqlbinlog binary from repository v3.3. i thuink current 
one

Original comment by [email protected] on 17 Feb 2012 at 9:02

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

What is the result of /usr/bin/mysqlbinlog --version ? 

Original comment by [email protected] on 17 Feb 2012 at 9:09

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

ok, i  see...I installed mysql from source and mysqlbinlog was put in the 
default /usr/local/mysql/bin dir.  I'll create some symlinks from here unless I 
can change the search path within the MHA code???? I have /usr/local/mysql/bin 
in the users path....

[ec2-user@mapi-slave01-qa ~]$ /usr/bin/mysqlbinlog --version 
-bash: /usr/bin/mysqlbinlog: No such file or directory
[ec2-user@mapi-slave01-qa ~]$ which mysqlbinlog 
/usr/local/mysql/bin/mysqlbinlog
[ec2-user@mapi-slave01-qa ~]$ mysqlbinlog --version
mysqlbinlog Ver 3.3 for Linux at x86_64

Original comment by [email protected] on 17 Feb 2012 at 1:39

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

I'm not a perl guy, but how can I have the search path include the 
/usr/local/mysql/bin directory?  the /usr/local/mysql/bin path is included in 
my users $PATH.  On the nodes, what other mysql tools/binaries is used by MHA?  
do I need to symlink them all?

Original comment by [email protected] on 17 Feb 2012 at 3:41

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

We have run into the same issue, as we install mysql in a custom location. 
Perhaps a configuration variable that could be used to set the location of the 
mysql client binaries would be helpful. 

Original comment by [email protected] on 22 Mar 2012 at 7:20

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Just hit this one too. Would be great to have a --basedir setting here.

Original comment by [email protected] on 30 Apr 2012 at 9:19

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Me too, just hit this one because apply_diff_relay_logs assumes mysqlbinlog in 
the PATH and ware of good /etc/my.cnf.  I would like the binary and options be 
configurable.

Original comment by [email protected] on 28 Feb 2013 at 3:10

• Added labels: ****
• Removed labels: ****