On Thu, 2010-04-29 at 13:53 +0100, Ton Voon wrote:
> On 29 Apr 2010, at 13:44, Ispas Paul wrote:
>
> > I upgraded opsview today (Centos 5.4 x86_64) and got the following
> > error when trying to update config for a host :
> >
> >
> > undef error - DBD::mysql::st execute failed: Unknown column
> > 'flap_detection_enabled' in 'field list' [for Statement "SELECT
> > hostgroup, http_admin_url, http_admin_port, icon, monitored_by,
> > notification_interval, notification_options, notification_period,
> > check_command, check_period, check_interval, retry_check_interval,
> > check_attempts, snmp_version, snmp_community, snmpv3_username,
> > snmpv3_authpassword, snmpv3_authprotocol, snmpv3_privprotocol,
> > snmpv3_privpassword, other_addresses, snmptrap_tracing,
> > flap_detection_enabled, use_nmis, nmis_node_type, use_rancid,
> > rancid_vendor, rancid_username, rancid_password,
> > rancid_connection_type, rancid_autoenable, uncommitted FROM hosts
> > WHERE id=? " with ParamValues: 0='16'] at /usr/local/nagios/perl/lib/
> > DBIx/ContextualFetch.pm line 52.
>
> Can you run /usr/local/nagios/installer/upgradedb.pl and capture the
> output? This should be run as part of the upgrade.
{blade}[r...@nms ~]# /usr/local/nagios/installer/upgradedb.pl
Thu Apr 29 16:02:40 2010: Starting for opsview
Thu Apr 29 16:02:40 2010: DB at version 3.6.0
Creating CONFIGUREVIEW and CONFIGURESAVE access and adding to all roles
with ADMINACCESS
Updated database to version 3.6.1
Thu Apr 29 16:02:40 2010: DB at version 3.7.0
Adding extra columns to notificationmethods
DBD::mysql::db do failed: Table 'contact_variables' already exists [for
Statement "
CREATE TABLE contact_variables (
contactid int NOT NULL,
name varchar(128) NOT NULL,
value TEXT NOT NULL,
PRIMARY KEY (contactid, name),
INDEX (contactid),
CONSTRAINT contact_variables_contactid_fk FOREIGN KEY
(contactid) REFERENCES contacts(id) ON DELETE CASCADE
) ENGINE=InnoDB;
"] at /usr/local/nagios/installer/upgradedb_opsview.pl line 1806.
Thu Apr 29 16:02:40 2010: Finished for opsview
upgrade failed at /usr/local/nagios/installer/upgradedb.pl line 35.
:(
>
> There have been schema changes for flap_detection_enabled for the host.
>
> Ton
>
> _______________________________________________
> Opsview-users mailing list
> Opsview-users@lists.opsview.org
> http://lists.opsview.org/lists/listinfo/opsview-users
_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users
