[Pdns-users] Strange resolve Problems

[Daniel Eschner]

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
>>