Non-authoritative answer

Danilo <[email protected]> Tue, 26 Feb 2013 14:56:49 +0100
Newsgroups gmane.network.dns.bind9.dlz
Message-ID <[email protected]>
Hello,
I have a trouble with bind9 dlz. I had configure a bind9 (version 9.8.0) and dlz
with mysql database.

When I try to resolve a zone I receive a Non-authoritative answer. But the zone
is on the DB, and all other things looks good.

$ nslookup -query=soa comune.ostuni.br.it dns1.convenzionefonia4.it
Server:		dns1.convenzionefonia4.it
Address:	31.199.7.28#53

Non-authoritative answer:
comune.ostuni.br.it
	origin = dns1.convenzionefonia4.it
	mail addr = hostmaster.comune.ostuni.br.it
	serial = 1361204190
	refresh = 10800
	retry = 7200
	expire = 604800
	minimum = 3600

Authoritative answers can be found from:
comune.ostuni.br.it	nameserver = dns2.convenzionefonia4.it.
comune.ostuni.br.it	nameserver = dns1.convenzionefonia4.it.

I need it will be authoritative. This is my config:
dlz "Consip Zones"{
        database "mysql
        {host=dns-vip dbname=dns user=dns pass=dns}
        {SELECT zone FROM records_db WHERE zone = '$zone$'}
        {SELECT ttl, type, mx_priority, IF(type = 'TXT', CONCAT('\"',data,'\"'),
data) AS data
            FROM records_db
            WHERE zone = '$zone$' AND host = '$record$' AND type <> 'SOA' AND
type <> 'NS' AND public = 1}
        {SELECT ttl, type, data, primary_ns, resp_contact, serial, refresh,
retry, expire, minimum
            FROM records_db
            WHERE zone = '$zone$' AND (type = 'SOA' OR type='NS') AND public = 1}
        {SELECT ttl, type, host, mx_priority, IF(type = 'TXT',
CONCAT('\"',data,'\"'), data) AS data, resp_contact, serial, refresh, retry,
expire, minimum
            FROM records_db
            WHERE zone = '$zone$' AND type <> 'SOA' AND type <> 'NS' AND public = 1}
        {}";
};

On DB I have:

mysql> SELECT ttl, type, data, primary_ns, resp_contact, serial, refresh, retry,
expire, minimum FROM records_db WHERE zone = 'comune.ostuni.br.it' AND (type =
'SOA' OR type='NS') AND public = 1\G;
*************************** 1. row ***************************
         ttl: 3600
        type: NS
        data: dns1.convenzionefonia4.it.
  primary_ns: NULL
resp_contact: NULL
      serial: NULL
     refresh: NULL
       retry: NULL
      expire: NULL
     minimum: NULL
*************************** 2. row ***************************
         ttl: 3600
        type: NS
        data: dns2.convenzionefonia4.it.
  primary_ns: NULL
resp_contact: NULL
      serial: NULL
     refresh: NULL
       retry: NULL
      expire: NULL
     minimum: NULL
*************************** 3. row ***************************
         ttl: 3600
        type: SOA
        data: NULL
  primary_ns: dns1.convenzionefonia4.it.
resp_contact: hostmaster.comune.ostuni.br.it.
      serial: 1361204190
     refresh: 10800
       retry: 7200
      expire: 604800
     minimum: 3600
3 rows in set (0.00 sec)

Any idea?

Thanks

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb