[Opendnssec-user] Exporting database schema version is not supported for conversion

[Arun Natarajan]

Hi,

 Trying to convert sqlite kasp.db (1.4.8) to MySQL but getting the
following error:

# ./convert_database.pl --from dbi:SQLite:dbname=/var/opendnssec/kasp.db
--to dbi:mysql:database=kasp;host=localhost --to-username kasp
--to-password kasp

Connected to exporting database dbi:SQLite:dbname=/var/opendnssec/kasp.db
./convert_database.pl: Exporting database schema version is not supported
for conversion.
bash: --to-username: command not found

The kasp.db was originally created for 1.4.7 and later converted to 1.4.8.

$ sqlite3 /var/opendnssec/kasp.db
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> alter table dnsseckeys add column rfc5011 tinyint default 0;
sqlite> alter table dnsseckeys add column revoked tinyint default 0;
sqlite> drop view if exists KEYDATA_VIEW;
sqlite> create view KEYDATA_VIEW as
   ...> select k.id as id, d.state as state, k.generate as generate,
d.publish as publish,
   ...>     d.ready as ready, d.active as active, d.retire as retire,
d.dead as dead,
   ...>     d.keytype as keytype, k.algorithm as algorithm, k.HSMkey_id as
location,
   ...>     d.zone_id as zone_id, k.policy_id as policy_id,
   ...>     k.securitymodule_id as securitymodule_id, k.size as size,
   ...>     k.compromisedflag as compromisedflag,
   ...>     k.fixedDate as fixedDate,
   ...>     d.rfc5011 as rfc5011, d.revoked as revoked
   ...> from  keypairs k left outer join dnsseckeys d
   ...> on k.id = d.keypair_id;
sqlite> insert into parameters (name, description, category_id) select
"revoked", "key is revoked?", id from categories where name="ksk";
sqlite> update dbadmin set version = 4;
sqlite> .exit

appreciate your help.

thanks,
arun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20170322/86bdb248/attachment.htm>