Hello Charles -
On Saturday 06 January 2001 12:10, Charles Sprickman wrote:
> On Sat, 6 Jan 2001, Hugh Irvine wrote:
> > > 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.
> >
> > You would use an AcctSQLStatement in your AuthBy SQL to total the times,
>
> I'm a bit stuck on this one, because while I have an AuthBy SQL, I'm only
> using it for accounting... I could make a query that does a sum on all
> "ACCTSESSIONTIME" entries for that user, but it seems a little abusive,
> although I'm guessing our IPass usage will be pretty light. I'm still a
> bit lost on this part of it.
>
Yes, the session times are reported in the accounting stops, so that is why
it would be simple to add the new session time to the cumulative total with
the AcctSQLStatement.
Something like this:
AcctSQLStatement update IPASSACCT set \
TOTALTIME=TOTALTIME+0%{Acct-Session-Time}
> > and an AuthBy PORTLIMITCHECK to handle the possible abuse (more than
> > "x" minutes, actually seconds would be easier to deal with).
>
> It almost looks like I could use PORTLIMITCHECK to do this. If I set
> "LimitQuery" to be something like "select username, sum(ACCTSESSIONTIME)
> from IPASSACCT where username=%{username} group by username;" and set max
> sessions to the number of seconds my top limit is... Ugly, but perhaps it
> would work.
>
The LimitQuery will only have to check the TOTALTIME against the preset limit.
You will also have to have a cron job (or similar) to reset the TOTALTIME
counters at the start of each month.
> > If you have any further questions just ask.
>
> Of course! Radiator is like having an auto shop full of tools. So far
> I'm just changing the oil on my Honda...
>
We offer only the finest tools - in fact Mike and I also have a joint venture
company called "Network Engineering Tools (NETS)" which handles - you guessed
it "Nets".
In fact, you should really have a look at Nets....
:-)
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.
