<!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.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=258005715-04072003><FONT face=Arial size=2>I'd like to start
off briefly by apologizing for the amount of posting I've made in the past 24
hours on the mail list... I'm a complete newb to PDNS, and opensource in
general... and I'm from the Microsoft world, so hey... Anyways, I believe this
here is a good question.</FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT size=2>1. I'm
trying to use Zone2sql.exe to migrate a couple thousand zones and about 30,000
host entries from Microsoft DNS zonefiles... unfortunately, there are thousands
of .dns zonefiles (1 for every zone)... I'm wondering though if there's a
parameter that I can pass to zone2sql that will point to the directory where all
the zone files are located. Now, I know there's --named-conf=, which,
according to the documentation "</FONT><FONT face="Times New Roman"><FONT
size=2>Parse this named.conf to find locations of zones.<SPAN
class=258005715-04072003>", <FONT face=Arial>However, I have no idea what the
structure of the named.conf file is supposed to be, and I'm having trouble
finding anything online. Will using a named.conf file solve my problem, or
do I have to write a script that loops through each zonefile in the directory
and executes the zone2sql on each zonefile
individually?</FONT></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003>2. I noticed the insert statements generated by
zone2sql are slightly different than the insert statements found in chapter 4 of
the documentation, and some are just downright wrong. For example, if I'm
adding a record for test.com with a hostname of www, zone2sql outputs the
following:</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003> <EM>insert into domains (name,type)
values ('','NATIVE');</EM></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003> <EM>insert into records (domain_id,
name,type,content,ttl,prio) select id ,'www', 'A', '64.141.48.50', 3600, 0 from
domains where name='';</EM></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003><EM></EM></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial><FONT
face="Times New Roman"><FONT face=Arial size=2><SPAN
class=258005715-04072003>The obvious 'whoopsie' I see here is that the insert
into domains statement fails to provide a value for name, where instead it
should be 'test.com'.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT><FONT><SPAN
class=258005715-04072003><FONT face=Arial size=2>The next part that really
confuses me is the insert statement for the record. The value zone2sql is
providing for the name field is "www", where as in the documentation the value
is a fully qualified domain name </FONT><A href="http://www.test.com"><FONT
face=Arial color=#000000 size=2>www.test.com</FONT></A><FONT face=Arial><FONT
size=2>.</FONT> </FONT></SPAN></FONT></FONT></SPAN><SPAN
class=258005715-04072003><FONT face=Arial> <FONT size=2>Is this a
bug?</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial size=2>The zonefiles are
created by Win2K Server, and the zone2sql is from the windows release of
PowerDNS 2.9.6.</FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial size=2>Sorry for the long
windedness, better to be thorough though... Can anybody point me in the wrong
direction?</FONT></SPAN></DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258005715-04072003><FONT face=Arial size=2>Thanking you all in
advance,</FONT></SPAN></DIV>
<P><FONT size=2>- Ryan Baldwin<BR>Programmer<BR>Point2 Technologies Inc.<BR><A
href="http://www.point2.com/">www.point2.com</A><FONT face=Arial><BR><A
href="http://www.point2agent.com/">www.point2agent.com</A></FONT></FONT><FONT
size=2></P></FONT>
<DIV> </DIV></BODY></HTML>