(RADIATOR) SQL Accounting / Radius Attribute Values only

[Hugh Irvine]

Hello Robert -

I can't think of an easy way to do what you describe below, other than 
writing a custom hook to add some pseudo-attributes to the current request 
for the integer values you require, and then using them in the 
AcctSQLStatement.

There are some example hooks in the distribution in the file 
"goodies/hooks.txt".

regards

Hugh


On Fri, 4 Jan 2002 23:57, Robert Blayzor wrote:
> Correct... If you are using the standard accounting "INSERT ...".  But
> how would you do it if you need to use:
>
>         AcctSQLStatement        EXEC sp_RadiusAcctInsert
> '0','%{Acct-Session-Id}','%{Acct-Status-
> Type}','%{User-Name}','%{Called-Station-Id}','%{Calling-Station-Id}','%c
> ','%{NAS-Port}','%{NAS-Po
> rt-Type}','%{Service-Type}','%{Framed-Protocol}','%{Framed-IP-Address}',
> '%{Connect-Info}','%{Acct
> -Terminate-Cause}','%{Acct-Input-Octets}','%{Acct-Output-Octets}','%{Acc
> t-Session-Time}'
>
>
> A more advanced SQL statement?

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