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@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