<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Great!</div><div><br></div><div>Another question: As a packet passes from proxy A to proxy B, won't both proxies write basically the same packet to the sip_trace table? In this instance CDRTool will simply display both packets, no?</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> Adrian Georgescu <<a href="mailto:ag@ag-projects.com">ag@ag-projects.com</a>><br><span style="font-weight:bold">Reply-To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Date: </span> Mon, 15 Nov 2010 03:42:17 -0500<br><span style="font-weight:bold">To: </span> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br><span style="font-weight:bold">Subject: </span> Re: [OpenSIPS-Users] (CDRTool) combining sip_trace/media records from multiple proxies<br></div><div><br></div><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Yes you can, just define the data sources for sip trace and media trace to point to the same databases.<div><br></div><div>Adrian</div><div><br><div><div>On Nov 11, 2010, at 12:38 PM, Jeff Pyle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Hello,</div><div><br></div><div>In my network I have three Opensips instances routing traffic to, from and across my network. I use MySQL with radius for Opensips accounting, as well as MySQL for sip_trace and MySQL + radius for Mediaproxy accouting. I use CDRTool to view the records together.</div><div><br></div><div>In CDRTool I have a separate data source for each proxy's records, as each is written to a separate database. That's fine. This also leads to separate sip_trace and mediaproxy records for the same call ID.</div><div><br></div><div>1) Is it possible to use the same sip_trace table for all three proxies, and therefore view the traffic across all three proxies at the same time in CDRTool no matter which proxy's traffic I choose to look at? My hope here is they will key on the same call ID. All three proxies are VMs on the same dom0 so their clocks are the same.</div><div><br></div><div>2) Mediaproxy is engaged only once across any of the three proxies for the same call. Can I use the same media_sessions table for all three dispatchers to see the media records for a call no matter which proxy's traffic I'm looking at? The MySQL side seems easier here than the radius one. I fear at best I'd lose the view of the radius data unless I pick the "correct" proxy in CDRTool.</div><div><br></div><div>My goal is to minimize the amount of places I have to look when looking for the same data.</div><div><br></div><div>Any thoughts? Am I trying to combine apples and pomegranates?</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div></div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></div></div></span></body></html>