2021-02-04 记录一次zabbix启动报错 /usr/sbin/zabbix_server: error while loading shared libraries: libmysqlcl

#

# Feb  4 15:52:55 zabbix zabbix_server: /usr/sbin/zabbix_server: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory

 

# 解决步骤 1 查看正常安装之后   libmysqlclient.so* 情况

find / -name libmysqlclient.so*

/usr/lib64/mysql/libmysqlclient.so.18
/usr/lib64/mysql/libmysqlclient.so.20
/usr/lib64/mysql/libmysqlclient.so.20.3.20
/usr/lib64/mysql/libmysqlclient.so.18.1.0

ll /usr/lib64/mysql/  # 查看一下正常目录情况  

total 15268
lrwxrwxrwx  1 root root      20 Jan 28 15:10 libmysqlclient_r.so.18 -> libmysqlclient.so.18
lrwxrwxrwx  1 root root      24 Jan 28 15:10 libmysqlclient_r.so.18.1.0 -> libmysqlclient.so.18.1.0
lrwxrwxrwx  1 root root      24 Jan 28 15:10 libmysqlclient.so.18 -> libmysqlclient.so.18.1.0
-rwxr-xr-x  1 root root 5979736 Dec 10 11:21 libmysqlclient.so.18.1.0
lrwxrwxrwx  1 root root      25 Jan 28 15:10 libmysqlclient.so.20 -> libmysqlclient.so.20.3.20
-rwxr-xr-x  1 root root 9646888 Dec 10 11:27 libmysqlclient.so.20.3.20
drwxr-xr-x  4 root root      28 Jan 28 15:10 mecab
drwxr-xr-x. 3 root root    4096 Jan 28 15:10 plugin
 

# 把正常文件scp过去

scp libmysqlclient.so.18 root@10.69.15.38:/usr/lib64/mysql/

scp libmysqlclient.so.18.1.0 root@10.69.15.38:/usr/lib64/mysql/

 

# 出错机器操作

ln -s libmysqlclient.so.18 libmysqlclient_r.so.18 
ln -s libmysqlclient.so.18.1.0 libmysqlclient_r.so.18.1.0 
ln -s libmysqlclient.so.18.1.0 libmysqlclient.so.18

# 查看配置文件是否正常
cat /etc/ld.so.conf
cat /etc/ld.so.conf.d/mysql-x86_64.conf 

# 查看一下此目录情况
/usr/lib64/mysql

lrwxrwxrwx  1 root root       20 Feb  4 15:53 libmysqlclient_r.so.18 -> libmysqlclient.so.18
lrwxrwxrwx  1 root root       24 Feb  4 15:54 libmysqlclient_r.so.18.1.0 -> libmysqlclient.so.18.1.0
-rwxr-xr-x  1 root root  5979736 Feb  4 15:53 libmysqlclient.so.18
-rwxr-xr-x  1 root root  5979736 Feb  4 15:54 libmysqlclient.so.18.1.0
lrwxrwxrwx  1 root root       25 Feb  4 11:08 libmysqlclient.so.20 -> libmysqlclient.so.20.3.19
-rwxr-xr-x  1 root root  9647032 Sep 23 20:59 libmysqlclient.so.20.3.19
-rwxr-xr-x  1 root root 14132808 Oct  2 00:56 libmysqld.so.18
drwxr-xr-x  4 root root       28 Jan 28 14:55 mecab
drwxr-xr-x. 3 root root     4096 Jan 28 14:55 plugin

# 感觉差不多  

#  启动 zabbix-server 试试 

systemctl restart zabbix-server zabbix-agent httpd
systemctl enable zabbix-server zabbix-agent httpd

# 搞定

# 此包默认是跟着mysql安装的  附下载地址

wget -O /usr/lib/libmysqlclient.so.18 http://files.directadmin.com/services/es_7.0_64/libmysqlclient.so.18