增加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运行服务的问题。

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。