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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
