本帖最后由 369666951 于 2016-3-3 23:54 编辑
nagios直接使用yum安装 或者编译安装 ，安装方法按照http://www.apelearn.com/bbs/thread-8087-1-1.html即可
1.在需要被监控的机器上（客户端），建立专用数据库 mysql -uroot -p
create database nagios;
并且授权grant select on nagios.* to nagios@'%' identified by '123456';
刷新权限flush privileges;
2，查看测试
/usr/lib64/nagios/plugins/check_mysql -H 127.0.0.1 -u nagios -d nagios -p 123456 //yum安装的路径注意32和64位系统
正确显示
或者/usr/local/nagios/libexec/check_mysql -H 127.0.0.1 -u nagios -d nagios -p 123456 //编译安装的路径解决办法 3.然后在监控机上修改 commands.cfg加入下面的
4.定义服务
define service{
use generic-service
host_name 192.168.1.106
service_description mysql
check_command check_mysql
max_check_attempts 5
normal_check_interval 1
contact_groups admins
}
最后检测并重启nagios服务即可
nagios直接使用yum安装 或者编译安装 ，安装方法按照http://www.apelearn.com/bbs/thread-8087-1-1.html即可
1.在需要被监控的机器上（客户端），建立专用数据库 mysql -uroot -p
create database nagios;
并且授权grant select on nagios.* to nagios@'%' identified by '123456';
刷新权限flush privileges;
2，查看测试
/usr/lib64/nagios/plugins/check_mysql -H 127.0.0.1 -u nagios -d nagios -p 123456 //yum安装的路径注意32和64位系统
正确显示
- Uptime: 660 Threads: 1 Questions: 35 Slow queries: 0 Opens: 70 Flush tables: 1 Open tables: 63 Queries per second avg: 0.053|Connections=13c;;; Open_files=19;;; Open_tables=63;;; Qcache_free_memory=1031360;;; Qcache_hits=0c;;; Qcache_inserts=0c;;; Qcache_lowmem_prunes=0c;;; Qcache_not_cached=0c;;; Qcache_queries_in_cache=0;;; Queries=36c;;; Questions=23c;;; Table_locks_waited=0c;;; Threads_connected=1;;; Threads_running=1;;; Uptime=660c;;;
或者/usr/local/nagios/libexec/check_mysql -H 127.0.0.1 -u nagios -d nagios -p 123456 //编译安装的路径
- 编译安装的可能报错/usr/local/nagios/libexec/check_mysql: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
- ln -sv /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18 //注意32和64位系统目录不同
- define command{
- command_name check_mysql
- command_line $USER1$/check_mysql -H $HOSTADDRESS$ -u nagios -d nagios -p 123456
- }
4.定义服务
define service{
use generic-service
host_name 192.168.1.106
service_description mysql
check_command check_mysql
max_check_attempts 5
normal_check_interval 1
contact_groups admins
}
最后检测并重启nagios服务即可
编辑回复