[Opendnssec-user] OpenDNSSEC 2.1.0 released

[Yuri Schaeffer]

Hi Sebastian,

> Converting database
> ERROR 1064 (42000) at line 663: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near '--Set to OMN if Tactive + Dttl < Tnow
> UPDATE keyState
> SET state = 2
> WHERE keySta' at line 1

Can you try the below patch? (also attached in case it gets messed up by
the mail formatting)

Depending on the version MySQL is somewhat picky on how comments are
written. It should be "-- " instead of "--".

//Yuri


diff --git a/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql
b/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql
index 8a985497c..de16058fa 100644
--- a/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql
+++ b/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql
@@ -660,7 +660,7 @@ JOIN REMOTE.dnsseckeys
 JOIN mapping
        ON mapping.state = REMOTE.dnsseckeys.state;

---Set to OMN if Tactive + Dttl < Tnow
+-- Set to OMN if Tactive + Dttl < Tnow
 UPDATE keyState
 SET state = 2
 WHERE keyState.state = 1 AND keyState.type = 1 AND keyState.id IN (
@@ -676,8 +676,8 @@ WHERE keyState.state = 1 AND keyState.type = 1 AND
keyState.id IN (
                 ON policy.id = zone.policyId
         WHERE CAST(UNIX_TIMESTAMP(REMOTE.dnsseckeys.active) +
policy.signaturesValidityDefault as INTEGER) < UNIX_TIMESTAMP(now()));

---Force the RRSIG state in omnipresent if rumoured and there is no old ZSK
---unretentive
+-- Force the RRSIG state in omnipresent if rumoured and there is no old ZSK
+-- unretentive
 UPDATE keyState
 SET state = 2
 WHERE keyState.id IN (

-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql_convert.diff
Type: text/x-patch
Size: 1065 bytes
Desc: not available
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20170420/9882daa9/attachment.bin>
-------------- 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/20170420/9882daa9/attachment-0001.bin>