Yeah I'm switching now to 3.4.3 so I can use the docs, thanks for everything :)
This patch helped me to find out what queries were failing: https://github.com/PowerDNS/pdns/pull/2359.patch I'm only switching because 'stable-env' but I'll post more if I need more info On Mon, Mar 16, 2015 at 3:30 PM, Aki Tuomi <[email protected]> wrote: > Hi! > > Your version has prepared statements patch in it, which means that the SQL > syntax has been changed. You no longer use %s and %d, you use ? and > statement > variable placeholder. > > You can see all the SQLs with pdns_server --launch=gmysql --config | grep > gmysql > > Aki > > On Mon, Mar 16, 2015 at 03:21:02PM -0300, Filipe Cifali wrote: > > Sorry, I forgot to mention that: > > > > pdns_control version > > git > > > > MySQL 5.5.42 > > > > I'm running on Gentoo latest, > > > > ]# head /usr/local/install/pdns/config.log > > This file contains any messages produced by compilers while > > running configure, to aid debugging if configure makes a mistake. > > > > It was created by pdns configure git, which was > > generated by GNU Autoconf 2.69. Invocation command line was > > > > $ ./configure --with-modules=bind gmysql pipe --without-lua > > > > The command output: > > > > pdns_server --launch=gmysql --config | grep gmysql-basic-query > > Mar 16 15:20:33 Reading random entropy from '/dev/urandom' > > # gmysql-basic-query Basic query > > # gmysql-basic-query=SELECT > > content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE > > disabled=0 and type=? and name=? > > > > > > > > > > On Mon, Mar 16, 2015 at 3:13 PM, Aki Tuomi <[email protected]> > wrote: > > > > > On Mon, Mar 16, 2015 at 01:05:26PM -0300, Filipe Cifali wrote: > > > > Hello all, > > > > > > > > I just subscribed to this mailing, I'm Filipe and I have some > experience > > > > with Bind/Named setups with MySQL. Since they both are good but not > > > optimal > > > > I was searching for a replacement and I came across PowerDNS and NSD, > > > right > > > > now I'm trying to do a custom layout for the MySQL queries since I > use > > > them > > > > on Bind with the driver, which is quite easy, writing the queries.I > came > > > > across the custom queries in the docs: > > > > https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/ > > > > > > > > And wrote a simple query: > > > > > > > > gmysql-basic-query=SELECT data,ttl,mx_priority,type,zone,host FROM > > > DNSTable > > > > WHERE type='%s' AND zone='%s' AND active=1 > > > > > > > > > > Are you using which version of PowerDNS? Can you check > > > > > > pdns_server --launch=gmysql --config | grep gmysql-basic-query > > > > > > Aki Tuomi > > > > > > > > > > > -- > > [ ]'s > > > > Filipe Cifali Stangler > > > _______________________________________________ > > Pdns-users mailing list > > [email protected] > > http://mailman.powerdns.com/mailman/listinfo/pdns-users > > -- [ ]'s Filipe Cifali Stangler
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
