[Pdns-users] Altering the SQL query for gmysql backend

[Steven Looman]

Maybe it would be an idea to replace the %s with %type for type and %name for name. This way you don't need to worry about the order and makes things a bit clearer. Imo a good thing (TM).

Untill now I was using the generic PostgreSQL backend. But as I suggested, I want to start using the generic MySQL backend. Yesterday I was getting tired (was staying a bit longer at work) and didn't realize i actually should be checking out the generic MySQL backend... I will do so now and post my findings.

Greets,

steven Looman

On Thu, Oct 07, 2004 at 09:56:16PM +0200, bert hubert wrote:
> On Thu, Oct 07, 2004 at 06:39:59PM +0200, Steven Looman wrote:
> 
> > However, it does seem that powerdns cannot handle more than two (in this
> > case) %s values, it crashes (signal 11).
> 
> Indeed, I never realised people might want to add more %s's.
> 
> > If I do something like this (just to try things, of course added \'s to the end of each (but the last) line):
> >         select content, ttl, prio, type, domain_id, name
> >         from records
> >         where type='%s' and name='%s' and type='%s' and name='%s'
> > it also crashes (signal 11).
> 
> You'll need to edit pdns/backends/gsql/gsqlbackend.cc a lot to get this to
> work. Do you have any ideas on how PowerDNS should handle this, it needs a
> specific order of %s to make this work.
> 
> -- 
> http://www.PowerDNS.com      Open source, database driven DNS Software 
> http://lartc.org           Linux Advanced Routing & Traffic Control HOWTO
>