Re: [Bind-dlz-testers] (no subject)
Brought to you by:
crodster
From: Rob B. <rob...@ve...> - 2003-03-25 23:32:09
|
The primary_ns, resp_person, serial, refresh, retry, expire and minimum = fields should only be filled in for SOA type dns records. For all other = DNS record types these fields should be null. By not having them as = null in the database your queries (while running correctly) are = returning "extra input text" for non SOA dns records. Also mx_priority = should be NULL for all DNS records except MX records (you seem to have = this correct). Once you correct the data in your database everything = should work fine. Later Rob ----- Original Message -----=20 From: Matt Langford=20 To: bin...@li...=20 Sent: Tuesday, March 25, 2003 2:44 PM Subject: [Bind-dlz-testers] (no subject) I'm having some trouble with my Bind-9.2.1/DZL configuration: none of = my NS/MX queries return any results: My Database Looks Like This: mysql> select * from dns_records where zone=3D'scruffyminds.com'; = +-------+-------+-------+------+------------------+-------------+--------= ------------------+------------------------+-----------------------------= -+------------+---------+-------+--------+---------+ | dbnum | ttl | type | host | zone | mx_priority | data = | primary_ns | resp_person = | serial | refresh | retry | expire | minimum | = +-------+-------+-------+------+------------------+-------------+--------= ------------------+------------------------+-----------------------------= -+------------+---------+-------+--------+---------+ | 62 | 86400 | NS | @ | scruffyminds.com | NULL | = ns2.danielhethmoran.com. | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048617684 | 86400 | 7200 | 604800 | = 86400 | | 59 | 86400 | MX | @ | scruffyminds.com | 10 | = www.lcarstechnology.com. | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048616310 | 86400 | 7200 | 604800 | = 86400 | | 61 | 86400 | NS | @ | scruffyminds.com | NULL | = ns.danielhethmoran.com. | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048617678 | 86400 | 7200 | 604800 | = 86400 | | 64 | 86400 | CNAME | mail | scruffyminds.com | NULL | www = | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048617714 | 86400 | 7200 | 604800 | = 86400 | | 63 | 86400 | CNAME | ftp | scruffyminds.com | NULL | www = | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048617708 | 86400 | 7200 | 604800 | = 86400 | | 58 | 86400 | A | www | scruffyminds.com | NULL | = 208.180.155.118 | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048616293 | 86400 | 7200 | 604800 | = 86400 | | 66 | 86400 | A | www2 | scruffyminds.com | NULL | = 208.180.155.118 | ns.danielhethmoran.com | = support.lcarstechnology.com. | 1048618803 | 86400 | 7200 | 604800 | = 86400 | = +-------+-------+-------+------+------------------+-------------+--------= ------------------+------------------------+-----------------------------= -+------------+---------+-------+--------+---------+ And my named.conf has the following entry: dlz "Mysql zone" { database "mysql {host=3Dlocalhost dbname=3Ddbname user=3Dusername = pass=3Dpassword ssl=3D0} {select zone from dns_records where zone =3D '%zone%'} {select ttl, type, mx_priority, case when lower(type)=3D'txt' = then concat('\"', data, '\"') else data end from dns_records where zone = =3D '%zone%' and host =3D '%record%' and not (type =3D 'SOA' or type =3D = 'NS')} {select ttl, type, mx_priority, data, resp_person, serial, = refresh, retry, expire, minimum from dns_records where zone =3D '%zone%' = and (type =3D 'SOA' or type=3D'NS')} {select ttl, type, host, mx_priority, data, resp_person, = serial, refresh, retry, expire, minimum from dns_records where zone =3D = '%zone%' and not (type =3D 'SOA' or type =3D 'NS')} {} {}"; }; If I do an nslookup on www.scruffyminds.com (type A) or = ftp.scruffyminds.com (type CNAME) it returns the correct information. = However, dig @localhost scruffyminds.com ANY returns no information and = I'm not able to get the MX record to return any information at all = unless I also specify a host (and then it will only return MX = information when I specify that hostname). In my syslog I'm recieving the following error whenever i do a query: Mar 25 14:03:38 mandy named[15217]: dns_rdata_fromtext: = buffer-0xbfffe540:1: near 'support.lcarstechnology.com.': extra input = text Mar 25 14:03:38 mandy named[15217]: dns_sdlz_putrr returned error. = Error code was: extra input text Can anybody point me in the right direction on how to fix this? Thanks, Matt |