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
