<html 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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif">Per <a href="https://gitlab.isc.org/isc-projects/kea/-/blob/master/src/lib/dhcpsrv/lease.cc">
lease.cc</a>, looks like there are 3 possible values for “state” column in kea-leases4.csv are 0, 1, or 2:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">const uint32_t Lease::STATE_DEFAULT = 0x0;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">const uint32_t Lease::STATE_DECLINED = 0x1;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">const uint32_t Lease::STATE_EXPIRED_RECLAIMED = 0x2;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif"><br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif"><o:p> </o:p></span></p>
<div id="mail-editor-reference-message-container">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">Kea-users <kea-users-bounces@lists.isc.org> on behalf of Darren Ankney <darren.ankney@gmail.com><br>
<b>Date: </b>Thursday, September 28, 2023 at 4:42 PM<br>
<b>To: </b>kea-users@lists.isc.org <kea-users@lists.isc.org><br>
<b>Subject: </b>Re: [Kea-users] kea-leases4.csv decode<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal">CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.<br>
<br>
<br>
Hi Chris,<br>
<br>
This isn't a simple answer, I'm afraid, but perhaps this document can<br>
help: <a href="https://reports.kea.isc.org/dev_guide/d2/d08/structisc_1_1dhcp_1_1Lease4.html">
https://reports.kea.isc.org/dev_guide/d2/d08/structisc_1_1dhcp_1_1Lease4.html</a><br>
It isn't directly about the storage file but I believe it is about<br>
the lease object that is stored in memfile which the lease log file<br>
feeds on startup.<br>
<br>
In particular you asked about:<br>
<br>
fqdn_fwd - "If true, forward DNS update is performed for a lease."<br>
fqdn_rev - " If true, forward DNS update is performed for a lease."<br>
state - I'm not sure about this one though it seems that the answer<br>
might be found spread throughout the document.<br>
<br>
There may be a better document somewhere that specifically defines<br>
this lease log file columns, but I could not find it.<br>
<br>
Thank you,<br>
<br>
Darren Ankney<br>
<br>
<br>
On Wed, Sep 27, 2023 at 1:13 PM LIU Chris via Kea-users<br>
<kea-users@lists.isc.org> wrote:<br>
><br>
> Classified as: {OPEN}<br>
><br>
><br>
> For kea lease file: /var/lib/kea/kea-leases4.csv<br>
><br>
> The header like below:<br>
><br>
> address,hwaddr,client_id,valid_lifetime,expire,subnet_id,fqdn_fwd,fqdn_rev,hostname,state,user_context<br>
><br>
><br>
><br>
> for sure, most of them, it explain by themselves via their name.<br>
><br>
> But for fqdn_fwd/fqdn_rev/state, what’s the meaning and how to decode them?<br>
><br>
> For example,<br>
><br>
> I got fqdn_fwd and fqdn_rev, the record value are 1<br>
><br>
> for state, the record value is 0.<br>
> With Best Regards,<br>
> Chris LIU<br>
<br>
<o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>