下文為各位介紹一個linux中nagios pnp4nagios 圖形監控 mysql的教程希望這篇文章可以幫助到各位哦,nagios圖形界面還是比較麻煩的,下面以mysql為例來說一下,監控mysql的插件比較多,在這里了解方法,而不是死搬硬套.

一，安裝pnp4nagios

[root@localhost objects]# yum install pnp4nagios rrdtool  

如果找不到包換epel源,博客里面有搜一下,關于nagios的安裝,請參考:nagios 安裝配置,詳解.

二，配置nagios

1,修改nagios.cfg

1. [root@localhost objects]# vim /etc/nagios/nagios.cfg    //修改以下內容   
2. process_performance_data=1                             //由0改為1   
3. host_perfdata_command=process-host-perfdata            //前面的注釋拿掉   
4. service_perfdata_command=process-service-perfdata      //注釋拿掉   
5. enable_environment_macros=1                            //如果有注釋拿掉  

2,修改commands.cfg

注釋掉原有對process-host-perfdata和process-service-perfdata,重新定義

1. [root@localhost objects]# vim /etc/nagios/objects/commands.cfg   
2.    
3. define command {   
4.        command_name    process-service-perfdata   
5.        command_line    /usr/bin/perl /usr/libexec/pnp4nagios/process_perfdata.pl   
6. }   
7.    
8. define command {   
9.        command_name    process-host-perfdata   
10.        command_line    /usr/bin/perl /usr/libexec/pnp4nagios/process_perfdata.pl -d HOSTPERFDATA   
11. }  

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

1. [root@localhost objects]# vim /etc/nagios/objects/templates.cfg    
2.    
3. define host {   
4.         name       hosts-pnp   
5.         register   0   
6.         action_url /pnp4nagios/index.php/graph?host=$HOSTNAME$&srv=_HOST_   
7.         process_perf_data               1   
8. }   
9. define service {   
10.         name       srv-pnp   
11.         register   0   
12.         action_url /pnp4nagios/index.php/graph?host=$HOSTNAME$&srv=$SERVICEDESC$   
13.         process_perf_data               1   
14. } 

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

1. [root@localhost objects]# vim /etc/nagios/objects/localhost.cfg   
2.    
3. define host{   
4.         use                     linux-server,hosts-pnp   
5.         host_name               localhost   
6.         alias                   localhost   
7.         address                 127.0.0.1   
8.         }   //Vevb.com 
9.    
10. define service{   
11.         use                             local-service,srv-pnp   
12.         host_name                       localhost   
13.         service_description             PING   
14.         check_command                   check_ping!100.0,20%!500.0,60%   
15.         }   

上面只是例舉了一個,你可以都加一下.

三,pnp4nagios配置

在網上好多關于pnp4nagios的文章,都是要把mv misccommands.cfg-sample misccommands.cfg 生成配置文件,我是yum安裝的,安裝目錄下根本沒有sample這樣的東西.

1. [root@localhost objects]# tree /etc/pnp4nagios/   
2. /etc/pnp4nagios/   
3. ├── background.pdf   
4. ├── check_commands   
5. │   ├── check_all_local_disks.cfg   
6. │   ├── check_nrpe.cfg   
7. │   └── check_nwstat.cfg   
8. ├── config.php   
9. ├── misccommands.cfg   
10. ├── nagios.cfg   
11. ├── npcd.cfg   
12. ├── pages   
13. │   └── web_traffic.cfg   
14. ├── pnp4nagios_release   
15. ├── process_perfdata.cfg   
16. └── rra.cfg   

所在我根本沒有配置任何東西.

四，重啟nagios,啟動npcd

1. [root@localhost pnp4nagios]# /etc/init.d/npcd start   
2. [root@localhost pnp4nagios]# /etc/init.d/nagios restart 

五，nginx配置

配置nginx的時候,配置挺頭痛的,nagios的根目錄是有php的,pnp4nagios是放在nagios的根目錄下面,pnp4nagios也是php的,配置不好容易錯亂的.

