Freeradius to use SQL table instead of client.conf

[Alan Smith]

 Thank you Bjorn. I followed the one from this link as I want to continue using SQL table. 

https://github.com/FreeRADIUS/freeradius-server/blob/d3fc9b6e76aef3fd3358210caadd97a5d46754c0/raddb/sites-available/dynamic-clients#L153
I have updated the query shown in Example 3 reflecting my table name. It still does not reflect when there is a change in the table. 




    On Wednesday, 17 July 2024 at 05:14:00 pm SGT, Bjørn Mork <bjorn at mork.no> wrote:  
 
 Alan Smith via Freeradius-Users <freeradius-users at lists.freeradius.org>
writes:

>  Thank you Nathan. May I check if there would be a way to achieve the
>  requirement to dynamically update client info without the need to
>  restart radiusd service?


Yes, there is. It is documented in this example config:
https://github.com/FreeRADIUS/freeradius-server/blob/HEAD/raddb/sites-available/dynamic-clients

Works best if all your clients have addresses from a small number of
prefixes.  I.e. if you allocate all the loopback addresses used as
radius client source addresses from a pool dedicated to precisely that.


Bjørn