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

[Nux!]

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