Problem solved, Thanks Lieter@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!" <[email protected]> > To: [email protected] > 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 _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
