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

[bert hubert]

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