Hello Charles -
On Tuesday 09 January 2001 10:06, Charles Sprickman wrote:
> 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...
>
There are two different things happening here. First, there is no "default"
query as it is generated from your AcctColumnDef's. Second, the
AcctSQLStatement(s) is/are executed *in addition to* the AcctColumnDef's.
Therefore, you leave your AcctColumnDef's as they are, and you add a simple
AcctSQLStatement (or even several) as I've shown.
Clear?
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.
