* Yuri Schaeffer <[email protected]> [2017-04-20 14:37]: > 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 "--".
That worked but it failed later on:
Creating database opendnssec20 (as user opendnssec)
Creating tables in opendnssec20 (as user opendnssec)
Converting database
ERROR 1064 (42000) at line 664: 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 'INTEGER) < UNIX_TIMESTAMP(now()))' at line
14
When I comment that part out I get:
Creating database opendnssec20 (as user opendnssec)
Creating tables in opendnssec20 (as user opendnssec)
Converting database
ERROR 1064 (42000) at line 681: 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 '== rs.keyDataId
WHERE rs.type == 1 AND dk.type == 2 AND rs.state == 1 AND dk.sta' at
line 5
And on to the next error:
Creating database opendnssec20 (as user opendnssec)
Creating tables in opendnssec20 (as user opendnssec)
Converting database
ERROR 1064 (42000) at line 697: 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 '== keyData.id
JOIN keyState AS KS2
ON KS2.keyDataId == keyData.id
JOIN (
SELE' at line 5
So... yeah
Regards
Sebastian
--
GPG Key: 0x93A0B9CE (F4F6 B1A3 866B 26E9 450A 9D82 58A2 D94A 93A0 B9CE)
'Are you Death?' ... IT'S THE SCYTHE, ISN'T IT? PEOPLE ALWAYS NOTICE THE SCYTHE.
-- Terry Pratchett, The Fifth Elephant
signature.asc
Description: Digital signature
_______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
