[Pdns-users] DNSKEY query with mysql backend gives "Authoritative empty NO ERROR"

[Andrew Wade]

Hello,

 I'm using PowerDNS Version 2.9.21, MySQL 5.0.45. I have a 'records'
 table with a record with what I wish to lookup:

 id     domain_id   name              type          content
 24          2        domain.com      #48     183 3 5  (<KEY>)

 I'm querying with dig:

 dig @127.0.0.1 -p 5300 -t dnskey domain.com +norecurse +multiline

 ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 13200
 ;; flags: qr aa; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

 But I get no reply, just the SOA.

 PowerDNS monitor gives: Apr 07 08:40:56 Authoritative empty NO ERROR
 to 127.0.0.1 for 'domain.com' (#48), other types do exist

 Am I not storing the record correctly in the MySQL table?
 Sorry if its something blatantly obvious.

 Thanks!