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