<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <tt>Please see section 4.3.6 of Kea Admin Guide:<br>
      <br>
<a class="moz-txt-link-freetext" href="https://jenkins.isc.org/job/Kea_doc/guide/kea-guide.html#idm139894053942032">https://jenkins.isc.org/job/Kea_doc/guide/kea-guide.html#idm139894053942032</a><br>
      <br>
      <br>
    </tt><br>
    <div class="moz-cite-prefix">On 6/6/19 12:56 PM, Sten Carlsen wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:1C1204FD-A2EC-47E9-AFE5-BF49030916AF@s-carlsen.dk">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      This was just a quick check for obvious things, I have nor used
      database backends. I am trying to learn because I see obvious
      advantages in my setting.<br>
      <br>
      <div id="AppleMailSignature" dir="ltr"><span
          style="background-color: rgba(255, 255, 255, 0);"><br>
          -- <br>
          Best regards<br>
          <br>
          Sten Carlsen<br>
          <br>
          No improvements come from shouting:<br>
          <br>
                "MALE BOVINE MANURE!!!"</span></div>
      <div dir="ltr"><br>
        On 6 Jun 2019, at 18.24, Laurent Aubert (laaubert) <<a
          href="mailto:laaubert@cisco.com" moz-do-not-send="true">laaubert@cisco.com</a>>
        wrote:<br>
        <br>
      </div>
      <blockquote type="cite">
        <div dir="ltr">
          <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:"Courier New \;color\:black";
        panose-1:2 7 3 9 2 2 5 2 4 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
        {mso-style-name:msonormal;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:"Courier New";}
span.EmailStyle20
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:windowtext;}
span.apple-converted-space
        {mso-style-name:apple-converted-space;}
span.EmailStyle22
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style>
          <div class="WordSection1">
            <p class="MsoNormal"><span style="font-size:11.0pt"
                lang="EN-US">Thanks Sten for your reply.<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">In our
                understanding the tool kea-admin lease-init, initialize
                the PostgresDB with the right schema defined for Kea<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">The way
                data is stored in PostgresDB is defined by Kea schema,
                which is defined here:<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><a
href="https://github.com/isc-projects/kea/blob/master/src/share/database/scripts/pgsql/dhcpdb_create.pgsql"
                  moz-do-not-send="true">https://github.com/isc-projects/kea/blob/master/src/share/database/scripts/pgsql/dhcpdb_create.pgsql</a><o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">Where
                valid_lifetime is define as:<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">valid_lifetime
                BIGINT,<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">And 
                according to PostgreSQL doc is:<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">bigint    
                8 bytes  large-range integer         
                -9223372036854775808 to +9223372036854775807<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">So is
                there a problem with the schema for PostgreSQL ?<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">Thanks,<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt">Laurent.<o:p></o:p></span></p>
            <p class="MsoNormal"><span style="font-size:11.0pt"
                lang="EN-US"><o:p> </o:p></span></p>
            <div style="border:none;border-top:solid #B5C4DF
              1.0pt;padding:3.0pt 0cm 0cm 0cm">
              <p class="MsoNormal"><b><span style="color:black">From: </span></b><span
                  style="color:black">Kea-users <<a
                    href="mailto:kea-users-bounces@lists.isc.org"
                    moz-do-not-send="true">kea-users-bounces@lists.isc.org</a>>
                  on behalf of Sten Carlsen <<a
                    href="mailto:stenc@s-carlsen.dk"
                    moz-do-not-send="true">stenc@s-carlsen.dk</a>><br>
                  <b>Date: </b>Thursday, June 6, 2019 at 5:20 PM<br>
                  <b>To: </b>"<a href="mailto:kea-users@lists.isc.org"
                    moz-do-not-send="true">kea-users@lists.isc.org</a>"
                  <<a href="mailto:kea-users@lists.isc.org"
                    moz-do-not-send="true">kea-users@lists.isc.org</a>><br>
                  <b>Subject: </b>Re: [Kea-users] Infinite lease not
                  stored in postgresql DB<o:p></o:p></span></p>
            </div>
            <div>
              <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            </div>
            <p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
            <div>
              <p class="MsoNormal">On 06/06/2019 13.02, Laurent Aubert
                (laaubert) wrote:<o:p></o:p></p>
            </div>
            <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
              <p class="MsoNormal"><span style="font-size:11.0pt"
                  lang="EN-US">Hi,</span><o:p></o:p></p>
              <p class="MsoNormal"><span style="font-size:11.0pt"
                  lang="EN-US"> </span><o:p></o:p></p>
              <p class="MsoNormal"><span style="font-size:11.0pt"
                  lang="EN-US">We deployed KEA 1.5 with a postgresql DB
                  without any issue. We have an application which asks
                  for IP addresses with an infinite lease.</span><o:p></o:p></p>
              <p class="MsoNormal"><span style="font-size:11.0pt"
                  lang="EN-US"> </span><o:p></o:p></p>
              <p class="MsoNormal"><span style="font-size:11.0pt"
                  lang="EN-US">When KEA receives the request, we see the
                  following error:</span><o:p></o:p></p>
              <p class="MsoNormal"><span style="font-size:11.0pt"
                  lang="EN-US"> </span><o:p></o:p></p>
              <p class="MsoNormal"><span
                  style="font-size:10.0pt;font-family:"Courier New
                  ;color:black",serif" lang="EN-US"><a
                    href="tel:2019" moz-do-not-send="true"><span
                      style="color:#00AFFA;text-decoration:none">2019</span></a>-06-06
                  09:05:02.566 ERROR [kea-dhcp4.alloc-engine/259]
                  ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1
                  00:00:00:00:00:00],
cid=[ff:00:00:00:00:00:02:00:00:00:09:01:10:49:52:38:30:39:47:2d:4c:54:45:2d:47:41:2d:4b:39:02:0<br>
                  b:4a:4d:58:32:30:32:33:58:30:30:30], tid=0x8aed1f:
                  error during attempt to allocate an IPv4 address:
                  Could not create bind array from Lease4:<span
                    class="apple-converted-space"> </span><a
                    href="http://192.168.89.2" moz-do-not-send="true"><span
                      style="color:#00AFFA;text-decoration:none">192.168.89.2</span></a>,
                  reason: Time value is too large:<span
                    class="apple-converted-space"> </span><a
                    href="tel:5854779197" moz-do-not-send="true"><span
                      style="color:#00AFFA;text-decoration:none">5854779197</span></a></span><o:p></o:p></p>
            </blockquote>
            <p class="MsoNormal"><span style="font-size:11.0pt">How is
                your definition of the lease time field in the database?
                this value requires 33 bits to be stored.<br>
                <br>
                <o:p></o:p></span></p>
            <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
              <p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
              <p class="MsoNormal"><span lang="EN-US">Everything works
                  fine if we use csv file to store the leases instead of
                  postgres.</span><o:p></o:p></p>
            </blockquote>
            <p class="MsoNormal"><span style="font-size:11.0pt">Yes, not
                limited by a fixed number of bits.<br>
                <br>
                <o:p></o:p></span></p>
            <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
              <p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
              <p class="MsoNormal"><span lang="EN-US">Any idea why such
                  leases can’t be stored in the DB ?</span><o:p></o:p></p>
              <p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
              <p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
            </blockquote>
            <p class="MsoNormal"><span style="font-size:11.0pt">Sten<br>
                <br>
                <o:p></o:p></span></p>
          </div>
        </div>
      </blockquote>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Kea-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a>
<a class="moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users">https://lists.isc.org/mailman/listinfo/kea-users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>