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:[email protected]] On Behalf Of Egor GRIJUC Sent: Wednesday, 15 September 2021 09:58 To: Klaus Steden; [email protected] 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:[email protected]] On Behalf Of Klaus Steden Sent: Wednesday, 15 September 2021 01:52 To: [email protected] 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 <[email protected]<mailto:[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]<mailto:[email protected]> 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 [email protected] https://lists.isc.org/mailman/listinfo/kea-users
