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-boun...@mailman.powerdns.com [pdns-users-boun...@mailman.powerdns.com] on behalf of Ian Mordey [ian.mor...@griffin.com] Sent: 08 December 2010 15:35 To: pdns-users@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 _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
