Hi and Merry Christmas, I don't know if I can ask my problem here because it's about CDRTool not kamailio.
I use kamailio+mediaproxy+callcontrol+cdrtool+freeradius-xs, all calls are OK, the balance is updated after each calln, and i have start/bye on freeradius. All seems ok but after each call I receive from cdrtool something like this, for example when I call to Germany (00491525XXXXXXX) Dec 25 17:43:53 billing cdrtool[11656]: Dec 25 17:45:01 billing cdrtool[17062]: Error: cannot find destination id for 491525XXXXXXX of customer = '', total destinations = 0 Dec 25 17:45:01 billing cdrtool[17062]: Error: cannot find destination id for 491525XXXXXXX of customer = '', total destinations = 0 Dec 25 17:45:01 billing cdrtool[17062]: Error: cannot find destination id for 491525XXXXXXX of customer = '', total destinations = 0 Dec 25 17:45:01 billing cdrtool[17062]: 1 CDRs, 1 normalized in 0 s @ 0 cps These are logs from cdrtool: 131225 17:43:35 527269 Query select * from prepaid where account = 'te...@sip.test' 527269 Query select * from destinations where dest_id = '491525' and (reseller_id = 0 or reseller_id = 0) order by reseller_id desc limit 1 527269 Query select * from billing_customers where subscriber = 'te...@sip.test' or domain = 'sip.test' or gateway = '10.57.85.221' or (subscriber = '' and domain = '' and gateway = '') order by subscriber desc, domain desc, gateway desc limit 1 527269 Query select * from billing_rates where name = 'bll_prepaid' and destination = '491525' and application = 'audio' 527269 Query update prepaid set active_sessions = '{\"WrNwobXRtxTIrP3YfZtbz8FmGRXJ6oh0\":{\"timestamp\":1387982615,\"duration\":36000,\"BillingPartyId\":\"te...@sip.test\",\"MaxSessionTime\":36000,\"domain\":\"sip.test\",\"gateway\":\"10.57.85.221\",\"Destination\":\"+4915252136282\",\"DestinationId\":\"491525\",\"region\":null,\"connectCost\":\"0.0000\"}}', session_counter = '1' where account = 'te...@sip.test' 131225 17:43:53 527269 Query select * from prepaid where account = 'te...@sip.test' 131225 17:44:59 527269 Query select * from destinations where dest_id = '491525' and (reseller_id = 0 or reseller_id = 0) order by reseller_id desc limit 1 527269 Query select * from billing_customers where subscriber = 'te...@sip.test' or domain = 'sip.test' or gateway = '10.57.85.221' or (subscriber = '' and domain = '' and gateway = '') order by subscriber desc, domain desc, gateway desc limit 1 527269 Query select * from billing_discounts where domain = 'sip.test' and application = 'audio' and destination = '491525' 527269 Query select * from billing_rates where name = 'bll_prepaid' and destination = '491525' and application = 'audio' 527269 Query select * from prepaid where account = 'te...@sip.test' 527269 Query update prepaid set balance = balance - '660.0000', change_date = NOW(), active_sessions = '[]', session_counter = '0' where account = 'te...@sip.test' 527269 Query insert into prepaid_history (username,domain,action,description,value,balance,date,session,duration,destination,reseller_id) values ('teddy','sip.blueline.mg','Debit balance','Session to +491525XXXXXXX for 66s','-660.0000','895739.9999',NOW(),'WrNwobXRtxTIrP3YfZtbz8FmGRXJ6oh0','66','+491525XXXXXXX',0) 1 when I telnet cdrtool on port 9024 from kamailio, I have the price, for the destination: ShowPrice From=sip:te...@sip.test To=sip:00491525xxxx...@sip.test gateway=10.0.0.1 duration=247 2470.0000 Duration: 247 s App: audio Destination: 491525 Customer: domain=sip.test Connect: 0.0000 StartTime: 2013-12-26 10:50:07 -- Span: 1 Duration: 247 s ProfileId: bll_prepaid / weekday RateId: bll_prepaid / 0-24h Rate: 600.0000 / 60 s Price: 2,470.0000 I don't know why cdrtool sends mail to me and says that it doesn't find the destination, can someone help me please. Thanks in advance. ps: If need, I can show the configuration files or other logs Regards. _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users