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.
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
