> I'm trying to virtualize an Opsview instance (master server only, no > slaves), from a physical > server (32-bit CentOS 5.5 + Opsview 3.91) to a virtual guest (64-bit > CentOS 5.6 + Opsview > 3.11.3) running under KVM. > > Got everything installed and migrated the data (did the export/import > migration procedure > in the wiki in case the 32-bit to 64-bit move affected things). > Everything went pretty > smoothly until I ran upgradedb.pl - it gave this error:
[...] > Duncan Ferguson replies: > > The errors you are seeing would imply a you restored the old opsview database > over a newer > version of the database where the tables already exist, rather than restore > to am empty > database. When the upgrade scripts tries to create the tables they are > already there. > > I would suggest you drop the database on the db server, restore it again and > then run the > upgrade script. Just tried that - dropped opsview, reports, runtime, odw from the db on the new server, re- dumped the database from the old 3.9 box, restored tables on new box, and ran upgradedb.pl - this is the output: [nagios@monitor ~]$ /usr/local/nagios/installer/upgradedb.pl Tue Jul 26 04:39:52 2011: Starting for opsview Tue Jul 26 04:39:52 2011: DB at version 3.9.20 Fix default value for auditlogs table Updated database to version 3.9.21 Tue Jul 26 04:39:52 2011: DB at version 3.9.21 Enforcing keyword name restrictions Updated database to version 3.9.22 Tue Jul 26 04:39:52 2011: DB at version 3.9.22 Add one_time_token option for API sessions Updated database to version 3.9.23 Tue Jul 26 04:39:52 2011: DB at version 3.9.23 Add dependency_level for service checks Updated database to version 3.9.24 Tue Jul 26 04:39:52 2011: DB at version 3.9.24 Fix foreign key constraint for servicechecks - any servicechecks with a servicegroup of NULL will be migrated to the first service group Updated database to version 3.9.25 Tue Jul 26 04:39:52 2011: DB at version 3.9.25 Adding events view timeline default Updated database to version 3.9.26 Tue Jul 26 04:39:53 2011: DB at version 3.9.26 Adding support for host template changes to list of hosts Updated database to version 3.9.27 Tue Jul 26 04:39:53 2011: DB at version 3.11.0 Creating CONFIGUREKEYWORDS access and adding to all roles with CONFIGUREVIEW Updated database to version 3.11.1 Tue Jul 26 04:39:53 2011: DB at version 3.11.1 Updated database to version 3.11.2 Tue Jul 26 04:39:53 2011: DB at version 3.11.2 Adding role_access_hostgroups table Updated database to version 3.11.3 Tue Jul 26 04:39:53 2011: DB at version 3.11.3 Adding role_access_servicegroups table Updated database to version 3.11.4 Tue Jul 26 04:39:53 2011: DB at version 3.11.4 Adding role_access_keywords table Updated database to version 3.11.5 Tue Jul 26 04:39:53 2011: DB at version 3.11.5 Migrating all contacts to new roles Updated database to version 3.11.6 Tue Jul 26 04:39:53 2011: DB at version 3.11.6 Removing redundant tables Updated database to version 3.11.7 Tue Jul 26 04:39:53 2011: DB at version 3.11.7 Adding all_keywords to notification profiles Updated database to version 3.11.8 Tue Jul 26 04:39:53 2011: DB at version 3.11.8 Adding date_format to systempreferences Updated database to version 3.11.9 Tue Jul 26 04:39:53 2011: DB at version 3.11.9 Adding "passive" to monitoringservers Updated database to version 3.11.10 Tue Jul 26 04:39:53 2011: DB at version 3.11.10 Adding tidy_ifdescr_level to hosts Updated database to version 3.11.11 Tue Jul 26 04:39:53 2011: DB at version 3.11.11 Adding snmp_max_msg_size to hosts Updated database to version 3.11.12 Tue Jul 26 04:39:53 2011: DB at version 3.11.12 Creating DOWNTIMESOME and DOWNTIMEALL access and adding to all roles with ACTIONSOME or ACTIONALL Updated database to version 3.11.13 Tue Jul 26 04:39:53 2011: DB at version 3.11.13 Updated database to version 3.11.14 Tue Jul 26 04:39:53 2011: DB at version 3.11.14 Updated database to version 3.11.15 Finished updating Opsview database Tue Jul 26 04:39:53 2011: Finished for opsview Upgrading Nagios part of Runtime database Tue Jul 26 04:39:53 2011: Starting for runtime-nagios Upgrading Opsview part of Runtime database Tue Jul 26 04:39:53 2011: Starting for runtime-opsview Tue Jul 26 04:39:53 2011: DB at version 3.9.0 Adding opsview_contacts table DBD::mysql::db do failed: Table 'opsview_contacts' already exists [for Statement " CREATE TABLE opsview_contacts ( id INT, contact_object_id INT, name varchar(128) NOT NULL, PRIMARY KEY (id), INDEX (contact_object_id, id) ) ENGINE=InnoDB "] at /usr/local/nagios/installer/upgradedb_runtime.pl line 735. Tue Jul 26 04:39:53 2011: Finished for runtime-opsview Tue Jul 26 04:39:53 2011: Finished for runtime-nagios upgrade failed at /usr/local/nagios/installer/upgradedb.pl line 35. _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
