<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Yes, a tutorial about this would be greatly appreciated.</p>
<p>CB sound delicious, but without data on how to populate the
tables, ( and which tables ) , it's like a beautiful car and no
keys to it .</p>
<p>Cris<br>
</p>
<div class="moz-cite-prefix">On 9/5/19 8:57 AM, Marc Boisis wrote:<br>
</div>
<blockquote type="cite"
cite="mid:52879F67-D0CA-4023-BAC5-9E89D28DA6D7@univ-lr.fr">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
No in 1.6 we can declare subnet and global parameters in MYSQL : <a
href="https://kea.readthedocs.io/en/v1_6_0/arm/config.html?highlight=workbench#kea-configuration-backend"
class="" moz-do-not-send="true">https://kea.readthedocs.io/en/v1_6_0/arm/config.html?highlight=workbench#kea-configuration-backend</a>
<div class=""><br class="">
</div>
<div class="">But there is no doc like "INSERT new-subnet INTO ...<br
class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On 5 Sep 2019, at 05:02, Klaus Steden <<a
href="mailto:klausfiend@gmail.com" class=""
moz-do-not-send="true">klausfiend@gmail.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class=""><br class="">
<div class="">You want something like this:</div>
<div class=""><br class="">
</div>
<div class="">
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
style="font-variant-ligatures:no-common-ligatures"
class="">{</span><br class="">
</p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
style="font-variant-ligatures:no-common-ligatures"
class=""> "Dhcp4":</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
style="font-variant-ligatures:no-common-ligatures"
class=""> {</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
style="font-variant-ligatures:no-common-ligatures"
class=""> ...</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><br
class="">
</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures">#
Use MySQL lease database backend to store leases
in a database.</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"lease-database":
{</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"type":
"mysql",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"host":
"__MYSQL_HOST__",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"name":
"__MYSQL_DB__",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"user":
"__MYSQL_USER__",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"password":
"__MYSQL_PASSWORD__"</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>},</span></p>
<p class="gmail-p2"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75);min-height:14px"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"></span><br
class="">
</p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures">#
Use MySQL hosts database backend to store
reservations in a database.</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"hosts-database":
{</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"type":
"mysql",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"host":
"__MYSQL_HOST__",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"name":
"__MYSQL_DB__",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"user":
"__MYSQL_USER__",</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>"password":
"__MYSQL_PASSWORD__"</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures"><span
class="gmail-Apple-converted-space"> </span>},</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures">
...</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures">
}</span></p>
<p class="gmail-p1"
style="margin-bottom:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:10px;line-height:normal;font-family:Monaco;color:rgb(242,242,242);background-color:rgba(0,0,0,0.75)"><span
class="gmail-s1"
style="font-variant-ligatures:no-common-ligatures">}</span></p>
<div class=""><br class="">
</div>
<div class="">where the tokens are whatever your SQL
credential/database parameters are.</div>
</div>
<div class=""><br class="">
</div>
<div class="">hth,</div>
<div class="">Klaus</div>
</div>
<br class="">
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Sep 4, 2019 at
3:39 AM Marc Boisis <<a
href="mailto:marc.boisis@univ-lr.fr" class=""
moz-do-not-send="true">marc.boisis@univ-lr.fr</a>>
wrote:<br class="">
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex"><br class="">
Where can I find where to put dhcp4 parameters in
mysql configuration backend ? (which table ?
values...).<br class="">
_______________________________________________<br
class="">
Kea-users mailing list<br class="">
<a href="mailto:Kea-users@lists.isc.org"
target="_blank" class="" moz-do-not-send="true">Kea-users@lists.isc.org</a><br
class="">
<a
href="https://lists.isc.org/mailman/listinfo/kea-users"
rel="noreferrer" target="_blank" class=""
moz-do-not-send="true">https://lists.isc.org/mailman/listinfo/kea-users</a><br
class="">
</blockquote>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
<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>
<pre class="moz-signature" cols="72">--
----------------------------------------------------------------------
Cristian Lemnaru
GPON Engineer
RCS & RDS - Brasov Branch
Mobil : 0770056815
<a class="moz-txt-link-abbreviated" href="mailto:cristian.lemnaru@rcs-rds.ro">cristian.lemnaru@rcs-rds.ro</a>
----------------------------------------------------------------------
Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message(or responsible
for delivery of the message to such person),you may not copy or deliver
this message to anyone. In such a case, you should destroy this message
and kindly notify the sender by reply e-mail.
</pre>
</body>
</html>