2023-06-21 08:25:35.474292 82.73% [NOTICE] switch_channel.c:1123 New Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 [fed14196-8415-4571-a3b0-53d97f710c5f] 2023-06-21 08:25:35.474292 82.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_NEW (Cur 1 Tot 13) 2023-06-21 08:25:35.474292 82.73% [INFO] sofia.c:10453 sofia/default/7870463271@alpha3.astppbilling.org:5076 receiving invite from 103.240.35.46:32832 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: NmIyMTc2NDZkMzQyZjc4MjY2YmE4OWEwM2Q0MzAyOTQ. 2023-06-21 08:25:35.474292 82.73% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 103.240.35.46:0. 2023-06-21 08:25:35.474292 82.73% [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-21 08:25:35.474292 82.73% [DEBUG] switch_core_state_machine.c:600 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State NEW 2023-06-21 08:25:35.474292 82.73% [DEBUG] sofia.c:2419 detaching session fed14196-8415-4571-a3b0-53d97f710c5f 2023-06-21 08:25:36.094344 82.73% [DEBUG] sofia.c:2532 Re-attaching to session fed14196-8415-4571-a3b0-53d97f710c5f 2023-06-21 08:25:36.094344 82.73% [INFO] sofia.c:10453 sofia/default/7870463271@alpha3.astppbilling.org:5076 receiving invite from 103.240.35.46:32832 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: NmIyMTc2NDZkMzQyZjc4MjY2YmE4OWEwM2Q0MzAyOTQ. 2023-06-21 08:25:36.094344 82.73% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 103.240.35.46:0. 2023-06-21 08:25:36.114340 84.70% [DEBUG] sofia.c:11668 Setting NAT mode based on via received 2023-06-21 08:25:36.114340 84.70% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [received][100] 2023-06-21 08:25:36.114340 84.70% [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-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 101@8000 2023-06-21 08:25:36.114340 84.70% [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-21 08:25:36.114340 84.70% [DEBUG] switch_core_codec.c:111 sofia/default/7870463271@alpha3.astppbilling.org:5076 Original read codec set to PCMA:8 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000 2023-06-21 08:25:36.114340 84.70% [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-21 08:25:36.114340 84.70% [DEBUG] sofia.c:7921 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_NEW -> CS_INIT 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_INIT (Cur 1 Tot 13) 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State INIT 2023-06-21 08:25:36.114340 84.70% [DEBUG] mod_sofia.c:97 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA INIT 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:40 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard INIT 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:48 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State INIT going to sleep 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 13) 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_channel.c:2380 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change DOWN -> RINGING 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING 2023-06-21 08:25:36.114340 84.70% [DEBUG] mod_sofia.c:158 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA ROUTING 2023-06-21 08:25:36.114340 84.70% [DEBUG] switch_core_state_machine.c:230 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard ROUTING 2023-06-21 08:25:36.114340 84.70% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->9120201 in context default 2023-06-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 9120201 2023-06-21 08:25:36.134292 84.70% [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-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-21 08:25:36.134292 84.70% [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-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1 2023-06-21 08:25:36.134292 84.70% [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-21 08:25:36.134292 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 2023-06-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 7870463271 / 23222 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 912020 AND status=0 limit 1 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-21 08:25:36.134292 84.70% [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-21 08:25:36.134292 84.70% [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-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2023-06-21 08:25:36.134292 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271] 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9120201 2023-06-21 08:25:36.134292 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 170 2023-06-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9120201 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2023-06-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2023-06-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 170 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7870463271 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 2883.9867 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 29 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::29 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2023-06-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [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-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 55 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 9120201 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 170 2023-06-21 08:25:36.154284 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2023-06-21 08:25:36.154284 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your2883.9867 balance Accountid 170 !!! 2023-06-21 08:25:36.174289 84.70% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2023-06-21 08:25:36.174289 84.70% [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-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:170 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:170 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 170 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-21 08:25:36.174289 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha3.astppbilling.org 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1 2023-06-21 08:25:36.174289 84.70% [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-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}] 2023-06-21 08:25:36.174289 84.70% [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":"2","no_answer_call_type":"9","priority":"1"}] 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2023-06-21 08:25:36.174289 84.70% [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-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2023-06-21 08:25:36.174289 84.70% [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-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-21 08:25:36.174289 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha3.astppbilling.org 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11 2023-06-21 08:25:36.174289 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1 2023-06-21 08:25:36.174289 84.70% [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-21 08:25:36.174289 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->Y Time condi test] continue=true Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Absolute Condition [Y Time condi test] 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-21 08:25:36.174289 84.70% [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 Time condi test] 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-21 08:25:36.174289 84.70% [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=2) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(extensions=2) 2023-06-21 08:25:36.174289 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [extensions]=[2] 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-21 08:25:36.174289 84.70% [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=9) INLINE EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=9) 2023-06-21 08:25:36.174289 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[9] 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-21 08:25:36.174289 84.70% [DEBUG] switch_core_state_machine.c:281 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING going to sleep 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 1 Tot 13) 2023-06-21 08:25:36.174289 84.70% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE 2023-06-21 08:25:36.174289 84.70% [DEBUG] mod_sofia.c:213 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA EXECUTE 2023-06-21 08:25:36.174289 84.70% [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-21 08:25:36.174289 84.70% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->9120201_open in context default 2023-06-21 08:25:36.194283 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-21 08:25:36.194283 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:25:36.194283 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:25:36.194283 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.194283 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-21 08:25:36.194283 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 9120201 2023-06-21 08:25:36.194283 84.70% [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-21 08:25:36.194283 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-21 08:25:36.194283 84.70% [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-21 08:25:36.194283 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271 2023-06-21 08:25:36.194283 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.194283 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 7870463271 / 23222 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 912020 AND status=0 limit 1 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271] 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9120201 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 170 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9120201 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 170 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7870463271 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 2883.9867 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 29 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::29 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2023-06-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [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-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 55 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 9120201 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 170 2023-06-21 08:25:36.214286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2023-06-21 08:25:36.214286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your2883.9867 balance Accountid 170 !!! 2023-06-21 08:25:36.234285 84.70% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:170 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:170 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 170 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-21 08:25:36.234285 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha3.astppbilling.org 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}] 2023-06-21 08:25:36.234285 84.70% [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":"2","no_answer_call_type":"9","priority":"1"}] 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-21 08:25:36.234285 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha3.astppbilling.org 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11 2023-06-21 08:25:36.234285 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->Y Time condi test] continue=true Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Absolute Condition [Y Time condi test] 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-21 08:25:36.234285 84.70% [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 Time condi test] 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-21 08:25:36.234285 84.70% [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=2) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(extensions=2) 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [extensions]=[2] 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-21 08:25:36.234285 84.70% [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=9) INLINE EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=9) 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[9] 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-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [domain_name]=[alpha3.astppbilling.org] 2023-06-21 08:25:36.234285 84.70% [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=2) 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [set_extensions]=[2] 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_flag]=[true] 2023-06-21 08:25:36.234285 84.70% [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=9) 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[9] 2023-06-21 08:25:36.234285 84.70% [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=2) 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_number]=[2] 2023-06-21 08:25:36.234285 84.70% [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-21 08:25:36.234285 84.70% [DEBUG] switch_ivr.c:2288 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_EXECUTE -> CS_ROUTING 2023-06-21 08:25:36.234285 84.70% [NOTICE] switch_ivr.c:2295 Transfer sofia/default/7870463271@alpha3.astppbilling.org:5076 to XML[170@default] 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE going to sleep 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 13) 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged 2023-06-21 08:25:36.234285 84.70% [DEBUG] mod_sofia.c:158 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA ROUTING 2023-06-21 08:25:36.234285 84.70% [DEBUG] switch_core_state_machine.c:230 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard ROUTING 2023-06-21 08:25:36.234285 84.70% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->170 in context default 2023-06-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 170 2023-06-21 08:25:36.254282 84.70% [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-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-21 08:25:36.254282 84.70% [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-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1 2023-06-21 08:25:36.254282 84.70% [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-21 08:25:36.254282 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 2023-06-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 7870463271 / 23222 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 170 AND status=0 limit 1 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0 2023-06-21 08:25:36.254282 84.70% [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-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound 2023-06-21 08:25:36.254282 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271] 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =170 2023-06-21 08:25:36.254282 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1 2023-06-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ no_answer_did_number :9120201 2023-06-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ accountid :170 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1 2023-06-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :170 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1 2023-06-21 08:25:36.274286 84.70% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainalpha3.astppbilling.org 2023-06-21 08:25:36.274286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 9 2023-06-21 08:25:36.274286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Queue 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_Queue_INFO] Query :SELECT * from pbx_queue WHERE id = 2 and status=0 LIMIT 1 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '6' LIMIT 1 2023-06-21 08:25:36.274286 84.70% [INFO] switch_cpp.cpp:1465 [ASTPP] music on hold recording name :- /var/www/html/astpp//upload/pbx/Greeting_210623035220.wav 2023-06-21 08:25:36.274286 84.70% [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=9) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(did_extensions=2) 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(fifo_music=) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(fifo_music=$${hold_music}) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(module_name=pbx) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bridge_export(hold_music=/var/www/html/astpp//upload/pbx/Greeting_210623035220.wav) Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action answer() Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action fifo(myqueue_2 in) 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_state_machine.c:281 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING going to sleep 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 1 Tot 13) 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_sofia.c:213 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA EXECUTE 2023-06-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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=9) 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [did_calltype]=[9] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(did_extensions=2) 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [did_extensions]=[2] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(daily_call_credit_limit=0.00000) 2023-06-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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-21 08:25:36.274286 84.70% [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(fifo_music=) 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [fifo_music]=[UNDEF] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(fifo_music=local_stream://moh) 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [fifo_music]=[local_stream://moh] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(module_name=pbx) 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [module_name]=[pbx] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bridge_export(hold_music=/var/www/html/astpp//upload/pbx/Greeting_210623035220.wav) 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_channel.c:1315 EXPORT (bridge_export_vars) [hold_music]=[/var/www/html/astpp//upload/pbx/Greeting_210623035220.wav] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 answer() 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_media.c:8651 AUDIO RTP [sofia/default/7870463271@alpha3.astppbilling.org:5076] 95.217.238.195 port 30934 -> 103.240.35.46 port 8000 codec: 8 ms: 20 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_rtp.c:4377 Starting timer [soft] 160 bytes per 20ms 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_media.c:8963 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_media.c:8970 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf receive payload to 101 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_core_media.c:8993 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set rtp dtmf delay to 40 2023-06-21 08:25:36.274286 84.70% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/7870463271@alpha3.astppbilling.org:5076: v=0 o=FreeSWITCH 1687305002 1687305003 IN IP4 95.217.238.195 s=FreeSWITCH c=IN IP4 95.217.238.195 t=0 0 m=audio 30934 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-21 08:25:36.274286 84.70% [NOTICE] mod_dptools.c:1408 Channel [sofia/default/7870463271@alpha3.astppbilling.org:5076] has been answered 2023-06-21 08:25:36.274286 84.70% [DEBUG] switch_channel.c:3893 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change RINGING -> ACTIVE 2023-06-21 08:25:36.274286 84.70% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [completed][200] EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 fifo(myqueue_2 in) 2023-06-21 08:25:36.294282 84.70% [DEBUG] mod_local_stream.c:912 Opening Stream [moh/8000] 8000hz 2023-06-21 08:25:36.294282 84.70% [DEBUG] switch_ivr_play_say.c:1566 Codec Activated L16@8000hz 1 channels 20ms 2023-06-21 08:25:36.574304 84.70% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [ready][200] 2023-06-21 08:25:36.614286 84.70% [DEBUG] switch_rtp.c:7511 Correct audio ip/port confirmed. 2023-06-21 08:25:48.994314 93.60% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [2271920202@alpha.astppbilling.org] from ip 157.32.125.19 2023-06-21 08:25:49.294309 93.57% [WARNING] sofia_reg.c:3211 Can't find user [2271920202@alpha.astppbilling.org] from 157.32.125.19 You must define a domain called 'alpha.astppbilling.org' in your directory and add a user with the id="2271920202" attribute and you must configure your device to use the proper domain in its authentication credentials. 2023-06-21 08:25:49.294309 93.57% [WARNING] sofia_reg.c:1791 SIP auth failure (REGISTER) on sofia profile 'default' for [2271920202@alpha.astppbilling.org] from ip 157.32.125.19 2023-06-21 08:26:17.434283 63.33% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [41002@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-21 08:26:18.954304 61.70% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [41002@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-21 08:26:20.774285 58.37% [NOTICE] switch_channel.c:1123 New Channel sofia/default/41002@alpha3.astppbilling.org:5076 [bc5327ab-ac87-4ad8-b390-4898058a424b] 2023-06-21 08:26:20.774285 58.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_NEW (Cur 2 Tot 14) 2023-06-21 08:26:20.774285 58.37% [INFO] sofia.c:10453 sofia/default/41002@alpha3.astppbilling.org:5076 receiving invite from 185.117.83.208:35080 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: a048J5m7hnR-8SNHc6mIuw.. 2023-06-21 08:26:20.774285 58.37% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 185.117.83.208:0. 2023-06-21 08:26:20.774285 58.37% [WARNING] sofia_reg.c:1846 SIP auth challenge (INVITE) on sofia profile 'default' for [91300144@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-21 08:26:20.774285 58.37% [DEBUG] switch_core_state_machine.c:600 (sofia/default/41002@alpha3.astppbilling.org:5076) State NEW 2023-06-21 08:26:20.774285 58.37% [DEBUG] sofia.c:2419 detaching session bc5327ab-ac87-4ad8-b390-4898058a424b 2023-06-21 08:26:21.214287 56.77% [DEBUG] sofia.c:2532 Re-attaching to session bc5327ab-ac87-4ad8-b390-4898058a424b 2023-06-21 08:26:21.214287 56.77% [INFO] sofia.c:10453 sofia/default/41002@alpha3.astppbilling.org:5076 receiving invite from 185.117.83.208:35080 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: a048J5m7hnR-8SNHc6mIuw.. 2023-06-21 08:26:21.214287 56.77% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 185.117.83.208:0. 2023-06-21 08:26:21.234296 56.77% [DEBUG] sofia.c:7487 Channel sofia/default/41002@alpha3.astppbilling.org:5076 entering state [received][100] 2023-06-21 08:26:21.234296 56.77% [DEBUG] sofia.c:7497 Remote SDP: v=0 o=Zoiper 0 1216638701 IN IP4 10.153.246.64 s=Zoiper c=IN IP4 10.153.246.64 t=0 0 m=audio 47734 RTP/AVP 106 9 98 101 0 8 3 a=rtpmap:106 opus/48000/2 a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1 a=rtpmap:98 telephone-event/48000 a=fmtp:98 0-16 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=rtcp-mux a=ptime:20 a=direction:both 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 98@48000 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:3750 Set Codec sofia/default/41002@alpha3.astppbilling.org:5076 PCMU/8000 20 ms 160 samples 64000 bits 1 channels 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_codec.c:111 sofia/default/41002@alpha3.astppbilling.org:5076 Original read codec set to PCMU:0 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_media.c:5850 sofia/default/41002@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 recv payload to 101 2023-06-21 08:26:21.234296 56.77% [DEBUG] sofia.c:7921 (sofia/default/41002@alpha3.astppbilling.org:5076) State Change CS_NEW -> CS_INIT 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_INIT (Cur 2 Tot 14) 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:624 (sofia/default/41002@alpha3.astppbilling.org:5076) State INIT 2023-06-21 08:26:21.234296 56.77% [DEBUG] mod_sofia.c:97 sofia/default/41002@alpha3.astppbilling.org:5076 SOFIA INIT 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:40 sofia/default/41002@alpha3.astppbilling.org:5076 Standard INIT 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:48 (sofia/default/41002@alpha3.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:624 (sofia/default/41002@alpha3.astppbilling.org:5076) State INIT going to sleep 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 2 Tot 14) 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_channel.c:2380 (sofia/default/41002@alpha3.astppbilling.org:5076) Callstate Change DOWN -> RINGING 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:640 (sofia/default/41002@alpha3.astppbilling.org:5076) State ROUTING 2023-06-21 08:26:21.234296 56.77% [DEBUG] mod_sofia.c:158 sofia/default/41002@alpha3.astppbilling.org:5076 SOFIA ROUTING 2023-06-21 08:26:21.234296 56.77% [DEBUG] switch_core_state_machine.c:230 sofia/default/41002@alpha3.astppbilling.org:5076 Standard ROUTING 2023-06-21 08:26:21.234296 56.77% [INFO] mod_dialplan_xml.c:639 Processing 41002 <41002>->91300144 in context default 2023-06-21 08:26:21.254284 56.77% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2023-06-21 08:26:21.254284 56.77% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2023-06-21 08:26:21.254284 56.77% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 91300144 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '91300144' limit 1 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '91300144' and status=0 LIMIT 1 2023-06-21 08:26:21.254284 56.77% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] queue_destination_number,agent_hold_file : 91300144 2023-06-21 08:26:21.254284 56.77% [WARNING] switch_cpp.cpp:1465 [ASTPP] Fifo Agent Flag1 2023-06-21 08:26:21.254284 56.77% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Queue Destination Number : 91300144 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '' LIMIT 1 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 parsing [default->91300144] continue=false Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 Regex (PASS) [91300144] destination_number(91300144) =~ /91300144/ break=on-false Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 Action export(did_user_domain=alpha3.astppbilling.org) Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 Action set(fifo_music=) Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 Action set(fifo_music=$${hold_music}) Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 Action answer() Dialplan: sofia/default/41002@alpha3.astppbilling.org:5076 Action fifo(myqueue_2 out wait) 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_state_machine.c:281 (sofia/default/41002@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_state_machine.c:640 (sofia/default/41002@alpha3.astppbilling.org:5076) State ROUTING going to sleep 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 2 Tot 14) 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_state_machine.c:647 (sofia/default/41002@alpha3.astppbilling.org:5076) State EXECUTE 2023-06-21 08:26:21.254284 56.77% [DEBUG] mod_sofia.c:213 sofia/default/41002@alpha3.astppbilling.org:5076 SOFIA EXECUTE 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_state_machine.c:323 sofia/default/41002@alpha3.astppbilling.org:5076 Standard EXECUTE EXECUTE [depth=0] sofia/default/41002@alpha3.astppbilling.org:5076 export(did_user_domain=alpha3.astppbilling.org) 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[alpha3.astppbilling.org] EXECUTE [depth=0] sofia/default/41002@alpha3.astppbilling.org:5076 set(fifo_music=) 2023-06-21 08:26:21.254284 56.77% [DEBUG] mod_dptools.c:1673 SET sofia/default/41002@alpha3.astppbilling.org:5076 [fifo_music]=[UNDEF] EXECUTE [depth=0] sofia/default/41002@alpha3.astppbilling.org:5076 set(fifo_music=local_stream://moh) 2023-06-21 08:26:21.254284 56.77% [DEBUG] mod_dptools.c:1673 SET sofia/default/41002@alpha3.astppbilling.org:5076 [fifo_music]=[local_stream://moh] EXECUTE [depth=0] sofia/default/41002@alpha3.astppbilling.org:5076 answer() 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_media.c:8651 AUDIO RTP [sofia/default/41002@alpha3.astppbilling.org:5076] 95.217.238.195 port 26546 -> 10.153.246.64 port 47734 codec: 0 ms: 20 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_rtp.c:4377 Starting timer [soft] 160 bytes per 20ms 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_media.c:8871 Activating RTCP PORT 47734 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_rtp.c:4708 RTCP send rate is: 1000 and packet rate is: 20000 Remote Port: 47734 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_media.c:8963 sofia/default/41002@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_media.c:8970 sofia/default/41002@alpha3.astppbilling.org:5076 Set 2833 dtmf receive payload to 101 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_core_media.c:8993 sofia/default/41002@alpha3.astppbilling.org:5076 Set rtp dtmf delay to 40 2023-06-21 08:26:21.254284 56.77% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/41002@alpha3.astppbilling.org:5076: v=0 o=FreeSWITCH 1687309435 1687309436 IN IP4 95.217.238.195 s=FreeSWITCH c=IN IP4 95.217.238.195 t=0 0 m=audio 26546 RTP/AVP 0 101 a=rtpmap:0 PCMU/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 a=ptime:20 a=sendrecv a=rtcp-mux a=rtcp:26546 IN IP4 95.217.238.195 2023-06-21 08:26:21.254284 56.77% [NOTICE] mod_dptools.c:1408 Channel [sofia/default/41002@alpha3.astppbilling.org:5076] has been answered 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_channel.c:3893 (sofia/default/41002@alpha3.astppbilling.org:5076) Callstate Change RINGING -> ACTIVE 2023-06-21 08:26:21.254284 56.77% [DEBUG] sofia.c:7487 Channel sofia/default/41002@alpha3.astppbilling.org:5076 entering state [completed][200] EXECUTE [depth=0] sofia/default/41002@alpha3.astppbilling.org:5076 fifo(myqueue_2 out wait) 2023-06-21 08:26:21.254284 56.77% [DEBUG] mod_local_stream.c:912 Opening Stream [moh/8000] 8000hz 2023-06-21 08:26:21.254284 56.77% [DEBUG] switch_ivr_play_say.c:1566 Codec Activated L16@8000hz 1 channels 20ms 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_ivr_play_say.c:2015 done playing file local_stream://moh 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_ivr_play_say.c:2015 done playing file local_stream://moh 2023-06-21 08:26:21.274281 56.77% [DEBUG] mod_fifo.c:2857 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_EXECUTE -> CS_HIBERNATE 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE going to sleep 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_HIBERNATE (Cur 2 Tot 14) 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_core_state_machine.c:662 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HIBERNATE 2023-06-21 08:26:21.274281 56.77% [DEBUG] mod_sofia.c:195 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA HIBERNATE 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_core_state_machine.c:417 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard HIBERNATE 2023-06-21 08:26:21.274281 56.77% [DEBUG] switch_core_state_machine.c:662 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HIBERNATE going to sleep 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_channel.c:1276 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[bridge_export_vars] [hold_music]=[/var/www/html/astpp//upload/pbx/Greeting_210623035220.wav] to sofia/default/41002@alpha3.astppbilling.org:5076 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_channel.c:1276 sofia/default/41002@alpha3.astppbilling.org:5076 EXPORTING[bridge_export_vars] [hold_music]=[/var/www/html/astpp//upload/pbx/Greeting_210623035220.wav] to sofia/default/7870463271@alpha3.astppbilling.org:5076 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_ivr_bridge.c:1681 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_HIBERNATE -> CS_CONSUME_MEDIA 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 14) 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_core_state_machine.c:659 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State CONSUME_MEDIA 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_ivr_bridge.c:1056 sofia/default/7870463271@alpha3.astppbilling.org:5076 CUSTOM HOLD 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_ivr_bridge.c:1791 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_core_state_machine.c:659 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State CONSUME_MEDIA going to sleep 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXCHANGE_MEDIA (Cur 2 Tot 14) 2023-06-21 08:26:21.294281 56.77% [DEBUG] switch_core_state_machine.c:650 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXCHANGE_MEDIA 2023-06-21 08:26:21.294281 56.77% [DEBUG] mod_sofia.c:671 SOFIA EXCHANGE_MEDIA 2023-06-21 08:26:21.674290 56.77% [DEBUG] sofia.c:7487 Channel sofia/default/41002@alpha3.astppbilling.org:5076 entering state [ready][200] 2023-06-21 08:26:21.774287 56.77% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [2271920202@alpha.astppbilling.org] from ip 157.32.125.19 2023-06-21 08:26:22.134282 55.03% [DEBUG] switch_rtp.c:1775 rtcp_stats_init: audio ssrc[3029823461] base_seq[18444] 2023-06-21 08:26:22.174296 55.03% [WARNING] sofia_reg.c:3211 Can't find user [2271920202@alpha.astppbilling.org] from 157.32.125.19 You must define a domain called 'alpha.astppbilling.org' in your directory and add a user with the id="2271920202" attribute and you must configure your device to use the proper domain in its authentication credentials. 2023-06-21 08:26:22.174296 55.03% [WARNING] sofia_reg.c:1791 SIP auth failure (REGISTER) on sofia profile 'default' for [2271920202@alpha.astppbilling.org] from ip 157.32.125.19 2023-06-21 08:26:22.174296 55.03% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [41002@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-21 08:26:22.374285 55.03% [INFO] switch_rtp.c:7471 Auto Changing audio port from 10.153.246.64:47734 to 117.228.45.182:45495 2023-06-21 08:26:34.454285 40.40% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [41002@alpha3.astppbilling.org] from ip 185.117.83.208 2023-06-21 08:26:36.274293 40.17% [DEBUG] sofia.c:7487 Channel sofia/default/41002@alpha3.astppbilling.org:5076 entering state [received][100] 2023-06-21 08:26:36.274293 40.17% [DEBUG] sofia.c:7497 Remote SDP: v=0 o=Zoiper 0 1216638703 IN IP4 10.153.246.64 s=Zoiper c=IN IP4 10.153.246.64 t=0 0 m=audio 47734 RTP/AVP 0 106 9 8 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-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1] 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 101@8000 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:5850 sofia/default/41002@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 recv payload to 101 2023-06-21 08:26:36.274293 40.17% [DEBUG] switch_core_media.c:8633 Audio params are unchanged for sofia/default/41002@alpha3.astppbilling.org:5076. 2023-06-21 08:26:36.274293 40.17% [DEBUG] sofia.c:8442 Processing updated SDP 2023-06-21 08:26:36.294292 40.17% [DEBUG] sofia.c:7487 Channel sofia/default/41002@alpha3.astppbilling.org:5076 entering state [completed][200] 2023-06-21 08:26:36.574295 40.17% [DEBUG] sofia.c:7487 Channel sofia/default/41002@alpha3.astppbilling.org:5076 entering state [ready][200] 2023-06-21 08:26:43.194293 41.20% [NOTICE] sofia.c:1065 Hangup sofia/default/41002@alpha3.astppbilling.org:5076 [CS_EXECUTE] [NORMAL_CLEARING] 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_ivr_bridge.c:911 BRIDGE THREAD DONE [sofia/default/41002@alpha3.astppbilling.org:5076] 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_ivr_bridge.c:819 sofia/default/41002@alpha3.astppbilling.org:5076 ending bridge by request from write function 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_ivr_bridge.c:911 BRIDGE THREAD DONE [sofia/default/7870463271@alpha3.astppbilling.org:5076] 2023-06-21 08:26:43.194293 41.20% [NOTICE] switch_ivr_bridge.c:1027 Hangup sofia/default/7870463271@alpha3.astppbilling.org:5076 [CS_EXCHANGE_MEDIA] [NORMAL_CLEARING] 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:650 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXCHANGE_MEDIA going to sleep 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 2 Tot 14) 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:844 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change ACTIVE -> HANGUP 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HANGUP 2023-06-21 08:26:43.194293 41.20% [DEBUG] mod_sofia.c:462 sofia/default/7870463271@alpha3.astppbilling.org:5076 Overriding SIP cause 480 with 200 from the other leg 2023-06-21 08:26:43.194293 41.20% [DEBUG] mod_sofia.c:468 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 hanging up, cause: NORMAL_CLEARING 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_ivr_bridge.c:1890 sofia/default/7870463271@alpha3.astppbilling.org:5076 skip receive message [UNBRIDGE] (channel is hungup already) 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_ivr_bridge.c:1893 sofia/default/41002@alpha3.astppbilling.org:5076 skip receive message [UNBRIDGE] (channel is hungup already) 2023-06-21 08:26:43.194293 41.20% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/7870463271@alpha3.astppbilling.org:5076 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:59 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard HANGUP, cause: NORMAL_CLEARING 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HANGUP going to sleep 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:616 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 2 Tot 14) 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_session.c:2973 sofia/default/41002@alpha3.astppbilling.org:5076 skip receive message [PHONE_EVENT] (channel is hungup already) 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:647 (sofia/default/41002@alpha3.astppbilling.org:5076) State EXECUTE going to sleep 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 2 Tot 14) 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:844 (sofia/default/41002@alpha3.astppbilling.org:5076) Callstate Change ACTIVE -> HANGUP 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:846 (sofia/default/41002@alpha3.astppbilling.org:5076) State HANGUP 2023-06-21 08:26:43.194293 41.20% [DEBUG] mod_sofia.c:468 Channel sofia/default/41002@alpha3.astppbilling.org:5076 hanging up, cause: NORMAL_CLEARING 2023-06-21 08:26:43.194293 41.20% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State REPORTING 2023-06-21 08:26:43.214282 41.20% [INFO] mod_json_cdr.c:272 Process [fed14196-8415-4571-a3b0-53d97f710c5f.cdr.json] 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:59 sofia/default/41002@alpha3.astppbilling.org:5076 Standard HANGUP, cause: NORMAL_CLEARING 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:846 (sofia/default/41002@alpha3.astppbilling.org:5076) State HANGUP going to sleep 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:616 (sofia/default/41002@alpha3.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:581 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 2 Tot 14) 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:932 (sofia/default/41002@alpha3.astppbilling.org:5076) State REPORTING 2023-06-21 08:26:43.214282 41.20% [INFO] mod_json_cdr.c:272 Process [bc5327ab-ac87-4ad8-b390-4898058a424b.cdr.json] 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:168 sofia/default/41002@alpha3.astppbilling.org:5076 Standard REPORTING, cause: NORMAL_CLEARING 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:932 (sofia/default/41002@alpha3.astppbilling.org:5076) State REPORTING going to sleep 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:607 (sofia/default/41002@alpha3.astppbilling.org:5076) State Change CS_REPORTING -> CS_DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_session.c:1743 Session 14 (sofia/default/41002@alpha3.astppbilling.org:5076) Locked, Waiting on external entities 2023-06-21 08:26:43.214282 41.20% [NOTICE] switch_core_session.c:1761 Session 14 (sofia/default/41002@alpha3.astppbilling.org:5076) Ended 2023-06-21 08:26:43.214282 41.20% [NOTICE] switch_core_session.c:1765 Close Channel sofia/default/41002@alpha3.astppbilling.org:5076 [CS_DESTROY] 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:168 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard REPORTING, cause: NORMAL_CLEARING 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State REPORTING going to sleep 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:735 (sofia/default/41002@alpha3.astppbilling.org:5076) Running State Change CS_DESTROY (Cur 1 Tot 14) 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:745 (sofia/default/41002@alpha3.astppbilling.org:5076) State DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] mod_sofia.c:379 sofia/default/41002@alpha3.astppbilling.org:5076 SOFIA DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:607 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_REPORTING -> CS_DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_session.c:1743 Session 13 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Locked, Waiting on external entities 2023-06-21 08:26:43.214282 41.20% [NOTICE] switch_core_session.c:1761 Session 13 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Ended 2023-06-21 08:26:43.214282 41.20% [NOTICE] switch_core_session.c:1765 Close Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 [CS_DESTROY] 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:175 sofia/default/41002@alpha3.astppbilling.org:5076 Standard DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:745 (sofia/default/41002@alpha3.astppbilling.org:5076) State DESTROY going to sleep 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:735 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_DESTROY (Cur 0 Tot 14) 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] mod_sofia.c:379 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:175 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard DESTROY 2023-06-21 08:26:43.214282 41.20% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State DESTROY going to sleep