<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hello.<br data-mce-bogus="1"></div><div>I have 1 question and one issue with storing leases information in mysql database in kea.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>The issue is that <!--StartFragment-->hwaddr <!--EndFragment--> field and <!--StartFragment-->client_id <!--EndFragment--> field are in "strange" format.<br data-mce-bogus="1"></div><div>I enabled query log in mysql and in logs i found the following query from kea<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>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'<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>So you can see " <!--StartFragment-->hwaddr = '`▒\\', client_id = '`▒\\'<!--EndFragment--> "<br data-mce-bogus="1"></div><div>Does someone faced same problem? How to fix it?<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Second part is question.<br data-mce-bogus="1"></div><div>Lease4 table have several fields. The question: is it possible to store additional information, like option 82, suboption 9?<br data-mce-bogus="1"></div></div></body></html>