(RADIATOR) Problem with accounting of multiple cisco avpairs.

[Anders Solhaug]

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.