[Pdns-users] Error using pdnsutil with MySQL backend

[tach yon]

Hi,

Oh yes, of course. Thanks for looking!

Kind regards,
tach


allow-axfr-ips=<ips>
also-notify=<ips>
config-dir=/etc/pdns
daemon=yes
distributor-threads=3
disable-axfr=no
guardian=yes
include-dir=/etc/pdns/pdns.d
launch=
log-dns-details=no
log-dns-queries=no
master=yes
only-notify=<ips>
query-logging=no
receiver-threads=3
setgid=pdns
setuid=pdns
slave=no


# MySQL Configuration
#
# Launch gmysql backend
launch+=gmysql
gmysql-host=127.0.0.1
gmysql-port=3311
gmysql-dbname=authdns
gmysql-user=
gmysql-password=
gmysql-dnssec=yes
gmysql-innodb-read-committed=no
# 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'



________________________________
From: Pdns-users <pdns-users-bounces at mailman.powerdns.com> on behalf of Markus Ehrlicher via Pdns-users <pdns-users at mailman.powerdns.com>
Sent: 12 April 2021 10:58
To: 'pdns-users at mailman.powerdns.com' <pdns-users at mailman.powerdns.com>
Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend


Hi,



your configuration would be nice ;)



best regards,

Markus



Von: Pdns-users <pdns-users-bounces at mailman.powerdns.com> Im Auftrag von tach yon via Pdns-users
Gesendet: Montag, 12. April 2021 11:53
An: pdns-users at mailman.powerdns.com
Betreff: [Pdns-users] Error using pdnsutil with MySQL backend



Hi,



I'm trying to import a zone into an authoritative PowerDNS server (version 4.1.14) which uses a MySQL backend.



When I try to use some of the commands, for example, "pdnsutil list-zone <zone>", it gives an error like this:



Error: GSQLBackend unable to retrieve information about a domain: Provided parameter count does not match statement: select id, name, master, last_check, notified_serial, type from domains where name='$s' and status='A'





Some of the other commands, like "pdnsutil check-zone <zone>" seem to work okay.



Am I doing something wrong?



Thanks in advance for your time and consideration.



Kind regards,
tach
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20210412/cea1f106/attachment.htm>