[Pdns-users] zone2sql with bind

[Ian Mordey]

Hi there

I'm trying to use zone2sql to migrate DNS from a bind box to a new
PowerDNS box. I have a problem where the bind zone file contains a . in
the $ORIGIN. For example:

 

$ORIGIN .

 

Zone2sql writes the insert as:

Insert into domains (name,type) values ('example.com','NATIVE');

Insert into records (domain_id,name,type,content,ttl,prio) select id
,'example.com' ,  'NS' , 'ns0.example.com', 345600, 0 from domains where
name = 'example.com.')

 

This breaks the insert of the record as no domain exists with the name =
'example.com.' only 'example.com'

 

Any ideas why? Or any workaround?

 

Thanks

Ian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20101208/ba0b1b81/attachment.html>