Shulou(Shulou.com)06/01 Report--

Production environment:

Operating system: CentOS release 6.8 (Final)

Database: mysql 5.5.49-cll-lve

Problem: among the many objects monitored by Cacti, due to the addition of a server and the addition of a monitoring object Windows system, only one of all the objects monitored by cacti shows the data.

Analysis:

1. The image is not generated, run # / usr/bin/php / var/www/html/cacti/poller.php-- force # does the data appear?

two。 Permission question, modify permission # chmod 777-R / var/www/html/cacti/rra # do not have permission?

3. The database table is corrupted. # do I need to repair the database?

4. Restart the snmp service.

5. Use snmpwalk to get all kinds of information.

After a problem occurs, we need to analyze the problem by checking the error log.

[root@sky9896 log] # sz cacti.log # download log analysis

Rz

Zmodem trl+C

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

[root@sky9896 log] # tail-n 200 cacti.log # View the last n lines of the text file, please see the attachment code

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

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 # repair database

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 # generate objects

09Accord 07 PM 06:03:56 2016-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 # set permissions

[root@sky9896 /] # service snmpd restart # restart the service

[root@sky9896 /] # snmpwalk-v 2c 117.40.collect information. *-c public # collect all kinds of information

The addition of the cacti object causes two problems, one is causing an error in the database, and the other is the problem of snmp running the service.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.