增加cacti监控对象时导致无数据无图形出现

生产环境：

操作系统：Centos release 6.8 (Final)

数据库：mysql 5.5.49-cll-lve

问题：在众多Cacti监控的对象中，由于增加一台服务器增加了一个了监控对象Windows系统，导致cacti在监控所有对象中仅有1个对象出图出数据。

分析：

1.图像没有生成，运行# /usr/bin/PHP /var/www/html/cacti/poller.php --force #出现数据了吗？
2.权限问题，修改权限#chmod 777 -R /var/www/html/cacti/rra  #没有权限吗？
3.数据库表有损坏。#需要修复数据库吗？

4.重新启动snmp服务。

5.使用snmpwalk 获取各种信息。

   出现问题之后，我们要通过检查错误日志来分析问题所在。

[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行，请查看附件代码

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  #修复数据库

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  #生成对象

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   #设置权限

[root@sky9896 /]# service snmpd restart  #重新启动服务

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

    此次增加cacti对象导致两个问题，一个是导致数据库发生错误，另一个是snmp运行服务的问题。