生產(chǎn)環(huán)境：

道里ssl適用于網(wǎng)站、小程序/APP、API接口等需要進(jìn)行數(shù)據(jù)傳輸應(yīng)用場(chǎng)景，ssl證書未來市場(chǎng)廣闊！成為成都創(chuàng)新互聯(lián)公司的ssl證書銷售渠道，可以享受市場(chǎng)價(jià)格4-6折優(yōu)惠！如果有意向歡迎電話聯(lián)系或者加微信：028-86922220（備注：SSL證書合作）期待與您的合作！

操作系統(tǒng)：CentOS release 6.8 (Final)

數(shù)據(jù)庫：MySQL 5.5.49-cll-lve

問題：在眾多Cacti監(jiān)控的對(duì)象中，由于增加一臺(tái)服務(wù)器增加了一個(gè)了監(jiān)控對(duì)象Windows系統(tǒng)，導(dǎo)致cacti在監(jiān)控所有對(duì)象中僅有1個(gè)對(duì)象出圖出數(shù)據(jù)。

分析：

1.圖像沒有生成，運(yùn)行# /usr/bin/php /var/www/html/cacti/poller.php --force #出現(xiàn)數(shù)據(jù)了嗎？
2.權(quán)限問題，修改權(quán)限#chmod 777 -R /var/www/html/cacti/rra  #沒有權(quán)限嗎？
3.數(shù)據(jù)庫表有損壞。#需要修復(fù)數(shù)據(jù)庫嗎？

4.重新啟動(dòng)snmp服務(wù)。

5.使用snmpwalk 獲取各種信息。

   出現(xiàn)問題之后，我們要通過檢查錯(cuò)誤日志來分析問題所在。

[root@sky9896 log]# sz  cacti.log   #下載日志分析

rz

 zmodem trl+C

  100% 1211481 KB 6478 KB/s 00:03:07       0 Errorss

[root@sky9896 log]# tail  -n 200 cacti.log #查看文本文件末尾n行，請(qǐng)查看附件代碼

09/07/2016 03:53:02 PM - CMDPHP: Poller[0] Host[2] DS[15] WARNING: Result from SERVER not valid.  Partial Result: U

09/07/2016 03:53:02 PM - CMDPHP: Poller[0] Host[2] DS[12] WARNING: Result from SERVER not valid.  Partial Result: U

……………………….

 [root@sky9896 ~]# mysqlcheck  --auto-repair  --databases  cacti -p

Enter password:

cacti.cdef                                         OK

cacti.cdef_items                                   OK

cacti.colors                                       OK

cacti.data_input                                   OK

cacti.data_input_data

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.data_input_fields                            OK

cacti.data_local

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.data_template                                OK

cacti.data_template_data

warning  : 3 clients are using or haven't closed the table properly

status   : OK

cacti.data_template_data_rra

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.data_template_rrd

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.graph_local

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.graph_template_input                         OK

cacti.graph_template_input_defs

warning  : 1 client is using or hasn't closed the table properly

status   : OK

cacti.graph_templates                              OK

cacti.graph_templates_gprint                       OK

cacti.graph_templates_graph

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.graph_templates_item

warning  : 2 clients are using or haven't closed the table properly

status   : OK

cacti.graph_tree                                   OK

cacti.graph_tree_items                             OK

cacti.host

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.host_graph                                   OK

cacti.host_snmp_cache

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.host_snmp_query                              OK

cacti.host_template                                OK

cacti.host_template_graph

warning  : 1 client is using or hasn't closed the table properly

status   : OK

cacti.host_template_snmp_query                     OK

cacti.plugin_config                                OK

cacti.plugin_db_changes                            OK

cacti.plugin_discover_hosts

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.plugin_discover_template                     OK

cacti.plugin_hooks                                 OK

cacti.plugin_notification_lists                    OK

cacti.plugin_realms                                OK

cacti.plugin_thold_contacts                        OK

cacti.plugin_thold_host_failed                     OK

cacti.plugin_thold_log

warning  : 5 clients are using or haven't closed the table properly

status   : OK

cacti.plugin_thold_template_contact                OK

cacti.plugin_thold_threshold_contact               OK

cacti.poller                                       OK

cacti.poller_command

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.poller_item

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.poller_output                                OK

cacti.poller_output_rt

warning  : 3 clients are using or haven't closed the table properly

status   : OK

cacti.poller_reindex

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.poller_time                                  OK

cacti.rra                                          OK

cacti.rra_cf                                       OK

cacti.settings

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.settings_graphs                              OK

cacti.settings_tree                                OK

cacti.snmp_query                                   OK

cacti.snmp_query_graph                             OK

cacti.snmp_query_graph_rrd                         OK

cacti.snmp_query_graph_rrd_sv                      OK

cacti.snmp_query_graph_sv                          OK

cacti.syslog                                       OK

