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-boun...@mailman.powerdns.com> on behalf of Markus Ehrlicher via Pdns-users <pdns-users@mailman.powerdns.com> Sent: 12 April 2021 10:58 To: 'pdns-users@mailman.powerdns.com' <pdns-users@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-boun...@mailman.powerdns.com> Im Auftrag von tach yon via Pdns-users Gesendet: Montag, 12. April 2021 11:53 An: pdns-users@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
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
