<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Couple simple leases files I took out from our automated testing
      are attached. Please be aware that in user context Kea can store
      quite extensive info in json structure (also attached). <br>
    </p>
    <p>Hope that will help</p>
    <p>Wlodek Wencel</p>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 13/04/2023 16:42, Rachael Wilson
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CY5PR19MB6220BF76D12E9895B54838A4CC989@CY5PR19MB6220.namprd19.prod.outlook.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
      <style>@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:Aharoni;}@font-face
        {font-family:"Arial Black";
        panose-1:2 11 10 4 2 1 2 2 2 4;}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.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:windowtext;}.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri",sans-serif;}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]-->
      <div class="WordSection1">
        <p class="MsoNormal">Thank you, Darren!  I will give perfdhcp a
          try.<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal"
          style="margin-bottom:8.0pt;line-height:106%"><o:p></o:p></p>
        <p class="MsoNormal"
          style="margin-bottom:8.0pt;line-height:106%"><o:p> </o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <br>
        <p>--<br>
          Rachael Wilson<br>
          (509) 422-8374</p>
        <div style="border:none;border-top:solid #E1E1E1
          1.0pt;padding:3.0pt 0in 0in 0in">
          <p class="MsoNormal"><b>From:</b> Kea-users
            <a class="moz-txt-link-rfc2396E" href="mailto:kea-users-bounces@lists.isc.org"><kea-users-bounces@lists.isc.org></a> <b>
              On Behalf Of </b>Darren Ankney<br>
            <b>Sent:</b> Thursday, April 13, 2023 3:27 AM<br>
            <b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:kea-users@lists.isc.org">kea-users@lists.isc.org</a><br>
            <b>Subject:</b> Re: [Kea-users] Migrate to Kea from non-ISC
            DHCP server ***EXTERNAL EMAIL***<o:p></o:p></p>
        </div>
        <p class="MsoNormal"><o:p> </o:p></p>
        <table class="MsoNormalTable" style="width:260.25pt" width="347"
          cellpadding="0" border="0">
          <tbody>
            <tr style="height:9.75pt">
              <td style="width:495.0pt;background:blue;padding:.75pt
                .75pt .75pt .75pt;height:9.75pt" width="660">
                <p><strong><span
                      style="font-size:9.0pt;font-family:"Arial
                      Black",sans-serif;color:yellow">EXTERNAL
                      EMAIL: Please Think Before You Click!!</span></strong><span
style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
              </td>
            </tr>
          </tbody>
        </table>
        <p><span
            style="font-size:10.0pt;font-family:"Arial",sans-serif"> <o:p></o:p></span></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <div>
          <p class="MsoNormal">Hello Rachael,<o:p></o:p></p>
          <div>
            <p class="MsoNormal"><o:p> </o:p></p>
          </div>
          <div>
            <p class="MsoNormal">There probably isn't an example file
              anywhere in the documentation (I looked also) or if there
              is, I just didn't find it.  I would suggest setting up a
              test kea server with the memfile lease database persisting
              to a file.  Then use perfdhcp to generate traffic thus
              populating the file.  If you need specific options to
              appear in the lease file, it is possible to use perfdhcp
              to generate most of them (even if you have to create the
              hex yourself).<o:p></o:p></p>
          </div>
          <div>
            <p class="MsoNormal"><o:p> </o:p></p>
          </div>
          <div>
            <p class="MsoNormal">Thank you,<o:p></o:p></p>
          </div>
          <div>
            <p class="MsoNormal"><o:p> </o:p></p>
          </div>
          <div>
            <p class="MsoNormal">Darren Ankney<o:p></o:p></p>
          </div>
        </div>
        <p class="MsoNormal"><o:p> </o:p></p>
        <div>
          <div>
            <p class="MsoNormal">On Wed, Apr 12, 2023 at 5:19 PM Rachael
              Wilson <<a href="mailto:RachaelW@okpud.org"
                moz-do-not-send="true" class="moz-txt-link-freetext">RachaelW@okpud.org</a>>
              wrote:<o:p></o:p></p>
          </div>
          <blockquote style="border:none;border-left:solid #CCCCCC
            1.0pt;padding:0in 0in 0in
            6.0pt;margin-left:4.8pt;margin-right:0in">
            <div>
              <div>
                <div>
                  <p class="MsoNormal"
                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi,
                    I would like to migrate a few thousand DHCP leases
                    from a non-ISC DHCP server to a memfile backed Kea
                    instance.  Looking through the docs, it seems it
                    would be easier to populate the lease file in
                    /var/lib/kea/kea-leases4.csv rather than using
                    hooks.  However, in a fresh install the file only
                    contains the header row.  Is there an example file
                    populated with rows I could look at to properly
                    format the data for import?  Didn’t see anything in
                    the docs, but might have missed it.<o:p></o:p></p>
                  <p class="MsoNormal"
                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                  <p class="MsoNormal"
                    style="mso-margin-top-alt:auto;margin-bottom:8.0pt;line-height:105%">
                     <o:p></o:p></p>
                  <p class="MsoNormal"
                    style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
                </div>
                <p class="MsoNormal">-- <o:p></o:p></p>
                <table class="MsoNormalTable" style="width:495.0pt"
                  id="m_-55651584395806363520.d7lo0ephf9g" width="660"
                  cellspacing="0" cellpadding="0" border="0">
                  <tbody>
                    <tr>
                      <td style="width:59.25pt;padding:0in 0in 0in 0in"
                        width="79">
                        <p class="MsoNormal" style="line-height:12.75pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><img
                              style="width:.9062in;height:.9062in"
                              id="m_-55651584395806363520.84vrp5kjk1v"
                              src="cid:part1.c0V0vaNx.RGfzTf07@isc.org"
                              alt="logo__250px.png" class="" width="87"
                              height="87" border="0"></span><span
                            style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
                      </td>
                      <td style="width:435.75pt;padding:4.5pt 4.5pt
                        4.5pt 4.5pt" width="581" valign="top">
                        <p class="MsoNormal" style="line-height:12.75pt"><strong><span
