[Pdns-users] pdns 3.1-4 (debian wheezy): zone2sql does not remove trailing '.'

[Frank van den Diepstraten]

Hi all,

I upgraded my debian system to wheezy with pdns-server 3.1-4 (came from 2.9.22-8 which was the latest squeeze version). Everything  looked fine, but when I started using the zone2sql script I saw the following problem:

This is the SOA record from one of the domains in the server running version 3.1-4:

4640410 |         2 | x.x.x.in-addr.arpa | SOA  | ns1.domain.tld postmaster.domain.tld 2013060405 28800 7200 604800 86400  | 3600 |    0 |        NULL

Now when I use a script to write the zone to a file I have this output:

@               IN      SOA     ns1.domain.tld. postmaster.domain.tld. (
                2013060406 ; serial
                     28800 ; refresh
                      7200 ; retry
                    604800 ; expire
                     86400); minimum

As you can see there are now trailing '.' Behind the domain and postmaster mailadres. As far as i now this is the normal behaviour. Now when I use zone2sql to make the right syntax to get the edited file back into the database this happens:

root at ns1:/tmp# zone2sql --gmysql --zone=/tmp/domain.1 --zone-name=domain.tld
insert into records (domain_id, name,type,content,ttl,prio) select id ,'domain.tld', 'SOA', 'ns1.domain.tld. postmaster.domain.tld. 2013010901 28800 7200 604800 86400', 3600, 0 from domains where name='domain.tld';

When I manually remove the trailing dots out of the database the zone2sql script put the domainname instead, so thats nog solving the problem (this is what the SOA looks like when I remove the dots: ns1.domain.tld.domain.tld. postmaster.domain.tld.domain.tld.)

As you can see the trailing dots are not being stripped by zone2sql which always was the case in the earlier versions. Is this a bug or is there somthing else I missed?

Regards,

Frank.






Met vriendelijke groet,
Frank van den Diepstraten
System engineer

[cid:image001.png at 01CE973F.0F477C40]

E: frank.van.den.diepstraten at telfortglasvezel.nl<mailto:frank.van.den.diepstraten at telfortglasvezel.nl>
T: +31 (0)76 - 750 1694
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130813/5d012811/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5504 bytes
Desc: image001.png
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130813/5d012811/attachment.png>