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 |