<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font size="4">Peter,</font></p>
<p><font size="4">thanks for the quick reply. please let me know if
there is more detail needed. i run Kea with ERROR level
logging, so if more verbose logs are needed, i would need to set
up some time to test and collect the logs, etc.<br>
</font></p>
<p><font size="4">the logs from the testing i did, as collected by
my syslog receiver:<br>
</font></p>
<p><font size="4">ReceivedAt DeviceReportedTime Facility
Priority FromHost Message SysLogTag processid<br>
2024-04-11 12:25:54 2024-04-11 12:25:54 3 6
server1 2024-04-11 12:25:54.414 INFO
[kea-dhcp4.dhcp4/840765.139709009588608] DHCP4_STARTING Kea
DHCPv4 server version 2.4.0 (stable) starting kea-dhcp4
840765<br>
2024-04-11 12:26:11 2024-04-11 12:26:11 3 6
server1 2024-04-11 12:26:11.238 INFO
[kea-dhcp-ddns.dctl/840800.140457414102528] DCTL_STARTING
DhcpDdns starting, pid: 840800, version: 2.4.0 (stable)
kea-dhcp-ddns 840800<br>
2024-04-11 12:26:29 2024-04-11 12:26:29 3 6
server1 2024-04-11 12:26:29.089 INFO
[kea-ctrl-agent.dctl/840831.139709242502656] DCTL_STARTING
Control-agent starting, pid: 840831, version: 2.4.0 (stable)
kea-ctrl-agent 840831<br>
2024-04-11 12:26:29 2024-04-11 12:26:29 16 3
server1 ERROR [kea-ctrl-agent.dctl.139709242502656]
DCTL_PARSER_FAIL : unable to setup TCP acceptor for listening to
the incoming HTTP requests: bind: Cannot assign requested
address [system:99] kea-ctrl-agent 840831<br>
2024-04-11 12:26:29 2024-04-11 12:26:29 3 6
server1 2024-04-11 12:26:29.091 FATAL
[kea-ctrl-agent.dctl/840831.139709242502656]
DCTL_CONFIG_FILE_LOAD_FAIL Control-agent reason: unable to setup
TCP acceptor for listening to the incoming HTTP requests: bind:
Cannot assign requested address [system:99] kea-ctrl-agent
840831<br>
2024-04-11 12:26:29 2024-04-11 12:26:29 3 6
server1 Service failed: Could Not load configuration file:
unable to setup TCP acceptor for listening to the incoming HTTP
requests: bind: Cannot assign requested address [system:99]
kea-ctrl-agent 840831<br>
2024-04-11 12:28:55 2024-04-11 12:28:55 3 6
server1 2024-04-11 12:28:55.893 INFO
[kea-ctrl-agent.dctl/841014.140210931731968] DCTL_STARTING
Control-agent starting, pid: 841014, version: 2.4.0 (stable)
kea-ctrl-agent 841014<br>
2024-04-11 12:28:55 2024-04-11 12:28:55 16 3
server1 ERROR [kea-ctrl-agent.dctl.140210931731968]
DCTL_PARSER_FAIL : unable to setup TCP acceptor for listening to
the incoming HTTP requests: bind: Cannot assign requested
address [system:99] kea-ctrl-agent 841014<br>
2024-04-11 12:28:55 2024-04-11 12:28:55 3 6
server1 2024-04-11 12:28:55.895 FATAL
[kea-ctrl-agent.dctl/841014.140210931731968]
DCTL_CONFIG_FILE_LOAD_FAIL Control-agent reason: unable to setup
TCP acceptor for listening to the incoming HTTP requests: bind:
Cannot assign requested address [system:99] kea-ctrl-agent
841014<br>
2024-04-11 12:28:55 2024-04-11 12:28:55 3 6
server1 Service failed: Could Not load configuration file:
unable to setup TCP acceptor for listening to the incoming HTTP
requests: bind: Cannot assign requested address [system:99]
kea-ctrl-agent 841014<br>
2024-04-11 12:29:08 2024-04-11 12:29:08 3 6
server1 2024-04-11 12:29:08.706 INFO
[kea-ctrl-agent.dctl/841029.139739550449152] DCTL_STARTING
Control-agent starting, pid: 841029, version: 2.4.0 (stable)
kea-ctrl-agent 841029<br>
2024-04-11 12:29:08 2024-04-11 12:29:08 16 3
server1 ERROR [kea-ctrl-agent.dctl.139739550449152]
DCTL_PARSER_FAIL : unable to setup TCP acceptor for listening to
the incoming HTTP requests: bind: Cannot assign requested
address [system:99] kea-ctrl-agent 841029<br>
2024-04-11 12:29:08 2024-04-11 12:29:08 3 6
server1 2024-04-11 12:29:08.708 FATAL
[kea-ctrl-agent.dctl/841029.139739550449152]
DCTL_CONFIG_FILE_LOAD_FAIL Control-agent reason: unable to setup
TCP acceptor for listening to the incoming HTTP requests: bind:
Cannot assign requested address [system:99] kea-ctrl-agent
841029<br>
2024-04-11 12:29:08 2024-04-11 12:29:08 3 6
server1 Service failed: Could Not load configuration file:
unable to setup TCP acceptor for listening to the incoming HTTP
requests: bind: Cannot assign requested address [system:99]
kea-ctrl-agent 841029<br>
2024-04-11 12:29:38 2024-04-11 12:29:38 3 6
server1 2024-04-11 12:29:38.806 INFO
[kea-ctrl-agent.dctl/841082.139974102445568] DCTL_STARTING
Control-agent starting, pid: 841082, version: 2.4.0 (stable)
kea-ctrl-agent 841082<br>
2024-04-11 13:06:55 2024-04-11 13:06:55 3 6
server3 2024-04-11 13:06:55.085 INFO
[kea-dhcp4.dhcp4/1650403.139635850383744] DHCP4_STARTING Kea
DHCPv4 server version 2.4.0 (stable) starting kea-dhcp4
1650403<br>
2024-04-11 13:07:25 2024-04-11 13:07:25 3 6
server1 2024-04-11 13:07:25.245 INFO
[kea-dhcp4.dhcp4/845781.140527526515072] DHCP4_STARTING Kea
DHCPv4 server version 2.4.0 (stable) starting kea-dhcp4
845781<br>
2024-04-11 13:46:12 2024-04-11 13:46:12 3 6
server1 2024-04-11 13:46:12.231 INFO
[kea-ctrl-agent.dctl/849744.140067687546368] DCTL_STARTING
Control-agent starting, pid: 849744, version: 2.4.0 (stable)
kea-ctrl-agent 849744<br>
2024-04-11 13:46:12 2024-04-11 13:46:12 16 3
server1 ERROR [kea-ctrl-agent.dctl.140067687546368]
DCTL_PARSER_FAIL : unable to setup TCP acceptor for listening to
the incoming HTTP requests: bind: Address already in use
[system:98] kea-ctrl-agent 849744<br>
2024-04-11 13:46:12 2024-04-11 13:46:12 3 6
server1 2024-04-11 13:46:12.233 FATAL
[kea-ctrl-agent.dctl/849744.140067687546368]
DCTL_CONFIG_FILE_LOAD_FAIL Control-agent reason: unable to setup
TCP acceptor for listening to the incoming HTTP requests: bind:
Address already in use [system:98] kea-ctrl-agent 849744<br>
2024-04-11 13:46:12 2024-04-11 13:46:12 3 6
server1 Service failed: Could Not load configuration file:
unable to setup TCP acceptor for listening to the incoming HTTP
requests: bind: Address already in use [system:98]
kea-ctrl-agent 849744<br>
2024-04-11 13:46:27 2024-04-11 13:46:27 3 6
server1 2024-04-11 13:46:27.838 INFO
[kea-ctrl-agent.dctl/849765.139798843375104] DCTL_STARTING
Control-agent starting, pid: 849765, version: 2.4.0 (stable)
kea-ctrl-agent 849765<br>
2024-04-11 15:49:44 2024-04-11 15:49:44 3 6
server1 2024-04-11 15:49:44.283 INFO
[kea-dhcp4.dhcp4/862125.139657899897216] DHCP4_STARTING Kea
DHCPv4 server version 2.4.0 (stable) starting kea-dhcp4
862125<br>
2024-04-11 15:52:24 2024-04-11 15:52:24 3 6
server1 2024-04-11 15:52:24.400 INFO
[kea-dhcp4.dhcp4/862433.139901698826624] DHCP4_STARTING Kea
DHCPv4 server version 2.4.0 (stable) starting kea-dhcp4
862433<br>
2024-04-11 18:02:35 2024-04-11 18:02:35 16 3
server1 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). kea-dhcp4 862433<br>
</font></p>
<p><font size="4">the database is a 3 node multi-provider MariaDB
footprint, with Galera (block-level) replication, all behind an
HAProxy VIP. there are no issues with the database being
available. i tried a couple of times and had to adjust a couple
of IP/port combos because of the HA+MT config, plus the Stork
agent. thats why there are a couple "could not bind to address,
already in use" errors. once i got the Kea instances started,
no device would come up with a new lease.<br>
</font></p>
<p>
<style type="text/css"><font size="4">body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small }a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }comment { display:none; }</font></style></p>
<p><font size="4">my pretty printed config, from one of the Kea
servers:</font></p>
<p><font size="4">{<br>
"authoritative": true,<br>
"client-classes": [<br>
{<br>
"name": "proxied-clients"<br>
},<br>
{<br>
"name": "unproxied-clients"<br>
},<br>
{<br>
"name": "unknown-clients",<br>
"test": "not member('KNOWN')"<br>
},<br>
{<br>
"boot-file-name": "linux-install/pxelinux.0",<br>
"name": "pxe-bios",<br>
"server-hostname": "tftp.bpk2.com",<br>
"test": "option[93].hex == '0x0000'"<br>
},<br>
{<br>
"boot-file-name": "linux-install/efi/bootx64.efi",<br>
"name": "pxe-uefi",<br>
"server-hostname": "tftp.bpk2.com",<br>
"test": "(option[93].hex == '0x0007') or (option[93].hex
== 0x0009)"<br>
},<br>
{<br>
"name": "primary-proxied",<br>
"test": "member('proxied-clients') and
member('HA_server1')"<br>
},<br>
{<br>
"name": "secondary-proxied",<br>
"test": "member('proxied-clients') and
member('HA_server2')"<br>
},<br>
{<br>
"name": "primary-unproxied",<br>
"test": "member('unproxied-clients') and
member('HA_server1')"<br>
},<br>
{<br>
"name": "secondary-unproxied",<br>
"test": "member('unproxied-clients') and
member('HA_server2')"<br>
},<br>
{<br>
"name": "primary-unknown",<br>
"test": "member('unknown-clients') and
member('HA_server1')"<br>
},<br>
{<br>
"name": "secondary-unknown",<br>
"test": "member('unknown-clients') and
member('HA_server2')"<br>
},<br>
{<br>
"name": "primary-pxeboot",<br>
"test": "member('pxe-bios') or member('pxe-uefi') and
member('HA_server1')"<br>
},<br>
{<br>
"name": "secondary-pxeboot",<br>
"test": "member('pxe-bios') or member('pxe-uefi') and
member('HA_server2')"<br>
}<br>
],<br>
"config-control": {<br>
"config-databases": [<br>
{<br>
"host": "database.bpk2.com",<br>
"name": "kea",<br>
"password": "*****",<br>
"port": 3306,<br>
"type": "mysql",<br>
"user": "kea"<br>
}<br>
],<br>
"config-fetch-wait-time": 20<br>
},<br>
"control-socket": {<br>
"socket-name": "/tmp/kea4-ctrl-socket",<br>
"socket-type": "unix"<br>
},<br>
"ddns-generated-prefix": "server3",<br>
"ddns-override-client-update": true,<br>
"ddns-override-no-update": false,<br>
"ddns-qualifying-suffix": "bpk2.com",<br>
"ddns-replace-client-name": "always",<br>
"ddns-send-updates": true,<br>
"ddns-update-on-renew": true,<br>
"dhcp-ddns": {<br>
"enable-updates": true,<br>
"max-queue-size": 1024,<br>
"ncr-format": "JSON",<br>
"ncr-protocol": "UDP",<br>
"sender-ip": "",<br>
"sender-port": 0,<br>
"server-ip": "127.0.0.1",<br>
"server-port": 53001<br>
},<br>
"dhcp-queue-control": {<br>
"capacity": 256,<br>
"enable-queue": true,<br>
"queue-type": "kea-ring4"<br>
},<br>
"expired-leases-processing": {<br>
"flush-reclaimed-timer-wait-time": 25,<br>
"hold-reclaimed-time": 3600,<br>
"max-reclaim-leases": 100,<br>
"max-reclaim-time": 250,<br>
"reclaim-timer-wait-time": 10,<br>
"unwarned-reclaim-cycles": 5<br>
},<br>
"hooks-libraries": [<br>
{<br>
"library": "/usr/lib64/kea/hooks/libdhcp_lease_cmds.so"<br>
},<br>
{<br>
"library": "/usr/lib64/kea/hooks/libdhcp_mysql_cb.so"<br>
},<br>
{<br>
"library": "/usr/lib64/kea/hooks/libdhcp_stat_cmds.so"<br>
},<br>
{<br>
"library": "/usr/lib64/kea/hooks/libdhcp_ha.so",<br>
"parameters": {<br>
"high-availability": [<br>
{<br>
"delayed-updates-limit": 100,<br>
"heartbeat-delay": 10000,<br>
"max-ack-delay": 5000,<br>
"max-rejected-lease-updates": 10,<br>
"max-response-delay": 60000,<br>
"max-unacked-clients": 5,<br>
"mode": "load-balancing",<br>
"multi-threading": {<br>
"enable-multi-threading": true,<br>
"http-client-threads": 4,<br>
"http-dedicated-listener": true,<br>
"http-listener-threads": 4<br>
},<br>
"peers": [<br>
{<br>
"auto-failover": false,<br>
"name": "server1",<br>
"role": "secondary",<br>
"url": <a class="moz-txt-link-rfc2396E" href="http://192.168.88.1:8100/">"http://192.168.88.1:8100/"</a><br>
},<br>
{<br>
"auto-failover": true,<br>
"name": "server2",<br>
"role": "backup",<br>
"url": <a class="moz-txt-link-rfc2396E" href="http://192.168.88.2:8100/">"http://192.168.88.2:8100/"</a><br>
},<br>
{<br>
"auto-failover": true,<br>
"name": "server3",<br>
"role": "primary",<br>
"url": <a class="moz-txt-link-rfc2396E" href="http://192.168.88.8:8100/">"http://192.168.88.8:8100/"</a><br>
}<br>
],<br>
"send-lease-updates": false,<br>
"sync-leases": false,<br>
"this-server-name": "server3"<br>
}<br>
]<br>
}<br>
}<br>
],<br>
"hostname-char-replacement": "",<br>
"hostname-char-set": "",<br>
"interfaces-config": {<br>
"dhcp-socket-type": "udp",<br>
"interfaces": [<br>
"bond0/192.168.88.8"<br>
]<br>
},<br>
"ip-reservations-unique": false,<br>
"lease-database": {<br>
"connect-timeout": 3,<br>
"host": "database.bpk2.com",<br>
"max-reconnect-tries": 3,<br>
"name": "kea",<br>
"on-fail": "stop-retry-exit",<br>
"password": "*****",<br>
"port": 3306,<br>
"read-timeout": 10,<br>
"reconnect-wait-time": 100,<br>
"type": "mysql",<br>
"user": "kea",<br>
"write-timeout": 20<br>
},<br>
"loggers": [<br>
{<br>
"debuglevel": 0,<br>
"name": "kea-dhcp4",<br>
"output_options": [<br>
{<br>
"output": "syslog"<br>
}<br>
],<br>
"severity": "ERROR"<br>
}<br>
],<br>
"max-valid-lifetime": 86400,<br>
"min-valid-lifetime": 3600,<br>
"multi-threading": {<br>
"enable-multi-threading": true,<br>
"packet-queue-size": 66,<br>
"thread-pool-size": 12<br>
},<br>
"option-data": [<br>
{<br>
"data": "192.168.248.254",<br>
"name": "domain-name-servers"<br>
},<br>
{<br>
"data": "bpk2.com",<br>
"name": "domain-name"<br>
},<br>
{<br>
"data": "bpk2.com",<br>
"name": "domain-search"<br>
},<br>
{<br>
"data": "0xf0",<br>
"name": "default-ip-ttl"<br>
},<br>
{<br>
"data": "192.168.254.2",<br>
"name": "ntp-servers"<br>
},<br>
{<br>
"data": "192.168.253.3",<br>
"name": "netbios-name-servers"<br>
},<br>
{<br>
"data": "192.168.120.6",<br>
"name": "smtp-server"<br>
},<br>
{<br>
"data": "192.168.120.2",<br>
"name": "www-server"<br>
}<br>
],<br>
"rebind-timer": 1800,<br>
"renew-timer": 900,<br>
"reservations": [<br>
{<br>
"hostname": "rpi3",<br>
"hw-address": "b8:27:eb:d6:9a:6b",<br>
"ip-address": "192.168.1.4"<br>
},<br>
{<br>
"hostname": "rpi4",<br>
"hw-address": "dc:a6:32:eb:44:c4",<br>
"ip-address": "192.168.1.14"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "desktop",<br>
"hw-address": "78:e3:b5:b4:61:b8"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "x1titanium",<br>
"hw-address": "04:7b:cb:f9:ed:ac"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "netbook",<br>
"hw-address": "20:cf:30:05:c6:f8"<br>
},<br>
{<br>
"hostname": "printer",<br>
"hw-address": "e8:d8:d1:94:75:66",<br>
"ip-address": "192.168.24.3"<br>
},<br>
{<br>
"hostname": "printer",<br>
"hw-address": "e8:6f:38:a5:ab:cc",<br>
"ip-address": "192.168.24.3"<br>
},<br>
{<br>
"hostname": "rpi3",<br>
"hw-address": "b8:27:eb:83:cf:3e",<br>
"ip-address": "192.168.24.4"<br>
},<br>
{<br>
"hostname": "tv",<br>
"hw-address": "40:16:3b:da:da:98",<br>
"ip-address": "192.168.24.6"<br>
},<br>
{<br>
"hostname": "rpi4",<br>
"hw-address": "dc:a6:32:eb:44:c7",<br>
"ip-address": "192.168.24.14"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "desktop",<br>
"hw-address": "68:94:23:1c:a1:64"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "x1titanium",<br>
"hw-address": "ac:5a:fc:e3:20:42"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "netbook",<br>
"hw-address": "74:f0:6d:50:e0:72"<br>
},<br>
{<br>
"client-classes": [<br>
"unproxied-clients"<br>
],<br>
"hostname": "note9",<br>
"hw-address": "cc:c0:79:f5:b7:d5"<br>
},<br>
{<br>
"hostname": "aruba",<br>
"hw-address": "20:4c:03:cb:3b:7c",<br>
"ip-address": "192.168.56.2"<br>
},<br>
{<br>
"hostname": "ooma",<br>
"hw-address": "00:18:61:2d:49:2d",<br>
"ip-address": "192.168.56.3"<br>
},<br>
{<br>
"hostname": "brians-ooma",<br>
"hw-address": "00:18:61:46:cc:f1",<br>
"ip-address": "192.168.56.4"<br>
},<br>
{<br>
"hostname": "pitboss",<br>
"hw-address": "e8:68:e7:17:75:14",<br>
"ip-address": "192.168.56.5"<br>
},<br>
{<br>
"hostname": "wa1ppaio0",<br>
"hw-address": "04:0e:3c:7e:85:11",<br>
"ip-address": "192.168.57.3"<br>
},<br>
{<br>
"hostname": "wa1ptevo0",<br>
"hw-address": "b8:16:5f:24:7e:5d",<br>
"ip-address": "192.168.57.4"<br>
},<br>
{<br>
"client-classes": [<br>
"proxied-clients"<br>
],<br>
"hostname": "netbook",<br>
"hw-address": "56:fd:c0:7d:cc:92"<br>
},<br>
{<br>
"hostname": "nas-ipmi",<br>
"hw-address": "64:51:06:d8:0b:ce",<br>
"ip-address": "192.168.216.7"<br>
},<br>
{<br>
"hostname": "unifi",<br>
"hw-address": "78:8a:20:45:30:ea",<br>
"ip-address": "192.168.248.1"<br>
},<br>
{<br>
"hostname": "wifi-se-ext",<br>
"hw-address": "78:8a:20:86:4a:61",<br>
"ip-address": "192.168.248.2"<br>
},<br>
{<br>
"hostname": "wifi-nw-ext",<br>
"hw-address": "68:d7:9a:86:87:29",<br>
"ip-address": "192.168.248.3"<br>
},<br>
{<br>
"hostname": "wifi-ne-int",<br>
"hw-address": "b4:fb:e4:24:6e:f0",<br>
"ip-address": "192.168.248.4"<br>
},<br>
{<br>
"hostname": "wifi-sw-int",<br>
"hw-address": "b4:fb:e4:20:07:65",<br>
"ip-address": "192.168.248.5"<br>
}<br>
],<br>
"server-tag": "server3",<br>
"subnet4": [<br>
{<br>
"id": 1,<br>
"option-data": [<br>
{<br>
"data": "192.168.1.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.1.50 - 192.168.1.74"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.1.75 - 192.168.1.99"<br>
},<br>
{<br>
"client-class": "primary-unproxied",<br>
"pool": "192.168.1.100 - 192.168.1.124"<br>
},<br>
{<br>
"client-class": "secondary-unproxied",<br>
"pool": "192.168.1.125 - 192.168.1.149"<br>
},<br>
{<br>
"client-class": "primary-unknown",<br>
"pool": "192.168.1.150 - 192.168.1.174"<br>
},<br>
{<br>
"client-class": "primary-unknown",<br>
"pool": "192.168.1.175 - 192.168.1.199"<br>
},<br>
{<br>
"client-class": "primary-pxeboot",<br>
"pool": "192.168.1.200 - 192.168.1.224"<br>
},<br>
{<br>
"client-class": "primary-pxeboot",<br>
"pool": "192.168.1.225 - 192.168.1.249"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.1.254"<br>
]<br>
},<br>
"subnet": "192.168.1.0/24"<br>
},<br>
{<br>
"id": 24,<br>
"option-data": [<br>
{<br>
"data": "192.168.24.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.24.50 - 192.168.24.74"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.24.75 - 192.168.24.99"<br>
},<br>
{<br>
"client-class": "primary-unproxied",<br>
"pool": "192.168.24.100 - 192.168.24.124"<br>
},<br>
{<br>
"client-class": "secondary-unproxied",<br>
"pool": "192.168.24.125 - 192.168.24.149"<br>
},<br>
{<br>
"client-class": "primary-unknown",<br>
"pool": "192.168.24.150 - 192.168.24.174"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.24.175 - 192.168.24.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.24.254"<br>
]<br>
},<br>
"subnet": "192.168.24.0/24"<br>
},<br>
{<br>
"id": 56,<br>
"option-data": [<br>
{<br>
"data": "192.168.56.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-unknown",<br>
"pool": "192.168.56.100 - 192.168.56.149"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.56.150 - 192.168.56.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.56.254"<br>
]<br>
},<br>
"subnet": "192.168.56.0/24"<br>
},<br>
{<br>
"id": 57,<br>
"option-data": [<br>
{<br>
"data": "192.168.57.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-unknown",<br>
"pool": "192.168.57.100 - 192.168.57.149"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.57.150 - 192.168.57.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.57.254"<br>
]<br>
},<br>
"subnet": "192.168.57.0/24"<br>
},<br>
{<br>
"id": 152,<br>
"option-data": [<br>
{<br>
"data": "192.168.152.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.152.50 - 192.168.152.74"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.152.75 - 192.168.152.99"<br>
},<br>
{<br>
"client-class": "primary-unproxied",<br>
"pool": "192.168.152.100 - 192.168.152.124"<br>
},<br>
{<br>
"client-class": "secondary-unproxied",<br>
"pool": "192.168.152.125 - 192.168.152.149"<br>
},<br>
{<br>
"client-class": "primary-unknown",<br>
"pool": "192.168.152.150 - 192.168.152.174"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.152.175 - 192.168.152.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.152.254"<br>
]<br>
},<br>
"subnet": "192.168.152.0/24"<br>
},<br>
{<br>
"id": 184,<br>
"option-data": [<br>
{<br>
"data": "192.168.184.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.184.50 - 192.168.184.74"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.184.75 - 192.168.184.99"<br>
},<br>
{<br>
"client-class": "primary-unproxied",<br>
"pool": "192.168.184.100 - 192.168.184.124"<br>
},<br>
{<br>
"client-class": "secondary-unproxied",<br>
"pool": "192.168.184.125 - 192.168.184.149"<br>
},<br>
{<br>
"client-class": "priamry-unknown",<br>
"pool": "192.168.184.150 - 192.168.184.174"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.184.175 - 192.168.184.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.184.254"<br>
]<br>
},<br>
"subnet": "192.168.184.0/24"<br>
},<br>
{<br>
"id": 185,<br>
"option-data": [<br>
{<br>
"data": "192.168.185.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.185.50 - 192.168.185.74"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.185.75 - 192.168.185.99"<br>
},<br>
{<br>
"client-class": "primary-unproxied",<br>
"pool": "192.168.185.100 - 192.168.185.124"<br>
},<br>
{<br>
"client-class": "secondary-unproxied",<br>
"pool": "192.168.185.125 - 192.168.185.149"<br>
},<br>
{<br>
"client-class": "priamry-unknown",<br>
"pool": "192.168.185.150 - 192.168.185.174"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.185.175 - 192.168.185.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.185.254"<br>
]<br>
},<br>
"subnet": "192.168.185.0/24"<br>
},<br>
{<br>
"id": 216,<br>
"option-data": [<br>
{<br>
"data": "192.168.216.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.216.1 - 192.168.216.24"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.216.25 - 192.168.216.50"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.216.254"<br>
]<br>
},<br>
"subnet": "192.168.216.0/24"<br>
},<br>
{<br>
"id": 248,<br>
"option-data": [<br>
{<br>
"data": "192.168.248.254",<br>
"name": "routers"<br>
}<br>
],<br>
"pools": [<br>
{<br>
"client-class": "primary-proxied",<br>
"pool": "192.168.248.50 - 192.168.248.74"<br>
},<br>
{<br>
"client-class": "secondary-proxied",<br>
"pool": "192.168.248.75 - 192.168.248.99"<br>
},<br>
{<br>
"client-class": "primary-unproxied",<br>
"pool": "192.168.248.100 - 192.168.248.124"<br>
},<br>
{<br>
"client-class": "secondary-unproxied",<br>
"pool": "192.168.248.125 - 192.168.248.149"<br>
},<br>
{<br>
"client-class": "priamry-unknown",<br>
"pool": "192.168.248.150 - 192.168.248.174"<br>
},<br>
{<br>
"client-class": "secondary-unknown",<br>
"pool": "192.168.248.175 - 192.168.248.199"<br>
}<br>
],<br>
"relay": {<br>
"ip-addresses": [<br>
"192.168.248.254"<br>
]<br>
},<br>
"subnet": "192.168.248.0/24"<br>
}<br>
],<br>
"valid-lifetime": 7200<br>
}<br>
<br>
</font></p>
<div class="moz-cite-prefix"><font size="4">On 4/16/24 12:30 PM,
Peter Davies wrote:<br>
</font></div>
<blockquote type="cite"
cite="mid:837a171f-24ce-4cda-a180-1d2c3c26b955@isc.org">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p><font size="4">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>
</font> <font size="4"><br>
Also, setting the "authoritative" to true will force Kea to
always reject INIT-REBOOT requests from unknown clients<br>
/Peter<br>
</font> </p>
<div class="moz-cite-prefix"><font size="4">On 16/04/2024 18.16,
Brendan Kearney wrote:<br>
</font> </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"><font size="4">--
Peter Davies
Support Engineer
Internet Systems Corporation
</font></pre>
<font size="4"><br>
</font>
<fieldset class="moz-mime-attachment-header"></fieldset>
</blockquote>
</body>
</html>