Issue to import DB from 0.8.8f to 1.2.21

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
jackouille
Cacti User
Posts: 71
Joined: Thu Apr 26, 2012 7:41 am

Re: Issue to import DB from 0.8.8f to 1.2.21

Post by jackouille »

MariaDB [cacti]> show create table automation_devices;
+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| automation_devices | CREATE TABLE `automation_devices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`network_id` int(10) unsigned NOT NULL DEFAULT 0,
`hostname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`ip` varchar(17) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`snmp_community` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`snmp_version` tinyint(1) unsigned NOT NULL DEFAULT 1,
`snmp_port` mediumint(5) unsigned NOT NULL DEFAULT 161,
`snmp_username` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`snmp_password` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`snmp_auth_protocol` char(6) COLLATE utf8mb4_unicode_ci DEFAULT '',
`snmp_priv_passphrase` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT '',
`snmp_priv_protocol` char(6) COLLATE utf8mb4_unicode_ci DEFAULT '',
`snmp_context` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '',
`snmp_engine_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '',
`sysName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sysLocation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sysContact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sysDescr` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sysUptime` bigint(20) unsigned NOT NULL DEFAULT 0,
`os` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`snmp` tinyint(4) NOT NULL DEFAULT 0,
`known` tinyint(4) NOT NULL DEFAULT 0,
`up` tinyint(4) NOT NULL DEFAULT 0,
`time` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `ip` (`ip`),
KEY `hostname` (`hostname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Table of Discovered Devices' |

So yes the id field is already present and in bigint format, where can I remove the ALTER ?
Top
User avatar
TheWitness
Developer
Posts: 17061
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Issue to import DB from 0.8.8f to 1.2.21

Post by TheWitness »

Well, that's kind of odd, the upgrade database is supposed to drop the old table plugin_discover_hosts via a rename. See if that table still exists. If it does, drop it. Then try the forcever again.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
jackouille
Cacti User
Posts: 71
Joined: Thu Apr 26, 2012 7:41 am

Re: Issue to import DB from 0.8.8f to 1.2.21

Post by jackouille »

Congratulations !!!

I dropped the table and got the following:
2022-07-31 19:59:03 - INSTALL: always: Installation was started at 2022-07-31 17:58:54, completed at 2022-07-31 17:59:03
2022-07-31 19:59:03 - INSTALL: always: Finished UPGRADE Process for v1.2.21
2022-07-31 19:59:03 - INSTALL: always: No templates were selected for import
2022-07-31 19:59:03 - INSTALL: always: Upgrading from v1.2.20 (DB 1.2.20) to v1.2.21
2022-07-31 19:59:03 - INSTALL: always: Upgrading from v1.2.19 (DB 1.2.19) to v1.2.20
2022-07-31 19:59:02 - INSTALL: always: Upgrading from v1.2.17 (DB 1.2.17) to v1.2.19
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.15 (DB 1.2.15) to v1.2.17
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.14 (DB 1.2.14) to v1.2.15
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.11 (DB 1.2.11) to v1.2.14
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.8 (DB 1.2.8) to v1.2.11
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.7 (DB 1.2.7) to v1.2.8
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.5 (DB 1.2.5) to v1.2.7
2022-07-31 19:59:00 - INSTALL: always: Repairing Automation Rules
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.3 (DB 1.2.3) to v1.2.5
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.2 (DB 1.2.2) to v1.2.3
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.1 (DB 1.2.1) to v1.2.2
2022-07-31 19:59:00 - INSTALL: always: Upgrading from v1.2.0 (DB 1.2.0) to v1.2.1
2022-07-31 19:58:59 - INSTALL: always: Upgrading from v1.1.37 (DB 1.1.37) to v1.2.0
2022-07-31 19:58:59 - INSTALL: always: Upgrading from v1.1.36 (DB 1.1.36) to v1.1.37
2022-07-31 19:58:59 - INSTALL: always: Upgrading from v1.1.35 (DB 1.1.35) to v1.1.36
2022-07-31 19:58:59 - INSTALL: always: Upgrading from v1.1.34 (DB 1.1.34) to v1.1.35
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.31 (DB 1.1.31) to v1.1.34
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.28 (DB 1.1.28) to v1.1.31
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.26 (DB 1.1.26) to v1.1.28
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.20 (DB 1.1.20) to v1.1.26
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.17 (DB 1.1.17) to v1.1.20
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.14 (DB 1.1.14) to v1.1.17
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.11 (DB 1.1.11) to v1.1.14
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.8 (DB 1.1.8) to v1.1.11
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.7 (DB 1.1.7) to v1.1.8
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.6 (DB 1.1.6) to v1.1.7
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.4 (DB 1.1.4) to v1.1.6
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.1.2 (DB 1.1.2) to v1.1.4
2022-07-31 19:58:58 - INSTALL: always: Upgrading from v1.0.5 (DB 1.0.5) to v1.1.2
2022-07-31 19:58:57 - INSTALL: always: Upgrading from v1.0.4 (DB 1.0.4) to v1.0.5
2022-07-31 19:58:57 - INSTALL: always: Upgrading from v1.0.0 (DB 1.0.0) to v1.0.4
2022-07-31 19:58:55 - INSTALL: always: Upgrading from v0.8.8h (DB 1.2.21 (DB: 0.8.8h)) to v1.0.0
2022-07-31 19:58:55 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cdu6GGx2q
2022-07-31 19:58:55 - INSTALL: always: Switched from to /tmp/cdu6GGx2q
2022-07-31 19:58:55 - INSTALL: always: No tables where found or selected for conversion
2022-07-31 19:58:55 - INSTALL: always: Starting UPGRADE Process for v1.2.21
2022-07-31 19:58:54 - INSTALL: always: Setting PHP Option memory_limit = -1
2022-07-31 19:58:54 - INSTALL: always: Setting PHP Option max_execution_time = 0
2022-07-31 19:58:54 - INSTALL: Checking arguments
2022-07-31 19:58:54 - INSTALL: always: Spawning background process: /usr/bin/php '/usr/share/cacti/install/background.php' 1659290334.568
Top
User avatar
TheWitness
Developer
Posts: 17061
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Re: Issue to import DB from 0.8.8f to 1.2.21

Post by TheWitness »

Cool. Glad you got it fixed.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 2 guests