<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p><br>
</p>
Anyone can help on expression of flex-id in mysql?<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> agiimaa.b<br>
<b>Sent:</b> Wednesday, December 4, 2019 2:46 PM<br>
<b>To:</b> kea-users@lists.isc.org<br>
<b>Subject:</b> Re: [Kea-users] using flex_id for combined reservation identifiers</font>
<div> </div>
</div>
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<p>Hello,</p>
<p><br>
</p>
<p>Now i'm trying to configure mysql host reservation. But no luck. Where could be my mistake?</p>
<p>Here is my configurations:</p>
<p><br>
</p>
<p></p>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px">
<div><i><span style="font-size:11pt"> "host-reservation-identifiers": [ "circuit-id", "hw-address", "flex-id" ],</span></i></div>
<div><i><span style="font-size:11pt"> "reservation-mode": "global",</span></i></div>
<div><i><br>
</i></div>
<div><i><span style="font-size:11pt"> "hosts-database": {</span></i></div>
<div><i><span style="font-size:11pt"> "type": "mysql",</span></i></div>
<div><i><span style="font-size:11pt"> "name": "kea",</span></i></div>
<div><i><span style="font-size:11pt"> "host": "",</span></i></div>
<div><i><span style="font-size:11pt"> "user": "my</span><span style="font-size:11pt">user</span><span style="font-size:11pt">",</span></i></div>
<div><i><span style="font-size:11pt"> "password": "mypass"</span></i></div>
<div><i><span style="font-size:11pt"> },</span></i></div>
<div><i><br>
</i></div>
<div><i><span style="font-size:11pt"> "hooks-libraries": [</span></i></div>
<div><i><span style="font-size:11pt"> {</span></i></div>
<div><i><span style="font-size:11pt"> "library": "/usr/local/lib/hooks/libdhcp_flex_id.so",</span></i></div>
<div><i><span style="font-size:11pt"> "parameters": {</span></i></div>
<div><i><span style="font-size:11pt"> "identifier-expression": "concat(relay4[1].hex, hexstring(pkt4.mac, ''))"</span></i></div>
<div><i><span style="font-size:11pt"> }</span></i></div>
<div><i><span style="font-size:11pt"> }</span></i></div>
<div><i><span style="font-size:11pt"> ], </span></i></div>
</blockquote>
<br>
<p></p>
MySQL insert statement:
<div><br>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px">
<div>
<div><i><span style="font-size:10pt">START TRANSACTION;</span></i></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @ipv4_reservation='10.</span><span style="font-size:10pt">10.10.10</span><span style="font-size:10pt">;</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @identifier_type='flex-id';</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @identifier_value='4857544315C6342Fd4cff9ffddbb';</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @dhcp4_subnet_id=1;</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @next_server='1</span><span style="font-size:10pt">0.10.10.1</span><span style="font-size:10pt">';</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @server_hostname='kea.test.com';</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">SET @boot_file_name='bootfile.efi';</span></i></span></div>
</div>
<div>
<div><i><br>
</i></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">INSERT INTO hosts (dhcp_identifier,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> dhcp_identifier_type,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> dhcp4_subnet_id,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> ipv4_address,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> dhcp4_next_server,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> dhcp4_server_hostname,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> dhcp4_boot_file_name)</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">VALUES (UNHEX(REPLACE(@identifier_value, ':', '')),</span></i></span></div>
</div>
<div>
<div><i><span style="white-space:pre; font-size:10pt"></span><span style="font-size:10pt">(SELECT type FROM host_identifier_type WHERE name=@identifier_type),</span></i></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> @dhcp4_subnet_id,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> INET_ATON(@ipv4_reservation),</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> INET_ATON(@next_server),</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> @server_hostname,</span></i></span></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt"> @boot_file_name);</span></i></span></div>
</div>
<div>
<div><i><br>
</i></div>
</div>
<div>
<div><span style="font-size:11pt"><i><span style="font-size:10pt">COMMIT;</span></i></span></div>
</div>
</blockquote>
<div><br>
</div>
<div>Kea Log: </div>
<div><br>
</div>
</div>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px">
<div>
<div><span style="font-family:monospace; font-size:10pt">INFO [kea-dhcp4.flex-id-hooks/17331] FLEX_ID_EXPRESSION_EVALUATED Expression evaluated for packet to "4857544315C6342Fd4cff9ffddbb" (size: 28)
</span></div>
</div>
<div>
<div><span style="font-family:monospace; font-size:10pt">WARN [kea-dhcp4.alloc-engine/17331] ALLOC_ENGINE_V4_ALLOC_FAIL [hwtype=1 d4:cf:f9:ff:dd:bb], cid=[01:d4:cf:f9:ff:dd:bb], tid=0x55455494: failed to al</span></div>
</div>
<div>
<div><span style="font-family:monospace; font-size:10pt">locate an IPv4 address after 0 attempt(s)</span></div>
</div>
</blockquote>
<div>
<div><br>
BR,</div>
<div>Agiimaa B.<br>
<div style="color:rgb(0,0,0)">
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Kea-users <kea-users-bounces@lists.isc.org> on behalf of TroYy <modo555@gmail.com><br>
<b>Sent:</b> Thursday, November 21, 2019 5:51 PM<br>
<b>To:</b> kea-users@lists.isc.org<br>
<b>Subject:</b> Re: [Kea-users] using flex_id for combined reservation identifiers</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt">
<div class="PlainText">If your hook evaluated your expression as "4857544394969D21d4:cf:f9:ff:dd:bb"<br>
then try to add reservation something like this<br>
<br>
"reservations": [<br>
{<br>
"flex-id": "4857544394969D21d4:cf:f9:ff:dd:bb",<br>
"ip-address": "10.215.160.101"<br>
} <br>
<br>
Also check if your flex-id identifier is enabled for quering:<br>
<br>
"host-reservation-identifiers": ["duid", "*flex-id*"],<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://kea-users.7364.n8.nabble.com/" id="LPlnk899768" previewremoved="true">
http://kea-users.7364.n8.nabble.com/</a>
<div id="LPBorder_GT_15754415100400.4020058946391676" style="margin-bottom:20px; overflow:auto; width:100%; text-indent:0px">
<table id="LPContainer_15754415100320.38177405063700043" cellspacing="0" style="width:90%; background-color:rgb(255,255,255); overflow:auto; padding-top:20px; padding-bottom:20px; margin-top:20px; border-top:1px dotted rgb(200,200,200); border-bottom:1px dotted rgb(200,200,200)">
<tbody>
<tr valign="top" style="border-spacing:0px">
<td id="TextCell_15754415100360.8111029803008687" colspan="2" style="vertical-align: top; padding: 0px; display: table-cell; position: relative;">
<div id="LPRemovePreviewContainer_15754415100360.9685826720285593"></div>
<div id="LPTitle_15754415100360.25313585652639636" style="top:0px; color:rgb(47,144,196); font-weight:400; font-size:21px; font-family:wf_segoe-ui_light,"Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; line-height:21px">
<a id="LPUrlAnchor_15754415100370.6222750136907649" href="http://kea-users.7364.n8.nabble.com/" target="_blank" style="text-decoration:none">Kea Users | Mailing List Archive</a></div>
<div id="LPMetadata_15754415100380.7312161923069431" style="margin:10px 0px 16px; color:rgb(102,102,102); font-weight:400; font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size:14px; line-height:14px">
kea-users.7364.n8.nabble.com</div>
<div id="LPDescription_15754415100390.0038201390053240747" style="display:block; color:rgb(102,102,102); font-weight:400; font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size:14px; line-height:20px; max-height:100px; overflow:hidden">
Kea Users forum and mailing list archive. Kea is an open source project from Internet Systems Consortium (ISC). This list is for discussion about installing and managing the Kea software suite for...</div>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
_______________________________________________<br>
Kea-users mailing list<br>
Kea-users@lists.isc.org<br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" id="LPlnk363615" previewremoved="true">https://lists.isc.org/mailman/listinfo/kea-users</a><br>
</div>
</span></font></div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size: 11px;">The information transmitted, including
attachments, is intended only for the person(s) or entity to which it is
addressed and may contain confidential and/or privileged material. Any review,
re-transmission, dissemination or other use of, or taking of any action in
reliance upon this information by persons or entities other than the intended
recipient is prohibited. If you received this in error, please contact the
sender and destroy any copies of this information.<br><br>-------------------------------------------------------------------------------------------------------------------------------------<br></span></p>
<p class="MsoNormal"><span style="font-size: 11px;">Энэхүү и-мэйл болон хавсралт дахь мэдээлэл нь тодорхой хүнд хаяглагдсан бөгөөд нууцлалтай мэдээлэл агуулж байж болзошгүй тул бусдад дамжуулах, олон нийтэд тараах, өөр бусад зорилгоор ашиглахыг хориглоно. Хэрэв та уг и-мэйлийг санамсаргүй байдлаар хүлээн авсан бол и-мэйл илгээгчид мэдэгдэж, хуулбар баримт үлдээлгүй устгана уу.</span></p></body>
</html>