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