[Kea-users] KEA DHCP with DB back end

[mtint hpc]

Hey Nicolò,

I wanted to discuss something about my organization. We don't allocate any
funds for software on our platforms, which are primarily used for research
purposes. I was considering directly writing to the database tables, but
you've advised against it due to the potential risks. If we manually insert
IP addresses and subnets into the database, will KEA automatically detect
them? I came across this resource [
https://gitlab.isc.org/isc-projects/kea/-/wikis/docs/editing-host-reservations],
and I've been working on this project for a few months now, so I need a
solution.

Kind Regards,

Michael

On Mon, 15 Jan 2024 at 11:29, Nicolò Borghi <borghi.nicolo at gmail.com> wrote:

> Hello,
>
> unfortunately, the DB backend is not supposed to be edited manually.
> Instead, you'd need to load either the MySQL or PostgreSQL Configuration
> Backend hook library. This exposes a convenient API to interact with the DB.
> From this section of the manual:
> https://kea.readthedocs.io/en/kea-2.4.0/arm/hooks.html#available-hook-libraries you'll
> find that both hook libs are open source. However, they have an inevitable
> dependency on this other hook:
> https://kea.readthedocs.io/en/kea-2.4.0/arm/hooks.html#std-ischooklib-libdhcp_cb_cmds.so which
> is only available after paying a recurring subscription.
>
> The structure of the DB is rather intuitive, but manually inserting rows
> into it has been made rather difficult on purpose and I don't suggest
> trying to bypass all the obstacles, otherwise the integrity of the DB may
> not be fully guaranteed.
>
> Best,
> Nicolò.
>
>
>
>
> January 15, 2024 at 12:10 PM, "mtint hpc" <hpcmtint at gmail.com
> <hpcmtint at gmail.com?to=%22mtint%20hpc%22%20%3Chpcmtint%40gmail.com%3E>>
> wrote:
>
> Hello everyone,
>
> We are in the process of transitioning from our previous DDI solution to
> phpIPAM, KEA DHCP with a database backend, and PowerDNS. Currently, KEA is
> operational without a database backend for DHCP reservations. In our setup,
> there won't be any DHCP pools, and IP addresses will be allocated via the
> DHCP reservation. We have a total of 10 subnets. Can anyone provide
> guidance on how to proceed with this migration and which tables in the Kea
> schema should be edited?
>
> Thank you,
>
> Michael
>
>
> --
> ISC funds the development of this software with paid support
> subscriptions. Contact us at https://www.isc.org/contact/ for more
> information.
>
> To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users.
>
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20240115/2cab9af6/attachment.htm>