Re: zone transfer troubles

On Sun, Jan 18, 2009 at 2:18 PM, nubjub <[email protected]> wrote:
>
> 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%'}

Since you seem to have followed the HOWTO exactly, the above query
looks to be your problem.  It's located at
http://bind-dlz.sourceforge.net/mysql_driver.html.  Here is what the
HOWTO has for this query:

{select ttl, type, host, mx_priority, data, resp_person, serial,
refresh, retry, expire, minimum from dns_records where zone = '%zone%'
and not (type = 'SOA' or type = 'NS')}

Note the exclusion of SOA and NS type records, which yours is not skipping.

>   {select zone from xfr_table where zone = '%zone%' and client = '%client%'}";
> };

I don't do XFERs with dlz, but just looking at config requirements,
I'd guess that's what you are going to find as the problem.
-- 
Regards...      Todd
All truth passes through three stages. First, it is ridiculed. Second,
it is violently opposed. Third, it is accepted as being self-evident.

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