cacti DB failed, updgrade lost everything

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Moderators, Developers

Author
Message
mrscary
Cacti User
Posts: 58
Joined: Tue Aug 26, 2014 2:58 pm

Re: cacti DB failed, updgrade lost everything

#76 Post by mrscary » Wed Mar 28, 2018 7:17 am

well to rehash an old issue... (not so old)
I was no longer getting my graphs, or alerts.
after a days' worth of bangin my head.. I found I had some bad data in the tables.. ran a repair_database.php.. seemed to be successful, but still no graphs.. bunch of error about BOOST, etc.
so this morning I upgraded to the latest revision of CACTI.. the upgrade with with zero errors, but my home page is still showing me a bad table in the database, but I don't know how to figure out which table, or how to fix it.. repair_database.php shows it to be fine.. here's my errors and such.. any idea on what to do? kinda lost at this point.. again

Version 1.1.29
DBProblem
Connection errors:0
Damaged Tables:1
Memory Tables:5
All Tables:138
2018/03/28 06:40:15 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost' doesn't exist
2018/03/28 06:39:51 - BOOST NOTE: Updating Local Data ID:'10', Total of '0' Updates to Process
2018/03/28 06:40:14 - POLLER: Poller[1] WARNING: Invalid Response(s), Errors[2] Device
2018/03/28 06:40:02 - CMDPHP WARNING: SNMP Error:'snmpget(): Error in packet at 'SNMPv2-SMI::enterprises.77.1.2.3.1.3.5.77.121.83.81.76': (noSuchName) There is no such variable name in this MIB.', Device:'localhost', OID:'.1.3.6.1.4.1.77.1.2.3.1.3.5.77.121.83.81.76'

netniV
Cacti Guru User
Posts: 2808
Joined: Sun Aug 27, 2017 12:05 am

Re: cacti DB failed, updgrade lost everything

#77 Post by netniV » Wed Mar 28, 2018 7:39 am

Use the upgrade_database.php --force-ver=0.8.8
You may get some errors but any tables it needs to create etc should be done.

mrscary
Cacti User
Posts: 58
Joined: Tue Aug 26, 2014 2:58 pm

Re: cacti DB failed, updgrade lost everything

#78 Post by mrscary » Wed Mar 28, 2018 7:40 am

ok today is getting worse.. now I cant get into the settings page.. I get an http 500 error..

mrscary
Cacti User
Posts: 58
Joined: Tue Aug 26, 2014 2:58 pm

Re: cacti DB failed, updgrade lost everything

#79 Post by mrscary » Wed Mar 28, 2018 7:41 am

netniV wrote:Use the upgrade_database.php --force-ver=0.8.8
You may get some errors but any tables it needs to create etc should be done.
C:\inetpub\wwwroot\cacti\cli>php upgrade_database.php --force-ver=0.8.8
ERROR: Invalid Parameter --force-ver=0.8.8

Cacti Database Upgrade Utility, Version 1.1.37, Copyright (C) 2004-2018 The Cact
i Group

usage: upgrade_database.php [--debug] [--forcever=VERSION]

A command line version of the Cacti database upgrade tool. You must execute
this command as a super user, or someone who can write a PHP session file.
Typically, this user account will be apache, www-run, or root.

If you are running a beta or alpha version of Cacti and need to rerun
the upgrade script, simply set the forcever to the previous release.

--forcever - Force the starting version, say 1.1.37
--debug - Display verbose output during execution

mrscary
Cacti User
Posts: 58
Joined: Tue Aug 26, 2014 2:58 pm

Re: cacti DB failed, updgrade lost everything

#80 Post by mrscary » Wed Mar 28, 2018 7:44 am

ok I am in.. I can get to the setting page.
home page still shows a bad table in the database.

mrscary
Cacti User
Posts: 58
Joined: Tue Aug 26, 2014 2:58 pm

Re: cacti DB failed, updgrade lost everything

#81 Post by mrscary » Wed Mar 28, 2018 8:38 am

most graphs are graphing again.
still got a 'bad table' in the database.. how do I determine what table is bad , and\or fix it?

mrscary
Cacti User
Posts: 58
Joined: Tue Aug 26, 2014 2:58 pm

Re: cacti DB failed, updgrade lost everything

#82 Post by mrscary » Wed Mar 28, 2018 9:28 am

ran mysqlcheck without having the switches to fix the databases.. found this


