<div dir="ltr"><br><div>This should all be possible with standard SQL queries, e.g.,</div><div><br></div><div>1. select hex(hwaddr), subnet_id, inet_ntoa(address), expire from lease4 where <condition>;</div><div>2. select hex(hwaddr), subnet_id, inet_ntoa(address), expire from hosts where <condition>;</div><div>3. you should probably let Kea insert new lease information for you, since that's what it's supposed to do</div><div>4. see #3</div><div><br></div><div>This is all pretty much covered in the documentation. see <a href="http://kea.isc.org/wiki/HostReservationsHowTo">http://kea.isc.org/wiki/HostReservationsHowTo</a>, <a href="http://kea.isc.org/docs/kea-guide.html#idp49015504">http://kea.isc.org/docs/kea-guide.html#idp49015504</a> etc.</div><div><br></div><div>Your API just needs to understand standard SQL syntax in order to insert reservations and/or query existing lease information.</div><div><br></div><div>cheers,</div><div>Klaus</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 26, 2016 at 11:47 PM, Nandan Adhikari <span dir="ltr"><<a href="mailto:nandan.adhikari007@gmail.com" target="_blank">nandan.adhikari007@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">Hi,</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">I am writing a service which assigns IP addresses to newly provisioned VMs or physical machines from a pre-defined IP pool. I want to use KEA with Galera MySQL backend. The problem I am facing is that there is no docs/info regarding the Table schema details or SQL queries to do common tasks like:</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">1) lease lookup by mac/ip</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">2) reservation lookup by mac/ip</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">3) add new lease</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">4) delete an existing lease</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">Here is what I am thinking for above APIs:</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">1) lease lookup by mac: (SELECT INET_NTOA(address) as address, HEX(hwaddr) as hwaddr, hostname from lease4 where HEX(hwaddr)= ?", macid)</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">If you could advice me on how to write such API's to do basic management.</div><span class="HOEnZb"><font color="#888888"><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br></div>-- <br><div class="m_-7471624178491253085gmail_signature">Thanks & warm wishes,<br>Nandan Adhikari</div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Kea-users mailing list<br>
<a href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/<wbr>listinfo/kea-users</a><br>
<br></blockquote></div><br></div>