Hi,
I have a setup which I migrated from version 2.14 to 3.0. This migration went pretty fine. But now I try to upgrade to 3.1, and it fails completely at upgrading the database. I could manually solve the error of the access table which could not be created, but now I face this: Setting up opsview-core (3.1.0.2553-1hardy1) ... Database opsview detected - upgrading ... Thu Jun 18 15:39:55 2009: Starting for opsview Thu Jun 18 15:39:55 2009: DB at version 3.1.0 New ACLs DBD::mysql::db do failed: Can't create table './opsview/roles_monitoringservers.frm' (errno: 150) [for Statement " CREATE TABLE roles_monitoringservers ( roleid INT, monitoringserverid INT, PRIMARY KEY (roleid, monitoringserverid), INDEX (roleid), CONSTRAINT roles_monitoringservers_role_fk FOREIGN KEY (roleid) REFERENCES roles(id) ON DELETE CASCADE, INDEX (monitoringserverid), CONSTRAINT roles_monitoringservers_monitoringserver_fk FOREIGN KEY (monitoringserverid) REFERENCES monitoringservers(id) ) ENGINE=InnoDB; "] at /usr/local/nagios/installer/upgradedb_opsview.pl line 1424. Thu Jun 18 15:39:55 2009: Finished for opsview dpkg: error processing opsview-core (--configure): Please help. -- Toni Van Remortel System Engineer @ Precision Operations NV +32 3 451 92 20 - [email protected]
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
