Hi,

I’m using Freeradius 2.0, I configurated it with an sql database and the principal job of the radius server is to authorize and authenticate my wireless user over my network. What I want to do is to give some attribute to the user when is connected. Like Session-Timeout, bandwith and some other stuff. Here some entry in my database

usergroup

1,"guillaume","dynamic"

2,"jacques","dynamic"

Radcheck

1,"guillaume","Cleartext-Password","xxxxxx",":="

2,"jacques","Cleartext-Password","xxxxx",":="

Radreply

3,"guillaume","Session-Timeout","30",":="

It’s an Mssql database

Here the debug info with radiusd –X

rlm_sql (sql): sql_set_user escaped user --> 'guillaume'

rlm_sql (sql): Reserving sql socket id: 2

        expand: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'guillaume' ORDER BY id

query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'guillaume' ORDER BY id

rlm_sql (sql): User found in radcheck table

        expand: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'guillaume' ORDER BY id

query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'guillaume' ORDER BY id

rlm_sql (sql): Released sql socket id: 2

++[sql] returns ok

I have access but my session didn’t disconnect after 30 sec. So can I do that with wireless configuration? My goal is to give some « guest user » a limited time and an expiration date.

Thanks

----------------------------

Guillaume Chartrand