[Pdns-users] New to PowerDNS

[Aki Tuomi]

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 <cmouse at youzen.ext.b2.fi> 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
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users