<div dir="ltr">I see this documentation <a href="https://github.com/josh73/migrate-host-reservations-to-kea-mysql/tree/master">https://github.com/josh73/migrate-host-reservations-to-kea-mysql/tree/master</a> <div><br></div><div>but i can't confirm or verify this - link does not exixts  <a href="https://downloads.isc.org/isc/kea/cur/2.5/doc/html/search.html?q=ipv4-subnet-id&check_keywords=yes&area=default">https://downloads.isc.org/isc/kea/cur/2.5/doc/html/search.html?q=ipv4-subnet-id&check_keywords=yes&area=default</a></div><div><br></div><div><table style="border-spacing:0px;border-collapse:collapse;margin-top:0px;margin-bottom:16px;display:block;width:max-content;max-width:100%;overflow:auto;color:rgb(203,218,230);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI","Noto Sans",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji";font-size:16px;background-color:rgb(10,14,18)"><tbody style="box-sizing:border-box"><tr style="box-sizing:border-box"><td style="box-sizing:border-box;padding:6px 13px"><code style="box-sizing:border-box;font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:13.6px;padding:0.2em 0.4em;margin:0px;border-radius:6px;background-color:rgba(220,224,228,0.1)">dhcpd_subnet_id</code></td><td style="box-sizing:border-box;padding:6px 13px">A unique number associated with a particular subnet. See <a href="https://downloads.isc.org/isc/kea/cur/doc/kea-guide.html#ipv4-subnet-id" rel="nofollow" style="box-sizing:border-box;background-color:transparent;text-decoration-line:none;margin-bottom:0px">https://downloads.isc.org/isc/kea/cur/doc/kea-guide.html#ipv4-subnet-id</a><br></td></tr></tbody></table></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 4 Oct 2023 at 15:06, mtint hpc <<a href="mailto:hpcmtint@gmail.com">hpcmtint@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi All, <div><br></div><div>We have pre-allocated all my desktops, 400+  in current DDI (replacing with Kea/phpIPAM).</div><div>Hoping to do the same with kea. I see in section Hosts Storage, </div><div><br></div><div>// The example below is not optimal from a performance perspective, but it<br>// nicely showcases the host reservation capabilities. Please use the minimum<br>// set of identifier types used in your network.</div><div><br></div><div><br><b>  "host-reservation-identifiers":<br>    [ "circuit-id", "hw-address", "duid", "client-id" ],</b><br><br>// Specify connection to the database holding host reservations. The type<br>// specifies that the MySQL database is used. user and password are the<br>// credentials used to connect to the database. host and name specify<br>// location of the host where the database instance is running, and the<br>// name of the database to use. The server processing a packet will first<br>// check if there are any reservations specified for this client in the<br>// reservations list, within the subnet (configuration file). If there are<br>// no reservations there, the server will try to retrieve reservations<br>// from this database.<br>  "hosts-database": {<br>    "type": "mysql",<br>    "reconnect-wait-time": 3000, // expressed in ms<br>    "max-reconnect-tries": 3,<br>    "name": "keatest",<br>    "user": "keatest",<br>    "password": "keatest",<br>    "host": "localhost",<br>    "port": 3306,<br>    "trust-anchor": "my-ca",<br>    "cert-file": "my-cert",<br>    "key-file": "my-key",<br>    "cipher-list": "AES"<br>  },</div><div><br></div><div>  "id": 1 <== is the subnet id? <br></div><div><br></div><div><div>how does it work with multiple subnets/scopes, is there a column to identify a different subnet?</div><div>in <b>host-reservation-identifiers </b></div></div><div><b><br></b></div><div>typically config but in my case reservations all in DB.</div><div>{<br>"subnet4": [<br>    {<br>        "id": 1,<br>        "pools": [ { "pool":  "192.0.2.1 - 192.0.2.200" } ],<br>        "subnet": "<a href="http://192.0.2.0/24" target="_blank">192.0.2.0/24</a>",<br>        "interface": "eth0",<br>        "reservations": [<br>            {<br>                "hw-address": "1a:1b:1c:1d:1e:1f",<br>                "ip-address": "192.0.2.202"<br>            },<br>            {<br>                "duid": "0a:0b:0c:0d:0e:0f",<br>                "ip-address": "192.0.2.100",<br>                "hostname": "alice-laptop"<br>            },<br>            {<br>                "circuit-id": "'charter950'",<br>                "ip-address": "192.0.2.203"<br>            },<br>            {<br>                "client-id": "01:11:22:33:44:55:66",<br>                "ip-address": "192.0.2.204"<br>            }<br>        ]<br>    }<br>],<br></div><div><br></div><div>Regards,</div><div><br></div><div>Michael</div><div><br></div><div><br></div></div>
</blockquote></div>