Re: Transfer to slave fails

Hi Rob,

Thanks for that. Zone transfers are now working.

Regards,

Stuart.

-----Original Message-----
From: Rob Butler [mailto:[email protected]] 
Sent: 27 May 2008 13:39
To: [email protected]
Subject: Re: [Bind-dlz-testers] Transfer to slave fails

The second to last query is the allnodes query.  You shouldn't restrict ns
and soa types from being returned by that query.

Change the query to:

select ttl, type, host, mx_priority, data, contact, serial, refresh,
retry, expire, minimum from dns_records where zone = '%zone%'

Rob

----- Original Message ----
From: Stuart O'Reilly <[email protected]>
To: [email protected]
Sent: Sunday, May 25, 2008 7:11:31 PM
Subject: [Bind-dlz-testers] Transfer to slave fails

Hi all,

I have BIND-DLZ running quite nicely on my primary nameserver and am now
trying to get transfer working to a non DLZ server. I know it's not
recommended, but I don't own the server so until they implement BIND-DLZ,
I'm left with flat files.

Anyway, the transfers are failing. I have turned on debugging on the slave
server and I am seeing this:

25-May-2008 22:51:24.450 zone tokenbay.com/IN: Transfer started.
25-May-2008 22:51:24.451 zone tokenbay.com/IN: no database exists yet,
requesting AXFR of initial version from 217.155.123.103#53
25-May-2008 22:51:24.518 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: connected using 82.69.229.91#49791
25-May-2008 22:51:24.518 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: sent request length prefix
25-May-2008 22:51:24.518 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: sent request data
25-May-2008 22:51:24.645 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: received 226 bytes
25-May-2008 22:51:24.645 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: got nonincremental response
25-May-2008 22:51:24.645 zone tokenbay.com/IN: has no NS records
25-May-2008 22:51:24.646 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: failed while receiving responses: bad zone
25-May-2008 22:51:24.646 zone tokenbay.com/IN: zone transfer finished: bad
zone
25-May-2008 22:51:24.646 transfer of 'tokenbay.com/IN' from
217.155.123.103#53: end of transfer

What worries me is the line about no NS records.

I have attached a .txt file with all my database information and the output
to the SQL queries.

>From looking at the debug messages, when the queries are run, they are not
returning the NS records, however when I run them by hand, they do return NS
records.

Any help in solving the problem would be greatly appreciated. I've just
spent the last couple of hours searching the archives without much luck.

Regards,

Stuart.

No virus found in this outgoing message.
Checked by AVG. 
Version: 8.0.100 / Virus Database: 269.24.1/1464 - Release Date: 24/05/2008
08:56



      

!DSPAM:483c0285195844809518897!

No virus found in this incoming message.
Checked by AVG. 
Version: 8.0.100 / Virus Database: 269.24.1/1468 - Release Date: 26/05/2008
15:23

No virus found in this outgoing message.
Checked by AVG. 
Version: 8.0.100 / Virus Database: 269.24.1/1468 - Release Date: 26/05/2008
15:23


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/