cacti.aggregate_graph_templates OK
cacti.aggregate_graph_templates_graph OK
cacti.aggregate_graph_templates_item OK
cacti.aggregate_graphs OK
cacti.aggregate_graphs_graph_item OK
cacti.aggregate_graphs_items OK
cacti.audit_log OK
cacti.automation_devices OK
cacti.automation_graph_rule_items OK
cacti.automation_graph_rules OK
cacti.automation_ips
note : The storage engine for the table doesn't support check
cacti.automation_match_rule_items OK
cacti.automation_networks OK
cacti.automation_processes
note : The storage engine for the table doesn't support check
cacti.automation_snmp OK
cacti.automation_snmp_items OK
cacti.automation_templates OK
cacti.automation_tree_rule_items OK
cacti.automation_tree_rules OK
cacti.cdef OK
cacti.cdef_items OK
cacti.color_template_items OK
cacti.color_templates OK
cacti.colors OK
cacti.data_input OK
cacti.data_input_data OK
cacti.data_input_fields OK
cacti.data_local OK
cacti.data_source_profiles OK
cacti.data_source_profiles_cf OK
cacti.data_source_profiles_rra OK
cacti.data_source_purge_action OK
cacti.data_source_purge_temp OK
cacti.data_source_stats_daily OK
cacti.data_source_stats_hourly OK
cacti.data_source_stats_hourly_cache
note : The storage engine for the table doesn't support check
cacti.data_source_stats_hourly_last
note : The storage engine for the table doesn't support check
cacti.data_source_stats_monthly OK
cacti.data_source_stats_weekly OK
cacti.data_source_stats_yearly OK
cacti.data_template OK
cacti.data_template_data OK
cacti.data_template_rrd OK
cacti.external_links 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.mac_track_aggregated_ports OK
cacti.mac_track_approved_macs OK
cacti.mac_track_device_types OK
cacti.mac_track_devices OK
cacti.mac_track_dot1x OK
cacti.mac_track_interface_graphs OK
cacti.mac_track_interfaces OK
cacti.mac_track_ip_ranges OK
cacti.mac_track_ips OK
cacti.mac_track_macauth OK
cacti.mac_track_macwatch OK
cacti.mac_track_oui_database OK
cacti.mac_track_ports OK
cacti.mac_track_processes OK
cacti.mac_track_scan_dates OK
cacti.mac_track_scanning_functions OK
cacti.mac_track_sites OK
cacti.mac_track_snmp OK
cacti.mac_track_snmp_items OK
cacti.mac_track_temp_ports OK
cacti.mac_track_vlans OK
cacti.manage_admin_link OK
cacti.manage_alerts OK
cacti.manage_groups OK
cacti.manage_host OK
cacti.manage_poller_output OK
cacti.manage_process OK
cacti.manage_services OK
cacti.manage_sites OK
cacti.manage_tcp OK
cacti.manage_templates OK
cacti.manage_uptime_method OK
cacti.plugin_autom8_graph_rule_items OK
cacti.plugin_autom8_graph_rules OK
cacti.plugin_autom8_match_rule_items OK
cacti.plugin_autom8_thold_rule_items OK
cacti.plugin_autom8_thold_rules OK
cacti.plugin_autom8_tree_rule_items OK
cacti.plugin_autom8_tree_rules OK
cacti.plugin_config OK
cacti.plugin_db_changes OK
cacti.plugin_hooks OK
cacti.plugin_intropage_panel OK
cacti.plugin_intropage_trends OK
cacti.plugin_monitor_notify_history OK
cacti.plugin_monitor_reboot_history OK
cacti.plugin_monitor_uptime OK
cacti.plugin_notification_lists OK
cacti.plugin_realms
warning : Found row where the auto_increment column has the value 0
status : OK
cacti.plugin_thold_contacts OK
cacti.plugin_thold_daemon_data OK
cacti.plugin_thold_daemon_processes OK
cacti.plugin_thold_host_failed OK
cacti.plugin_thold_host_template OK
cacti.plugin_thold_log OK
cacti.plugin_thold_template_contact OK
cacti.plugin_thold_threshold_contact OK
cacti.plugin_usersettings OK
cacti.poller OK
cacti.poller_command OK
cacti.poller_data_template_field_mappings OK
cacti.poller_item OK
cacti.poller_output
note : The storage engine for the table doesn't support check
cacti.poller_output_boost OK
cacti.poller_output_boost_processes
note : The storage engine for the table doesn't support check
cacti.poller_output_realtime OK
cacti.poller_reindex OK
cacti.poller_resource_cache OK
cacti.poller_time OK
cacti.quicktree_graphs OK
cacti.reports OK
cacti.reports_items OK
cacti.sessions OK
cacti.settings OK
cacti.settings_tree OK
cacti.settings_user OK
cacti.settings_user_group OK
cacti.sites 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.snmpagent_cache OK
cacti.snmpagent_cache_notifications OK
cacti.snmpagent_cache_textual_conventions OK
cacti.snmpagent_managers OK
cacti.snmpagent_managers_notifications OK
cacti.snmpagent_mibs OK
cacti.snmpagent_notifications_log OK
cacti.thold_data OK
cacti.thold_template OK
cacti.user_auth OK
cacti.user_auth_cache OK
cacti.user_auth_group OK
cacti.user_auth_group_members OK
cacti.user_auth_group_perms OK
cacti.user_auth_group_realm OK
cacti.user_auth_perms OK
cacti.user_auth_realm OK
cacti.user_domains OK
cacti.user_domains_ldap OK
cacti.user_log OK
cacti.vdef OK
cacti.vdef_items OK
cacti.version OK

Post Reply