Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Tip

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:

Code Block
enforcer/utils/convert_database.pl

In 1.4 the supported backends are SQLite and MySQL. 

Note

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:

Code Block
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:

Code Block
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
Info

Also see the MIGRATION file in the source code.