2023-06-16 03:49:12.096300 96.10% [NOTICE] switch_channel.c:1123 New Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [f2b5318a-799f-4039-86a3-8bcc2119c47a]
2023-06-16 03:49:12.096300 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_NEW (Cur 1 Tot 580)
2023-06-16 03:49:12.096300 96.10% [INFO] sofia.c:10462 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 receiving invite from 78.47.101.152:5060 version: 1.10.7 -release 64bit call-id: YjE2MWM4MzgxNmE3NmVhNGU2ZTEwNjgxODQ3ZDdhNjg.
2023-06-16 03:49:12.096300 96.10% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 78.47.101.152:0.
2023-06-16 03:49:12.096300 96.10% [DEBUG] sofia.c:10585 IP 78.47.101.152 Approved by acl "default[]". Access Granted.
2023-06-16 03:49:12.116266 96.10% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [received][100]
2023-06-16 03:49:12.116266 96.10% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Z 0 0 IN IP4 103.240.35.46
s=Z
c=IN IP4 103.240.35.46
t=0 0
m=audio 8000 RTP/AVP 3 110 8 0 98 101
a=rtpmap:110 speex/8000
a=rtpmap:98 iLBC/8000
a=fmtp:98 mode=20
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15

2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/986057@clusterguibeta5.astppbilling.org:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_codec.c:111 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Original read codec set to PCMA:8
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_media.c:5973 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf send payload to 101 recv payload to 101
2023-06-16 03:49:12.116266 96.10% [DEBUG] sofia.c:7933 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_NEW -> CS_INIT
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:600 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State NEW
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_INIT (Cur 1 Tot 580)
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:624 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State INIT
2023-06-16 03:49:12.116266 96.10% [DEBUG] mod_sofia.c:97 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA INIT
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:40 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard INIT
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:48 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_INIT -> CS_ROUTING
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:624 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State INIT going to sleep
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_ROUTING (Cur 1 Tot 580)
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_channel.c:2380 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Callstate Change DOWN -> RINGING
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING
2023-06-16 03:49:12.116266 96.10% [DEBUG] mod_sofia.c:158 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA ROUTING
2023-06-16 03:49:12.116266 96.10% [DEBUG] switch_core_state_machine.c:230 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard ROUTING
2023-06-16 03:49:12.116266 96.10% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->91884400 in context default
2023-06-16 03:49:12.116266 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:49:12.136253 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:49:12.136253 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:49:12.136253 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.136253 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:49:12.136253 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 91884400
2023-06-16 03:49:12.136253 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '91884400' limit 1
2023-06-16 03:49:12.136253 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91884400' AND status=0 limit 1
2023-06-16 03:49:12.136253 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '91884400' and status=0 LIMIT 1
2023-06-16 03:49:12.176233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '91884400' limit 1
2023-06-16 03:49:12.176233 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:49:12.176233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 00
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 918844 AND status=0 limit 1
2023-06-16 03:49:12.176233 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.176233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
2023-06-16 03:49:12.176233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:49:12.176233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =91884400
2023-06-16 03:49:12.176233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91884400" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 34
2023-06-16 03:49:12.196257 96.10% [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 = '^91884400.*' OR patterns = '^9188440.*' OR patterns = '^918844.*' OR patterns = '^91884.*' OR patterns = '^9188.*' OR patterns = '^918.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 34 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-06-16 03:49:12.196257 96.10% [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 ="91884400" AND A.accountid = '34' limit 1
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91884400
2023-06-16 03:49:12.196257 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2023-06-16 03:49:12.196257 96.10% [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 = '91884400' OR number = '9188440' OR number = '918844' OR number = '91884' OR number = '9188' OR number = '918' OR number = '91' OR number = '9' OR number ='--') OR (number = '91884400*' OR number = '9188440*' OR number = '918844*' OR number = '91884*' OR number = '9188*' OR number = '918*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '986057' OR number = '98605' OR number = '9860' OR number = '986' OR number = '98' OR number = '9' OR number ='--') OR (number = '986057*' OR number = '98605*' OR number = '9860*' OR number = '986*' OR number = '98*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91884400' OR routing_prefix = '9188440' OR routing_prefix = '918844' OR routing_prefix = '91884' OR routing_prefix = '9188' OR routing_prefix = '918' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 34
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 986057
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3053.9027
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 8
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2023-06-16 03:49:12.196257 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.00000
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:8
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '8' and status=0
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.00000
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 22
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 91884400
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 34
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3053.9027 balance Accountid 34 !!!
2023-06-16 03:49:12.196257 96.10% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2023-06-16 03:49:12.196257 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2023-06-16 03:49:12.196257 96.10% [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 = 34 AND status=0 LIMIT 1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "34" AND deleted = 0 limit 1
2023-06-16 03:49:12.196257 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:34
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:34
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 34
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:49:12.236240 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 2
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
2023-06-16 03:49:12.236240 96.10% [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":"256","no_answer_call_type":"11","priority":"1"}]
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "256" limit 1
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023" 
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
2023-06-16 03:49:12.236240 96.10% [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 = "2" AND accounts.status = 0 
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :91884400
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :91884400
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:49:12.236240 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
2023-06-16 03:49:12.236240 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 2
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="Y Test timecondi" continue="true">
<condition break="never">
<action application="set" data="timezone=Europe/Sarajevo" inline="true"/>
</condition>
<condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
<action application="set" data="office_status=open" inline="true"/>
<action application="set" data="extensions=761767" inline="true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=11" inline="true"/>
</condition>
</extension>
<extension name="tod route, x91884400">
<condition field="destination_number" expression="^(\+?)?(91884400)$">
<action application="execute_extension" data="91884400_${office_status}"/>
</condition>
</extension>
<extension name="office is open">
<condition field="destination_number" expression="^(\+?)?(91884400_open)$">
<action application="set" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="set" data="set_extensions=${extensions}"/>
<action application="set" data="no_answer_flag=true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
<action application="set" data="no_answer_number=${extensions}" />
<action application="transfer" data="34 XML default"/>
</condition>
</extension>
<extension name="91884400">
<condition field="destination_number" expression="91884400">
<action application="set" data="effective_destination_number=91884400"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
<action application="set" data="notify_flag=0"/>
<action application="set" data="notify_credit_limit=5.00000"/>
<action application="set" data="type=0"/>
<action application="set" data="callstart=2023-06-16 03:49:12"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=34"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates_did=ID:22|CODE:^91884400.*|DESTINATION:91884400|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:34"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=986057"/>
<action application="set" data="original_caller_id_number=986057"/>
<action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
<action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
<action application="set" data="effective_caller_id_name=986057"/>
<action application="set" data="effective_caller_id_number=986057"/>
<action application="set" data="receiver_accid=34"/>
<action application="export" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="export" data="sip_to_host=clusterguibeta5.astppbilling.org"/>
<action application="export" data="presence_data=x|||Yash(986057)|||^91884400.* // 91884400 // 0.00000|||||||||DID|||103.240.35.46"/>
<action application="export" data="call_type=11"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->Y Test timecondi] continue=true
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Absolute Condition [Y Test timecondi]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(timezone=Europe/Sarajevo) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(timezone=Europe/Sarajevo)
2023-06-16 03:49:12.236240 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [timezone]=[Europe/Sarajevo]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Date/Time Match (PASS) [Y Test timecondi] break=never
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(office_status=open) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(office_status=open)
2023-06-16 03:49:12.236240 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [office_status]=[open]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(extensions=761767) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(extensions=761767)
2023-06-16 03:49:12.236240 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [extensions]=[761767]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_did_number=91884400) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_did_number=91884400)
2023-06-16 03:49:12.236240 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_did_number]=[91884400]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_call_type=11) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_call_type=11)
2023-06-16 03:49:12.236240 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_call_type]=[11]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->tod route, x91884400] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [tod route, x91884400] destination_number(91884400) =~ /^(\+?)?(91884400)$/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action execute_extension(91884400_${office_status}) 
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_core_state_machine.c:281 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_ROUTING -> CS_EXECUTE
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING going to sleep
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_EXECUTE (Cur 1 Tot 580)
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE
2023-06-16 03:49:12.236240 96.10% [DEBUG] mod_sofia.c:213 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA EXECUTE
2023-06-16 03:49:12.236240 96.10% [DEBUG] switch_core_state_machine.c:323 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard EXECUTE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 execute_extension(91884400_open)
2023-06-16 03:49:12.236240 96.10% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->91884400_open in context default
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 91884400
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '91884400' limit 1
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91884400' AND status=0 limit 1
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '91884400' and status=0 LIMIT 1
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '91884400' limit 1
2023-06-16 03:49:12.256254 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 00
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 918844 AND status=0 limit 1
2023-06-16 03:49:12.256254 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:49:12.256254 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =91884400
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:49:12.256254 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91884400" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 34
2023-06-16 03:49:12.296230 96.10% [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 = '^91884400.*' OR patterns = '^9188440.*' OR patterns = '^918844.*' OR patterns = '^91884.*' OR patterns = '^9188.*' OR patterns = '^918.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 34 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-06-16 03:49:12.296230 96.10% [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 ="91884400" AND A.accountid = '34' limit 1
2023-06-16 03:49:12.296230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91884400
2023-06-16 03:49:12.296230 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.296230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2023-06-16 03:49:12.296230 96.10% [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 = '91884400' OR number = '9188440' OR number = '918844' OR number = '91884' OR number = '9188' OR number = '918' OR number = '91' OR number = '9' OR number ='--') OR (number = '91884400*' OR number = '9188440*' OR number = '918844*' OR number = '91884*' OR number = '9188*' OR number = '918*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '986057' OR number = '98605' OR number = '9860' OR number = '986' OR number = '98' OR number = '9' OR number ='--') OR (number = '986057*' OR number = '98605*' OR number = '9860*' OR number = '986*' OR number = '98*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91884400' OR routing_prefix = '9188440' OR routing_prefix = '918844' OR routing_prefix = '91884' OR routing_prefix = '9188' OR routing_prefix = '918' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-06-16 03:49:12.296230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-06-16 03:49:12.296230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 34
2023-06-16 03:49:12.296230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 986057
2023-06-16 03:49:12.296230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3053.9027
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 8
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2023-06-16 03:49:12.316233 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.00000
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:8
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '8' and status=0
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.00000
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 22
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 91884400
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 34
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3053.9027 balance Accountid 34 !!!
2023-06-16 03:49:12.316233 96.10% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2023-06-16 03:49:12.316233 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2023-06-16 03:49:12.316233 96.10% [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 = 34 AND status=0 LIMIT 1
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "34" AND deleted = 0 limit 1
2023-06-16 03:49:12.316233 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:34
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:34
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 34
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:49:12.336230 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 2
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
2023-06-16 03:49:12.336230 96.10% [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":"256","no_answer_call_type":"11","priority":"1"}]
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "256" limit 1
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023" 
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
2023-06-16 03:49:12.336230 96.10% [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 = "2" AND accounts.status = 0 
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :91884400
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :91884400
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:49:12.336230 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
2023-06-16 03:49:12.336230 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 2
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="Y Test timecondi" continue="true">
<condition break="never">
<action application="set" data="timezone=Europe/Sarajevo" inline="true"/>
</condition>
<condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
<action application="set" data="office_status=open" inline="true"/>
<action application="set" data="extensions=761767" inline="true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=11" inline="true"/>
</condition>
</extension>
<extension name="tod route, x91884400">
<condition field="destination_number" expression="^(\+?)?(91884400)$">
<action application="execute_extension" data="91884400_${office_status}"/>
</condition>
</extension>
<extension name="office is open">
<condition field="destination_number" expression="^(\+?)?(91884400_open)$">
<action application="set" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="set" data="set_extensions=${extensions}"/>
<action application="set" data="no_answer_flag=true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
<action application="set" data="no_answer_number=${extensions}" />
<action application="transfer" data="34 XML default"/>
</condition>
</extension>
<extension name="91884400">
<condition field="destination_number" expression="91884400">
<action application="set" data="effective_destination_number=91884400"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
<action application="set" data="notify_flag=0"/>
<action application="set" data="notify_credit_limit=5.00000"/>
<action application="set" data="type=0"/>
<action application="set" data="callstart=2023-06-16 03:49:12"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=34"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates_did=ID:22|CODE:^91884400.*|DESTINATION:91884400|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:34"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=986057"/>
<action application="set" data="original_caller_id_number=986057"/>
<action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
<action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
<action application="set" data="effective_caller_id_name=986057"/>
<action application="set" data="effective_caller_id_number=986057"/>
<action application="set" data="receiver_accid=34"/>
<action application="export" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="export" data="sip_to_host=clusterguibeta5.astppbilling.org"/>
<action application="export" data="presence_data=x|||Yash(986057)|||^91884400.* // 91884400 // 0.00000|||||||||DID|||103.240.35.46"/>
<action application="export" data="call_type=11"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->Y Test timecondi] continue=true
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Absolute Condition [Y Test timecondi]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(timezone=Europe/Sarajevo) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(timezone=Europe/Sarajevo)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [timezone]=[Europe/Sarajevo]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Date/Time Match (PASS) [Y Test timecondi] break=never
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(office_status=open) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(office_status=open)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [office_status]=[open]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(extensions=761767) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(extensions=761767)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [extensions]=[761767]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_did_number=91884400) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_did_number=91884400)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_did_number]=[91884400]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_call_type=11) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_call_type=11)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_call_type]=[11]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->tod route, x91884400] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (FAIL) [tod route, x91884400] destination_number(91884400_open) =~ /^(\+?)?(91884400)$/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->office is open] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [office is open] destination_number(91884400_open) =~ /^(\+?)?(91884400_open)$/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(domain_name=clusterguibeta5.astppbilling.org) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(set_extensions=${extensions}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_flag=true) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_did_number=91884400) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_did_number=91884400)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_did_number]=[91884400]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_call_type=${no_answer_call_type}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_number=${extensions}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action transfer(34 XML default) 
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(domain_name=clusterguibeta5.astppbilling.org)
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(domain_name=clusterguibeta5.astppbilling.org)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [domain_name]=[clusterguibeta5.astppbilling.org]
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(set_extensions=${extensions})
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(set_extensions=761767)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [set_extensions]=[761767]
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_flag=true)
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_flag=true)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_flag]=[true]
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type})
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_call_type=11)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_call_type]=[11]
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_number=${extensions})
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_number=761767)
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_number]=[761767]
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_core_session.c:3095 Execute [depth=1] transfer(34 XML default)
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 transfer(34 XML default)
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_ivr.c:2289 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_EXECUTE -> CS_ROUTING
2023-06-16 03:49:12.336230 96.10% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/986057@clusterguibeta5.astppbilling.org:5060 to XML[34@default]
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE going to sleep
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_ROUTING (Cur 1 Tot 580)
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
2023-06-16 03:49:12.336230 96.10% [DEBUG] mod_sofia.c:158 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA ROUTING
2023-06-16 03:49:12.336230 96.10% [DEBUG] switch_core_state_machine.c:230 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard ROUTING
2023-06-16 03:49:12.336230 96.10% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->34 in context default
2023-06-16 03:49:12.356250 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.356250 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:49:12.356250 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 34
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '34' limit 1
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '34' AND status=0 limit 1
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '34' and status=0 LIMIT 1
2023-06-16 03:49:12.356250 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '34' limit 1
2023-06-16 03:49:12.356250 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:49:12.356250 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 34 AND status=0 limit 1
2023-06-16 03:49:12.356250 96.10% [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 ="34" LIMIT 1
2023-06-16 03:49:12.356250 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.356250 96.10% [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="34"  AND domains.domain="clusterguibeta5.astppbilling.org" limit 1
2023-06-16 03:49:12.376246 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2023-06-16 03:49:12.376246 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:49:12.376246 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =34
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^34.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 34 limit 1 
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="34" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ no_answer_did_number :91884400
2023-06-16 03:49:12.376246 96.10% [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 ="91884400" LIMIT 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ accountid :34
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "34" AND deleted = 0 limit 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^34.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 34 limit 1 
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :34
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:49:12.376246 96.10% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainclusterguibeta5.astppbilling.org
2023-06-16 03:49:12.376246 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 11
2023-06-16 03:49:12.376246 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Time Conditions
2023-06-16 03:49:12.376246 96.10% [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 = "761767" 
2023-06-16 03:49:12.376246 96.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC5]
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="761767"  AND domains.domain="clusterguibeta5.astppbilling.org" limit 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer_attended' limit 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer' limit 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_park_in' limit 1
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="34">
<condition field="destination_number" expression="34">
<action application="export" data="did_user_domain=clusterguibeta5.astppbilling.org"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="ignore_early_media=true"/>
<action application="set" data="no_answer_flag=false"/>
<action application="set" data="did_calltype=11"/>
<action application="set" data="did_extensions=761767"/>
<action application="set" data="daily_call_credit_limit=0.00000"/>
<action application="set" data="monthly_call_credit_limit=0.00000"/>
<action application="set" data="daily_call_used_limit=0.00000"/>
<action application="set" data="monthly_call_used_limit=0.00000"/>
<action application="set" data="sip_destination_number=761767"/>
<action application="set" data="sip_to_host=clusterguibeta5.astppbilling.org"/>
<action application="hash" data="insert/${domain_name}-call_return/761767/${caller_id_number}"/>
<action application="set" data="user_domain=clusterguibeta5.astppbilling.org"/>
<action application="db" data="insert/pickup_any_group_${callgroup}/761767/${uuid}"/>
<action application="set" data="dialed_extension=transfer_call"/>
<action application="export" data="dialed_extension=transfer_call"/>
<action application="bind_meta_app" data="2 b s execute_extension::transfer_call_2 XML default"/>
<action application="bind_meta_app" data="3 b s execute_extension::transfer_call_3 XML default"/>
<action application="bind_meta_app" data="8 b s execute_extension::transfer_call_8 XML default"/>
<action application="export" data="ring_group_transfer=true"/>
<action application="set" data="userinfo_id=34"/>
<action application="bridge" data="{sip_invite_params=user=LOCAL}sofia/${sofia_profile_name}/761767@clusterguibeta5.astppbilling.org:5060"/>
<action application="lua" data="astpp/lib/pbx/astpp-sipdevice-routing.lua"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->34] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [34] destination_number(34) =~ /34/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(did_user_domain=clusterguibeta5.astppbilling.org) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(continue_on_fail=TRUE) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(ignore_early_media=true) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_flag=false) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(did_calltype=11) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(did_extensions=761767) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(daily_call_credit_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(monthly_call_credit_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(daily_call_used_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(monthly_call_used_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(sip_destination_number=761767) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(sip_to_host=clusterguibeta5.astppbilling.org) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action hash(insert/${domain_name}-call_return/761767/${caller_id_number}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(user_domain=clusterguibeta5.astppbilling.org) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action db(insert/pickup_any_group_${callgroup}/761767/${uuid}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(dialed_extension=transfer_call) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(dialed_extension=transfer_call) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action bind_meta_app(8 b s execute_extension::transfer_call_8 XML default) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(ring_group_transfer=true) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(userinfo_id=34) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action bridge({sip_invite_params=user=LOCAL}sofia/${sofia_profile_name}/761767@clusterguibeta5.astppbilling.org:5060) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua) 
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:281 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_ROUTING -> CS_EXECUTE
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING going to sleep
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_EXECUTE (Cur 1 Tot 580)
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_sofia.c:213 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA EXECUTE
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:323 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard EXECUTE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(did_user_domain=clusterguibeta5.astppbilling.org)
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[clusterguibeta5.astppbilling.org]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(continue_on_fail=TRUE)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(ignore_early_media=true)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [ignore_early_media]=[true]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_flag=false)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_flag]=[false]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(did_calltype=11)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [did_calltype]=[11]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(did_extensions=761767)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [did_extensions]=[761767]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(daily_call_credit_limit=0.00000)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [daily_call_credit_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(monthly_call_credit_limit=0.00000)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [monthly_call_credit_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(daily_call_used_limit=0.00000)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [daily_call_used_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(monthly_call_used_limit=0.00000)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [monthly_call_used_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(sip_destination_number=761767)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [sip_destination_number]=[761767]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(sip_to_host=clusterguibeta5.astppbilling.org)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [sip_to_host]=[clusterguibeta5.astppbilling.org]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 hash(insert/clusterguibeta5.astppbilling.org-call_return/761767/986057)
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(user_domain=clusterguibeta5.astppbilling.org)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [user_domain]=[clusterguibeta5.astppbilling.org]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 db(insert/pickup_any_group_/761767/f2b5318a-799f-4039-86a3-8bcc2119c47a)
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(dialed_extension=transfer_call)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(dialed_extension=transfer_call)
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [dialed_extension]=[transfer_call]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
2023-06-16 03:49:12.376246 96.10% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
2023-06-16 03:49:12.376246 96.10% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 bind_meta_app(8 b s execute_extension::transfer_call_8 XML default)
2023-06-16 03:49:12.376246 96.10% [INFO] switch_ivr_async.c:4774 Bound B-Leg: *8 execute_extension::transfer_call_8 XML default
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(ring_group_transfer=true)
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [ring_group_transfer]=[true]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(userinfo_id=34)
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [userinfo_id]=[34]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 bridge({sip_invite_params=user=LOCAL}sofia/default/761767@clusterguibeta5.astppbilling.org:5060)
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [did_user_domain]=[clusterguibeta5.astppbilling.org] to event
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [ring_group_transfer]=[true] to event
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2023-06-16 03:49:12.376246 96.10% [NOTICE] switch_channel.c:1123 New Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 [e321c00f-80e8-42c0-be5c-4ede6099b6d2]
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_sofia.c:5121 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State Change CS_NEW -> CS_INIT
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_INIT (Cur 2 Tot 581)
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:624 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State INIT
2023-06-16 03:49:12.376246 96.10% [DEBUG] mod_sofia.c:97 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 SOFIA INIT
2023-06-16 03:49:12.376246 96.10% [INFO] sofia_glue.c:1651 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 sending invite call-id: (null)
2023-06-16 03:49:12.376246 96.10% [DEBUG] sofia_glue.c:1654 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 sending invite version: 1.10.7 -release 64bit
Local SDP:
v=0
o=FreeSWITCH 1686857694 1686857695 IN IP4 167.235.194.5
s=FreeSWITCH
c=IN IP4 167.235.194.5
t=0 0
m=audio 29658 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv

2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:40 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Standard INIT
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:48 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State Change CS_INIT -> CS_ROUTING
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:624 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State INIT going to sleep
2023-06-16 03:49:12.376246 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_ROUTING (Cur 2 Tot 581)
2023-06-16 03:49:12.416379 96.10% [DEBUG] sofia.c:7499 Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 entering state [calling][0]
2023-06-16 03:49:12.416379 96.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State ROUTING
2023-06-16 03:49:12.416379 96.10% [DEBUG] mod_sofia.c:158 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 SOFIA ROUTING
2023-06-16 03:49:12.416379 96.10% [DEBUG] switch_ivr_originate.c:67 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2023-06-16 03:49:12.416379 96.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State ROUTING going to sleep
2023-06-16 03:49:12.416379 96.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 581)
2023-06-16 03:49:12.416379 96.10% [DEBUG] switch_core_state_machine.c:659 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State CONSUME_MEDIA
2023-06-16 03:49:12.416379 96.10% [DEBUG] switch_core_state_machine.c:659 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State CONSUME_MEDIA going to sleep
2023-06-16 03:49:15.676271 95.23% [DEBUG] sofia.c:7499 Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 entering state [proceeding][180]
2023-06-16 03:49:15.676271 95.23% [NOTICE] sofia.c:7610 Ring-Ready sofia/default/761767@clusterguibeta5.astppbilling.org:5060!
2023-06-16 03:49:15.676271 95.23% [DEBUG] switch_channel.c:3494 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Callstate Change DOWN -> RINGING
2023-06-16 03:49:15.696249 95.23% [NOTICE] mod_sofia.c:2515 Ring-Ready sofia/default/986057@clusterguibeta5.astppbilling.org:5060!
2023-06-16 03:49:15.696249 95.23% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [early][180]
2023-06-16 03:49:15.696249 95.23% [NOTICE] switch_ivr_originate.c:565 Ring Ready sofia/default/986057@clusterguibeta5.astppbilling.org:5060!
2023-06-16 03:49:26.256271 94.73% [DEBUG] sofia.c:7499 Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 entering state [completing][200]
2023-06-16 03:49:26.256271 94.73% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Zoiper 0 1093917800 IN IP4 185.117.83.208
s=Zoiper
c=IN IP4 185.117.83.208
t=0 0
m=audio 49601 RTP/AVP 8 106 9 0 3 101 98
a=rtpmap:106 opus/48000/2
a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=rtpmap:98 telephone-event/48000
a=fmtp:98 0-16
a=rtcp-mux
a=ptime:20
a=direction:both
a=oldoip:10.156.235.240
a=oldcip:10.156.235.240

2023-06-16 03:49:26.256271 94.73% [DEBUG] sofia.c:7499 Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 entering state [ready][200]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/761767@clusterguibeta5.astppbilling.org:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_codec.c:111 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Original read codec set to PCMA:8
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:5973 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf send payload to 101 recv payload to 101
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/761767@clusterguibeta5.astppbilling.org:5060] 167.235.194.5 port 29658 -> 185.117.83.208 port 49601 codec: 8 ms: 20
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:8997 Activating RTCP PORT 49601
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_rtp.c:5017 RTCP send rate is: 1000 and packet rate is: 20000 Remote Port: 49601
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:9089 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf send payload to 101
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:9096 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf receive payload to 101
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:9119 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Set rtp dtmf delay to 40
2023-06-16 03:49:26.256271 94.73% [NOTICE] sofia.c:8683 Channel [sofia/default/761767@clusterguibeta5.astppbilling.org:5060] has been answered
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_channel.c:3950 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Callstate Change RINGING -> ACTIVE
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/986057@clusterguibeta5.astppbilling.org:5060] 167.235.194.5 port 28958 -> 103.240.35.46 port 8000 codec: 8 ms: 20
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:9089 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf send payload to 101
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:9096 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf receive payload to 101
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_media.c:9119 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set rtp dtmf delay to 40
2023-06-16 03:49:26.256271 94.73% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/986057@clusterguibeta5.astppbilling.org:5060:
v=0
o=FreeSWITCH 1686858408 1686858409 IN IP4 167.235.194.5
s=FreeSWITCH
c=IN IP4 167.235.194.5
t=0 0
m=audio 28958 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv

2023-06-16 03:49:26.256271 94.73% [NOTICE] switch_ivr_originate.c:3834 Channel [sofia/default/986057@clusterguibeta5.astppbilling.org:5060] has been answered
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_channel.c:3950 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Callstate Change RINGING -> ACTIVE
2023-06-16 03:49:26.256271 94.73% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [completed][200]
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_ivr_originate.c:3892 Originate Resulted in Success: [sofia/default/761767@clusterguibeta5.astppbilling.org:5060] Peer UUID: e321c00f-80e8-42c0-be5c-4ede6099b6d2
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_ivr_bridge.c:1793 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_EXCHANGE_MEDIA (Cur 2 Tot 581)
2023-06-16 03:49:26.256271 94.73% [DEBUG] switch_core_state_machine.c:650 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State EXCHANGE_MEDIA
2023-06-16 03:49:26.256271 94.73% [DEBUG] mod_sofia.c:671 SOFIA EXCHANGE_MEDIA
2023-06-16 03:49:26.556301 94.73% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [ready][200]
2023-06-16 03:49:26.576263 94.73% [DEBUG] switch_rtp.c:1982 rtcp_stats_init: audio ssrc[2013087102] base_seq[38010]
2023-06-16 03:49:26.576263 94.73% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
2023-06-16 03:49:26.836320 94.70% [INFO] switch_rtp.c:7894 Auto Changing audio port from 185.117.83.208:49601 to 117.228.26.98:30503
2023-06-16 03:50:03.936243 94.87% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [1303@clusterfs.astppbilling.org] from ip 45.61.185.51
2023-06-16 03:50:04.096274 94.87% [WARNING] sofia_reg.c:3223 Can't find user [1303@clusterfs.astppbilling.org] from 45.61.185.51
You must define a domain called 'clusterfs.astppbilling.org' in your directory and add a user with the id="1303" attribute
and you must configure your device to use the proper domain in its authentication credentials.
2023-06-16 03:50:04.096274 94.87% [WARNING] sofia_reg.c:1806 SIP auth failure (REGISTER) on sofia profile 'default' for [1303@clusterfs.astppbilling.org] from ip 45.61.185.51
2023-06-16 03:50:06.396243 91.90% [NOTICE] sofia.c:1065 Hangup sofia/default/761767@clusterguibeta5.astppbilling.org:5060 [CS_EXCHANGE_MEDIA] [NORMAL_CLEARING]
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_ivr_bridge.c:912 BRIDGE THREAD DONE [sofia/default/761767@clusterguibeta5.astppbilling.org:5060]
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:650 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State EXCHANGE_MEDIA going to sleep
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_HANGUP (Cur 2 Tot 581)
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:844 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Callstate Change ACTIVE -> HANGUP
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State HANGUP
2023-06-16 03:50:06.396243 91.90% [DEBUG] mod_sofia.c:468 Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 hanging up, cause: NORMAL_CLEARING
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:59 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Standard HANGUP, cause: NORMAL_CLEARING
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State HANGUP going to sleep
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:616 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State Change CS_HANGUP -> CS_REPORTING
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_REPORTING (Cur 2 Tot 581)
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State REPORTING
2023-06-16 03:50:06.396243 91.90% [INFO] mod_json_cdr.c:271 Process [e321c00f-80e8-42c0-be5c-4ede6099b6d2.cdr.json]
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_ivr_bridge.c:820 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 ending bridge by request from write function
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_ivr_bridge.c:912 BRIDGE THREAD DONE [sofia/default/986057@clusterguibeta5.astppbilling.org:5060]
2023-06-16 03:50:06.396243 91.90% [DEBUG] switch_ivr_bridge.c:1892 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 skip receive message [UNBRIDGE] (channel is hungup already)
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:50:06.436244 91.90% [NOTICE] switch_cpp.cpp:1465 [Astpp_SIP-Devices] This Is Last Dispositions SUCCESS This Is SIP Number : 761767
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_cpp.cpp:1209 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 destroy/unlink session from object
2023-06-16 03:50:06.436244 91.90% [NOTICE] switch_core_state_machine.c:382 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 has executed the last dialplan instruction, hanging up.
2023-06-16 03:50:06.436244 91.90% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [CS_EXECUTE] [NORMAL_CLEARING]
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE going to sleep
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_HANGUP (Cur 2 Tot 581)
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:844 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Callstate Change ACTIVE -> HANGUP
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State HANGUP
2023-06-16 03:50:06.436244 91.90% [DEBUG] mod_sofia.c:462 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Overriding SIP cause 480 with 200 from the other leg
2023-06-16 03:50:06.436244 91.90% [DEBUG] mod_sofia.c:468 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 hanging up, cause: NORMAL_CLEARING
2023-06-16 03:50:06.436244 91.90% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/986057@clusterguibeta5.astppbilling.org:5060
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:59 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard HANGUP, cause: NORMAL_CLEARING
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:846 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State HANGUP going to sleep
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:616 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_HANGUP -> CS_REPORTING
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_REPORTING (Cur 2 Tot 581)
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State REPORTING
2023-06-16 03:50:06.436244 91.90% [INFO] mod_json_cdr.c:271 Process [f2b5318a-799f-4039-86a3-8bcc2119c47a.cdr.json]
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:168 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Standard REPORTING, cause: NORMAL_CLEARING
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State REPORTING going to sleep
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:607 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State Change CS_REPORTING -> CS_DESTROY
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_session.c:1753 Session 581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Locked, Waiting on external entities
2023-06-16 03:50:06.436244 91.90% [NOTICE] switch_core_session.c:1771 Session 581 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Ended
2023-06-16 03:50:06.436244 91.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/761767@clusterguibeta5.astppbilling.org:5060 [CS_DESTROY]
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:735 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) Running State Change CS_DESTROY (Cur 1 Tot 581)
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State DESTROY
2023-06-16 03:50:06.436244 91.90% [DEBUG] mod_sofia.c:379 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 SOFIA DESTROY
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:175 sofia/default/761767@clusterguibeta5.astppbilling.org:5060 Standard DESTROY
2023-06-16 03:50:06.436244 91.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/761767@clusterguibeta5.astppbilling.org:5060) State DESTROY going to sleep
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:168 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard REPORTING, cause: NORMAL_CLEARING
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:932 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State REPORTING going to sleep
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:607 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_REPORTING -> CS_DESTROY
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_session.c:1753 Session 580 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Locked, Waiting on external entities
2023-06-16 03:50:06.476234 91.90% [NOTICE] switch_core_session.c:1771 Session 580 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Ended
2023-06-16 03:50:06.476234 91.90% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [CS_DESTROY]
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:735 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_DESTROY (Cur 0 Tot 581)
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State DESTROY
2023-06-16 03:50:06.476234 91.90% [DEBUG] mod_sofia.c:379 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA DESTROY
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:175 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard DESTROY
2023-06-16 03:50:06.476234 91.90% [DEBUG] switch_core_state_machine.c:745 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State DESTROY going to sleep
2023-06-16 03:51:07.696264 90.80% [NOTICE] switch_channel.c:1123 New Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [c20a7ad8-9f1a-489d-9970-d287594f9e1f]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_NEW (Cur 1 Tot 582)
2023-06-16 03:51:07.696264 90.80% [INFO] sofia.c:10462 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 receiving invite from 78.47.101.152:5060 version: 1.10.7 -release 64bit call-id: NTMyMjM3MTAyMzQ2MGQzYjg4NGU3MDRiMWQ0N2NhNWY.
2023-06-16 03:51:07.696264 90.80% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 78.47.101.152:0.
2023-06-16 03:51:07.696264 90.80% [DEBUG] sofia.c:10585 IP 78.47.101.152 Approved by acl "default[]". Access Granted.
2023-06-16 03:51:07.696264 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [received][100]
2023-06-16 03:51:07.696264 90.80% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=Z 0 0 IN IP4 103.240.35.46
s=Z
c=IN IP4 103.240.35.46
t=0 0
m=audio 8000 RTP/AVP 3 110 8 0 98 101
a=rtpmap:110 speex/8000
a=rtpmap:98 iLBC/8000
a=fmtp:98 mode=20
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15

2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/986057@clusterguibeta5.astppbilling.org:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_codec.c:111 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Original read codec set to PCMA:8
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_media.c:5973 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf send payload to 101 recv payload to 101
2023-06-16 03:51:07.696264 90.80% [DEBUG] sofia.c:7933 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_NEW -> CS_INIT
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:600 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State NEW
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_INIT (Cur 1 Tot 582)
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State INIT
2023-06-16 03:51:07.696264 90.80% [DEBUG] mod_sofia.c:97 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA INIT
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:40 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard INIT
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:48 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_INIT -> CS_ROUTING
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State INIT going to sleep
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_ROUTING (Cur 1 Tot 582)
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_channel.c:2380 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Callstate Change DOWN -> RINGING
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING
2023-06-16 03:51:07.696264 90.80% [DEBUG] mod_sofia.c:158 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA ROUTING
2023-06-16 03:51:07.696264 90.80% [DEBUG] switch_core_state_machine.c:230 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard ROUTING
2023-06-16 03:51:07.696264 90.80% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->91884400 in context default
2023-06-16 03:51:07.716251 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:51:07.716251 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:51:07.716251 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:51:07.716251 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.716251 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:51:07.716251 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 91884400
2023-06-16 03:51:07.716251 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '91884400' limit 1
2023-06-16 03:51:07.716251 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91884400' AND status=0 limit 1
2023-06-16 03:51:07.716251 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '91884400' and status=0 LIMIT 1
2023-06-16 03:51:07.756232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '91884400' limit 1
2023-06-16 03:51:07.756232 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:51:07.756232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 00
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 918844 AND status=0 limit 1
2023-06-16 03:51:07.756232 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.756232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
2023-06-16 03:51:07.756232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:51:07.756232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =91884400
2023-06-16 03:51:07.756232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91884400" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 34
2023-06-16 03:51:07.776249 90.80% [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 = '^91884400.*' OR patterns = '^9188440.*' OR patterns = '^918844.*' OR patterns = '^91884.*' OR patterns = '^9188.*' OR patterns = '^918.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 34 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-06-16 03:51:07.776249 90.80% [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 ="91884400" AND A.accountid = '34' limit 1
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91884400
2023-06-16 03:51:07.776249 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2023-06-16 03:51:07.776249 90.80% [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 = '91884400' OR number = '9188440' OR number = '918844' OR number = '91884' OR number = '9188' OR number = '918' OR number = '91' OR number = '9' OR number ='--') OR (number = '91884400*' OR number = '9188440*' OR number = '918844*' OR number = '91884*' OR number = '9188*' OR number = '918*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '986057' OR number = '98605' OR number = '9860' OR number = '986' OR number = '98' OR number = '9' OR number ='--') OR (number = '986057*' OR number = '98605*' OR number = '9860*' OR number = '986*' OR number = '98*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91884400' OR routing_prefix = '9188440' OR routing_prefix = '918844' OR routing_prefix = '91884' OR routing_prefix = '9188' OR routing_prefix = '918' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 34
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 986057
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3053.9027
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 8
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2023-06-16 03:51:07.776249 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.00000
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:8
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '8' and status=0
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.00000
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 22
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 91884400
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 34
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-06-16 03:51:07.776249 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3053.9027 balance Accountid 34 !!!
2023-06-16 03:51:07.776249 90.80% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2023-06-16 03:51:07.776249 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2023-06-16 03:51:07.776249 90.80% [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 = 34 AND status=0 LIMIT 1
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "34" AND deleted = 0 limit 1
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:34
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:34
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 34
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:51:07.816236 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 2
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
2023-06-16 03:51:07.816236 90.80% [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":"918822001#","no_answer_call_type":"12","priority":"1"}]
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023" 
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-06-16 03:51:07.816236 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
2023-06-16 03:51:07.816236 90.80% [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 = "2" AND accounts.status = 0 
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :91884400
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :91884400
2023-06-16 03:51:07.816236 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:51:07.836232 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
2023-06-16 03:51:07.836232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 2
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="Y Test timecondi" continue="true">
<condition break="never">
<action application="set" data="timezone=Europe/Sarajevo" inline="true"/>
</condition>
<condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
<action application="set" data="office_status=open" inline="true"/>
<action application="set" data="extensions=918822001#" inline="true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=12" inline="true"/>
</condition>
</extension>
<extension name="tod route, x91884400">
<condition field="destination_number" expression="^(\+?)?(91884400)$">
<action application="execute_extension" data="91884400_${office_status}"/>
</condition>
</extension>
<extension name="office is open">
<condition field="destination_number" expression="^(\+?)?(91884400_open)$">
<action application="set" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="set" data="set_extensions=${extensions}"/>
<action application="set" data="no_answer_flag=true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
<action application="set" data="no_answer_number=${extensions}" />
<action application="transfer" data="34 XML default"/>
</condition>
</extension>
<extension name="91884400">
<condition field="destination_number" expression="91884400">
<action application="set" data="effective_destination_number=91884400"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
<action application="set" data="notify_flag=0"/>
<action application="set" data="notify_credit_limit=5.00000"/>
<action application="set" data="type=0"/>
<action application="set" data="callstart=2023-06-16 03:51:07"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=34"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates_did=ID:22|CODE:^91884400.*|DESTINATION:91884400|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:34"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=986057"/>
<action application="set" data="original_caller_id_number=986057"/>
<action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
<action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
<action application="set" data="effective_caller_id_name=986057"/>
<action application="set" data="effective_caller_id_number=986057"/>
<action application="set" data="receiver_accid=34"/>
<action application="export" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="export" data="sip_to_host=clusterguibeta5.astppbilling.org"/>
<action application="export" data="presence_data=x|||Yash(986057)|||^91884400.* // 91884400 // 0.00000|||||||||DID|||103.240.35.46"/>
<action application="export" data="call_type=11"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->Y Test timecondi] continue=true
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Absolute Condition [Y Test timecondi]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(timezone=Europe/Sarajevo) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(timezone=Europe/Sarajevo)
2023-06-16 03:51:07.836232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [timezone]=[Europe/Sarajevo]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Date/Time Match (PASS) [Y Test timecondi] break=never
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(office_status=open) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(office_status=open)
2023-06-16 03:51:07.836232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [office_status]=[open]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(extensions=918822001#) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(extensions=918822001#)
2023-06-16 03:51:07.836232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [extensions]=[918822001#]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_did_number=91884400) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_did_number=91884400)
2023-06-16 03:51:07.836232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_did_number]=[91884400]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_call_type=12) INLINE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_call_type=12)
2023-06-16 03:51:07.836232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_call_type]=[12]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->tod route, x91884400] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [tod route, x91884400] destination_number(91884400) =~ /^(\+?)?(91884400)$/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action execute_extension(91884400_${office_status}) 
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_core_state_machine.c:281 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_ROUTING -> CS_EXECUTE
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING going to sleep
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_EXECUTE (Cur 1 Tot 582)
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE
2023-06-16 03:51:07.836232 90.80% [DEBUG] mod_sofia.c:213 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA EXECUTE
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_core_state_machine.c:323 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard EXECUTE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 execute_extension(91884400_open)
2023-06-16 03:51:07.836232 90.80% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->91884400_open in context default
2023-06-16 03:51:07.836232 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:51:07.836232 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 91884400
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '91884400' limit 1
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '91884400' AND status=0 limit 1
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '91884400' and status=0 LIMIT 1
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '91884400' limit 1
2023-06-16 03:51:07.856241 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 00
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 918844 AND status=0 limit 1
2023-06-16 03:51:07.856241 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:51:07.856241 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =91884400
2023-06-16 03:51:07.856241 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="91884400" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 34
2023-06-16 03:51:07.876240 90.80% [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 = '^91884400.*' OR patterns = '^9188440.*' OR patterns = '^918844.*' OR patterns = '^91884.*' OR patterns = '^9188.*' OR patterns = '^918.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 34 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-06-16 03:51:07.876240 90.80% [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 ="91884400" AND A.accountid = '34' limit 1
2023-06-16 03:51:07.876240 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 91884400
2023-06-16 03:51:07.876240 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.876240 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
2023-06-16 03:51:07.876240 90.80% [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 = '91884400' OR number = '9188440' OR number = '918844' OR number = '91884' OR number = '9188' OR number = '918' OR number = '91' OR number = '9' OR number ='--') OR (number = '91884400*' OR number = '9188440*' OR number = '918844*' OR number = '91884*' OR number = '9188*' OR number = '918*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '986057' OR number = '98605' OR number = '9860' OR number = '986' OR number = '98' OR number = '9' OR number ='--') OR (number = '986057*' OR number = '98605*' OR number = '9860*' OR number = '986*' OR number = '98*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-06-16 03:51:07.876240 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '91884400' OR routing_prefix = '9188440' OR routing_prefix = '918844' OR routing_prefix = '91884' OR routing_prefix = '9188' OR routing_prefix = '918' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 34
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 986057
2023-06-16 03:51:07.896233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3053.9027
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 8
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-06-16 03:51:07.896233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:51:07.896233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
2023-06-16 03:51:07.896233 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.896233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.896233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.00000
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:8
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '8' and status=0
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.00000
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 22
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 91884400
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 34
2023-06-16 03:51:07.896233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-06-16 03:51:07.896233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3053.9027 balance Accountid 34 !!!
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
2023-06-16 03:51:07.916244 90.80% [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 = 34 AND status=0 LIMIT 1
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "34" AND deleted = 0 limit 1
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =34
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:34
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:34
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 34
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:51:07.916244 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 2
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
2023-06-16 03:51:07.916244 90.80% [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":"918822001#","no_answer_call_type":"12","priority":"1"}]
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023" 
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
2023-06-16 03:51:07.916244 90.80% [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 = "2" AND accounts.status = 0 
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :91884400
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :91884400
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:51:07.916244 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta5.astppbilling.org
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 2
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="Y Test timecondi" continue="true">
<condition break="never">
<action application="set" data="timezone=Europe/Sarajevo" inline="true"/>
</condition>
<condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
<action application="set" data="office_status=open" inline="true"/>
<action application="set" data="extensions=918822001#" inline="true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=12" inline="true"/>
</condition>
</extension>
<extension name="tod route, x91884400">
<condition field="destination_number" expression="^(\+?)?(91884400)$">
<action application="execute_extension" data="91884400_${office_status}"/>
</condition>
</extension>
<extension name="office is open">
<condition field="destination_number" expression="^(\+?)?(91884400_open)$">
<action application="set" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="set" data="set_extensions=${extensions}"/>
<action application="set" data="no_answer_flag=true"/>
<action application="set" data="no_answer_did_number=91884400" inline="true"/>
<action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
<action application="set" data="no_answer_number=${extensions}" />
<action application="transfer" data="34 XML default"/>
</condition>
</extension>
<extension name="91884400">
<condition field="destination_number" expression="91884400">
<action application="set" data="effective_destination_number=91884400"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
<action application="set" data="notify_flag=0"/>
<action application="set" data="notify_credit_limit=5.00000"/>
<action application="set" data="type=0"/>
<action application="set" data="callstart=2023-06-16 03:51:07"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=34"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=inbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates_did=ID:22|CODE:^91884400.*|DESTINATION:91884400|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:34"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=986057"/>
<action application="set" data="original_caller_id_number=986057"/>
<action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
<action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
<action application="set" data="effective_caller_id_name=986057"/>
<action application="set" data="effective_caller_id_number=986057"/>
<action application="set" data="receiver_accid=34"/>
<action application="export" data="domain_name=clusterguibeta5.astppbilling.org"/>
<action application="export" data="sip_to_host=clusterguibeta5.astppbilling.org"/>
<action application="export" data="presence_data=x|||Yash(986057)|||^91884400.* // 91884400 // 0.00000|||||||||DID|||103.240.35.46"/>
<action application="export" data="call_type=11"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->Y Test timecondi] continue=true
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Absolute Condition [Y Test timecondi]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(timezone=Europe/Sarajevo) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(timezone=Europe/Sarajevo)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [timezone]=[Europe/Sarajevo]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Date/Time Match (PASS) [Y Test timecondi] break=never
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(office_status=open) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(office_status=open)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [office_status]=[open]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(extensions=918822001#) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(extensions=918822001#)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [extensions]=[918822001#]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_did_number=91884400) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_did_number=91884400)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_did_number]=[91884400]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_call_type=12) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_call_type=12)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_call_type]=[12]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->tod route, x91884400] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (FAIL) [tod route, x91884400] destination_number(91884400_open) =~ /^(\+?)?(91884400)$/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->office is open] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [office is open] destination_number(91884400_open) =~ /^(\+?)?(91884400_open)$/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(domain_name=clusterguibeta5.astppbilling.org) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(set_extensions=${extensions}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_flag=true) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_did_number=91884400) INLINE
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_did_number=91884400)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_did_number]=[91884400]
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_call_type=${no_answer_call_type}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_number=${extensions}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action transfer(34 XML default) 
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(domain_name=clusterguibeta5.astppbilling.org)
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(domain_name=clusterguibeta5.astppbilling.org)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [domain_name]=[clusterguibeta5.astppbilling.org]
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(set_extensions=${extensions})
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(set_extensions=918822001#)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [set_extensions]=[918822001#]
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_flag=true)
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_flag=true)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_flag]=[true]
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type})
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_call_type=12)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_call_type]=[12]
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_number=${extensions})
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_number=918822001#)
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_number]=[918822001#]
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_core_session.c:3095 Execute [depth=1] transfer(34 XML default)
EXECUTE [depth=1] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 transfer(34 XML default)
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_ivr.c:2289 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_EXECUTE -> CS_ROUTING
2023-06-16 03:51:07.916244 90.80% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/986057@clusterguibeta5.astppbilling.org:5060 to XML[34@default]
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE going to sleep
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_ROUTING (Cur 1 Tot 582)
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
2023-06-16 03:51:07.916244 90.80% [DEBUG] mod_sofia.c:158 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA ROUTING
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_core_state_machine.c:230 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard ROUTING
2023-06-16 03:51:07.916244 90.80% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->34 in context default
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:51:07.916244 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 34
2023-06-16 03:51:07.916244 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '34' limit 1
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '34' AND status=0 limit 1
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '34' and status=0 LIMIT 1
2023-06-16 03:51:07.956233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '34' limit 1
2023-06-16 03:51:07.956233 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:51:07.956233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 34 AND status=0 limit 1
2023-06-16 03:51:07.956233 90.80% [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 ="34" LIMIT 1
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.956233 90.80% [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="34"  AND domains.domain="clusterguibeta5.astppbilling.org" limit 1
2023-06-16 03:51:07.956233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2023-06-16 03:51:07.956233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:51:07.956233 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =34
2023-06-16 03:51:07.956233 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^34.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 34 limit 1 
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="34" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ no_answer_did_number :91884400
2023-06-16 03:51:07.976380 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ accountid :34
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "34" AND deleted = 0 limit 1
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^34.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 34 limit 1 
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :34
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 34 limit 1
2023-06-16 03:51:07.976380 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainclusterguibeta5.astppbilling.org
2023-06-16 03:51:07.976380 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 12
2023-06-16 03:51:07.976380 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] Time-Codtion Pstn Call
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 34  and status = 0 limit 1
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="34">
<condition field="destination_number" expression="34">
<action application="export" data="did_user_domain=clusterguibeta5.astppbilling.org"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="ignore_early_media=true"/>
<action application="set" data="no_answer_flag=false"/>
<action application="set" data="did_calltype=12"/>
<action application="set" data="did_extensions=918822001#"/>
<action application="set" data="daily_call_credit_limit=0.00000"/>
<action application="set" data="monthly_call_credit_limit=0.00000"/>
<action application="set" data="daily_call_used_limit=0.00000"/>
<action application="set" data="monthly_call_used_limit=0.00000"/>
<action application="set" data="accountcode=986057"/>
<action application="transfer" data="918822001 XML default"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->34] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [34] destination_number(34) =~ /34/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(did_user_domain=clusterguibeta5.astppbilling.org) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(continue_on_fail=TRUE) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(ignore_early_media=true) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(no_answer_flag=false) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(did_calltype=12) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(did_extensions=918822001#) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(daily_call_credit_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(monthly_call_credit_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(daily_call_used_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(monthly_call_used_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(accountcode=986057) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action transfer(918822001 XML default) 
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:281 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_ROUTING -> CS_EXECUTE
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING going to sleep
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_EXECUTE (Cur 1 Tot 582)
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_sofia.c:213 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA EXECUTE
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:323 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard EXECUTE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(did_user_domain=clusterguibeta5.astppbilling.org)
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[clusterguibeta5.astppbilling.org]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(continue_on_fail=TRUE)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(ignore_early_media=true)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [ignore_early_media]=[true]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(no_answer_flag=false)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [no_answer_flag]=[false]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(did_calltype=12)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [did_calltype]=[12]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(did_extensions=918822001#)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [did_extensions]=[918822001#]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(daily_call_credit_limit=0.00000)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [daily_call_credit_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(monthly_call_credit_limit=0.00000)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [monthly_call_credit_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(daily_call_used_limit=0.00000)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [daily_call_used_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(monthly_call_used_limit=0.00000)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [monthly_call_used_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(accountcode=986057)
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [accountcode]=[986057]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 transfer(918822001 XML default)
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_ivr.c:2289 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_EXECUTE -> CS_ROUTING
2023-06-16 03:51:07.976380 90.80% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/986057@clusterguibeta5.astppbilling.org:5060 to XML[918822001@default]
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE going to sleep
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_ROUTING (Cur 1 Tot 582)
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
2023-06-16 03:51:07.976380 90.80% [DEBUG] mod_sofia.c:158 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA ROUTING
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_core_state_machine.c:230 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard ROUTING
2023-06-16 03:51:07.976380 90.80% [INFO] mod_dialplan_xml.c:639 Processing 986057 <986057>->918822001 in context default
2023-06-16 03:51:07.976380 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
2023-06-16 03:51:07.976380 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 918822001
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '918822001' limit 1
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '918822001' AND status=0 limit 1
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '918822001' and status=0 LIMIT 1
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER986057
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'clusterguibeta5.astppbilling.org' limit 1
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '34' and username = '918822001' limit 1
2023-06-16 03:51:08.016239 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID 
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 986057 / 986057
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 001
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 918822 AND status=0 limit 1
2023-06-16 03:51:08.016239 90.80% [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 ="918822001" LIMIT 1
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:08.016239 90.80% [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="918822001"  AND domains.domain="clusterguibeta5.astppbilling.org" limit 1
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 103.240.35.46
2023-06-16 03:51:08.016239 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 986057]
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =918822001
2023-06-16 03:51:08.016239 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "986057" AND deleted = 0 limit 1
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^918822001.*' OR blocked_patterns = '^91882200.*' OR blocked_patterns = '^9188220.*' OR blocked_patterns = '^918822.*' OR blocked_patterns = '^91882.*' OR blocked_patterns = '^9188.*' OR blocked_patterns = '^918.*' OR blocked_patterns = '^91.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND accountid = 34 limit 1 
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="918822001" AND (accountid = 0 OR status = 1) LIMIT 1
2023-06-16 03:51:08.036243 90.80% [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 = '^918822001.*' OR patterns = '^91882200.*' OR patterns = '^9188220.*' OR patterns = '^918822.*' OR patterns = '^91882.*' OR patterns = '^9188.*' OR patterns = '^918.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 34 ORDER BY LENGTH(PKGPTR.patterns) DESC
2023-06-16 03:51:08.036243 90.80% [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 ="918822001" AND A.accountid = '34' limit 1
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 918822001
2023-06-16 03:51:08.036243 90.80% [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 ="918822001" LIMIT 1
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:08.036243 90.80% [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="918822001"  AND domains.domain="clusterguibeta5.astppbilling.org" limit 1
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
2023-06-16 03:51:08.036243 90.80% [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 = '918822001' OR number = '91882200' OR number = '9188220' OR number = '918822' OR number = '91882' OR number = '9188' OR number = '918' OR number = '91' OR number = '9' OR number ='--') OR (number = '918822001*' OR number = '91882200*' OR number = '9188220*' OR number = '918822*' OR number = '91882*' OR number = '9188*' OR number = '918*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '986057' OR number = '98605' OR number = '9860' OR number = '986' OR number = '98' OR number = '9' OR number ='--') OR (number = '986057*' OR number = '98605*' OR number = '9860*' OR number = '986*' OR number = '98*' OR number = '9*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '918822001' OR routing_prefix = '91882200' OR routing_prefix = '9188220' OR routing_prefix = '918822' OR routing_prefix = '91882' OR routing_prefix = '9188' OR routing_prefix = '918' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 34
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 986057
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3053.9027
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 8
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^918822001.*' OR pattern = '^91882200.*' OR pattern = '^9188220.*' OR pattern = '^918822.*' OR pattern = '^91882.*' OR pattern = '^9188.*' OR pattern = '^918.*' OR pattern = '^91.*' OR pattern = '^9.*' OR pattern ='--') AND (caller_id_pattern = '^986057.*' OR caller_id_pattern = '^98605.*' OR caller_id_pattern = '^9860.*' OR caller_id_pattern = '^986.*' OR caller_id_pattern = '^98.*' OR caller_id_pattern = '^9.*' OR caller_id_pattern ='^.*') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 8 OR accountid=34)  ORDER BY accountid DESC,LENGTH(pattern) DESC,LENGTH(caller_id_pattern) DESC,cost DESC,effective_date DESC LIMIT 1
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : outbound
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:2.40000
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:8
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '8' and status=0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:2.40000
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 3157584
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.10000
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 2.40000
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : India
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 34
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID: 0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type: 
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Shadow_billing_rates]SHADOWBILLING:|ID:3157584|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|CT:|COST:2.40000|INC:60|INITIALBLOCK:60|RATEGROUP:8|MARKUP:0|CI:0|ACCID:34!!!
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3053.9027 balance Accountid 34 !!!
2023-06-16 03:51:08.036243 90.80% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [DIALPLAN] User Rate ID : 3157584
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id	:0
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=8 ORDER by id asc
2023-06-16 03:51:08.036243 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^918822001.*' OR pattern = '^91882200.*' OR pattern = '^9188220.*' OR pattern = '^918822.*' OR pattern = '^91882.*' OR pattern = '^9188.*' OR pattern = '^918.*' OR pattern = '^91.*' OR pattern = '^9.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (4) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information ===================
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 7
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^91.*
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination : India
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.10000
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^91.*
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip : 
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend : 
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 4
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : YGateway
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable : 
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway : 
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 3
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0
2023-06-16 03:51:08.036243 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES=======================
2023-06-16 03:51:08.036243 90.80% [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 = 34 AND status=0 LIMIT 1
2023-06-16 03:51:08.076231 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:08.076231 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
2023-06-16 03:51:08.076231 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : outbound
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :918822001
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :918822001
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 8 AND status = 0
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from accounts where id = 3) AND status=0 limit 1 
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from trunks where id = 4) AND status=0 limit 1 
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="986057"  AND domains.domain="clusterguibeta5.astppbilling.org" limit 1
2023-06-16 03:51:08.076231 90.80% [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 ="91884400" LIMIT 1
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="34" and did_id ="22" and number ="986057" and status = '0' LIMIT 1
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document type="freeswitch/xml">
<section name="dialplan" description="ASTPP Dialplan">
<context name="default">
<extension name="918822001">
<condition field="destination_number" expression="918822001">
<action application="set" data="effective_destination_number=918822001"/>
<action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
<action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
<action application="set" data="notify_flag=0"/>
<action application="set" data="notify_credit_limit=5.00000"/>
<action application="set" data="type=0"/>
<action application="set" data="callstart=2023-06-16 03:51:08"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=34"/>
<action application="set" data="parent_id=0"/>
<action application="set" data="entity_id=0"/>
<action application="set" data="call_processed=internal"/>
<action application="set" data="call_direction=outbound"/>
<action application="set" data="accountname=default"/>
<action application="set" data="filename1=astpp.pbx.lua"/>
<action application="set" data="origination_rates=SHADOWBILLING:|ID:3157584|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|CT:|COST:2.40000|INC:60|INITIALBLOCK:60|RATEGROUP:8|MARKUP:0|CI:0|ACCID:34"/>
<action application="set" data="original_caller_id_name=986057"/>
<action application="set" data="original_caller_id_number=986057"/>

<action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
<action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
<action application="set" data="effective_caller_id_name=986057"/>
<action application="set" data="effective_caller_id_number=986057"/>
<action application="set" data="calltype=STANDARD"/>
<action application="set" data="termination_rates=ID:7|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|COST:1.40000|INC:60|INITIALBLOCK:60|TRUNK:4|PROVIDER:3"/>
<action application="set" data="trunk_id=4"/>
<action application="set" data="provider_id=3"/>
<action application="set" data="rate_flag=0"/>
<action application="set" data="daily_call_credit_limit=0.00000"/>
<action application="set" data="monthly_call_credit_limit=0.00000"/>
<action application="set" data="daily_call_used_limit=0.00000"/>
<action application="set" data="monthly_call_used_limit=0.00000"/>
<action application="set" data="quality_trunk_seq=4"/>
<action application="set" data="force_trunk_flag=3157584"/>
<action application="export" data="presence_data=trunk_id=4"/>
<action application="set" data="intcall=0"/>
<action application="export" data="presence_id=918822001"/>
<action application="export" data="presence_data=x|||Yash(986057)|||^91.* // India // 2.40000 |||YTrunk // ^91.* // India // 1.40000 // trunk_id=4|||STD|||103.240.35.46"/>
<action application="bridge" data="{sip_cid_type=none}[leg_timeout=0]sofia/gateway/YGateway/918822001;fs_path=sip:78.47.101.152:5060"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 parsing [default->918822001] continue=false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Regex (PASS) [918822001] destination_number(918822001) =~ /918822001/ break=on-false
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(effective_destination_number=918822001) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(bridge_pre_execute_bleg_app=sched_hangup) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(notify_flag=0) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(notify_credit_limit=5.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(type=0) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(callstart=2023-06-16 03:51:08) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(hangup_after_bridge=true) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(continue_on_fail=TRUE) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(account_id=34) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(parent_id=0) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(entity_id=0) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(call_processed=internal) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(call_direction=outbound) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(accountname=default) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(filename1=astpp.pbx.lua) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(origination_rates=SHADOWBILLING:|ID:3157584|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|CT:|COST:2.40000|INC:60|INITIALBLOCK:60|RATEGROUP:8|MARKUP:0|CI:0|ACCID:34) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(original_caller_id_name=986057) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(original_caller_id_number=986057) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action hash(insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action hash(insert/${domain_name}-call_return/${destination_number}/${caller_id_number}) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(effective_caller_id_name=986057) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(effective_caller_id_number=986057) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(calltype=STANDARD) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(termination_rates=ID:7|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|COST:1.40000|INC:60|INITIALBLOCK:60|TRUNK:4|PROVIDER:3) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(trunk_id=4) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(provider_id=3) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(rate_flag=0) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(daily_call_credit_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(monthly_call_credit_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(daily_call_used_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(monthly_call_used_limit=0.00000) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(quality_trunk_seq=4) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(force_trunk_flag=3157584) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(presence_data=trunk_id=4) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action set(intcall=0) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(presence_id=918822001) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action export(presence_data=x|||Yash(986057)|||^91.* // India // 2.40000 |||YTrunk // ^91.* // India // 1.40000 // trunk_id=4|||STD|||103.240.35.46) 
Dialplan: sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Action bridge({sip_cid_type=none}[leg_timeout=0]sofia/gateway/YGateway/918822001;fs_path=sip:78.47.101.152:5060) 
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_core_state_machine.c:281 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_ROUTING -> CS_EXECUTE
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State ROUTING going to sleep
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_EXECUTE (Cur 1 Tot 582)
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_sofia.c:213 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA EXECUTE
2023-06-16 03:51:08.076231 90.80% [DEBUG] switch_core_state_machine.c:323 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard EXECUTE
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(effective_destination_number=918822001)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [effective_destination_number]=[918822001]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(bridge_pre_execute_bleg_app=sched_hangup)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [bridge_pre_execute_bleg_app]=[sched_hangup]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(notify_flag=0)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [notify_flag]=[0]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(notify_credit_limit=5.00000)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [notify_credit_limit]=[5.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(type=0)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [type]=[0]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(callstart=2023-06-16 03:51:08)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [callstart]=[2023-06-16 03:51:08]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(hangup_after_bridge=true)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(continue_on_fail=TRUE)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(account_id=34)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [account_id]=[34]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(parent_id=0)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(entity_id=0)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [entity_id]=[0]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(call_processed=internal)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(call_direction=outbound)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [call_direction]=[outbound]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(accountname=default)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [accountname]=[default]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(filename1=astpp.pbx.lua)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [filename1]=[astpp.pbx.lua]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(origination_rates=SHADOWBILLING:|ID:3157584|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|CT:|COST:2.40000|INC:60|INITIALBLOCK:60|RATEGROUP:8|MARKUP:0|CI:0|ACCID:34)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [origination_rates]=[SHADOWBILLING:|ID:3157584|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|CT:|COST:2.40000|INC:60|INITIALBLOCK:60|RATEGROUP:8|MARKUP:0|CI:0|ACCID:34]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(original_caller_id_name=986057)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [original_caller_id_name]=[986057]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(original_caller_id_number=986057)
2023-06-16 03:51:08.076231 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [original_caller_id_number]=[986057]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 hash(insert/clusterguibeta5.astppbilling.org-last_dial/986057/918822001)
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 hash(insert/clusterguibeta5.astppbilling.org-call_return/918822001/986057)
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(effective_caller_id_name=986057)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [effective_caller_id_name]=[986057]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(effective_caller_id_number=986057)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [effective_caller_id_number]=[986057]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(calltype=STANDARD)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [calltype]=[STANDARD]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(termination_rates=ID:7|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|COST:1.40000|INC:60|INITIALBLOCK:60|TRUNK:4|PROVIDER:3)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [termination_rates]=[ID:7|CODE:^91.*|DESTINATION:India|CONNECTIONCOST:0.10000|INCLUDEDSECONDS:0|COST:1.40000|INC:60|INITIALBLOCK:60|TRUNK:4|PROVIDER:3]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(trunk_id=4)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [trunk_id]=[4]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(provider_id=3)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [provider_id]=[3]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(rate_flag=0)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [rate_flag]=[0]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(daily_call_credit_limit=0.00000)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [daily_call_credit_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(monthly_call_credit_limit=0.00000)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [monthly_call_credit_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(daily_call_used_limit=0.00000)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [daily_call_used_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(monthly_call_used_limit=0.00000)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [monthly_call_used_limit]=[0.00000]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(quality_trunk_seq=4)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [quality_trunk_seq]=[4]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(force_trunk_flag=3157584)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [force_trunk_flag]=[3157584]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(presence_data=trunk_id=4)
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[trunk_id=4]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 set(intcall=0)
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_dptools.c:1685 SET sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [intcall]=[0]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(presence_id=918822001)
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_id]=[918822001]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 export(presence_data=x|||Yash(986057)|||^91.* // India // 2.40000 |||YTrunk // ^91.* // India // 1.40000 // trunk_id=4|||STD|||103.240.35.46)
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||Yash(986057)|||^91.* // India // 2.40000 |||YTrunk // ^91.* // India // 1.40000 // trunk_id=4|||STD|||103.240.35.46]
EXECUTE [depth=0] sofia/default/986057@clusterguibeta5.astppbilling.org:5060 bridge({sip_cid_type=none}[leg_timeout=0]sofia/gateway/YGateway/918822001;fs_path=sip:78.47.101.152:5060)
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [did_user_domain]=[clusterguibeta5.astppbilling.org] to event
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [presence_data]=[x|||Yash(986057)|||^91.* // India // 2.40000 |||YTrunk // ^91.* // India // 1.40000 // trunk_id=4|||STD|||103.240.35.46] to event
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [presence_id]=[918822001] to event
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_channel.c:1269 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 EXPORTING[export_vars] [presence_data]=[x|||Yash(986057)|||^91.* // India // 2.40000 |||YTrunk // ^91.* // India // 1.40000 // trunk_id=4|||STD|||103.240.35.46] to event
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_ivr_originate.c:2843 Parsing session specific variables
2023-06-16 03:51:08.096232 90.80% [NOTICE] switch_channel.c:1123 New Channel sofia/default/918822001 [854c6222-5ec8-40d0-ae6a-c7dd30f26d38]
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_sofia.c:5121 (sofia/default/918822001) State Change CS_NEW -> CS_INIT
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/918822001) Running State Change CS_INIT (Cur 2 Tot 583)
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/918822001) State INIT
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_sofia.c:97 sofia/default/918822001 SOFIA INIT
2023-06-16 03:51:08.096232 90.80% [DEBUG] sofia_glue.c:1620 sip:78.47.101.152:5060 Setting proxy route to sofia/default/918822001
2023-06-16 03:51:08.096232 90.80% [INFO] sofia_glue.c:1651 sofia/default/918822001 sending invite call-id: (null)
2023-06-16 03:51:08.096232 90.80% [DEBUG] sofia_glue.c:1654 sofia/default/918822001 sending invite version: 1.10.7 -release 64bit
Local SDP:
v=0
o=FreeSWITCH 1686870786 1686870787 IN IP4 167.235.194.5
s=FreeSWITCH
c=IN IP4 167.235.194.5
t=0 0
m=audio 16682 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv

2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:40 sofia/default/918822001 Standard INIT
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:48 (sofia/default/918822001) State Change CS_INIT -> CS_ROUTING
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/918822001) State INIT going to sleep
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/918822001) Running State Change CS_ROUTING (Cur 2 Tot 583)
2023-06-16 03:51:08.096232 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/918822001 entering state [calling][0]
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/918822001) State ROUTING
2023-06-16 03:51:08.096232 90.80% [DEBUG] mod_sofia.c:158 sofia/default/918822001 SOFIA ROUTING
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_ivr_originate.c:67 (sofia/default/918822001) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/918822001) State ROUTING going to sleep
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/918822001) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 583)
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:659 (sofia/default/918822001) State CONSUME_MEDIA
2023-06-16 03:51:08.096232 90.80% [DEBUG] switch_core_state_machine.c:659 (sofia/default/918822001) State CONSUME_MEDIA going to sleep
2023-06-16 03:51:08.416331 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/918822001 entering state [completing][200]
2023-06-16 03:51:08.416331 90.80% [DEBUG] sofia.c:7509 Remote SDP:
v=0
o=root 1318115297 1318115297 IN IP4 159.203.131.36
s=Asterisk PBX 16.4.0
c=IN IP4 159.203.131.36
t=0 0
m=audio 14922 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=maxptime:150

2023-06-16 03:51:08.416331 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/918822001 entering state [ready][200]
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:150:64000:1]/[PCMA:8:8000:20:64000:1]
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/918822001 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_codec.c:111 sofia/default/918822001 Original read codec set to PCMA:8
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:5973 sofia/default/918822001 Set 2833 dtmf send payload to 101 recv payload to 101
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/918822001] 167.235.194.5 port 16682 -> 159.203.131.36 port 14922 codec: 8 ms: 20
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:9089 sofia/default/918822001 Set 2833 dtmf send payload to 101
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:9096 sofia/default/918822001 Set 2833 dtmf receive payload to 101
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:9119 sofia/default/918822001 Set rtp dtmf delay to 40
2023-06-16 03:51:08.416331 90.80% [NOTICE] sofia.c:8683 Channel [sofia/default/918822001] has been answered
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_channel.c:3950 (sofia/default/918822001) Callstate Change DOWN -> ACTIVE
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/986057@clusterguibeta5.astppbilling.org:5060] 167.235.194.5 port 27844 -> 103.240.35.46 port 8000 codec: 8 ms: 20
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:9089 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf send payload to 101
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:9096 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set 2833 dtmf receive payload to 101
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_media.c:9119 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Set rtp dtmf delay to 40
2023-06-16 03:51:08.416331 90.80% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/986057@clusterguibeta5.astppbilling.org:5060:
v=0
o=FreeSWITCH 1686859624 1686859625 IN IP4 167.235.194.5
s=FreeSWITCH
c=IN IP4 167.235.194.5
t=0 0
m=audio 27844 RTP/AVP 8 101
a=rtpmap:8 PCMA/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-15
a=ptime:20
a=sendrecv

2023-06-16 03:51:08.416331 90.80% [NOTICE] switch_ivr_originate.c:3834 Channel [sofia/default/986057@clusterguibeta5.astppbilling.org:5060] has been answered
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_channel.c:3950 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Callstate Change RINGING -> ACTIVE
2023-06-16 03:51:08.416331 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [completed][200]
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_ivr_originate.c:3892 Originate Resulted in Success: [sofia/default/918822001] Peer UUID: 854c6222-5ec8-40d0-ae6a-c7dd30f26d38
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_ivr_bridge.c:1793 (sofia/default/918822001) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/918822001) Running State Change CS_EXCHANGE_MEDIA (Cur 2 Tot 583)
2023-06-16 03:51:08.416331 90.80% [DEBUG] switch_core_state_machine.c:650 (sofia/default/918822001) State EXCHANGE_MEDIA
2023-06-16 03:51:08.416331 90.80% [DEBUG] mod_sofia.c:671 SOFIA EXCHANGE_MEDIA
2023-06-16 03:51:08.616287 90.80% [DEBUG] switch_ivr_bridge.c:655 sofia/default/918822001 Bridge execute app sched_hangup(+6000 normal_clearing)
2023-06-16 03:51:08.636281 89.67% [DEBUG] switch_ivr.c:632 sofia/default/918822001 Command Execute [depth=0] sched_hangup(+6000 normal_clearing)
EXECUTE [depth=0] sofia/default/918822001 sched_hangup(+6000 normal_clearing)
2023-06-16 03:51:08.636281 89.67% [DEBUG] switch_scheduler.c:263 Added task 32 switch_ivr_schedule_hangup (854c6222-5ec8-40d0-ae6a-c7dd30f26d38) to run at 1686893468
2023-06-16 03:51:08.736283 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 entering state [ready][200]
2023-06-16 03:51:08.756264 89.67% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
2023-06-16 03:51:08.876282 89.67% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_ivr_bridge.c:820 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 ending bridge by request from write function
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_ivr_bridge.c:912 BRIDGE THREAD DONE [sofia/default/918822001]
2023-06-16 03:51:26.176255 89.37% [NOTICE] switch_ivr_bridge.c:1029 Hangup sofia/default/918822001 [CS_EXCHANGE_MEDIA] [NORMAL_CLEARING]
2023-06-16 03:51:26.176255 89.37% [NOTICE] sofia.c:1065 Hangup sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [CS_EXECUTE] [NORMAL_CLEARING]
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:650 (sofia/default/918822001) State EXCHANGE_MEDIA going to sleep
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/918822001) Running State Change CS_HANGUP (Cur 2 Tot 583)
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:844 (sofia/default/918822001) Callstate Change ACTIVE -> HANGUP
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/918822001) State HANGUP
2023-06-16 03:51:26.176255 89.37% [DEBUG] mod_sofia.c:468 Channel sofia/default/918822001 hanging up, cause: NORMAL_CLEARING
2023-06-16 03:51:26.176255 89.37% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/918822001
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_ivr_bridge.c:912 BRIDGE THREAD DONE [sofia/default/986057@clusterguibeta5.astppbilling.org:5060]
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:59 sofia/default/918822001 Standard HANGUP, cause: NORMAL_CLEARING
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/918822001) State HANGUP going to sleep
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:616 (sofia/default/918822001) State Change CS_HANGUP -> CS_REPORTING
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/918822001) Running State Change CS_REPORTING (Cur 2 Tot 583)
2023-06-16 03:51:26.176255 89.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/918822001) State REPORTING
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_ivr_bridge.c:1892 sofia/default/918822001 skip receive message [UNBRIDGE] (channel is hungup already)
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_ivr_bridge.c:1895 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 skip receive message [UNBRIDGE] (channel is hungup already)
2023-06-16 03:51:26.196252 89.37% [INFO] mod_json_cdr.c:271 Process [854c6222-5ec8-40d0-ae6a-c7dd30f26d38.cdr.json]
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_session.c:2983 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 skip receive message [PHONE_EVENT] (channel is hungup already)
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:647 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State EXECUTE going to sleep
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_HANGUP (Cur 2 Tot 583)
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:844 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Callstate Change ACTIVE -> HANGUP
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State HANGUP
2023-06-16 03:51:26.196252 89.37% [DEBUG] mod_sofia.c:468 Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 hanging up, cause: NORMAL_CLEARING
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:59 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard HANGUP, cause: NORMAL_CLEARING
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:846 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State HANGUP going to sleep
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:616 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_HANGUP -> CS_REPORTING
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:581 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_REPORTING (Cur 2 Tot 583)
2023-06-16 03:51:26.196252 89.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State REPORTING
2023-06-16 03:51:26.196252 89.37% [INFO] mod_json_cdr.c:271 Process [c20a7ad8-9f1a-489d-9970-d287594f9e1f.cdr.json]
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:168 sofia/default/918822001 Standard REPORTING, cause: NORMAL_CLEARING
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/918822001) State REPORTING going to sleep
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:607 (sofia/default/918822001) State Change CS_REPORTING -> CS_DESTROY
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_session.c:1753 Session 583 (sofia/default/918822001) Locked, Waiting on external entities
2023-06-16 03:51:26.216281 89.37% [NOTICE] switch_core_session.c:1771 Session 583 (sofia/default/918822001) Ended
2023-06-16 03:51:26.216281 89.37% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/918822001 [CS_DESTROY]
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:735 (sofia/default/918822001) Running State Change CS_DESTROY (Cur 1 Tot 583)
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/918822001) State DESTROY
2023-06-16 03:51:26.216281 89.37% [DEBUG] mod_sofia.c:379 sofia/default/918822001 SOFIA DESTROY
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:175 sofia/default/918822001 Standard DESTROY
2023-06-16 03:51:26.216281 89.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/918822001) State DESTROY going to sleep
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:168 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard REPORTING, cause: NORMAL_CLEARING
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:932 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State REPORTING going to sleep
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:607 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State Change CS_REPORTING -> CS_DESTROY
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_session.c:1753 Session 582 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Locked, Waiting on external entities
2023-06-16 03:51:26.256307 89.37% [NOTICE] switch_core_session.c:1771 Session 582 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Ended
2023-06-16 03:51:26.256307 89.37% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/986057@clusterguibeta5.astppbilling.org:5060 [CS_DESTROY]
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:735 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) Running State Change CS_DESTROY (Cur 0 Tot 583)
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State DESTROY
2023-06-16 03:51:26.256307 89.37% [DEBUG] mod_sofia.c:379 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 SOFIA DESTROY
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:175 sofia/default/986057@clusterguibeta5.astppbilling.org:5060 Standard DESTROY
2023-06-16 03:51:26.256307 89.37% [DEBUG] switch_core_state_machine.c:745 (sofia/default/986057@clusterguibeta5.astppbilling.org:5060) State DESTROY going to sleep
2023-06-16 03:51:26.656280 89.17% [DEBUG] switch_scheduler.c:147 Deleting task 32 switch_ivr_schedule_hangup (854c6222-5ec8-40d0-ae6a-c7dd30f26d38)