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 = 'teddy@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 = 'teddy@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":"teddy@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 = 'teddy@sip.test' 131225 17:43:53 527269 Query select * from prepaid where account = 'teddy@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 = 'teddy@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 = 'teddy@sip.test' 527269 Query update prepaid set balance = balance - '660.0000', change_date = NOW(), active_sessions = '[]', session_counter = '0' where account = 'teddy@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:teddy@sip.test To=sip:00491525XXXXXXX@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.