[Pdns-users] zone2sql with bind

[Erik Ljungstrom]

Are you possibly using a slightly older version? This  was fixed in http://wiki.powerdns.com/trac/changeset/1234 - released in 2.9.22.

Cheers,
Erik
________________________________________
From: pdns-users-bounces at mailman.powerdns.com [pdns-users-bounces at mailman.powerdns.com] on behalf of Ian Mordey [ian.mordey at griffin.com]
Sent: 08 December 2010 15:35
To: pdns-users at mailman.powerdns.com
Subject: [Pdns-users] zone2sql with bind

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
This message is intended solely for the use of the individual or organisation to whom it is addressed. It may contain privileged or confidential information. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message. All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of DediPower Managed Hosting Ltd or its affiliates.

DediPower Managed Hosting Ltd is registered in England and Wales No. 3625971 Registered Office: Cadogan House, Rose Kiln Lane, Reading, Berkshire, RG2 0HP