Hello, I have a Rocky 9 Linux setup with Kea 2.6.1 with the latest Mariadb 11 that is giving me the following error below.
I first converted a lease file from ISC DHCP and then used the kea-admin tool to upload the csv to the Kea database. I didn't get any errors during any of the processes. Kea started up just fine and the error was received when one of the MAC Addresses from a DHCP lease that was converted. 2024-11-05 18:59:52.714 ERROR [kea-dhcp4.alloc-engine/6547.139957880890944] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 XX:XX:XX:XX:XX:XX], cid=[no info], tid=0xdda92c: error during attempt to allocate an IPv4 address: unable to execute for <UPDATE lease4 SET address = ?, hwaddr = ?, client_id = ?, valid_lifetime = ?, expire = ?, subnet_id = ?, fqdn_fwd = ?, fqdn_rev = ?, hostname = ?, state = ?, user_context = ?, relay_id = ?, remote_id = ?, pool_id = ? WHERE address = ? AND expire = ?>, reason: Unexpected end of JSON text in argument 1 to function 'json_extract' (error code 4037) And to add to this, I can change Kea to use the csv lease file as the memfile and the MAC Addresses that were converted have no problem renewing the existing IP Address. That same csv lease file is what I used to upload the leases to Mariadb. Thanks, JT
-- 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@lists.isc.org https://lists.isc.org/mailman/listinfo/kea-users
