<div class="gmail_extra">Thanks Andrew, the issue is fixed now and upgrade applied. I will test click2call more tomorrow and revert if anything comes up.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Cheers,</div>
<div class="gmail_extra">Skyler<br><br><div class="gmail_quote">On Wed, Apr 25, 2012 at 8:50 AM, Andrew Pogrebennyk <span dir="ltr"><<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Skyler, this means you need to fix the accounting record by inserting<br>
"call" into the blank space, e.g.:<br>
<br>
update acc set<br>
src_leg='1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a>|14574176498||1605|3|||0|call|1335300610.209136'<br>
where id=129;<br>
<br>
Make sure to not copy it from email, as it may split src_leg to multiple<br>
lines. Do the same for second acc record and after that restart the<br>
mediator. Or just drop them if you don't need the CDR :-)<br>
<br>
I'm pretty sure the broken accounting comes from click2dial, can tell<br>
for sure if you have the proxy.log for this callid.<br>
<br>
The fixes for click2dial case are available in 2.5 sipwise repository<br>
(make sure to apply the new templates).<br>
<br>
Normally this mysql select should produce zero rows.<br>
<div class="im"><br>
On 04/25/2012 05:22 PM, Skyler wrote:<br>
> Could you show me<br>
> select * from acc where src_leg like "%||133%"\G<br>
> ?<br>
><br>
><br>
><br>
> mysql> select * from acc where src_leg like "%||133%"\G;<br>
> *************************** 1. row ***************************<br>
> id: 129<br>
> method: INVITE<br>
> from_tag: 5F808EAC-4F9712020003249B-15116700<br>
> to_tag: 18AED02F-4F971202000333DD-13C01700<br>
> callid: 700B2758-4F971202000324A4-15116700<br>
> sip_code: 200<br>
> sip_reason: OK<br>
> time: 2012-04-24 13:50:14<br>
> time_hires: 1335300614.920<br>
> src_leg:<br>
> 1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a><br>
</div>> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>>|14574176498||1605|3|||0||1335300610.209136<br>
<div class="im">> dst_leg:<br>
> |1605|3|14574176498|1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a><br>
</div>> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>>|14574176498|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a><br>
> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>><br>
<div class="im">> dst_user: 14574176498<br>
> dst_ouser: +13564176492<br>
> dst_domain: 25.116.109.202<br>
> src_user:<br>
</div>> src_domain: <a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>><br>
<div class="im">> *************************** 2. row ***************************<br>
> id: 130<br>
> method: INVITE<br>
> from_tag: 753CF869-4F9712080004EA9E-14A0F700<br>
> to_tag:<br>
> callid: 66E2CDF9-4F9712080004EAA1-14A0F700<br>
> sip_code: 404<br>
> sip_reason:<br>
> time: 2012-04-24 13:50:16<br>
> time_hires: 1335300616.320<br>
> src_leg:<br>
> 1ceb0639-329d-412a-828f-4ca1f1147c19|<a href="tel:16044173292" value="+16044173292">16044173292</a>|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a><br>
</div>> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>>|14574176498||1605|3|||0||1335300616.324150<br>
<div class="im">> dst_leg: ||0|+13564176492|0|+13564176492|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a><br>
</div>> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>>|+13564176492|<a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a><br>
> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>><br>
> dst_user: +13564176492<br>
> dst_ouser: +13564176492<br>
> dst_domain: <a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>><br>
> src_user:<br>
> src_domain: <a href="http://sip.mydomain.com" target="_blank">sip.mydomain.com</a> <<a href="http://sip.mydomain.com" target="_blank">http://sip.mydomain.com</a>><br>
<div class="HOEnZb"><div class="h5">> 2 rows in set (0.00 sec)<br>
<br>
</div></div></blockquote></div><br></div>