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 <[email protected]> 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 <[email protected]> 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. > [email protected] -- 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. [email protected]
