Hi,
I'm using
Sep 13 15:26:46 PowerDNS Authoritative Server 3.3
([email protected]) (C) 2001-2013 PowerDNS.COM BV
Sep 13 15:26:46 Using 64-bits mode. Built on 20130717102032 by
[email protected], gcc 4.4.5.
Sep 13 15:26:46 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free
software, and you are welcome to redistribute it according to the terms of the
GPL version 2.
I just noticed that an axfr (example:)
dig axfr die-optimisten.net
;; global options: +cmd
die-optimisten.net. 86400 IN SOA ns-gmx.ui-dns.org.
hostmaster.gmx.net. 2012120600 28800 7200 604800 86400
die-optimisten.net. 86400 IN NS ns-gmx.ui-dns.org.
die-optimisten.net. 86400 IN NS ns-gmx.ui-dns.com.
die-optimisten.net. 86400 IN NS ns-gmx.ui-dns.de.
die-optimisten.net. 86400 IN NS ns-gmx.ui-dns.biz.
die-optimisten.net. 86400 IN A 213.165.65.50
die-optimisten.net. 86400 IN MX 10 mx00.gmx.net.
die-optimisten.net. 86400 IN MX 10 mx01.gmx.net.
die-optimisten.net. 86400 IN TXT "v=spf1 redirect=gmx.net"
_jabber._tcp.die-optimisten.net. 86400 IN SRV 5 0 5269 jabber.gmx.net.
_xmpp-client._tcp.die-optimisten.net. 86400 IN SRV 5 0 5222 jabber.gmx.net.
_xmpp-server._tcp.die-optimisten.net. 86400 IN SRV 5 0 5269 jabber.gmx.net.
imap.die-optimisten.net. 86400 IN CNAME imap.gmx.net.
localhost.die-optimisten.net. 86400 IN A 127.0.0.1
mail.die-optimisten.net. 86400 IN CNAME mail.gmx.net.
pop.die-optimisten.net. 86400 IN CNAME pop.gmx.net.
smtp.die-optimisten.net. 86400 IN CNAME smtp.gmx.net.
www.die-optimisten.net. 86400 IN CNAME service.gmx.net.
die-optimisten.net. 86400 IN SOA ns-gmx.ui-dns.org.
hostmaster.gmx.net. 2012120600 28800 7200 604800 86400
;; Query time: 2 msec
I cleaned the zone with
delete from where
and did a
pdns_control retrieve die-optimisten.net
Now the zone looks in the mysql database like this:
mysql> select * from records where domain_id=2734;
+-----------+-----------+--------------------------------------+-------+---------------------------------------------------------------------------+-------+------+---------------------+
| id | domain_id | name | type |
content | ttl
| prio | change_date |
+-----------+-----------+--------------------------------------+-------+---------------------------------------------------------------------------+-------+------+---------------------+
| 160510146 | 2734 | die-optimisten.net | SOA |
ns-gmx.ui-dns.org. hostmaster.gmx.net. 2012120600 28800 7200 604800 86400 |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510147 | 2734 | die-optimisten.net | NS |
ns-gmx.ui-dns.org |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510148 | 2734 | die-optimisten.net | NS |
ns-gmx.ui-dns.com |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510149 | 2734 | die-optimisten.net | NS |
ns-gmx.ui-dns.de |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510150 | 2734 | die-optimisten.net | NS |
ns-gmx.ui-dns.biz |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510151 | 2734 | die-optimisten.net | A |
213.165.65.50 |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510152 | 2734 | die-optimisten.net | MX |
mx00.gmx.net |
86400 | 10 | 2013-09-13 15:30:08 |
| 160510153 | 2734 | die-optimisten.net | MX |
mx01.gmx.net |
86400 | 10 | 2013-09-13 15:30:08 |
| 160510154 | 2734 | die-optimisten.net | TXT | "v=spf1
redirect=gmx.net" | 86400 | 0 |
2013-09-13 15:30:08 |
| 160510155 | 2734 | _jabber._tcp.die-optimisten.net | SRV | 0 5269
jabber.gmx.net | 86400 |
5 | 2013-09-13 15:30:08 |
| 160510156 | 2734 | _xmpp-client._tcp.die-optimisten.net | SRV | 0 5222
jabber.gmx.net | 86400 |
5 | 2013-09-13 15:30:08 |
| 160510157 | 2734 | _xmpp-server._tcp.die-optimisten.net | SRV | 0 5269
jabber.gmx.net | 86400 |
5 | 2013-09-13 15:30:08 |
| 160510158 | 2734 | imap.die-optimisten.net | CNAME |
imap.gmx.net |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510159 | 2734 | localhost.die-optimisten.net | A |
127.0.0.1 |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510160 | 2734 | mail.die-optimisten.net | CNAME |
mail.gmx.net |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510161 | 2734 | pop.die-optimisten.net | CNAME |
pop.gmx.net |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510162 | 2734 | smtp.die-optimisten.net | CNAME |
smtp.gmx.net |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510163 | 2734 | www.die-optimisten.net | CNAME |
service.gmx.net |
86400 | 0 | 2013-09-13 15:30:08 |
| 160510164 | 2734 | _tcp.die-optimisten.net | NULL | NULL
| NULL |
NULL | 2013-09-13 15:30:08 |
+-----------+-----------+--------------------------------------+-------+---------------------------------------------------------------------------+-------+------+---------------------+
19 rows in set (0.01 sec)
You see record id 160510164.
It wasn't in the axfr. I have longer zones with 20 to 40 NULL records
which are duplicates of real names. As long as the type is NULL the
select will probably not return them to powerdns, But select * from
records where type is null; returns 12561 rows :-(
How do I stop this?
Thomas
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
