Missing destinations in CDRTool but calls are ok - sr-users

26 Dec 2013

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