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

[Skyler]

Hi,

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

> On 04/25/2012 01:34 PM, Skyler wrote:
> > Hrmmm, there was a dev tester yesterday verifying the setup ... maybe
> > they clicked on click2dial via CSC.
>
> 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|14574176498||1605|3|||0||1335300610.209136
   dst_leg:
|1605|3|14574176498|1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|
sip.mydomain.com|14574176498|sip.mydomain.com
  dst_user: 14574176498
 dst_ouser: +13564176492
dst_domain: 25.116.109.202
  src_user:
src_domain: 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|14574176498||1605|3|||0||1335300616.324150
   dst_leg: ||0|+13564176492|0|+13564176492|sip.mydomain.com|+13564176492|
sip.mydomain.com
  dst_user: +13564176492
 dst_ouser: +13564176492
dst_domain: sip.mydomain.com
  src_user:
src_domain: 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/7741131f/attachment-0001.html>