[Pdns-users] Strange resolve Problems

[Aki Tuomi]

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 info at tophoster.de 2014033001 10800 3600 604800 86400 |
> 86400 | NULL | SOA  |    181386 | altersvorsorgen.org |
> | ns1.top-hoster.de info at tophoster.de 2014050901 10800 3600 604800 86400 |
> 86400 | NULL | SOA  |    232896 | altersvorsorgen.org |
> | ns1.top-hoster.de info at tophoster.de 2014033001 10800 3600 604800 86400 |
> 86400 | NULL | SOA  |    229001 | altersvorsorgen.org |
> +------------------------------------------------------------------------+-
> ------+------+------+-----------+---------------------+
> 3 rows in set (0.00 sec)
> 
> 
> 
>  
> 
> -----Ursprüngliche Nachricht-----
> Von: Daniel Eschner <der at sfhost.de>
> Datum: Dienstag, 13. Mai 2014 10:57
> An: bert hubert <bert.hubert at netherlabs.nl>
> Cc: "pdns-users at mailman.powerdns.com" <pdns-users at mailman.powerdns.com>
> Betreff: Re: [Pdns-users] Strange resolve Problems
> 
> >Hi there,
> >
> >Here you get all strange outouts:
> >
> >[root at dedusns03 ~]# pdnssec rectify-zone altersvorsorgen.org.
> >No SOA known for 'altersvorsorgen.org.', is such a zone in the database?
> >
> >[root at 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 <bert.hubert at netherlabs.nl>
> >Datum: Montag, 12. Mai 2014 23:53
> >An: Daniel Eschner <der at sfhost.de>
> >Cc: "pdns-users at mailman.powerdns.com" <pdns-users at mailman.powerdns.com>
> >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 info at tophoster.de 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 <bert.hubert at netherlabs.nl>
> >>> Datum: Montag, 12. Mai 2014 23:40
> >>> An: Daniel Eschner <der at sfhost.de>
> >>> Cc: "pdns-users at mailman.powerdns.com" <pdns-users at mailman.powerdns.com>
> >>> 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
> >Pdns-users at mailman.powerdns.com
> >http://mailman.powerdns.com/mailman/listinfo/pdns-users
> 
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users