<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi I'm sorry, you're right, this is the output<br>
<br>
mysql> select * from accounting.cdr where call_id =
'<a class="moz-txt-link-abbreviated" href="mailto:5101bdff0000118100000013724c76af@ens.com">5101bdff0000118100000013724c76af@ens.com</a>'\G<br>
*************************** 1. row ***************************<br>
id: 113865<br>
update_time: 2013-01-25 00:05:24<br>
source_user_id:
a1ceef67-5b37-4c36-99f5-5441c31a3b5e<br>
source_provider_id: 1<br>
source_external_subscriber_id:<br>
source_external_contract_id: ibred<br>
source_account_id: 3<br>
source_user: n555554148<br>
source_domain: voip.ibreddigital.net<br>
source_cli: 34555554148<br>
source_clir: 1<br>
destination_user_id: 0<br>
destination_provider_id: 5<br>
destination_external_subscriber_id:<br>
destination_external_contract_id:<br>
destination_account_id: 0<br>
destination_user: 34555550330<br>
destination_domain: 55.55.107.230<br>
destination_user_dialed: 34555550330<br>
destination_user_in: 34555550330<br>
destination_domain_in: voip.ibreddigital.net<br>
peer_auth_user:<br>
peer_auth_realm:<br>
call_type: cfb<br>
call_status: ok<br>
call_code: 200<br>
init_time: 1359068671.617<br>
start_time: 1359068674.920<br>
duration: 42.010<br>
call_id:
<a class="moz-txt-link-abbreviated" href="mailto:5101bdff0000118100000013724c76af@ens.com">5101bdff0000118100000013724c76af@ens.com</a><br>
carrier_cost: 0.95<br>
reseller_cost: 0.00<br>
customer_cost: 0.95<br>
carrier_free_time: 0<br>
reseller_free_time: 0<br>
customer_free_time: 0<br>
carrier_billing_fee_id: 120295<br>
reseller_billing_fee_id: NULL<br>
customer_billing_fee_id: 120295<br>
carrier_billing_zone_id: 360<br>
reseller_billing_zone_id: NULL<br>
customer_billing_zone_id: 360<br>
frag_carrier_onpeak: NULL<br>
frag_reseller_onpeak: NULL<br>
frag_customer_onpeak: NULL<br>
is_fragmented: NULL<br>
rated_at: 2013-01-25 00:05:24<br>
rating_status: ok<br>
*************************** 2. row ***************************<br>
id: 113866<br>
update_time: 2013-01-25 00:05:24<br>
source_user_id: 0<br>
source_provider_id: 5<br>
source_external_subscriber_id:<br>
source_external_contract_id:<br>
source_account_id: 0<br>
source_user: 555551271<br>
source_domain: 55.55.107.230<br>
source_cli: 34555551271<br>
source_clir: 0<br>
destination_user_id:
a1ceef67-5b37-4c36-99f5-5441c31a3b5e<br>
destination_provider_id: 1<br>
destination_external_subscriber_id:<br>
destination_external_contract_id: ibred<br>
destination_account_id: 3<br>
destination_user: n555554148<br>
destination_domain: voip.ibreddigital.net<br>
destination_user_dialed: 555554148<br>
destination_user_in: 34555554148<br>
destination_domain_in: 55.55111.231<br>
peer_auth_user:<br>
peer_auth_realm:<br>
call_type: call<br>
call_status: ok<br>
call_code: 200<br>
init_time: 1359068671.554<br>
start_time: 1359068674.920<br>
duration: 42.010<br>
call_id:
<a class="moz-txt-link-abbreviated" href="mailto:5101bdff0000118100000013724c76af@ens.com">5101bdff0000118100000013724c76af@ens.com</a><br>
carrier_cost: 0.00<br>
reseller_cost: 0.00<br>
customer_cost: 0.00<br>
carrier_free_time: 0<br>
reseller_free_time: 0<br>
customer_free_time: 0<br>
carrier_billing_fee_id: NULL<br>
reseller_billing_fee_id: NULL<br>
customer_billing_fee_id: NULL<br>
carrier_billing_zone_id: NULL<br>
reseller_billing_zone_id: NULL<br>
customer_billing_zone_id: NULL<br>
frag_carrier_onpeak: NULL<br>
frag_reseller_onpeak: NULL<br>
frag_customer_onpeak: NULL<br>
is_fragmented: NULL<br>
rated_at: 2013-01-25 00:05:24<br>
rating_status: ok<br>
2 rows in set (0.00 sec)<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">El 2013-01-28 11:17, Jon Bonilla
(Manwe) escribió:<br>
</div>
<blockquote cite="mid:20130128111728.6cfbb01f@quenya" type="cite">
<pre wrap="">El Fri, 25 Jan 2013 08:17:46 +0100
"Joan Cifre (ibred)" <a class="moz-txt-link-rfc2396E" href="mailto:jcifre@ib-red.com"><jcifre@ib-red.com></a> escribió:
</pre>
<blockquote type="cite">
<pre wrap="">mysql> select * from accounting.cdr where call_id =
'<a class="moz-txt-link-abbreviated" href="mailto:5101bdff0000118100000013724c76af@55.55.107.230:5060">5101bdff0000118100000013724c76af@55.55.107.230:5060</a>'\G
Empty set (0.00 sec)
Am I doing something wrong? It's empty...
</pre>
</blockquote>
<pre wrap="">
The call-id is not correct. Where did you find that one? This is what I see in
the log you sent
<a class="moz-txt-link-abbreviated" href="mailto:ID=5101bdff0000118100000013724c76af@ens.com">ID=5101bdff0000118100000013724c76af@ens.com</a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="http://lists.sipwise.com/listinfo/spce-user">http://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>