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免认证是否正确。
10 -
sqlercn
2016-12-12
这是MySQL监控账号的问题,看提示不是已经说了Access denied for user 'root'@'RocketMQ161' (using password: YES)
10 -
码农小龙251151
提问者
2016-12-13
老师还得麻烦你一下,我的masterha_check_ssh --conf=/etc/mha/mysql_mha.cnf是验证成功了
00
相似问题