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
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.,
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,
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,
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
