[Kea-users] Kea 2.6.5: hosts-database with PostgreSQL not querying database during DHCP lease allocation

[Doug Freed]

On 5/12/26 15:03, Eddie Taylor wrote:
> Sorry for the delay had an issue to address.
> 
> root at p-powerdns-001 ~]# grep -A 100 '"hooks-libraries"' /etc/kea/kea- 
> dhcp4.conf | grep -A 1 "library"
> 
>          "library": "/usr/lib64/kea/hooks/libdhcp_lease_cmds.so"
> 
>        },
> 
> --
> 
>          "library": "/usr/lib64/kea/hooks/libdhcp_ha.so",
> 
>          "parameters": {
> 
> --
> 
>          "library": "/usr/lib64/kea/hooks/libdhcp_host_cmds.so"
> 
>        },
> 
> --
> 
>          "library": "/usr/lib64/kea/hooks/libdhcp_pgsql_cb.so"
> 
>        }
> 
> [root at p-powerdns-001 ~]#
> 
> *From:*Kea-users <kea-users-bounces at lists.isc.org> *On Behalf Of *Peter 
> Davies
> *Sent:* Tuesday, May 12, 2026 11:47 AM
> *To:* kea-users at lists.isc.org
> *Subject:* Re: [Kea-users] Kea 2.6.5: hosts-database with PostgreSQL not 
> querying database during DHCP lease allocation
> 
> Hi Eddie,
>    What does your "hosts-database" definition look like?
> 
> Have you remembered to load the host commands hooks library 
> "libdhcp_host_cmds.so"
> 
> See: https://kea.readthedocs.io/en/kea-2.6.5/arm/hooks.html#libdhcp- 
> host-cmds-so-host-commands <https://kea.readthedocs.io/en/kea-2.6.5/arm/ 
> hooks.html#libdhcp-host-cmds-so-host-commands>
> 
> /Peter
> 
> On 12/05/2026 17.25, Eddie Taylor wrote:
> 
>     According to kb.isc.org/docs/aa-01615 (Kea Significant Features
>     Matrix), Kea 2.6 should support Host Reservations Mode (Global). We
>     have hosts-database configured with PostgreSQL, the schema is
>     correct (22.2), host reservations exist in the database with correct
>     data, but Kea 2.6.5 is not querying the database during DHCP lease
>     assignment. No special hook is indicated as required for Kea 2.6
>     host reservations in the matrix. What's missing or broken?
> 
>     All email and communication should be considered private and
>     protected personal and shall be secured under all applicable laws.
>     Any recipient, who has access to any contained information,
>     regardless of purpose or medium is so advised, bound and obligated
>     to handle as such.
> 
> -- 
> 
> Peter Davies
> 
> Support Engineer
> 
> Internet Systems Corporation
> 
> All email and communication should be considered private and protected 
> personal and shall be secured under all applicable laws. Any recipient, 
> who has access to any contained information, regardless of purpose or 
> medium is so advised, bound and obligated to handle as such.
> 

My first recommendation would be to crank the logging up to DEBUG level 
99, and trigger some clients to request a lease that should be getting a 
reservation.  Post the logs here on the list and somebody can probably 
figure out what's going wrong.  It would likely also be helpful to have 
your full configuration.

-Doug