[Pdns-users] Error using pdnsutil with MySQL backend

[tach yon]

Perfect, thanks muchly!

Kind regards,
tach

________________________________
From: Otto Moerbeek <otto at drijf.net>
Sent: 13 April 2021 14:28
To: tach yon <tachyon at live.co.uk>
Cc: 'pdns-users at mailman.powerdns.com' <pdns-users at mailman.powerdns.com>; Peter van Dijk <peter.van.dijk at powerdns.com>
Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20210416/64631b42/attachment.htm>