nagios监控mysql(借助脚本)
nagios监控mysql(借助脚本)修改后的脚本如下（需添加指示灯的状态）
# vi mysql.sh
#!/bin/bash
Port=`netstat -ntpl | grep mysqld | awk -F[:" "]+ '{print $5}'`
if [[ $Port == "3306" ]];then
echo "OK - mysql is running"
exit 0
else
echo "CRITICAL - mysql is down"
/sbin/service mysqld restart
exit 2
fi
:wq
注：0 指的是状态灯绿灯，2指的是红灯，黄灯不用 并且宕了之后再次check时就能自动重启
# cp mysql.sh/usr/local/nagios/libexec
# chmod +x /usr/local/nagios/libexec/mysql.sh
# mount /dev/cdrom /media/cdrom
# rpm -ivh sudo-1.6.9pl7-3.el5.i386.rpm
# visudo
#Defaults requiretty (注释掉)
nagios ALL=(ALL) NOPASSWD:/usr/local/nagios/libexec/mysql.sh (多个脚本的话设置多行)
:wq
# su - nagios -c 'sudo /usr/local/nagios/libexec/mysql.sh' (看看执行是否成功)
# vi /usr/local/nagios/etc/nrpe.cfg
command=/usr/bin/sudo /usr/local/nagios/libexec/mysql.sh
:wq
# killall nrpe
# /usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -d
# vi /usr/local/nagios/etc/objects/ming.cfg
define service{
use generic-service
host_name ming
service_description mysql
check_command check_nrpe!check_mysql
notifications_enabled 1
}
:wq
# service nagios restart
页:
[1]