freeswitch@ip-172-31-43-241> 2021-12-23 12:09:25.586546 95.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/9693017122@pkcall.astppbilling.org:5022 [a611756f-41d2-42d3-b7b4-dfa316850cfe] 2021-12-23 12:09:25.586546 95.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_NEW (Cur 1 Tot 20) 2021-12-23 12:09:25.586546 95.67% [INFO] sofia.c:10462 sofia/default/9693017122@pkcall.astppbilling.org:5022 receiving invite from 117.247.91.162:40516 version: 1.10.7 -release-19-883d2cb662 64bit call-id: ZjVkMGU2MzhmNTAwNjViYWQwZTljYzY0ZDEzMTczOGU. 2021-12-23 12:09:25.586546 95.67% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0. 2021-12-23 12:09:25.586546 95.67% [DEBUG] sofia.c:2419 detaching session a611756f-41d2-42d3-b7b4-dfa316850cfe 2021-12-23 12:09:25.586546 95.67% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [330444@pkcall.astppbilling.org] from ip 117.247.91.162 2021-12-23 12:09:25.586546 95.67% [DEBUG] switch_core_state_machine.c:600 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State NEW 2021-12-23 12:09:26.186547 95.63% [DEBUG] sofia.c:2532 Re-attaching to session a611756f-41d2-42d3-b7b4-dfa316850cfe 2021-12-23 12:09:26.186547 95.63% [INFO] sofia.c:10462 sofia/default/9693017122@pkcall.astppbilling.org:5022 receiving invite from 117.247.91.162:40516 version: 1.10.7 -release-19-883d2cb662 64bit call-id: ZjVkMGU2MzhmNTAwNjViYWQwZTljYzY0ZDEzMTczOGU. 2021-12-23 12:09:26.186547 95.63% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0. 2021-12-23 12:09:26.206527 95.63% [DEBUG] sofia.c:11672 Setting NAT mode based on via received 2021-12-23 12:09:26.206527 95.63% [DEBUG] sofia.c:7499 Channel sofia/default/9693017122@pkcall.astppbilling.org:5022 entering state [received][100] 2021-12-23 12:09:26.206527 95.63% [DEBUG] sofia.c:7509 Remote SDP: v=0 o=Z 0 0 IN IP4 117.247.91.162 s=Z c=IN IP4 117.247.91.162 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 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1] 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/9693017122@pkcall.astppbilling.org:5022 PCMA/8000 20 ms 160 samples 64000 bits 1 channels 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_codec.c:111 sofia/default/9693017122@pkcall.astppbilling.org:5022 Original read codec set to PCMA:8 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_media.c:5973 sofia/default/9693017122@pkcall.astppbilling.org:5022 Set 2833 dtmf send payload to 101 recv payload to 101 2021-12-23 12:09:26.206527 95.63% [DEBUG] sofia.c:7933 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_NEW -> CS_INIT 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_INIT (Cur 1 Tot 20) 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State INIT 2021-12-23 12:09:26.206527 95.63% [DEBUG] mod_sofia.c:97 sofia/default/9693017122@pkcall.astppbilling.org:5022 SOFIA INIT 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:40 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard INIT 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:48 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_INIT -> CS_ROUTING 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State INIT going to sleep 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_ROUTING (Cur 1 Tot 20) 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_channel.c:2380 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Callstate Change DOWN -> RINGING 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State ROUTING 2021-12-23 12:09:26.206527 95.63% [DEBUG] mod_sofia.c:158 sofia/default/9693017122@pkcall.astppbilling.org:5022 SOFIA ROUTING 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_core_state_machine.c:230 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard ROUTING 2021-12-23 12:09:26.206527 95.63% [INFO] mod_dialplan_xml.c:639 Processing 9693017122 <9693017122>->330444 in context default 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.206527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2021-12-23 12:09:26.206527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 330444 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '330444' limit 1 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '330444' AND status=0 limit 1 2021-12-23 12:09:26.206527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '330444' and status=0 LIMIT 1 2021-12-23 12:09:26.226527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9693017122 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'pkcall.astppbilling.org' limit 1 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '4' and username = '330444' limit 1 2021-12-23 12:09:26.226527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9693017122 / 9693017122 2021-12-23 12:09:26.226527 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="330444" LIMIT 1 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="330444" LIMIT 1 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.226527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2021-12-23 12:09:26.226527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9693017122] 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9693017122" AND deleted = 0 limit 1 2021-12-23 12:09:26.226527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="330444" AND (accountid = 0 OR status = 1) LIMIT 1 2021-12-23 12:09:26.246528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2021-12-23 12:09:26.246528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 7 2021-12-23 12:09:26.246528 95.63% [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 (patterns = '^330444.*' OR patterns = '^33044.*' OR patterns = '^3304.*' OR patterns = '^330.*' OR patterns = '^33.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 7 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-12-23 12:09:26.246528 95.63% [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 ="330444" AND A.accountid = '4' limit 1 2021-12-23 12:09:26.246528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 330444 2021-12-23 12:09:26.246528 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="330444" LIMIT 1 2021-12-23 12:09:26.246528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="330444" LIMIT 1 2021-12-23 12:09:26.246528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2021-12-23 12:09:26.266529 95.63% [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 = '330444' OR number = '33044' OR number = '3304' OR number = '330' OR number = '33' OR number = '3' OR number ='--') OR (number = '330444*' OR number = '33044*' OR number = '3304*' OR number = '330*' OR number = '33*' OR number = '3*' OR number ='--') OR (number = '9693017122' OR number = '969301712' OR number = '96930171' OR number = '9693017' OR number = '969301' OR number = '96930' OR number = '9693' OR number = '969' OR number = '96' OR number = '9' OR number ='--') OR (number = '9693017122*' OR number = '969301712*' OR number = '96930171*' OR number = '9693017*' OR number = '969301*' OR number = '96930*' OR number = '9693*' OR number = '969*' OR number = '96*' OR number = '9*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '330444' OR routing_prefix = '33044' OR routing_prefix = '3304' OR routing_prefix = '330' OR routing_prefix = '33' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 4 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9693017122 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 394.7 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2021-12-23 12:09:26.266529 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="330444" LIMIT 1 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="330444" LIMIT 1 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 2 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 330444 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 4 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your394.7 balance Accountid 4 !!! 2021-12-23 12:09:26.266529 95.63% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2021-12-23 12:09:26.266529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2021-12-23 12:09:26.266529 95.63% [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 = 4 AND status=0 LIMIT 1 2021-12-23 12:09:26.266529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "7" AND deleted = 0 limit 1 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:4 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:4 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 4 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 7 limit 1 2021-12-23 12:09:26.286528 95.63% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : payfast.astppbilling.org 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"33022220444#","no_answer_call_type":"12"}] 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition : [{"hour":"00-23","minute":"00-59","wday":"7-7","mday":"1-31","mon":"12-12","year":"2021-2021","extensions":"33088888800000#","no_answer_call_type":"12","priority":"3"},{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-12","year":"2021-2021","extensions":"5","no_answer_call_type":"7","priority":"2"},{"hour":"00-23","minute":"00-59","wday":"2-7","mday":"1-31","mon":"1-12","year":"2021-2022","extensions":"14","no_answer_call_type":"11","priority":"1"}] 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 3 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str : time-of-day= "00:00-23:59" wday= "7-7" mday= "1-31" mon= "12-12" year= "2021-2021" 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 2 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2021-12-23 12:09:26.286528 95.63% [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= "2021-2021" 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "14" limit 1 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str : time-of-day= "00:00-23:59" wday= "2-7" mday= "1-31" mon= "1-12" year= "2021-2022" 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2021-12-23 12:09:26.286528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2021-12-23 12:09:26.286528 95.63% [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 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 7 limit 1 2021-12-23 12:09:26.286528 95.63% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : payfast.astppbilling.org 2021-12-23 12:09:26.286528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 7 and status = 0 limit 1 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11 2021-12-23 12:09:26.306530 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/Time Match (PASS) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(office_status=open) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(office_status=open) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [office_status]=[open] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(extensions=33022220444#) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(extensions=33022220444#) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [extensions]=[33022220444#] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=12) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=12) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[12] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Absolute Condition [TC_PK_reseller_Cust] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(timezone=Europe/Sarajevo) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/TimeMatch (FAIL) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Absolute Condition [TC_PK_reseller_Cust] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(timezone=Europe/Sarajevo) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/Time Match (PASS) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(office_status=open) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(office_status=open) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [office_status]=[open] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(extensions=5) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(extensions=5) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [extensions]=[5] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=7) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=7) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[7] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Absolute Condition [TC_PK_reseller_Cust] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(timezone=Europe/Sarajevo) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/Time Match (PASS) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(office_status=open) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(office_status=open) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [office_status]=[open] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(extensions=6258825497) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(extensions=6258825497) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [extensions]=[6258825497] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=11) INLINE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=11) 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[11] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->tod route, x330444] continue=false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Regex (PASS) [tod route, x330444] destination_number(330444) =~ /^(\+?)?(330444)$/ break=on-false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action execute_extension(330444_${office_status}) 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_core_state_machine.c:281 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_ROUTING -> CS_EXECUTE 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State ROUTING going to sleep 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_EXECUTE (Cur 1 Tot 20) 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_core_state_machine.c:647 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State EXECUTE 2021-12-23 12:09:26.306530 95.63% [DEBUG] mod_sofia.c:213 sofia/default/9693017122@pkcall.astppbilling.org:5022 SOFIA EXECUTE 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_core_state_machine.c:323 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard EXECUTE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 execute_extension(330444_open) 2021-12-23 12:09:26.306530 95.63% [INFO] mod_dialplan_xml.c:639 Processing 9693017122 <9693017122>->330444_open in context default 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-12-23 12:09:26.306530 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.326526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2021-12-23 12:09:26.326526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 330444 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '330444' limit 1 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '330444' AND status=0 limit 1 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '330444' and status=0 LIMIT 1 2021-12-23 12:09:26.326526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9693017122 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'pkcall.astppbilling.org' limit 1 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '4' and username = '330444' limit 1 2021-12-23 12:09:26.326526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9693017122 / 9693017122 2021-12-23 12:09:26.326526 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="330444" LIMIT 1 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="330444" LIMIT 1 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.326526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound 2021-12-23 12:09:26.326526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9693017122] 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9693017122" AND deleted = 0 limit 1 2021-12-23 12:09:26.326526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="330444" AND (accountid = 0 OR status = 1) LIMIT 1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 7 2021-12-23 12:09:26.346526 95.63% [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 (patterns = '^330444.*' OR patterns = '^33044.*' OR patterns = '^3304.*' OR patterns = '^330.*' OR patterns = '^33.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 7 ORDER BY LENGTH(PKGPTR.patterns) DESC 2021-12-23 12:09:26.346526 95.63% [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 ="330444" AND A.accountid = '4' limit 1 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 330444 2021-12-23 12:09:26.346526 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="330444" LIMIT 1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="330444" LIMIT 1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound 2021-12-23 12:09:26.346526 95.63% [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 = '330444' OR number = '33044' OR number = '3304' OR number = '330' OR number = '33' OR number = '3' OR number ='--') OR (number = '330444*' OR number = '33044*' OR number = '3304*' OR number = '330*' OR number = '33*' OR number = '3*' OR number ='--') OR (number = '9693017122' OR number = '969301712' OR number = '96930171' OR number = '9693017' OR number = '969301' OR number = '96930' OR number = '9693' OR number = '969' OR number = '96' OR number = '9' OR number ='--') OR (number = '9693017122*' OR number = '969301712*' OR number = '96930171*' OR number = '9693017*' OR number = '969301*' OR number = '96930*' OR number = '9693*' OR number = '969*' OR number = '96*' OR number = '9*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '330444' OR routing_prefix = '33044' OR routing_prefix = '3304' OR routing_prefix = '330' OR routing_prefix = '33' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information =================== 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 4 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9693017122 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 394.7 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid] 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] ======================================================== 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound 2021-12-23 12:09:26.346526 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="330444" LIMIT 1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="330444" LIMIT 1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Direction : inbound 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information =================== 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 2 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 330444 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 4 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================ 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your394.7 balance Accountid 4 !!! 2021-12-23 12:09:26.346526 95.63% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length :: 100 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE 2021-12-23 12:09:26.346526 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1 2021-12-23 12:09:26.346526 95.63% [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 = 4 AND status=0 LIMIT 1 2021-12-23 12:09:26.346526 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "7" AND deleted = 0 limit 1 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:4 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:4 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 4 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 7 limit 1 2021-12-23 12:09:26.366529 95.63% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : payfast.astppbilling.org 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"33022220444#","no_answer_call_type":"12"}] 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition : [{"hour":"00-23","minute":"00-59","wday":"7-7","mday":"1-31","mon":"12-12","year":"2021-2021","extensions":"33088888800000#","no_answer_call_type":"12","priority":"3"},{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-12","year":"2021-2021","extensions":"5","no_answer_call_type":"7","priority":"2"},{"hour":"00-23","minute":"00-59","wday":"2-7","mday":"1-31","mon":"1-12","year":"2021-2022","extensions":"14","no_answer_call_type":"11","priority":"1"}] 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 3 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str : time-of-day= "00:00-23:59" wday= "7-7" mday= "1-31" mon= "12-12" year= "2021-2021" 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 2 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2021-12-23 12:09:26.366529 95.63% [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= "2021-2021" 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "14" limit 1 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str : time-of-day= "00:00-23:59" wday= "2-7" mday= "1-31" mon= "1-12" year= "2021-2022" 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] Maxlength : 100 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound 2021-12-23 12:09:26.366529 95.63% [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 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 7 limit 1 2021-12-23 12:09:26.366529 95.63% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : payfast.astppbilling.org 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 7 and status = 0 limit 1 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11 2021-12-23 12:09:26.366529 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1 2021-12-23 12:09:26.366529 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/Time Match (PASS) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(office_status=open) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(office_status=open) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [office_status]=[open] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(extensions=33022220444#) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(extensions=33022220444#) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [extensions]=[33022220444#] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=12) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=12) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[12] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Absolute Condition [TC_PK_reseller_Cust] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(timezone=Europe/Sarajevo) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/TimeMatch (FAIL) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Absolute Condition [TC_PK_reseller_Cust] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(timezone=Europe/Sarajevo) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/Time Match (PASS) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(office_status=open) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(office_status=open) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [office_status]=[open] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(extensions=5) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(extensions=5) 2021-12-23 12:09:26.366529 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [extensions]=[5] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=7) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=7) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[7] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->TC_PK_reseller_Cust] continue=true Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Absolute Condition [TC_PK_reseller_Cust] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(timezone=Europe/Sarajevo) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(timezone=Europe/Sarajevo) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [timezone]=[Europe/Sarajevo] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Date/Time Match (PASS) [TC_PK_reseller_Cust] break=never Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(office_status=open) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(office_status=open) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [office_status]=[open] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(extensions=6258825497) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(extensions=6258825497) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [extensions]=[6258825497] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=11) INLINE EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=11) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[11] Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->tod route, x330444] continue=false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Regex (FAIL) [tod route, x330444] destination_number(330444_open) =~ /^(\+?)?(330444)$/ break=on-false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->office is open] continue=false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Regex (PASS) [office is open] destination_number(330444_open) =~ /^(\+?)?(330444_open)$/ break=on-false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(domain_name=payfast.astppbilling.org) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(set_extensions=${extensions}) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_flag=true) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_call_type=${no_answer_call_type}) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_number=${extensions}) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action transfer(7 XML default) 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(domain_name=payfast.astppbilling.org) EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(domain_name=payfast.astppbilling.org) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [domain_name]=[payfast.astppbilling.org] 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(set_extensions=${extensions}) EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(set_extensions=6258825497) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [set_extensions]=[6258825497] 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_flag=true) EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_flag=true) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_flag]=[true] 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type}) EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_call_type=11) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_call_type]=[11] 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_number=${extensions}) EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_number=6258825497) 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_number]=[6258825497] 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_core_session.c:3095 Execute [depth=1] transfer(7 XML default) EXECUTE [depth=1] sofia/default/9693017122@pkcall.astppbilling.org:5022 transfer(7 XML default) 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_ivr.c:2289 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_EXECUTE -> CS_ROUTING 2021-12-23 12:09:26.386532 95.63% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/9693017122@pkcall.astppbilling.org:5022 to XML[7@default] 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_core_state_machine.c:647 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State EXECUTE going to sleep 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_ROUTING (Cur 1 Tot 20) 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State ROUTING 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged 2021-12-23 12:09:26.386532 95.63% [DEBUG] mod_sofia.c:158 sofia/default/9693017122@pkcall.astppbilling.org:5022 SOFIA ROUTING 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_core_state_machine.c:230 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard ROUTING 2021-12-23 12:09:26.386532 95.63% [INFO] mod_dialplan_xml.c:639 Processing 9693017122 <9693017122>->7 in context default 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-12-23 12:09:26.386532 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.406527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0 2021-12-23 12:09:26.406527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 7 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '7' limit 1 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '7' AND status=0 limit 1 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '7' and status=0 LIMIT 1 2021-12-23 12:09:26.406527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9693017122 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'pkcall.astppbilling.org' limit 1 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '4' and username = '7' limit 1 2021-12-23 12:09:26.406527 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number : 9693017122 / 9693017122 2021-12-23 12:09:26.406527 95.63% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7" LIMIT 1 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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.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 ="7" LIMIT 1 2021-12-23 12:09:26.406527 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons 2021-12-23 12:09:26.406527 95.63% [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 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="7" AND domains.domain="pkcall.astppbilling.org" limit 1 2021-12-23 12:09:26.426528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound 2021-12-23 12:09:26.426528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9693017122] 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9693017122" AND deleted = 0 limit 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^7.*' OR blocked_patterns ='--') AND accountid = 4 limit 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="7" AND (accountid = 0 OR status = 1) LIMIT 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "7" AND deleted = 0 limit 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^7.*' OR blocked_patterns ='--') AND accountid = 7 limit 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :7 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 7 limit 1 2021-12-23 12:09:26.426528 95.63% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainpayfast.astppbilling.org 2021-12-23 12:09:26.426528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 11 2021-12-23 12:09:26.426528 95.63% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Time Conditions 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_extensions_forwarding] Query :select sip_devices.id,sip_device_routing.call_forwarding_flag,sip_device_routing.call_forwarding_destination from sip_devices JOIN sip_device_routing ON sip_devices.id = sip_device_routing.sip_device_id where sip_devices.username = "6258825497" 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer_attended' limit 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer' limit 1 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 parsing [default->7] continue=false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Regex (PASS) [7] destination_number(7) =~ /7/ break=on-false Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action export(presence_data=x|||Customer Of(7135873514)|||||||||DID|||117.247.91.162) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action export(did_user_domain=pkcall.astppbilling.org) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(continue_on_fail=TRUE) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(ignore_early_media=true) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(no_answer_flag=false) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(did_calltype=11) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(did_extensions=6258825497) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(sip_destination_number=6258825497) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(sip_to_host=payfast.astppbilling.org) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(user_domain=payfast.astppbilling.org) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action db(insert/pickup_any_group_${callgroup}/6258825497/${uuid}) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action set(dialed_extension=transfer_call) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action export(dialed_extension=transfer_call) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action export(ring_group_transfer=true) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action bridge(user/6258825497@payfast.astppbilling.org) Dialplan: sofia/default/9693017122@pkcall.astppbilling.org:5022 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua) 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_core_state_machine.c:281 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_ROUTING -> CS_EXECUTE 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State ROUTING going to sleep 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_EXECUTE (Cur 1 Tot 20) 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_core_state_machine.c:647 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State EXECUTE 2021-12-23 12:09:26.426528 95.63% [DEBUG] mod_sofia.c:213 sofia/default/9693017122@pkcall.astppbilling.org:5022 SOFIA EXECUTE 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_core_state_machine.c:323 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard EXECUTE EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 export(presence_data=x|||Customer Of(7135873514)|||||||||DID|||117.247.91.162) 2021-12-23 12:09:26.426528 95.63% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||Customer Of(7135873514)|||||||||DID|||117.247.91.162] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 export(did_user_domain=pkcall.astppbilling.org) 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[pkcall.astppbilling.org] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(continue_on_fail=TRUE) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [continue_on_fail]=[TRUE] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(ignore_early_media=true) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [ignore_early_media]=[true] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(no_answer_flag=false) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [no_answer_flag]=[false] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(did_calltype=11) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [did_calltype]=[11] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(did_extensions=6258825497) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [did_extensions]=[6258825497] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(sip_destination_number=6258825497) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [sip_destination_number]=[6258825497] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(sip_to_host=payfast.astppbilling.org) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [sip_to_host]=[payfast.astppbilling.org] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(user_domain=payfast.astppbilling.org) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [user_domain]=[payfast.astppbilling.org] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 db(insert/pickup_any_group_/6258825497/a611756f-41d2-42d3-b7b4-dfa316850cfe) EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 set(dialed_extension=transfer_call) 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_dptools.c:1685 SET sofia/default/9693017122@pkcall.astppbilling.org:5022 [dialed_extension]=[transfer_call] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 export(dialed_extension=transfer_call) 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [dialed_extension]=[transfer_call] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default) 2021-12-23 12:09:26.446539 95.63% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default) 2021-12-23 12:09:26.446539 95.63% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 export(ring_group_transfer=true) 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [ring_group_transfer]=[true] EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 bridge(user/6258825497@payfast.astppbilling.org) 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [presence_data]=[x|||Customer Of(7135873514)|||||||||DID|||117.247.91.162] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [did_user_domain]=[pkcall.astppbilling.org] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [ring_group_transfer]=[true] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [presence_data]=[x|||Customer Of(7135873514)|||||||||DID|||117.247.91.162] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [did_user_domain]=[pkcall.astppbilling.org] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_channel.c:1269 sofia/default/9693017122@pkcall.astppbilling.org:5022 EXPORTING[export_vars] [ring_group_transfer]=[true] to event 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables 2021-12-23 12:09:26.446539 95.63% [NOTICE] switch_channel.c:1123 New Channel sofia/default/6258825497@49.34.152.238:39134 [1007ac12-5397-493c-ab6a-bca6ee60ff4f] 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_sofia.c:5121 (sofia/default/6258825497@49.34.152.238:39134) State Change CS_NEW -> CS_INIT 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6258825497@49.34.152.238:39134) Running State Change CS_INIT (Cur 2 Tot 21) 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:624 (sofia/default/6258825497@49.34.152.238:39134) State INIT 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_sofia.c:97 sofia/default/6258825497@49.34.152.238:39134 SOFIA INIT 2021-12-23 12:09:26.446539 95.63% [DEBUG] sofia_glue.c:1620 sip:6258825497@49.34.152.238:47125;transport=TCP;rinstance=d3464f7335d94f31 Setting proxy route to sofia/default/6258825497@49.34.152.238:39134 2021-12-23 12:09:26.446539 95.63% [INFO] sofia_glue.c:1651 sofia/default/6258825497@49.34.152.238:39134 sending invite call-id: (null) 2021-12-23 12:09:26.446539 95.63% [DEBUG] sofia_glue.c:1654 sofia/default/6258825497@49.34.152.238:39134 sending invite version: 1.10.7 -release-19-883d2cb662 64bit Local SDP: v=0 o=FreeSWITCH 1640239938 1640239939 IN IP4 3.23.127.90 s=FreeSWITCH c=IN IP4 3.23.127.90 t=0 0 m=audio 21428 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 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:40 sofia/default/6258825497@49.34.152.238:39134 Standard INIT 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:48 (sofia/default/6258825497@49.34.152.238:39134) State Change CS_INIT -> CS_ROUTING 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:624 (sofia/default/6258825497@49.34.152.238:39134) State INIT going to sleep 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6258825497@49.34.152.238:39134) Running State Change CS_ROUTING (Cur 2 Tot 21) 2021-12-23 12:09:26.446539 95.63% [DEBUG] sofia.c:7499 Channel sofia/default/6258825497@49.34.152.238:39134 entering state [calling][0] 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:640 (sofia/default/6258825497@49.34.152.238:39134) State ROUTING 2021-12-23 12:09:26.446539 95.63% [DEBUG] mod_sofia.c:158 sofia/default/6258825497@49.34.152.238:39134 SOFIA ROUTING 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_ivr_originate.c:67 (sofia/default/6258825497@49.34.152.238:39134) State Change CS_ROUTING -> CS_CONSUME_MEDIA 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:640 (sofia/default/6258825497@49.34.152.238:39134) State ROUTING going to sleep 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6258825497@49.34.152.238:39134) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 21) 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:659 (sofia/default/6258825497@49.34.152.238:39134) State CONSUME_MEDIA 2021-12-23 12:09:26.446539 95.63% [DEBUG] switch_core_state_machine.c:659 (sofia/default/6258825497@49.34.152.238:39134) State CONSUME_MEDIA going to sleep 2021-12-23 12:09:27.306587 94.13% [DEBUG] sofia.c:7499 Channel sofia/default/6258825497@49.34.152.238:39134 entering state [proceeding][180] 2021-12-23 12:09:27.306587 94.13% [NOTICE] sofia.c:7610 Ring-Ready sofia/default/6258825497@49.34.152.238:39134! 2021-12-23 12:09:27.306587 94.13% [DEBUG] switch_channel.c:3494 (sofia/default/6258825497@49.34.152.238:39134) Callstate Change DOWN -> RINGING 2021-12-23 12:09:27.326499 94.13% [NOTICE] mod_sofia.c:2515 Ring-Ready sofia/default/9693017122@pkcall.astppbilling.org:5022! 2021-12-23 12:09:27.326499 94.13% [DEBUG] sofia.c:7499 Channel sofia/default/9693017122@pkcall.astppbilling.org:5022 entering state [early][180] 2021-12-23 12:09:27.326499 94.13% [NOTICE] switch_ivr_originate.c:565 Ring Ready sofia/default/9693017122@pkcall.astppbilling.org:5022! 2021-12-23 12:10:26.006530 96.37% [NOTICE] switch_ivr_originate.c:3799 Hangup sofia/default/6258825497@49.34.152.238:39134 [CS_CONSUME_MEDIA] [NO_ANSWER] 2021-12-23 12:10:26.026524 96.37% [NOTICE] switch_ivr_originate.c:3039 Cannot create outgoing channel of type [user] cause: [NO_ANSWER] 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 19 [NO_ANSWER] 2021-12-23 12:10:26.026524 96.37% [INFO] mod_dptools.c:3653 Originate Failed. Cause: NO_ANSWER EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 lua(astpp/lib/pbx/astpp-sipdevice-routing.lua) 2021-12-23 12:10:26.026524 96.37% [NOTICE] switch_cpp.cpp:1465 [Astpp_SIP-Devices] This Is Last Dispositions NO_ANSWER This Is SIP Number : 6258825497 EXECUTE [depth=0] sofia/default/9693017122@pkcall.astppbilling.org:5022 answer() 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/9693017122@pkcall.astppbilling.org:5022] 172.31.43.241 port 27288 -> 117.247.91.162 port 8000 codec: 8 ms: 20 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6258825497@49.34.152.238:39134) Running State Change CS_HANGUP (Cur 2 Tot 21) 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:844 (sofia/default/6258825497@49.34.152.238:39134) Callstate Change RINGING -> HANGUP 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/6258825497@49.34.152.238:39134) State HANGUP 2021-12-23 12:10:26.026524 96.37% [DEBUG] mod_sofia.c:468 Channel sofia/default/6258825497@49.34.152.238:39134 hanging up, cause: NO_ANSWER 2021-12-23 12:10:26.026524 96.37% [DEBUG] mod_sofia.c:536 Sending CANCEL to sofia/default/6258825497@49.34.152.238:39134 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:59 sofia/default/6258825497@49.34.152.238:39134 Standard HANGUP, cause: NO_ANSWER 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/6258825497@49.34.152.238:39134) State HANGUP going to sleep 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:616 (sofia/default/6258825497@49.34.152.238:39134) State Change CS_HANGUP -> CS_REPORTING 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/6258825497@49.34.152.238:39134) Running State Change CS_REPORTING (Cur 2 Tot 21) 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/6258825497@49.34.152.238:39134) State REPORTING 2021-12-23 12:10:26.026524 96.37% [INFO] mod_json_cdr.c:271 Process [1007ac12-5397-493c-ab6a-bca6ee60ff4f.cdr.json] 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_media.c:9089 sofia/default/9693017122@pkcall.astppbilling.org:5022 Set 2833 dtmf send payload to 101 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_media.c:9096 sofia/default/9693017122@pkcall.astppbilling.org:5022 Set 2833 dtmf receive payload to 101 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_media.c:9119 sofia/default/9693017122@pkcall.astppbilling.org:5022 Set rtp dtmf delay to 40 2021-12-23 12:10:26.026524 96.37% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/9693017122@pkcall.astppbilling.org:5022: v=0 o=FreeSWITCH 1640234138 1640234139 IN IP4 3.23.127.90 s=FreeSWITCH c=IN IP4 3.23.127.90 t=0 0 m=audio 27288 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 2021-12-23 12:10:26.026524 96.37% [DEBUG] sofia.c:7499 Channel sofia/default/9693017122@pkcall.astppbilling.org:5022 entering state [completed][200] 2021-12-23 12:10:26.026524 96.37% [NOTICE] mod_dptools.c:1419 Channel [sofia/default/9693017122@pkcall.astppbilling.org:5022] has been answered 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_channel.c:3950 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Callstate Change RINGING -> ACTIVE 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes') 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:168 sofia/default/6258825497@49.34.152.238:39134 Standard REPORTING, cause: NO_ANSWER 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/6258825497@49.34.152.238:39134) State REPORTING going to sleep 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:607 (sofia/default/6258825497@49.34.152.238:39134) State Change CS_REPORTING -> CS_DESTROY 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_session.c:1753 Session 21 (sofia/default/6258825497@49.34.152.238:39134) Locked, Waiting on external entities 2021-12-23 12:10:26.026524 96.37% [NOTICE] switch_core_session.c:1771 Session 21 (sofia/default/6258825497@49.34.152.238:39134) Ended 2021-12-23 12:10:26.026524 96.37% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/6258825497@49.34.152.238:39134 [CS_DESTROY] 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:735 (sofia/default/6258825497@49.34.152.238:39134) Running State Change CS_DESTROY (Cur 1 Tot 21) 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/6258825497@49.34.152.238:39134) State DESTROY 2021-12-23 12:10:26.026524 96.37% [DEBUG] mod_sofia.c:379 sofia/default/6258825497@49.34.152.238:39134 SOFIA DESTROY 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:175 sofia/default/6258825497@49.34.152.238:39134 Standard DESTROY 2021-12-23 12:10:26.026524 96.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/6258825497@49.34.152.238:39134) State DESTROY going to sleep 2021-12-23 12:10:26.046881 96.37% [NOTICE] switch_cpp.cpp:1465 [Astpp_SIP-Devices] dialed_user for voicemail::: 6258825497 2021-12-23 12:10:26.046881 96.37% [ERR] mod_lua.cpp:202 ...switch/scripts/astpp/lib/pbx/astpp-custom-voice-mail.lua:55: attempt to concatenate local 'userinfo_id' (a nil value) stack traceback: ...switch/scripts/astpp/lib/pbx/astpp-custom-voice-mail.lua:55: in function 'custom_voicemail' ...switch/scripts/astpp/lib/pbx/astpp-sipdevice-routing.lua:110: in main chunk 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_cpp.cpp:1209 sofia/default/9693017122@pkcall.astppbilling.org:5022 destroy/unlink session from object 2021-12-23 12:10:26.046881 96.37% [NOTICE] switch_core_state_machine.c:382 sofia/default/9693017122@pkcall.astppbilling.org:5022 has executed the last dialplan instruction, hanging up. 2021-12-23 12:10:26.046881 96.37% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/9693017122@pkcall.astppbilling.org:5022 [CS_EXECUTE] [NORMAL_CLEARING] 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:647 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State EXECUTE going to sleep 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_HANGUP (Cur 1 Tot 21) 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_channel.c:3990 sofia/default/9693017122@pkcall.astppbilling.org:5022 skip receive message [VIDEO_SYNC] (channel is hungup already) 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:844 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Callstate Change ACTIVE -> HANGUP 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State HANGUP 2021-12-23 12:10:26.046881 96.37% [DEBUG] mod_sofia.c:468 Channel sofia/default/9693017122@pkcall.astppbilling.org:5022 hanging up, cause: NORMAL_CLEARING 2021-12-23 12:10:26.046881 96.37% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/9693017122@pkcall.astppbilling.org:5022 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:59 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard HANGUP, cause: NORMAL_CLEARING 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State HANGUP going to sleep 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:616 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_HANGUP -> CS_REPORTING 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_REPORTING (Cur 1 Tot 21) 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State REPORTING 2021-12-23 12:10:26.046881 96.37% [INFO] mod_json_cdr.c:271 Process [a611756f-41d2-42d3-b7b4-dfa316850cfe.cdr.json] 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:168 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard REPORTING, cause: NORMAL_CLEARING 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State REPORTING going to sleep 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:607 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State Change CS_REPORTING -> CS_DESTROY 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_session.c:1753 Session 20 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Locked, Waiting on external entities 2021-12-23 12:10:26.046881 96.37% [NOTICE] switch_core_session.c:1771 Session 20 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Ended 2021-12-23 12:10:26.046881 96.37% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/9693017122@pkcall.astppbilling.org:5022 [CS_DESTROY] 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:735 (sofia/default/9693017122@pkcall.astppbilling.org:5022) Running State Change CS_DESTROY (Cur 0 Tot 21) 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State DESTROY 2021-12-23 12:10:26.046881 96.37% [DEBUG] mod_sofia.c:379 sofia/default/9693017122@pkcall.astppbilling.org:5022 SOFIA DESTROY 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:175 sofia/default/9693017122@pkcall.astppbilling.org:5022 Standard DESTROY 2021-12-23 12:10:26.046881 96.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9693017122@pkcall.astppbilling.org:5022) State DESTROY going to sleep freeswitch@ip-172-31-43-241>