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 (
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 (
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
