[Kea-users] flex-id reservation from db

[Darren Ankney]

Hello,

It is difficult to understand what is happening here with what has
been provided.  Perhaps you might consider sharing your Kea
configuration and debug level Kea logs.  Logs from postgres shouldn't
be necessary.

Thank you,
Darren Ankney

On Thu, Nov 20, 2025 at 3:17 PM Marcin Jurczuk <spock at omegastar.eu> wrote:
>
> I noticed DEBUG log saying:
> DEBUG FLEX_ID_NO_IDENTIFIER_EXPRESSION identifier-expression is either not specified or empty
> How is this possible ?
>
> czw., 20 lis 2025 o 21:03 Marcin Jurczuk <spock at omegastar.eu> napisał(a):
>>
>> Hi,
>>
>>
>> I'm trying to have flex-id reservation based on  option 82.1. I can't force KEA to do correct loopup in DB. I've enabled postgresql query snooping and I don't see correct query:
>>
>> Here is my setup:
>> ..
>>       {
>>         "library": "/usr/lib/kea/hooks/libdhcp_flex_id.so",
>>         "parameters": {
>>           "identifier-expression": "substring(relay4[1].text, 0, 12)",
>>           "replace-client-id": true
>>         }
>>       }
>>
>> "host-reservation-identifiers": [ "hw-address", "duid", "circuit-id", "client-id", "flex-id" ],
>>
>> I've added reservation via API:
>> {
>>   "command": "reservation-add",
>>   "arguments": {
>>       "operation-target":"database",
>>       "reservation": {
>>            "flex-id": "'DSNGCF232E15'"
>>       }
>>   }
>> }
>>
>> I see it reservation in db table after adding it
>> SQL logging shows number of queries like this;
>> postgres-1  | 2025-11-20 19:56:40 UTC [361]: [59-1] user=kea,db=keadhcp,app=[unknown],client=172.18.0.8 DETAIL:  parameters: $1 = '0', $2 = '0', $3 = '\x04f41c435c8c'
>> postgres-1  | 2025-11-20 19:56:40 UTC [361]: [60-1] user=kea,db=keadhcp,app=[unknown],client=172.18.0.8 LOG:  execute get_host_subid4_dhcpid: SELECT h.host_id, h.dhcp_identifier, h.dhcp_identifier_type,   h.dhcp4_subnet_id, h.dhcp6_subnet_id, h.ipv4_address, h.hostname,   h.dhcp4_client_classes, h.dhcp6_client_classes, h.user_context,   h.dhcp4_next_server, h.dhcp4_server_hostname,   h.dhcp4_boot_file_name, h.auth_key,   o.option_id, o.code, o.value, o.formatted_value, o.space,   o.persistent, o.cancelled, o.user_context, o.client_classes FROM hosts AS h LEFT JOIN dhcp4_options AS o ON h.host_id = o.host_id WHERE h.dhcp4_subnet_id = $1 AND h.dhcp_identifier_type = $2   AND h.dhcp_identifier = $3 ORDER BY h.host_id, o.option_id
>>
>> $2 parameter (h.dhcp_identifier_type) is tested by lea only for 0,2,3 - flex_id is 4..
>>
>> Am I missing something else ?
>>
> --
> 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 at lists.isc.org