You can also use hooks and get all the lease data when lease is in select, renew, release, decline, expire and recover state.

More about that you can see here:
http://git.kea.isc.org/~tester/kea/doxygen/de/df3/dhcpv4Hooks.html

Igor

On 12/27/2016 11:49 AM, Nandan Adhikari wrote:
Hi Igor, I am trying to have similar kind of functionality which OMAPI gives for ISC DHCP.

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.

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.


On Tue, Dec 27, 2016 at 3:50 PM, Igor Smitran <[email protected] <mailto:[email protected]>> wrote:

    Galera MySQL is MySQL cluster. Kea already has mysql support and
    already does all the work you mentioned.
    Why would you write another API for functionality that is already
    implemented?


    On 12/27/2016 08:47 AM, Nandan Adhikari wrote:
    Hi,

    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:

    1) lease lookup by mac/ip
    2) reservation lookup by mac/ip
    3) add new lease
    4) delete an existing lease

    Here is what I am thinking for above APIs:

    1) lease lookup by mac: (SELECT INET_NTOA(address) as address,
    HEX(hwaddr) as hwaddr, hostname from lease4 where HEX(hwaddr)=
    ?", macid)

    If you could advice me on how to write such API's to do basic
    management.

-- Thanks & warm wishes,
    Nandan Adhikari


    _______________________________________________
    Kea-users mailing list
    [email protected] <mailto:[email protected]>
    https://lists.isc.org/mailman/listinfo/kea-users
    <https://lists.isc.org/mailman/listinfo/kea-users>

    _______________________________________________ Kea-users mailing
    list [email protected] <mailto:[email protected]>
    https://lists.isc.org/mailman/listinfo/kea-users
<https://lists.isc.org/mailman/listinfo/kea-users>
--
Thanks & warm wishes, Nandan Adhikari

_______________________________________________
Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users

Reply via email to