2023-06-16 06:07:59.014224 42.23% [NOTICE] switch_channel.c:1123 New Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 [afd7d3e7-1b90-4ab0-a54b-cf8c033578af] 2023-06-16 06:07:59.014224 42.23% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_NEW (Cur 1 Tot 339) 2023-06-16 06:07:59.014224 42.23% [INFO] sofia.c:10453 sofia/default/7870463271@alpha3.astppbilling.org:5076 receiving invite from 103.240.35.46:51948 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: M2RkMGJlNTNmY2I0YWYzYzZhYzU4ZmE5ZTUxMWEzNjI. 2023-06-16 06:07:59.014224 42.23% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 103.240.35.46:0. 2023-06-16 06:07:59.014224 42.23% [WARNING] sofia_reg.c:1846 SIP auth challenge (INVITE) on sofia profile 'default' for [9120201@alpha3.astppbilling.org] from ip 103.240.35.46 2023-06-16 06:07:59.014224 42.23% [DEBUG] switch_core_state_machine.c:600 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State NEW 2023-06-16 06:07:59.014224 42.23% [DEBUG] sofia.c:2419 detaching session afd7d3e7-1b90-4ab0-a54b-cf8c033578af 2023-06-16 06:07:59.654229 42.53% [DEBUG] sofia.c:2532 Re-attaching to session afd7d3e7-1b90-4ab0-a54b-cf8c033578af 2023-06-16 06:07:59.674234 42.53% [INFO] sofia.c:10453 sofia/default/7870463271@alpha3.astppbilling.org:5076 receiving invite from 103.240.35.46:51948 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: M2RkMGJlNTNmY2I0YWYzYzZhYzU4ZmE5ZTUxMWEzNjI. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 103.240.35.46:0. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:11668 Setting NAT mode based on via received 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [received][100] 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:7497 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 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[G729:18:8000:20:8000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[G729:18:8000:20:8000:1] 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 101@8000 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:3750 Set Codec sofia/default/7870463271@alpha3.astppbilling.org:5076 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_codec.c:111 sofia/default/7870463271@alpha3.astppbilling.org:5076 Original read codec set to PCMA:8 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5850 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 recv payload to 101 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:7921 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_NEW -> CS_INIT 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_INIT (Cur 1 Tot 339) 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State INIT 2023-06-16 06:07:59.674234 42.53% [DEBUG] mod_sofia.c:97 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA INIT 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:40 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard INIT 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:48 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State INIT going to sleep 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 339) 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_channel.c:2380 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change DOWN -> RINGING 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING 2023-06-16 06:07:59.674234 42.53% [DEBUG] mod_sofia.c:158 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA ROUTING 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:230 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard ROUTING 2023-06-16 06:07:59.674234 42.53% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->9120201 in context default 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 9120201 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9120201' limit 1 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9120201' and status=0 LIMIT 1 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '170' and username = '9120201' limit 1 2023-06-16 06:07:59.694239 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 7870463271 / 23222 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 912020 AND status=0 limit 1 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-16 06:07:59.694239 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.694239 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271] 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9120201 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 170 2023-06-16 06:07:59.734244 42.53% [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 = '^9120201.*' OR patterns = '^912020.*' OR patterns = '^91202.*' OR patterns = '^9120.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 170 ORDER BY LENGTH(PKGPTR.patterns) DESC 2023-06-16 06:07:59.734244 42.53% [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 ="9120201" AND A.accountid = '170' limit 1 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9120201 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-16 06:07:59.734244 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.734244 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2023-06-16 06:07:59.734244 42.53% [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 = '9120201' OR number = '912020' OR number = '91202' OR number = '9120' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '9120201*' OR number = '912020*' OR number = '91202*' OR number = '9120*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '23222' OR number = '2322' OR number = '232' OR number = '23' OR number = '2' OR number ='--') OR (number = '23222*' OR number = '2322*' OR number = '232*' OR number = '23*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9120201' OR routing_prefix = '912020' OR routing_prefix = '91202' OR routing_prefix = '9120' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 170 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7870463271 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3091.8867 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 29 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::29 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2023-06-16 06:07:59.734244 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.734244 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 55 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 9120201 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 170 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3091.8867 balance Accountid 170 !!! 2023-06-16 06:07:59.774233 42.53% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2023-06-16 06:07:59.774233 42.53% [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 = 170 AND status=0 LIMIT 1 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:170 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:170 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 170 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-16 06:07:59.774233 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha3.astppbilling.org 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}] 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition : [{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-12","year":"2023-2023","extensions":"347","no_answer_call_type":"11","priority":"1"}] 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "347" limit 1 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str : time-of-day= "00:00-23:59" wday= "1-7" mday= "1-31" mon= "1-12" year= "2023-2023" 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2023-06-16 06:07:59.774233 42.53% [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 = "1" AND accounts.status = 0 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-16 06:07:59.794231 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha3.astppbilling.org 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->Y test timecondi] continue=true Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Absolute Condition [Y test timecondi] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(timezone=Europe/Sarajevo) 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Date/Time Match (PASS) [Y test timecondi] break=never Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(office_status=open) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(office_status=open) 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [office_status]=[open] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(extensions=5575942767) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(extensions=5575942767) 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [extensions]=[5575942767] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_did_number=9120201) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_did_number=9120201) 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_did_number]=[9120201] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_call_type=11) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=11) 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[11] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->tod route, x9120201] continue=false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (PASS) [tod route, x9120201] destination_number(9120201) =~ /^(\+?)?(9120201)$/ break=on-false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action execute_extension(9120201_${office_status}) 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:281 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING going to sleep 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 1 Tot 339) 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_sofia.c:213 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA EXECUTE 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:323 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard EXECUTE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 execute_extension(9120201_open) 2023-06-16 06:07:59.794231 42.53% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->9120201_open in context default 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 9120201 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9120201' limit 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9120201' and status=0 LIMIT 1 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '170' and username = '9120201' limit 1 2023-06-16 06:07:59.814226 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 7870463271 / 23222 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 912020 AND status=0 limit 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-16 06:07:59.814226 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.814226 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271] 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9120201 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 170 2023-06-16 06:07:59.814226 42.53% [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 = '^9120201.*' OR patterns = '^912020.*' OR patterns = '^91202.*' OR patterns = '^9120.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 170 ORDER BY LENGTH(PKGPTR.patterns) DESC 2023-06-16 06:07:59.814226 42.53% [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 ="9120201" AND A.accountid = '170' limit 1 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9120201 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-16 06:07:59.814226 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.814226 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2023-06-16 06:07:59.814226 42.53% [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 = '9120201' OR number = '912020' OR number = '91202' OR number = '9120' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '9120201*' OR number = '912020*' OR number = '91202*' OR number = '9120*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '23222' OR number = '2322' OR number = '232' OR number = '23' OR number = '2' OR number ='--') OR (number = '23222*' OR number = '2322*' OR number = '232*' OR number = '23*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9120201' OR routing_prefix = '912020' OR routing_prefix = '91202' OR routing_prefix = '9120' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 170 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7870463271 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3091.8867 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 29 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::29 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2023-06-16 06:07:59.834229 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.834229 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 55 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 9120201 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 170 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3091.8867 balance Accountid 170 !!! 2023-06-16 06:07:59.834229 42.53% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2023-06-16 06:07:59.834229 42.53% [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 = 170 AND status=0 LIMIT 1 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:170 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:170 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 170 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha3.astppbilling.org 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}] 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition : [{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-12","year":"2023-2023","extensions":"347","no_answer_call_type":"11","priority":"1"}] 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "347" limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str : time-of-day= "00:00-23:59" wday= "1-7" mday= "1-31" mon= "1-12" year= "2023-2023" 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2023-06-16 06:07:59.854238 42.53% [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 = "1" AND accounts.status = 0 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha3.astppbilling.org 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->Y test timecondi] continue=true Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Absolute Condition [Y test timecondi] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(timezone=Europe/Sarajevo) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Date/Time Match (PASS) [Y test timecondi] break=never Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(office_status=open) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(office_status=open) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [office_status]=[open] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(extensions=5575942767) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(extensions=5575942767) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [extensions]=[5575942767] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_did_number=9120201) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_did_number=9120201) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_did_number]=[9120201] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_call_type=11) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=11) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[11] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->tod route, x9120201] continue=false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (FAIL) [tod route, x9120201] destination_number(9120201_open) =~ /^(\+?)?(9120201)$/ break=on-false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->office is open] continue=false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (PASS) [office is open] destination_number(9120201_open) =~ /^(\+?)?(9120201_open)$/ break=on-false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(domain_name=alpha3.astppbilling.org) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(set_extensions=${extensions}) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_flag=true) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_did_number=9120201) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_did_number=9120201) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_did_number]=[9120201] Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_call_type=${no_answer_call_type}) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_number=${extensions}) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action transfer(170 XML default) 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(domain_name=alpha3.astppbilling.org) EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(domain_name=alpha3.astppbilling.org) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [domain_name]=[alpha3.astppbilling.org] 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(set_extensions=${extensions}) EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(set_extensions=5575942767) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [set_extensions]=[5575942767] 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(no_answer_flag=true) EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_flag=true) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_flag]=[true] 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type}) EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=11) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[11] 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(no_answer_number=${extensions}) EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_number=5575942767) 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_number]=[5575942767] 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] transfer(170 XML default) EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 transfer(170 XML default) 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_ivr.c:2288 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_EXECUTE -> CS_ROUTING 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_ivr.c:2295 Transfer sofia/default/7870463271@alpha3.astppbilling.org:5076 to XML[170@default] 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE going to sleep 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 339) 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_sofia.c:158 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA ROUTING 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:230 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard ROUTING 2023-06-16 06:07:59.854238 42.53% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->170 in context default 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 170 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '170' limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '170' and status=0 LIMIT 1 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '170' and username = '170' limit 1 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 7870463271 / 23222 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 170 AND status=0 limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-16 06:07:59.854238 42.53% [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="170" AND domains.domain="alpha3.astppbilling.org" limit 1 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271] 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =170 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^170.*' OR blocked_patterns = '^17.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 170 limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ no_answer_did_number :9120201 2023-06-16 06:07:59.854238 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.854238 42.53% [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 ="9120201" LIMIT 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ accountid :170 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^170.*' OR blocked_patterns = '^17.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 170 limit 1 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :170 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainalpha3.astppbilling.org 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 11 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Time Conditions 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_extensions_forwarding] Query :select sip_devices.id,sip_device_routing.call_forwarding_flag,sip_device_routing.call_forwarding_destination from sip_devices JOIN sip_device_routing ON sip_devices.id = sip_device_routing.sip_device_id where sip_devices.username = "5575942767" 2023-06-16 06:07:59.894230 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC5] 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT 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="5575942767" AND domains.domain="alpha3.astppbilling.org" limit 1 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer_attended' limit 1 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer' limit 1 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->170] continue=false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (PASS) [170] destination_number(170) =~ /170/ break=on-false Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action export(did_user_domain=alpha3.astppbilling.org) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(ignore_early_media=true) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_flag=false) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(did_calltype=11) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(did_extensions=5575942767) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(daily_call_credit_limit=0.00000) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(monthly_call_credit_limit=0.00000) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(daily_call_used_limit=0.00000) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(monthly_call_used_limit=0.00000) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(sip_destination_number=5575942767) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(sip_to_host=alpha3.astppbilling.org) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(user_domain=alpha3.astppbilling.org) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action db(insert/pickup_any_group_${callgroup}/5575942767/${uuid}) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(dialed_extension=transfer_call) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action export(dialed_extension=transfer_call) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action export(ring_group_transfer=true) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bridge(user/5575942767@alpha3.astppbilling.org) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:281 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING going to sleep 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 1 Tot 339) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:213 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA EXECUTE 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:323 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard EXECUTE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 export(did_user_domain=alpha3.astppbilling.org) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[alpha3.astppbilling.org] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(continue_on_fail=TRUE) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [continue_on_fail]=[TRUE] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(ignore_early_media=true) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [ignore_early_media]=[true] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_flag=false) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_flag]=[false] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(did_calltype=11) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [did_calltype]=[11] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(did_extensions=5575942767) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [did_extensions]=[5575942767] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(daily_call_credit_limit=0.00000) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [daily_call_credit_limit]=[0.00000] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(monthly_call_credit_limit=0.00000) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [monthly_call_credit_limit]=[0.00000] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(daily_call_used_limit=0.00000) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [daily_call_used_limit]=[0.00000] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(monthly_call_used_limit=0.00000) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [monthly_call_used_limit]=[0.00000] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(sip_destination_number=5575942767) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [sip_destination_number]=[5575942767] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(sip_to_host=alpha3.astppbilling.org) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [sip_to_host]=[alpha3.astppbilling.org] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(user_domain=alpha3.astppbilling.org) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [user_domain]=[alpha3.astppbilling.org] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 db(insert/pickup_any_group_/5575942767/afd7d3e7-1b90-4ab0-a54b-cf8c033578af) EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(dialed_extension=transfer_call) 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [dialed_extension]=[transfer_call] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 export(dialed_extension=transfer_call) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [dialed_extension]=[transfer_call] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default) 2023-06-16 06:07:59.894230 42.53% [INFO] switch_ivr_async.c:4780 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default) 2023-06-16 06:07:59.894230 42.53% [INFO] switch_ivr_async.c:4780 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 export(ring_group_transfer=true) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [ring_group_transfer]=[true] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bridge(user/5575942767@alpha3.astppbilling.org) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [did_user_domain]=[alpha3.astppbilling.org] to event 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [ring_group_transfer]=[true] to event 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_ivr_originate.c:2291 Parsing global variables 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [did_user_domain]=[alpha3.astppbilling.org] to event 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [ring_group_transfer]=[true] to event 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_ivr_originate.c:2291 Parsing global variables 2023-06-16 06:07:59.894230 42.53% [NOTICE] switch_channel.c:1123 New Channel sofia/default/5575942767@185.117.83.208:35080 [0d73261a-1319-4eb8-a388-348f777c776d] 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:5117 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_NEW -> CS_INIT 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_INIT (Cur 2 Tot 340) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/5575942767@185.117.83.208:35080) State INIT 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:97 sofia/default/5575942767@185.117.83.208:35080 SOFIA INIT 2023-06-16 06:07:59.894230 42.53% [INFO] sofia_glue.c:1654 sofia/default/5575942767@185.117.83.208:35080 sending invite call-id: (null) 2023-06-16 06:07:59.894230 42.53% [DEBUG] sofia_glue.c:1657 sofia/default/5575942767@185.117.83.208:35080 sending invite version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit Local SDP: v=0 o=FreeSWITCH 1686864753 1686864754 IN IP4 95.217.238.195 s=FreeSWITCH c=IN IP4 95.217.238.195 t=0 0 m=audio 23726 RTP/AVP 8 101 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 a=sendrecv 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:40 sofia/default/5575942767@185.117.83.208:35080 Standard INIT 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:48 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_INIT -> CS_ROUTING 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/5575942767@185.117.83.208:35080) State INIT going to sleep 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_ROUTING (Cur 2 Tot 340) 2023-06-16 06:07:59.894230 42.53% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [calling][0] 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/5575942767@185.117.83.208:35080) State ROUTING 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:158 sofia/default/5575942767@185.117.83.208:35080 SOFIA ROUTING 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_ivr_originate.c:67 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_ROUTING -> CS_CONSUME_MEDIA 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/5575942767@185.117.83.208:35080) State ROUTING going to sleep 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 340) 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:659 (sofia/default/5575942767@185.117.83.208:35080) State CONSUME_MEDIA 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:659 (sofia/default/5575942767@185.117.83.208:35080) State CONSUME_MEDIA going to sleep 2023-06-16 06:08:03.754237 40.80% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [7543346407@alpha5.astppbilling.org] from ip 103.240.35.46 2023-06-16 06:08:04.394231 39.87% [WARNING] sofia_reg.c:3211 Can't find user [7543346407@alpha5.astppbilling.org] from 103.240.35.46 You must define a domain called 'alpha5.astppbilling.org' in your directory and add a user with the id="7543346407" attribute and you must configure your device to use the proper domain in its authentication credentials. 2023-06-16 06:08:04.654244 39.87% [WARNING] sofia_reg.c:1846 SIP auth challenge (INVITE) on sofia profile 'default' for [7543346407@alpha5.astppbilling.org] from ip 103.240.35.46 2023-06-16 06:08:05.614227 38.90% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [5575942767@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-16 06:08:06.974226 38.37% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [proceeding][180] 2023-06-16 06:08:06.974226 38.37% [NOTICE] sofia.c:7598 Ring-Ready sofia/default/5575942767@185.117.83.208:35080! 2023-06-16 06:08:06.974226 38.37% [DEBUG] switch_channel.c:3494 (sofia/default/5575942767@185.117.83.208:35080) Callstate Change DOWN -> RINGING 2023-06-16 06:08:06.974226 38.37% [NOTICE] mod_sofia.c:2516 Ring-Ready sofia/default/7870463271@alpha3.astppbilling.org:5076! 2023-06-16 06:08:06.974226 38.37% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [early][180] 2023-06-16 06:08:06.974226 38.37% [NOTICE] switch_ivr_originate.c:565 Ring Ready sofia/default/7870463271@alpha3.astppbilling.org:5076! 2023-06-16 06:08:07.314242 38.63% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [5575942767@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-16 06:08:10.714270 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [completing][200] 2023-06-16 06:08:10.714270 38.63% [DEBUG] sofia.c:7497 Remote SDP: v=0 o=Zoiper 0 1094410467 IN IP4 10.156.235.240 s=Zoiper c=IN IP4 10.156.235.240 t=0 0 m=audio 49432 RTP/AVP 8 106 9 0 3 101 98 a=rtpmap:106 opus/48000/2 a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=rtpmap:98 telephone-event/48000 a=fmtp:98 0-16 a=rtcp-mux a=ptime:20 a=direction:both 2023-06-16 06:08:10.714270 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [ready][200] 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 101@8000 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:3750 Set Codec sofia/default/5575942767@185.117.83.208:35080 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_codec.c:111 sofia/default/5575942767@185.117.83.208:35080 Original read codec set to PCMA:8 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5850 sofia/default/5575942767@185.117.83.208:35080 Set 2833 dtmf send payload to 101 recv payload to 101 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8651 AUDIO RTP [sofia/default/5575942767@185.117.83.208:35080] 95.217.238.195 port 23726 -> 10.156.235.240 port 49432 codec: 8 ms: 20 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_rtp.c:4377 Starting timer [soft] 160 bytes per 20ms 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8871 Activating RTCP PORT 49432 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_rtp.c:4708 RTCP send rate is: 1000 and packet rate is: 20000 Remote Port: 49432 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8963 sofia/default/5575942767@185.117.83.208:35080 Set 2833 dtmf send payload to 101 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8970 sofia/default/5575942767@185.117.83.208:35080 Set 2833 dtmf receive payload to 101 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8993 sofia/default/5575942767@185.117.83.208:35080 Set rtp dtmf delay to 40 2023-06-16 06:08:10.714270 38.63% [NOTICE] sofia.c:8674 Channel [sofia/default/5575942767@185.117.83.208:35080] has been answered 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_channel.c:3893 (sofia/default/5575942767@185.117.83.208:35080) Callstate Change RINGING -> ACTIVE 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8651 AUDIO RTP [sofia/default/7870463271@alpha3.astppbilling.org:5076] 95.217.238.195 port 22716 -> 103.240.35.46 port 8000 codec: 8 ms: 20 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_rtp.c:4377 Starting timer [soft] 160 bytes per 20ms 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8963 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8970 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf receive payload to 101 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8993 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set rtp dtmf delay to 40 2023-06-16 06:08:10.714270 38.63% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/7870463271@alpha3.astppbilling.org:5076: v=0 o=FreeSWITCH 1686865774 1686865775 IN IP4 95.217.238.195 s=FreeSWITCH c=IN IP4 95.217.238.195 t=0 0 m=audio 22716 RTP/AVP 8 101 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 a=sendrecv 2023-06-16 06:08:10.714270 38.63% [NOTICE] switch_ivr_originate.c:3844 Channel [sofia/default/7870463271@alpha3.astppbilling.org:5076] has been answered 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_channel.c:3893 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change RINGING -> ACTIVE 2023-06-16 06:08:10.754229 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [completed][200] 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_ivr_originate.c:3902 Originate Resulted in Success: [sofia/default/5575942767@185.117.83.208:35080] Peer UUID: 0d73261a-1319-4eb8-a388-348f777c776d 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_ivr_originate.c:3902 Originate Resulted in Success: [sofia/default/5575942767@185.117.83.208:35080] Peer UUID: 0d73261a-1319-4eb8-a388-348f777c776d 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_ivr_bridge.c:1791 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_EXCHANGE_MEDIA (Cur 2 Tot 340) 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_core_state_machine.c:650 (sofia/default/5575942767@185.117.83.208:35080) State EXCHANGE_MEDIA 2023-06-16 06:08:10.754229 38.63% [DEBUG] mod_sofia.c:671 SOFIA EXCHANGE_MEDIA 2023-06-16 06:08:11.054226 38.63% [DEBUG] switch_rtp.c:1775 rtcp_stats_init: audio ssrc[3039066830] base_seq[35524] 2023-06-16 06:08:11.054226 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [ready][200] 2023-06-16 06:08:11.074226 38.63% [DEBUG] switch_rtp.c:7511 Correct audio ip/port confirmed. 2023-06-16 06:08:11.374231 39.20% [INFO] switch_rtp.c:7471 Auto Changing audio port from 10.156.235.240:49432 to 117.228.92.158:47448 2023-06-16 06:08:21.454233 39.77% [NOTICE] sofia.c:1065 Hangup sofia/default/5575942767@185.117.83.208:35080 [CS_EXCHANGE_MEDIA] [NORMAL_CLEARING] 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_ivr_bridge.c:911 BRIDGE THREAD DONE [sofia/default/5575942767@185.117.83.208:35080] 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:650 (sofia/default/5575942767@185.117.83.208:35080) State EXCHANGE_MEDIA going to sleep 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_HANGUP (Cur 2 Tot 340) 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:844 (sofia/default/5575942767@185.117.83.208:35080) Callstate Change ACTIVE -> HANGUP 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/5575942767@185.117.83.208:35080) State HANGUP 2023-06-16 06:08:21.454233 39.77% [DEBUG] mod_sofia.c:468 Channel sofia/default/5575942767@185.117.83.208:35080 hanging up, cause: NORMAL_CLEARING 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:59 sofia/default/5575942767@185.117.83.208:35080 Standard HANGUP, cause: NORMAL_CLEARING 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/5575942767@185.117.83.208:35080) State HANGUP going to sleep 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:616 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_HANGUP -> CS_REPORTING 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_REPORTING (Cur 2 Tot 340) 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/5575942767@185.117.83.208:35080) State REPORTING 2023-06-16 06:08:21.454233 39.77% [INFO] mod_json_cdr.c:272 Process [0d73261a-1319-4eb8-a388-348f777c776d.cdr.json] 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:168 sofia/default/5575942767@185.117.83.208:35080 Standard REPORTING, cause: NORMAL_CLEARING 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/5575942767@185.117.83.208:35080) State REPORTING going to sleep 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:607 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_REPORTING -> CS_DESTROY 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_session.c:1743 Session 340 (sofia/default/5575942767@185.117.83.208:35080) Locked, Waiting on external entities 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_ivr_bridge.c:819 sofia/default/5575942767@185.117.83.208:35080 ending bridge by request from write function 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_ivr_bridge.c:911 BRIDGE THREAD DONE [sofia/default/7870463271@alpha3.astppbilling.org:5076] 2023-06-16 06:08:21.454233 39.77% [NOTICE] switch_core_session.c:1761 Session 340 (sofia/default/5575942767@185.117.83.208:35080) Ended 2023-06-16 06:08:21.454233 39.77% [NOTICE] switch_core_session.c:1765 Close Channel sofia/default/5575942767@185.117.83.208:35080 [CS_DESTROY] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 lua(astpp/lib/pbx/astpp-sipdevice-routing.lua) 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:735 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_DESTROY (Cur 1 Tot 340) 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/5575942767@185.117.83.208:35080) State DESTROY 2023-06-16 06:08:21.454233 39.77% [DEBUG] mod_sofia.c:379 sofia/default/5575942767@185.117.83.208:35080 SOFIA DESTROY 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:175 sofia/default/5575942767@185.117.83.208:35080 Standard DESTROY 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/5575942767@185.117.83.208:35080) State DESTROY going to sleep 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-16 06:08:21.474232 39.77% [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') 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_cpp.cpp:1465 [Astpp_SIP-Devices] This Is Last Dispositions SUCCESS This Is SIP Number : 5575942767 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_cpp.cpp:1209 sofia/default/7870463271@alpha3.astppbilling.org:5076 destroy/unlink session from object 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_state_machine.c:382 sofia/default/7870463271@alpha3.astppbilling.org:5076 has executed the last dialplan instruction, hanging up. 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/7870463271@alpha3.astppbilling.org:5076 [CS_EXECUTE] [NORMAL_CLEARING] 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE going to sleep 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 1 Tot 340) 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:844 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change ACTIVE -> HANGUP 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HANGUP 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:462 sofia/default/7870463271@alpha3.astppbilling.org:5076 Overriding SIP cause 480 with 200 from the other leg 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:468 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 hanging up, cause: NORMAL_CLEARING 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/7870463271@alpha3.astppbilling.org:5076 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:59 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard HANGUP, cause: NORMAL_CLEARING 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HANGUP going to sleep 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:616 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 1 Tot 340) 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State REPORTING 2023-06-16 06:08:21.474232 39.77% [INFO] mod_json_cdr.c:272 Process [afd7d3e7-1b90-4ab0-a54b-cf8c033578af.cdr.json] 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:168 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard REPORTING, cause: NORMAL_CLEARING 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State REPORTING going to sleep 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:607 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_REPORTING -> CS_DESTROY 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_session.c:1743 Session 339 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Locked, Waiting on external entities 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_session.c:1761 Session 339 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Ended 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_session.c:1765 Close Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 [CS_DESTROY] 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:735 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_DESTROY (Cur 0 Tot 340) 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State DESTROY 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:379 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA DESTROY 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:175 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard DESTROY 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State DESTROY going to sleep