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

[Frank van den Diepstraten]

Hi Peter,

I just tried to ignore this issue as you said it shouldt cause any problems. But when I edited my zone and put it back in the database (with in the SOA the 2 dots that are added by zone2sql) I get this:

:~$ host -t SOA domain.tld ip-of-the-ns-server
;; Got bad packet: extra input data
109 bytes
0e e2 85 00 00 01 00 01 00 00 00 00 0c 77 76 64          .............dom
65 76 61 63 68 74 6a 65 73 02 6e 6c 00 00 06 00          ain.tld.........
01 c0 0c 00 06 00 01 00 00 0e 10 00 40 03 6e 73          ............ at .ns
31 0c 63 6f 6e 63 65 70 74 73 2d 69 63 74 02 6e          1.domain.tld....
6c 00 00 0a 70 6f 73 74 6d 61 73 74 65 72 08 63          l...postmaster.d
6f 6e 63 65 70 74 73 c0 3e 77 fc 1b d6 00 00 70          omain.>w.......p
80 00 00 1c 20 00 09 3a 80 00 01 51 80                   .......:...Q.

Doesnt seem to work fine...

Any clue?

-----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
http://mailman.powerdns.com/mailman/listinfo/pdns-users