[Pdns-users] NXDOMAIN for noon authoritative zone

[Peter van Dijk]

Hello Riccardo,

On Fri, 2022-10-28 at 14:37 +0000, Riccardo Brunetti via Pdns-users
wrote:
> Thanks for your answer.
> Maybe I found the issue:
> 
> mysql> select * from records where domain_id=13203;
> +------+-----------+------+------+-------------------------------------
> -----------------------------------------+------+------+----------+----
> -------+------+
> | id   | domain_id | name | type |
> content                                                                
>       | ttl  | prio | disabled | ordername | auth |
> +------+-----------+------+------+-------------------------------------
> -----------------------------------------+------+------+----------+----
> -------+------+
> | 6309 |     13203 | .    | SOA  | a.misconfigured.powerdns.server
> hostmaster 2020032401 10800 3600 604800 3600 | 3600 |    0 |        0 |
> NULL      |    1 |
> +------+-----------+------+------+-------------------------------------
> -----------------------------------------+------+------+----------+----
> -------+------+
> 1 row in set (0.00 sec)
> There is an entry (probably a mistake with some API call) which shows a
> bad SOA entry in a domain with only a "." in the "name" column.

That would explain the NXDOMAINs.

> In fact, the query for a non existent domain returns something like:
> 
> # dig @my-dns-server-IP non-existent-domain

I asked you, once on-list, once off-list, to show unedited data. Please
respect this next time you ask something. For more information, see
https://blog.powerdns.com/2016/01/18/open-source-support-out-in-the-open/

> Do you think it's safe to simply remove it?
> 
> update records set disabled=1 where id=6309;
> delete from records where id=6309;

The update is not very useful if you're going to delete it right after.

Don't forget to also delete it from the domains table. Perhaps pdnsutil
is a safer approach.

Kind regards,
-- 
Peter van Dijk
PowerDNS.COM BV - https://www.powerdns.com/