Skip to end of metadata
Go to start of metadata

See the database section of the installation guide for guidance on the difference between the supported backends. 

Migration script

In 1.4 a script has been provided to enable users to migrate between the supported backends for a given version of OpenDNSSEC. The script is located here:

enforcer/utils/convert_database.pl

In 1.4 the supported backends are SQLite and MySQL. 

You must create the MySQL database and database user manually before converting to MySQL.

If users wish to convert to another OpenDNSSEC version you need to migrate existing database to that version first - see Migrating from earlier versions of OpenDNSSEC.

Examples

Convert from SQLite to MySQL:

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

Convert from MySQL to SQLite:

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

Also see the MIGRATION file in the source code. 

  • No labels