加入收藏 | 设为首页 | 会员中心 | 我要投稿 银川站长网 (https://www.0951zz.com/)- 云通信、基础存储、云上网络、机器学习、视觉智能!
当前位置: 首页 > 服务器 > 搭建环境 > Linux > 正文

linux中nagios pnp4nagios 图形监控 mysql

发布时间:2023-07-20 13:09:35 所属栏目:Linux 来源:
导读:下文为各位介绍一个linux中nagios pnp4nagios 图形监控 mysql的教程希望这篇文章可以帮助到各位哦,nagios图形界面还是比较麻烦的,下面以mysql为例来说一下,监控mysql的插件比较多,在这里了解方法,而不是死搬硬套.一,

下文为各位介绍一个linux中nagios pnp4nagios 图形监控 mysql的教程希望这篇文章可以帮助到各位哦,nagios图形界面还是比较麻烦的,下面以mysql为例来说一下,监控mysql的插件比较多,在这里了解方法,而不是死搬硬套.

一,安装pnp4nagios

[root@localhost objects]# yum install pnp4nagios rrdtool 

如果找不到包换epel源,博客里面有搜一下,关于nagios的安装,请参考:nagios 安装配置,详解.

二,配置nagios

1,修改nagios.cfg

[root@localhost objects]# vim /etc/nagios/nagios.cfg    //修改以下内容   

process_performance_data=1                             //由0改为1   

host_perfdata_command=process-host-perfdata            //前面的注释拿掉   

service_perfdata_command=process-service-perfdata      //注释拿掉   

enable_environment_macros=1                            //如果有注释拿掉  

2,修改commands.cfg

注释掉原有对process-host-perfdata和process-service-perfdata,重新定义

[root@localhost objects]# vim /etc/nagios/objects/commands.cfg   

define command {   

       command_name    process-service-perfdata   

       command_line    /usr/bin/perl /usr/libexec/pnp4nagios/process_perfdata.pl

}   

define command {   

       command_name    process-host-perfdata   

       command_line    /usr/bin/perl /usr/libexec/pnp4nagios/process_perfdata.pl -d HOSTPERFDATA   

}  

3、修改配置文件templates.cfg,添加以下内容:

[root@localhost objects]# vim /etc/nagios/objects/templates.cfg    

define host {   

        name       hosts-pnp   

        register   0   

        action_url /pnp4nagios/index.php/graph?host=$HOSTNAME$&srv=_HOST_   

        process_perf_data               1   

}   

define service {   

        name       srv-pnp   

        register   0   

        action_url /pnp4nagios/index.php/graph?host=$HOSTNAME$&srv=$SERVICEDESC$   

        process_perf_data               1   

4,修改服务器配置文件localhost.cfg

[root@localhost objects]# vim /etc/nagios/objects/localhost.cfg   

define host{   

        use                     linux-server,hosts-pnp   

        host_name               localhost   

        alias                   localhost   

        address                 127.0.0.1   

        }   //Cuoxin.com 

define service{   

        use                             local-service,srv-pnp   

        host_name                       localhost   

        service_description             PING   

        check_command                   check_ping!100.0,20%!500.0,60%   

        }   

上面只是例举了一个,你可以都加一下.

三,pnp4nagios配置

在网上好多关于pnp4nagios的文章,都是要把mv misccommands.cfg-sample misccommands.cfg 生成配置文件,我是yum安装的,安装目录下根本没有sample这样的东西.

[root@localhost objects]# tree /etc/pnp4nagios/   

/etc/pnp4nagios/   

 background.pdf   

 check_commands   

    check_all_local_disks.cfg   

    check_nrpe.cfg   

    check_nwstat.cfg   

 config.php   

 misccommands.cfg   

 nagios.cfg   

 npcd.cfg   

 pages   

    web_traffic.cfg   

 pnp4nagios_release   

 process_perfdata.cfg   

 rra.cfg   

所在我根本没有配置任何东西.

四,重启nagios,启动npcd

[root@localhost pnp4nagios]# /etc/init.d/npcd start   

[root@localhost pnp4nagios]# /etc/init.d/nagios restart 

五,nginx配置

配置nginx的时候,配置挺头痛的,nagios的根目录是有php的,pnp4nagios是放在nagios的根目录下面,pnp4nagios也是php的,配置不好容易错乱的.

server   

{   

    listen       80;   

    server_name  nagios.xxxx.com;   

    index  index.php;   

    root   /usr/share/nagios/html;   

    location ~ .*\.(php|php5)?$ {        //nagios根目录的php   

        fastcgi_pass  127.0.0.1:9000;   

        fastcgi_index index.php;   

        include fastcgi.conf;   

    }   

    location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ {   //nagios的图片重写   

        rewrite ^/nagios/images/(.*) /images/$1 break;   

        rewrite ^/pnp4nagios/index.php/(.*) /pnp4nagios/$1 break;   

        expires     30d;   

    }   

    location ~ .*\.(js|css)?$ {       //nagios的js,css重写   

        rewrite ^/nagios/stylesheets/(.*) /stylesheets/$1 break;   

        rewrite ^/nagios/js/(.*) /js/$1 break;   

        rewrite ^/pnp4nagios/index.php/(.*) /pnp4nagios/$1 break;   

        expires     1h;   

    }   

    location ~ .*\.cgi$ {             //nagios的主程序是perl的,perl的cgi重写   

        root /usr/lib64/nagios/cgi-bin;   

        rewrite ^/nagios/cgi-bin/(.*)\.cgi /$1.cgi break;   

        fastcgi_pass   127.0.0.1:9001;   

        fastcgi_index index.cgi;   

        include fastcgi.conf;   

    }   

    location ~ ^(/pnp4nagios.*\.php)(.*)$ {       //pnp4nagios的php重写   

        rewrite ^/pnp4nagios/index.php/index.php/(.*)$ /pnp4nagios/index.php/$1; break;   

        fastcgi_pass   127.0.0.1:9000;   

        fastcgi_index index.php;   

        include fastcgi.conf;   

    }   

在这里有一个问题就是http://nagios.xxxx.com/pnp4nagios/index.php/index.php/graph?host=localhost&srv=PING在这里有二个index.php,这个是php的程序加上去的,我并没有改,同一个页面有二种链接.

由nagios的监控页面,跳转到pnp4nagios监控页面的连接是

http://nagios.xxxx.com/pnp4nagios/index.php/graph?host=localhost&srv=PING

点php4nagios监控页面中的连接然后就会多加一个index.php,http://nagios.xxxx.com/pnp4nagios/index.php/index.php/graph?host=localhost&srv=PING

这也是上面我为什么要加这一句rewrite ^/pnp4nagios/index.php/index.php/(.*)$ /pnp4nagios/index.php/$1;break;的原因.

二,安装perl mysql扩展

# yum install perl-Class-DBI-mysql

三,check_mysqld.php和check_mysqld.pl

1,下载

http://exchange.nagios.org/components/com_mtree/attachment.php?link_id=174&cf_id=30 

http://exchange.nagios.org/components/com_mtree/attachment.php?link_id=174&cf_id=36 

2,修改check_mysqld.php和check_mysqld.pl,本机是64位,根本没有/usr/lib/nagios,所以要把文件中的lib改成lib64.

3,copy和修改文件权限

# cp check_mysqld.pl /usr/lib64/nagios/plugins   

# chmod 755 /usr/lib64/nagios/plugins/check_mysqld.pl   

# chgrp nagios /usr/lib64/nagios/plugins/check_mysqld.pl   

# cp check_mysqld.php /usr/share/nagios/html/pnp4nagios/templates.dist  

四,nagios配置

1,修改command.cfg

# vim /etc/nagios/objects/commands.cfg   

define command{   

 command_name check_mysqld   

 command_line $USER1$/check_mysqld.pl -H $HOSTADDRESS$ -u nagios -p $USER7$ -a uptime,threads_connected,questions,slow_queries,open_tables -w ',,,,' -c ',,,,' -A $USER21$   

}  

2,修改resource.cfg

# vim /etc/nagios/objects/resource.cfg    

$USER7$=nagios   

$USER21$='com_select,com_update,com_insert,com_insert_select,  

com_commit,com_delete,com_rollback,aborted_clients,  

aborted_connects,binlog_cache_disk_use,binlog_cache_use,  

bytes_received,bytes_sent,connections,created_tmp_disk_tables,  

created_tmp_files,created_tmp_tables,delayed_errors,  

delayed_insert_threads,delayed_writes,handler_update,handler_write,  

handler_delete,handler_read_first,handler_read_key,  

handler_read_next,handler_read_prev,handler_read_rnd,  

handler_read_rnd_next,key_blocks_not_flushed,  

key_blocks_unused,key_blocks_used,key_read_requests,key_reads,  

key_write_requests,key_writes,max_used_connections,  

not_flushed_delayed_rows,open_files,open_streams,open_tables,  

opened_tables,prepared_stmt_count,qcache_free_blocks,  

qcache_free_memory,qcache_hits,qcache_inserts,  

qcache_lowmem_prunes,qcache_not_cached,  

qcache_queries_in_cache,qcache_total_blocks,questions,  

select_full_join,select_rangle_check,slow_launch_threads,  

slow_queries,table_locks_immediate,table_locks_waited,  

threads_cached,threads_connected,threads_created,  

threads_running'  

在这里要注意,$USER21$后面的内容要在一行.

3,修改localhost.cfg

# vim /etc/nagios/objects/localhost.cfg    

define service {   

 use local-service,srv-pnp //srv-pnp换成你自定义的   

 host_name localhost   

 service_description MYSQLD   

 check_command check_mysqld!localhost!nagios!nagios   

}   

4,pnp4nagios中增加check_mysqld.cfg 

# vim /etc/pnp4nagios/check_commands/check_mysqld.cfg   

DATATYPE = COUNTER   

五,重启nagios

# /etc/init.d/npcd restart   

# /etc/init.d/nrpe restart   

# /etc/init.d/nagios restart

(编辑:银川站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章