[Kea-users] KEA DHCP with DB back end

[Nicolò Borghi]

Hi Michael,

as far as I know (far from me selling false hopes, so it's best if other users chime in), yes. Once you find a way to inject data into the DB, Kea will use it (provided you setup the host database correctly in the config file). In this case, i think you won't even need to load the backend hook libraries, as they are only intended to handle the DB from a config perspective.

Best,
Nicolò.



January 15, 2024 at 1:20 PM, "mtint hpc" <hpcmtint at gmail.com> wrote:


> 
> 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> 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/f0b31bc8/attachment.htm>