<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Brendan,<br>
Kea will not be able to grant leases if it cannot contact its
lease database.<br>
Your configuration file and logging would be helpful.<br>
<br>
Also, setting the "authoritative" to true will force Kea to
always reject INIT-REBOOT requests from unknown clients<br>
/Peter<br>
</p>
<div class="moz-cite-prefix">On 16/04/2024 18.16, Brendan Kearney
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:d29a3d18-c023-47cd-bdec-bce39fcac01e@gmail.com">
<p><font size="4">list members,</font></p>
<p><font size="4">i am trying to migrate to Kea and have 2 HA+MT
instances stood up. when i start relaying dhcp requests to
Kea, i get bunch of failed attempts to obtain leases on the
clients, which i believe is due to the clients not having
active leases from Kea. i am wondering if there is a means to
have the clients get new assigned leases without having to
jump through hoops like reboots.</font></p>
<p><font size="4">as an aside, i also find the below error in my
logs, which seems to indicate a malformed database query.<br>
</font></p>
<p><font size="4">ERROR [kea-dhcp4.database.139901550986944]
DATABASE_MYSQL_FATAL_ERROR Unrecoverable MySQL error occurred:
unable to execute for <SELECT address, hwaddr, client_id,
valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev,
hostname, state, user_context, relay_id, remote_id, pool_id
FROM lease4 WHERE client_id = ?>, reason: Lost connection
to server during query (error code: 2013).<br>
</font></p>
<p><font size="4">the select, if pasted into any mariadb client,
fails since the "?" is not proper syntax. i dont know if the
behavior i am seeing with the clients not getting new leases
and the database error above are related or if there are a
couple of issues to be worked through.</font></p>
<p><font size="4">what info should i provide, to understand where
i have issues to address? i am running Kea 2.4.0 on fedora
38.</font></p>
<p><font size="4">thanks in advance,</font></p>
<p><font size="4">brendan</font></p>
</blockquote>
<pre class="moz-signature" cols="72">--
Peter Davies
Support Engineer
Internet Systems Corporation
</pre>
</body>
</html>