Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What if there is a problem with the database when adding cacti monitoring objects?

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to add cacti monitoring objects to lead to database problems, the article is very detailed, has a certain reference value, interested friends must read it!

Production environment:

Database: mysql 5.5.49-cll-lve

Problem: among the many objects monitored by Cacti, due to the addition of the monitoring object nginx, only one object is graphed out of all the objects monitored by cacti.

Analysis:

1.systemutilities-> Rebuild poller cache # do I need to rebuild cache?

two。 System time is not accurate, reset time # do I need to update the server time?

3. Image not generated, run

# / usr/bin/php / var/www/html/cacti/poller.php-- is there any data in force #?

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

5.crontab-e # scheduled tasks?

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

After a problem occurs, we will analyze the problem by checking the error log. Please check the attachment.

By looking at the cacti log file, it is found that there is no valid data loaded, and the problem of plotting data is solved by repairing the cacti database.

[root@sky9896 sky] # 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: 3 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: 3 clients are using or haven't closed the table properly

Status: 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

Warning: 3 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

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

Status: OK

Cacti.graph_tree_items

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

Status: OK

Cacti.host

Warning: 9 clients are using or haven't closed the table properly

Status: OK

Cacti.host_graph OK

Cacti.host_snmp_cache

Warning: 9 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 OK

Cacti.host_template_snmp_query OK

Cacti.plugin_config

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

Status: OK

Cacti.plugin_db_changes

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

Status: OK

Cacti.plugin_discover_hosts

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

Status: OK

Cacti.plugin_discover_template OK

Cacti.plugin_hooks

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

Status: OK

Cacti.plugin_notification_lists OK

Cacti.plugin_realms

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

Status: OK

Cacti.plugin_thold_contacts OK

Cacti.plugin_thold_host_failed OK

Cacti.plugin_thold_log

Warning: 7 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: 9 clients are using or haven't closed the table properly

Status: OK

Cacti.poller_item

Warning: 9 clients are using or haven't closed the table properly

Status: OK

Cacti.poller_output OK

Cacti.poller_output_rt

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

Status: OK

Cacti.poller_reindex

Warning: 9 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: 9 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.thold_data

Warning: 9 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

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

Status: OK

Cacti.user_log

Warning: 8 clients are using or haven't closed the table properly

Status: OK

Cacti.version OK

The above is all the contents of the article "what to do if the database goes wrong when adding cacti monitoring objects?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report