[Pdns-users] zone2sql with bind

[Ian Mordey]

It's from 2.9.22 tarball but I don't see those changes made in misc.hh..
In fact misc.hh is only 385 lines long..



-----Original Message-----
From: Erik Ljungstrom [mailto:Erik.Ljungstrom at dedipower.org] 
Sent: 08 December 2010 23:40
To: Ian Mordey; pdns-users at mailman.powerdns.com
Subject: RE: zone2sql with bind

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