fantasyni / mysql-master-ha

Automatically exported from code.google.com/p/mysql-master-ha
0 stars 0 forks source link

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

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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 
ec2-user@xx.xx.xxx.xxx(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 danoyo...@gmail.com on 17 Feb 2012 at 6:02

GoogleCodeExporter commented 9 years ago
Where is mysqlbinlog installed on the target machine (xx.xx.xxx.xxx)? 

Original comment by Yoshinor...@gmail.com on 17 Feb 2012 at 6:05

GoogleCodeExporter commented 9 years ago
You need to install mysqlbinlog binary from repository v3.3. i thuink current 
one

Original comment by nilldot@gmail.com on 17 Feb 2012 at 9:02

GoogleCodeExporter commented 9 years ago
What is the result of /usr/bin/mysqlbinlog --version ? 

Original comment by Yoshinor...@gmail.com on 17 Feb 2012 at 9:09

GoogleCodeExporter commented 9 years ago
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 danoyo...@gmail.com on 17 Feb 2012 at 1:39

GoogleCodeExporter commented 9 years ago
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 danoyo...@gmail.com on 17 Feb 2012 at 3:41

GoogleCodeExporter commented 9 years ago
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 crazycat...@gmail.com on 22 Mar 2012 at 7:20

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Just hit this one too. Would be great to have a --basedir setting here.

Original comment by eroomy...@gmail.com on 30 Apr 2012 at 9:19

GoogleCodeExporter commented 9 years ago
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 kaiwang....@gmail.com on 28 Feb 2013 at 3:10