MySQL Backend

Rampage atomikramp at email.it
Tue Jun 12 22:21:32 CEST 2012


Hello everyone,
I need a lil advice from you FreeRADIUS gurus, as i'm having a bit of 
trouble in understanding the database structure from the examples and 
schema available on the project wiki.

Let's say i successfully managed to bind freeRADIUS to mysql, i can 
connect it and no errors are present, i created all proper tables, and 
database accounts to have freeRADIUS talk to mysql.

the problem is.. ok but now, which informations do i put where?

i'd start from a simple example..

let's say i have the user

"testuser"
"cleartext-password"
:=
"testpassword"

if i add this values in the radcheck table, i can successfully 
authenticate testuser from my NAS.

Now let's say i'd like to limit the user for using the service for only 
1 hour a day.
if i recall correctly there is a parameter that says:

Max-Daily-Session := 3600 (seconds)

but, where do i have to add this value? still to the radcheck? or 
radreply? or where else?

i also noticed that the radacct table contains one account for each time 
i perform a login for the specific user, is it normal?

is there a table that contains usernames in a unique manner? so that i 
can eventually link it to another table containing further informations 
about the user (name, surname etc?)

sorry if i ask here but really i couldn't understand this from the wiki :(

thanks in advice.



More information about the Freeradius-Users mailing list