[Opendnssec-user] OpenDNSSEC 2.1.0 released

[Sebastian Wiesinger]

* Yuri Schaeffer <yuri at nlnetlabs.nl> [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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 581 bytes
Desc: Digital signature
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20170420/3f57cbac/attachment.bin>