Re: [opsview-users] Upgrade to 3.1 fails

Duncan Ferguson Thu, 18 Jun 2009 07:07:35 -0700

On 18 Jun 2009, at 14:45, Toni Van Remortel wrote:

I could manually solve the error of the access table which could not be created, but now I face this:

What error of the access table being created? What was the mysql error number and the error message at the time?

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):

What version of MySQL are you using and what OS/arch is this on? Looks like Ubuntu Hardy?

Duncs

Duncan Ferguson
Senior Developer

Opsera Limited | Unit 69 Suttons Business Park
Reading | Berkshire | RG6 1AZ | UK

Phone:   +44 (0) 845 057 7887
Mobile:   +44 (0) 7968 148 748
Skype:   duncan_j_ferguson     Email:   [email protected]
www.opsera.com

Opsera Limited is registered in the

under Company Number 5396532. Our registered office is Gorse View, Horsell Rise, Woking, Surrey, GU21 4RB.

_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/listinfo/opsview-users

Re: [opsview-users] Upgrade to 3.1 fails

Reply via email to