How to store multiple Cisco-AVPair to sql database

Mark Jones mjones at mnsi.net
Fri Nov 13 19:27:01 CET 2009


As you can see in the below accounting packet there are multiple cisco-avpsir entries. how can i referecne the second and seccussive entries when trying to store them in and sql database.








Fri Nov 13 10:56:23 2009
        Acct-Session-Id = "004D8A64"
        Cisco-AVPair = "client-mac-address=0024.016f.3054"
        Framed-Protocol = PPP
        Framed-IP-Address = 
        User-Name = "downs at mnsi.net"
        Acct-Authentic = RADIUS
        Cisco-AVPair = "connect-progress=LAN Ses Up"
        Cisco-AVPair = "nas-tx-speed=37500000"
        Cisco-AVPair = "nas-rx-speed=37500000"
        Acct-Session-Time = 300
        Acct-Input-Octets = 666
        Acct-Output-Octets = 708
        Acct-Input-Packets = 52
        Acct-Output-Packets = 53
        Acct-Terminate-Cause = User-Request
        Cisco-AVPair = "disc-cause-ext=PPP Receive Term"
        Acct-Status-Type = Stop
        NAS-Port-Type = Virtual
        NAS-Port = 0
        NAS-Port-Id = "1/0/0/3.33"
        Service-Type = Framed-User
        NAS-IP-Address = 
        Acct-Delay-Time = 1
        Client-IP-Address = 
        Hint = ""
        Acct-Unique-Session-Id = "f60485a6cb583511"
        Stripped-User-Name = "dow"
        Realm = ""
        Timestamp = 1258127783    

Mark Jones
London Operations
Managed Network Systems
Desk 519-679-5207

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20091113/19f665e1/attachment.html>


More information about the Freeradius-Users mailing list