<div dir="ltr">Hi Andrew,<div><br></div><div>Just want so check that I am explaining clear enough, or if I am still leaving some room for confusion?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Oct 25, 2014 at 2:26 PM, Matthew Ogden <span dir="ltr"><<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Also, maybe I am explaining my self badly.<div><br></div><div>The SourceUser column is correctly displaying TN001 in the log I sent you, but that same line, both the SourceExtAccountId and SourceExtSubscriberId are displaying PD001 (the original calling user).</div><div><br></div><div>So if you use these two fields for billing (SourceExtAccountId and SourceExtSubsbriberId), then I end up billing the wrong caller? (Whereas, if you look at SourceUser, you will bill the right caller for the cfu leg.</div><div><br></div><div>Hope I am explaining myself correctly.</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Oct 25, 2014 at 2:21 PM, Matthew Ogden <span dir="ltr"><<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:12.8000001907349px">Thanks Andrew, but we have been using SourceAccountExtId to check who should pay for the call, in exported system.</span><span><div style="font-family:arial,sans-serif;font-size:12.8000001907349px"><br></div><div style="font-family:arial,sans-serif;font-size:12.8000001907349px">the <span>cfu</span> leg of the call is billable to the person who needed the <span>cfu</span> to exist (Called party). </div><div style="font-family:arial,sans-serif;font-size:12.8000001907349px"><br></div><div style="font-family:arial,sans-serif;font-size:12.8000001907349px">But in the case of a <span>CFU</span>, its actually the otherway around, (isn't that a little counter-intuitive?) Well, it was for me, but</div></span><div style="font-family:arial,sans-serif;font-size:12.8000001907349px"><div><br></div><div>I can quite happily go and change it around post-processing, but in your panel, do you then make two queries for all your lookups as well for billing? Or are you billing the original calling party?</div></div></div><div class="gmail_extra"><br><div class="gmail_quote"><span>On Thu, Oct 16, 2014 at 1:03 AM, Andrew Pogrebennyk <span dir="ltr"><<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a>></span> wrote:<br></span><div><div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Matthew,<br>
// I'm adding list to the cc again since this message doesn't carry<br>
conditential information<br>
So the mysql output shows you have two CDRs, one for the caller and<br>
another for subscriber which has a call forwarding, just like I said.<br>
<br>
Think of it like that in case of call A->B forwarded to C, you get one<br>
CDR for A->B and a second one with B->C with call_type='cfu'. You can<br>
use the call_type field if you want to apply special rating to the<br>
forwarding subscriber.<br>
<span><br>
On 14/10/14 16:42, Matthew Ogden wrote:<br>
> Hi Andrew,<br>
><br>
> I've kept this offlist, and didn't want to sanitize it and lose any info<br>
> you might need.<br>
><br>
> Please find attached<br>
><br>
> I wasn't sure the best way to give you the two records, so I just used<br>
> mysql OUTPUTFILE syntax.<br>
> There are two records in it.<br>
><br>
> The call is from PD001 and then the cfu leg for TEST1 is logged as a<br>
> call against PD001 in SourceSubscriber<br>
><br>
> Regards<br>
><br>
> On Fri, Oct 10, 2014 at 5:09 PM, Andrew Pogrebennyk<br>
</span><span>> <<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a> <mailto:<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a>>> wrote:<br>
><br>
> Hi,<br>
> you should have two CDRs, one for the caller and another for subscriber<br>
> which has a call forwarding. This is consistent for any 2.x and 3.x<br>
> release. What is your issue? Could you please provide the select * from<br>
> accounting.cdr where call_id='...'? And if there is really just one CDR<br>
> provide the kamailio-proxy.log for this call-id.<br>
><br>
> Regards,<br>
> Andrew<br>
><br>
> On 10/10/2014 10:00 AM, Matthew Ogden wrote:<br>
> > Hi All,<br>
> ><br>
> > Seems to be quite a serious issue this (at least on a large system it<br>
> > could be if a lot of inter subscriber calling with cfu's is occuring).<br>
> ><br>
> > Is there any additional info I can give you ?<br>
> ><br>
> > On Tue, Oct 7, 2014 at 11:36 PM, Matthew Ogden <<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a> <mailto:<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a>><br>
</span><span>> > <mailto:<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a> <mailto:<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a>>>> wrote:<br>
> ><br>
> > Hi All<br>
> ><br>
> ><br>
> > I'm running templates templates 2.8.18<br>
> ><br>
> > It seems that if one subscriber calls another subscriber, if<br>
> the 2nd<br>
> > subscriber does a call forward, that the call cost is logged<br>
> against<br>
> > the calling (caller) subscriber, and not the called (callee)<br>
> > subscriber.<br>
> ><br>
> > I'm seeing this in my exported CDRs.<br>
> ><br>
> > I wanted to check, is this the expectation (because I'm<br>
> thinking it<br>
> > should not be), or is there something wrong in this template<br>
> version?<br>
> ><br>
> > Kind Regards<br>
> > Matthew<br>
> ><br>
> ><br>
> ><br>
><br>
><br>
><br>
><br>
> --<br>
><br>
><br>
><br>
><br>
><br>
</span>> *Matthew Ogden*<br>
><br>
> Management<br>
><br>
> TenacIT<br>
><br>
><br>
><br>
><br>
><br>
> *Strategic IT Consulting *•*Advanced Networking *• *Virtualisation***<br>
><br>
> *Custom Development *•***Hosting *•***Syspro Support *• *MS Licensing***<br>
<span>><br>
> National Tel: 041 10 10 100 | Cell: 084 205 4445 | Email:<br>
</span>> <a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a> <mailto:<a href="mailto:matthew@tenacit.net" target="_blank">matthew@tenacit.net</a>><br>
<span>><br>
> CT Tel: 021 201 0333 | Skype Name: matthew.ogden | Web:<br>
</span>> <a href="http://www.tenacit.net" target="_blank">http://www.tenacit.net</a> <<a href="http://www.tenacit.net/" target="_blank">http://www.tenacit.net/</a>><br>
><br>
><br>
><br>
<br>
</blockquote></div></div></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><span><p> </p>
<p><span style="font-size:10.0pt;color:gray"><img src="http://www.tenacit.net/googlesig/tenacit.png" width="200" height="65"></span><span lang="EN-ZA" style="font-size:10.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:10.0pt;color:black"> </span></p>
<p><b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">Matthew Ogden</span></b></p>
<p><span style="font-size:10.0pt;color:gray">Management</span></p>
<p><span style="font-size:10.0pt;color:gray">TenacIT
</span></p>
<p><span style="font-size:10.0pt;color:gray"> </span></p>
<p><span style="color:gray;font-size:10pt"> </span><br></p>
<p><b><span lang="EN-ZA">Strategic IT Consulting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> Advanced Networking </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">Virtualisation</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><b><span lang="EN-ZA">Custom Development </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Hosting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Syspro Support </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">MS Licensing</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
</span><p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">National Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">041 10 10 100
| </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Cell: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">084 205 4445 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Email: </span><a href="mailto:matthew@tenacit.net" target="_blank"><span style="font-size:9.0pt;color:gray;text-decoration:none">matthew@tenacit.net</span></a><span style="font-size:9.0pt;color:#44546a"> </span><span style="font-size:9.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">CT Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">021 201 0333 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Skype Name: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">matthew.ogden | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Web: </span><span lang="EN-ZA" style="font-size:9.0pt;color:#bce292;text-decoration:none"><a href="http://www.tenacit.net/" target="_blank">http://www.tenacit.net</a></span></p><p> <img src="http://www.tenacit.net/googlesig/bottom.png"></p></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><p> </p>
<p><span style="font-size:10.0pt;color:gray"><img src="http://www.tenacit.net/googlesig/tenacit.png" width="200" height="65"></span><span lang="EN-ZA" style="font-size:10.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:10.0pt;color:black"> </span></p>
<p><b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">Matthew Ogden</span></b></p>
<p><span style="font-size:10.0pt;color:gray">Management</span></p>
<p><span style="font-size:10.0pt;color:gray">TenacIT
</span></p>
<p><span style="font-size:10.0pt;color:gray"> </span></p>
<p><span style="color:gray;font-size:10pt"> </span><br></p>
<p><b><span lang="EN-ZA">Strategic IT Consulting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> Advanced Networking </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">Virtualisation</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><b><span lang="EN-ZA">Custom Development </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Hosting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Syspro Support </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">MS Licensing</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">National Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">041 10 10 100
| </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Cell: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">084 205 4445 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Email: </span><a href="mailto:matthew@tenacit.net" target="_blank"><span style="font-size:9.0pt;color:gray;text-decoration:none">matthew@tenacit.net</span></a><span style="font-size:9.0pt;color:#44546a"> </span><span style="font-size:9.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">CT Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">021 201 0333 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Skype Name: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">matthew.ogden | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Web: </span><span lang="EN-ZA" style="font-size:9.0pt;color:#bce292;text-decoration:none"><a href="http://www.tenacit.net/" target="_blank">http://www.tenacit.net</a></span></p><p> <img src="http://www.tenacit.net/googlesig/bottom.png"></p></div>
</div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><p> </p>
<p><span style="font-size:10.0pt;color:gray"><img src="http://www.tenacit.net/googlesig/tenacit.png" width="200" height="65"></span><span lang="EN-ZA" style="font-size:10.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:10.0pt;color:black"> </span></p>
<p><b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">Matthew Ogden</span></b></p>
<p><span style="font-size:10.0pt;color:gray">Management</span></p>
<p><span style="font-size:10.0pt;color:gray">TenacIT
</span></p>
<p><span style="font-size:10.0pt;color:gray"> </span></p>
<p><span style="color:gray;font-size:10pt"> </span><br></p>
<p><b><span lang="EN-ZA">Strategic IT Consulting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> Advanced Networking </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">Virtualisation</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><b><span lang="EN-ZA">Custom Development </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Hosting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Syspro Support </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">MS Licensing</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">National Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">041 10 10 100
| </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Cell: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">084 205 4445 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Email: </span><a href="mailto:matthew@tenacit.net" target="_blank"><span style="font-size:9.0pt;color:gray;text-decoration:none">matthew@tenacit.net</span></a><span style="font-size:9.0pt;color:#44546a"> </span><span style="font-size:9.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">CT Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">021 201 0333 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Skype Name: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">matthew.ogden | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Web: </span><span lang="EN-ZA" style="font-size:9.0pt;color:#bce292;text-decoration:none"><a href="http://www.tenacit.net/" target="_blank">http://www.tenacit.net</a></span></p><p> <img src="http://www.tenacit.net/googlesig/bottom.png"></p></div>
</div>