/usr/share/doc/opendnssec-common/MIGRATION is in opendnssec-common 1:1.4.9-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 | This file gives you instructions on how to migrate from one version of
OpenDNSSEC to another.
*** Migrating from 1.4.X to 1.4.8 ***
As of 1.4.8 the database has changes slightly. To migrate between databases
run the SQL statements given in:
enforcer/utils/migrate_1_4_8.sqlite3
or
enforcer/utils/migrate_1_4_8.mysql
against your existing database.
*** Fix for MySQL zone delete issue ***
As reported in:
https://issues.opendnssec.org/browse/OPENDNSSEC-338
This effects MySQL databases created after 1.4.0a3 or 1.3.9 where zone deletion was changed.
If you wish to fix this without losing any existing information then run the sql statements
given in:
enforcer/utils/migrate_zone_delete.mysql
against your database.
Note that sqlite is not effected as we do not enforce any constraints.
*** Migrating from 1.3 to trunk/1.4 ***
r5914 has some kasp database changes to allow for an update to the zonelist.xml schema.
This means that if you want to use this version or any after it with a database created
earlier you will need to do one of 2 things...
1) wipe and recreate your kasp database (run ods-ksmutl setup) which will lose all of
your current state.
If you need to keep your key information then,
2) run the sql statements given in:
enforcer/utils/migrate_adapters_1.mysql
or
enforcer/utils/migrate_adapters_1.sqlite3
against your existing database.
These changes allow flexibility in the input and output adapters.
*** Migrating from v1.2 to v1.3 ***
There are no migration scripts to run to make this transition.
*** Migrating from v1.1 to v1.2 ***
There is a kasp schema change from the 1.1 branch (or trunk if you built
prior to r3823). To make this transition you have 2 options:
1) Run ods-ksmutil setup again. This will remove _all_ the current
information from the kasp database and start you off again with a fresh
environment.
If that is not an option, or you want to try something else then:
2) run one of the migration scripts
enforcer/utils/migrate_keyshare_mysql.pl
or
enforcer/utils/migrate_keyshare_sqlite3.pl
depending on your database.
NOTE: Although these scripts have been tested it is recommended to make a
backup of your database prior to running them.
*** Migrating to a larger keypairs(id) field (MySQL ONLY) ***
The version of the MySQL database that was created with v1.2 (and prior to
svn r4465) had a smallint datatype for the keypairs(id) field. This limits
the number of keys that the system can store to 32767.
If this number is not large enough then the script:
enforcer/utils/migrate_id_mysql.pl
will increase it to an int, which can store 2147483647 keys.
NOTES: Although this scripts have been tested it is recommended to make a
backup of your database prior to running them.
This issue only applies to MySQL backends.
*** Migrating between SQLite <=> MySQL (same OpenDNSSEC version) ***
convert_database.pl located in enforcer/utils can be used to convert
between SQLite and MySQL on the same OpenDNSSEC version. If you wish to
convert to another OpenDNSSEC version you need to migrate existing
database to that version first.
NOTE: You must create the MySQL database and database user manually
before converting to MySQL.
Convert from SQLite to MySQL example:
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 example:
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
|