Arun Natarajan
2017-03-22 09:40:14 UTC
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
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