[Pdns-users] Strange resolve Problems

[Daniel Eschner]

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