2018-07-13 11:35:01.884240 [WARNING] sofia_reg.c:1792 SIP auth challenge (INVITE) on sofia profile 'internal' for [0114620900@sbc.convergedgroup.co.za] from ip 154.118.252.35 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.884240 [DEBUG] switch_core_state_machine.c:603 (sofia/internal/27105914607@sbc.convergedgroup.co.za) State NEW 2018-07-13 11:35:01.884240 [DEBUG] sofia.c:2334 detaching session 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] sofia.c:7084 Channel sofia/internal/0102065021@10.192.0.130:5060 entering state [proceeding][183] c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] sofia.c:7094 Remote SDP: c3169a1c-3cd0-440f-894e-6f0993ae8ffe v=0 c3169a1c-3cd0-440f-894e-6f0993ae8ffe o=CvtVoice 49298220 49298220 IN IP4 10.192.0.130 c3169a1c-3cd0-440f-894e-6f0993ae8ffe s=CvtVoice c3169a1c-3cd0-440f-894e-6f0993ae8ffe c=IN IP4 10.192.0.130 c3169a1c-3cd0-440f-894e-6f0993ae8ffe t=0 0 c3169a1c-3cd0-440f-894e-6f0993ae8ffe m=audio 13936 RTP/AVP 18 101 c3169a1c-3cd0-440f-894e-6f0993ae8ffe a=rtpmap:18 G729/8000 c3169a1c-3cd0-440f-894e-6f0993ae8ffe a=fmtp:18 annexb=no c3169a1c-3cd0-440f-894e-6f0993ae8ffe a=rtpmap:101 telephone-event/8000 c3169a1c-3cd0-440f-894e-6f0993ae8ffe a=fmtp:101 0-16 c3169a1c-3cd0-440f-894e-6f0993ae8ffe a=ptime:20 c3169a1c-3cd0-440f-894e-6f0993ae8ffe a=maxptime:230 c3169a1c-3cd0-440f-894e-6f0993ae8ffe c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:3061 Set Codec sofia/internal/0102065021@10.192.0.130:5060 G729/8000 20 ms 160 samples 8000 bits 1 channels c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_codec.c:111 sofia/internal/0102065021@10.192.0.130:5060 Original read codec set to G729:18 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4767 sofia/internal/0102065021@10.192.0.130:5060 Set 2833 dtmf send payload to 101 recv payload to 101 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/internal/0102065021@10.192.0.130:5060] 154.118.252.36 port 27272 -> 10.192.0.130 port 13936 codec: 18 ms: 20 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_rtp.c:4111 Starting timer [soft] 160 bytes per 20ms c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:7179 sofia/internal/0102065021@10.192.0.130:5060 Set 2833 dtmf send payload to 101 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:7186 sofia/internal/0102065021@10.192.0.130:5060 Set 2833 dtmf receive payload to 101 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:7209 sofia/internal/0102065021@10.192.0.130:5060 Set rtp dtmf delay to 40 c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [NOTICE] sofia_media.c:92 Pre-Answer sofia/internal/0102065021@10.192.0.130:5060! c3169a1c-3cd0-440f-894e-6f0993ae8ffe 2018-07-13 11:35:01.884240 [DEBUG] switch_channel.c:3474 (sofia/internal/0102065021@10.192.0.130:5060) Callstate Change RINGING -> EARLY 2018-07-13 11:35:01.884240 [DEBUG] sofia.c:2442 Re-attaching to session 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [NOTICE] mod_sofia.c:2273 Ring-Ready sofia/external/+27837225168@154.118.252.35! c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] sofia.c:7084 Channel sofia/external/+27837225168@154.118.252.35 entering state [early][180] c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [NOTICE] switch_ivr_originate.c:525 Ring Ready sofia/external/+27837225168@154.118.252.35! c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] switch_ivr_originate.c:410 Setting codec string on sofia/external/+27837225168@154.118.252.35 to G729@8000h@20i c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [INFO] switch_ivr_originate.c:3654 Sending early media c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1] c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 101@8000 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] switch_core_media.c:3061 Set Codec sofia/external/+27837225168@154.118.252.35 G729/8000 20 ms 160 samples 8000 bits 1 channels c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.884240 [DEBUG] switch_core_codec.c:111 sofia/external/+27837225168@154.118.252.35 Original read codec set to G729:18 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 101@8000 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_core_media.c:4767 sofia/external/+27837225168@154.118.252.35 Set 2833 dtmf send payload to 101 recv payload to 101 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_core_media.c:6878 AUDIO RTP [sofia/external/+27837225168@154.118.252.35] 154.118.252.36 port 29692 -> 154.118.252.38 port 38932 codec: 18 ms: 20 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_rtp.c:4111 Starting timer [soft] 160 bytes per 20ms c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_core_media.c:7179 sofia/external/+27837225168@154.118.252.35 Set 2833 dtmf send payload to 101 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_core_media.c:7186 sofia/external/+27837225168@154.118.252.35 Set 2833 dtmf receive payload to 101 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [DEBUG] switch_core_media.c:7209 sofia/external/+27837225168@154.118.252.35 Set rtp dtmf delay to 40 c866212e-fe16-48bb-bfdf-ea1aa1d56509 2018-07-13 11:35:01.924239 [NOTICE] sofia_media.c:92 Pre-Answer sofia/external/+27837225168@154.118.252.35! -- 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [INFO] mod_dialplan_xml.c:637 Processing Andrew Colin <27105914607>->0114620900 in context cgrtbilling 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za parsing [cgrtbilling->unloop] continue=false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (PASS) [unloop] ${unroll_loops}(true) =~ /^true$/ break=on-false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (FAIL) [unloop] ${sip_looped_call}() =~ /^true$/ break=on-false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za parsing [cgrtbilling->call_debug] continue=true 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (FAIL) [call_debug] ${call_debug}(false) =~ /^true$/ break=never 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za parsing [cgrtbilling->block_account] continue=false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (FAIL) [block_account] destination_number(0114620900) =~ /^(block_account)$/ break=on-false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za parsing [cgrtbilling->check_auth] continue=true 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (PASS) [check_auth] ${sip_authorized}(true) =~ /^true$/ break=never 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za parsing [cgrtbilling->calls_from_converged] continue=true 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (PASS) [calls_from_converged] ${sip_req_host}(sbc.convergedgroup.co.za) =~ /^sbc.convergedgroup.co.za$/ break=on-false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: Processing recursive conditions level:1 [calls_from_converged_recur_1] require-nested=TRUE 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (PASS) [calls_from_converged_recur_1] destination_number(0114620900) =~ /^(.*)$/ break=on-false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action translate(${destination_number} sbc.convergedgroup.co.za-za) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action set(destination_number=${translated}) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action set(outside_call=true) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action set(lnp_dest_num=${lua(cgrtbilling/sa_lnp_lookup.lua ${destination_number})}) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 |--- Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action lua(cgrtbilling/cgrtbilling_v2.luac) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za parsing [cgrtbilling->calls_from_tenants] continue=true 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Regex (PASS) [calls_from_tenants] destination_number(0114620900) =~ /^(.*)$/ break=on-false 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action translate(${destination_number} sbc.convergedgroup.co.za-za) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action set(destination_number=${translated}) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action set(outside_call=true) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 Dialplan: sofia/internal/27105914607@sbc.convergedgroup.co.za Action lua(cgrtbilling/cgrtbilling_v2.luac) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] switch_core_state_machine.c:286 (sofia/internal/27105914607@sbc.convergedgroup.co.za) State Change CS_ROUTING -> CS_EXECUTE 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] switch_core_state_machine.c:643 (sofia/internal/27105914607@sbc.convergedgroup.co.za) State ROUTING going to sleep 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] switch_core_state_machine.c:584 (sofia/internal/27105914607@sbc.convergedgroup.co.za) Running State Change CS_EXECUTE (Cur 622 Tot 1557932) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] switch_core_state_machine.c:650 (sofia/internal/27105914607@sbc.convergedgroup.co.za) State EXECUTE 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] mod_sofia.c:198 sofia/internal/27105914607@sbc.convergedgroup.co.za SOFIA EXECUTE 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] switch_core_state_machine.c:328 sofia/internal/27105914607@sbc.convergedgroup.co.za Standard EXECUTE 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za translate(0114620900 sbc.convergedgroup.co.za-za) 2018-07-13 11:35:01.924239 [DEBUG] mod_translate.c:128 translating [0114620900] against [sbc.convergedgroup.co.za-za] profile 2018-07-13 11:35:01.924239 [DEBUG] mod_translate.c:137 0114620900 =~ /^\+(\d+)$/ 2018-07-13 11:35:01.924239 [DEBUG] mod_translate.c:137 0114620900 =~ /^(00\d{9,17})$/ 2018-07-13 11:35:01.924239 [DEBUG] mod_translate.c:137 0114620900 =~ /^0(\d+)$/ 2018-07-13 11:35:01.924239 [NOTICE] mod_translate.c:249 Translated: 27114620900 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za set(destination_number=27114620900) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] mod_dptools.c:1548 SET sofia/internal/27105914607@sbc.convergedgroup.co.za [destination_number]=[27114620900] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za set(outside_call=true) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.924239 [DEBUG] mod_dptools.c:1548 SET sofia/internal/27105914607@sbc.convergedgroup.co.za [outside_call]=[true] 2018-07-13 11:35:01.924239 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7fa889421220 Connected. 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 The number was ported to ECN with DCode D001 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(lnp_enabled, true) 2018-07-13 11:35:01.944239 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7fa889421220 released. 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:1112 sofia/internal/27105914607@sbc.convergedgroup.co.za destroy/unlink session from object 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za set(lnp_dest_num=D00127114620900) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1548 SET sofia/internal/27105914607@sbc.convergedgroup.co.za [lnp_dest_num]=[D00127114620900] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za lua(cgrtbilling/cgrtbilling_v2.luac) 2018-07-13 11:35:01.944239 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7fa888e89850 Connected. 2018-07-13 11:35:01.944239 [INFO] switch_cpp.cpp:1365 Destination_number: 27114620900<----------- 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 SELECT mc.id, mc.name, mc.account_type, mc.account_code, b.balance_uuid, b.value as balance, t.name as tenant, mc.origination, mc.orig_credit_limit, mc.max_per_minute_rate as max_rate, mc.max_daily_spend, mc.play_audio_messages as play_msgs, mc.orig_max_channels as max_channels, mc.orig_max_cps as max_cps, tc.max_call_length as max_duration, mc.enable_calls, mc.enabled FROM management_client mc INNER JOIN management_tenant t ON t.id = mc.tenant_id INNER JOIN management_tenantconfiguration tc ON ( t.id = tc.tenant_id ) INNER JOIN management_clientbalances b ON mc.id = b.client_id WHERE mc.account_code = '4597204894' AND b.balance_type = '*monetary' AND weight = '10' 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 <-------> Enable calls: 1 ----- 2018-07-13 11:35:01.944239 [WARNING] switch_cpp.cpp:1365 <------- Getting Account Info for Client: Converged Telecoms with account_code: 4597204894 -------> 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 SELECT mc.account_code, s.username, s.password, s.ip_address, s.caller_id_name as cid_name, s.caller_id_number as cid_number, s.bypass_media as bymedia, s.pass_thru_caller_id, s.custom_sip_headers, c1.description as c1, c2.description as c2, c3.description as c3, c4.description as c4, s.enabled FROM management_sipaccount s INNER JOIN management_client mc ON s.client_id = mc.id LEFT OUTER JOIN configuration_codecpreference c1 ON s.codec1_id = c1.id LEFT OUTER JOIN configuration_codecpreference c2 ON s.codec2_id = c2.id LEFT OUTER JOIN configuration_codecpreference c3 ON s.codec3_id = c3.id LEFT OUTER JOIN configuration_codecpreference c4 ON s.codec4_id = c4.id WHERE mc.id = '1740885166862658' AND s.username = 'convergedjhb'AND s.enabled = 't' 2018-07-13 11:35:01.944239 [WARNING] switch_cpp.cpp:1365 elapsed time: 0.004478 2018-07-13 11:35:01.944239 [WARNING] switch_cpp.cpp:1365 -------------> Geting Client Tariff Plan info -------------> 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 SELECT mt.tech_prefix, mt.tpb_id, t.name as tpb_name, mt.routing_plan_id, r.routing_type, r.allow_negative_profit FROM management_tpballocation mt INNER JOIN management_client mc ON mt.client_id = mc.id INNER JOIN routing_routingplan r ON mt.routing_plan_id = r.id INNER JOIN tariff_plans_tpb t ON t.id = mt.tpb_id WHERE mc.account_code = '4597204894' 2018-07-13 11:35:01.944239 [INFO] switch_cpp.cpp:1365 <-----------------------------------------------------> 2018-07-13 11:35:01.944239 [INFO] switch_cpp.cpp:1365 Trying without tech prefix 2018-07-13 11:35:01.944239 [INFO] switch_cpp.cpp:1365 Dialed number : 27114620900 2018-07-13 11:35:01.944239 [INFO] switch_cpp.cpp:1365 Tariff Plan Name : SPECIAL_CUST 2018-07-13 11:35:01.944239 [INFO] switch_cpp.cpp:1365 <-----------------------------------------------------> 2018-07-13 11:35:01.944239 [WARNING] switch_cpp.cpp:1365 ------------ Getting Call cost for client ------------ 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 SELECT tp.code, tp.destination_name, tp.connect_fee, tp.rate, tp.rate_minimum, tp.rate_increment, tp.effective_date, tp.expiry_date, tp.enabled FROM tariff_plans_rates tp WHERE code @> '27114620900' AND tpb_id = '4566351673973515' AND tp.effective_date <= tp.expiry_date AND tp.expiry_date >= now() ORDER BY CODE ASC LIMIT 1 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 Code: 2711 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za export(execute_on_answer=nibblebill adjust -0) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [execute_on_answer]=[nibblebill adjust -0] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(connect_fee, 0) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(nibble_rate, 0.12) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(nibble_minimum, 0.002) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(nibble_increment, 1) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(nibble_account, 9D589CB4-4BC5-4DBF-AC0D-67E9D0C666B3) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_account, 4597204894) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(client_id, 1740885166862658) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_tenant, sbc.convergedgroup.co.za) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(nobal_amt, -5000) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za nibblebill(heartbeat 60) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [WARNING] switch_core_session.c:1605 sofia/internal/27105914607@sbc.convergedgroup.co.za using scheduler due to bypass media or media is not established. 2018-07-13 11:35:01.944239 [DEBUG] switch_scheduler.c:249 Added task 3750960 switch_core_session_sched_heartbeat (5be1f9f2-3bc4-489a-8a78-622a7a4dc644) to run at 1531474561 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_dept, ) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_site, ) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_extension, ) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_custom, ) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_subject, ) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_supplier, ) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_reqtype, POSTPAID) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(o_category, SPECIAL_CUST) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(prefix, 2711) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(destination_name, SA National_2711) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(destination_number, 27114620900) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(tor, *voice) 2018-07-13 11:35:01.944239 [WARNING] switch_cpp.cpp:1365 -------------> Removing unwanted SIP Headers -------------> 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za unset(sip_h_X-accountcode) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1693 UNSET [sip_h_X-accountcode] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za unset(sip_h_X-username) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1693 UNSET [sip_h_X-username] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za unset(sip_h_X-extension) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1693 UNSET [sip_h_X-extension] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za unset(sip_h_X-dept) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1693 UNSET [sip_h_X-dept] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za unset(sip_h_X-site) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1693 UNSET [sip_h_X-site] 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 EXECUTE sofia/internal/27105914607@sbc.convergedgroup.co.za unset(sip_h_X-custom) 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.944239 [DEBUG] mod_dptools.c:1693 UNSET [sip_h_X-custom] 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 Checking if 27114620900 is a DID <------------- 2018-07-13 11:35:01.944239 [NOTICE] switch_cpp.cpp:1365 SELECT status from management_did where did_number = '27114620900' and status != 'ported_out'2018-07-13 11:35:01.964238 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7fa888e89850 released. 2018-07-13 11:35:01.964238 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7fa888e89850 Connected. 2018-07-13 11:35:01.964238 [WARNING] switch_cpp.cpp:1365 ------------ Getting LCR info ------------ 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 SELECT * FROM (SELECT DISTINCT ON (t.name) t.name as tariff_plan, rt.id AS rt_id, r.code, r.destination_name, r.connect_fee, r.rate, r.rate_minimum, r.rate_increment, t.prefix, t.suffix, t.quality, t.reliability, t.client_id AS carrier_id, r.effective_date, r.expiry_date, t.gw1_id, t.gw2_id, t.gw3_id, r.enabled FROM tariff_plans_rates r INNER JOIN tariff_plans_tpb t ON r.tpb_id = t.id INNER JOIN routing_routingplantariff rt ON rt.tariff_plan_id = t.id WHERE rt.routing_plan_id = '1947940545902389' AND code @> 'D00127114620900' AND enabled = 't' AND (CURRENT_TIMESTAMP BETWEEN r.effective_date AND r.expiry_date) ORDER BY t.name, code ASC, "effective_date" DESC) n ORDER BY rate ASC, quality DESC, reliability DESC 2018-07-13 11:35:01.964238 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7fa888e89850 released. 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ------------------ No of routes found: 2 ------------------ 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 -------> lcr_profile: lc 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 -------> lcr_allow_negative_profit: 0.00 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ----------------------- Route [ 1 of 2 ] ----------------------- 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_code[1]: D001 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_destination_name[1]: ECN 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_connect_fee[1]: 0.00000 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_rate[1]: 0.16000 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_rate_minimum[1]: 1 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_rate_increment[1]: 1 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_prefix[1]: 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_tariff_plan[1]: LIQUIDTEL_NAT 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_carrier_id[1]: 937975527397526 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_effective_date[1]: 2017-09-24 21:50:39.307041 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_expiry_date[1]: 2027-09-24 21:50:40.264676 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_enabled[1]: 1 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ------------------------------------------------------------------ 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ----------------------- Route [ 2 of 2 ] ----------------------- 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_code[2]: D001 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_destination_name[2]: ECN 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_connect_fee[2]: 0.00000 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_rate[2]: 0.18000 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_rate_minimum[2]: 1 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_rate_increment[2]: 1 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_prefix[2]: 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_tariff_plan[2]: TELKOM_NAT 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_carrier_id[2]: 946479979601305 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_effective_date[2]: 2017-09-24 21:50:00 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_expiry_date[2]: 2027-09-24 21:50:00 2018-07-13 11:35:01.964238 [NOTICE] switch_cpp.cpp:1365 -------> lcr_enabled[2]: 1 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ------------------------------------------------------------------ 5be1f9f2-3bc4-489a-8a78-622a7a4dc644 2018-07-13 11:35:01.964238 [DEBUG] switch_cpp.cpp:745 CoreSession::setVariable(sip_h_X-cid, vCWfuMQ_ORE85u6iuhgu9w..) 2018-07-13 11:35:01.964238 [WARNING] switch_cpp.cpp:1365 ------->5be1f9f2-3bc4-489a-8a78-622a7a4dc644 - WS CALL Set value :.....: sip_h_X-cid vCWfuMQ_ORE85u6iuhgu9w..<------------- 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ----------> Call progressing through the diaplan <---------- 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 --------------------- Customer rate: 0.12 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ----------- Negative profit allowed: 0.00% 2018-07-13 11:35:01.964238 [INFO] switch_cpp.cpp:1365 ---- Maximum provider rate fo