FreeSWITCH Pastebin

time condition

From Scanty Hamster, 3 Years ago, written in FreeSWITCH.
- go back
URL https://pastebin.freeswitch.org/view/e2efcc49
Embed
Viewing differences between and time condition
  1. <extension name="tod route, x0103130012">                                                                                                    
  2. <condition field="destination_number" expression="^(\+?)?(0103130012)$">                                                                      
  3. <action application="execute_extension" data="0103130012_${office_status}"/>                                                                  
  4. </condition>                                                                                                                                  
  5. </extension>                                                                                                                                  
  6. <extension name="office is open">                                                                                                            
  7. <condition field="destination_number" expression="^(\+?)?(0103130012_open)$">                                                                
  8. <action application="set" data="domain_name=Electronicconnect.nebular.co.za"/>                                                                
  9. <action application="set" data="set_extensions=${extensions}"/>                                                                              
  10. <action application="set" data="no_answer_flag=true"/>                                                                                        
  11. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>                                                                
  12. <action application="set" data="no_answer_number=${extensions}" />                                                                            
  13. <action application="transfer" data="23 XML default"/>                                                                                        
  14. </condition>                                                                                                                                  
  15. </extension>                                                                                                                                  
  16. <extension name="0103130012">                                                                                                                
  17. <condition field="destination_number" expression="0103130012">                                                                                
  18. <action application="set" data="effective_destination_number=0103130012"/>                                                                    
  19. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>                                                                  
  20. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>                                                        
  21. <action application="set" data="callstart=2021-09-17 07:02:40"/>                                                                              
  22. <action application="set" data="hangup_after_bridge=true"/>                                                                                  
  23. <action application="set" data="continue_on_fail=TRUE"/>                                                                                      
  24. <action application="set" data="account_id=3"/>                                                                                              
  25. <action application="set" data="parent_id=0"/>                                                                                                
  26. <action application="set" data="entity_id=3"/>                                                                                                
  27. <action application="set" data="call_processed=internal"/>                                                                                    
  28. <action application="set" data="call_direction=inbound"/>                                                                                    
  29. <action application="set" data="accountname=default"/>                                                                                        
  30. <action application="set" data="origination_rates_did=ID:2029|CODE:^0103130012.*|DESTINATION:0103130012|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:171|ACCID:23"/>                                                            
  31. <action application="set" data="origination_rates=0"/>                                                                                        
  32. <action application="set" data="original_caller_id_name=0720692958"/>                                                                        
  33. <action application="set" data="effective_caller_id_name=27720692958"/>                                                                      
  34. <action application="set" data="receiver_accid=23"/>                                                                                          
  35. <action application="export" data="domain_name=Electronicconnect.nebular.co.za"/>                                                            
  36. <action application="export" data="sip_to_host=Electronicconnect.nebular.co.za"/>                                                            
  37. <action application="export" data="presence_data=x|||default(3673942894)|||^0103130012.* // 0103130012 // 0.00000||||||DID|||41.160.32.115"/>
  38. <action application="export" data="call_type=11"/>                                                                                            
  39. </condition>                                                                                                                                  
  40. </extension>                                                                                                                                  
  41. </context>                                                                                                                                    
  42. </section>                                                                                                                                    
  43. </document>                                                                                                                                  
  44. 2021-09-17 09:02:40.283442 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7f98780ffd80 released.
  45. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  46. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/Time Match (PASS) [testinextrix] break=never
  47. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(office_status=open) INLINE
  48. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(office_status=open)
  49. 2021-09-17 09:02:40.283442 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [office_status]=[open]
  50. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(extensions=0731898326#) INLINE
  51. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(extensions=0731898326#)
  52. span style="color: goldenrod; font-weight: bold;"> 2021-09-17 09:02:40.283442 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [extensions]=[0731898326#]
  53. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(no_answer_call_type=12) INLINE
  54. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(no_answer_call_type=12)
  55. 2021-09-17 09:02:40.283442 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [no_answer_call_type]=[12]
  56. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  57. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Absolute Condition [testinextrix]
  58. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(timezone=Africa/Johannesburg) INLINE
  59. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(timezone=Africa/Johannesburg)
  60. 2021-09-17 09:02:40.283442 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [timezone]=[Africa/Johannesburg]
  61. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/TimeMatch (FAIL) [testinextrix] break=never
  62. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  63. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Absolute Condition [testinextrix]
  64. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(timezone=Africa/Johannesburg) INLINE
  65. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(timezone=Africa/Johannesburg)
  66. 2021-09-17 09:02:40.283442 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [timezone]=[Africa/Johannesburg]
  67. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/TimeMatch (FAIL) [testinextrix] break=never
  68. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  69. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Absolute Condition [testinextrix]
  70. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(timezone=Africa/Johannesburg) INLINE
  71. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(timezone=Africa/Johannesburg)
  72. 2021-09-17 09:02:40.283442 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [timezone]=[Africa/Johannesburg]
  73. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/TimeMatch (FAIL) [testinextrix] break=never
  74. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->tod route, x0103130012] continue=false
  75. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Regex (PASS) [tod route, x0103130012] destination_number(0103130012) =~ /^(\+?)?(0103130012)$/ break=on-false                                                                                                                        
  76. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action execute_extension(0103130012_${office_status})
  77. 2021-09-17 09:02:40.283442 [DEBUG] switch_core_state_machine.c:286 (sofia/default/0720692958@41.160.32.115:5060) State Change CS_ROUTING -> CS_EXECUTE                                                                                                                                      
  78. 2021-09-17 09:02:40.283442 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0720692958@41.160.32.115:5060) State ROUTING going to sleep
  79. 2021-09-17 09:02:40.283442 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0720692958@41.160.32.115:5060) Running State Change CS_EXECUTE (Cur 1 Tot 2132)                                                                                                                          
  80. 2021-09-17 09:02:40.283442 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0720692958@41.160.32.115:5060) State EXECUTE
  81. 2021-09-17 09:02:40.283442 [DEBUG] mod_sofia.c:198 sofia/default/0720692958@41.160.32.115:5060 SOFIA EXECUTE
  82. 2021-09-17 09:02:40.283442 [DEBUG] switch_core_state_machine.c:328 sofia/default/0720692958@41.160.32.115:5060 Standard EXECUTE
  83. EXECUTE sofia/default/0720692958@41.160.32.115:5060 execute_extension(0103130012_open)
  84. 2021-09-17 09:02:40.283442 [INFO] mod_dialplan_xml.c:637 Processing 0720692958 <0720692958>->0103130012_open in context default
  85. 2021-09-17 09:02:40.283442 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7f98780ffd80 Connected.
  86. 2021-09-17 09:02:40.283442 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')                                                                                  
  87. 2021-09-17 09:02:40.283442 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  88. 2021-09-17 09:02:40.303219 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] blind_flag: 0
  89. 2021-09-17 09:02:40.303219 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 0103130012
  90. 2021-09-17 09:02:40.303219 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '0103130012' limit 1                                                                                                
  91. 2021-09-17 09:02:40.303219 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0103130012' AND status=0 limit 1                                                                                                      
  92. 2021-09-17 09:02:40.323208 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '0103130012' and status=0 LIMIT 1                                                                
  93. 2021-09-17 09:02:40.323208 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number  : 0720692958 / <null>
  94. 2021-09-17 09:02:40.323208 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130012" LIMIT 1                                                                                            
  95. 2021-09-17 09:02:40.323208 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : inbound
  96. 2021-09-17 09:02:40.323208 [INFO] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 3673942894]
  97. 2021-09-17 09:02:40.323208 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "3673942894" AND deleted = 0 limit 1                                                                                                                          
  98. 2021-09-17 09:02:40.343222 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="0103130012" AND (accountid = 0 OR status = 1) LIMIT 1                                                                                                                
  99. 2021-09-17 09:02:40.343222 [NOTICE] switch_cpp.cpp:1365 [ASTPP] Localization Id: 5
  100. 2021-09-17 09:02:40.343222 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 5 AND status=0 limit 1                                                        
  101. 2021-09-17 09:02:40.363245 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  102. 2021-09-17 09:02:40.363245 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 23
  103. 2021-09-17 09:02:40.363245 [DEBUG] switch_cpp.cpp:1365 [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 = '^0103130012.*' OR patterns = '^010313001.*' OR patterns = '^01031300.*' OR patterns = '^0103130.*' OR patterns = '^010313.*' OR patterns = '^01031.*' OR patterns = '^0103.*' OR patterns = '^010.*' OR patterns = '^01.*' OR patterns = '^0.*' OR patterns ='--') AND accountid = 23 ORDER BY LENGTH(PKGPTR.patterns) DESC                                                                                                                                      
  104. 2021-09-17 09:02:40.363245 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130012" AND A.accountid = '3' limit 1                                
  105. 2021-09-17 09:02:40.383213 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 0103130012
  106. 2021-09-17 09:02:40.383213 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130012" LIMIT 1                                                                                            
  107. 2021-09-17 09:02:40.383213 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] New Call Direction : inbound
  108. 2021-09-17 09:02:40.383213 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '0103130012' OR number = '010313001' OR number = '01031300' OR number = '0103130' OR number = '010313' OR number = '01031' OR number = '0103' OR number = '010' OR number = '01' OR number = '0' OR number ='--') OR (number = '0103130012*' OR number = '010313001*' OR number = '01031300*' OR number = '0103130*' OR number = '010313*' OR number = '01031*' OR number = '0103*' OR number = '010*' OR number = '01*' OR number = '0*' OR number ='--') OR (number = '<null>' OR number = '<null' OR number = '<nul' OR number = '<nu' OR number = '<n' OR number = '<' OR number ='--') OR (number = '<null>*' OR number = '<null*' OR number = '<nul*' OR number = '<nu*' OR number = '<n*' OR number = '<*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC          
  109. 2021-09-17 09:02:40.383213 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Call Barring Status : -1
  110. 2021-09-17 09:02:40.383213 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '0103130012' OR routing_prefix = '010313001' OR routing_prefix = '01031300' OR routing_prefix = '0103130' OR routing_prefix = '010313' OR routing_prefix = '01031' OR routing_prefix = '0103' OR routing_prefix = '010' OR routing_prefix = '01' OR routing_prefix = '0' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1                                                    
  111. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Account Information ===================
  112. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 3
  113. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 3673942894
  114. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 10000
  115. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  116. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 15
  117. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] CID Pool : 0
  118. 2021-09-17 09:02:40.403288 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================================================
  119. 2021-09-17 09:02:40.403288 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 15 AND status = 0                                                                                                                                            
  120. 2021-09-17 09:02:40.423226 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :inbound
  121. 2021-09-17 09:02:40.423226 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130012" LIMIT 1                                                                                            
  122. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP]  Call Direction : inbound
  123. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information ===================
  124. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 2029
  125. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
  126. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0
  127. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.00000
  128. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : 0103130012
  129. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 171
  130. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 3
  131. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================
  132. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your10000 balance Accountid 3 !!!
  133. 2021-09-17 09:02:40.423226 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  134. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Max Length Duration : 100 minutes
  135. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] [userinfo] INB_FREE:TRUE
  136. 2021-09-17 09:02:40.423226 [INFO] switch_cpp.cpp:1365 [ASTPP] [userinfo] free_inbound:1
  137. 2021-09-17 09:02:40.423226 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 3 AND status=0 LIMIT 1                                                      
  138. 2021-09-17 09:02:40.443213 [INFO] switch_cpp.cpp:1365 [ASTPP] [userinfo] sandip +++++23
  139. 2021-09-17 09:02:40.443213 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "23" AND deleted = 0 limit 1                                                                                                                                      
  140. 2021-09-17 09:02:40.443213 [INFO] switch_cpp.cpp:1365 [ASTPP] [userinfo] Actual CustomerInfo XML:3
  141. 2021-09-17 09:02:40.443213 [INFO] switch_cpp.cpp:1365 [ASTPP] [userinfo] Userinfo XML:3
  142. 2021-09-17 09:02:40.443213 [INFO] switch_cpp.cpp:1365 [ASTPP] [userinfo] Actual CustomerInfo XML : 3
  143. 2021-09-17 09:02:40.443213 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 23 limit 1
  144. 2021-09-17 09:02:40.464463 [WARNING] switch_cpp.cpp:1365 [ASTPP] [user_domain] User Domain : Electronicconnect.nebular.co.za
  145. 2021-09-17 09:02:40.464463 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Timecondition Id : 13
  146. 2021-09-17 09:02:40.464463 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '13' and status =0 LIMIT 1                                                                                                            
  147. 2021-09-17 09:02:40.464463 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"0731898326#","no_answer_call_type":"12"}]                                                                                                                                
  148. span style="color: green; font-weight: bold;"> 2021-09-17 09:02:40.464463 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Timecondition : [{"hour":"09-18","minute":"05-00","wday":"2-6","mday":"1-31","mon":"1-12","year":"2021-2021","extensions":"5","no_answer_call_type":"7","priority":"3"},{"hour":"00-09","minute":"00-04","wday":"2-6","mday":"1-31","mon":"12-12","year":"2021-2021","extensions":"0731898326#","no_answer_call_type":"12","priority":"2"},{"hour":"18-23","minute":"01-59","wday":"2-6","mday":"1-31","mon":"12-12","year":"2021-2021","extensions":"0731898326#","no_answer_call_type":"12","priority":"1"}]
  149. span style="color: green; font-weight: bold;"> 2021-09-17 09:02:40.464463 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Priority : 3
  150. 2021-09-17 09:02:40.464463 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '845' LIMIT 1                                                                                                                                
  151. 2021-09-17 09:02:40.483755 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "09:05-18:00"  wday= "2-6"  mday= "1-31"  mon= "1-12"  year= "2021-2021"                                                                                                            
  152. 2021-09-17 09:02:40.483755 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Priority : 2
  153. 2021-09-17 09:02:40.483755 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '845' LIMIT 1                                                                                                                                
  154. 2021-09-17 09:02:40.483755 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-09:04"  wday= "2-6"  mday= "1-31"  mon= "12-12"  year= "2021-2021"                                                                                                          
  155. 2021-09-17 09:02:40.483755 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Priority : 1
  156. 2021-09-17 09:02:40.483755 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '845' LIMIT 1                                                                                                                                
  157. 2021-09-17 09:02:40.483755 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "18:01-23:59"  wday= "2-6"  mday= "1-31"  mon= "12-12"  year= "2021-2021"                                                                                                          
  158. 2021-09-17 09:02:40.483755 [INFO] switch_cpp.cpp:1365 [ASTPP]  Maxlength : 100
  159. 2021-09-17 09:02:40.483755 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  160. 2021-09-17 09:02:40.503391 [INFO] switch_cpp.cpp:1365 [ASTPP] [XML] Customer Recording Flag : 1
  161. 2021-09-17 09:02:40.503391 [INFO] switch_cpp.cpp:1365 [ASTPP] [PBX] call_direction : inbound
  162. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"0/27".....0720692958
  163. 2021-09-17 09:02:40.503391 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 0720692958
  164. 2021-09-17 09:02:40.503391 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 27720692958
  165. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"0/27".....<null>
  166. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 23 limit 1
  167. 2021-09-17 09:02:40.503391 [WARNING] switch_cpp.cpp:1365 [ASTPP] [XML] User Domain : Electronicconnect.nebular.co.za
  168. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  169. 2021-09-17 09:02:40.503391 [INFO] switch_cpp.cpp:1365 [ASTPP] [TIME_COND] timecondition_id : 13
  170. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '13' and status =0 LIMIT 1                                                                                                            
  171. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] time_condition::::::::::::::::::::::::2029
  172. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] custom_function_name::::::::::::::::::::::::2029
  173. 2021-09-17 09:02:40.503391 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  174. <document type="freeswitch/xml">                                                                                                              
  175. <section name="dialplan" description="ASTPP Dialplan">                                                                                        
  176. <context name="default">                                                                                                                      
  177. <extension name="testinextrix" continue="true">                                                                                              
  178. <condition time-of-day= "00:01-23:59" break="never">                                                                                          
  179. <action application="set" data="office_status=open" inline="true"/>                                                                          
  180. <action application="set" data="extensions=0731898326#" inline="true"/>                                                                      
  181. <action application="set" data="no_answer_call_type=12" inline="true"/>                                                                      
  182. </condition>                                                                                                                                  
  183. </extension>                                                                                                                                  
  184. <extension name="testinextrix" continue="true">                                                                                              
  185. <condition break="never">                                                                                                                    
  186. <action application="set" data="timezone=Africa/Johannesburg" inline="true"/>                                                                
  187. </condition>                                                                                                                                  
  188. <condition  time-of-day= "09:05-18:00"  wday= "2-6"  mday= "1-31"  mon= "1-12"  year= "2021-2021"  break="never">                            
  189. <action application="set" data="office_status=open" inline="true"/>                                                                          
  190. <action application="set" data="extensions=5" inline="true"/>                                                                                
  191. <action application="set" data="no_answer_call_type=7" inline="true"/>                                                                        
  192. </condition>                                                                                                                                  
  193. </extension>                                                                                                                                  
  194. <extension name="testinextrix" continue="true">                                                                                              
  195. <condition break="never">                                                                                                                    
  196. <action application="set" data="timezone=Africa/Johannesburg" inline="true"/>                                                                
  197. </condition>                                                                                                                                  
  198. <condition  time-of-day= "00:00-09:04"  wday= "2-6"  mday= "1-31"  mon= "12-12"  year= "2021-2021"  break="never">                            
  199. <action application="set" data="office_status=open" inline="true"/>                                                                          
  200. <action application="set" data="extensions=0731898326#" inline="true"/>                                                                      
  201. <action application="set" data="no_answer_call_type=12" inline="true"/>                                                                      
  202. </condition>                                                                                                                                  
  203. </extension>                                                                                                                                  
  204. <extension name="testinextrix" continue="true">                                                                                              
  205. <condition break="never">                                                                                                                    
  206. <action application="set" data="timezone=Africa/Johannesburg" inline="true"/>                                                                
  207. </condition>                                                                                                                                  
  208. <condition  time-of-day= "18:01-23:59"  wday= "2-6"  mday= "1-31"  mon= "12-12"  year= "2021-2021"  break="never">                            
  209. <action application="set" data="office_status=open" inline="true"/>                                                                          
  210. <action application="set" data="extensions=0731898326#" inline="true"/>                                                                      
  211. <action application="set" data="no_answer_call_type=12" inline="true"/>                                                                      
  212. </condition>                                                                                                                                  
  213. </extension>                                                                                                                                  
  214. <extension name="tod route, x0103130012">                                                                                                    
  215. <condition field="destination_number" expression="^(\+?)?(0103130012)$">                                                                      
  216. <action application="execute_extension" data="0103130012_${office_status}"/>                                                                  
  217. </condition>                                                                                                                                  
  218. </extension>                                                                                                                                  
  219. <extension name="office is open">                                                                                                            
  220. <condition field="destination_number" expression="^(\+?)?(0103130012_open)$">                                                                
  221. <action application="set" data="domain_name=Electronicconnect.nebular.co.za"/>                                                                
  222. <action application="set" data="set_extensions=${extensions}"/>                                                                              
  223. <action application="set" data="no_answer_flag=true"/>                                                                                        
  224. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>                                                                
  225. <action application="set" data="no_answer_number=${extensions}" />                                                                            
  226. <action application="transfer" data="23 XML default"/>                                                                                        
  227. </condition>                                                                                                                                  
  228. </extension>                                                                                                                                  
  229. <extension name="0103130012">                                                                                                                
  230. <condition field="destination_number" expression="0103130012">                                                                                
  231. <action application="set" data="effective_destination_number=0103130012"/>                                                                    
  232. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>                                                                  
  233. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>                                                        
  234. <action application="set" data="callstart=2021-09-17 07:02:40"/>                                                                              
  235. <action application="set" data="hangup_after_bridge=true"/>                                                                                  
  236. <action application="set" data="continue_on_fail=TRUE"/>                                                                                      
  237. <action application="set" data="account_id=3"/>                                                                                              
  238. <action application="set" data="parent_id=0"/>                                                                                                
  239. <action application="set" data="entity_id=3"/>                                                                                                
  240. <action application="set" data="call_processed=internal"/>                                                                                    
  241. <action application="set" data="call_direction=inbound"/>                                                                                    
  242. <action application="set" data="accountname=default"/>                                                                                        
  243. <action application="set" data="origination_rates_did=ID:2029|CODE:^0103130012.*|DESTINATION:0103130012|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:171|ACCID:23"/>                                                            
  244. <action application="set" data="origination_rates=0"/>                                                                                        
  245. <action application="set" data="original_caller_id_name=0720692958"/>                                                                        
  246. <action application="set" data="effective_caller_id_name=27720692958"/>                                                                      
  247. <action application="set" data="receiver_accid=23"/>                                                                                          
  248. <action application="export" data="domain_name=Electronicconnect.nebular.co.za"/>                                                            
  249. <action application="export" data="sip_to_host=Electronicconnect.nebular.co.za"/>                                                            
  250. <action application="export" data="presence_data=x|||default(3673942894)|||^0103130012.* // 0103130012 // 0.00000||||||DID|||41.160.32.115"/>
  251. <action application="export" data="call_type=11"/>                                                                                            
  252. </condition>                                                                                                                                  
  253. </extension>                                                                                                                                  
  254. </context>                                                                                                                                    
  255. </section>                                                                                                                                    
  256. </document>                                                                                                                                  
  257. 2021-09-17 09:02:40.523228 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7f98780ffd80 released.
  258. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  259. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/Time Match (PASS) [testinextrix] break=never
  260. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(office_status=open) INLINE
  261. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(office_status=open)
  262. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [office_status]=[open]
  263. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(extensions=0731898326#) INLINE
  264. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(extensions=0731898326#)
  265. span style="color: goldenrod; font-weight: bold;"> 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [extensions]=[0731898326#]
  266. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(no_answer_call_type=12) INLINE
  267. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(no_answer_call_type=12)
  268. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [no_answer_call_type]=[12]
  269. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  270. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Absolute Condition [testinextrix]
  271. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(timezone=Africa/Johannesburg) INLINE
  272. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(timezone=Africa/Johannesburg)
  273. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [timezone]=[Africa/Johannesburg]
  274. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/TimeMatch (FAIL) [testinextrix] break=never
  275. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  276. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Absolute Condition [testinextrix]
  277. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(timezone=Africa/Johannesburg) INLINE
  278. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(timezone=Africa/Johannesburg)
  279. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [timezone]=[Africa/Johannesburg]
  280. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/TimeMatch (FAIL) [testinextrix] break=never
  281. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->testinextrix] continue=true
  282. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Absolute Condition [testinextrix]
  283. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(timezone=Africa/Johannesburg) INLINE
  284. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(timezone=Africa/Johannesburg)
  285. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [timezone]=[Africa/Johannesburg]
  286. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Date/TimeMatch (FAIL) [testinextrix] break=never
  287. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->tod route, x0103130012] continue=false
  288. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Regex (FAIL) [tod route, x0103130012] destination_number(0103130012_open) =~ /^(\+?)?(0103130012)$/ break=on-false                                                                                                                    
  289. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->office is open] continue=false
  290. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Regex (PASS) [office is open] destination_number(0103130012_open) =~ /^(\+?)?(0103130012_open)$/ break=on-false                                                                                                                      
  291. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(domain_name=Electronicconnect.nebular.co.za)
  292. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(set_extensions=${extensions})
  293. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(no_answer_flag=true)
  294. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(no_answer_call_type=${no_answer_call_type})
  295. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(no_answer_number=${extensions})
  296. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action transfer(23 XML default)
  297. 2021-09-17 09:02:40.523228 [NOTICE] switch_core_session.c:2914 Execute set(domain_name=Electronicconnect.nebular.co.za)
  298. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(domain_name=Electronicconnect.nebular.co.za)
  299. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [domain_name]=[Electronicconnect.nebular.co.za]                                                                                                                                      
  300. 2021-09-17 09:02:40.523228 [NOTICE] switch_core_session.c:2914 Execute set(set_extensions=${extensions})
  301. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(set_extensions=0731898326#)
  302. span style="color: goldenrod; font-weight: bold;"> 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [set_extensions]=[0731898326#]
  303. span style="color: cornflowerblue; font-weight: bold;"> 2021-09-17 09:02:40.523228 [NOTICE] switch_core_session.c:2914 Execute set(no_answer_flag=true)
  304. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(no_answer_flag=true)
  305. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [no_answer_flag]=[true]
  306. 2021-09-17 09:02:40.523228 [NOTICE] switch_core_session.c:2914 Execute set(no_answer_call_type=${no_answer_call_type})
  307. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(no_answer_call_type=12)
  308. 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [no_answer_call_type]=[12]
  309. 2021-09-17 09:02:40.523228 [NOTICE] switch_core_session.c:2914 Execute set(no_answer_number=${extensions})
  310. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(no_answer_number=0731898326#)
  311. span style="color: goldenrod; font-weight: bold;"> 2021-09-17 09:02:40.523228 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [no_answer_number]=[0731898326#]
  312. span style="color: cornflowerblue; font-weight: bold;"> 2021-09-17 09:02:40.523228 [NOTICE] switch_core_session.c:2914 Execute transfer(23 XML default)
  313. EXECUTE sofia/default/0720692958@41.160.32.115:5060 transfer(23 XML default)
  314. 2021-09-17 09:02:40.523228 [DEBUG] switch_ivr.c:2165 (sofia/default/0720692958@41.160.32.115:5060) State Change CS_EXECUTE -> CS_ROUTING
  315. 2021-09-17 09:02:40.523228 [NOTICE] switch_ivr.c:2172 Transfer sofia/default/0720692958@41.160.32.115:5060 to XML[23@default]
  316. 2021-09-17 09:02:40.523228 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0720692958@41.160.32.115:5060) State EXECUTE going to sleep
  317. 2021-09-17 09:02:40.523228 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0720692958@41.160.32.115:5060) Running State Change CS_ROUTING (Cur 1 Tot 2132)                                                                                                                          
  318. 2021-09-17 09:02:40.523228 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0720692958@41.160.32.115:5060) State ROUTING
  319. 2021-09-17 09:02:40.523228 [DEBUG] mod_sofia.c:143 sofia/default/0720692958@41.160.32.115:5060 SOFIA ROUTING
  320. 2021-09-17 09:02:40.523228 [DEBUG] switch_core_state_machine.c:236 sofia/default/0720692958@41.160.32.115:5060 Standard ROUTING
  321. 2021-09-17 09:02:40.523228 [INFO] mod_dialplan_xml.c:637 Processing 0720692958 <0720692958>->23 in context default
  322. 2021-09-17 09:02:40.523228 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7f98780ffd80 Connected.
  323. 2021-09-17 09:02:40.523228 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')                                                                                  
  324. 2021-09-17 09:02:40.523228 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  325. 2021-09-17 09:02:40.543463 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] blind_flag: 0
  326. 2021-09-17 09:02:40.543463 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 23
  327. 2021-09-17 09:02:40.543463 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '23' limit 1                                                                                                        
  328. 2021-09-17 09:02:40.563221 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '23' AND status=0 limit 1                                                                                                              
  329. 2021-09-17 09:02:40.563221 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '23' and status=0 LIMIT 1                                                                        
  330. 2021-09-17 09:02:40.563221 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number  : 0720692958 / <null>
  331. 2021-09-17 09:02:40.563221 [DEBUG] switch_cpp.cpp:1365 [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 ="23" LIMIT 1                                                                                                    
  332. 2021-09-17 09:02:40.583222 [DEBUG] switch_cpp.cpp:1365 [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="23"  AND domains.domain="156.38.231.106" limit 1                                        
  333. 2021-09-17 09:02:40.583222 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : outbound
  334. 2021-09-17 09:02:40.583222 [INFO] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 3673942894]
  335. 2021-09-17 09:02:40.583222 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "3673942894" AND deleted = 0 limit 1                                                                                                                          
  336. 2021-09-17 09:02:40.603753 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^23.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 3 limit 1                                              
  337. 2021-09-17 09:02:40.603753 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="23" AND (accountid = 0 OR status = 1) LIMIT 1                                                                                                                        
  338. 2021-09-17 09:02:40.623219 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "23" AND deleted = 0 limit 1                                                                                                                                      
  339. 2021-09-17 09:02:40.623219 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^23.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 23 limit 1                                              
  340. 2021-09-17 09:02:40.643217 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Generated ringgroup_no_answer_forward:23
  341. 2021-09-17 09:02:40.643217 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 23 limit 1
  342. 2021-09-17 09:02:40.643217 [WARNING] switch_cpp.cpp:1365 [ASTPP] [user_domain] user_domainElectronicconnect.nebular.co.za
  343. 2021-09-17 09:02:40.643217 [INFO] switch_cpp.cpp:1365 [ASTPP] [PBX] call_type : 12
  344. 2021-09-17 09:02:40.643217 [WARNING] switch_cpp.cpp:1365 [ASTPP] Time-Codtion Pstn Call
  345. 2021-09-17 09:02:40.643217 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 23  and status = 0 limit 1                                                                                                                                      
  346. 2021-09-17 09:02:40.663916 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Generated XML:
  347. <?xml version="1.0" encoding="UTF-8" standalone="no"?>                                                                                        
  348. <document type="freeswitch/xml">                                                                                                              
  349. <section name="dialplan" description="ASTPP Dialplan">                                                                                        
  350. <context name="default">                                                                                                                      
  351. <extension name="23">                                                                                                                        
  352. <condition field="destination_number" expression="23">                                                                                        
  353. <action application="export" data="did_user_domain=156.38.231.106"/>                                                                          
  354. <action application="set" data="continue_on_fail=TRUE"/>                                                                                      
  355. <action application="set" data="no_answer_flag=false"/>                                                                                      
  356. <action application="set" data="did_calltype=12"/>                                                                                            
  357. <action application="set" data="did_extensions=0731898326#"/>                                                                                
  358. <action application="set" data="accountcode=386976"/>                                                                                        
  359. <action application="transfer" data="0731898326 XML default"/>                                                                                
  360. </condition>                                                                                                                                  
  361. </extension>                                                                                                                                  
  362. </context>                                                                                                                                    
  363. </section>                                                                                                                                    
  364. </document>                                                                                                                                  
  365. 2021-09-17 09:02:40.663916 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7f98780ffd80 released.
  366. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->23] continue=false
  367. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Regex (PASS) [23] destination_number(23) =~ /23/ break=on-false
  368. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action export(did_user_domain=156.38.231.106)
  369. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(continue_on_fail=TRUE)
  370. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(no_answer_flag=false)
  371. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(did_calltype=12)
  372. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(did_extensions=0731898326#)
  373. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(accountcode=386976)
  374. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action transfer(0731898326 XML default)
  375. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:286 (sofia/default/0720692958@41.160.32.115:5060) State Change CS_ROUTING -> CS_EXECUTE                                                                                                                                      
  376. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0720692958@41.160.32.115:5060) State ROUTING going to sleep
  377. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0720692958@41.160.32.115:5060) Running State Change CS_EXECUTE (Cur 1 Tot 2132)                                                                                                                          
  378. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0720692958@41.160.32.115:5060) State EXECUTE
  379. 2021-09-17 09:02:40.663916 [DEBUG] mod_sofia.c:198 sofia/default/0720692958@41.160.32.115:5060 SOFIA EXECUTE
  380. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:328 sofia/default/0720692958@41.160.32.115:5060 Standard EXECUTE
  381. EXECUTE sofia/default/0720692958@41.160.32.115:5060 export(did_user_domain=156.38.231.106)
  382. 2021-09-17 09:02:40.663916 [DEBUG] switch_channel.c:1296 EXPORT (export_vars) [did_user_domain]=[156.38.231.106]
  383. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(continue_on_fail=TRUE)
  384. 2021-09-17 09:02:40.663916 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [continue_on_fail]=[TRUE]
  385. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(no_answer_flag=false)
  386. 2021-09-17 09:02:40.663916 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [no_answer_flag]=[false]
  387. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(did_calltype=12)
  388. 2021-09-17 09:02:40.663916 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [did_calltype]=[12]
  389. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(did_extensions=0731898326#)
  390. span style="color: goldenrod; font-weight: bold;"> 2021-09-17 09:02:40.663916 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [did_extensions]=[0731898326#]
  391. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(accountcode=386976)
  392. 2021-09-17 09:02:40.663916 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [accountcode]=[386976]
  393. EXECUTE sofia/default/0720692958@41.160.32.115:5060 transfer(0731898326 XML default)
  394. 2021-09-17 09:02:40.663916 [DEBUG] switch_ivr.c:2165 (sofia/default/0720692958@41.160.32.115:5060) State Change CS_EXECUTE -> CS_ROUTING
  395. 2021-09-17 09:02:40.663916 [NOTICE] switch_ivr.c:2172 Transfer sofia/default/0720692958@41.160.32.115:5060 to XML[0731898326@default]
  396. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0720692958@41.160.32.115:5060) State EXECUTE going to sleep
  397. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0720692958@41.160.32.115:5060) Running State Change CS_ROUTING (Cur 1 Tot 2132)                                                                                                                          
  398. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0720692958@41.160.32.115:5060) State ROUTING
  399. 2021-09-17 09:02:40.663916 [DEBUG] mod_sofia.c:143 sofia/default/0720692958@41.160.32.115:5060 SOFIA ROUTING
  400. 2021-09-17 09:02:40.663916 [DEBUG] switch_core_state_machine.c:236 sofia/default/0720692958@41.160.32.115:5060 Standard ROUTING
  401. 2021-09-17 09:02:40.663916 [INFO] mod_dialplan_xml.c:637 Processing 0720692958 <0720692958>->0731898326 in context default
  402. 2021-09-17 09:02:40.663916 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7f98780ffd80 Connected.
  403. 2021-09-17 09:02:40.663916 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')                                                                                  
  404. 2021-09-17 09:02:40.683207 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  405. 2021-09-17 09:02:40.683207 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] blind_flag: 0
  406. 2021-09-17 09:02:40.683207 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 0731898326
  407. 2021-09-17 09:02:40.683207 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '0731898326' limit 1                                                                                                
  408. 2021-09-17 09:02:40.703212 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0731898326' AND status=0 limit 1                                                                                                      
  409. 2021-09-17 09:02:40.703212 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '0731898326' and status=0 LIMIT 1                                                                
  410. 2021-09-17 09:02:40.723806 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number  : 0720692958 / <null>
  411. 2021-09-17 09:02:40.723806 [DEBUG] switch_cpp.cpp:1365 [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 ="0731898326" LIMIT 1                                                                                            
  412. 2021-09-17 09:02:40.723806 [DEBUG] switch_cpp.cpp:1365 [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="0731898326"  AND domains.domain="156.38.231.106" limit 1                                
  413. 2021-09-17 09:02:40.723806 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : outbound
  414. 2021-09-17 09:02:40.723806 [INFO] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 386976]
  415. 2021-09-17 09:02:40.723806 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "386976" AND deleted = 0 limit 1                                                                                                                              
  416. 2021-09-17 09:02:40.744884 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0731898326.*' OR blocked_patterns = '^073189832.*' OR blocked_patterns = '^07318983.*' OR blocked_patterns = '^0731898.*' OR blocked_patterns = '^073189.*' OR blocked_patterns = '^07318.*' OR blocked_patterns = '^0731.*' OR blocked_patterns = '^073.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 23 limit 1                                                      
  417. 2021-09-17 09:02:40.744884 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="0731898326" AND (accountid = 0 OR status = 1) LIMIT 1                                                                                                                
  418. 2021-09-17 09:02:40.764101 [NOTICE] switch_cpp.cpp:1365 [ASTPP] Localization Id: 3
  419. 2021-09-17 09:02:40.764101 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 3 AND status=0 limit 1                                                        
  420. 2021-09-17 09:02:40.764101 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"27/0,00/99".....0731898326
  421. 2021-09-17 09:02:40.764101 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"27/0,00/99".....0731898326
  422. 2021-09-17 09:02:40.764101 [DEBUG] switch_cpp.cpp:1365 [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 = '^0731898326.*' OR patterns = '^073189832.*' OR patterns = '^07318983.*' OR patterns = '^0731898.*' OR patterns = '^073189.*' OR patterns = '^07318.*' OR patterns = '^0731.*' OR patterns = '^073.*' OR patterns = '^07.*' OR patterns = '^0.*' OR patterns ='--') AND accountid = 23 ORDER BY LENGTH(PKGPTR.patterns) DESC                                                                                                                                      
  423. 2021-09-17 09:02:40.783932 [DEBUG] switch_cpp.cpp:1365 [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 ="0731898326" AND A.accountid = '23' limit 1                              
  424. 2021-09-17 09:02:40.783932 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 0731898326
  425. 2021-09-17 09:02:40.783932 [DEBUG] switch_cpp.cpp:1365 [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 ="0731898326" LIMIT 1                                                                                            
  426. 2021-09-17 09:02:40.803211 [DEBUG] switch_cpp.cpp:1365 [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="0731898326"  AND domains.domain="156.38.231.106" limit 1                                
  427. 2021-09-17 09:02:40.803211 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] New Call Direction : outbound
  428. 2021-09-17 09:02:40.803211 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '0731898326' OR number = '073189832' OR number = '07318983' OR number = '0731898' OR number = '073189' OR number = '07318' OR number = '0731' OR number = '073' OR number = '07' OR number = '0' OR number ='--') OR (number = '0731898326*' OR number = '073189832*' OR number = '07318983*' OR number = '0731898*' OR number = '073189*' OR number = '07318*' OR number = '0731*' OR number = '073*' OR number = '07*' OR number = '0*' OR number ='--') OR (number = '<null>' OR number = '<null' OR number = '<nul' OR number = '<nu' OR number = '<n' OR number = '<' OR number ='--') OR (number = '<null>*' OR number = '<null*' OR number = '<nul*' OR number = '<nu*' OR number = '<n*' OR number = '<*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC          
  429. 2021-09-17 09:02:40.823210 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Call Barring Status : -1
  430. 2021-09-17 09:02:40.823210 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '0731898326' OR routing_prefix = '073189832' OR routing_prefix = '07318983' OR routing_prefix = '0731898' OR routing_prefix = '073189' OR routing_prefix = '07318' OR routing_prefix = '0731' OR routing_prefix = '073' OR routing_prefix = '07' OR routing_prefix = '0' OR routing_prefix ='--') AND status = 0 and reseller_id = 13 limit 1                                                    
  431. 2021-09-17 09:02:40.823210 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Get Destination Number (0731898326)!!!!
  432. 2021-09-17 09:02:40.823210 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Ported Number :27731898326
  433. 2021-09-17 09:02:40.823210 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] Query :SELECT rnoroute FROM ported_number WHERE dnfrom ='27731898326' limit 1                                                                                                                                
  434. 2021-09-17 09:02:40.843225 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [PORTED_NUMBER] After Append Ported Number : (0731898326)!!!!
  435. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Account Information ===================
  436. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 23
  437. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 386976
  438. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 805.8774
  439. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  440. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 17
  441. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] CID Pool : 0
  442. 2021-09-17 09:02:40.863296 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================================================
  443. 2021-09-17 09:02:40.863296 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 17 AND status = 0                                                                                                                                            
  444. 2021-09-17 09:02:40.863296 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :outbound
  445. 2021-09-17 09:02:40.863296 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 17 AND status = 0                                                                                                                                            
  446. 2021-09-17 09:02:40.863296 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^0731898326.*' OR pattern = '^073189832.*' OR pattern = '^07318983.*' OR pattern = '^0731898.*' OR pattern = '^073189.*' OR pattern = '^07318.*' OR pattern = '^0731.*' OR pattern = '^073.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 17 OR accountid=23)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1                      
  447. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP]  Call Direction : outbound
  448. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information ===================
  449. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 172625
  450. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
  451. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0
  452. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.49000
  453. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : D083-MTN
  454. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 0
  455. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 23
  456. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0
  457. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type:
  458. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================
  459. 2021-09-17 09:02:40.883244 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your805.8774 balance Accountid 23 !!!
  460. 2021-09-17 09:02:40.883244 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  461. 2021-09-17 09:02:40.883244 [NOTICE] switch_cpp.cpp:1365 [ASTPP] FINDING LIMIT FOR RESELLER: 13
  462. 2021-09-17 09:02:40.883244 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "13" AND deleted = 0 limit 1                                                                                                                                      
  463. 2021-09-17 09:02:40.883244 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0731898326.*' OR blocked_patterns = '^073189832.*' OR blocked_patterns = '^07318983.*' OR blocked_patterns = '^0731898.*' OR blocked_patterns = '^073189.*' OR blocked_patterns = '^07318.*' OR blocked_patterns = '^0731.*' OR blocked_patterns = '^073.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 13 limit 1                                                      
  464. 2021-09-17 09:02:40.903229 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Reseller Information ===================
  465. 2021-09-17 09:02:40.903229 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 13
  466. 2021-09-17 09:02:40.903229 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 778509
  467. 2021-09-17 09:02:40.903229 [INFO] switch_cpp.cpp:1365 [ASTPP] Balance : 2223.99
  468. 2021-09-17 09:02:40.903229 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  469. 2021-09-17 09:02:40.903229 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 21
  470. 2021-09-17 09:02:40.903229 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 21 AND status = 0                                                                                                                                            
  471. 2021-09-17 09:02:40.903229 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] call_direction :outbound
  472. 2021-09-17 09:02:40.903229 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 21 AND status = 0                                                                                                                                            
  473. 2021-09-17 09:02:40.925295 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^0731898326.*' OR pattern = '^073189832.*' OR pattern = '^07318983.*' OR pattern = '^0731898.*' OR pattern = '^073189.*' OR pattern = '^07318.*' OR pattern = '^0731.*' OR pattern = '^073.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 21 OR accountid=13)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1                      
  474. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP]  Call Direction : outbound
  475. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information ===================
  476. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 271833
  477. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
  478. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 0
  479. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.24960
  480. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Comment : D083-MTN
  481. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Country Id : 0
  482. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 13
  483. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0
  484. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type:
  485. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================
  486. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Your2223.99 balance Accountid 13 !!!
  487. 2021-09-17 09:02:40.925295 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  488. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Reseller xml_user_rates : ID:172625|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.49000|INC:1|INITIALBLOCK:1|RATEGROUP:17|MARKUP:0|CI:0|ACCID:23||ID:271833|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.24960|INC:1|INITIALBLOCK:1|RATEGROUP:21|MARKUP:0|CI:0|ACCID:13                      
  489. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================================================
  490. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Lossless Routing Status : 1
  491. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Max Length Duration : 100 minutes
  492. 2021-09-17 09:02:40.925295 [INFO] switch_cpp.cpp:1365 [ASTPP] [DIALPLAN] User Rate ID : 172625
  493. 2021-09-17 09:02:40.925295 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id        :0
  494. 2021-09-17 09:02:40.925295 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=21 ORDER by id asc                                                                                                    
  495. 2021-09-17 09:02:40.943277 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,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 = '^0731898326.*' OR pattern = '^073189832.*' OR pattern = '^07318983.*' OR pattern = '^0731898.*' OR pattern = '^073189.*' OR pattern = '^07318.*' OR pattern = '^0731.*' OR pattern = '^073.*' OR pattern = '^07.*' OR pattern = '^0.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (5,7) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC      
  496. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Termination Rates Information ===================
  497. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 3
  498. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Code : ^0.*
  499. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Destination : South Africa
  500. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
  501. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Free Seconds : 0
  502. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Prefix : ^0.*
  503. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Strip :
  504. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Prepend :
  505. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Carrier id : 5
  506. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] carrier_name : liquid_primary
  507. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] dialplan_variable :
  508. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Failover gateway :
  509. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Vendor id : 3
  510. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Max channels : 0
  511. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk Name : Liquid
  512. 2021-09-17 09:02:40.943277 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================END OF TERMINATION RATES=======================
  513. 2021-09-17 09:02:40.943277 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 23 AND status=0 LIMIT 1                                                    
  514. 2021-09-17 09:02:40.963685 [INFO] switch_cpp.cpp:1365 [ASTPP]  Maxlength : 100
  515. 2021-09-17 09:02:40.963685 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  516. 2021-09-17 09:02:40.963685 [INFO] switch_cpp.cpp:1365 [ASTPP] [XML] Customer Recording Flag : 1
  517. 2021-09-17 09:02:40.963685 [INFO] switch_cpp.cpp:1365 [ASTPP] [PBX] call_direction : outbound
  518. 2021-09-17 09:02:40.963685 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 21 AND status = 0                                                                                                                                            
  519. 2021-09-17 09:02:40.963685 [DEBUG] switch_cpp.cpp:1365 [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 = 5) AND status=0 limit 1                                  
  520. 2021-09-17 09:02:40.983217 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCALIZATION] Query :"+27/0".....0731898326
  521. 2021-09-17 09:02:40.983217 [DEBUG] switch_cpp.cpp:1365 [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                                
  522. 2021-09-17 09:02:40.983217 [DEBUG] switch_cpp.cpp:1365 [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 ="0103130012" LIMIT 1                                                                                            
  523. 2021-09-17 09:02:41.003217 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Generated XML:
  524. <?xml version="1.0" encoding="UTF-8" standalone="no"?>                                                                                        
  525. <document type="freeswitch/xml">                                                                                                              
  526. <section name="dialplan" description="ASTPP Dialplan">                                                                                        
  527. <context name="default">                                                                                                                      
  528. <extension name="0731898326">                                                                                                                
  529. <condition field="destination_number" expression="0731898326">                                                                                
  530. <action application="set" data="effective_destination_number=0731898326"/>                                                                    
  531. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>                                                                  
  532. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>                                                        
  533. <action application="set" data="callstart=2021-09-17 07:02:40"/>                                                                              
  534. <action application="set" data="hangup_after_bridge=true"/>                                                                                  
  535. <action application="set" data="continue_on_fail=TRUE"/>                                                                                      
  536. <action application="set" data="account_id=23"/>                                                                                              
  537. <action application="set" data="parent_id=13"/>                                                                                              
  538. <action application="set" data="entity_id=0"/>                                                                                                
  539. <action application="set" data="call_processed=internal"/>                                                                                    
  540. <action application="set" data="call_direction=outbound"/>                                                                                    
  541. <action application="set" data="accountname=default"/>                                                                                        
  542. <action application="set" data="origination_rates=ID:172625|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.49000|INC:1|INITIALBLOCK:1|RATEGROUP:17|MARKUP:0|CI:0|ACCID:23||ID:271833|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.24960|INC:1|INITIALBLOCK:1|RATEGROUP:21|MARKUP:0|CI:0|ACCID:13"/>                                                        
  543. <action application="set" data="original_caller_id_name=0720692958"/>                                                                        
  544. <action application="limit" data="db 386976 user_386976 5 "/>                                                                                
  545. <action application="limit" data="db 778509 user_778509 10 "/>                                                                                
  546. <action application="set" data="effective_caller_id_name=0720692958"/>                                                                        
  547. <action application="set" data="calltype=STANDARD"/>                                                                                          
  548. <action application="set" data="termination_rates=ID:3|CODE:^0.*|DESTINATION:South Africa|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3"/>                                                                                                  
  549. <action application="set" data="trunk_id=5"/>                                                                                                
  550. <action application="set" data="provider_id=3"/>                                                                                              
  551. <action application="set" data="rate_flag=0"/>                                                                                                
  552. <action application="set" data="force_trunk_flag=172625"/>                                                                                    
  553. <action application="export" data="presence_data=trunk_id=5"/>                                                                                
  554. <action application="set" data="intcall=0"/>                                                                                                  
  555. <action application="export" data="presence_data=x//13|||Electronic(386976)|||^073.* // D083-MTN // 0.49000 // trunk_id=0|||Liquid // ^0.* // South Africa // 0.00000 // trunk_id=5|||STD|||41.160.32.115|||0.24960 // ^073.* // D083-MTN"/>                                                
  556. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA:G729:PCMU]sofia/gateway/liquid_primary/0731898326;fs_path=sip:156.38.231.106:5060"/>                                                                                                                        
  557. </condition>                                                                                                                                  
  558. </extension>                                                                                                                                  
  559. </context>                                                                                                                                    
  560. </section>                                                                                                                                    
  561. </document>                                                                                                                                  
  562. 2021-09-17 09:02:41.003217 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7f98780ffd80 released.
  563. Dialplan: sofia/default/0720692958@41.160.32.115:5060 parsing [default->0731898326] continue=false
  564. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Regex (PASS) [0731898326] destination_number(0731898326) =~ /0731898326/ break=on-false
  565. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(effective_destination_number=0731898326)
  566. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  567. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  568. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(callstart=2021-09-17 07:02:40)
  569. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(hangup_after_bridge=true)
  570. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(continue_on_fail=TRUE)
  571. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(account_id=23)
  572. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(parent_id=13)
  573. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(entity_id=0)
  574. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(call_processed=internal)
  575. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(call_direction=outbound)
  576. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(accountname=default)
  577. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(origination_rates=ID:172625|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.49000|INC:1|INITIALBLOCK:1|RATEGROUP:17|MARKUP:0|CI:0|ACCID:23||ID:271833|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.24960|INC:1|INITIALBLOCK:1|RATEGROUP:21|MARKUP:0|CI:0|ACCID:13)                          
  578. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(original_caller_id_name=0720692958)
  579. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action limit(db 386976 user_386976 5 )
  580. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action limit(db 778509 user_778509 10 )
  581. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(effective_caller_id_name=0720692958)
  582. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(calltype=STANDARD)
  583. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(termination_rates=ID:3|CODE:^0.*|DESTINATION:South Africa|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3)                                                                  
  584. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(trunk_id=5)
  585. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(provider_id=3)
  586. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(rate_flag=0)
  587. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(force_trunk_flag=172625)
  588. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action export(presence_data=trunk_id=5)
  589. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action set(intcall=0)
  590. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action export(presence_data=x//13|||Electronic(386976)|||^073.* // D083-MTN // 0.49000 // trunk_id=0|||Liquid // ^0.* // South Africa // 0.00000 // trunk_id=5|||STD|||41.160.32.115|||0.24960 // ^073.* // D083-MTN)                
  591. Dialplan: sofia/default/0720692958@41.160.32.115:5060 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA:G729:PCMU]sofia/gateway/liquid_primary/0731898326;fs_path=sip:156.38.231.106:5060)                                                                                        
  592. 2021-09-17 09:02:41.003217 [DEBUG] switch_core_state_machine.c:286 (sofia/default/0720692958@41.160.32.115:5060) State Change CS_ROUTING -> CS_EXECUTE                                                                                                                                      
  593. 2021-09-17 09:02:41.003217 [DEBUG] switch_core_state_machine.c:643 (sofia/default/0720692958@41.160.32.115:5060) State ROUTING going to sleep
  594. 2021-09-17 09:02:41.003217 [DEBUG] switch_core_state_machine.c:584 (sofia/default/0720692958@41.160.32.115:5060) Running State Change CS_EXECUTE (Cur 1 Tot 2132)                                                                                                                          
  595. 2021-09-17 09:02:41.003217 [DEBUG] switch_core_state_machine.c:650 (sofia/default/0720692958@41.160.32.115:5060) State EXECUTE
  596. 2021-09-17 09:02:41.003217 [DEBUG] mod_sofia.c:198 sofia/default/0720692958@41.160.32.115:5060 SOFIA EXECUTE
  597. 2021-09-17 09:02:41.003217 [DEBUG] switch_core_state_machine.c:328 sofia/default/0720692958@41.160.32.115:5060 Standard EXECUTE
  598. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(effective_destination_number=0731898326)
  599. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [effective_destination_number]=[0731898326]                                                                                                                                          
  600. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(bridge_pre_execute_bleg_app=sched_hangup)
  601. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [bridge_pre_execute_bleg_app]=[sched_hangup]                                                                                                                                          
  602. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  603. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]                                                                                                                                
  604. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(callstart=2021-09-17 07:02:40)
  605. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [callstart]=[2021-09-17 07:02:40]
  606. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(hangup_after_bridge=true)
  607. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [hangup_after_bridge]=[true]
  608. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(continue_on_fail=TRUE)
  609. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [continue_on_fail]=[TRUE]
  610. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(account_id=23)
  611. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [account_id]=[23]
  612. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(parent_id=13)
  613. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [parent_id]=[13]
  614. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(entity_id=0)
  615. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [entity_id]=[0]
  616. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(call_processed=internal)
  617. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [call_processed]=[internal]
  618. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(call_direction=outbound)
  619. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [call_direction]=[outbound]
  620. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(accountname=default)
  621. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [accountname]=[default]
  622. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(origination_rates=ID:172625|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.49000|INC:1|INITIALBLOCK:1|RATEGROUP:17|MARKUP:0|CI:0|ACCID:23||ID:271833|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.24960|INC:1|INITIALBLOCK:1|RATEGROUP:21|MARKUP:0|CI:0|ACCID:13)                                  
  623. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [origination_rates]=[ID:172625|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.49000|INC:1|INITIALBLOCK:1|RATEGROUP:17|MARKUP:0|CI:0|ACCID:23||ID:271833|CODE:^073.*|DESTINATION:D083-MTN|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.24960|INC:1|INITIALBLOCK:1|RATEGROUP:21|MARKUP:0|CI:0|ACCID:13]                                                                                                                                
  624. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(original_caller_id_name=0720692958)
  625. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [original_caller_id_name]=[0720692958]
  626. EXECUTE sofia/default/0720692958@41.160.32.115:5060 limit(db 386976 user_386976 5 )
  627. 2021-09-17 09:02:41.003217 [DEBUG] switch_limit.c:126 incr called: 386976_user_386976 max:5, interval:0
  628. 2021-09-17 09:02:41.003217 [DEBUG] mod_db.c:194 Usage for 386976_user_386976 is now 1/5
  629. EXECUTE sofia/default/0720692958@41.160.32.115:5060 limit(db 778509 user_778509 10 )
  630. 2021-09-17 09:02:41.003217 [DEBUG] switch_limit.c:126 incr called: 778509_user_778509 max:10, interval:0
  631. 2021-09-17 09:02:41.003217 [DEBUG] mod_db.c:194 Usage for 778509_user_778509 is now 1/10
  632. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(effective_caller_id_name=0720692958)
  633. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [effective_caller_id_name]=[0720692958]
  634. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(calltype=STANDARD)
  635. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [calltype]=[STANDARD]
  636. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(termination_rates=ID:3|CODE:^0.*|DESTINATION:South Africa|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3)                                                                            
  637. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [termination_rates]=[ID:3|CODE:^0.*|DESTINATION:South Africa|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00000|INC:1|INITIALBLOCK:1|TRUNK:5|PROVIDER:3]                          
  638. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(trunk_id=5)
  639. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [trunk_id]=[5]
  640. EXECUTE sofia/default/0720692958@41.160.32.115:5060 set(provider_id=3)
  641. 2021-09-17 09:02:41.003217 [DEBUG] mod_dptools.c:1548 SET sofia/default/0720692958@41.160.32.115:5060 [provider_id]=[3]
  642.  

Reply to "time condition"