<div dir="ltr"><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:small;color:#330099">Thanks a lot for the suggestions.</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:small;color:#330099"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:small;color:#330099">What I am specifically looking for is a way to modify/delete existing host reservations or from lease tables. As Klaus suggested to use KEA itself for insertion into lease tables, so I was checking out host reservation section of the guide. But I am unable to find any table where I can see the current reservations. </div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:small;color:#330099"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:small;color:#330099">Can someone suggest how we can modify current host reservations instead of modifying the .conf file and doing restart?</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:small;color:#330099"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 27, 2016 at 8:39 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div class="m_724975356069727386moz-cite-prefix">You can also use hooks and get all the
lease data when lease is in select, renew, release, decline,
expire and recover state.<br>
<br>
More about that you can see here:<br>
<a class="m_724975356069727386moz-txt-link-freetext" href="http://git.kea.isc.org/~tester/kea/doxygen/de/df3/dhcpv4Hooks.html" target="_blank">http://git.kea.isc.org/~<wbr>tester/kea/doxygen/de/df3/<wbr>dhcpv4Hooks.html</a><span class="HOEnZb"><font color="#888888"><br>
<br>
Igor</font></span><div><div class="h5"><br>
<br>
On 12/27/2016 11:49 AM, Nandan Adhikari wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default">Hi
Igor, I am trying to have similar kind of functionality which
OMAPI gives for ISC DHCP.</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">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"><br>
</div>
<div class="gmail_default">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"><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="m_724975356069727386gmail-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="m_724975356069727386gmail-h5"><br>
<br>
On 12/27/2016 08:47 AM, Nandan Adhikari wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="m_724975356069727386gmail-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="m_724975356069727386gmail-m_-1100774962198917641gmail_signature">Thanks
& warm wishes,<br>
Nandan Adhikari</div>
</div>
<br>
<fieldset class="m_724975356069727386gmail-m_-1100774962198917641mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<span class="m_724975356069727386gmail-">
<pre>______________________________<wbr>_________________
Kea-users mailing list
<a class="m_724975356069727386gmail-m_-1100774962198917641moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a>
<a class="m_724975356069727386gmail-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>
</p>
</div>
______________________________<wbr>_________________
Kea-users mailing list
<a href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/<wbr>listinfo/kea-users</a>
</blockquote></div>
<div>
</div>--
<div class="m_724975356069727386gmail_signature">Thanks & warm wishes,
Nandan Adhikari</div>
</div></div>
</blockquote><p>
</p></div></div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Thanks & warm wishes,<br>Nandan Adhikari</div>
</div>