Greetings,
How does one edit the gmysql queries that pdns uses? I'm looking to edit
the basic query to add some functionality and then se it as the primary
query to use for requests to the DB,
Regards,
-S
___
Pdns-users mailing list
Pdns-users@mailman.
On 10/09/2019 14:07, Shawn Augenstein wrote:
How does one edit the gmysql queries that pdns uses?
https://doc.powerdns.com/authoritative/backends/generic-sql.html#specifying-queries
To see the existing queries powerdns uses, run "pdns_server --config"
If you don't see them, add "--launch gmys
Crushing it Brian!
Looks like I'm 99% of the way there. It *seems* I can update the query
with pdns_server
--gmysql-basic-query=
I just have to dial in the query (I believe...) unless the non-option is
referring to the LIMIT itself
# pdns_server --gmysql-basic-query=SELECT
content,ttl,prio,type,
Hi Shawn,
On 9/10/19 4:46 PM, Shawn Augenstein wrote:
> I just have to dial in the query (I believe...) unless the non-option is
> referring to the LIMIT itself
No, your shell requires you to quote is properly (as it passes in argv)
> # pdns_server --gmysql-basic-query=SELECT
> content,ttl,prio,
Pieter,
I'm just going to jump in here because I'm curious,
Couldn't he just put this in the pdns.conf file and restart pdns?
gmysql-basic-query=SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
disabled=0 and type=? and name=? LIMIT=5
Eric
On 2019-09-10 11:01 a.m.,
I'd like to take a moment and thank Frank, Brian, Pieter and others who
helped me work through my configuration. This User Group is solid Gold.
and Eric, here's some validation:
Added in pdns.conf
##
#Any ID Query
gmysql-any-id-query=SELECT
content,ttl,prio,type,domai