[Opendnssec-user] upgrade debian Jessie to Stretch: database trouble

[Yuri Schaeffer]

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).
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20171102/fdd9ac25/attachment.bin>