Re: zone transfer troubles

Todd Lyons <tlyons <at> ivenue.com> writes:

>
> Post your entire dlz configuration, but omit the password setting.
> 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.
> 

So this is the dlz config for my test setup, if there's anything else I can
provide please let me know. I'm completely stumped on the transfer troubles. 

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