[Opendnssec-user] migration whacks me

[Siôn Lloyd]

On 03/08/13 15:40, Randy Bush wrote:
> FreeBSD rip.psg.com 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #0 r243557: Mon Nov 26 09:10:55 UTC 2012     root at rip.psg.com:/usr/obj/usr/src/sys/GENERIC  amd64
>
> portupgraded from 1.4.0 to 1.4.1
>
> on restart, logged
>
> Aug  3 14:12:25 rip ods-enforcerd: group set to: opendnssec (3007)
> Aug  3 14:12:25 rip ods-enforcerd: user set to: opendnssec (3007)
> Aug  3 14:12:25 rip ods-enforcerd: ERROR: database version number incompatible with software; require 3, found 2. Please run the migration scripts
> Aug  3 14:12:25 rip ods-enforcerd: Database connection failed
>
> but
>
> # perl /usr/ports/dns/opendnssec/work/opendnssec-1.4.1/enforcer/utils/migrate_keyshare_sqlite3.pl -d /usr/local/var/opendnssec/kasp.db
> DBD::SQLite::db do failed: duplicate column name: state at enforcer/utils/migrate_keyshare_sqlite3.pl line 75.
> Couldn't add column state: Inappropriate ioctl for device at enforcer/utils/migrate_keyshare_sqlite3.pl line 75.
>
> randy
>

By the looks of the error message this is an upgrade from 1.3 to 1.4
(rather than 1.4.0 to 1.4.1)?

The migration script for this transition is in
"enforcer/utils/migrate_adapters_1.sqlite3". This script is actually
just some sql to run against your database; consisting of the following
lines:

    alter table zones add column in_type varchar(512) default "File";
    alter table zones add column out_type varchar(512) default "File";

    update dbadmin set version = 3;

Which allows the different input and output adapters to be used.

Sion