(RADIATOR) Problem with accounting of multiple cisco avpairs.

[Hugh Irvine]

Hello Anders -

I think you will have to write a hook to parse the accounting packet in 
whatever fashion suits your requirements.

There are some example hooks in the file "goodies/hooks.txt" in the Radiator 
3.1 distribution.

regards

Hugh


On Tue, 2 Jul 2002 23:25, Anders Solhaug wrote:
> Hello,
>
> Can anyone help me or give me some hints on how to solve my problem with
> accounting of multiple cisco avpairs  into a MySQL database.
>
> Here is an part of an RADIUS account message recieved by Radiator from a
> Cisco AS5300:
>         Acct-Input-Packets = 40
>         Acct-Output-Packets = 23
>         Acct-Session-Time = 53
>         cisco-avpair = "disc-cause-ext=1045"
>         cisco-avpair = "pre-bytes-in=202"
>         cisco-avpair = "pre-bytes-out=147"
>         cisco-avpair = "pre-paks-in=6"
>         cisco-avpair = "pre-paks-out=5"
>         cisco-avpair = "pre-session-time=29"
>         cisco-avpair = "connect-progress=65"
>         cisco-avpair = "nas-rx-speed=31200"
>         cisco-avpair = "nas-tx-speed=26400"
>         Acct-Delay-Time = 0
>
> The radius.cfg entry:
> 	  AcctColumnDef   CISCOAVPAIR,cisco-avpair
>
> With this configuration, only the first avpair is stored on the SQL
> ACCOUNTING table. Is there any way to store all the avpairs in separate
> fields or as one concatenated string in one field?
>
> Any help regarding this is highly appreciated!
>
> Thanks in advance.
>
> Regards
>
> Anders Solhaug
> ===
> 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.

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