Re: Accounting and Session-Timeout

At 04:09 PM 6/26/2003, you wrote:
> Hello everybody,
>
> I have here, up and running, a FreeRadius 0.8.1 server accessing a MySQL 
> database to authenticate my users.
> I have a table 'radreply', where I can define a custom radreply for each 
> user. I'm using this for a quite easy thing: I'm replying with the default 
> data a Session-Timeout, which is defined for each user.
> What's going on: I have an user with the login 'igor', for example, and 
> I've configured a Session-Timeout of 60 seconds (1 minute). After 1 
> minute, my RAS disconnects the user 'igor'. But if 'igor' authenticates 
> again, he'll have 1 minute more.
> I guess that I have to launch a database stored procedure or something 
> like on the STOP event, to calculate the remaining time and write the 
> right values on the right places.
> Does anybody here have another way to do it? Have someone here ever did that?
> Suggestions are welcome.

I think you might want to look at rlm_sqlcounter. There is excellent 
documentation too, which is found in /path/to/src/radiusd/doc/rlm_sqlcounter.


HTH,

Chris Brotsos



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html