Upgrade to 1.2.10 left me all sort of messed up

[mrscary]

mysql> SHOW ENGINES;
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
| Engine | Support | Comment
| Transactions | XA | Savepoints |
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
| InnoDB | DEFAULT | Supports transactions, row-level locking, and f
oreign keys | YES | YES | YES |
| MRG_MYISAM | YES | Collection of identical MyISAM tables
| NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for tempor
ary tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to
it disappears) | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine
| NO | NO | NO |
| CSV | YES | CSV storage engine
| NO | NO | NO |
| ARCHIVE | YES | Archive storage engine
| NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema
| NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine
| NULL | NULL | NULL |
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
9 rows in set (0.00 sec)

[mrscary]

found my.ini. put in
innodb_file_format=Barracuda
innodb_file_per_table=1 was already in it
innodb_large_prefix=1

restarted mysql
php -q convert_tables.php --innodb --dynamic Converting Database Tables to InnoDB with less than '1000000' Records innodb_file_per_table not enabled

php -q upgrade_database.php --forcever=1.2.10
Your Cacti is already up to date (v1.2.10 vs v1.2.10)

[mrscary]

now it's

mysql> use cacti
Database changed
mysql> SELECT TABLE_NAME, TABLE_TYPE, ENGINE, ROW_FORMAT FROM information_sch
.TABLES WHERE TABLE_SCHEMA='cacti';
+-------------------------------------+------------+--------+------------+
| TABLE_NAME | TABLE_TYPE | ENGINE | ROW_FORMAT |
+-------------------------------------+------------+--------+------------+
| aggregate_graph_templates | BASE TABLE | InnoDB | Dynamic |
| aggregate_graph_templates_graph | BASE TABLE | InnoDB | Dynamic |
| aggregate_graph_templates_item | BASE TABLE | InnoDB | Dynamic |
| aggregate_graphs | BASE TABLE | InnoDB | Dynamic |
| aggregate_graphs_graph_item | BASE TABLE | InnoDB | Dynamic |
| aggregate_graphs_items | BASE TABLE | InnoDB | Dynamic |
| audit_log | BASE TABLE | NULL | NULL |
| automation_devices | BASE TABLE | InnoDB | Dynamic |
| automation_graph_rule_items | BASE TABLE | InnoDB | Dynamic |
| automation_graph_rules | BASE TABLE | InnoDB | Dynamic |
| automation_ips | BASE TABLE | MEMORY | Fixed |
| automation_match_rule_items | BASE TABLE | MyISAM | Dynamic |
| automation_processes | BASE TABLE | MEMORY | Fixed |
| automation_snmp | BASE TABLE | NULL | NULL |
| automation_snmp_items | BASE TABLE | NULL | NULL |
| automation_templates | BASE TABLE | MyISAM | Dynamic |
| automation_tree_rule_items | BASE TABLE | MyISAM | Dynamic |
| automation_tree_rules | BASE TABLE | MyISAM | Dynamic |
| cdef | BASE TABLE | MyISAM | Dynamic |
| cdef_items | BASE TABLE | MyISAM | Dynamic |
| color_template_items | BASE TABLE | NULL | NULL |
| color_templates | BASE TABLE | NULL | NULL |
| colors | BASE TABLE | MyISAM | Dynamic |
| data_input | BASE TABLE | MyISAM | Dynamic |
| data_input_data | BASE TABLE | MyISAM | Dynamic |
| data_input_fields | BASE TABLE | MyISAM | Dynamic |
| data_local | BASE TABLE | MyISAM | Dynamic |
| data_source_profiles | BASE TABLE | NULL | NULL |
| data_source_profiles_cf | BASE TABLE | NULL | NULL |
| data_source_profiles_rra | BASE TABLE | NULL | NULL |
| data_source_purge_action | BASE TABLE | NULL | NULL |
| data_source_purge_temp | BASE TABLE | NULL | NULL |
| data_source_stats_daily | BASE TABLE | NULL | NULL |
| data_source_stats_hourly | BASE TABLE | NULL | NULL |
| data_source_stats_hourly_cache | BASE TABLE | MEMORY | Fixed |
| data_source_stats_hourly_last | BASE TABLE | MEMORY | Fixed |
| data_source_stats_monthly | BASE TABLE | NULL | NULL |
| data_source_stats_weekly | BASE TABLE | NULL | NULL |
| data_source_stats_yearly | BASE TABLE | NULL | NULL |
| data_template | BASE TABLE | MyISAM | Dynamic |
| data_template_data | BASE TABLE | MyISAM | Dynamic |
| data_template_rrd | BASE TABLE | MyISAM | Dynamic |
| graph_local | BASE TABLE | MyISAM | Dynamic |
| graph_template_input | BASE TABLE | MyISAM | Dynamic |
| graph_template_input_defs | BASE TABLE | MyISAM | Fixed |
| graph_templates | BASE TABLE | MyISAM | Fixed |
| graph_templates_gprint | BASE TABLE | MyISAM | Dynamic |
| graph_templates_graph | BASE TABLE | MyISAM | Dynamic |
| graph_templates_item | BASE TABLE | MyISAM | Dynamic |
| graph_tree | BASE TABLE | MyISAM | Dynamic |
| graph_tree_items | BASE TABLE | MyISAM | Dynamic |
| host | BASE TABLE | MyISAM | Dynamic |
| host_graph | BASE TABLE | MyISAM | Fixed |
| host_snmp_cache | BASE TABLE | MyISAM | Dynamic |
| host_snmp_query | BASE TABLE | MyISAM | Dynamic |
| host_template | BASE TABLE | MyISAM | Dynamic |
| host_template_graph | BASE TABLE | MyISAM | Fixed |
| host_template_snmp_query | BASE TABLE | MyISAM | Fixed |
| mac_track_aggregated_ports | BASE TABLE | NULL | NULL |
| mac_track_approved_macs | BASE TABLE | NULL | NULL |
| mac_track_device_types | BASE TABLE | NULL | NULL |
| mac_track_devices | BASE TABLE | NULL | NULL |
| mac_track_dot1x | BASE TABLE | NULL | NULL |
| mac_track_interface_graphs | BASE TABLE | NULL | NULL |
| mac_track_interfaces | BASE TABLE | NULL | NULL |
| mac_track_ip_ranges | BASE TABLE | NULL | NULL |
| mac_track_ips | BASE TABLE | NULL | NULL |
| mac_track_macauth | BASE TABLE | NULL | NULL |
| mac_track_macwatch | BASE TABLE | NULL | NULL |
| mac_track_oui_database | BASE TABLE | NULL | NULL |
| mac_track_ports | BASE TABLE | NULL | NULL |
| mac_track_processes | BASE TABLE | NULL | NULL |
| mac_track_scan_dates | BASE TABLE | NULL | NULL |
| mac_track_scanning_functions | BASE TABLE | NULL | NULL |
| mac_track_sites | BASE TABLE | NULL | NULL |
| mac_track_snmp | BASE TABLE | NULL | NULL |
| mac_track_snmp_items | BASE TABLE | NULL | NULL |
| mac_track_temp_ports | BASE TABLE | NULL | NULL |
| mac_track_vlans | BASE TABLE | NULL | NULL |
| manage_admin_link | BASE TABLE | MyISAM | Dynamic |
| manage_alerts | BASE TABLE | MyISAM | Dynamic |
| manage_groups | BASE TABLE | MyISAM | Dynamic |
| manage_host | BASE TABLE | MyISAM | Dynamic |
| manage_poller_output | BASE TABLE | MyISAM | Dynamic |
| manage_process | BASE TABLE | MyISAM | Dynamic |
| manage_services | BASE TABLE | MyISAM | Dynamic |
| manage_sites | BASE TABLE | MyISAM | Dynamic |
| manage_tcp | BASE TABLE | MyISAM | Dynamic |
| manage_templates | BASE TABLE | MyISAM | Dynamic |
| manage_uptime_method | BASE TABLE | MyISAM | Dynamic |
| plugin_autom8_graph_rule_items | BASE TABLE | NULL | NULL |
| plugin_autom8_graph_rules | BASE TABLE | NULL | NULL |
| plugin_autom8_match_rule_items | BASE TABLE | NULL | NULL |
| plugin_autom8_thold_rule_items | BASE TABLE | MyISAM | Dynamic |
| plugin_autom8_thold_rules | BASE TABLE | MyISAM | Dynamic |
| plugin_autom8_tree_rule_items | BASE TABLE | NULL | NULL |
| plugin_autom8_tree_rules | BASE TABLE | NULL | NULL |
| plugin_config | BASE TABLE | MyISAM | Dynamic |
| plugin_db_changes | BASE TABLE | MyISAM | Dynamic |
| plugin_hooks | BASE TABLE | MyISAM | Dynamic |
| plugin_intropage_panel | BASE TABLE | MyISAM | Dynamic |
| plugin_intropage_trends | BASE TABLE | MyISAM | Dynamic |
| plugin_monitor_notify_history | BASE TABLE | NULL | NULL |
| plugin_monitor_reboot_history | BASE TABLE | NULL | NULL |
| plugin_monitor_uptime | BASE TABLE | NULL | NULL |
| plugin_notification_lists | BASE TABLE | NULL | NULL |
| plugin_realms | BASE TABLE | MyISAM | Dynamic |
| plugin_thold_contacts | BASE TABLE | NULL | NULL |
| plugin_thold_daemon_data | BASE TABLE | NULL | NULL |
| plugin_thold_daemon_processes | BASE TABLE | NULL | NULL |
| plugin_thold_host_failed | BASE TABLE | NULL | NULL |
| plugin_thold_host_template | BASE TABLE | NULL | NULL |
| plugin_thold_log | BASE TABLE | NULL | NULL |
| plugin_thold_template_contact | BASE TABLE | NULL | NULL |
| plugin_thold_threshold_contact | BASE TABLE | NULL | NULL |
| plugin_usersettings | BASE TABLE | MyISAM | Dynamic |
| poller_command | BASE TABLE | MyISAM | Dynamic |
| poller_data_template_field_mappings | BASE TABLE | NULL | NULL |
| poller_item | BASE TABLE | MyISAM | Dynamic |
| poller_output | BASE TABLE | MEMORY | Fixed |
| poller_output_boost | BASE TABLE | NULL | NULL |
| poller_output_boost_processes | BASE TABLE | MEMORY | Fixed |
| poller_output_realtime | BASE TABLE | NULL | NULL |
| poller_reindex | BASE TABLE | MyISAM | Dynamic |
| poller_time | BASE TABLE | NULL | NULL |
| quicktree_graphs | BASE TABLE | NULL | NULL |
| reports | BASE TABLE | MyISAM | Dynamic |
| reports_items | BASE TABLE | MyISAM | Dynamic |
| sessions | BASE TABLE | NULL | NULL |
| settings | BASE TABLE | MyISAM | Dynamic |
| settings_tree | BASE TABLE | MyISAM | Fixed |
| settings_user | BASE TABLE | MyISAM | Dynamic |
| settings_user_group | BASE TABLE | NULL | NULL |
| snmp_query | BASE TABLE | MyISAM | Dynamic |
| snmp_query_graph | BASE TABLE | MyISAM | Dynamic |
| snmp_query_graph_rrd | BASE TABLE | MyISAM | Dynamic |
| snmp_query_graph_rrd_sv | BASE TABLE | MyISAM | Dynamic |
| snmp_query_graph_sv | BASE TABLE | MyISAM | Dynamic |
| snmpagent_cache | BASE TABLE | MyISAM | Dynamic |
| snmpagent_cache_notifications | BASE TABLE | MyISAM | Dynamic |
| snmpagent_cache_textual_conventions | BASE TABLE | MyISAM | Dynamic |
| snmpagent_managers | BASE TABLE | MyISAM | Dynamic |
| snmpagent_managers_notifications | BASE TABLE | MyISAM | Dynamic |
| snmpagent_mibs | BASE TABLE | MyISAM | Dynamic |
| snmpagent_notifications_log | BASE TABLE | MyISAM | Dynamic |
| thold_data | BASE TABLE | NULL | NULL |
| thold_template | BASE TABLE | NULL | NULL |
| user_auth | BASE TABLE | MyISAM | Dynamic |
| user_auth_cache | BASE TABLE | NULL | NULL |
| user_auth_group | BASE TABLE | NULL | NULL |
| user_auth_group_members | BASE TABLE | NULL | NULL |
| user_auth_group_perms | BASE TABLE | NULL | NULL |
| user_auth_group_realm | BASE TABLE | NULL | NULL |
| user_auth_perms | BASE TABLE | MyISAM | Fixed |
| user_auth_realm | BASE TABLE | MyISAM | Fixed |
| user_domains | BASE TABLE | NULL | NULL |
| user_log | BASE TABLE | MyISAM | Dynamic |
| vdef | BASE TABLE | NULL | NULL |
| vdef_items | BASE TABLE | NULL | NULL |
| version | BASE TABLE | MyISAM | Fixed |
+-------------------------------------+------------+--------+------------+
160 rows in set, 140 warnings (0.26 sec)

