<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">The schema for the configuration backend is documented in the code, here: <a href="https://gitlab.isc.org/isc-projects/kea/blob/master/src/share/database/scripts/mysql/dhcpdb_create.mysql" class="">https://gitlab.isc.org/isc-projects/kea/blob/master/src/share/database/scripts/mysql/dhcpdb_create.mysql</a> We also have some related design documents in our public Gitlab - <a href="https://gitlab.isc.org/isc-projects/kea/wikis/designs/configuration-in-db-design" class="">https://gitlab.isc.org/isc-projects/kea/wikis/designs/configuration-in-db-design</a>. <div class=""><br class=""></div><div class="">So, a do-it-yourselfer can certainly populate the tables directly or develop their own system for modifying the tables. This is not recommended because, as Thomas pointed out, it is easy to screw things up directly modifying the database. But, the feature enabling the configuration backend is open source, and you are welcome to modify the open source however you like for your deployment. </div><div class=""><br class=""></div><div class="">We did just do a webinar on using the subscription CB-cmds hook library to manage the config backend. The recording is on the ISC channel at <a href="https://www.youtube.com/watch?v=gnVEO4ThE10" class="">https://www.youtube.com/watch?v=gnVEO4ThE10</a>. This is the way we recommend you manage the config backend.</div><div class=""><br class=""></div><div class="">Vicky</div><div><br class=""><blockquote type="cite" class=""><div class="">On Sep 5, 2019, at 3:54 AM, Thomas Markwalder <<a href="mailto:tmark@isc.org" class="">tmark@isc.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
<div text="#000000" bgcolor="#FFFFFF" class="">
<tt class="">Hello:<br class="">
<br class="">
The Configuration Backend is a Kea Support Subscriber-level hook
library which provides RESTful commands for managing the
configuration elements. It is described in the Administration
Reference Manual here:<br class="">
<br class="">
<a class="moz-txt-link-freetext" href="https://kea.readthedocs.io/en/v1_6_0/arm/hooks.html#cb-cmds-configuration-backend-commands">https://kea.readthedocs.io/en/v1_6_0/arm/hooks.html#cb-cmds-configuration-backend-commands</a><br class="">
<br class="">
We do not recommend (nor support) people directly manipulating the
data in the our schema. The CB library provides application logic
to make sure things stay sane and isolates users from future
schema changes.<br class="">
<br class="">
For more information on Kea support subscriptions, start here:<br class="">
<br class="">
<a class="moz-txt-link-freetext" href="https://www.isc.org/kea/">https://www.isc.org/kea/</a><br class="">
<br class="">
<br class="">
Cheers,<br class="">
<br class="">
Thomas Markwalder<br class="">
</tt><br class="">
<div class="moz-cite-prefix">On 9/5/19 4:41 AM, Cristian Lemnaru
wrote:<br class="">
</div>
<blockquote type="cite" cite="mid:d74437bd-baa3-a914-09e9-9c12029bce0c@rcs-rds.ro" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class=""><p class="">Yes, a tutorial about this would be greatly appreciated.</p><p class="">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 class="">Cris<br class="">
</p>
<div class="moz-cite-prefix">On 9/5/19 8:57 AM, Marc Boisis wrote:<br class="">
</div>
<blockquote type="cite" cite="mid:52879F67-D0CA-4023-BAC5-9E89D28DA6D7@univ-lr.fr" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
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 class=""><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 class="">
<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>
<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" moz-do-not-send="true">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>
<br class="">
<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 class="">
</div>
_______________________________________________<br class="">Kea-users mailing list<br class=""><a href="mailto:Kea-users@lists.isc.org" class="">Kea-users@lists.isc.org</a><br class="">https://lists.isc.org/mailman/listinfo/kea-users<br class=""></div></blockquote></div><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Victoria Risk</div><div class="">Product Manager</div><div class="">Internet Systems Consortium</div><div class=""><a href="mailto:vicky@isc.org" class="">vicky@isc.org</a></div><div class=""><br class=""></div></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br class=""></body></html>