On 10 Dec 2009, at 14:32, John harris wrote: Thanks for the response Duncan. I followed the directions, but I got an error when I did the upgradedb.pl.
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 1490.
Wed Dec 9 11:33:00 2009: Finished for opsview
upgrade failed at usr/local/nagios/installer/upgradedb.pl line 35.
This looks like a previous upgrade was interrupted for some reason before it was completed. Best thing is to look through the upgradedb_opsview.pl around line 1490 and perform any remaining SQL statements before upping the version within the schema_version table for major_release 3.1
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 UK 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/lists/listinfo/opsview-users
