(posted to Opsview forum but am not seeing any traffic there)
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:
[nagios@monitor ~]$ /usr/local/nagios/installer/upgradedb.pl
Fri Jul 8 12:15:29 2011: Starting for opsview
Opsview database already up to date
Fri Jul 8 12:15:29 2011: Finished for opsview
Upgrading Nagios part of Runtime database
Fri Jul 8 12:15:29 2011: Starting for runtime-nagios
Upgrading Opsview part of Runtime database
Fri Jul 8 12:15:29 2011: Starting for runtime-opsview
Fri Jul 8 12:15:29 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.
Fri Jul 8 12:15:29 2011: Finished for runtime-opsview
Fri Jul 8 12:15:29 2011: Finished for runtime-nagios
upgrade failed at /usr/local/nagios/installer/upgradedb.pl line 35.
I commented that create table portion of the code, and it went on to
error on a subsequent create table - commented that, and it again
went to another similar error on a different table.
When I eventually commented all the code portions that were
attempting to create duplicate tables, I got Opsview running in the
VM, but the config info was incomplete - all hosts, groups, etc would
appear in the config area, but the host groups overview for example
was empty. Regenerating the config didn't change this.
Any help or suggestions would be greatly appreciated!
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