[TheWitness]

Wrong options here:

php -q upgrade_database.php --forcever=1.2.10

should be

php -q upgrade_database.php --forcever=your.old.version.of.cacti

[mrscary]

my bad..

php -q upgrade_database.php --forcever=1.1.37
Upgrading from v1.1.37
Upgrading from v1.1.37 (DB 1.1.38) to v1.2.0
xxxxxxxxxxxxxx+-xxx+++xxxxx+++x++++xxx++
################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.user_domains_ldap' doe
sn't exist
+------------------------------+
ALTER TABLE `user_domains_ldap` ADD `cn_full_name`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.user_domains_ldap' doe
sn't exist
+------------------------------+
ALTER TABLE `user_domains_ldap` ADD `cn_email`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `max_time`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `min_time`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `avg_time`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `total_polls`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `processes`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `threads`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `sync_interval`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `timezone`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `dbsslkey`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `dbsslcert`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `dbsslca`
################################

################################
[Fail] - DB Exec Failed!, Error 1146: Table 'cacti.poller' doesn't exist

+------------------------------+
UPDATE poller SET processes = 4, threads = 1
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller_resource_cache'
doesn't exist
+------------------------------+
ALTER TABLE `poller_resource_cache` ADD `attributes`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.external_links' doesn'
t exist
+------------------------------+
ALTER TABLE `external_links` ADD `refresh`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.automation_networks' d
oesn't exist
+------------------------------+
ALTER TABLE `automation_networks` ADD `same_sysname`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.automation_networks' d
oesn't exist
+------------------------------+
ALTER TABLE `automation_networks` ADD `notification_enabled`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.automation_networks' d
oesn't exist
+------------------------------+
ALTER TABLE `automation_networks` ADD `notification_email`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.automation_networks' d
oesn't exist
+------------------------------+
ALTER TABLE `automation_networks` ADD `notification_fromname`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.automation_networks' d
oesn't exist
+------------------------------+
ALTER TABLE `automation_networks` ADD `notification_fromemail`
################################

