mha验证masterha_check_repl --conf=/etc/mha/mysql_mha.cnf 出错

来源:

码农小龙251151

2016-12-07

[root@RocketMQ161 mha]# masterha_check_repl --conf=/etc/mha/mysql_mha.cnf 

Thu Dec  8 00:13:36 2016 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.

Thu Dec  8 00:13:36 2016 - [info] Reading application default configuration from /etc/mha/mysql_mha.cnf..

Thu Dec  8 00:13:36 2016 - [info] Reading server configuration from /etc/mha/mysql_mha.cnf..

Thu Dec  8 00:13:36 2016 - [info] MHA::MasterMonitor version 0.56.

Thu Dec  8 00:13:36 2016 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 10.9.210.161(10.9.210.161:3306) :1045:Access denied for user 'root'@'RocketMQ161' (using password: YES), but this is not a MySQL crash. Check MySQL server settings.

 at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297

Thu Dec  8 00:13:36 2016 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 10.9.12.35(10.9.12.35:3306) :1045:Access denied for user 'root'@'10.9.210.161' (using password: YES), but this is not a MySQL crash. Check MySQL server settings.

 at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297

Thu Dec  8 00:13:36 2016 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 10.9.12.36(10.9.12.36:3306) :1045:Access denied for user 'root'@'10.9.210.161' (using password: YES), but this is not a MySQL crash. Check MySQL server settings.

 at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297

Thu Dec  8 00:13:36 2016 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations

Thu Dec  8 00:13:36 2016 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations.  at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 326

Thu Dec  8 00:13:36 2016 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.

Thu Dec  8 00:13:36 2016 - [info] Got exit code 1 (Not master dead).


MySQL Replication Health is NOT OK!



写回答

3回答

sqlercn

2016-12-13

这两个脚本验证的内容不一样,masterha_check_ssh只是验证各服务器之间的SSH免认证是否正确。

1
0

sqlercn

2016-12-12

这是MySQL监控账号的问题,看提示不是已经说了Access denied for user 'root'@'RocketMQ161' (using password: YES)

1
0

码农小龙251151

提问者

2016-12-13

老师还得麻烦你一下,我的masterha_check_ssh --conf=/etc/mha/mysql_mha.cnf是验证成功了





0
0

MySQL提升课程 全面讲解MySQL架构设计

面面俱到讲解影响MySQL性能的各个因素,让MySQL架构了然于胸。

4419 学习 · 547 问题

查看课程