> > On 2015/07/22 06:48 PM, Mark Moseley wrote: > >> On Tue, Jul 21, 2015 at 5:00 PM, Gabriel Marais >> <[email protected] <mailto:[email protected]>> wrote: >> >> Hi Guys >> >> Seems like I have hit a brick wall. I have PowerDNS 2.9.x running as >> master and 2 slaves. I am busy moving over to Ubuntu 14.x on newly >> installed servers and as such I ended up with PowerDNS 3.x which is >> not compatible with the older 2.9 schema on MySQL. >> >> I have read in a thread that one could use custom queries to >> overcome the immediate issue of moving a complete DNS implementation >> over to the version 3.x schema but I cannot seem to find the custom >> queries to overcome the issue from my log :- >> >> Jul 22 01:17:46 hubble pdns[2006]: Backend error: Failed to execute >> mysql_query, perhaps connection died? Err=1: Unknown column 'auth' >> in 'field list' >> >> Ultimately, I would like to move over to PowerDNS 3.x but right now >> I need to get another 'slave' working which is sitting on PowerDNS >> 3.x to work with my 2.9 master and database schema. >> >> Can anyone perhaps point me in the right direction with the custom >> queries to accommodate the missing "auth" column in the new DB schema? >> >> >> >> Hi Mark > > Thanks for the reply. This is what I was looking for.. > >> I limped by for a little while with these queries, in the middle of a >> 2.9.x->3.x upgrade. It's been long enough now that I couldn't tell you >> what negative side effects it had, but I do remember that AXFR's did >> *NOT* work with the below queries. IIRC with this setup, AXFRs will >> actually cause a restart of pdns, so you'd want to get off of it pretty >> quick. >> >> I added the queries to my config file, pdns.local.gmysql.conf > But I'm still getting the error on the "auth" field :- > Backend error: Failed to execute mysql_query, perhaps connection died? > Err=1: Unknown column 'auth' in 'field list' > > # Use old queries till we get schema updated >> gmysql-basic-query=SELECT content,ttl,prio,type,domain_id,name FROM >> records WHERE type='%s' and name='%s' >> gmysql-any-id-query=SELECT content,ttl,prio,type,domain_id,name FROM >> records WHERE name='%s' and domain_id=%d >> gmysql-list-query=SELECT content,ttl,prio,type,domain_id,name FROM >> records WHERE 0=%d and domain_id='%d' order by name, type >> >> >> At the same time, the 2.9.x boxes might work just fine (but you'd >> obviously want to test first) with the 3.x schema, though I'm assuming >> you're doing mysql replication. >> >
Must be a different query. You could tcpdump the query and match it up to the list of queries in the pdns docs and adapt it accordingly perhaps.
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
