[Opendnssec-user] sqllite upgrade to 1.4.18

[Eliot Lear]

Hi Randy,


On 5/4/17 4:33 AM, Randy Bush wrote:
> 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
>

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

Eliot

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 481 bytes
Desc: OpenPGP digital signature
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20170504/475de609/attachment.bin>