GDay
all,
As far as I can tell I have everything installed and configured
correctly, I think the problem is with the way I've entered the data
into the database, I couldn't find any info about this and just kinda
guessed.
I downloaded the performance testing data and had a look at that for
help, I changed swapped around the data and host column names, but it
made no difference, I don't know where I'm going wrong.
The problem I am having is that whenever I do a dig eg:
ns2.mydomain.com.au or
www.mydomain.com.au I get:
; <<>> DiG 9.2.2 <<>> ns2.mydomain.com.au
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 19358
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0
;; QUESTION SECTION:
;ns2.mydomain.com.au. IN A
;; Query time: 6 msec
;; SERVER: 127.0.0.1#53(127.0.0.1)
;; WHEN: Mon Aug 1 21:42:21 2005
;; MSG SIZE rcvd: 38
And named reports:
Aug 01 21:42:21.318 dns_rdata_fromtext: buffer-0xfee67d60:1: near '0':
extra input text
Aug 01 21:42:21.319 dns_sdlz_putrr returned error. Error code was:
extra input text
named.conf
options {
directory "/var/named";
};
key rndc_key {
algorithm hmac-md5;
secret "not giving that one away";
};
controls {
inet 127.0.0.1 allow { localhost; } keys { rndc_key; };
};
zone "." {
type hint;
file "root.hints";
};
zone "0.0.127.in-addr.arpa" {
type master;
notify no;
file "pz/127.0.0";
};
zone "1.168.192.in-addr.arpa" {
type master;
notify no;
file "pz/192.168.1";
};
zone "2.168.192.in-addr.arpa" {
type master;
notify no;
file "pz/192.168.2";
};
zone "34.6.58.in-addr.arpa" {
type master;
file "pz/58.6.33";
};
dlz "Mysql zone" {
database "mysql
{host=localhost dbname=named}
{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')}";
};
sample of data in database
zone data type
host ttl mx_priority refresh retry expire minimum
serial resp_person primary_ns
mydomain.com.au <at> SOA ns1 3600 28800
7200 604800 86400 1 admin ns2.mydomain.com.au
mydomain.com.au 1.2.3.4 NS ns1 3600 0
0 0 0 0
mydomain.com.au 127.0.0.1 NS ns2 3600 0
0 0 0 0
mydomain.com.au ns2 CNAME www 3600 0
0 0 0 0
mydomain.com.au ns2 CNAME ftp 3600 0
0 0 0 0
mydomain.com.au ns2 CNAME webstats 3600 0
0 0 0 0
mydomain.com.au ns2 CNAME webmail 3600 0
0 0 0 0
mydomain.com.au ns2 CNAME mail 3600 0
0 0 0 0
mydomain.com.au <at> MX mail 3600 20 0 0
0 0 0
Server details:
Fedora Core 2 with all updates
Bind 9.2.2
MySQL 3.23.58
Any help greatly appreciated,
thanks,
Jordan.
RSS Feed