[Kea-users] Leases storage format

[egor.grijuc at orange.com]

Yes, but in mysql log I see query from kea in format:
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'


The fields hwaddr = '`▒\\', client_id = '`▒\\'
It it normal? How to convert this to mac address?

From: Kea-users [mailto:kea-users-bounces at lists.isc.org] On Behalf Of Klaus Steden
Sent: Wednesday, 15 September 2021 01:52
To: admin at mailsrv.globnet.md
Cc: kea-users
Subject: Re: [Kea-users] Leases storage format


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<mailto: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<mailto:Kea-users at lists.isc.org>
https://lists.isc.org/mailman/listinfo/kea-users

_________________________________________________________________________________________________________________________

Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci.

This message and its attachments may contain confidential or privileged information that may be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete this message and its attachments.
As emails may be altered, Orange is not liable for messages that have been modified, changed or falsified.
Thank you.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20210915/b62b3025/attachment.htm>