Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Aug 23, 2017 8:15 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: MYSQL error from cacti log
PostPosted: Thu Dec 08, 2016 1:30 am 
Offline
Cacti User

Joined: Wed Oct 29, 2014 5:08 am
Posts: 78
Log shown below message
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host.id, host.hostname, host.description, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_port, host.snmp_timeout, manage_host.uptime, manage_host.statut FROM host,manage_host where manage = 'on' and disabled <> 'on' and host.id=manage_host.id"

And seem the database does not contain those item.

mysql> use cacti
Database changed
mysql> show tables;
+------------------------------------------+
| Tables_in_cacti |
+------------------------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_source_stats_daily |
| data_source_stats_hourly |
| data_source_stats_hourly_cache |
| data_source_stats_hourly_last |
| data_source_stats_monthly |
| data_source_stats_weekly |
| data_source_stats_yearly |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| gpsmap_templates |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
|host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_quer
y |[/b]
| mac_track_interface_graphs |
| manage_admin_link |
| manage_alerts |
| manage_groups |
| manage_poller_output |
| manage_process |
| manage_services |
| manage_sites |
| manage_tcp |
| manage_templates |
| manage_uptime_method |
| notices |
| plugin_aggregate_color_template_items |
| plugin_aggregate_color_templates |
| plugin_aggregate_graph_templates |
| plugin_aggregate_graph_templates_graph |
| plugin_aggregate_graph_templates_item |
| plugin_aggregate_graphs |
| plugin_aggregate_graphs_graph_item |
| plugin_aggregate_graphs_items |
| plugin_autom8_graph_rule_items |
| plugin_autom8_graph_rules |
| plugin_autom8_match_rule_items |
| plugin_autom8_tree_rule_items |
| plugin_autom8_tree_rules |
| plugin_config |
| plugin_db_changes |
| plugin_fix64bit |
| plugin_hooks |
| plugin_murlin_cache |
| plugin_murlin_index |
| plugin_nectar |
| plugin_nectar_items |
| plugin_nmiddataexport_dataitems |
| plugin_nmidweb2_sort_order |
| plugin_realms |
| plugin_rrdclean |
| plugin_rrdclean_action |
| plugin_spikekill_templates |
| plugin_thold_contacts |
| plugin_thold_log |
| plugin_thold_template_contact |
| plugin_thold_threshold_contact |
| plugin_transporter_poller_output_archive |
| plugin_usersettings |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_output_rt |
| poller_reindex |
| poller_time |
| reports |
| reports_data |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| superlinks_auth |
| superlinks_pages |
| syslog |
| syslog_alert |
| syslog_facilities |
| syslog_host_facilities |
| syslog_hosts |
| syslog_incoming |
| syslog_logs |
| syslog_priorities |
| syslog_remove |
| syslog_removed |
| syslog_reports |
| syslog_statistics |
| thold_data |
| thold_template |
| transporter_table |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
| weathermap_auth |
| weathermap_data |
| weathermap_groups |
| weathermap_maps |
| weathermap_settings |
+------------------------------------------+
126 rows in set (0.00 sec)


Top
 Profile  
 
 Post subject: Re: MYSQL error from cacti log
PostPosted: Mon Dec 26, 2016 8:47 am 
Offline
Cacti User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 482
Answer depends on storage engine in MySQL. Have you run the repair_database.php script?

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group