Re: Hotspot nearing completion

[Albert Miles Enabe]

>  "Daniel Baughman" <[EMAIL PROTECTED]> wrote:
>

> So from what I read it seems that I might be able to do something like > this: > > in the postgresql.conf define a new variable like this: > my_session_timeout = > "SELECT minutes_left from ${acct_tablex} where user = > '%{SQL-User-Name}' " > > Then back in the radiusd.conf do this for the session-timeout: > Session-Timeout = my_session_timeout > > Thus the session time out will vary from session to session based on > how > much a user has left? > > Im reading more of the stuff in doc, and it seems that is what the expr > mod > is kinda for, allowing for assignment based on string interpertation. > > Dan In my case, although I'm using MySQL for my database, I compiled Freeradius 0.9.3 with the rlm_sqlcounter module and used the Max-All-Session attribute in the radcheck table for each user. It works, disconnecting online users when their maximum allowed total time has been all used up.

Please see the documentation on using the rlm_sqlcounter module.

Good luck!

-Miles

 

---

Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.