nagios报警mysql出错解决一列
收到自己的服务器的nagios报警，内容如下：[*]***** Nagios *****
[*]
[*]Notification Type: PROBLEM
[*]
[*]Service: 06. The Mysql Status
[*]Host: linuxjcq01
[*]Address: 192.168.2.11
[*]State: UNKNOWN
[*]
[*]Date/Time: Thu Dec 22 12:11:46 CST 2011
[*]
[*]Additional Info:
[*]
[*]NRPE: Unable to read output
首先，报警使用的是nrpe客户端，测试nrpe监控命令是否正常。
[*]vi /usr/local/nagios/etc/nrpe.cfg
[*]......
[*]command=/usr/local/nagios/libexec/check_mysql -H 192.168.2.11 -u nagios -p 密码 -d nagios -s /tmp/mysql.sock
[*]......
测试命令
[*]/usr/local/nagios/libexec/check_mysql -H 192.168.2.11 -u nagios -p 密码 -d nagios -s /tmp/mysql.sock
[*]/usr/local/nagios/libexec/check_mysql: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
从报错来看，原因很明显，找不到libmysqlclient.so.18。
原因分析：
因为我是自己安装的mysql，库文件存在于/usr/loca/mysql/lib中，查看是否存在该文件
[*]ls -l /usr/local/mysql/lib/libmysqlclient.so.18
[*]lrwxrwxrwx 1 mysql mysql 24 Aug 27 23:10 /usr/local/mysql/lib/libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
看来是我刚才用yum升级软件包的时候修改了ldconfig的配置文件，查看配置文件：
[*]vi /etc/ld.so.conf.d/mysql-x86_64.conf
[*]/usr/lib64/mysql
果然这个文件被重写了，原来自己有添加/usr/local/mysql/lib
解决方法：
添加/usr/local/mysql/lib
[*]vi /etc/ld.so.conf.d/mysql-x86_64.conf
[*]/usr/lib64/mysql
[*]/usr/local/mysql/lib
执行ldconfig
[*]ldconfig
重新执行监控子命令
[*]/usr/local/nagios/libexec/check_mysql -H 192.168.2.11 -u nagios -p 密码 -d nagios -s /tmp/mysql.sock
[*]Uptime: 8777Threads: 1Questions: 6762Slow queries: 0Opens: 113Flush tables: 1Open tables: 50Queries per second avg: 0.770
OK, 问题解决，一会儿收到邮件，通知服务正常了
[*]***** Nagios *****
[*]
[*]Notification Type: RECOVERY
[*]
[*]Service: 06. The Mysql Status
[*]Host: linuxjcq01
[*]Address: 192.168.2.11
[*]State: OK
[*]
[*]Date/Time: Thu Dec 22 12:36:46 CST 2011
[*]
[*]Additional Info:
[*]
[*]Uptime: 18085Threads: 1Questions: 13209Slow queries: 0Opens: 176Flush tables: 1Open tables: 61Queries per second avg: 0.730
附上另外一个解决方法，是安装MySQL-shared-compat包，可以到http://downloads.mysql.com/archives.php这边，下载对应的架构和动态客户端连接库，安装rpm包即可。
页:
[1]