masterha_check_repl --conf=/etc/mha/app1.cnf检查错误

[mysql@node3 ~]$ masterha_check_repl --conf=/etc/mha/app1.cnf
Tue Jul  7 22:43:26 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Tue Jul  7 22:43:26 2020 - [info] Reading application default configuration from /etc/mha/app1.cnf..
Tue Jul  7 22:43:26 2020 - [info] Reading server configuration from /etc/mha/app1.cnf..
Tue Jul  7 22:43:26 2020 - [info] MHA::MasterMonitor version 0.58.
Tue Jul  7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln180] Got MySQL error when connecting 192.168.12.131(192.168.12.131:3306) :1045:Access denied for user ‘mha‘@‘192.168.12.130‘ (using password: YES), but this is not a MySQL crash. Check MySQL server settings.
Tue Jul  7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301]  at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297.
Tue Jul  7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln180] Got MySQL error when connecting 192.168.12.130(192.168.12.130:3306) :1045:Access denied for user ‘mha‘@‘192.168.12.130‘ (using password: YES), but this is not a MySQL crash. Check MySQL server settings.
Tue Jul  7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301]  at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297.
Tue Jul  7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln180] Got MySQL error when connecting 192.168.12.132(192.168.12.132:3306) :1045:Access denied for user ‘mha‘@‘192.168.12.130‘ (using password: YES), but this is not a MySQL crash. Check MySQL server settings.
Tue Jul  7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301]  at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297.
Tue Jul  7 22:43:27 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations
Tue Jul  7 22:43:27 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations.  at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 329.
Tue Jul  7 22:43:27 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Tue Jul  7 22:43:27 2020 - [info] Got exit code 1 (Not master dead).

  

原因:MHA配置文件监控用户mha的密码错误。

 

[mysql@node3 ~]$ cat /etc/mha/app1.cnf
[server default]
manager_log=/var/log/mha/app1/manager
manager_workdir=/var/log/mha/app1
master_binlog_dir=/mysql/binlog
user=mha
password=mysql
ping_interval=2
repl_password=mysql
repl_user=repl
ssh_user=mysql
[server1]
hostname=192.168.12.131
port=3306
[server2]
hostname=192.168.12.132
port=3306
[server3]
hostname=192.168.12.130
port=3306

 

masterha_check_repl --conf=/etc/mha/app1.cnf检查错误

上一篇:Unity3D2019版本安装多个安卓SDK版本


下一篇:IOS 页面滚动下拉