I know the rlm_sqlcounter module is there. I just need to find an example on how to set up FreeRadius to use it.
I'm very familiar with writing sql queries, just not in this environment. Anyone have a sample radiusd.conf and sql.conf for calculating Session-Timeout's ? > -----Original Message----- > From: Keith Yoder [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 01, 2004 8:07 AM > To: [EMAIL PROTECTED] > Subject: Re: Calculating Remaining Time for Session-Timeout > > Rick, > > You'll want to use the rlm_sqlcounter module. You can set a > Max-All-Session = 36000 to limit a user to 10 hours of total > access for example. FreeRadius will calculate how much time > was used and set the Session-Timeout attribute automatically. > > Hope that helps, > Keith Yoder > > Rick Smith escreveu: > > >OK, I have several Mikrotik based hotspots out there. They > auth users > >via RADIUS. I'm now running FreeRadius 1.0.0. > > > >I right now can auth users on them via FreeRadius - works > great - and > >I'm using MySQL which is even better. > > > >Only problem is, right now they all get non-expiring > sessions when they > >paid for half-hour increments :) > > > >Mikrotik expects "Session-Timeout" back as a clue on when to > kick the > >user to pay for more time. > > > >How do I tell FreeRadius that "User x" bought 15 minutes on > a hotspot, > >and tell Mikrotik to kick him when his time's up ? > > > >I understand about putting the Session-Timeout value in the radcheck > >table - that works. Just need to figure out how to update that > >Session-Timeout value every time the user logs in and out .... > > > > > >Thanks, > > > >Rick > > > >- > >List info/subscribe/unsubscribe? See > >http://www.freeradius.org/list/users.html > > > > > > > > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
