[Pdns-users] Error using pdnsutil with MySQL backend

[tach yon]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20210413/6e2a5db3/attachment.htm>