(RADIATOR) Does anyone have a radacct.cgi

[Hugh Irvine]

Hello Miguel -

I posted this to the mailing list some time ago - you might find it useful.

	http://www.open.com.au/archives/radiator/2000-11/msg00114.html

regards

Hugh


On Tuesday 29 May 2001 14:06, Miguel A.L. Paraz wrote:
> Does anyone have a radacct.cgi that eliminates duplicate accounting
> records?
>
> I started working on this for the different queries by using a hash to
> track down if the session was seen already.  However in the default query,
> we have this SQL statement:
>
> my $q = "select USERNAME, sum(ACCTSESSIONTIME),
> sum(ACCTINPUTOCTETS), sum(ACCTOUTPUTOCTETS)
> from $DBTableName group by USERNAME";
>
> which aggregates the session time and others by username.  Has anyone
> "unrolled" this SQL statement yet?  If not, we will do that here.  Thanks.

-- 
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.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.