Re: zone transfer troubles

Todd Lyons wrote:
> Order of the SELECT statements and the format of the data it returns
> is important, so a few small changes to your dlz config might be all
> that are needed.
>
>   
> Post your entire dlz configuration, but omit the password setting.
This is the dlz config for my test setup. If there's anything else I can 
provide let me know, I'm really stuck on this one.

dlz "Mysql zone" {
   database "mysql
   {host=127.0.0.1 dbname=dns port=3306 user=bind pass=password}
   {select zone from dns_records where zone = '%zone%'}
   {select ttl, type, mx_priority, case when lower(type)='txt' then
        concat('\"', data, '\"') when lower(type) = 'soa' then
        concat_ws(' ', data, resp_person, serial, refresh, retry, expire,
        minimum) else data end from dns_records where zone = '%zone%' and
        host = '%record%'}
   {}
   {select ttl, type, host, mx_priority, data, resp_person, serial, 
refresh,
        retry, expire, minimum from dns_records where zone = '%zone%'}
   {select zone from xfr_table where zone = '%zone%' and client = 
'%client%'}";
};


------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword