[Pdns-users] Error using pdnsutil with MySQL backend

tach yon tachyon at live.co.uk
Tue Apr 13 13:25:29 UTC 2021

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,

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

More information about the Pdns-users mailing list