pdnssec rectify-zone adds useless data to MySQL

[croessner]

Hi,

I am using Ubuntu Trusty /14.04.1). First I tested the version provided with the release itself (3.3-2), but this caused the same error as I am going to describe right now, and afterwards I took the 3.3.1 trusty-backports version. This version does have the same issue.

Version: pdns-server 3.3.1-4ubuntu14.04.1
Backend: pdns-backend-mysql 3.3.1-4ubuntu14.04.1
DNSSEC: Yes
OS: Ubuntu 14.04.1 LTS
Installed from trusty-backports

Description of the problem:

After I created a new zone (using PoerAdmin-2.1.7), I have a zone containing SOA, NS, MX and some othe RRs. Nothing special. If I go to the command line and run:

pdnssec rectify-zone exampleserver.de
pdnssec add-zone-key exampleserver.de zsk
pdnssec add-zone-key exampleserver.de ksk

Whenever rectify is called, the command adds these rows to MySQL:

As you can see, there are lines that do not contain useful information. I double-checked it and it really only exists in the database. Even if I remove all bogus lines with:

delete from records where content is NULL

and re-invoking rectify-zone, the line are added again. I do not know how to get this fixed. So I guess that is a bug.

Kind regards

[zeha]

This is by design. I'd say your fronted has a bug in not hiding the rows that have type set to NULL.