[Opendnssec-develop] Re: [Opendnssec-user] opendnssec 1.4.4 and mysql

[Jerry Lundström]

Hi Mark,

On tor, 2014-04-03 at 10:51 +0100, Sara Dickinson wrote:
> On 31 Mar 2014, at 15:44, Mark Elkins <mje at posix.co.za> wrote:
> 
> > ods-ksmutil key list:    
> > Keys:
> > ERROR: error executing SQL - Unknown column 'k.zone_id' in 'on clause'
> > Error: failed to list keys

Sadly there is a little bug that passed us by here, the issue is that a
SQL join was made to the key data which is a view and MySQL does not
like this.

> I’ve managed to reproduce this problem locally, but I don’t see it happening on any of our test systems so something a little strange is going on. 

Our tests didn't catch this because there was a miss when we migrated to
GitHub and our tests for 1.3 and 1.4 using MySQL was actually running
SQLite, that has been fixed now.

We will of course start working on this and release a fixed version
ASAP!

Also note that this bug only affects "key list" and should not disrupt
services and 1.3 is not affected.

Thanks for reporting this.
Cheers
Jerry

-- 
Jerry Lundström - OpenDNSSEC Developer
http://www.opendnssec.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 620 bytes
Desc: This is a digitally signed message part
URL: <http://lists.opendnssec.org/pipermail/opendnssec-develop/attachments/20140403/61c28839/attachment.bin>