[Kea-users] Leases storage format

[perl-list]

I believe:

select hex(hwaddr) from lease4;

will get you an ASCII mac address.  Someone correct me if I'm wrong.

----- Original Message -----
> From: "egor grijuc" <egor.grijuc at orange.com>
> To: "Klaus Steden" <klausfiend at gmail.com>, admin at mailsrv.globnet.md
> Cc: "kea-users" <kea-users at lists.isc.org>
> Sent: Wednesday, September 15, 2021 3:02:00 AM
> Subject: Re: [Kea-users] Leases storage format

> Same problem with lease6 table.

> The sytax of create table lease4

> CREATE TABLE `lease4` (

> `address` int(10) unsigned NOT NULL,

> `hwaddr` varbinary(20) DEFAULT NULL,

> `client_id` varbinary(128) DEFAULT NULL,

> `valid_lifetime` int(10) unsigned DEFAULT NULL,

> `expire` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
> CURRENT_TIMESTAMP,

> `subnet_id` int(10) unsigned DEFAULT NULL,

> `fqdn_fwd` tinyint(1) DEFAULT NULL,

> `fqdn_rev` tinyint(1) DEFAULT NULL,

> `hostname` varchar(255) DEFAULT NULL,

> `state` int(10) unsigned DEFAULT '0',

> `user_context` text,

> `mycol` varchar(254) DEFAULT NULL,

> PRIMARY KEY (`address`),

> KEY `lease4_by_hwaddr_subnet_id` (`hwaddr`,`subnet_id`),

> KEY `lease4_by_client_id_subnet_id` (`client_id`,`subnet_id`),

> KEY `lease4_by_state_expire` (`state`,`expire`),

> KEY `lease4_by_subnet_id` (`subnet_id`),

> KEY `lease4_by_hostname` (`hostname`),

> CONSTRAINT `fk_lease4_state` FOREIGN KEY (`state`) REFERENCES `lease_state`
> (`state`)

> ) ENGINE=InnoDB DEFAULT CHARSET=latin1

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

> 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 < [ mailto:admin at mailsrv.globnet.md |
> 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/ | https://www.isc.org/contact/ ]
>> for more information.

>> To unsubscribe visit [ https://lists.isc.org/mailman/listinfo/kea-users |
>> https://lists.isc.org/mailman/listinfo/kea-users ] .

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

> 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.

> _______________________________________________
> 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