(RADIATOR) SQL Accounting / Radius Attribute Values only

Robert Blayzor noc at inoc.net
Thu Jan 3 15:59:21 CST 2002


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.

--
Robert Blayzor, BOFH
INOC, LLC
rblayzor at inoc.net

Earth is 98% full...please delete anyone you can.


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


More information about the radiator mailing list