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,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=? LIMIT 5 ############################# ...worked!!! On Tue, Sep 10, 2019 at 9:48 AM Eric Beck <ericb...@cadns.ca> wrote: > 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 > > > > _______________________________________________ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users >
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users