On Sat, 6 Jan 2001, Hugh Irvine wrote:
> 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}
OK, I'm just about ready. I've been digging around the various .pm files
trying to find what the "default" SQL statement is, but I've yet to find
it. What am I missing? Or do I just set it up based on my
"AcctColumnDef" fields, ie:
AcctSQLStatement update NASPORT set NASPORT=%{NAS-Port} update \
TIME_STAMP set TIME_STAMP=%{Timestamp} [etc...] where \
USERNAME=%{User-Name}
Is that correct? I assume I also ditch all the AcctColumnDef's at this
point as well. Actually, that's not correct, is it? That's why I want to
see the actual default statement...
Thanks,
Charles
> > > 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.
