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

Frank van den Diepstraten frank.van.den.diepstraten at telfortglasvezel.nl
Thu Aug 15 09:46:40 UTC 2013

Thanks for your answer! 

In fact I use a script for adding bulk records into the database (reverse and forward for whole subnets). This script always worked fine. Now everytime I want to edit a zone it adds a '.' , so when I edit a zone 2 times, 2 dots are added behind the SOA, like this:

@               IN      SOA     ns1.domain.tld.. postmaster.domain.tld..

After 4 times I get this:

@               IN      SOA     ns1.domain.tld.... postmaster.domain.tld....

Thats not the behaviour I want. 

If the only solution is to make a report I will do that, but perhaps the above example is making it more clear and another solution is possible.



-----Oorspronkelijk bericht-----
Van: pdns-users-bounces at mailman.powerdns.com [mailto:pdns-users-bounces at mailman.powerdns.com] Namens Peter van Dijk
Verzonden: donderdag 15 augustus 2013 10:36
Aan: pdns-users Users
Onderwerp: Re: [Pdns-users] pdns 3.1-4 (debian wheezy): zone2sql does not remove trailing '.'

Hello Frank,

On Aug 13, 2013, at 13:23 , Frank van den Diepstraten wrote:

> 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?

This is a change that indeed occurred between 2.9.22 and 3.0. The dot should be removed but it does not cause any problems. Feel free to file a report at https://github.com/PowerDNS/pdns/issues if you feel we should change this.

If this is actually causing you problems, please explain how and why!

Kind regards,
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/

Pdns-users mailing list
Pdns-users at mailman.powerdns.com

More information about the Pdns-users mailing list