The allowed NULL in type is NOT optional. Exactly for these purposes (empty-non-terminals). Powerdns automatically creates "filler" records with type=NULL if you e.g. create record a.b.c.bla in domain c.bla without any record present for b.c.bla.
IOW: If your software is designed to work on a Powerdns database backend and cannot handle type=NULL, it's br0ken. Fell into that trap on my own. You _could_ try changing the corresponding queries that create these records to not enter NULL but some other bogus into type field, but I'm rather sure this would break Powerdns processing these "filler" records, as "type=NULL" is expected here. Kind regards, Sebastian Von: [email protected] [mailto:[email protected]] Im Auftrag von Philippe M Gesendet: Donnerstag, 6. März 2014 14:24 An: [email protected] Betreff: Re: [Pdns-users] Wildcards for ipv6 PTR Records? Hello Peter, thank You for your Responds. >> I tried to do wildcard records like: >> *.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa >This should work. I thougth so too, but it doesn't. Is there anything i have to change somewhere to get the wildcards working? >Please update your schema to allow the NULLs! We use a custom made Program, to manage our Zones, which get Errors if the Type get's NULL, that's why i wanted to Use the Wildcard and just add PTR's with the content "hosted.by.xxxx". I'll try to look into the program to find a way for a solution for Problem with the NULL Constraint. But until i found one, i would like to use the wildcard. Kind regards, Philippe Peter van Dijk <[email protected]<mailto:[email protected]>> schrieb am 11:34 Donnerstag, 6.März 2014: Hello Philippe, On 06 Mar 2014, at 10:03 , Philippe M <[email protected]<mailto:[email protected]>> wrote: > is it possible wo wildcard ipv6 PTR Records? There is nothing special about PTRs, and you can wildcard them according to the same rules as any other record. > I tried to do wildcard records like: > *.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa This should work. > *.*.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa This does not work. > The Reason why i want the Wildcards: > When i try to "rectify-zone w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa" > The Problem is, that i can't rectify these ipv6 reverse-lookup zones without > having the upper record of the PTR Records. (for example: > Powerdns wants to reate the following record: > Error: GSQLBackend unable to insert empty non-terminal rr > 0.1.1.2.0.2.1.2.0.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6 > in domain_id xxxx: PostgreSQL failed to execute command: ERROR: null value > in column "type" violates not-null constraint > for this PTR Record: > 1.3.1.0.1.8.1.0.1.1.2.0.2.1.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6 > > I know why it fails, that's not the point, that's why i wanted to create them > manually. > (For explanation the error comes from: > STATEMENT: insert into records (domain_id,name,type,auth) values > ('xxxx','0.1.1.2.0.2.1.2.0.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6',null,true) > which failes because of the null type which powerdns tries to create. Please update your schema to allow the NULLs! Kind regards, -- Peter van Dijk Netherlabs Computer Consulting BV - http://www.netherlabs.nl/ _______________________________________________ Pdns-users mailing list [email protected]<mailto:[email protected]> http://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
