Re: [Pdns-users] Edit gMySQL Queries

2019-09-10 Thread Shawn Augenstein
#x27;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: > >

Re: [Pdns-users] Edit gMySQL Queries

2019-09-10 Thread Shawn Augenstein
x-gnu/pdns/libgmysqlbackend.so' Fatal: non-option on the command line, perhaps a '--setting=123' statement missed the '='? -S On Tue, Sep 10, 2019 at 7:12 AM Brian Candler wrote: > On 10/09/2019 14:07, Shawn Augenstein wrote: > > How does one edit the gmysql quer

[Pdns-users] Edit gMySQL Queries

2019-09-10 Thread Shawn Augenstein
Greetings, How does one edit the gmysql queries that pdns uses? I'm looking to edit the basic query to add some functionality and then se it as the primary query to use for requests to the DB, Regards, -S ___ Pdns-users mailing list Pdns-users@mailman.

Re: [Pdns-users] Edit Queries gmysql

2019-09-09 Thread Shawn Augenstein
ied I only want to return "X" (lets say 3) of the possible 100 returned. Conversely, I can write the query and call it out ...it's just the where to do it (for both cases) that's alluding me. -S On Mon, Sep 9, 2019 at 12:33 PM Brian Candler wrote: > On 09/09/2019 1

Re: [Pdns-users] Edit Queries gmysql

2019-09-09 Thread Shawn Augenstein
disabled=0 and type=? and name=? LIMIT 5 OFFSET 5 On Mon, Sep 9, 2019 at 8:38 AM Brian Candler wrote: > 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

[Pdns-users] Edit Queries gmysql

2019-09-09 Thread Shawn Augenstein
Greetings, 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 specifying them as gmysql-launchname-queryna

[Pdns-users] Limit Returned Results from a SRV Query

2019-09-05 Thread Shawn Augenstein
Greetings, I have stood up a MariaDB backend for a Authoritative Server deployment and I am working under a specific requirement: Provisioning the backend with 200 A Records associated with a SRV however, for each query to the Authoritative server only 5 of the 200 can be returned at any one time