[Kea-users] SQL host reservations (Kea 1.3.0)

[Owen Dunn]

On Wed, 17 Jan 2018, Tobias - wrote:

> I've set up mariadb to host Kea's leases. I'm trying to figure out how to make reservations through the 'hosts' table.
>
> I do not understand how the IP address in 'ipv4_address' is encoded. I've looked in the 'lease4' table but I don't see the pattern.
>
> How is an address encoded as an 'int(10) unsigned'?

It's just 16777216*octet1 + 65536*octet2 + 256*octet3 + octet4.

I found https://kea.isc.org/wiki/HostReservationsHowTo invaluable for 
backending on databases.

Owen