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