[Pdns-users] Powerdns recursion fails after I import old SQL data
nux at li.nux.ro
Wed Aug 5 14:03:50 UTC 2015
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!
Sent from the Delta quadrant using Borg technology!
----- 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
> 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:
> 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:
> 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
> 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:
> 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. :)
> Sent from the Delta quadrant using Borg technology!
More information about the Pdns-users