<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello! I have a problem where host reservations are not pulled
from the database.</p>
<p>This is how I installed Kea and setup mysql:</p>
<p> using this guide: <a class="moz-txt-link-freetext" href="https://kea.isc.org/wiki/SystemNotesOpenBSD">https://kea.isc.org/wiki/SystemNotesOpenBSD</a></p>
<p>then added to kea.conf and created database with tables:</p>
<p>[...]"subnet": "10.0.0.0/24",<br>
"id": 1,[...]</p>
<p> "lease-database": {<br>
"type": "mysql",<br>
"name": "kea",<br>
"host" : "",<br>
"user": "kea",<br>
"password": "kea"<br>
},<br>
<br>
"hosts-database": {<br>
"type": "mysql",<br>
"name": "kea",<br>
"host" : "",<br>
"user": "kea",<br>
"password": "kea"<br>
},<br>
</p>
<p>It connects and adds leases to database: <br>
</p>
<p>2016-08-07 12:56:18.838 INFO [kea-dhcp4.dhcpsrv/21651]
DHCPSRV_MYSQL_DB opening MySQL lease database: name=kea
password=***** type=mysql universe=4 user=kea<br>
2016-08-07 12:56:18.844 INFO [kea-dhcp4.dhcpsrv/21651]
DHCPSRV_MYSQL_HOST_DB opening MySQL hosts database: name=kea
password=***** type=mysql universe=4 user=kea</p>
<p>Added reservation:<br>
</p>
<pre class="wiki" style="border: 1px solid rgb(215, 215, 215); box-shadow: rgb(238, 238, 238) 0px 0px 1em; border-radius: 0.3em; margin: 1em 1.75em; padding: 0.25em; overflow: auto; color: rgb(0, 0, 0); font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background: rgb(247, 247, 247);">START TRANSACTION;
SET @ipv4_reservation='10.0.0.150';
SET @hostname = 'test';
SET @identifier_type='hw-address';
SET @identifier_value='66:38:32:38:38:38';
SET @dhcp4_subnet_id=1;
INSERT INTO hosts (dhcp_identifier,
dhcp_identifier_type,
dhcp4_subnet_id,
ipv4_address,
hostname)
VALUES (UNHEX(REPLACE(@identifier_value, ':', '')),
(SELECT type FROM host_identifier_type WHERE name=@identifier_type),
@dhcp4_subnet_id,
INET_ATON(@ipv4_reservation),
@hostname);
COMMIT;</pre>
Client still uses old lease until reservation is added in kea.conf.<br>
<br>
Is there something I'm missing? Thanks!<br>
</body>
</html>