(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