[Kea-users] Kea 2.6.1 Mariadb Issue

[JT ISC]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20241105/1b82b45b/attachment.htm>