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 = "do...@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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html