testing bind-dlz
Agnello George
agnello.dsouza at gmail.com
Wed Dec 12 07:04:53 UTC 2007
HI
I have install the bind-9.5.0 source rpm package from
http://people.redhat.com/atkac/bind/
i have add the following lines in my named.conf
dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=binddlzdb user=binddlzuser pass=binddlzpassword}
{SELECT zone FROM records WHERE zone = '%zone%'}
{SELECT ttl, type, mx_priority, IF(type = 'TXT', CONCAT('\"',data,'\"'),
data) AS data
FROM records
WHERE zone = '%zone%' AND host = '%record%' AND type <> 'SOA' AND type
<> 'NS'}
{SELECT ttl, type, data, primary_ns, resp_contact, serial, refresh,
retry, expire, minimum
FROM records
WHERE zone = '%zone%' AND (type = 'SOA' OR type='NS')}
{SELECT ttl, type, host, mx_priority, IF(type = 'TXT',
CONCAT('\"',data,'\"'), data) AS data, resp_contact, serial, refresh, retry,
expire, minimum
FROM records
WHERE zone = '%zone%' AND type <> 'SOA' AND type <> 'NS'}
{SELECT zone FROM xfr where zone='%zone%' AND client = '%client%'}";
};
i have have added the the SOA , A and MX records in the mysql database ...
but when i restart named all seems to stars ok ..
when i check the /log /messages ( i dont see any connection to the msql
database )
Dec 12 14:18:16 TestDNS named-sdb[19568]: command channel listening on
127.0.0.1#953
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone 0.in-addr.arpa/IN: NS '
0.in-addr.arpa' has no address records (A or AAAA)
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone 0.in-addr.arpa/IN: loaded
serial 0
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone 1.0.0.127.in-addr.arpa/IN: NS
'1.0.0.127.in-addr.arpa' has no address records (A or AAAA)
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone 1.0.0.127.in-addr.arpa/IN:
loaded serial 0
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone
1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN:
NS '
1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa'
has no address records (A or AAAA)
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone
1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN:
loaded serial 0
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone localhost.localdomain/IN:
loaded serial 0
Dec 12 14:18:16 TestDNS named-sdb[19568]: zone localhost/IN: loaded serial 0
Dec 12 14:18:16 TestDNS named-sdb[19568]: running
how do i manually check if i can connect to the data base
thanks !! :- )
--
Agnello . G .Dsouza
[Every action you take is a seed you sow, and every seed you sow is a
harvest you'll reap.]
More information about the bind-users
mailing list