testing bind-dlz

[Agnello George]

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.]