[Pdns-users] Edit gMySQL Queries

[Pieter Lexis]

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
-- 
Pieter Lexis
PowerDNS.COM BV -- https://www.powerdns.com