[Pdns-users] Error using pdnsutil with MySQL backend

[Otto Moerbeek]

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-bounces at mailman.powerdns.com> on behalf of Peter van Dijk via Pdns-users <pdns-users at mailman.powerdns.com>
> Sent: 12 April 2021 21:41
> To: 'pdns-users at mailman.powerdns.com' <pdns-users at 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 at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users

> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users