<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>The allowed NULL in type is NOT optional. Exactly for these purposes (empty-non-terminals).<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>You _<i>could</i>_ 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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;color:#1F497D'>Kind regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas;color:#1F497D'>Sebastian<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> pdns-users-bounces@mailman.powerdns.com [mailto:pdns-users-bounces@mailman.powerdns.com] <b>Im Auftrag von </b>Philippe M<br><b>Gesendet:</b> Donnerstag, 6. März 2014 14:24<br><b>An:</b> pdns-users@mailman.powerdns.com <br><b>Betreff:</b> Re: [Pdns-users] Wildcards for ipv6 PTR Records?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>Hello Peter,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>thank You for your Responds.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>>> I tried to do wildcard records like:<br>>> *.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa<br><br>>This should work.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>I thougth so too, but it doesn't.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>Is there anything i have to change somewhere to get the wildcards working?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>>Please update your schema to allow the NULLs!<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>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".<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>I'll try to look into the program to find a way for a solution for Problem with the NULL Constraint.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>But until i found one, i would like to use the wildcard.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>Kind regards,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'>Philippe<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p><div><div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>Peter van Dijk <<a href="mailto:peter.van.dijk@netherlabs.nl">peter.van.dijk@netherlabs.nl</a>> schrieb am 11:34 Donnerstag, 6.März 2014:</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'>Hello Philippe,<br><br>On 06 Mar 2014, at 10:03 , Philippe M <<a href="mailto:m_philippe@rocketmail.com">m_philippe@rocketmail.com</a>> wrote:<br><br>> is it possible wo wildcard ipv6 PTR Records?<br><br>There is nothing special about PTRs, and you can wildcard them according to the same rules as any other record.<br><br>> I tried to do wildcard records like:<br>> *.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa<br><br>This should work.<br><br>> *.*.w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa<br><br>This does not work.<o:p></o:p></span></p><div id=yqtfd20324><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><br><br>> The Reason why i want the Wildcards:<br>> When i try to "rectify-zone w.w.w.w.x.x.x.x.y.y.y.y.z.z.z.z.ip6.arpa"<br>> The Problem is, that i can't rectify these ipv6 reverse-lookup zones without having the upper record of the PTR Records. (for example: <br>> Powerdns wants to reate the following record:<br>> 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 <br>> in domain_id xxxx: PostgreSQL failed to execute command: ERROR: null value in column "type" violates not-null constraint<br>> for this PTR Record:<br>> 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<br>> <br>> I know why it fails, that's not the point, that's why i wanted to create them manually.<br>> (For explanation the error comes from:<br>> 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)<br>> which failes because of the null type which powerdns tries to create.<o:p></o:p></span></p></div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><br><br>Please update your schema to allow the NULLs!<br><br>Kind regards,<br>-- <br>Peter van Dijk<br>Netherlabs Computer Consulting BV - <a href="http://www.netherlabs.nl/" target="_blank">http://www.netherlabs.nl/</a><o:p></o:p></span></p><div id=yqtfd21037><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p><div id=yqtfd36109><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica","sans-serif";color:black'>_______________________________________________<br>Pdns-users mailing list<br><a href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a><br><a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div></div></div></div></div></div></div></body></html>