Duncan Ferguson wrote:
>
> 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?
DBD::mysql::db do failed: Table 'access' already exists [for Statement "
CREATE TABLE access (
id int AUTO_INCREMENT,
name varchar(128) NOT NULL,
PRIMARY KEY (id),
UNIQUE (name)
) ENGINE=InnoDB
"] at /usr/local/nagios/installer/upgradedb_opsview.pl line 1404.
Because it was already created by the first try (which also stopped on
the error below).
>
>> 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
Ubuntu Hardy indeed. Default installation.
I saw too late that my MySQL config didn't had
'innodb_file_per_table=1', so I added it.
Thanks,
Toni
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/listinfo/opsview-users
