<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
You need only use a very large value to get a lease that it is
virtually infinite. So long as the value is no more than max for
32-bit signed integer you should be fine.<br>
<br>
<div class="moz-cite-prefix">On 6/6/19 2:49 PM, Thomas Markwalder
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:f797c3dd-992b-7e2c-a7b8-96120430dd7b@isc.org">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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" moz-do-not-send="true">Kea-users@lists.isc.org</a>
<a class="moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users" moz-do-not-send="true">https://lists.isc.org/mailman/listinfo/kea-users</a>
</pre>
</blockquote>
<br>
<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>