Hello Charles -
On Saturday 06 January 2001 10:03, Charles Sprickman wrote:
> Hi,
>
> I'm having some trouble figuring out what direction to go to track total
> usage for certain users. We recently signed up with IPass, and have it
> working fine. I auth off of a unix password file and a flat users file,
> but log to a sql database...
>
> How can I:
>
> -keep a running total of usage on my IPass users (they hit their own
> Handler).
> -eventually put an upper limit on this usage.
>
> As a hack around I was going to just add another column to my db called
> "total time" and run a cron job that would periodically addup all my
> "acctsessiontime" stats for each user. I assume some type of post-auth
> hook could do this, but I'm really no big perl guy... And a pre-auth
> could look at that column as well and if it's more than "x" minutes, deny
> the login...
>
> Any ideas? I know I can't be the first to need to do this, as IPass
> strongly recommends doing all you can to keep a possibly hijacked account
> from being abused (and paid for).
>
You would use an AcctSQLStatement in your AuthBy SQL to total the times, and
an AuthBy PORTLIMITCHECK to handle the possible abuse (more than "x" minutes,
actually seconds would be easier to deal with).
If you have any further questions just ask.
regards
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
