freeswitch@devangASTPP> freeswitch@devangASTPP> 2022-08-10 10:04:08.285543 89.73% [NOTICE] switch_channel.c:1123 New Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 [9286459f-0e84-4027-8141-4114255a3130] 2022-08-10 10:04:08.285543 89.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_NEW (Cur 1 Tot 52) 2022-08-10 10:04:08.285543 89.73% [INFO] sofia.c:10462 sofia/default/8822934216@astppqa605.astppbilling.org:5072 receiving invite from 103.240.35.46:56624 version: 1.10.7 -release 64bit call-id: MTYxNDE5ZDEyNzAzMGZkMmJhZjkwODg4ODU5ZDNmMDQ. 2022-08-10 10:04:08.285543 89.73% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0. 2022-08-10 10:04:08.285543 89.73% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [999007070@astppqa605.astppbilling.org] from ip 103.240.35.46 2022-08-10 10:04:08.285543 89.73% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State NEW 2022-08-10 10:04:08.285543 89.73% [DEBUG] sofia.c:2419 detaching session 9286459f-0e84-4027-8141-4114255a3130 2022-08-10 10:04:08.605540 89.73% [DEBUG] sofia.c:2532 Re-attaching to session 9286459f-0e84-4027-8141-4114255a3130 2022-08-10 10:04:08.625543 89.73% [INFO] sofia.c:10462 sofia/default/8822934216@astppqa605.astppbilling.org:5072 receiving invite from 103.240.35.46:56624 version: 1.10.7 -release 64bit call-id: MTYxNDE5ZDEyNzAzMGZkMmJhZjkwODg4ODU5ZDNmMDQ. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:11672 Setting NAT mode based on via received 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:7499 Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 entering state [received][100] 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:7509 Remote SDP: v=0 o=Z 0 0 IN IP4 103.240.35.46 s=Z c=IN IP4 103.240.35.46 t=0 0 m=audio 8000 RTP/AVP 3 110 8 0 98 101 a=rtpmap:110 speex/8000 a=rtpmap:98 iLBC/8000 a=fmtp:98 mode=20 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1] 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/8822934216@astppqa605.astppbilling.org:5072 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_codec.c:111 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Original read codec set to PCMA:8 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5973 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Set 2833 dtmf send payload to 101 recv payload to 101 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:7933 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_NEW -> CS_INIT 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_INIT (Cur 1 Tot 52) 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State INIT 2022-08-10 10:04:08.625543 89.73% [DEBUG] mod_sofia.c:97 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA INIT 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:40 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard INIT 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_INIT -> CS_ROUTING 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State INIT going to sleep 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_ROUTING (Cur 1 Tot 52) 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_channel.c:2380 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Callstate Change DOWN -> RINGING 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State ROUTING 2022-08-10 10:04:08.625543 89.73% [DEBUG] mod_sofia.c:158 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA ROUTING 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:230 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard ROUTING 2022-08-10 10:04:08.625543 89.73% [INFO] mod_dialplan_xml.c:639 Processing 8822934216 <8822934216>->999007070 in context default 2022-08-10 10:04:08.625543 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 999007070 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '999007070' limit 1 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '999007070' and status=0 LIMIT 1 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER8822934216 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '999007070' limit 1 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 8822934216 / 8822934216 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 999007070 AND status=0 limit 1 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2022-08-10 10:04:08.645538 89.73% [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="999007070" AND domains.domain="astppqa605.astppbilling.org" limit 1 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 999001] 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "999001" AND deleted = 0 limit 1 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^999007070.*' OR blocked_patterns = '^99900707.*' OR blocked_patterns = '^9990070.*' OR blocked_patterns = '^999007.*' OR blocked_patterns = '^99900.*' OR blocked_patterns = '^9990.*' OR blocked_patterns = '^999.*' OR blocked_patterns = '^99.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND accountid = 21 limit 1 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2022-08-10 10:04:08.645538 89.73% [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 = '^999007070.*' OR patterns = '^99900707.*' OR patterns = '^9990070.*' OR patterns = '^999007.*' OR patterns = '^99900.*' OR patterns = '^9990.*' OR patterns = '^999.*' OR patterns = '^99.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 21 ORDER BY LENGTH(PKGPTR.patterns) DESC 2022-08-10 10:04:08.645538 89.73% [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 ="999007070" AND A.accountid = '21' limit 1 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 999007070 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2022-08-10 10:04:08.645538 89.73% [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="999007070" AND domains.domain="astppqa605.astppbilling.org" limit 1 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound 2022-08-10 10:04:08.645538 89.73% [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 = '999007070' OR number = '99900707' OR number = '9990070' OR number = '999007' OR number = '99900' OR number = '9990' OR number = '999' OR number = '99' OR number = '9' OR number ='--') OR (number = '999007070*' OR number = '99900707*' OR number = '9990070*' OR number = '999007*' OR number = '99900*' OR number = '9990*' OR number = '999*' OR number = '99*' OR number = '9*' OR number ='--') OR (number = '8822934216' OR number = '882293421' OR number = '88229342' OR number = '8822934' OR number = '882293' OR number = '88229' OR number = '8822' OR number = '882' OR number = '88' OR number = '8' OR number ='--') OR (number = '8822934216*' OR number = '882293421*' OR number = '88229342*' OR number = '8822934*' OR number = '882293*' OR number = '88229*' OR number = '8822*' OR number = '882*' 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-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '999007070' OR routing_prefix = '99900707' OR routing_prefix = '9990070' OR routing_prefix = '999007' OR routing_prefix = '99900' OR routing_prefix = '9990' OR routing_prefix = '999' OR routing_prefix = '99' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 21 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 999001 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 49783.3664 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid] 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 5 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::5 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::5 2022-08-10 10:04:08.665540 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-5 2022-08-10 10:04:09.505553 89.10% [NOTICE] switch_channel.c:1123 New Channel sofia/default/5352@142.132.184.134 [17965cb5-f78e-4e1c-8bc4-3e02c13afe7d] 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5352@142.132.184.134) Running State Change CS_NEW (Cur 2 Tot 53) 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-5 2022-08-10 10:04:09.505553 89.10% [INFO] sofia.c:10462 sofia/default/5352@142.132.184.134 receiving invite from 51.79.18.155:20726 version: 1.10.7 -release 64bit call-id: 9m5sbOrN29OmOyB32znQwo.. 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-5 2022-08-10 10:04:09.505553 89.10% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 51.79.18.155:0. 2022-08-10 10:04:09.505553 89.10% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [+6468827959@142.132.184.134] from ip 51.79.18.155 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_core_state_machine.c:600 (sofia/default/5352@142.132.184.134) State NEW 2022-08-10 10:04:09.505553 89.10% [DEBUG] sofia.c:2419 detaching session 17965cb5-f78e-4e1c-8bc4-3e02c13afe7d 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-08-10 10:04:09 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING] 1=GOT___SUCCESS=pattern::^999.* 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING] 1=GOT___SUCCESS=caller_id_pattern::^.* 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : outbound 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.40000 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:5 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '5' and status=0 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] holiday_based_routing : 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Query :SELECT gmttime from timezone where id = '118' 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Data :GMT+00:00 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Plus timezone 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -05:00 : 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_date:10 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_month:Aug 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :10-8 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :1 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] today_date mday:- 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] demand_based_condition : 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT gmttime from timezone where id = '118' 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Data :GMT+00:00 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Plus timezone 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If timezone like = +05:00 : 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted current_time: 10.04 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] BEFORE current_wday :Wed 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -00:00 : 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted DAY current_wday:Wed 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] AFTER current_wday :Wed 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Current Day Number4 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :-7 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.40000 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 10053 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.40000 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : RSA 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 116 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 21 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID: 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type: 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your49783.3664 balance Accountid 21 !!! 2022-08-10 10:04:09.525536 89.10% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins! 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id : 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=5 ORDER by id asc 2022-08-10 10:04:09.525536 89.10% [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 = '^999007070.*' OR pattern = '^99900707.*' OR pattern = '^9990070.*' OR pattern = '^999007.*' OR pattern = '^99900.*' OR pattern = '^9990.*' OR pattern = '^999.*' OR pattern = '^99.*' OR pattern = '^9.*' OR pattern ='--') AND TR.status = 0 AND TR.trunk_id IN (4) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC 2022-08-10 10:04:09.525536 89.10% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [Dialplan] No Termination Rates Found...!!! 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Post Cdrs : 0 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 21 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 parsing [default->999007070] continue=false Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Regex (PASS) [999007070] destination_number(999007070) =~ /999007070/ break=on-false Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action log(WARNING Accountcode 999001. Dialed number (999007070) termination rates not found!!) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(original_caller_id_name=8822934216) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(original_caller_id_number=8822934216) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(error_cdr=1) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(callstart=2022-08-10 10:04:09) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(account_id=21) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(parent_id=0) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(call_direction=outbound) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(sip_ignore_remote_cause=true) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(call_processed=internal) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(effective_destination_number=999007070) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND) Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action hangup(TERMINATION_RATE_NOT_FOUND) 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_ROUTING -> CS_EXECUTE 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State ROUTING going to sleep 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_EXECUTE (Cur 2 Tot 53) 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State EXECUTE 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_sofia.c:213 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA EXECUTE 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:323 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard EXECUTE EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 log(WARNING Accountcode 999001. Dialed number (999007070) termination rates not found!!) 2022-08-10 10:04:09.525536 89.10% [WARNING] mod_dptools.c:1879 Accountcode 999001. Dialed number (999007070) termination rates not found!! EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(original_caller_id_name=8822934216) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [original_caller_id_name]=[8822934216] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(original_caller_id_number=8822934216) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [original_caller_id_number]=[8822934216] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(error_cdr=1) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [error_cdr]=[1] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(callstart=2022-08-10 10:04:09) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [callstart]=[2022-08-10 10:04:09] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(account_id=21) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [account_id]=[21] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(parent_id=0) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [parent_id]=[0] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(call_direction=outbound) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [call_direction]=[outbound] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(sip_ignore_remote_cause=true) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [sip_ignore_remote_cause]=[true] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(call_processed=internal) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [call_processed]=[internal] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(effective_destination_number=999007070) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [effective_destination_number]=[999007070] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND) 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [last_bridge_hangup_cause]=[TERMINATION_RATE_NOT_FOUND] EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 hangup(TERMINATION_RATE_NOT_FOUND) 2022-08-10 10:04:09.525536 89.10% [NOTICE] mod_dptools.c:1387 Hangup sofia/default/8822934216@astppqa605.astppbilling.org:5072 [CS_EXECUTE] [NORMAL_CLEARING] 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_session.c:2983 sofia/default/8822934216@astppqa605.astppbilling.org:5072 skip receive message [PHONE_EVENT] (channel is hungup already) 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State EXECUTE going to sleep 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_HANGUP (Cur 2 Tot 53) 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Callstate Change RINGING -> HANGUP 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State HANGUP 2022-08-10 10:04:09.545545 89.10% [DEBUG] mod_sofia.c:468 Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 hanging up, cause: NORMAL_CLEARING 2022-08-10 10:04:09.545545 89.10% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 480 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:59 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard HANGUP, cause: NORMAL_CLEARING 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State HANGUP going to sleep 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_HANGUP -> CS_REPORTING 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_REPORTING (Cur 2 Tot 53) 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State REPORTING 2022-08-10 10:04:09.545545 89.10% [INFO] mod_json_cdr.c:271 Process [9286459f-0e84-4027-8141-4114255a3130.cdr.json] 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:168 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard REPORTING, cause: NORMAL_CLEARING 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State REPORTING going to sleep 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:607 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_REPORTING -> CS_DESTROY 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_session.c:1753 Session 52 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Locked, Waiting on external entities 2022-08-10 10:04:09.545545 89.10% [NOTICE] switch_core_session.c:1771 Session 52 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Ended 2022-08-10 10:04:09.545545 89.10% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 [CS_DESTROY] 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:735 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_DESTROY (Cur 1 Tot 53) 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State DESTROY 2022-08-10 10:04:09.545545 89.10% [DEBUG] mod_sofia.c:379 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA DESTROY 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:175 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard DESTROY 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State DESTROY going to sleep freeswitch@devangASTPP> /exit root@devangASTPP:/opt/ASTPP# root@devangASTPP:/opt/ASTPP