[Pdns-users] Powerdns recursion fails after I import old SQL data

[Nux!]

Problem solved,

Thanks Lieter at Freenode again. It was no coincidence that domain_id=435 kept showing up.
The SOA entry for that domain had no "name"; once I put the domain's name there everything started working as expected.

Have a nice day!
Lucian

--
Sent from the Delta quadrant using Borg technology!

Nux!
www.nux.ro

----- Original Message -----
> From: "Nux!" <nux at li.nux.ro>
> To: pdns-users at mailman.powerdns.com
> Sent: Wednesday, 5 August, 2015 14:48:11
> Subject: Powerdns recursion fails after I import old SQL data

> Hello,
> 
> I'm having a very weird problem with PowerDNS (auth server) where it replies to
> all recursive queries with NXDOMAIN after I import my old db/data.
> 
> The first problem is I have an old custom DB schema which looks like this:
> http://tmp.nux.ro/powerdnsri/oldschemaconfig.txt
> 
> In that same file you can see the gmysql instructions for PowerDNS. This has
> worked fine on v2.9.22.
> 
> Today we are trying to get more up to date and also back to the stock schema.
> 
> We installed PowerDNS 3.4.5, imported the stock mysql schema, imported in the
> same DB the old tables & data then run the following SQL in order to move
> things around how the server expects them:
> http://tmp.nux.ro/powerdnsri/old2newstock.txt
> 
> After these changes things seemingly work; domains that are registered in the DB
> can be resolved/queried using `host` or `dig` against `127.0.0.1`, however
> there is a problem, recursion has stopped working despite having the proper
> config:
> allow-recursion=127.0.0.0/8
> recursor=4.2.2.3
> 
> It works fine with the empty stock mysql schema, it stops working once I import
> my stuff.
> 
> When trying to make a recursive query for e.g. linux.ro I get all the time
> NXDOMAIN and the following in /var/log/messages:
> http://tmp.nux.ro/powerdnsri/failquerylog.txt
> 
> No matter which domain I try to query, the log will always show that "and
> domain_id=435" - that is not the last domain id in my DB and as far as I can
> tell there is nothing special about it; not sure why it keeps popping up in the
> query log!
> 
> Here's the config I'm using: http://tmp.nux.ro/powerdnsri/newconfig.txt
> 
> I did some initial debugging on IRC with "Lieter", but to no avail.
> 
> Does anyone have any ideas? I need recursion to work. :)
> 
> 
> Thanks,
> Lucian
> 
> 
> 
> 
> --
> Sent from the Delta quadrant using Borg technology!
> 
> Nux!
> www.nux.ro