Re: [Pdns-users] Edit Queries gmysql

2019-09-09 Thread Shawn Augenstein
That does clear up a couple of points, I appreciate it! What I am trying to do is limit the response of records via the query so I need to edit the query itself. In essence I'm doing DNS Round-robin but limiting the responses. If I have a record with 100 IPs associated, when the db is queried I onl

Re: [Pdns-users] Edit Queries gmysql

2019-09-09 Thread Brian Candler
On 09/09/2019 16:30, Shawn Augenstein wrote: ## #gmysql-launchname-queryname Override the default queries with custom parameters gmysql-launchname-queryname=SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and

Re: [Pdns-users] Edit Queries gmysql

2019-09-09 Thread Shawn Augenstein
Understood however I seem to be a bit dense in understanding. What I attempted o do in pdfs.conf is: ## #gmysql-launchname-queryname Override the default queries with custom parameters gmysql-launchname-queryname=SELECT content,ttl,prio,type,domain_id,disabled,n

Re: [Pdns-users] Edit Queries gmysql

2019-09-09 Thread Brian Candler
On 09/09/2019 14:41, Shawn Augenstein wrote: I have a simple edit to the Basic Query that I'd like to Test and I am unsure of how to either 1. edit the basic query or where to add in the new one to be used. I've read the documentation and found, "you can override the default queries by specif