Please use a more recent version of the script: https://github.com/opendnssec/opendnssec/blob/develop/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql
//Yuri On 02-11-17 21:22, Dennis Baaten wrote: > 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). >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
