[Pdns-users] Error using pdnsutil with MySQL backend

Peter van Dijk peter.van.dijk at powerdns.com
Mon Apr 12 20:41:20 UTC 2021

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/

More information about the Pdns-users mailing list