(RADIATOR) SQL Accounting / Radius Attribute Values only

[Hugh Irvine]

Hello Robert -

My first inclination would be to archive the accounting data on a periodic 
basis (every day, every week, every month, whatever). One easy way to do this 
is to set up a different table for each month (week, day, whatever) for 
example and then use the Radiator special characters in your AcctSQLStatement 
to specify the table name.

I really wouldn't suggest storing the integer values as trying to post 
process the data will be very messy.

regards

Hugh


On Fri, 4 Jan 2002 08:59, Robert Blayzor wrote:
> We have a very high number of accounting records that get stored on our
> SQL servers, our goal is to reduce space consumption a bit.  Is there a
> way to have Radiator store the actual value of the RADIUS accounting
> attributes and not the dictionary definitions?
>
>
> Ie:
>
>
> EXEC sp_RadiusAcctInsert '0', '00000015', 'Stop', 'joeuser', '6894448',
> '5184329030', '64.246.132.1','12', 'Async', 'Framed-User', 'PPP',
> '64.246.132.11', '', 'User-Request', '2194', '1138', '63'
>
>
> Instead "Stop", value would be integer 2.
>
> NAS-Port-Type, Framed-Protocol, etc, all are integers and use much less
> space to store than their text meanings.

-- 
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.