[Pdns-users] Edit gMySQL Queries

[Shawn Augenstein]

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 <ericbeck at 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 at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190910/894009ba/attachment-0001.htm>