Freeradius push attribute to wireless connection

Guillaume Chartrand guillaume.chartrand at Collanaud.Qc.Ca
Wed Apr 2 15:25:26 CEST 2008


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080402/89c7a486/attachment.html>


More information about the Freeradius-Users mailing list