<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi,<div><br></div><div>I am no expert on bind, but I install bind-9.6.1-13.P2.fc12.i686 and bind-sdb-9.6.1-13.P2.fc12.i686 on Fedora 12 x86 with a mysql configuration example from <a href="http://bind-dlz.sourceforge.net/mailing_list.html">bind-dlz.sourceforge.net</a>.</div><div><br></div><div>If I do: "dig @192.168.0.82 test24.com any", I get:</div><div><div><br></div><div>; <<>> DiG 9.6.1-P2-RedHat-9.6.1-7.P2.fc11 <<>> @192.168.0.82 test24.com any</div><div>; (1 server found)</div><div>;; global options: +cmd</div><div>;; Got answer:</div><div>;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 23242</div><div>;; flags: qr aa rd; QUERY: 1, ANSWER: 4, AUTHORITY: 0, ADDITIONAL: 0</div><div>;; WARNING: recursion requested but not available</div><div><br></div><div>;; QUESTION SECTION:</div><div>;test24.com. IN ANY</div><div><br></div><div>;; ANSWER SECTION:</div><div>test24.com. 10 IN MX 10 mail.test24.com.</div><div>test24.com. 10 IN A 192.168.0.82</div><div>test24.com. 10 IN SOA ns.dos.ro. hostmaster.dos.ro. 1261614770 28000 2800 64800 10</div><div>test24.com. 10 IN NS ns.test24.com.</div><div><br></div><div>;; Query time: 3 msec</div><div>;; SERVER: 192.168.0.82#53(192.168.0.82)</div><div>;; WHEN: Thu Dec 24 13:45:10 2009</div><div>;; MSG SIZE rcvd: 138</div><div><br></div><div>But if I do the same for a real domain on a bind box without dlz, I get:</div><div><br></div><div><div>[root@mmhome ~]# dig eurofeeds.com any</div><div><br></div><div>; <<>> DiG 9.6.1-P2-RedHat-9.6.1-7.P2.fc11 <<>> eurofeeds.com any</div><div>;; global options: +cmd</div><div>;; Got answer:</div><div>;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 41475</div><div>;; flags: qr rd ra; QUERY: 1, ANSWER: 5, AUTHORITY: 2, ADDITIONAL: 3</div><div><br></div><div>;; QUESTION SECTION:</div><div>;eurofeeds.com. IN ANY</div><div><br></div><div>;; ANSWER SECTION:</div><div>eurofeeds.com. 1494 IN NS ns.dos.ro.</div><div>eurofeeds.com. 1494 IN NS ns1.dos.ro.</div><div>eurofeeds.com. 1494 IN SOA ns.dos.ro. hostmaster.dos.ro. 2006093005 21600 7200 1209600 7200</div><div>eurofeeds.com. 1494 IN A 86.55.19.190</div><div>eurofeeds.com. 1494 IN MX 10 mail.eurofeeds.com.</div><div><br></div><div>;; AUTHORITY SECTION:</div><div>eurofeeds.com. 1494 IN NS ns.dos.ro.</div><div>eurofeeds.com. 1494 IN NS ns1.dos.ro.</div><div><br></div><div>;; ADDITIONAL SECTION:</div><div>ns.dos.ro. 5998 IN A 212.104.212.82</div><div>ns1.dos.ro. 1195 IN A 86.55.19.190</div><div>mail.eurofeeds.com. 1494 IN A 86.55.19.190</div><div><br></div><div>;; Query time: 42 msec</div><div>;; SERVER: 193.231.100.130#53(193.231.100.130)</div><div>;; WHEN: Thu Dec 24 13:45:58 2009</div><div>;; MSG SIZE rcvd: 232</div><div><br></div><div>Why are the additional and authority sections missing when using dlz?</div><div><br></div><div>My conf files are:</div><div><br></div><div><div>// named.conf</div><div>//</div><div>// Provided by Red Hat bind package to configure the ISC BIND named(8) DNS</div><div>// server as a caching only nameserver (as a localhost DNS resolver only).</div><div>//</div><div>// See /usr/share/doc/bind*/sample/ for example named configuration files.</div><div>//</div><div><br></div><div>options {</div><div> #listen-on port 53 { 127.0.0.1; };</div><div> listen-on port 53 { 192.168.0.82; };</div><div> #listen-on-v6 port 53 { ::1; };</div><div> directory "/var/named";</div><div> dump-file "/var/named/data/cache_dump.db";</div><div> statistics-file "/var/named/data/named_stats.txt";</div><div> memstatistics-file "/var/named/data/named_mem_stats.txt";</div><div> allow-query { localhost; 192.168.0.82; };</div><div> recursion no;</div><div> auth-nxdomain yes;</div><div> dnssec-enable yes;</div><div> dnssec-validation yes;</div><div> dnssec-lookaside . trust-anchor dlv.isc.org.;</div><div>};</div><div><br></div><div>logging {</div><div> #channel all_log {</div><div> # file "/var/log/named.log";</div><div> # severity debug;</div><div> # print-time yes;</div><div> # print-category yes;</div><div> # print-severity yes;</div><div> #};</div><div><br></div><div> channel default_debug {</div><div> file "data/named.run";</div><div> severity dynamic;</div><div> };</div><div>};</div><div><br></div><div>zone "." IN {</div><div> type hint;</div><div> file "named.ca";</div><div>};</div><div><br></div><div>include "/etc/named.rfc1912.zones";</div><div><br></div><div>include "/etc/pki/dnssec-keys//named.dnssec.keys";</div><div>include "/etc/pki/dnssec-keys//dlv/dlv.isc.org.conf";</div><div><br></div><div>include "/etc/named.dlz.conf";</div><div><br></div><div><br></div><div>and</div><div><br></div><div>[root@VMFC12 etc]# cat named.dlz.conf</div><div><div>//</div><div>// named.conf</div><div>//</div><div>// Provided by Red Hat bind package to configure the ISC BIND named(8) DNS</div><div>// server as a caching only nameserver (as a localhost DNS resolver only).</div><div>//</div><div>// See /usr/share/doc/bind*/sample/ for example named configuration files.</div><div>//</div><div><br></div><div>dlz "Mysql zone" {</div><div> database "mysql</div><div> {host=localhost dbname=****** user=******* pass=********}</div><div> {select zone from dns_records where zone = '%zone%'}</div><div> {select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"')</div><div> else data end from dns_records where zone = '%zone%' and host = '%record%'</div><div> and not (type = 'SOA' or type = 'NS')}</div><div> {select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum</div><div> from dns_records where zone = '%zone%' and (type = 'SOA' or type='NS')}</div><div> {select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,</div><div> minimum from dns_records where zone = '%zone%' and not (type = 'SOA' or type = 'NS')}</div><div> {select zone from xfr_table where zone = '%zone%' and client = '%client%'}</div><div> {update data_count set count = count + 1 where zone ='%zone%'}";</div><div>};</div><div><br></div></div><div>Many thanks,</div><div>Michael.</div></div></div></div> <br><hr>Use Hotmail to send and receive mail from your different email accounts. <a href="http://clk.atdmt.com/UKM/go/186394592/direct/01/">Find out how.</a> <br /><hr />Have more than one Hotmail account? <a href=' http://clk.atdmt.com/UKM/go/186394591/direct/01/' target='_new'>Link them together to easily access both.</a></body>
</html>