cacti.syslog_alert                                 OK

cacti.syslog_facilities                            OK

cacti.syslog_host_facilities                       OK

cacti.syslog_hosts                                 OK

cacti.syslog_incoming                              OK

cacti.syslog_logs                                  OK

cacti.syslog_priorities                            OK

cacti.syslog_remove                                OK

cacti.syslog_removed                               OK

cacti.syslog_reports                               OK

cacti.syslog_statistics                            OK

cacti.test                                         OK

cacti.thold_data

warning  : 6 clients are using or haven't closed the table properly

status   : OK

cacti.thold_template                               OK

cacti.user_auth                                    OK

cacti.user_auth_perms                              OK

cacti.user_auth_realm                              OK

cacti.user_log

warning  : 4 clients are using or haven't closed the table properly

status   : OK

cacti.version           

[root@sky9896 /]# mysqlcheck --auto-repair --database cacti -p  #修復(fù)數(shù)據(jù)庫

Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead.

Enter password:

cacti.cdef                                         OK

cacti.cdef_items                                   OK

cacti.colors                                       OK

cacti.data_input                                   OK

cacti.data_input_data                              OK

cacti.data_input_fields                            OK

cacti.data_local                                   OK

cacti.data_template                                OK

cacti.data_template_data                           OK

cacti.data_template_data_rra                       OK

cacti.data_template_rrd                            OK

cacti.graph_local                                  OK

cacti.graph_template_input                         OK

cacti.graph_template_input_defs                    OK

cacti.graph_templates                              OK

cacti.graph_templates_gprint                       OK

cacti.graph_templates_graph                        OK

cacti.graph_templates_item                         OK

cacti.graph_tree                                   OK

cacti.graph_tree_items                             OK

cacti.host                                         OK

cacti.host_graph                                   OK

cacti.host_snmp_cache                              OK

cacti.host_snmp_query                              OK

cacti.host_template                                OK

cacti.host_template_graph                          OK

cacti.host_template_snmp_query                     OK

cacti.plugin_config                                OK

cacti.plugin_db_changes                            OK

cacti.plugin_discover_hosts                        OK

cacti.plugin_discover_template                     OK

cacti.plugin_hooks                                 OK

cacti.plugin_notification_lists                    OK

cacti.plugin_realms                                OK

cacti.plugin_thold_contacts                        OK

cacti.plugin_thold_host_failed                     OK

cacti.plugin_thold_log                             OK

cacti.plugin_thold_template_contact                OK

cacti.plugin_thold_threshold_contact               OK

cacti.poller                                       OK

cacti.poller_command                               OK

cacti.poller_item                                  OK

cacti.poller_output                                OK

cacti.poller_output_rt                             OK

cacti.poller_reindex                               OK

cacti.poller_time                                  OK

cacti.rra                                          OK

cacti.rra_cf                                       OK

cacti.settings                                     OK

cacti.settings_graphs                              OK

cacti.settings_tree                                OK

cacti.snmp_query                                   OK

cacti.snmp_query_graph                             OK

cacti.snmp_query_graph_rrd                         OK

cacti.snmp_query_graph_rrd_sv                      OK

cacti.snmp_query_graph_sv                          OK

cacti.syslog                                       OK

cacti.syslog_alert                                 OK

cacti.syslog_facilities                            OK

cacti.syslog_host_facilities                       OK

cacti.syslog_hosts                                 OK

cacti.syslog_incoming                              OK

cacti.syslog_logs                                  OK

cacti.syslog_priorities                            OK

cacti.syslog_remove                                OK

cacti.syslog_removed                               OK

cacti.syslog_reports                               OK

cacti.syslog_statistics                            OK

cacti.test                                         OK

cacti.thold_data                                   OK

cacti.thold_template                               OK

cacti.user_auth                                    OK

cacti.user_auth_perms                              OK

cacti.user_auth_realm                              OK

cacti.user_log                                     OK

cacti.version                                      OK

 [root@sky9896 /]# /usr/bin/php  /var/www/html/cacti/poller.php --force  #生成對(duì)象

09/07/2016 06:03:56 PM - SYSTEM STATS: Time:0.4219 Method:cmd.php Processes:4 Threads:N/A Hosts:10 HostsPerProcess:3 DataSources:0 RRDsProcessed:0

[root@sky9896 /]# chmod 777 -R  rra   #設(shè)置權(quán)限

[root@sky9896 /]# service snmpd restart  #重新啟動(dòng)服務(wù)

[root@sky9896 /]# snmpwalk -v  2c 117.40.***.*   -c public  #收集各種信息

    此次增加cacti對(duì)象導(dǎo)致兩個(gè)問題，一個(gè)是導(dǎo)致數(shù)據(jù)庫發(fā)生錯(cuò)誤，另一個(gè)是snmp運(yùn)行服務(wù)的問題。