<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Am 04.10.2018 um 16:06 schrieb Rodrigo
Severo - Fábrica:<br>
</div>
<blockquote type="cite"
cite="mid:CAOdi6iaH6QP+rbjYQimbPUy75fj9zzJwVaLnmG+Hu-io3UBSQw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">
<div dir="ltr">Hi,
<div><br>
</div>
<div><br>
</div>
<div>I'm trying to understand the role fulfilled by each
column in the SQL backends.</div>
<div><br>
</div>
<div>I have already read this page: <a
href="https://doc.powerdns.com/authoritative/backends/generic-sql.html#queries"
moz-do-not-send="true">https://doc.powerdns.com/authoritative/backends/generic-sql.html#queries</a>
but can't find any info on the "ordername" column in the
"records" table.</div>
<div><br>
</div>
<div>What is the role of the "ordername" column in the
"records" table?</div>
</div>
</div>
</blockquote>
<br>
Copied from the URL you provided:<br>
<br>
<p style="background-color: transparent; box-sizing: border-box;
color: rgb(51, 51, 51); font-family: "Open
Sans",Helvetica,Arial,sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: 400;
letter-spacing: normal; margin-bottom: 10px; margin-left: 0px;
margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom:
0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;
text-align: left; text-decoration: none; text-indent: 0px;
text-transform: none; -webkit-text-stroke-width: 0px; white-space:
normal; word-spacing: 0px;">The ‘ordername’ field needs to be
filled out depending on the NSEC/NSEC3
mode. When running in NSEC3 ‘Narrow’ mode, the ordername field is
ignored and best left empty. In NSEC/NSEC3 mode, the ordername
field
should be NULL for any glue but filled in for all delegation NS
records
and all authoritative records. In NSEC3 opt-out mode, ordername is
NULL
for any glue and insecure delegation NS records, but filled in for
secure delegation NS records and all authoritative records.</p>
<span style="display: inline !important; float: none;
background-color: transparent; color: rgb(51, 51, 51);
font-family: "Open Sans",Helvetica,Arial,sans-serif;
font-size: 16px; font-style: normal; font-variant: normal;
font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
left; text-decoration: none; text-indent: 0px; text-transform:
none; -webkit-text-stroke-width: 0px; white-space: normal;
word-spacing: 0px;">
</span>
<p style="background-color: transparent; box-sizing: border-box;
color: rgb(51, 51, 51); font-family: "Open
Sans",Helvetica,Arial,sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: 400;
letter-spacing: normal; margin-bottom: 10px; margin-left: 0px;
margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom:
0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;
text-align: left; text-decoration: none; text-indent: 0px;
text-transform: none; -webkit-text-stroke-width: 0px; white-space:
normal; word-spacing: 0px;">In ‘NSEC’ mode, it should contain the
<em style="box-sizing: border-box;">relative</em> part of a domain
name,
in reverse order, with dots replaced by spaces. So
‘www.uk.powerdnssec.org’ in the ‘powerdnssec.org’ zone should have
‘uk
www’ as its ordername.</p>
<span style="display: inline !important; float: none;
background-color: transparent; color: rgb(51, 51, 51);
font-family: "Open Sans",Helvetica,Arial,sans-serif;
font-size: 16px; font-style: normal; font-variant: normal;
font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
left; text-decoration: none; text-indent: 0px; text-transform:
none; -webkit-text-stroke-width: 0px; white-space: normal;
word-spacing: 0px;">
</span>
<p style="background-color: transparent; box-sizing: border-box;
color: rgb(51, 51, 51); font-family: "Open
Sans",Helvetica,Arial,sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: 400;
letter-spacing: normal; margin-bottom: 10px; margin-left: 0px;
margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom:
0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;
text-align: left; text-decoration: none; text-indent: 0px;
text-transform: none; -webkit-text-stroke-width: 0px; white-space:
normal; word-spacing: 0px;">In ‘NSEC3’ non-narrow mode, the
ordername should contain a lowercase
base32hex encoded representation of the salted & iterated hash
of the
full record name. <code class="docutils literal notranslate"
style="background-color: rgb(255, 255, 255);
border-bottom-left-radius: 4px; border-bottom-right-radius: 4px;
border-top-left-radius: 4px; border-top-right-radius: 4px;
box-sizing: border-box; color: rgb(141, 26, 56); font-family:
Consolas,monospace; font-size: 15px; line-height: 23px;
margin-bottom: 20px; margin-left: 0px; margin-right: 0px;
margin-top: 20px; padding-bottom: 2px; padding-left: 4px;
padding-right: 4px; padding-top: 2px; white-space: nowrap;
word-wrap: normal;"><span class="pre" style="box-sizing:
border-box;">pdnsutil</span> <span class="pre"
style="box-sizing: border-box;">hash-zone-record</span> <span
class="pre" style="box-sizing: border-box;">zone</span> <span
class="pre" style="box-sizing: border-box;">record</span></code>
can be used
to calculate this hash.</p>
<p style="background-color: transparent; box-sizing: border-box;
color: rgb(51, 51, 51); font-family: "Open
Sans",Helvetica,Arial,sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: 400;
letter-spacing: normal; margin-bottom: 10px; margin-left: 0px;
margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom:
0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;
text-align: left; text-decoration: none; text-indent: 0px;
text-transform: none; -webkit-text-stroke-width: 0px; white-space:
normal; word-spacing: 0px;"><br>
</p>
<p style="background-color: transparent; box-sizing: border-box;
color: rgb(51, 51, 51); font-family: "Open
Sans",Helvetica,Arial,sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: 400;
letter-spacing: normal; margin-bottom: 10px; margin-left: 0px;
margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom:
0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;
text-align: left; text-decoration: none; text-indent: 0px;
text-transform: none; -webkit-text-stroke-width: 0px; white-space:
normal; word-spacing: 0px;"><br>
</p>
<p style="background-color: transparent; box-sizing: border-box;
color: rgb(51, 51, 51); font-family: "Open
Sans",Helvetica,Arial,sans-serif; font-size: 16px;
font-style: normal; font-variant: normal; font-weight: 400;
letter-spacing: normal; margin-bottom: 10px; margin-left: 0px;
margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom:
0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;
text-align: left; text-decoration: none; text-indent: 0px;
text-transform: none; -webkit-text-stroke-width: 0px; white-space:
normal; word-spacing: 0px;">Klaus<br>
</p>
</body>
</html>