Re: NAS list with MySQL

[orion <meshkruaj@gmail.com>]

the script nas.sql has the mysql table schema.
the file sql.conf at the end you can see :


# 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

        # Table to keep radius client info
        nas_table = "nas"

As you can see the default table name is nas ( can you imagine :-) ).
Uncoment
readclients =  yes

Make configuration changes at radiusd.conf and enable sql module.

On 19/01/2008, Pawel Cieplinski < pawel@parkandmarine.com> wrote:

Hi there... i am new to free radius. I already successfully installed freeradius 1.1.7 with mysql5.1. The point is NAS's IPs and secrets are configured in clients.conf. I cannot find anything how to put those data to SQL database. Sql.conf doesn't describe any table or value for clients, can anyone give any clue how to store those data in SQL database

 

Pawel Cieplinski

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