The hwaddr field in MySQL is stored as hexadecimal. You want to use HEX/UNHEX to convert between ASCII presentation and hex encoding.
cheers, Klaus On Tue, Sep 7, 2021 at 4:19 AM <[email protected]> wrote: > 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? > _______________________________________________ > 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 > [email protected] > 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 [email protected] https://lists.isc.org/mailman/listinfo/kea-users
