<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="auto">Hi Owen!
<div dir="auto"><br>
</div>
<div dir="auto">Great! How could I have missed that? That's exactly what I've been looking for. I just didn't dig deep enough I guess.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Thank you!</div>
<div dir="auto">Tobias</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">Den 17 jan. 2018 17:33 skrev Owen Dunn <osd1000@cam.ac.uk>:<br type="attribution">
<blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><font size="2"><span style="font-size:11pt">
<div>On Wed, 17 Jan 2018, Tobias - wrote:<br>
<br>
> I've set up mariadb to host Kea's leases. I'm trying to figure out how to make reservations through the 'hosts' table.<br>
><br>
> 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.<br>
><br>
> How is an address encoded as an 'int(10) unsigned'?<br>
<br>
It's just 16777216*octet1 + 65536*octet2 + 256*octet3 + octet4.<br>
<br>
I found <a href="https://kea.isc.org/wiki/HostReservationsHowTo">https://kea.isc.org/wiki/HostReservationsHowTo</a> invaluable for
<br>
backending on databases.<br>
<br>
Owen<br>
</div>
</span></font></div>
</blockquote>
</div>
<br>
</div>
</body>
</html>