报错:MHA:masterha_check_repl --conf=/etc/mha/app1.cnf解决密方

1:报错


[error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 32) line 3.

提示安装mysql驱动失败,尝试重新加载DBD

2:网上尝试的方法


安装cpan我试过了,一点用都没有

3:原因


就是驱动安装失败(没有mysql驱动,为什么没有那?因为除了yum安装mysql,二进制,源码安装不会自带)

4:解决


在http://rpm.pbone.net/上下载以下三个rpm软件

mysql-community-common
mysql-community-libs
mysql-community-libs-compat

版本系统型号选择对应的即可
(如果你可以yum安装那最好,一般没有)

如果安装报错
[root@db3 ~]# rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm

警告:mysql-community-common-5.7.32-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中… ################################# [100%]
file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.32-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64
file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.32-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64
file /usr/share/mysql/dutch/errmsg.sys from install of mysql-community-common-5.7.32-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64…

原因:软件包冲突(原来之前有mariadb的,难怪之前安装manager和node没有报错,原来一直用的mariadb的库)

解决:yum remove mariadb-libs*

remove后要重新安装manager和node还有相关的依赖包,因为相关依赖都会被一起去掉

最后执行


[root@db3 mha]# masterha_check_repl --conf=/etc/mha/app1.cnf
Sat Nov 14 17:02:54 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Sat Nov 14 17:02:54 2020 - [info] Reading application default configuration from /etc/mha/app1.cnf…

MySQL Replication Health is OK.

又可以愉快的玩起来了。我弄了一天,整个人都蒙蔽了,网上的东西我都翻烂了,这是一个大坑。。。

点赞是对我最大的支持,关注是我最大的认可


版权声明:本文为qq_46654855原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。