Re: [Pdns-users] Error using pdnsutil with MySQL backend
Perfect, thanks muchly! Kind regards, tach From: Otto Moerbeek Sent: 13 April 2021 14:28 To: tach yon Cc: 'pdns-users@mailman.powerdns.com' ; Peter van Dijk Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend See https://docs.powerdns.com/authoritative/upgrading.html -Otto On Tue, Apr 13, 2021 at 01:25:29PM +, tach yon via Pdns-users wrote: > 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 on behalf of Peter > van Dijk via Pdns-users > Sent: 12 April 2021 21:41 > To: 'pdns-users@mailman.powerdns.com' > Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend > > On Mon, 2021-04-12 at 12:38 +, 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@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users > ___ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Error using pdnsutil with MySQL backend
See https://docs.powerdns.com/authoritative/upgrading.html -Otto On Tue, Apr 13, 2021 at 01:25:29PM +, tach yon via Pdns-users wrote: > 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 on behalf of Peter > van Dijk via Pdns-users > Sent: 12 April 2021 21:41 > To: 'pdns-users@mailman.powerdns.com' > Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend > > On Mon, 2021-04-12 at 12:38 +, 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@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users > ___ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Error using pdnsutil with MySQL backend
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 on behalf of Peter van Dijk via Pdns-users Sent: 12 April 2021 21:41 To: 'pdns-users@mailman.powerdns.com' Subject: Re: [Pdns-users] Error using pdnsutil with MySQL backend On Mon, 2021-04-12 at 12:38 +, 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@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Error using pdnsutil with MySQL backend
On Mon, 2021-04-12 at 12:38 +, 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@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Error using pdnsutil with MySQL backend
Hi, Oh yes, of course. Thanks for looking! Kind regards, tach allow-axfr-ips= also-notify= 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= 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 on behalf of Markus Ehrlicher via Pdns-users Sent: 12 April 2021 10:58 To: '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 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 ", 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 " 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
Re: [Pdns-users] Error using pdnsutil with MySQL backend
Hi, your configuration would be nice ;) best regards, Markus Von: Pdns-users 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 ", 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 " 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