[This app Best viewed at 160x60 or more..] +OK log level [7] 2022-05-10 13:27:55.221569 98.13% [NOTICE] switch_channel.c:1123 New Channel sofia/default/8871343676@46.101.114.158 [cfcc5321-bbc4-4d48-9f50-73113573a312] 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_NEW (Cur 1 Tot 55) 2022-05-10 13:27:55.221569 98.13% [INFO] sofia.c:10462 sofia/default/8871343676@46.101.114.158 receiving invite from 46.101.114.158:5077 version: 1.10.7 -release-19-883d2cb662 64bit call-id: d75c7d05-4b07-123b-a087-ba05d31eb9f9 2022-05-10 13:27:55.221569 98.13% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 46.101.114.158:0. 2022-05-10 13:27:55.221569 98.13% [DEBUG] sofia.c:10585 IP 46.101.114.158 Approved by acl "default[]". Access Granted. 2022-05-10 13:27:55.221569 98.13% [DEBUG] sofia.c:7499 Channel sofia/default/8871343676@46.101.114.158 entering state [received][100] 2022-05-10 13:27:55.221569 98.13% [DEBUG] sofia.c:7509 Remote SDP: v=0 o=FreeSWITCH 1652171831 1652171832 IN IP4 46.101.114.158 s=FreeSWITCH c=IN IP4 46.101.114.158 t=0 0 m=audio 17444 RTP/AVP 0 101 a=rtpmap:0 PCMU/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=ptime:20 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/8871343676@46.101.114.158 PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_codec.c:111 sofia/default/8871343676@46.101.114.158 Original read codec set to PCMU:0 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_media.c:5973 sofia/default/8871343676@46.101.114.158 Set 2833 dtmf send payload to 101 recv payload to 101 2022-05-10 13:27:55.221569 98.13% [DEBUG] sofia.c:7933 (sofia/default/8871343676@46.101.114.158) State Change CS_NEW -> CS_INIT 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8871343676@46.101.114.158) State NEW 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_INIT (Cur 1 Tot 55) 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8871343676@46.101.114.158) State INIT 2022-05-10 13:27:55.221569 98.13% [DEBUG] mod_sofia.c:97 sofia/default/8871343676@46.101.114.158 SOFIA INIT 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:40 sofia/default/8871343676@46.101.114.158 Standard INIT 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8871343676@46.101.114.158) State Change CS_INIT -> CS_ROUTING 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8871343676@46.101.114.158) State INIT going to sleep 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_ROUTING (Cur 1 Tot 55) 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_channel.c:2380 (sofia/default/8871343676@46.101.114.158) Callstate Change DOWN -> RINGING 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8871343676@46.101.114.158) State ROUTING 2022-05-10 13:27:55.221569 98.13% [DEBUG] mod_sofia.c:158 sofia/default/8871343676@46.101.114.158 SOFIA ROUTING 2022-05-10 13:27:55.221569 98.13% [DEBUG] switch_core_state_machine.c:230 sofia/default/8871343676@46.101.114.158 Standard ROUTING 2022-05-10 13:27:55.221569 98.13% [INFO] mod_dialplan_xml.c:639 Processing Prashant Kumar <8871343676>->7701111 in context default 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code') 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.241538 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2022-05-10 13:27:55.241538 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 7701111 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '7701111' limit 1 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '7701111' AND status=0 limit 1 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '7701111' and status=0 LIMIT 1 2022-05-10 13:27:55.241538 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+PKGatewayDefault 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = '3.7.66.233' limit 1 2022-05-10 13:27:55.241538 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : Prashant Kumar / 8871343676 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 770111 AND status=0 limit 1 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.241538 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("46.101.114.158") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "7701111" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7073582043] 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7073582043" AND deleted = 0 limit 1 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =5 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="7701111" AND (accountid = 0 OR status = 1) LIMIT 1 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 5 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^7701111.*' OR patterns = '^770111.*' OR patterns = '^77011.*' OR patterns = '^7701.*' OR patterns = '^770.*' OR patterns = '^77.*' OR patterns = '^7.*' OR patterns ='--') AND accountid = 5 ORDER BY LENGTH(PKGPTR.patterns) DESC 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="7701111" AND A.accountid = '9' limit 1 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 7701111 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '7701111' OR number = '770111' OR number = '77011' OR number = '7701' OR number = '770' OR number = '77' OR number = '7' OR number ='--') OR (number = '7701111*' OR number = '770111*' OR number = '77011*' OR number = '7701*' OR number = '770*' OR number = '77*' OR number = '7*' OR number ='--') OR (number = '8871343676' OR number = '887134367' OR number = '88713436' OR number = '8871343' OR number = '887134' OR number = '88713' OR number = '8871' OR number = '887' OR number = '88' OR number = '8' OR number ='--') OR (number = '8871343676*' OR number = '887134367*' OR number = '88713436*' OR number = '8871343*' OR number = '887134*' OR number = '88713*' OR number = '8871*' OR number = '887*' OR number = '88*' OR number = '8*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '7701111' OR routing_prefix = '770111' OR routing_prefix = '77011' OR routing_prefix = '7701' OR routing_prefix = '770' OR routing_prefix = '77' OR routing_prefix = '7' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 9 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7073582043 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =5 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 9854.8 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2022-05-10 13:27:55.261536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2022-05-10 13:27:55.261536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.00000 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '1' and status=0 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.00000 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 1 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 7701111 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 9 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =5 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your9854.8 balance Accountid 9 !!! 2022-05-10 13:27:55.281572 98.13% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 10000 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 1000 minutes 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 9 AND status=0 LIMIT 1 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "5" AND deleted = 0 limit 1 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:9 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:9 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 9 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 5 limit 1 2022-05-10 13:27:55.281572 98.13% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : w07version63.astppbilling.org 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 1000 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2022-05-10 13:27:55.281572 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "7700999200" AND accounts.status = 0 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 5 limit 1 2022-05-10 13:27:55.281572 98.13% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : w07version63.astppbilling.org 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 5 and status = 0 limit 1 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_4 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/8871343676@46.101.114.158 parsing [default->7701111] continue=false Dialplan: sofia/default/8871343676@46.101.114.158 Regex (PASS) [7701111] destination_number(7701111) =~ /7701111/ break=on-false Dialplan: sofia/default/8871343676@46.101.114.158 Action set(effective_destination_number=7701111) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(bridge_pre_execute_bleg_app=sched_hangup) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(bridge_pre_execute_bleg_data=+60000 normal_clearing) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(callstart=2022-05-10 13:27:55) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(hangup_after_bridge=true) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(account_id=9) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(parent_id=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(entity_id=3) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(call_processed=internal) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(call_direction=inbound) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(accountname=Entdemo) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(origination_rates_did=ID:1|CODE:^7701111.*|DESTINATION:7701111|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:88|ACCID:5) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(origination_rates=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(original_caller_id_name=Prashant Kumar) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(original_caller_id_number=8871343676) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(effective_caller_id_name=Prashant Kumar) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(effective_caller_id_number=8871343676) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(receiver_accid=5) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_id=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(transfer_call_type=5) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(transfer_extensions=9998913660) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(busy_status=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(no_answer_status=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(always_status=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(transfer_status=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(variable_sip_to_host=${domain_name}) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(variable_sip_network_ip=46.101.114.158) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(variable_sip_network_port=5077) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(domain_name=w07version63.astppbilling.org) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(sip_to_host=w07version63.astppbilling.org) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(presence_data=x|||Reseller Customer(9998913119)|||||||||DID|||46.101.114.158) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(call_type=4) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(calltype=STANDARD) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(accountcode=9998913119) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(caller_did_account_id=9) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_number=7701111) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_init_inc=60) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_inc=60) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_cost=0.00000) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_connectcost=0.00000) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(origination_rates_did=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_id=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action transfer(7700999200 XML default) 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8871343676@46.101.114.158) State Change CS_ROUTING -> CS_EXECUTE 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8871343676@46.101.114.158) State ROUTING going to sleep 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_EXECUTE (Cur 1 Tot 55) 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8871343676@46.101.114.158) State EXECUTE 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_sofia.c:213 sofia/default/8871343676@46.101.114.158 SOFIA EXECUTE 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_core_state_machine.c:323 sofia/default/8871343676@46.101.114.158 Standard EXECUTE EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(effective_destination_number=7701111) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [effective_destination_number]=[7701111] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(bridge_pre_execute_bleg_app=sched_hangup) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [bridge_pre_execute_bleg_app]=[sched_hangup] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(bridge_pre_execute_bleg_data=+60000 normal_clearing) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [bridge_pre_execute_bleg_data]=[+60000 normal_clearing] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(callstart=2022-05-10 13:27:55) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [callstart]=[2022-05-10 13:27:55] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(hangup_after_bridge=true) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [hangup_after_bridge]=[true] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(continue_on_fail=TRUE) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [continue_on_fail]=[TRUE] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(account_id=9) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [account_id]=[9] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(parent_id=0) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [parent_id]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(entity_id=3) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [entity_id]=[3] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(call_processed=internal) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [call_processed]=[internal] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(call_direction=inbound) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [call_direction]=[inbound] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(accountname=Entdemo) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [accountname]=[Entdemo] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(origination_rates_did=ID:1|CODE:^7701111.*|DESTINATION:7701111|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:88|ACCID:5) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [origination_rates_did]=[ID:1|CODE:^7701111.*|DESTINATION:7701111|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:88|ACCID:5] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(origination_rates=0) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [origination_rates]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(original_caller_id_name=Prashant Kumar) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [original_caller_id_name]=[Prashant Kumar] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(original_caller_id_number=8871343676) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [original_caller_id_number]=[8871343676] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(effective_caller_id_name=Prashant Kumar) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [effective_caller_id_name]=[Prashant Kumar] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(effective_caller_id_number=8871343676) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [effective_caller_id_number]=[8871343676] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(receiver_accid=5) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [receiver_accid]=[5] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_id=1) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_id]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(transfer_call_type=5) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [transfer_call_type]=[5] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(transfer_extensions=9998913660) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [transfer_extensions]=[9998913660] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(busy_status=0) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [busy_status]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(no_answer_status=1) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [no_answer_status]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(always_status=1) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [always_status]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(transfer_status=0) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [transfer_status]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(variable_sip_to_host=172.31.14.218) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [variable_sip_to_host]=[172.31.14.218] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(variable_sip_network_ip=46.101.114.158) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [variable_sip_network_ip]=[46.101.114.158] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(variable_sip_network_port=5077) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [variable_sip_network_port]=[5077] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(domain_name=w07version63.astppbilling.org) 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[w07version63.astppbilling.org] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(sip_to_host=w07version63.astppbilling.org) 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[w07version63.astppbilling.org] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(presence_data=x|||Reseller Customer(9998913119)|||||||||DID|||46.101.114.158) 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||Reseller Customer(9998913119)|||||||||DID|||46.101.114.158] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(call_type=4) 2022-05-10 13:27:55.281572 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[4] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(calltype=STANDARD) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [calltype]=[STANDARD] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(accountcode=9998913119) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [accountcode]=[9998913119] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(caller_did_account_id=9) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [caller_did_account_id]=[9] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_number=7701111) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_number]=[7701111] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_init_inc=60) 2022-05-10 13:27:55.281572 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_init_inc]=[60] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_inc=60) 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_inc]=[60] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_cost=0.00000) 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_cost]=[0.00000] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_connectcost=0.00000) 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_connectcost]=[0.00000] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(origination_rates_did=0) 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [origination_rates_did]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_id=1) 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_id]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 transfer(7700999200 XML default) 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_ivr.c:2289 (sofia/default/8871343676@46.101.114.158) State Change CS_EXECUTE -> CS_ROUTING 2022-05-10 13:27:55.301536 98.13% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/8871343676@46.101.114.158 to XML[7700999200@default] 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8871343676@46.101.114.158) State EXECUTE going to sleep 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_ROUTING (Cur 1 Tot 55) 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8871343676@46.101.114.158) State ROUTING 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged 2022-05-10 13:27:55.301536 98.13% [DEBUG] mod_sofia.c:158 sofia/default/8871343676@46.101.114.158 SOFIA ROUTING 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_core_state_machine.c:230 sofia/default/8871343676@46.101.114.158 Standard ROUTING 2022-05-10 13:27:55.301536 98.13% [INFO] mod_dialplan_xml.c:639 Processing Prashant Kumar <8871343676>->7700999200 in context default 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code') 2022-05-10 13:27:55.301536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.321536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2022-05-10 13:27:55.321536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 7700999200 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '7700999200' limit 1 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '7700999200' AND status=0 limit 1 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '7700999200' and status=0 LIMIT 1 2022-05-10 13:27:55.321536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+PKGatewayDefault 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'w07version63.astppbilling.org' limit 1 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '5' and username = '7700999200' limit 1 2022-05-10 13:27:55.321536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : Prashant Kumar / 8871343676 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 9200 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 770099 AND status=0 limit 1 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7700999200" LIMIT 1 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7700999200" LIMIT 1 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="7700999200" AND domains.domain="w07version63.astppbilling.org" limit 1 2022-05-10 13:27:55.321536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound 2022-05-10 13:27:55.321536 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9998913119] 2022-05-10 13:27:55.321536 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9998913119" AND deleted = 0 limit 1 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^7700999200.*' OR blocked_patterns = '^770099920.*' OR blocked_patterns = '^77009992.*' OR blocked_patterns = '^7700999.*' OR blocked_patterns = '^770099.*' OR blocked_patterns = '^77009.*' OR blocked_patterns = '^7700.*' OR blocked_patterns = '^770.*' OR blocked_patterns = '^77.*' OR blocked_patterns = '^7.*' OR blocked_patterns ='--') AND accountid = 5 limit 1 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="7700999200" AND (accountid = 0 OR status = 1) LIMIT 1 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^7700999200.*' OR patterns = '^770099920.*' OR patterns = '^77009992.*' OR patterns = '^7700999.*' OR patterns = '^770099.*' OR patterns = '^77009.*' OR patterns = '^7700.*' OR patterns = '^770.*' OR patterns = '^77.*' OR patterns = '^7.*' OR patterns ='--') AND accountid = 5 ORDER BY LENGTH(PKGPTR.patterns) DESC 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="7700999200" AND A.accountid = '5' limit 1 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 7700999200 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7700999200" LIMIT 1 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7700999200" LIMIT 1 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="7700999200" AND domains.domain="w07version63.astppbilling.org" limit 1 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '7700999200' OR number = '770099920' OR number = '77009992' OR number = '7700999' OR number = '770099' OR number = '77009' OR number = '7700' OR number = '770' OR number = '77' OR number = '7' OR number ='--') OR (number = '7700999200*' OR number = '770099920*' OR number = '77009992*' OR number = '7700999*' OR number = '770099*' OR number = '77009*' OR number = '7700*' OR number = '770*' OR number = '77*' OR number = '7*' OR number ='--') OR (number = '8871343676' OR number = '887134367' OR number = '88713436' OR number = '8871343' OR number = '887134' OR number = '88713' OR number = '8871' OR number = '887' OR number = '88' OR number = '8' OR number ='--') OR (number = '8871343676*' OR number = '887134367*' OR number = '88713436*' OR number = '8871343*' OR number = '887134*' OR number = '88713*' OR number = '8871*' OR number = '887*' OR number = '88*' OR number = '8*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '7700999200' OR routing_prefix = '770099920' OR routing_prefix = '77009992' OR routing_prefix = '7700999' OR routing_prefix = '770099' OR routing_prefix = '77009' OR routing_prefix = '7700' OR routing_prefix = '770' OR routing_prefix = '77' OR routing_prefix = '7' OR routing_prefix ='--') AND status = 0 and reseller_id = 4 limit 1 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 5 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9998913119 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 9854.8 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid] 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 2 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 2 AND status = 0 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 2 AND status = 0 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^7700999200.*' OR pattern = '^770099920.*' OR pattern = '^77009992.*' OR pattern = '^7700999.*' OR pattern = '^770099.*' OR pattern = '^77009.*' OR pattern = '^7700.*' OR pattern = '^770.*' OR pattern = '^77.*' OR pattern = '^7.*' OR pattern ='--') AND (caller_id_pattern = '^8871343676.*' OR caller_id_pattern = '^887134367.*' OR caller_id_pattern = '^88713436.*' OR caller_id_pattern = '^8871343.*' OR caller_id_pattern = '^887134.*' OR caller_id_pattern = '^88713.*' OR caller_id_pattern = '^8871.*' OR caller_id_pattern = '^887.*' OR caller_id_pattern = '^88.*' OR caller_id_pattern = '^8.*' OR caller_id_pattern ='^.*') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 2 OR accountid=5) ORDER BY accountid DESC,LENGTH(pattern),LENGTH(caller_id_pattern) DESC,cost DESC,effective_date DESC LIMIT 1 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : outbound 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.60000 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:2 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '2' and status=0 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] holiday_based_routing : 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Query :SELECT gmttime from timezone where id = '118' 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Data :GMT+00:00 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Plus timezone 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -05:00 : 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_date:10 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_month:May 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :10-5 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :1 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] demand_based_condition : 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT gmttime from timezone where id = '118' 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Data :GMT+00:00 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Plus timezone 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If timezone like = +05:00 : 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted current_time: 13.27 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] current_wday :Tue 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Current Day Number3 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :-7 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.60000 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 3 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.60000 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : Mexico City 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 124 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 5 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID: 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type: 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2022-05-10 13:27:55.341541 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your9854.8 balance Accountid 5 !!! 2022-05-10 13:27:55.341541 98.13% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 1000 mins! 2022-05-10 13:27:55.341541 98.13% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 4 2022-05-10 13:27:55.341541 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "4" AND deleted = 0 limit 1 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^7700999200.*' OR blocked_patterns = '^770099920.*' OR blocked_patterns = '^77009992.*' OR blocked_patterns = '^7700999.*' OR blocked_patterns = '^770099.*' OR blocked_patterns = '^77009.*' OR blocked_patterns = '^7700.*' OR blocked_patterns = '^770.*' OR blocked_patterns = '^77.*' OR blocked_patterns = '^7.*' OR blocked_patterns ='--') AND accountid = 4 limit 1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information =================== 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 4 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9579184285 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 14988.8 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^7700999200.*' OR pattern = '^770099920.*' OR pattern = '^77009992.*' OR pattern = '^7700999.*' OR pattern = '^770099.*' OR pattern = '^77009.*' OR pattern = '^7700.*' OR pattern = '^770.*' OR pattern = '^77.*' OR pattern = '^7.*' OR pattern ='--') AND (caller_id_pattern = '^8871343676.*' OR caller_id_pattern = '^887134367.*' OR caller_id_pattern = '^88713436.*' OR caller_id_pattern = '^8871343.*' OR caller_id_pattern = '^887134.*' OR caller_id_pattern = '^88713.*' OR caller_id_pattern = '^8871.*' OR caller_id_pattern = '^887.*' OR caller_id_pattern = '^88.*' OR caller_id_pattern = '^8.*' OR caller_id_pattern ='^.*') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 1 OR accountid=4) ORDER BY accountid DESC,LENGTH(pattern),LENGTH(caller_id_pattern) DESC,cost DESC,effective_date DESC LIMIT 1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : outbound 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.30000 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '1' and status=0 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.30000 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 6 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.30000 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : Bhopal 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 23 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 4 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID: 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type: 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your14988.8 balance Accountid 4 !!! 2022-05-10 13:27:55.361542 98.13% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 1000 mins! 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:3|CODE:^77.*|DESTINATION:Mexico City|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.60000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|CI:124|ACCID:5||ID:6|CODE:^77.*|DESTINATION:Bhopal|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.30000|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:23|ACCID:4 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 1000 minutes 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id : 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=1 ORDER by id asc 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^7700999200.*' OR pattern = '^770099920.*' OR pattern = '^77009992.*' OR pattern = '^7700999.*' OR pattern = '^770099.*' OR pattern = '^77009.*' OR pattern = '^7700.*' OR pattern = '^770.*' OR pattern = '^77.*' OR pattern = '^7.*' OR pattern ='--') AND TR.status = 0 AND TR.trunk_id IN (1) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information =================== 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 2 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^77.* 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination : QA Sender Your Trucking 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^77.* 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip : 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend : 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : YourProvider 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable : 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway : 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 3 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES======================= 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 5 AND status=0 LIMIT 1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 1000 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2022-05-10 13:27:55.361542 98.13% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : outbound 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from accounts where id = 3) AND status=0 limit 1 2022-05-10 13:27:55.361542 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from trunks where id = 1) AND status=0 limit 1 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701111" LIMIT 1 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DIDQUERY] Query :SELECT * FROM dids WHERE id ="1" and status = 0 limit 1 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/8871343676@46.101.114.158 parsing [default->7700999200] continue=false Dialplan: sofia/default/8871343676@46.101.114.158 Regex (PASS) [7700999200] destination_number(7700999200) =~ /7700999200/ break=on-false Dialplan: sofia/default/8871343676@46.101.114.158 Action set(effective_destination_number=7700999200) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(bridge_pre_execute_bleg_app=sched_hangup) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(bridge_pre_execute_bleg_data=+60000 normal_clearing) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(callstart=2022-05-10 13:27:55) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(hangup_after_bridge=true) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(account_id=5) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(parent_id=4) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(entity_id=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(call_processed=internal) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(call_direction=outbound) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(accountname=default) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(origination_rates=ID:3|CODE:^77.*|DESTINATION:Mexico City|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.60000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|CI:124|ACCID:5||ID:6|CODE:^77.*|DESTINATION:Bhopal|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.30000|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:23|ACCID:4) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(original_caller_id_name=Prashant Kumar) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(original_caller_id_number=8871343676) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(effective_caller_id_name=Prashant Kumar) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(effective_caller_id_number=8871343676) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(calltype=STANDARD) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(termination_rates=ID:2|CODE:^77.*|DESTINATION:QA Sender Your Trucking|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.20000|INC:60|INITIALBLOCK:60|TRUNK:1|PROVIDER:3) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(trunk_id=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(provider_id=3) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(rate_flag=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(force_trunk_flag=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(presence_data=trunk_id=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(intcall=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(presence_id=7700999200) Dialplan: sofia/default/8871343676@46.101.114.158 Action export(presence_data=x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal) Dialplan: sofia/default/8871343676@46.101.114.158 Action bridge({sip_cid_type=none}[leg_timeout=30,absolute_codec_string=^^:PCMA:G729:PCMA]sofia/gateway/YourProvider/7700999200) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(did_id=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(destination_number=7700999200) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(leg_timeout=20) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(call_type_vm_flag=1) Dialplan: sofia/default/8871343676@46.101.114.158 Action set(is_local_extension=0) Dialplan: sofia/default/8871343676@46.101.114.158 Action lua(did_call_forwarding.lua) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8871343676@46.101.114.158) State Change CS_ROUTING -> CS_EXECUTE 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8871343676@46.101.114.158) State ROUTING going to sleep 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_EXECUTE (Cur 1 Tot 55) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8871343676@46.101.114.158) State EXECUTE 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_sofia.c:213 sofia/default/8871343676@46.101.114.158 SOFIA EXECUTE 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:323 sofia/default/8871343676@46.101.114.158 Standard EXECUTE EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(effective_destination_number=7700999200) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [effective_destination_number]=[7700999200] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(bridge_pre_execute_bleg_app=sched_hangup) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [bridge_pre_execute_bleg_app]=[sched_hangup] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(bridge_pre_execute_bleg_data=+60000 normal_clearing) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [bridge_pre_execute_bleg_data]=[+60000 normal_clearing] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(callstart=2022-05-10 13:27:55) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [callstart]=[2022-05-10 13:27:55] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(hangup_after_bridge=true) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [hangup_after_bridge]=[true] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(continue_on_fail=TRUE) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [continue_on_fail]=[TRUE] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(account_id=5) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [account_id]=[5] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(parent_id=4) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [parent_id]=[4] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(entity_id=0) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [entity_id]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(call_processed=internal) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [call_processed]=[internal] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(call_direction=outbound) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [call_direction]=[outbound] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(accountname=default) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [accountname]=[default] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(origination_rates=ID:3|CODE:^77.*|DESTINATION:Mexico City|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.60000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|CI:124|ACCID:5||ID:6|CODE:^77.*|DESTINATION:Bhopal|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.30000|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:23|ACCID:4) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [origination_rates]=[ID:3|CODE:^77.*|DESTINATION:Mexico City|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.60000|INC:60|INITIALBLOCK:60|RATEGROUP:2|MARKUP:0|CI:124|ACCID:5||ID:6|CODE:^77.*|DESTINATION:Bhopal|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.30000|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:23|ACCID:4] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(original_caller_id_name=Prashant Kumar) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [original_caller_id_name]=[Prashant Kumar] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(original_caller_id_number=8871343676) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [original_caller_id_number]=[8871343676] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(effective_caller_id_name=Prashant Kumar) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [effective_caller_id_name]=[Prashant Kumar] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(effective_caller_id_number=8871343676) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [effective_caller_id_number]=[8871343676] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(calltype=STANDARD) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [calltype]=[STANDARD] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(termination_rates=ID:2|CODE:^77.*|DESTINATION:QA Sender Your Trucking|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.20000|INC:60|INITIALBLOCK:60|TRUNK:1|PROVIDER:3) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [termination_rates]=[ID:2|CODE:^77.*|DESTINATION:QA Sender Your Trucking|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.20000|INC:60|INITIALBLOCK:60|TRUNK:1|PROVIDER:3] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(trunk_id=1) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [trunk_id]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(provider_id=3) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [provider_id]=[3] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(rate_flag=0) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [rate_flag]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(force_trunk_flag=0) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [force_trunk_flag]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(presence_data=trunk_id=1) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[trunk_id=1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(intcall=0) 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [intcall]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(presence_id=7700999200) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_id]=[7700999200] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 export(presence_data=x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 bridge({sip_cid_type=none}[leg_timeout=30,absolute_codec_string=^^:PCMA:G729:PCMA]sofia/gateway/YourProvider/7700999200) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [domain_name]=[w07version63.astppbilling.org] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [sip_to_host]=[w07version63.astppbilling.org] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [call_type]=[4] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_id]=[7700999200] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] to event 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_ivr_originate.c:2843 Parsing session specific variables 2022-05-10 13:27:55.381540 98.13% [NOTICE] switch_channel.c:1123 New Channel sofia/default/7700999200 [6a79b9cd-33f9-4f16-842a-18c906834db5] 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_sofia.c:5121 (sofia/default/7700999200) State Change CS_NEW -> CS_INIT 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_ivr_originate.c:3151 sofia/default/7700999200 Setting leg timeout to 30 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7700999200) Running State Change CS_INIT (Cur 2 Tot 56) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7700999200) State INIT 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_sofia.c:97 sofia/default/7700999200 SOFIA INIT 2022-05-10 13:27:55.381540 98.13% [INFO] sofia_glue.c:1651 sofia/default/7700999200 sending invite call-id: (null) 2022-05-10 13:27:55.381540 98.13% [DEBUG] sofia_glue.c:1654 sofia/default/7700999200 sending invite version: 1.10.7 -release-19-883d2cb662 64bit Local SDP: v=0 o=FreeSWITCH 1652164611 1652164612 IN IP4 172.31.14.218 s=FreeSWITCH c=IN IP4 172.31.14.218 t=0 0 m=audio 24664 RTP/AVP 8 18 101 a=rtpmap:8 PCMA/8000 a=rtpmap:18 G729/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 a=sendrecv 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:40 sofia/default/7700999200 Standard INIT 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:48 (sofia/default/7700999200) State Change CS_INIT -> CS_ROUTING 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7700999200) State INIT going to sleep 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7700999200) Running State Change CS_ROUTING (Cur 2 Tot 56) 2022-05-10 13:27:55.381540 98.13% [DEBUG] sofia.c:7499 Channel sofia/default/7700999200 entering state [calling][0] 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7700999200) State ROUTING 2022-05-10 13:27:55.381540 98.13% [DEBUG] mod_sofia.c:158 sofia/default/7700999200 SOFIA ROUTING 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_ivr_originate.c:67 (sofia/default/7700999200) State Change CS_ROUTING -> CS_CONSUME_MEDIA 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7700999200) State ROUTING going to sleep 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7700999200) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 56) 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:659 (sofia/default/7700999200) State CONSUME_MEDIA 2022-05-10 13:27:55.381540 98.13% [DEBUG] switch_core_state_machine.c:659 (sofia/default/7700999200) State CONSUME_MEDIA going to sleep 2022-05-10 13:27:56.261560 97.43% [DEBUG] sofia.c:7499 Channel sofia/default/7700999200 entering state [proceeding][180] 2022-05-10 13:27:56.261560 97.43% [NOTICE] sofia.c:7610 Ring-Ready sofia/default/7700999200! 2022-05-10 13:27:56.261560 97.43% [DEBUG] switch_channel.c:3494 (sofia/default/7700999200) Callstate Change DOWN -> RINGING 2022-05-10 13:27:56.261560 97.43% [NOTICE] mod_sofia.c:2515 Ring-Ready sofia/default/8871343676@46.101.114.158! 2022-05-10 13:27:56.261560 97.43% [DEBUG] sofia.c:7499 Channel sofia/default/8871343676@46.101.114.158 entering state [early][180] 2022-05-10 13:27:56.261560 97.43% [NOTICE] switch_ivr_originate.c:565 Ring Ready sofia/default/8871343676@46.101.114.158! 2022-05-10 13:28:04.621539 96.80% [DEBUG] sofia.c:6678 Remote Reason: 17 2022-05-10 13:28:04.621539 96.80% [DEBUG] sofia.c:7499 Channel sofia/default/7700999200 entering state [terminated][486] 2022-05-10 13:28:04.621539 96.80% [NOTICE] sofia.c:8738 Hangup sofia/default/7700999200 [CS_CONSUME_MEDIA] [USER_BUSY] 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7700999200) Running State Change CS_HANGUP (Cur 2 Tot 56) 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:844 (sofia/default/7700999200) Callstate Change RINGING -> HANGUP 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7700999200) State HANGUP 2022-05-10 13:28:04.621539 96.80% [DEBUG] mod_sofia.c:468 Channel sofia/default/7700999200 hanging up, cause: USER_BUSY 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:59 sofia/default/7700999200 Standard HANGUP, cause: USER_BUSY 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7700999200) State HANGUP going to sleep 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:616 (sofia/default/7700999200) State Change CS_HANGUP -> CS_REPORTING 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7700999200) Running State Change CS_REPORTING (Cur 2 Tot 56) 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7700999200) State REPORTING 2022-05-10 13:28:04.621539 96.80% [INFO] mod_json_cdr.c:271 Process [6a79b9cd-33f9-4f16-842a-18c906834db5.cdr.json] 2022-05-10 13:28:04.621539 96.80% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 17 [USER_BUSY] 2022-05-10 13:28:04.621539 96.80% [INFO] mod_dptools.c:3653 Originate Failed. Cause: USER_BUSY EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(did_id=1) 2022-05-10 13:28:04.621539 96.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [did_id]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(destination_number=7700999200) 2022-05-10 13:28:04.621539 96.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [destination_number]=[7700999200] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(leg_timeout=20) 2022-05-10 13:28:04.621539 96.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [leg_timeout]=[20] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(call_type_vm_flag=1) 2022-05-10 13:28:04.621539 96.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [call_type_vm_flag]=[1] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 set(is_local_extension=0) 2022-05-10 13:28:04.621539 96.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/8871343676@46.101.114.158 [is_local_extension]=[0] EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 lua(did_call_forwarding.lua) 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code') 2022-05-10 13:28:04.641534 96.80% [NOTICE] switch_cpp.cpp:1465 [ASTPP] SECTION 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DID_Call_Forwading] This Is Last Opensips 1 This Is DiD Id : EXECUTE [depth=0] sofia/default/8871343676@46.101.114.158 bridge({ignore_early_media=true,sip_h_P-did_number=7700999200,sip_h_P-call_type='custom_forward',sip_h_P-Accountcode=5}user/9998913660@172.31.14.218) 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [domain_name]=[w07version63.astppbilling.org] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [sip_to_host]=[w07version63.astppbilling.org] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [call_type]=[4] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_id]=[7700999200] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_channel.c:1269 sofia/default/8871343676@46.101.114.158 EXPORTING[export_vars] [presence_data]=[x//4|||Reseller Customer(9998913119)|||^77.* // Mexico City // 0.60000 |||YourTrunk // ^77.* // QA Sender Your Trucking // 0.20000 // trunk_id=1|||STD|||46.101.114.158|||0.30000 // ^77.* // Bhopal] to event 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables 2022-05-10 13:28:04.641534 96.80% [WARNING] mod_dptools.c:4401 Can't find user [9998913660@172.31.14.218] 2022-05-10 13:28:04.641534 96.80% [NOTICE] switch_ivr_originate.c:3039 Cannot create outgoing channel of type [user] cause: [SUBSCRIBER_ABSENT] 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 20 [SUBSCRIBER_ABSENT] 2022-05-10 13:28:04.641534 96.80% [INFO] mod_dptools.c:3653 Originate Failed. Cause: SUBSCRIBER_ABSENT 2022-05-10 13:28:04.641534 96.80% [DEBUG] switch_cpp.cpp:1209 sofia/default/8871343676@46.101.114.158 destroy/unlink session from object 2022-05-10 13:28:04.661534 96.80% [NOTICE] switch_core_state_machine.c:382 sofia/default/8871343676@46.101.114.158 has executed the last dialplan instruction, hanging up. 2022-05-10 13:28:04.661534 96.80% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/8871343676@46.101.114.158 [CS_EXECUTE] [NORMAL_CLEARING] 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8871343676@46.101.114.158) State EXECUTE going to sleep 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_HANGUP (Cur 2 Tot 56) 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8871343676@46.101.114.158) Callstate Change RINGING -> HANGUP 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8871343676@46.101.114.158) State HANGUP 2022-05-10 13:28:04.661534 96.80% [DEBUG] mod_sofia.c:462 sofia/default/8871343676@46.101.114.158 Overriding SIP cause 480 with 486 from the other leg 2022-05-10 13:28:04.661534 96.80% [DEBUG] mod_sofia.c:468 Channel sofia/default/8871343676@46.101.114.158 hanging up, cause: NORMAL_CLEARING 2022-05-10 13:28:04.661534 96.80% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 486 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:59 sofia/default/8871343676@46.101.114.158 Standard HANGUP, cause: NORMAL_CLEARING 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8871343676@46.101.114.158) State HANGUP going to sleep 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8871343676@46.101.114.158) State Change CS_HANGUP -> CS_REPORTING 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8871343676@46.101.114.158) Running State Change CS_REPORTING (Cur 2 Tot 56) 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8871343676@46.101.114.158) State REPORTING 2022-05-10 13:28:04.661534 96.80% [INFO] mod_json_cdr.c:271 Process [cfcc5321-bbc4-4d48-9f50-73113573a312.cdr.json] 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:168 sofia/default/7700999200 Standard REPORTING, cause: USER_BUSY 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7700999200) State REPORTING going to sleep 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:607 (sofia/default/7700999200) State Change CS_REPORTING -> CS_DESTROY 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_session.c:1753 Session 56 (sofia/default/7700999200) Locked, Waiting on external entities 2022-05-10 13:28:04.661534 96.80% [NOTICE] switch_core_session.c:1771 Session 56 (sofia/default/7700999200) Ended 2022-05-10 13:28:04.661534 96.80% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/7700999200 [CS_DESTROY] 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:735 (sofia/default/7700999200) Running State Change CS_DESTROY (Cur 1 Tot 56) 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7700999200) State DESTROY 2022-05-10 13:28:04.661534 96.80% [DEBUG] mod_sofia.c:379 sofia/default/7700999200 SOFIA DESTROY 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:175 sofia/default/7700999200 Standard DESTROY 2022-05-10 13:28:04.661534 96.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7700999200) State DESTROY going to sleep 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:168 sofia/default/8871343676@46.101.114.158 Standard REPORTING, cause: NORMAL_CLEARING 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8871343676@46.101.114.158) State REPORTING going to sleep 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:607 (sofia/default/8871343676@46.101.114.158) State Change CS_REPORTING -> CS_DESTROY 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_session.c:1753 Session 55 (sofia/default/8871343676@46.101.114.158) Locked, Waiting on external entities 2022-05-10 13:28:04.701539 96.80% [NOTICE] switch_core_session.c:1771 Session 55 (sofia/default/8871343676@46.101.114.158) Ended 2022-05-10 13:28:04.701539 96.80% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/8871343676@46.101.114.158 [CS_DESTROY] 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:735 (sofia/default/8871343676@46.101.114.158) Running State Change CS_DESTROY (Cur 0 Tot 56) 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8871343676@46.101.114.158) State DESTROY 2022-05-10 13:28:04.701539 96.80% [DEBUG] mod_sofia.c:379 sofia/default/8871343676@46.101.114.158 SOFIA DESTROY 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:175 sofia/default/8871343676@46.101.114.158 Standard DESTROY 2022-05-10 13:28:04.701539 96.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8871343676@46.101.114.158) State DESTROY going to sleep freeswitch@ip-172-31-14-218> freeswitch@ip-172-31-14-218> freeswitch@ip-172-31-14-218> freeswitch@ip-172-31-14-218> /exit root@ip-172-31-14-218:/home/admin#