<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="">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="">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="">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="">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="">Kea-users@lists.isc.org</a><br class="">
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank" class="">https://lists.isc.org/mailman/listinfo/kea-users</a><br class="">
</blockquote></div>
</div></blockquote></div><br class=""></div></body></html>