[Opendnssec-user] upgrade debian Jessie to Stretch: database trouble
dennis at baaten.com
Thu Nov 2 20:22:25 UTC 2017
Cool! I've now been able to complete step 3. However, I ran into some trouble with step 4.
In the current Debian testing package the strftime calls have not been replaced with UNIX_TIMESTAMP(). So I used this mysql_convert.sql version from github: https://github.com/yschaeff/opendnssec/blob/4c45d7a1a1a4d09b58eb94c0a6a392c71fafd2d0/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql and stored it as mysql_convert_patch.sql in /usr/share/opendnssec/. Then I replaced 'REMOTE' with 'opendnssec' using your sed command.
Upon execution the resulted in the following error: "ERROR 1093 (HY000) at line 664: Table 'keyState' is specified twice, both as a target for 'UPDATE' and as a separate source for data.". I find this strange because the support ticket https://issues.opendnssec.org/browse/SUPPORT-205 states that this error has been fixed in the version of mysql_convert.sql I downloaded from github (and stored as mysql_convert_patch.sql).
More information about the Opendnssec-user