Re: Clients Configuration on MySQL

2010-03-18 Thread Teguh Kurniawan
It working. Thank you.

Teguh

On Thu, Mar 18, 2010 at 6:33 PM, Alan Buxey  wrote:
> Hi,
>
>> Could we move clients.conf to mysql table ?
>
> yes.
>
>> How to do that ?
>
> its well documented but basically, you need to
>
>
> 1) import the nas.sql  so that your MySQL has the right table/structure
> 2) edit the mysql/dialup.conf make sure that nas_query is not commented
>
>
> finally, edit sql.conf..right near the bottom you will find this:
>
>        # Set to 'yes' to read radius clients from the database ('nas' table)
>        # Clients will ONLY be read on server startup.  For performance
>        # and security reasons, finding clients via SQL queries CANNOT
>        # be done "live" while the server is running.
>        #
>        #readclients = yes
>
> read the text. uncomment the readclients
>
>
> if you DO want new clients to work without restarting the service, then
> enable the dynamic-clients virtual host.  read the dynamic-clients config
> well - it makes pretty good sense and is trivial to operate.
>
> alan
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Clients Configuration on MySQL

2010-03-18 Thread Alan Buxey
Hi,

> Could we move clients.conf to mysql table ?

yes.

> How to do that ?

its well documented but basically, you need to


1) import the nas.sql  so that your MySQL has the right table/structure
2) edit the mysql/dialup.conf make sure that nas_query is not commented


finally, edit sql.conf..right near the bottom you will find this:

# Set to 'yes' to read radius clients from the database ('nas' table)
# Clients will ONLY be read on server startup.  For performance
# and security reasons, finding clients via SQL queries CANNOT
# be done "live" while the server is running.
#
#readclients = yes

read the text. uncomment the readclients


if you DO want new clients to work without restarting the service, then
enable the dynamic-clients virtual host.  read the dynamic-clients config
well - it makes pretty good sense and is trivial to operate.

alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Clients Configuration on MySQL

2010-03-17 Thread Teguh Kurniawan
Hi,
Could we move clients.conf to mysql table ?
How to do that ?
Thank's

Teguh
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html