(RADIATOR) Problem with accounting of multiple cisco avpairs.
hugh at open.com.au
Tue Jul 2 20:03:21 CDT 2002
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
On Tue, 2 Jul 2002 23:25, Anders Solhaug wrote:
> 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.
> 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.
More information about the radiator