[Spce-user] Error rating CDR batch - after upgrade

[Skyler]

Thanks Andrew, the issue is fixed now and upgrade applied. I will test
click2call more tomorrow and revert if anything comes up.

Cheers,
Skyler

On Wed, Apr 25, 2012 at 8:50 AM, Andrew Pogrebennyk <
apogrebennyk at sipwise.com> wrote:

> Skyler, this means you need to fix the accounting record by inserting
> "call" into the blank space, e.g.:
>
> update acc set
> src_leg='1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|sip.mydomain.com
> |14574176498||1605|3|||0|call|1335300610.209136'
> where id=129;
>
> Make sure to not copy it from email, as it may split src_leg to multiple
> lines. Do the same for second acc record and after that restart the
> mediator. Or just drop them if you don't need the CDR :-)
>
> I'm pretty sure the broken accounting comes from click2dial, can tell
> for sure if you have the proxy.log for this callid.
>
> The fixes for click2dial case are available in 2.5 sipwise repository
> (make sure to apply the new templates).
>
> Normally this mysql select should produce zero rows.
>
> On 04/25/2012 05:22 PM, Skyler wrote:
> >     Could you show me
> >     select * from acc where src_leg like "%||133%"\G
> >     ?
> >
> >
> >
> > mysql> select * from acc where src_leg like "%||133%"\G;
> > *************************** 1. row ***************************
> >         id: 129
> >     method: INVITE
> >   from_tag: 5F808EAC-4F9712020003249B-15116700
> >     to_tag: 18AED02F-4F971202000333DD-13C01700
> >     callid: 700B2758-4F971202000324A4-15116700
> >   sip_code: 200
> > sip_reason: OK
> >       time: 2012-04-24 13:50:14
> > time_hires: 1335300614.920
> >    src_leg:
> > 1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|sip.mydomain.com
> > <http://sip.mydomain.com>|14574176498||1605|3|||0||1335300610.209136
> >    dst_leg:
> > |1605|3|14574176498|1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|
> sip.mydomain.com
> > <http://sip.mydomain.com>|14574176498|sip.mydomain.com
> > <http://sip.mydomain.com>
> >   dst_user: 14574176498
> >  dst_ouser: +13564176492
> > dst_domain: 25.116.109.202
> >   src_user:
> > src_domain: sip.mydomain.com <http://sip.mydomain.com>
> > *************************** 2. row ***************************
> >         id: 130
> >     method: INVITE
> >   from_tag: 753CF869-4F9712080004EA9E-14A0F700
> >     to_tag:
> >     callid: 66E2CDF9-4F9712080004EAA1-14A0F700
> >   sip_code: 404
> > sip_reason:
> >       time: 2012-04-24 13:50:16
> > time_hires: 1335300616.320
> >    src_leg:
> > 1ceb0639-329d-412a-828f-4ca1f1147c19|16044173292|sip.mydomain.com
> > <http://sip.mydomain.com>|14574176498||1605|3|||0||1335300616.324150
> >    dst_leg: ||0|+13564176492|0|+13564176492|sip.mydomain.com
> > <http://sip.mydomain.com>|+13564176492|sip.mydomain.com
> > <http://sip.mydomain.com>
> >   dst_user: +13564176492
> >  dst_ouser: +13564176492
> > dst_domain: sip.mydomain.com <http://sip.mydomain.com>
> >   src_user:
> > src_domain: sip.mydomain.com <http://sip.mydomain.com>
> > 2 rows in set (0.00 sec)
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120425/4220c878/attachment-0001.html>