[Opendnssec-user] sqllite upgrade to 1.4.18

Discussion:

Randy Bush

2017-05-04 02:33:41 UTC

freebsd 10.3

portmaster opendnssec tells me

===>>> pkg-message for opendnssec-1.4.14
Always:
This file gives you instructions on how to migrate from one version of
OpenDNSSEC to another.

*** Migrating from 1.4.X to 1.4.8 ***

As of 1.4.8 the database has changes slightly. To migrate between databases
run the SQL statements given in:

enforcer/utils/migrate_1_4_8.sqlite3
or
enforcer/utils/migrate_1_4_8.mysql

against your existing database.

but it barfs when i try to do so

/usr/ports/dns/opendnssec/work/opendnssec-1.4.14# sqlite3 < enforcer/utils/migrate_1_4_8.sqlite3
Error: near line 3: no such table: dnsseckeys
Error: near line 4: no such table: dnsseckeys
Error: near line 19: no such table: parameters
Error: near line 21: no such table: dbadmin

clue bat please

randy

Eliot Lear

2017-05-04 04:42:16 UTC

Permalink

Hi Randy,

Post by Randy Bush
freebsd 10.3
portmaster opendnssec tells me
===>>> pkg-message for opendnssec-1.4.14
This file gives you instructions on how to migrate from one version of
OpenDNSSEC to another.
*** Migrating from 1.4.X to 1.4.8 ***
As of 1.4.8 the database has changes slightly. To migrate between databases
enforcer/utils/migrate_1_4_8.sqlite3
or
enforcer/utils/migrate_1_4_8.mysql
against your existing database.
but it barfs when i try to do so
/usr/ports/dns/opendnssec/work/opendnssec-1.4.14# sqlite3 < enforcer/utils/migrate_1_4_8.sqlite3
Error: near line 3: no such table: dnsseckeys
Error: near line 4: no such table: dnsseckeys
Error: near line 19: no such table: parameters
Error: near line 21: no such table: dbadmin
clue bat please

You need to specify the database name as the argument to sqlite3. Be
sure to make a copy first.

Eliot

Randy Bush

2017-05-04 08:27:43 UTC

Permalink

Post by Eliot Lear
You need to specify the database name as the argument to sqlite3. Be
sure to make a copy first.

# sqlite3 /usr/local/var/opendnssec/kasp.db < /usr/ports/dns/opendnssec/work/opendnssec-1.4.14/enforcer/utils/migrate_1_4_8.sqlite3
Error: near line 3: duplicate column name: rfc5011
Error: near line 4: duplicate column name: revoked
Error: near line 19: UNIQUE constraint failed: parameters.name, parameters.category_id

warmer, i guess. thanks.

randy

Yuri Schaeffer

2017-05-04 08:31:28 UTC

Permalink

Post by Randy Bush
# sqlite3 /usr/local/var/opendnssec/kasp.db < /usr/ports/dns/opendnssec/work/opendnssec-1.4.14/enforcer/utils/migrate_1_4_8.sqlite3
Error: near line 3: duplicate column name: rfc5011
warmer, i guess. thanks.

It seems the migration script was already run on this database. No
further steps required.

Did you come from a OpenDNSSEC version < 1.4.8?

//Yuri

Randy Bush

2017-05-04 08:46:24 UTC

Permalink

Post by Yuri Schaeffer
It seems the migration script was already run on this database.

ahh

Post by Yuri Schaeffer
Did you come from a OpenDNSSEC version < 1.4.8?

# ods-getconf --version
opendnssec version 1.4.14

Eliot Lear

2017-05-04 09:05:29 UTC

Permalink

This seems to indicate that the db is already converted.

Post by Randy Bush

Post by Eliot Lear
You need to specify the database name as the argument to sqlite3. Be
sure to make a copy first.