[Pdns-users] pdnsutil tools discrepancy with backend content

[Mike Lopes]

Hi all,

Today while auditing a few zones, I noticed that when I run one of the following I am not seeing all the records that are supposed to be in the zone.

# pdnsutil list-zone 29.0.10.in-addr.arpa
$ORIGIN .
29.0.10.in-addr.arpa 3600    IN      NS      ns2.example.com.
29.0.10.in-addr.arpa 3600    IN      NS      ns. example.com.
29.0.10.in-addr.arpa 3600    IN      SOA     ns2. example.com dnsadmin. example.com 2019121721 900 600 86400 3600

# pdnsutil check-zone 29.0.10.in-addr.arpa
Checked 3 records of '29.0.10.in-addr.arpa', 0 errors, 0 warnings.

When I check my postgresql backend however, I see this, which is what’s supposed to be in the zone:

# select * from records where name LIKE '%29.0.10.in-addr.arpa%';
    id     | domain_id |            name             | type |                               content                                |  ttl  | prio | change_date | disabled | ordername | auth
-----------+-----------+-----------------------------+------+----------------------------------------------------------------------+-------+------+-------------+----------+-----------+------
466105138 |      8475 | 29.0.10.in-addr.arpa     | SOA  | ns2.example.com dnsadmin. example.com 2019121721 900 600 86400 3600 |  3600 |    0 |             | f        |           | t
466105139 |      8475 | 29.0.10.in-addr.arpa     | NS   | ns. example.com                                                      |  3600 |    0 |             | f        |           | t
466105140 |      8475 | 29.0.10.in-addr.arpa     | NS   | ns2. example.com                                                     |  3600 |    0 |             | f        |           | t
466105141 |      8475 | 1.29.0.10.in-addr.arpa   | PTR  | bdr01. example.com                                      | 21600 |    0 |             | f        |           | t
466105142 |      8475 | 41.29.0.10.in-addr.arpa  | PTR  | bdr02. example.com                                      | 21600 |    0 |             | f        |           | t
466105143 |      8475 | 222.29.0.10.in-addr.arpa | PTR  | agg01. example.com                                      | 21600 |    0 |             | f        |           | t

When doing a dig to this server it does not work when querying those records, querying the soa and ns records return correct data.
When I try to add records with pdnsutil edit-zone 29.0.10.in-addr.arpa, it adds to the backend but a pdns list-zone 29.0.10.in-addr.arpa returns the same 3 records, the SOA and both ns records…

I am really puzzled about this and would appreciate any clues that would help me resolve this.

Thanks.

-Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20191217/637f3194/attachment.htm>