<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi I am receiving these error messages when I am
trying to query certain record types with powerdns and a mysql backend. Certain
queries are working fine and some</FONT></DIV>
<DIV><FONT face=Arial size=2>aren't, some examples follow:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>dig @172.16.0.151 test.com </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>;; QUESTION
SECTION:<BR>;test.com.
IN A<BR> <BR>;; ANSWER
SECTION:<BR>test.com.
172800 IN
A
172.16.0.100<BR>--------------------</FONT></DIV>
<DIV><FONT face=Arial size=2>dig @172.16.0.151 test.com NS</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>;; Warning: Message parser reports malformed
message packet.<BR>;; Truncated, retrying in TCP mode.<BR>;; Connection to
172.16.0.151#53(172.16.0.151) for test.com failed: connection
refused.<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>It seems like query types of NS, MX or ANY are
failing while A SOA and PTR are fine. I can't see any error messages in
the logs as to why.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mysql tables were built as specified by the
documentation. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Here is an overview of the insert statements I used
for mysql:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into domains (name,type) values
('test.com','NATIVE');</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'test.com', 'SOA', <BR>'ns1.test.com.
dnsadmin.test.com. 20030501 28800 7200 1209600 3600', 172800, 0 from domains
<BR>where name='test.com';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'test.com', <BR>'A', '172.16.0.100',
172800, 0 from domains where name='test.com';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'test.com', <BR>'NS', 'ns1.test.com',
172800, 0 from domains where name='test.com';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'test.com', <BR>'NS', 'ns2.test.com',
172800, 0 from domains where name='test.com';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'ns1.test.com', <BR>'A', '172.16.0.1',
172800, 0 from domains where name='test.com';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'ns2.test.com', <BR>'A', '172.16.0.2',
172800, 0 from domains where name='test.com';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If I do a query on the A record for ns1 or
ns2.test.com then those come back fine. Perhaps my Insert statements for the NS
entries are off?</FONT></DIV>
<DIV><FONT face=Arial size=2>Any help on this is greatly appreciated.
Thanks!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Graham White<BR><A
href="mailto:graham@bravenet.com">graham@bravenet.com</A></FONT><FONT face=Arial
size=2></DIV>
<DIV><BR></DIV></FONT></BODY></HTML>