|
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 |