(RADIATOR) inserting vendor attributes to accounting table

[Hugh Irvine]

Hello Utku -

You will need to pre-process the accounting requests with a PreAuthHook to 
extract the relevant information and add a couple of pseudo-attributes to the 
request packet that you can then use in your AcctColumnDef's.

There are some example hooks (including Cisco pseudo-attributes) in the file 
"goodies/hooks.txt" in the Radiator 2.19 distribution.

regards

Hugh


On Tue, 19 Feb 2002 05:23, Utku Er wrote:
> Hi there,
>
> We are running Radiator 2.19 on linux redhat 7.2.
> We know that cisco sends its vendor attributes in a text stile like:
>         cisco-avpair = "nas-rx-speed=31200"
>         cisco-avpair = "nas-tx-speed=31200"
>
> I want to insert this rx-speed and tx-speed attributes to my sql ACCOUNTING
> table... But how do I insert values accourdingly to my RXRATE and TXRATE
> columns? I mean is there any way to split this attribute=value pairs and
> insert it with AcctColumnDef? do something like:
>
> AcctColumnDef   ACCTRXRATE,$rxrate,integer
> AcctColumnDef   ACCTTXRATE,$txrate,integer
> ?
>
> any help appreciated... thanks
>
> Utku.
> here is the full attributes from cisco nas:
>
> Attributes:
>         NAS-IP-Address = aa.bb.cc.dd
>         NAS-Port = 213
>         Cisco-NAS-Port = "Async213"
>         NAS-Port-Type = Async
>         User-Name = "testetest"
>         Called-Station-Id = "234234234234"
>         Calling-Station-Id = "2523452342342"
>         Acct-Status-Type = Stop
>         Acct-Authentic = RADIUS
>         Service-Type = Framed-User
>         Acct-Session-Id = "00013195"
>         Framed-Protocol = PPP
>         Framed-IP-Address = a.b.c.d
>         Acct-Terminate-Cause = Lost-Carrier
>         Acct-Input-Octets = 1120292
>         Acct-Output-Octets = 9155113
>         Acct-Input-Packets = 11130
>         Acct-Output-Packets = 10634
>         Acct-Session-Time = 5921
>         cisco-avpair = "disc-cause-ext=1011"
>         cisco-avpair = "pre-bytes-in=253"
>         cisco-avpair = "pre-bytes-out=183"
>         cisco-avpair = "pre-paks-in=10"
>         cisco-avpair = "pre-paks-out=8"
>         cisco-avpair = "pre-session-time=37"
>         cisco-avpair = "nas-rx-speed=31200"
>         cisco-avpair = "nas-tx-speed=31200"
>         Acct-Delay-Time = 0

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