style="font-size:12.0pt;font-family:"Calibri",sans-serif">Rachael
                              Wilson
                            </span></strong><span
                            style="font-size:12.0pt;color:#7F7F7F">| </span><span
                            style="font-size:12.0pt;color:#1F497D">Network
                            Analyst</span><span style="font-size:10.0pt"><br>
                            <span style="color:#7F7F7F">Public Utility
                              District No. 1 Of Okanogan County <br>
                              Office: (509) 422-8374 | <a
                                href="mailto:RachaelW@okpud.org"
                                target="_blank" moz-do-not-send="true"
                                class="moz-txt-link-freetext">RachaelW@okpud.org</a> <br>
                            </span><span style="color:black">1331 2nd
                              Ave N., Okanogan, WA 98840 | P.O. Box 912,
                              Okanogan, WA 98840 </span></span><span
                            style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
                      </td>
                    </tr>
                    <tr>
                      <td colspan="2" style="width:495.0pt;padding:0in
                        0in 0in 0in" width="660" valign="top">
                        <p class="MsoNormal" style="line-height:12.75pt"><span
style="font-size:6.0pt;font-family:"Arial",sans-serif">P.U.D.
                            No. 1 of Okanogan County is an equal
                            opportunity provider and employer.  If you
                            think that you have received this message in
                            error, please e-mail the sender at the above
                            e-mail address.</span><span
                            style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
                      </td>
                    </tr>
                  </tbody>
                </table>
                <p class="MsoNormal"><o:p> </o:p></p>
              </div>
              <p class="MsoNormal">-- <br>
                ISC funds the development of this software with paid
                support subscriptions. Contact us at
                <a href="https://www.isc.org/contact/" target="_blank"
                  moz-do-not-send="true" class="moz-txt-link-freetext">https://www.isc.org/contact/</a>
                for more information.<br>
                <br>
                To unsubscribe visit <a
                  href="https://lists.isc.org/mailman/listinfo/kea-users"
                  target="_blank" moz-do-not-send="true"
                  class="moz-txt-link-freetext">
                  https://lists.isc.org/mailman/listinfo/kea-users</a>.<br>
                <br>
                Kea-users mailing list<br>
                <a href="mailto:Kea-users@lists.isc.org" target="_blank"
                  moz-do-not-send="true" class="moz-txt-link-freetext">Kea-users@lists.isc.org</a><br>
                <a
                  href="https://lists.isc.org/mailman/listinfo/kea-users"
                  target="_blank" moz-do-not-send="true"
                  class="moz-txt-link-freetext">https://lists.isc.org/mailman/listinfo/kea-users</a><o:p></o:p></p>
            </div>
          </blockquote>
        </div>
      </div>
      <br>
      <fieldset class="moz-mime-attachment-header"></fieldset>
    </blockquote>
  </body>
</html>