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/ _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
