Hi, I having a problem storing repeated Attributes in to a Microsoft Sql Database. My Start record gets logged like this: Acct-Status-Type = Start NAS-IP-Address = 127.0.0.254 NAS-Port = 5060 Acct-Session-Id = "D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139" Session-Ingress-CallId = "D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139" Session-Egress-CallId = "D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139" Session-Protocol-Type = "SIP" Calling-Station-Id = "Test" Called-Station-Id = "<sip:XXXXXXXXXX@127.102.0.117>" h323-setup-time = "18:01:42.091 UTC APR 28 2006" h323-connect-time = "18:01:42.119 UTC APR 28 2006" Session-Egress-Realm = "b11" Session-Ingress-Realm = "p11" FlowID = "localhost:65616" FlowType = "PCMA" Flow-In-Realm = "p11" Flow-In-Src-Addr = 0.0.0.0 Flow-In-Src-Port = 0 Flow-In-Dst-Addr = 10.2.35.117 Flow-In-Dst-Port = 49232 Flow-Out-Realm = "b11" Flow-Out-Src-Addr = 10.2.19.117 Flow-Out-Src-Port = 49232 Flow-Out-Dst-Addr = 0.0.0.0 Flow-Out-Dst-Port = 0 FlowID = "localhost:65617" FlowType = "PCMA" Flow-In-Realm = "b11" Flow-In-Src-Addr = 0.0.0.0 Flow-In-Src-Port = 0 Flow-In-Dst-Addr = 10.2.19.117 Flow-In-Dst-Port = 49232 Flow-Out-Realm = "p11" Flow-Out-Src-Addr = 10.2.35.117 Flow-Out-Src-Port = 49232 Flow-Out-Dst-Addr = 10.10.1.139 Flow-Out-Dst-Port = 49228 Client-IP-Address = 10.1.0.33 Acct-Unique-Session-Id = "bfbfead8e14980c1" Timestamp = 1146246538 Notice how the FlowID attribute is logged twice but have different values How do I reference the second occurance of FlowID i.e %{FlowID} in my SQL statement in my mssql.conf? I created two new columns in my sql database called FlowID1 and FlowID2. accounting_update_query = "INSERT into ${acct_table1} (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, FlowID1, FlowID2) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{FlowID}', '%{FlowID}')"
participants (2)
-
Alan DeKok -
Jackie Lau