[Spce-user] applying NCOS to all users

[Joan Cifre (ibred)]

Hi I'm sorry, you're right, this is the output

mysql>  select * from accounting.cdr where call_id = 
'5101bdff0000118100000013724c76af at ens.com'\G
*************************** 1. row ***************************
                                 id: 113865
                        update_time: 2013-01-25 00:05:24
                     source_user_id: a1ceef67-5b37-4c36-99f5-5441c31a3b5e
                 source_provider_id: 1
      source_external_subscriber_id:
        source_external_contract_id: ibred
                  source_account_id: 3
                        source_user: n555554148
                      source_domain: voip.ibreddigital.net
                         source_cli: 34555554148
                        source_clir: 1
                destination_user_id: 0
            destination_provider_id: 5
destination_external_subscriber_id:
   destination_external_contract_id:
             destination_account_id: 0
                   destination_user: 34555550330
                 destination_domain: 55.55.107.230
            destination_user_dialed: 34555550330
                destination_user_in: 34555550330
              destination_domain_in: voip.ibreddigital.net
                     peer_auth_user:
                    peer_auth_realm:
                          call_type: cfb
                        call_status: ok
                          call_code: 200
                          init_time: 1359068671.617
                         start_time: 1359068674.920
                           duration: 42.010
                            call_id: 
5101bdff0000118100000013724c76af at ens.com
                       carrier_cost: 0.95
                      reseller_cost: 0.00
                      customer_cost: 0.95
                  carrier_free_time: 0
                 reseller_free_time: 0
                 customer_free_time: 0
             carrier_billing_fee_id: 120295
            reseller_billing_fee_id: NULL
            customer_billing_fee_id: 120295
            carrier_billing_zone_id: 360
           reseller_billing_zone_id: NULL
           customer_billing_zone_id: 360
                frag_carrier_onpeak: NULL
               frag_reseller_onpeak: NULL
               frag_customer_onpeak: NULL
                      is_fragmented: NULL
                           rated_at: 2013-01-25 00:05:24
                      rating_status: ok
*************************** 2. row ***************************
                                 id: 113866
                        update_time: 2013-01-25 00:05:24
                     source_user_id: 0
                 source_provider_id: 5
      source_external_subscriber_id:
        source_external_contract_id:
                  source_account_id: 0
                        source_user: 555551271
                      source_domain: 55.55.107.230
                         source_cli: 34555551271
                        source_clir: 0
                destination_user_id: a1ceef67-5b37-4c36-99f5-5441c31a3b5e
            destination_provider_id: 1
destination_external_subscriber_id:
   destination_external_contract_id: ibred
             destination_account_id: 3
                   destination_user: n555554148
                 destination_domain: voip.ibreddigital.net
            destination_user_dialed: 555554148
                destination_user_in: 34555554148
              destination_domain_in: 55.55111.231
                     peer_auth_user:
                    peer_auth_realm:
                          call_type: call
                        call_status: ok
                          call_code: 200
                          init_time: 1359068671.554
                         start_time: 1359068674.920
                           duration: 42.010
                            call_id: 
5101bdff0000118100000013724c76af at ens.com
                       carrier_cost: 0.00
                      reseller_cost: 0.00
                      customer_cost: 0.00
                  carrier_free_time: 0
                 reseller_free_time: 0
                 customer_free_time: 0
             carrier_billing_fee_id: NULL
            reseller_billing_fee_id: NULL
            customer_billing_fee_id: NULL
            carrier_billing_zone_id: NULL
           reseller_billing_zone_id: NULL
           customer_billing_zone_id: NULL
                frag_carrier_onpeak: NULL
               frag_reseller_onpeak: NULL
               frag_customer_onpeak: NULL
                      is_fragmented: NULL
                           rated_at: 2013-01-25 00:05:24
                      rating_status: ok
2 rows in set (0.00 sec)




El 2013-01-28 11:17, Jon Bonilla (Manwe) escribió:
> El Fri, 25 Jan 2013 08:17:46 +0100
> "Joan Cifre (ibred)" <jcifre at ib-red.com> escribió:
>
>> mysql> select * from accounting.cdr where call_id =
>> '5101bdff0000118100000013724c76af at 55.55.107.230:5060'\G
>> Empty set (0.00 sec)
>>
>> Am I doing something wrong? It's empty...
>>
>>
> The call-id is not correct. Where did you find that one? This is what I see in
> the log you sent
>
> ID=5101bdff0000118100000013724c76af at ens.com
>
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20130128/a4727e94/attachment.html>