[Pdns-users] Need help re: Remote tried to sneak in out-of-zone data ''|SOA during AXFR of zone

[Aki Tuomi]

On Tue, Feb 18, 2014 at 11:29:02AM -0500, Chris Moody wrote:
> Thanks for the suggestions Peter.
> 
> That SELECT returns just a single successful row. (The '.' was just
> added to the suffix of the primary & hostmaster fields as I'm
> actively trying to debug what's going on).
> 
> ===
> mysql> SELECT * FROM records WHERE domain_id=457 AND type='SOA';
> +-------+-----------+---------------+------+-------+------+-----------------------------------------------------------------------+-----------+------+----------+
> | id    | domain_id | name          | type | ttl   | prio | content
> | ordername | auth | disabled |
> +-------+-----------+---------------+------+-------+------+-----------------------------------------------------------------------+-----------+------+----------+
> | 35275 |       457 | node-nine.com | SOA  | 86400 | NULL |
> ns1.node-nine.com. postmaster at node-nine.com. 0 10800 3600 604800
> 3600 | NULL      | NULL |     NULL |
> +-------+-----------+---------------+------+-------+------+-----------------------------------------------------------------------+-----------+------+----------+
> 1 row in set (0.00 sec)
> ===
> 
> the pdnssec command returned a couple duplicate records, which I
> just removed, but still seeing the same errors in the logs.
> 
> I've turned on mysql query logging to see if I can find some more
> clues.  Are there any other queries you can think of that may help
> me find the trouble?
> 
> I'm actually even beginning to question whether or not I've got all
> the tables & whatnot built correctly.  I just added another new
> domain and am seeing the same condition.
> 
> -Chris
> 
> On 2/18/14 10:48 AM, Peter van Dijk wrote:
> >SELECT * FROM records WHERE domain_id=457 AND type='SOA';
> 

Can you try SELECT * FROM records WHERE name = "." OR name = ""

> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20140218/83b39dfe/attachment-0001.sig>