See https://docs.powerdns.com/authoritative/upgrading.html
-Otto On Tue, Apr 13, 2021 at 01:25:29PM +0000, tach yon via Pdns-users wrote: > Hi Peter, > > Oh I see, there was a syntax change that I didn't encounter whilst testing on > a temporary slave. Good to know, thanks! > > Also thanks for the tip about "account" - saved me the headache of that. > > Thanks very much for the assist, the list-zone function works fine now! 🙂 > > Ah, we've just been tracking the version provided by the CentOS repos. I will > plan changing to version 4.4 in the coming weeks. > > Just to double check please, does PowerDNS make any necessary database > changes automatically? Or does it need to be done manually? I was trying to > find details in the docs on this, but didn't have any luck so far. > > Thanks again for the help. > > Kind regards, > tach > > > > ________________________________ > From: Pdns-users <pdns-users-boun...@mailman.powerdns.com> on behalf of Peter > van Dijk via Pdns-users <pdns-users@mailman.powerdns.com> > Sent: 12 April 2021 21:41 > To: 'pdns-users@mailman.powerdns.com' <pdns-users@mailman.powerdns.com> > Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend > > On Mon, 2021-04-12 at 12:38 +0000, tach yon via Pdns-users wrote: > > # change zone check to have conditional on status > > gmysql-info-zone-query=select > > id,name,master,last_check,notified_serial,type from domains where name='%s' > > and status='A' > > The original query in 4.1 is > > select id,name,master,last_check,notified_serial,type,account from > domains where name=? > > Compared to that, you have used %s instead of ? (which explains your > error), and you forgot the 'account' column (which you will probably > run into once you fix the ? ) > > Also, please note that 4.1.x is End Of Life ( > https://doc.powerdns.com/authoritative/appendices/EOL.html). We > strongly suggest upgrading to 4.4, as 4.2 will also go End Of Life > within a month or two. > > Kind regards, > -- > Peter van Dijk > PowerDNS.COM BV - https://www.powerdns.com/ > > _______________________________________________ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users > _______________________________________________ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users