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]
https://lists.isc.org/mailman/listinfo/kea-users

Reply via email to