<div dir="ltr"><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:small;color:rgb(51,0,153)">Hi Igor, I am trying to have similar kind of functionality which OMAPI gives for ISC DHCP.</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)">Its because we have existing setup in ISC DHCP, where we manage the DHCP using OMAPI which gives the APIs like 'host_add' or 'host_delete'. I was trying to have something similar to it. The IP/subnet pool is being managed by another system here, and therefore what is needed is to somehow insert a lease when a VM/instance comes up and delete that lease when VM is destroyed.</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)">Thanks Klaus for the reply. I was actually trying to manage leases, which I think better would be to use host reservation. I will give it a try.</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_extra"><br><div class="gmail_quote">On Tue, Dec 27, 2016 at 3:50 PM, Igor Smitran <span dir="ltr"><<a href="mailto:sigor@blic.net" target="_blank">sigor@blic.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<div class="gmail-m_-1100774962198917641moz-cite-prefix">Galera MySQL is MySQL cluster. Kea
already has mysql support and already does all the work you
mentioned.<br>
Why would you write another API for functionality that is already
implemented?<div><div class="gmail-h5"><br>
<br>
On 12/27/2016 08:47 AM, Nandan Adhikari wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div class="gmail-h5">
<div dir="ltr">
<div>Hi,</div>
<div><br>
</div>
<div>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><br>
</div>
<div>1)
lease lookup by mac/ip</div>
<div>2)
reservation lookup by mac/ip</div>
<div>3)
add new lease</div>
<div>4)
delete an existing lease</div>
<div><br>
</div>
<div>Here
is what I am thinking for above APIs:</div>
<div><br>
</div>
<div>1)
lease lookup by mac: (SELECT INET_NTOA(address) as address,
HEX(hwaddr) as hwaddr, hostname from lease4 where HEX(hwaddr)=
?", macid)</div>
<div><br>
</div>
<div>If
you could advice me on how to write such API's to do basic
management.</div>
<div><br>
</div>
-- <br>
<div class="gmail-m_-1100774962198917641gmail_signature">Thanks & warm wishes,<br>
Nandan Adhikari</div>
</div>
<br>
<fieldset class="gmail-m_-1100774962198917641mimeAttachmentHeader"></fieldset>
<br>
</div></div><span class="gmail-"><pre>______________________________<wbr>_________________
Kea-users mailing list
<a class="gmail-m_-1100774962198917641moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a>
<a class="gmail-m_-1100774962198917641moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users" target="_blank">https://lists.isc.org/mailman/<wbr>listinfo/kea-users</a>
</pre>
</span></blockquote>
<p><br>
</p>
</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><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Thanks & warm wishes,<br>Nandan Adhikari</div>
</div></div>