Perfect -thank you. I have a great standalone lab so now I understand the interaction I can start to play 😊 Thank you for the very quick and detailed explanation! David From: Freeradius-Users <freeradius-users-bounces+d.lake=surrey.ac.uk@lists.freeradius.org> on behalf of Matthew Newton via Freeradius-Users <freeradius-users@lists.freeradius.org> Date: Thursday, 31 July 2025 at 14:07 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Cc: Matthew Newton <mcn@freeradius.org> Subject: Re: Unsure of linelog configuration On 31/07/2025 13:41, David Lake wrote:
(4) dhcp_sqlippool: --> DHCP: Allocated IP: 192.168.2.101 from ipoe (cid 0x010c3311bf0000 chaddr 0c:33:11:bf:00:00 giaddr 192.168.2.1) (4) [dhcp_sqlippool] = ok (4) linelog_dhcp: EXPAND %t %{control:Module-Success-Message} (4) linelog_dhcp: --> Thu Jul 31 12:32:31 2025 DHCP: Allocated IP: 192.168.2.101 from ipoe (cid 0x010c3311bf0000 chaddr 0c:33:11:bf:00:00 giaddr 192.168.2.1)
Ah, OK. dhcp_sqlippool calls the authorize method, which emits some logging information that ends up in Module-Success-Message.
After an ACK I see this:
(5) dhcp_sqlippool: --> UPDATE dhcpippool SET expiry_time = NOW() + INTERVAL 7200 SECOND, counter = counter + 1 WHERE pool_name = 'ipoe' AND pool_key = '0x010c3311bf0000' AND framedipaddress = '192.168.2.101' (5) dhcp_sqlippool: Executing query: UPDATE dhcpippool SET expiry_time = NOW() + INTERVAL 7200 SECOND, counter = counter + 1 WHERE pool_name = 'ipoe' AND pool_key = '0x010c3311bf0000' AND framedipaddress = '192.168.2.101' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 ...
(5) linelog_dhcp: EXPAND %t %{control:Module-Success-Message} (5) linelog_dhcp: --> Thu Jul 31 12:32:32 2025
dhcp_sqlippool_request calls the accounting method, which doesn't output any logging, so doesn't update the Module-Success-Message attribute. You'll be better to just log what you want, rather than using that attribute. Something like message="%t %{request:DHCP-Client-Hardware-Address} %{reply:DHCP-Your-IP-Address} from pool %{Pool-Name}" Add whatever attributes you need (you can call the `debug_all` policy before `linelog_dhcp` to show them all in the debug output if you're not sure what is available). -- Matthew - List info/subscribe/unsubscribe? See https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeradius.org%2Flist%2Fusers.html&data=05%7C02%7Cd.lake%40surrey.ac.uk%7C54b2b2f0ac554563878808ddd0332722%7C6b902693107440aa9e21d89446a2ebb5%7C0%7C0%7C638895640303736033%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=rykzPLKA42Vl%2Frs07wzbGQatPH9mNmvJ7Q7dvzWESC4%3D&reserved=0<http://www.freeradius.org/list/users.html>