[Kea-users] Leases storage format

admin at mailsrv.globnet.md admin at mailsrv.globnet.md
Tue Sep 7 11:22:47 UTC 2021


Hello. 
I have 1 question and one issue with storing leases information in mysql database in kea. 

The issue is that hwaddr field and client_id field are in "strange" format. 
I enabled query log in mysql and in logs i found the following query from kea 

UPDATE lease4 SET address = 1682022402, hwaddr = '`▒\\', client_id = '`▒\\', valid_lifetime = 21600, expire = '2021-09-07 20:12:16', subnet_id = 2, fqdn_fwd = 0, fqdn_rev = 0, hostname = 'hg8247u', state = 0, user_context = NULL WHERE address = 1682022402 AND expire = '2021-09-07 18:52:56' 

So you can see " hwaddr = '`▒\\', client_id = '`▒\\' " 
Does someone faced same problem? How to fix it? 

Second part is question. 
Lease4 table have several fields. The question: is it possible to store additional information, like option 82, suboption 9? 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20210907/7e35a37e/attachment.htm>


More information about the Kea-users mailing list