(RADIATOR) inserting vendor attributes to accounting table
Utku Er
erutku at netone.net.tr
Mon Feb 18 12:23:47 CST 2002
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020218/32da338d/attachment.html>
More information about the radiator
mailing list