################################
[Fail] - DB Exec Failed!, Error 1813: Tablespace '`cacti`.`data_debug`'
exists.
+------------------------------+
CREATE TABLE `data_debug` ( `id` int(11) unsigned NOT NULL auto_increment, `star
ted` int(11) NOT NULL DEFAULT '0', `done` int(11) NOT NULL DEFAULT '0', `user` i
nt(11) NOT NULL DEFAULT '0', `datasource` int(11) NOT NULL DEFAULT '0', `info` t
ext NOT NULL DEFAULT '', `issue` text NOT NULL NULL DEFAULT '', PRIMARY KEY (`id
`), KEY `user` (`user`), KEY `done` (`done`), KEY `datasource` (`datasource`), K
EY `started` (`started`)) ROW_FORMAT=Dynamic ENGINE=InnoDB COMMENT = 'Datasource
Debugger Information';
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.sites' doesn't exist
+------------------------------+
ALTER TABLE `sites` ADD `zoom`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `last_sync`
################################

################################
[Fail] - DB Row Failed!, Error 1146: Table 'cacti.poller' doesn't exist
+------------------------------+
ALTER TABLE `poller` ADD `requires_sync`
################################

################################
[Fail] - DB Exec Failed!, Error 1146: Table 'cacti.poller' doesn't exist

