In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.