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]
