[Pdns-users] Altering the SQL query for gmysql backend
steven at krx.nl
Fri Oct 8 06:52:15 UTC 2004
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.
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
More information about the Pdns-users