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"}] 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 : # 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:
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