<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Good call. It is stored the same way, thanks! -Travis<br>
    </p>
    <pre class="moz-signature" cols="72">
</pre>
    <div class="moz-cite-prefix">On 2/7/2022 11:20 AM, Frey, Rick E
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:DM5PR05MB345158A4D3D9A8AA1410080B882C9@DM5PR05MB3451.namprd05.prod.outlook.com">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <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:</p>
        <p class="MsoNormal"><a
            href="https://datatracker.ietf.org/doc/html/rfc3046#page-8"
            moz-do-not-send="true" class="moz-txt-link-freetext">https://datatracker.ietf.org/doc/html/rfc3046#page-8</a></p>
        <p class="MsoNormal"> </p>
        <p class="MsoNormal"> </p>
        <p class="MsoNormal"> </p>
        <div>
          <p class="MsoNormal"><b><span>From:
              </span></b><span>Kea-users
              <a class="moz-txt-link-rfc2396E" href="mailto:kea-users-bounces@lists.isc.org"><kea-users-bounces@lists.isc.org></a> on behalf of
              Travis C - Surf BB <a class="moz-txt-link-rfc2396E" href="mailto:tchesna@surfbroadband.com"><tchesna@surfbroadband.com></a><br>
              <b>Date: </b>Monday, February 7, 2022 at 7:32 AM<br>
              <b>To: </b><a class="moz-txt-link-abbreviated" href="mailto:kea-users@lists.isc.org">kea-users@lists.isc.org</a>
              <a class="moz-txt-link-rfc2396E" href="mailto:kea-users@lists.isc.org"><kea-users@lists.isc.org></a><br>
              <b>Subject: </b>[Kea-users] Option 82 delimiter</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&amp;data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=tTni89SKp8RGcJW3Qf9lbrFtarZRiO7q%2FsffK5Blg4k%3D&amp;reserved=0"
              moz-do-not-send="true">
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&amp;data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=tTni89SKp8RGcJW3Qf9lbrFtarZRiO7q%2FsffK5Blg4k%3D&amp;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&amp;data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&amp;reserved=0"
              moz-do-not-send="true">
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&amp;reserved=0</a>.<br>
            <br>
            Kea-users mailing list<br>
            <a class="moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a><br>
            <a
href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&amp;reserved=0"
              moz-do-not-send="true">https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Crick.frey%40windstream.com%7C220d864b33c94dcdbbdd08d9ea3e1c25%7C2567b4c1b0ed40f5aee358d7c5f3e2b2%7C0%7C0%7C637798375501489433%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=9S3MqhlYv5eTaGs4W2ke%2FfMdvgwJ3CXw%2FiQgEGmZGkE%3D&amp;reserved=0</a></p>
        </div>
      </div>
      <br>
      <p>
        Sensitivity: Internal<br>
      </p>
    </blockquote>
  </body>
</html>