Hi JT, I think the only JSON content in the lease would be in user_context = ? I suspect that when it mentions argument 1 that it is not referring to hwaddr = ? Can you have a look at the content in user_context in your database? Perhaps the JSON is actually syntactically bad? This same content should be ending up in your lease csv, I think, for memfile ... perhaps you could compare the two? This might yield some clue.
Thank you, Darren Ankney On Tue, Nov 5, 2024 at 3:30 PM JT ISC <jtis...@gmail.com> wrote: > > 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 -- 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
