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

[Peter van Dijk]

Hello Frank,

putting double dots in the database certainly is not okay. When I said you could try to ignore it, I meant single dots.

I have to ask - why are you repeatedly exporting and importing zones?

Also, PowerDNS 3.2 and 3.3 will not send these broken packets (they will send SERVFAIL instead, which is not much more useful, of course).

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

On Aug 20, 2013, at 9:40 , Frank van den Diepstraten wrote:

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 841 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130820/763d4377/attachment-0001.sig>