[Pdns-users] Edit gMySQL Queries

[Eric Beck]

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., Pieter Lexis wrote:
> 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,type,domain_id,disabled,name,auth FROM records WHERE
>> disabled=0 and type=? and name=? LIMIT=5
> 
> Should be
> 
> # pdns_server --gmysql-basic-query="SELECT
> content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
> disabled=0 and type=? and name=? LIMIT=5"
> 
> Best regards,
> 
> Pieter
>