linux里nagios pnp4nagios 图形监控 mysql
发布时间:2022-10-15 05:02:01 所属栏目:教程 来源:网络
导读: 下文为各位介绍一个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 } //phpfensi.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。 (编辑:晋中站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
站长推荐