span style="color: cornflowerblue; font-weight: bold;"> 2021-02-25 09:42:43.995891 [NOTICE] switch_channel.c:1118 New Channel sofia/default/4810338297@192.168.1.114 [59bd9545-5e24-4cd0-9758-4238eaa875f5]
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:585 (sofia/default/4810338297@192.168.1.114) Running State Change CS_NEW (Cur 1 Tot 19)
2021-02-25 09:42:43.995891 [DEBUG] sofia.c:10280 sofia/default/4810338297@192.168.1.114 receiving invite from 192.168.1.114:5352 version: 1.10.5 -release-17-25569c1631 64bit
2021-02-25 09:42:43.995891 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 192.168.1.114:0.
2021-02-25 09:42:43.995891 [DEBUG] sofia.c:10403 IP 192.168.1.114 Approved by acl "default[]". Access Granted.
2021-02-25 09:42:43.995891 [DEBUG] sofia.c:7326 Channel sofia/default/4810338297@192.168.1.114 entering state [received][100]
2021-02-25 09:42:43.995891 [DEBUG] sofia.c:7336 Remote SDP:
v=0
o=FreeSWITCH 1614218519 1614218520 IN IP4 192.168.1.114
s=FreeSWITCH
c=IN IP4 192.168.1.114
t=0 0
m=audio 27644 RTP/AVP 8 18 101
a=rtpmap:8 PCMA/8000
a=rtpmap:18 G729/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=ptime:20
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1]
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1]
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 101@8000
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/4810338297@192.168.1.114 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
2021-02-25 09:42:43.995891 [DEBUG] switch_core_codec.c:111 sofia/default/4810338297@192.168.1.114 Original read codec set to PCMA:8
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000
2021-02-25 09:42:43.995891 [DEBUG] switch_core_media.c:5911 sofia/default/4810338297@192.168.1.114 Set 2833 dtmf send payload to 101 recv payload to 101
2021-02-25 09:42:43.995891 [DEBUG] sofia.c:7760 (sofia/default/4810338297@192.168.1.114) State Change CS_NEW -> CS_INIT
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:604 (sofia/default/4810338297@192.168.1.114) State NEW
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:585 (sofia/default/4810338297@192.168.1.114) Running State Change CS_INIT (Cur 1 Tot 19)
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:628 (sofia/default/4810338297@192.168.1.114) State INIT
2021-02-25 09:42:43.995891 [DEBUG] mod_sofia.c:93 sofia/default/4810338297@192.168.1.114 SOFIA INIT
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:40 sofia/default/4810338297@192.168.1.114 Standard INIT
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:48 (sofia/default/4810338297@192.168.1.114) State Change CS_INIT -> CS_ROUTING
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:628 (sofia/default/4810338297@192.168.1.114) State INIT going to sleep
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:585 (sofia/default/4810338297@192.168.1.114) Running State Change CS_ROUTING (Cur 1 Tot 19)
2021-02-25 09:42:43.995891 [DEBUG] switch_channel.c:2332 (sofia/default/4810338297@192.168.1.114) Callstate Change DOWN -> RINGING
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:644 (sofia/default/4810338297@192.168.1.114) State ROUTING
2021-02-25 09:42:43.995891 [DEBUG] mod_sofia.c:154 sofia/default/4810338297@192.168.1.114 SOFIA ROUTING
2021-02-25 09:42:43.995891 [DEBUG] switch_core_state_machine.c:236 sofia/default/4810338297@192.168.1.114 Standard ROUTING
2021-02-25 09:42:43.995891 [INFO] mod_dialplan_xml.c:637 Processing ASTPP <4810338297>->1234569156565656 in context default
2021-02-25 09:42:44.015875 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
2021-02-25 09:42:44.015875 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2021-02-25 09:42:44.035912 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] blind_flag: 0
2021-02-25 09:42:44.035912 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 1234569156565656
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1234569156565656' limit 1
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1234569156565656' AND status=0 limit 1
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1234569156565656' and status=0 LIMIT 1
2021-02-25 09:42:44.035912 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number : ASTPP / 4810338297
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1234569156565656" LIMIT 1
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1234569156565656" AND domains.domain="192.168.1.114" limit 1
2021-02-25 09:42:44.035912 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : outbound
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.1.114") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 - SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1)) AND "1234569156565656" LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :123456/*.....1234569156565656
2021-02-25 09:42:44.035912 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 1234569156565656
2021-02-25 09:42:44.035912 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 9156565656
2021-02-25 09:42:44.035912 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 5966448661]
2021-02-25 09:42:44.035912 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9156565656
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "5966448661" AND deleted = 0 limit 1
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^9156565656.*' OR blocked_patterns = '^915656565.*' OR blocked_patterns = '^91565656.*' OR blocked_patterns = '^9156565.*' OR blocked_patterns = '^915656.*' OR blocked_patterns = '^91565.*' OR blocked_patterns = '^9156.*' OR blocked_patterns = '^915.*' OR blocked_patterns = '^91.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND accountid = 60 limit 1
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [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 ="9156565656" AND A.accountid = '60' limit 1
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9156565656
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9156565656" LIMIT 1
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : inbound
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9156565656" AND (accountid = 0 OR status = 1) LIMIT 1
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :60
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^9156565656.*' OR patterns = '^915656565.*' OR patterns = '^91565656.*' OR patterns = '^9156565.*' OR patterns = '^915656.*' OR patterns = '^91565.*' OR patterns = '^9156.*' OR patterns = '^915.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 60 ORDER BY LENGTH(PKGPTR.patterns) DESC
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '9156565656' OR number = '915656565' OR number = '91565656' OR number = '9156565' OR number = '915656' OR number = '91565' OR number = '9156' OR number = '915' OR number = '91' OR number = '9' OR number ='--') OR (number = '9156565656*' OR number = '915656565*' OR number = '91565656*' OR number = '9156565*' OR number = '915656*' OR number = '91565*' OR number = '9156*' OR number = '915*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '4810338297' OR number = '481033829' OR number = '48103382' OR number = '4810338' OR number = '481033' OR number = '48103' OR number = '4810' OR number = '481' OR number = '48' OR number = '4' OR number ='--') OR (number = '4810338297*' OR number = '481033829*' OR number = '48103382*' OR number = '4810338*' OR number = '481033*' OR number = '48103*' OR number = '4810*' OR number = '481*' OR number = '48*' OR number = '4*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9156565656' OR routing_prefix = '915656565' OR routing_prefix = '91565656' OR routing_prefix = '9156565' OR routing_prefix = '915656' OR routing_prefix = '91565' OR routing_prefix = '9156' OR routing_prefix = '915' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 60
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 5966448661
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 495.255
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :inbound
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9156565656" LIMIT 1
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] call_direction:::::: inbound
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 14
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 0
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.00000
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] comment : 9156565656
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 88
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 60
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your495.255 balance Accountid 60 !!!
2021-02-25 09:42:44.055860 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call is free - assigning max length!!! :: 100
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length duration : 100 minutes
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] INB_FREE:TRUE
2021-02-25 09:42:44.055860 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] free_inbound:1
2021-02-25 09:42:44.055860 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 60 AND status=0 LIMIT 1
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "60" AND deleted = 0 limit 1
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Actual CustomerInfo XML:60
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Userinfo XML:60
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Actual CustomerInfo XML : 60
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 60 limit 1
2021-02-25 09:42:44.075862 [WARNING] switch_cpp.cpp:1447 [ASTPP] [user_domain] user_domain192.168.1.114
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] timecondition_id : 2
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] failover_timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
span style="color: green; font-weight: bold;"> 2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] timecondition : [{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-2","year":"2021-2021","extensions":"63","no_answer_call_type":"11","priority":"1"}]
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] failover_timecondition_str : #
span style="color: green; font-weight: bold;"> 2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] priority : 1
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [sipdevice_form_id] Query :SELECT username from sip_devices where id = "63" limit 1
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '92' LIMIT 1
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] condition_str : time-of-day= "00:00-23:59" wday= "1-7" mday= "1-31" mon= "1-2" year= "2021-2021"
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength::::::::: 100
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] customer_userinfo['is_recording'] : 1
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] call_direction : inbound
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [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
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 60 limit 1
2021-02-25 09:42:44.075862 [WARNING] switch_cpp.cpp:1447 [ASTPP] [user_domain] user_domain192.168.1.114
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_11
2021-02-25 09:42:44.075862 [INFO] switch_cpp.cpp:1447 [ASTPP] [TIME_COND] timecondition_id : 2
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] time_condition::::::::::::::::::::::::14
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [ASTPP] custom_function_name::::::::::::::::::::::::14
2021-02-25 09:42:44.075862 [DEBUG] switch_cpp.cpp:1447 [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="WWW" continue="true">
<condition break="never">
<action application="set" data="timezone=America/Glace_Bay" inline="true"/>
</condition>
<condition time-of-day= "00:00-23:59" wday= "1-7" mday= "1-31" mon= "1-2" year= "2021-2021" break="never">
<action application="set" data="office_status=open" inline="true"/>
<action application="set" data="extensions=5966448661" inline="true"/>
<action application="set" data="no_answer_call_type=11" inline="true"/>
</condition>
</extension>
<extension name="tod route, x9156565656">
<condition field="destination_number" expression="^(\+?)?(9156565656)$">
<action application="execute_extension" data="9156565656_${office_status}"/>
</condition>
</extension>
<extension name="office is open">
<condition field="destination_number" expression="^(\+?)?(9156565656_open)$">
<action application="set" data="domain_name=192.168.1.114"/>
<action application="set" data="set_extensions=${extensions}"/>
<action application="set" data="no_answer_flag=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="60 XML default"/>
</condition>
</extension>
<extension name="9156565656">
<condition field="destination_number" expression="1234569156565656">
<action application="set" data="effective_destination_number=9156565656"/>
<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="callstart=2021-02-25 09:42:44"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=TRUE"/>
<action application="set" data="account_id=60"/>
<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=SameerIP"/>
<action application="set" data="origination_rates_did=ID:14|CODE:^9156565656.*|DESTINATION:9156565656|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:60"/>
<action application="set" data="origination_rates=0"/>
<action application="set" data="original_caller_id_name=ASTPP"/>
<action application="set" data="original_caller_id_number=4810338297"/>
<action application="limit" data="db 60 user_60 60 "/>
<action application="set" data="effective_caller_id_name=ASTPP"/>
<action application="set" data="effective_caller_id_number=4810338297"/>
<action application="set" data="receiver_accid=60"/>
<action application="export" data="domain_name=192.168.1.114"/>
<action application="export" data="sip_to_host=192.168.1.114"/>
<action application="limit" data="db 9156565656 did_9156565656 60 "/>
<action application="export" data="presence_data=x|||Call(5966448661)|||^9156565656.* // 9156565656 // 0.00000||||||DID|||192.168.1.114"/>
<action application="export" data="call_type=11"/>
</condition>
</extension>
</context>
</section>
</document>
Dialplan: sofia/default/4810338297@192.168.1.114 parsing [default->WWW] continue=true
Dialplan: sofia/default/4810338297@192.168.1.114 Absolute Condition [WWW]
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(timezone=America/Glace_Bay) INLINE
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(timezone=America/Glace_Bay)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [timezone]=[America/Glace_Bay]
Dialplan: sofia/default/4810338297@192.168.1.114 Date/Time Match (PASS) [WWW] break=never
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(office_status=open) INLINE
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(office_status=open)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [office_status]=[open]
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(extensions=5966448661) INLINE
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(extensions=5966448661)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [extensions]=[5966448661]
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(no_answer_call_type=11) INLINE
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(no_answer_call_type=11)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [no_answer_call_type]=[11]
Dialplan: sofia/default/4810338297@192.168.1.114 parsing [default->tod route, x9156565656] continue=false
Dialplan: sofia/default/4810338297@192.168.1.114 Regex (FAIL) [tod route, x9156565656] destination_number(1234569156565656) =~ /^(\+?)?(9156565656)$/ break=on-false
Dialplan: sofia/default/4810338297@192.168.1.114 parsing [default->office is open] continue=false
Dialplan: sofia/default/4810338297@192.168.1.114 Regex (FAIL) [office is open] destination_number(1234569156565656) =~ /^(\+?)?(9156565656_open)$/ break=on-false
Dialplan: sofia/default/4810338297@192.168.1.114 parsing [default->9156565656] continue=false
Dialplan: sofia/default/4810338297@192.168.1.114 Regex (PASS) [9156565656] destination_number(1234569156565656) =~ /1234569156565656/ break=on-false
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(effective_destination_number=9156565656)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(bridge_pre_execute_bleg_app=sched_hangup)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(callstart=2021-02-25 09:42:44)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(hangup_after_bridge=true)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(continue_on_fail=TRUE)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(account_id=60)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(parent_id=0)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(entity_id=0)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(call_processed=internal)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(call_direction=inbound)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(accountname=SameerIP)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(origination_rates_did=ID:14|CODE:^9156565656.*|DESTINATION:9156565656|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:60)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(origination_rates=0)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(original_caller_id_name=ASTPP)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(original_caller_id_number=4810338297)
Dialplan: sofia/default/4810338297@192.168.1.114 Action limit(db 60 user_60 60 )
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(effective_caller_id_name=ASTPP)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(effective_caller_id_number=4810338297)
Dialplan: sofia/default/4810338297@192.168.1.114 Action set(receiver_accid=60)
Dialplan: sofia/default/4810338297@192.168.1.114 Action export(domain_name=192.168.1.114)
Dialplan: sofia/default/4810338297@192.168.1.114 Action export(sip_to_host=192.168.1.114)
Dialplan: sofia/default/4810338297@192.168.1.114 Action limit(db 9156565656 did_9156565656 60 )
Dialplan: sofia/default/4810338297@192.168.1.114 Action export(presence_data=x|||Call(5966448661)|||^9156565656.* // 9156565656 // 0.00000||||||DID|||192.168.1.114)
Dialplan: sofia/default/4810338297@192.168.1.114 Action export(call_type=11)
2021-02-25 09:42:44.075862 [DEBUG] switch_core_state_machine.c:287 (sofia/default/4810338297@192.168.1.114) State Change CS_ROUTING -> CS_EXECUTE
2021-02-25 09:42:44.075862 [DEBUG] switch_core_state_machine.c:644 (sofia/default/4810338297@192.168.1.114) State ROUTING going to sleep
2021-02-25 09:42:44.075862 [DEBUG] switch_core_state_machine.c:585 (sofia/default/4810338297@192.168.1.114) Running State Change CS_EXECUTE (Cur 1 Tot 19)
2021-02-25 09:42:44.075862 [DEBUG] switch_core_state_machine.c:651 (sofia/default/4810338297@192.168.1.114) State EXECUTE
2021-02-25 09:42:44.075862 [DEBUG] mod_sofia.c:209 sofia/default/4810338297@192.168.1.114 SOFIA EXECUTE
2021-02-25 09:42:44.075862 [DEBUG] switch_core_state_machine.c:329 sofia/default/4810338297@192.168.1.114 Standard EXECUTE
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(effective_destination_number=9156565656)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [effective_destination_number]=[9156565656]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(bridge_pre_execute_bleg_app=sched_hangup)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [bridge_pre_execute_bleg_app]=[sched_hangup]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(callstart=2021-02-25 09:42:44)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [callstart]=[2021-02-25 09:42:44]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(hangup_after_bridge=true)
2021-02-25 09:42:44.075862 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [hangup_after_bridge]=[true]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(continue_on_fail=TRUE)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [continue_on_fail]=[TRUE]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(account_id=60)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [account_id]=[60]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(parent_id=0)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [parent_id]=[0]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(entity_id=0)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [entity_id]=[0]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(call_processed=internal)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [call_processed]=[internal]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(call_direction=inbound)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [call_direction]=[inbound]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(accountname=SameerIP)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [accountname]=[SameerIP]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(origination_rates_did=ID:14|CODE:^9156565656.*|DESTINATION:9156565656|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:60)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [origination_rates_did]=[ID:14|CODE:^9156565656.*|DESTINATION:9156565656|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:60]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(origination_rates=0)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [origination_rates]=[0]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(original_caller_id_name=ASTPP)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [original_caller_id_name]=[ASTPP]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(original_caller_id_number=4810338297)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [original_caller_id_number]=[4810338297]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 limit(db 60 user_60 60 )
2021-02-25 09:42:44.095861 [DEBUG] switch_limit.c:124 incr called: 60_user_60 max:60, interval:0
2021-02-25 09:42:44.095861 [DEBUG] mod_db.c:194 Usage for 60_user_60 is now 1/60
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(effective_caller_id_name=ASTPP)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [effective_caller_id_name]=[ASTPP]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(effective_caller_id_number=4810338297)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [effective_caller_id_number]=[4810338297]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 set(receiver_accid=60)
2021-02-25 09:42:44.095861 [DEBUG] mod_dptools.c:1672 SET sofia/default/4810338297@192.168.1.114 [receiver_accid]=[60]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 export(domain_name=192.168.1.114)
2021-02-25 09:42:44.095861 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [domain_name]=[192.168.1.114]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 export(sip_to_host=192.168.1.114)
2021-02-25 09:42:44.095861 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [sip_to_host]=[192.168.1.114]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 limit(db 9156565656 did_9156565656 60 )
2021-02-25 09:42:44.095861 [DEBUG] switch_limit.c:124 incr called: 9156565656_did_9156565656 max:60, interval:0
2021-02-25 09:42:44.095861 [DEBUG] mod_db.c:194 Usage for 9156565656_did_9156565656 is now 1/60
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 export(presence_data=x|||Call(5966448661)|||^9156565656.* // 9156565656 // 0.00000||||||DID|||192.168.1.114)
2021-02-25 09:42:44.095861 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||Call(5966448661)|||^9156565656.* // 9156565656 // 0.00000||||||DID|||192.168.1.114]
EXECUTE [depth=0] sofia/default/4810338297@192.168.1.114 export(call_type=11)
2021-02-25 09:42:44.095861 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [call_type]=[11]
2021-02-25 09:42:44.095861 [NOTICE] switch_core_state_machine.c:386 sofia/default/4810338297@192.168.1.114 has executed the last dialplan instruction, hanging up.
2021-02-25 09:42:44.095861 [NOTICE] switch_core_state_machine.c:388 Hangup sofia/default/4810338297@192.168.1.114 [CS_EXECUTE] [NORMAL_CLEARING]
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:651 (sofia/default/4810338297@192.168.1.114) State EXECUTE going to sleep
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:585 (sofia/default/4810338297@192.168.1.114) Running State Change CS_HANGUP (Cur 1 Tot 19)
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:848 (sofia/default/4810338297@192.168.1.114) Callstate Change RINGING -> HANGUP
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:850 (sofia/default/4810338297@192.168.1.114) State HANGUP
2021-02-25 09:42:44.095861 [DEBUG] mod_sofia.c:453 Channel sofia/default/4810338297@192.168.1.114 hanging up, cause: NORMAL_CLEARING
2021-02-25 09:42:44.095861 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 480
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:60 sofia/default/4810338297@192.168.1.114 Standard HANGUP, cause: NORMAL_CLEARING
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:850 (sofia/default/4810338297@192.168.1.114) State HANGUP going to sleep
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:620 (sofia/default/4810338297@192.168.1.114) State Change CS_HANGUP -> CS_REPORTING
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:585 (sofia/default/4810338297@192.168.1.114) Running State Change CS_REPORTING (Cur 1 Tot 19)
2021-02-25 09:42:44.095861 [DEBUG] switch_core_state_machine.c:936 (sofia/default/4810338297@192.168.1.114) State REPORTING
2021-02-25 09:42:44.095861 [INFO] mod_json_cdr.c:271 Process [59bd9545-5e24-4cd0-9758-4238eaa875f5.cdr.json]
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:174 sofia/default/4810338297@192.168.1.114 Standard REPORTING, cause: NORMAL_CLEARING
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:936 (sofia/default/4810338297@192.168.1.114) State REPORTING going to sleep
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:611 (sofia/default/4810338297@192.168.1.114) State Change CS_REPORTING -> CS_DESTROY
2021-02-25 09:42:44.395912 [DEBUG] switch_core_session.c:1726 Session 19 (sofia/default/4810338297@192.168.1.114) Locked, Waiting on external entities
2021-02-25 09:42:44.395912 [NOTICE] switch_core_session.c:1744 Session 19 (sofia/default/4810338297@192.168.1.114) Ended
2021-02-25 09:42:44.395912 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/4810338297@192.168.1.114 [CS_DESTROY]
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:739 (sofia/default/4810338297@192.168.1.114) Running State Change CS_DESTROY (Cur 0 Tot 19)
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:749 (sofia/default/4810338297@192.168.1.114) State DESTROY
2021-02-25 09:42:44.395912 [DEBUG] mod_sofia.c:364 sofia/default/4810338297@192.168.1.114 SOFIA DESTROY
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:181 sofia/default/4810338297@192.168.1.114 Standard DESTROY
2021-02-25 09:42:44.395912 [DEBUG] switch_core_state_machine.c:749 (sofia/default/4810338297@192.168.1.114) State DESTROY going to sleep