Hi,
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 bind-dlz.sourceforge.net.
If I do: "dig @192.168.0.82 test24.com any", I get:
; <<>> DiG 9.6.1-P2-RedHat-9.6.1-7.P2.fc11 <<>> @192.168.0.82 test24.com any; 
(1 server found);; global options: +cmd;; Got answer:;; ->>HEADER<<- opcode: 
QUERY, status: NOERROR, id: 23242;; flags: qr aa rd; QUERY: 1, ANSWER: 4, 
AUTHORITY: 0, ADDITIONAL: 0;; WARNING: recursion requested but not available
;; QUESTION SECTION:;test24.com.                    IN      ANY
;; ANSWER SECTION:test24.com.             10      IN      MX      10 
mail.test24.com.test24.com.             10      IN      A       
192.168.0.82test24.com.             10      IN      SOA     ns.dos.ro. 
hostmaster.dos.ro. 1261614770 28000 2800 64800 10test24.com.             10     
 IN      NS      ns.test24.com.
;; Query time: 3 msec;; SERVER: 192.168.0.82#53(192.168.0.82);; WHEN: Thu Dec 
24 13:45:10 2009;; MSG SIZE  rcvd: 138
But if I do the same for a real domain on a bind box without dlz, I get:
[r...@mmhome ~]# dig eurofeeds.com any
; <<>> DiG 9.6.1-P2-RedHat-9.6.1-7.P2.fc11 <<>> eurofeeds.com any;; global 
options: +cmd;; Got answer:;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 
41475;; flags: qr rd ra; QUERY: 1, ANSWER: 5, AUTHORITY: 2, ADDITIONAL: 3
;; QUESTION SECTION:;eurofeeds.com.                 IN      ANY
;; ANSWER SECTION:eurofeeds.com.          1494    IN      NS      
ns.dos.ro.eurofeeds.com.          1494    IN      NS      
ns1.dos.ro.eurofeeds.com.          1494    IN      SOA     ns.dos.ro. 
hostmaster.dos.ro. 2006093005 21600 7200 1209600 7200eurofeeds.com.          
1494    IN      A       86.55.19.190eurofeeds.com.          1494    IN      MX  
    10 mail.eurofeeds.com.
;; AUTHORITY SECTION:eurofeeds.com.          1494    IN      NS      
ns.dos.ro.eurofeeds.com.          1494    IN      NS      ns1.dos.ro.
;; ADDITIONAL SECTION:ns.dos.ro.              5998    IN      A       
212.104.212.82ns1.dos.ro.             1195    IN      A       
86.55.19.190mail.eurofeeds.com.     1494    IN      A       86.55.19.190
;; Query time: 42 msec;; SERVER: 193.231.100.130#53(193.231.100.130);; WHEN: 
Thu Dec 24 13:45:58 2009;; MSG SIZE  rcvd: 232
Why are the additional and authority sections missing when using dlz?
My conf files are:
// named.conf//// Provided by Red Hat bind package to configure the ISC BIND 
named(8) DNS// server as a caching only nameserver (as a localhost DNS resolver 
only).//// See /usr/share/doc/bind*/sample/ for example named configuration 
files.//
options {        #listen-on port 53 { 127.0.0.1; };        listen-on port 53 { 
192.168.0.82; };        #listen-on-v6 port 53 { ::1; };        directory       
"/var/named";        dump-file       "/var/named/data/cache_dump.db";        
statistics-file "/var/named/data/named_stats.txt";        memstatistics-file 
"/var/named/data/named_mem_stats.txt";        allow-query     { localhost; 
192.168.0.82; };        recursion no;        auth-nxdomain yes;        
dnssec-enable yes;        dnssec-validation yes;        dnssec-lookaside . 
trust-anchor dlv.isc.org.;};
logging {        #channel all_log {        #    file "/var/log/named.log";      
  #    severity debug;        #    print-time yes;        #    print-category 
yes;        #    print-severity yes;        #};
        channel default_debug {                file "data/named.run";           
     severity dynamic;        };};
zone "." IN {        type hint;        file "named.ca";};
include "/etc/named.rfc1912.zones";
include "/etc/pki/dnssec-keys//named.dnssec.keys";include 
"/etc/pki/dnssec-keys//dlv/dlv.isc.org.conf";
include "/etc/named.dlz.conf";

and
[r...@vmfc12 etc]# cat named.dlz.conf//// named.conf//// Provided by Red Hat 
bind package to configure the ISC BIND named(8) DNS// server as a caching only 
nameserver (as a localhost DNS resolver only).//// See 
/usr/share/doc/bind*/sample/ for example named configuration files.//
dlz "Mysql zone" {   database "mysql    {host=localhost dbname=****** 
user=******* pass=********}    {select zone from dns_records where zone = 
'%zone%'}    {select ttl, type, mx_priority, case when lower(type)='txt' then 
concat('\"', data, '\"')        else data end from dns_records where zone = 
'%zone%' and host = '%record%'        and not (type = 'SOA' or type = 'NS')}    
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, 
expire, minimum        from dns_records where zone = '%zone%' and (type = 'SOA' 
or type='NS')}    {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')}    {select zone from xfr_table 
where zone = '%zone%' and client = '%client%'}    {update data_count set count 
= count + 1 where zone ='%zone%'}";};
Many thanks,Michael.                                      
Use Hotmail to send and receive mail from your different email accounts. Find 
out how.                                    
_________________________________________________________________
Add your Gmail and Yahoo! Mail email accounts into Hotmail - it's easy
http://clk.atdmt.com/UKM/go/186394592/direct/01/
_______________________________________________
bind-users mailing list
bind-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/bind-users

Reply via email to