Here we go again, The mysql table seems to have more entries for some domains:
mysql> select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='altersvorsorgen.org'; +------------------------------------------------------------------------+- ------+------+------+-----------+---------------------+ | content | ttl | prio | type | domain_id | name | +------------------------------------------------------------------------+- ------+------+------+-----------+---------------------+ | ns1.top-hoster.de [email protected] 2014033001 10800 3600 604800 86400 | 86400 | NULL | SOA | 181386 | altersvorsorgen.org | | ns1.top-hoster.de [email protected] 2014050901 10800 3600 604800 86400 | 86400 | NULL | SOA | 232896 | altersvorsorgen.org | | ns1.top-hoster.de [email protected] 2014033001 10800 3600 604800 86400 | 86400 | NULL | SOA | 229001 | altersvorsorgen.org | +------------------------------------------------------------------------+- ------+------+------+-----------+---------------------+ 3 rows in set (0.00 sec) -----Ursprüngliche Nachricht----- Von: Daniel Eschner <[email protected]> Datum: Dienstag, 13. Mai 2014 10:57 An: bert hubert <[email protected]> Cc: "[email protected]" <[email protected]> Betreff: Re: [Pdns-users] Strange resolve Problems >Hi there, > >Here you get all strange outouts: > >[root@dedusns03 ~]# pdnssec rectify-zone altersvorsorgen.org. >No SOA known for 'altersvorsorgen.org.', is such a zone in the database? > >[root@dedusns03 ~]# pdnssec check-zone altersvorsorgen.org. >No SOA for zone 'altersvorsorgen.org.' > >In the log i just see: > > > >May 13 04:56:17 ns4 pdns[11182]: Remote 109.91.117.23 wants >'altersvorsorgen.org|A', do = 0, bufsize = 512: packetcache MISS >May 13 04:56:17 ns4 pdns[11182]: Query: select >content,ttl,prio,type,domain_id,name from records where type='SOA' and >name='altersvorsorgen.org' >May 13 04:56:17 ns4 pdns[11182]: Query: select >content,ttl,prio,type,domain_id,name from records where >name='altersvorsorgen.org' and domain_id=229001 > > > >Just an idea.. It Seems that the domain_ID isnt correct. > >mysql> SELECT * FROM `domains` WHERE `name` = 'altersvorsorgen.org' ; >+--------+---------------------+--------+------------+------+------------- >- >---+---------+ >| id | name | master | last_check | type | >notified_serial | account | >+--------+---------------------+--------+------------+------+------------- >- >---+---------+ >| 232896 | altersvorsorgen.org | NULL | NULL | | >2014050901 | NULL | >+--------+---------------------+--------+------------+------+------------- >- >---+---------+ >1 row in set (0.02 sec) > >Why he has that old Domain_ID? Maybe thats the reason why some domains >cant be resolved. > > > >-----Ursprüngliche Nachricht----- >Von: bert hubert <[email protected]> >Datum: Montag, 12. Mai 2014 23:53 >An: Daniel Eschner <[email protected]> >Cc: "[email protected]" <[email protected]> >Betreff: Re: [Pdns-users] Strange resolve Problems > >>On Mon, May 12, 2014 at 09:48:23PM +0000, Daniel Eschner wrote: >>> Hi Bert, >>> >>> SOA still exists: >>> >>> 00 | 10 | 2014 | >>> | 5225955 | 232896 | altersvorsorgen.org | SOA | >>> ns1.top-hoster.de [email protected] 2014050901 10800 3600 604800 86400 >> >>Ok - your dump didn't show it. Try pdnssec check-zone >>altersvorsorgen.org. >>also try pdnssec rectify altersvorsorgen.org. >> >>If that doesn't show anything, try enabling 'query-logging' and >>'loglevel=9' >>to see what queries powerdns is sending. >> >> Bert >> >> >>> >>> >>> >>> >>> >>> -----Ursprüngliche Nachricht----- >>> Von: bert hubert <[email protected]> >>> Datum: Montag, 12. Mai 2014 23:40 >>> An: Daniel Eschner <[email protected]> >>> Cc: "[email protected]" <[email protected]> >>> Betreff: Re: [Pdns-users] Strange resolve Problems >>> >>> >On Mon, May 12, 2014 at 09:32:08PM +0000, Daniel Eschner wrote: >>> >> ysql> SELECT * FROM `records` WHERE `domain_id` = 232896; >>> > >>> >This should show SOA records. In older verions of PowerDNS, things >>>would >>> >accidentally work w/o SOA records. But no more. >>> > >>> >So add those, and things will work. >>> > >>> > Bert >>> > >_______________________________________________ >Pdns-users mailing list >[email protected] >http://mailman.powerdns.com/mailman/listinfo/pdns-users _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
