<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">I’m using memfile (CSV) for leases so not sure if format differs from SQL, but CSV format for user_context field is JSON with attribute name of “relay-agent-info” and the value is entire option 82 hex value as sent over wire. Assuming
SQL value is same, you could parse hex value into sub options 1 and 2 per RFC 3046:<o:p></o:p></p>
<p class="MsoNormal"><a href="https://datatracker.ietf.org/doc/html/rfc3046#page-8">https://datatracker.ietf.org/doc/html/rfc3046#page-8</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">Kea-users <kea-users-bounces@lists.isc.org> on behalf of Travis C - Surf BB <tchesna@surfbroadband.com><br>
<b>Date: </b>Monday, February 7, 2022 at 7:32 AM<br>
<b>To: </b>kea-users@lists.isc.org <kea-users@lists.isc.org><br>
<b>Subject: </b>[Kea-users] Option 82 delimiter<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal">CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.<br>
<br>
<br>
Is there a delimiter or a way to pull the sub-option 2 from option 82<br>
when it is stored in the user context through the store-extended-info<br>
flag? I am using sql for storing leases. So far I do not see a<br>
delimiter, I just see the two sub-options merged together and then stored.<br>
<br>
Does anyone have any ideas on a good way to store just the sub-option 2<br>
so it can be recalled? The end goal that I need is IP, hwaddr, and<br>
option82 suboption2. I cant definitively say that suboption 2 will be a<br>
mac address, or X amount of characters, otherwise it wouldnt be too<br>
difficult. I was thinking about using a script and writing into another<br>
table, but that feels sloppy to me and a good way for something to get<br>
missed or out of sync.<br>
<br>
Thanks, Travis<br>
<br>
--<br>
ISC funds the development of this software with paid support subscriptions. Contact us at
<a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=tTni89SKp8RGcJW3Qf9lbrFtarZRiO7q%2FsffK5Blg4k%3D&reserved=0">
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=tTni89SKp8RGcJW3Qf9lbrFtarZRiO7q%2FsffK5Blg4k%3D&reserved=0</a>
for more information.<br>
<br>
To unsubscribe visit <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&reserved=0">
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&reserved=0</a>.<br>
<br>
Kea-users mailing list<br>
Kea-users@lists.isc.org<br>
<a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&reserved=0">https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&reserved=0</a><o:p></o:p></p>
</div>
</div>
<br>
<p style="font-family:Calibri;font-size:8pt;color:#000000;margin:15pt;" align="Left">
Sensitivity: Internal<br>
</p>
</body>
</html>