Alan Just ran a quick debug again so I get my story straight The key in dhcp_sqlippool is pool_key = "%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}" Debug is as follows Tue Oct 28 16:32:24 2025 : Debug: (1121) DHCP-Gateway-IP-Address = 10.180.144.2 Tue Oct 28 16:32:24 2025 : Debug: (1122) DHCP-Gateway-IP-Address = 10.180.144.3 Tue Oct 28 16:32:24 2025 : Debug: DHCP: Existing IP: %{reply:DHCP-Your-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address}) Tue Oct 28 16:32:24 2025 : Debug: attribute --> DHCP-Gateway-IP-Address Tue Oct 28 16:32:24 2025 : Debug: (1121) dhcp_sqlippool: EXPAND DHCP: Existing IP: %{reply:DHCP-Your-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address}) Tue Oct 28 16:32:24 2025 : Debug: (1121) DHCP-Gateway-IP-Address = 10.180.144.2 Tue Oct 28 16:32:24 2025 : Debug: DHCP: Existing IP: %{reply:DHCP-Your-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address}) Tue Oct 28 16:32:24 2025 : Debug: attribute --> DHCP-Gateway-IP-Address Tue Oct 28 16:32:24 2025 : Debug: (1122) dhcp_sqlippool: EXPAND DHCP: Existing IP: %{reply:DHCP-Your-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address}) Tue Oct 28 16:32:24 2025 : Debug: (1122) DHCP-Gateway-IP-Address = 10.180.144.3 Tue Oct 28 16:32:25 2025 : Debug: (1123) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Oct 28 16:32:25 2025 : Debug: DHCP: No Pool-Name defined (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address}) Tue Oct 28 16:32:25 2025 : Debug: attribute --> DHCP-Gateway-IP-Address Tue Oct 28 16:32:25 2025 : Debug: (1123) dhcp_sqlippool: EXPAND DHCP: No Pool-Name defined (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address}) Tue Oct 28 16:32:25 2025 : Debug: (1123) DHCP-Gateway-IP-Address = 0.0.0.0 These are the same request being relayed from the two different routers. One matches the existing ip the other does not as the query is using the giaddr. Unless I am misunderstanding the debug. Mark Jones Operations Managed Network Systems Windsor Desk 519-258-2333 x8417 Cell 226-340-1254 -----Original Message----- From: Freeradius-Users <freeradius-users-bounces+mjones=mnsi.net@lists.freeradius.org> On Behalf Of Alan DeKok via Freeradius-Users Sent: Tuesday, October 28, 2025 4:11 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Cc: Alan DeKok <alan.dekok@inkbridge.io> Subject: Re: [Possible Spam]Re: dhcp with multiple dhcp-relay routers On Oct 28, 2025, at 2:13 PM, mjones@mnsi.net wrote:
It looks like we are actually run 3.2.1.
You can upgrade on a test machine. And see if the queries have been updated.
The key you refer to is what we had expected to use but it still seems to use the giaddr even though it is not part of the key.
And.... what does the debug output say? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html