1. server   
2. {   
3.     listen       80;   
4.     server_name  nagios.xxxx.com;   
5.     index  index.php;   
6.     root   /usr/share/nagios/html;   
7.    
8.     location ~ .*＼.(php|php5)?$ {        //nagios根目錄的php   
9.         fastcgi_pass  127.0.0.1:9000;   
10.         fastcgi_index index.php;   
11.         include fastcgi.conf;   
12.     }   
13.    
14.     location ~ .*＼.(gif|jpg|jpeg|png|bmp|swf)$ {   //nagios的圖片重寫   
15.         rewrite ^/nagios/images/(.*) /images/$1 break;   
16.         rewrite ^/pnp4nagios/index.php/(.*) /pnp4nagios/$1 break;   
17.         expires     30d;   
18.     }   
19.    
20.     location ~ .*＼.(js|css)?$ {       //nagios的js,css重寫   
21.         rewrite ^/nagios/stylesheets/(.*) /stylesheets/$1 break;   
22.         rewrite ^/nagios/js/(.*) /js/$1 break;   
23.         rewrite ^/pnp4nagios/index.php/(.*) /pnp4nagios/$1 break;   
24.         expires     1h;   
25.     }   
26.    
27.     location ~ .*＼.cgi$ {             //nagios的主程序是perl的，perl的cgi重寫   
28.         root /usr/lib64/nagios/cgi-bin;   
29.         rewrite ^/nagios/cgi-bin/(.*)＼.cgi /$1.cgi break;   
30.         fastcgi_pass   127.0.0.1:9001;   
31.         fastcgi_index index.cgi;   
32.         include fastcgi.conf;   
33.     }   
34.     location ~ ^(/pnp4nagios.*＼.php)(.*)$ {       //pnp4nagios的php重寫   
35.         rewrite ^/pnp4nagios/index.php/index.php/(.*)$ /pnp4nagios/index.php/$1; break;   
36.         fastcgi_pass   127.0.0.1:9000;   
37.         fastcgi_index index.php;   
38.         include fastcgi.conf;   
39.     }   
40.    
41. } 

在這里有一個問題就是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,下載

1. http://exchange.nagios.org/components/com_mtree/attachment.php?link_id=174&cf_id=30 
2. 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和修改文件權限

1. # cp check_mysqld.pl /usr/lib64/nagios/plugins   
2.    
3. # chmod 755 /usr/lib64/nagios/plugins/check_mysqld.pl   
4. # chgrp nagios /usr/lib64/nagios/plugins/check_mysqld.pl   
5.    
6. # cp check_mysqld.php /usr/share/nagios/html/pnp4nagios/templates.dist  

四,nagios配置

1,修改command.cfg

1. # vim /etc/nagios/objects/commands.cfg   
2.    
3. define command{   
4.  command_name check_mysqld   
5.  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$   
6. }  

2,修改resource.cfg

1. # vim /etc/nagios/objects/resource.cfg    
2.    
3. $USER7$=nagios   
4. $USER21$='com_select,com_update,com_insert,com_insert_select,  
5. com_commit,com_delete,com_rollback,aborted_clients,  
6. aborted_connects,binlog_cache_disk_use,binlog_cache_use,  
7. bytes_received,bytes_sent,connections,created_tmp_disk_tables,  
8. created_tmp_files,created_tmp_tables,delayed_errors,  
9. delayed_insert_threads,delayed_writes,handler_update,handler_write,  
10. handler_delete,handler_read_first,handler_read_key,  
11. handler_read_next,handler_read_prev,handler_read_rnd,  
12. handler_read_rnd_next,key_blocks_not_flushed,  
13. key_blocks_unused,key_blocks_used,key_read_requests,key_reads,  
14. key_write_requests,key_writes,max_used_connections,  
15. not_flushed_delayed_rows,open_files,open_streams,open_tables,  
16. opened_tables,prepared_stmt_count,qcache_free_blocks,  
17. qcache_free_memory,qcache_hits,qcache_inserts,  
18. qcache_lowmem_prunes,qcache_not_cached,  
19. qcache_queries_in_cache,qcache_total_blocks,questions,  
20. select_full_join,select_rangle_check,slow_launch_threads,  
21. slow_queries,table_locks_immediate,table_locks_waited,  
22. threads_cached,threads_connected,threads_created,  
23. threads_running'  

在這里要注意,$USER21$后面的內容要在一行.

3,修改localhost.cfg

1. # vim /etc/nagios/objects/localhost.cfg    
2.    
3. define service {   
4.  use local-service,srv-pnp //srv-pnp換成你自定義的   
5.  host_name localhost   
6.  service_description MYSQLD   
7.  check_command check_mysqld!localhost!nagios!nagios   
8. }   
9. 4,pnp4nagios中增加check_mysqld.cfg 
10. # vim /etc/pnp4nagios/check_commands/check_mysqld.cfg   
11.    
12. DATATYPE = COUNTER   

五,重啟nagios

1. # /etc/init.d/npcd restart   
2. # /etc/init.d/nrpe restart   
3. # /etc/init.d/nagios restart