[Kea-users] Leases storage format

[Klaus Steden]

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 <admin at mailsrv.globnet.md> 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
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20210914/81b7797c/attachment.htm>