+------------------------------+
UPDATE poller SET requires_sync = "on" WHERE id != 1
################################

[TheWitness]

Yea, your database is screwed. Likely you either changed the innodb_log_file_size to something different (which corrupts your database), or you took some nasty system failure. You should google "innodb_force_recovery" techniques to recover your database, which generally involves settings the value, dumping the database to a backup file, and then rebuilding the entirety of the database from scratch. If you don't know what else you changes and/or made a backup file, you may be screwed. I was suspecting that there was an InnoDB issue when the convert did not change the engines of your tables. Good luck.

[mrscary]

ive been working fixing the db. i did have a backup of it.. but i hadnt re imported it.
i did that, and cacti said my database wasnt initialized, so i went through the steps on the page to do that,, and at the end i get one error
ERROR 1813 (HY000) at line 13: Tablespace '`cacti`.`aggregate_graph_templates`'
exists.

[mrscary]

im gonna have to bite the bullet and just reinstall everything... or at least just create a new database and recreate all my devices that were in there.

let me ask you this.. how do i just recreate the mysql database so i can start from scratch?

[TheWitness]

If you have a good backup, you can simply drop the cacti database, then recreate it, make sure your InnoDB engine is actually working, and then import the whole thing. After you drop the database, you may have to delete the MySQL cacti directory in the database area. Good luck.

[mrscary]

so i wanted to thank you for your insights.
that said, i decided to start building from scratch.

there's a few templates i lost, and i dont remember where the heck i found em. i have dell powerconnect N3000 series switches.. i was graphing the system temps.. i have a dell powerconnect template that includes temps, but its not showing me the temps.. its blank.. if anyone haa a graph for these devices, id appreciate the help.

i havent learned how to make my own templates yet

[TheWitness]

Not a problem. Answering forum posts is like meditation sometimes, when the person on the other end of the line is not hostile.