You might want to clean up your database... it is not a good idea to have several different SOA enties with different domain id's for same domain.
Aki On Tue, May 13, 2014 at 09:12:02AM +0000, Daniel Eschner wrote: > 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 _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
