26 Dec
2013
26 Dec
'13
1:13 p.m.
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(a)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(a)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(a)sip.test'
131225 17:43:53 527269 Query select * from prepaid where account =
'teddy(a)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(a)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(a)sip.test'
527269 Query update prepaid
set balance = balance - '660.0000',
change_date = NOW(),
active_sessions = '[]',
session_counter = '0'
where account = 'teddy(a)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.