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. [email protected]. 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 > [email protected] > http://mailman.powerdns.com/mailman/listinfo/pdns-users
signature.asc
Description: Digital signature
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
