[Pdns-users] Altering the SQL query for gmysql backend
steven at krx.nl
Fri Oct 8 07:49:28 UTC 2004
Same thing hapen when having more than two (in basic-query) '%s' when using the gmysql-backend.
On Fri, Oct 08, 2004 at 08:52:15AM +0200, Steven Looman wrote:
> 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.
> 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
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
More information about the Pdns-users