[OpenSIPS-Users] (CDRTool) combining sip_trace/media records from multiple proxies

[Jeff Pyle]

Great!

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?


- Jeff


From: Adrian Georgescu <ag at ag-projects.com<mailto:ag at ag-projects.com>>
Reply-To: OpenSIPS users mailling list <users at lists.opensips.org<mailto:users at lists.opensips.org>>
Date: Mon, 15 Nov 2010 03:42:17 -0500
To: OpenSIPS users mailling list <users at lists.opensips.org<mailto:users at lists.opensips.org>>
Subject: Re: [OpenSIPS-Users] (CDRTool) combining sip_trace/media records from multiple proxies

Yes you can, just define the data sources for sip trace and media trace to point to the same databases.

Adrian

On Nov 11, 2010, at 12:38 PM, Jeff Pyle wrote:

Hello,

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.

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.

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.

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.

My goal is to minimize the amount of places I have to look when looking for the same data.

Any thoughts?  Am I trying to combine apples and pomegranates?


- Jeff

_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20101115/1fdfc04e/attachment.htm>