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
_______________________________________________ Opendnssec-user mailing list Opendnssec-user@lists.opendnssec.org https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
