Re: No glue on MX and NS requests.

To explain this further, I am running DNSReports on the domain in
question via DNSStuff.com
 
Its returning the MX entries for the domain without issue, but the
returned results do not contain the A records matching the listed MX
entries.
 
Eg:
 
@ IN MX 10 mx1.domain.com
@ IN MX 20 mx2.domain.com

A request for MX entries returns something similar to that.
However, to speed up DNS, and allow resolution without subsequent
requests, we should be able to respond to a request for MX records with
accompanying A records:
 
@ IN MX 10 mx1.domain.com
@ IN MX 20 mx2.domain.com
mx1 IN A 1.2.3.4
mx2 IN A 9.8.7.6
 
Any thoughts on how I can do this?
Current SQL Queries are as follows (colored to match website SQL
coloring for MySQL: http://bind-dlz.sourceforge.net/mysql_driver.html): 
 
 
dlz "MySQL Zone" {
        database "mysql
        {host=localhost dbname=dbname user=user pass=pass}
        {SELECT DISTINCT 'DOMAIN_EXISTS' FROM `dns_zones` WHERE
`domain_name` = '%zone%'}
        {SELECT `ttl`,`type`,`mx_priority`,IF (`type` = 'TXT',
concat('\"', `data`, '\"'), `data`) FROM `dns_records` LEFT JOIN
`dns_zones` ON `dns_records`.`dns_zone_id` = `dns_zones`.`id` WHERE
`domain_name`='%zone%' AND `host`='%record%' AND NOT (`type`='SOA' OR
`type`='NS')}
        {SELECT
`ttl`,`type`,`mx_priority`,`data`,`contact`,`serial`,`refresh`,`retry`,`
expire`,`minimum` FROM `dns_records` LEFT JOIN `dns_zones` ON
`dns_records`.`dns_zone_id`=`dns_zones`.`id` WHERE
`domain_name`='%zone%' AND (`type`='SOA' OR `type`='NS') ORDER BY `type`
DESC}
        {SELECT `ttl`,`type`,`mx_priority`,IF (`type` = 'TXT',
concat('\"', `data`, '\"'),
`data`),`contact`,`serial`,`refresh`,`retry`,`expire`,`minimum` FROM
`dns_records` LEFT JOIN `dns_zones` ON
`dns_records`.`dns_zone_id`=`dns_zones`.`id` WHERE
`domain_name`='%zone%' AND NOT (`type`='SOA' OR `type`='NS')}
        {SELECT DISTINCT 'ALLOW_TRANSFER' FROM `dns_transfers` LEFT JOIN
`dns_zones` ON `dns_transfers`.`dns_zone_id` = `dns_zones`.`id` WHERE
`domain_name`='%zone%' AND `client`='%client%'}
        {INSERT INTO `dns_queries` SET `domain_name`='%zone%'}";
};

 
Cheers,
 
Graham Weldon
 
Fluid Lino
(02) 4927 5337
(0407) 017 293
[email protected] <mailto:[email protected]> 
www.fluidlino.com.au <http://www.fluidlino.com.au/> 
 

________________________________

From: [email protected]
[mailto:[email protected]] On Behalf Of
Graham Weldon
Sent: Tuesday, 26 February 2008 11:35 AM
To: [email protected]
Subject: [Bind-dlz-testers] No glue on MX and NS requests.



 

Hi all,

Just running a few DNS reports on the domains hosted on our systems, and
I am noticing that requests for NS and MX records do not return the
corresponding A records.
Is this something that should be done, and is it something that I can
simply configure by re-writing my SQL statements?

Appreciate any help.

Cheers,
 
Graham Weldon
 
Fluid Lino
(02) 4927 5337
(0407) 017 293
[email protected] <mailto:[email protected]> 
www.fluidlino.com.au <http://www.fluidlino.com.au/>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers