Upgrade from cacti 0.8.8.f to 1.0.0

[EagleRed]

Hello,
I'm using Ubuntu server 16.10 with cacti 0.8.8.f and I would like to upgrade to cacti 1.0.0.

Are there any new source to do the upgrade?

Thank you for your support.

Best Regards,
EagleRed

[kjstech]

In /tmp I just did wget http://www.cacti.net/downloads/cacti-1.0.0.tar.gz
then extracted it...
tar -zxvf cacti1.0.0.tar.gz
backed up existing cacti database
mysqldump -l -ucactiuser -pPassword --add-drop-table cacti > mysql.cacti
mv old cacti install to cacti_old
mv extracted cacti-1.0.0 to /var/www/cacti
edit /include/config.php with proper mysql database info
copy old cacti rra files to new cacti rra directory (took awhile)
Copied relevant scripts
custom xml files copied
ensured permissions were set
then went to the cacti webpage and found a boatload of mysql stuff I had to remediate before I could continue.
Like I had to populate timezone info into mysql
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot mysql -pPassword
edited /etc/mysql/my.cnf under the [mysqld] section to add all the extra innodb, max_heap_table_size, tmp_table_size, Join_buffer_size, etc...
in phpmyadmin ran SET time_zone = 'US/Eastern'
then in command line did service mysqld restart and then finally cacti allowed me to page through and complete the install.

[dbqandersons]

Thanks kjstech for the tips and thoughts. I'll be trying this in the next couple of days.

Question about this line of yours:

"edited /etc/mysql/my.cnf under the [mysqld] section to add all the extra innodb, max_heap_table_size, tmp_table_size, Join_buffer_size, etc..."

How did you know what to add/update?

Thanks in advance.

Bill Anderson
Dubuque, Iowa

[kjstech]

Thanks kjstech for the tips and thoughts. I'll be trying this in the next couple of days.

Question about this line of yours:

"edited /etc/mysql/my.cnf under the [mysqld] section to add all the extra innodb, max_heap_table_size, tmp_table_size, Join_buffer_size, etc..."

How did you know what to add/update?

Thanks in advance.

Bill Anderson
Dubuque, Iowa

Sure, yeah when you go through it and access the cacti web page, it pretty much walks you through what variables need changed. I needed quite a few changes but depending on your installation you may (or may not) need these or different alterations. Once that's done you refresh the page and it should let you proceed next through the dB upgrade and then finally onto the upgrades installation.

[csalcedo1024]

Almost worked for me..
granted full permission to cacti user:
grant all privileges on *.* to cacti@localhost identified by 'cacti';

I get this error on upgrade:

WARNING: One or more of the SQL queries needed to upgraded your Cacti installation has failed. Please see below for more details.
Your Cacti MySQL user must have SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE, and DROP permissions.
You should try executing the failed queries as "root" to ensure that you do not have a permissions problem.

Granted all permissions to the user.

This is the error when it tries to create the table poller_output_boost (everything else is success including creation of other tables)The table does not get created.:

[Fail] CREATE TABLE IF NOT EXISTS `poller_output_boost` (
`local_data_id` mediumint(8) unsigned NOT NULL default '0',
`rrd_name` varchar(19) NOT NULL default '',
`time` timestamp NOT NULL default '0000-00-00 00:00:00',
`output` varchar(512) NOT NULL,
PRIMARY KEY USING BTREE (`local_data_id`,`rrd_name`,`time`))
ENGINE=InnoDB ROW_FORMAT=FIXED

List of table:

+-------------------------------------+
| Tables_in_cacti |
+-------------------------------------+
| aggregate_graph_templates |
| aggregate_graph_templates_graph |
| aggregate_graph_templates_item |
| aggregate_graphs |
| aggregate_graphs_graph_item |
| aggregate_graphs_items |
| automation_devices |
| automation_graph_rule_items |
| automation_graph_rules |
| automation_ips |
| automation_match_rule_items |
| automation_networks |
| automation_processes |
| automation_snmp |
| automation_snmp_items |
| automation_templates |
| automation_tree_rule_items |
| automation_tree_rules |
| cdef |
| cdef_items |
| color_template_items |
| color_templates |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_source_profiles |
| data_source_profiles_cf |
| data_source_profiles_rra |
| data_source_purge_action |
| data_source_purge_temp |
| 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_rrd |
| external_links |
| 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_query |
| 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_hooks |
| plugin_realms |
| poller |
| poller_command |
| poller_data_template_field_mappings |
| poller_item |
| poller_output |
| poller_output_boost_processes |
| poller_output_realtime |
| poller_reindex |
| poller_resource_cache |
| poller_time |
| reports |
| reports_items |
| sessions |
| settings |
| settings_tree |
| settings_user |
| settings_user_group |
| sites |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| snmpagent_cache |
| snmpagent_cache_notifications |
| snmpagent_cache_textual_conventions |
| snmpagent_managers |
| snmpagent_managers_notifications |
| snmpagent_mibs |
| snmpagent_notifications_log |
| user_auth |
| user_auth_cache |
| user_auth_group |
| user_auth_group_members |
| user_auth_group_perms |
| user_auth_group_realm |
| user_auth_perms |
| user_auth_realm |
| user_domains |
| user_domains_ldap |
| user_log |
| vdef |
| vdef_items |
| version |
+-------------------------------------+

[Osiris]

On that boost table create error. What version of MySQL?

[beeri]

I have exactly the same problem. "[Fail] CREATE TABLE IF NOT EXISTS `poller_output_boost` (....."

my MYSQL Version is : mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

someone have an idea how to fix it ?

[monkeyboy04]

I also have the exact same problem.

cacti version 1.02
mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

I have exactly the same problem. "[Fail] CREATE TABLE IF NOT EXISTS `poller_output_boost` (....."

my MYSQL Version is : mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

someone have an idea how to fix it ?

[rony]

Fixed in 1.0.3