From MOM not working, 1 Year ago, written in FreeSWITCH.
- view diff
Embed
  1. span style="color: green; font-weight: bold;"> 2023-04-26 08:15:58.208305 [INFO] mod_dialplan_xml.c:637 Processing 31855004076 <31855004076>->31307910414 in context default
  2. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  3. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  4. 2023-04-26 08:15:58.208305 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [xml_handler] Params:
  5. Event-Name: REQUEST_PARAMS
  6. Core-UUID: ea9d74c5-64c7-47f9-8036-72e9783891f2
  7. FreeSWITCH-Hostname: multitenant-1
  8. FreeSWITCH-Switchname: multitenant-1
  9. FreeSWITCH-IPv4: 185.249.40.236
  10. FreeSWITCH-IPv6: %3A%3A1
  11. Event-Date-Local: 2023-04-26%2008%3A15%3A58
  12. Event-Date-GMT: Wed,%2026%20Apr%202023%2006%3A15%3A58%20GMT
  13. Event-Date-Timestamp: 1682489758208305
  14. Event-Calling-File: mod_dialplan_xml.c
  15. Event-Calling-Function: dialplan_xml_locate
  16. Event-Calling-Line-Number: 608
  17. Event-Sequence: 52518887
  18. Channel-State: CS_ROUTING
  19. Channel-Call-State: RINGING
  20. Channel-State-Number: 2
  21. Channel-Name: sofia/default/31855004076%40185.249.40.253
  22. Unique-ID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  23. Call-Direction: inbound
  24. Presence-Call-Direction: inbound
  25. Channel-HIT-Dialplan: true
  26. Channel-Presence-ID: 31855004076%40185.249.40.253
  27. Channel-Call-UUID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  28. Answer-State: ringing
  29. Channel-Read-Codec-Name: PCMA
  30. Channel-Read-Codec-Rate: 8000
  31. Channel-Read-Codec-Bit-Rate: 64000
  32. Channel-Write-Codec-Name: PCMA
  33. Channel-Write-Codec-Rate: 8000
  34. Channel-Write-Codec-Bit-Rate: 64000
  35. Caller-Direction: inbound
  36. Caller-Logical-Direction: inbound
  37. Caller-Username: 31855004076
  38. Caller-Dialplan: XML
  39. Caller-Caller-ID-Name: 31855004076
  40. Caller-Caller-ID-Number: 31855004076
  41. Caller-Orig-Caller-ID-Name: 31855004076
  42. Caller-Orig-Caller-ID-Number: 31855004076
  43. Caller-Network-Addr: 185.249.40.253
  44. Caller-ANI: 31855004076
  45. Caller-Destination-Number: 31307910414
  46. Caller-Unique-ID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  47. Caller-Source: mod_sofia
  48. Caller-Context: default
  49. Caller-Channel-Name: sofia/default/31855004076%40185.249.40.253
  50. Caller-Profile-Index: 1
  51. Caller-Profile-Created-Time: 1682489758208305
  52. Caller-Channel-Created-Time: 1682489758208305
  53. Caller-Channel-Answered-Time: 0
  54. Caller-Channel-Progress-Time: 0
  55. Caller-Channel-Progress-Media-Time: 0
  56. Caller-Channel-Hangup-Time: 0
  57. Caller-Channel-Transfer-Time: 0
  58. Caller-Channel-Resurrect-Time: 0
  59. Caller-Channel-Bridged-Time: 0
  60. Caller-Channel-Last-Hold: 0
  61. Caller-Channel-Hold-Accum: 0
  62. Caller-Screen-Bit: true
  63. Caller-Privacy-Hide-Name: false
  64. Caller-Privacy-Hide-Number: false
  65. variable_direction: inbound
  66. variable_uuid: 7300696e-0f58-47f3-91c0-a52ccc32d979
  67. variable_session_id: 635757
  68. variable_sip_from_user: 31855004076
  69. variable_sip_from_uri: 31855004076%40185.249.40.253
  70. variable_sip_from_host: 185.249.40.253
  71. variable_video_media_flow: disabled
  72. variable_text_media_flow: disabled
  73. variable_channel_name: sofia/default/31855004076%40185.249.40.253
  74. variable_sip_call_id: 02165EC6D181400000AE893E%40UDP_5060.sbc1.controlsbc.com
  75. variable_sip_local_network_addr: 185.249.40.236
  76. variable_sip_network_ip: 185.249.40.253
  77. variable_sip_network_port: 5060
  78. variable_sip_invite_stamp: 1682489758208305
  79. variable_sip_received_ip: 185.249.40.253
  80. variable_sip_received_port: 5060
  81. variable_sip_via_protocol: udp
  82. variable_sip_authorized: true
  83. variable_sip_acl_authed_by: default
  84. variable_sip_from_user_stripped: 31855004076
  85. variable_sip_from_tag: EC4630303330333099C20501
  86. variable_sofia_profile_name: default
  87. variable_sofia_profile_url: sip%3Amod_sofia%40185.249.40.236%3A5060
  88. variable_recovery_profile_name: default
  89. variable_sip_P-Asserted-Identity: 31855004076
  90. variable_sip_cid_type: pid
  91. variable_sip_full_route: %3Csip%3A185.249.40.236%3A5060%3Blr%3Btransport%3Dudp%3E
  92. variable_sip_full_via: SIP/2.0/UDP%20185.249.40.253%3A5060%3Bbranch%3Dz9hG4bK714A7AA71839DCFCA8280A3778DADF8E%3Brport%3D5060
  93. variable_sip_from_display: 31855004076
  94. variable_sip_full_from: %2231855004076%22%20%3Csip%3A31855004076%40185.249.40.253%3E%3Btag%3DEC4630303330333099C20501
  95. variable_sip_full_to: %3Csip%3A31307910414%40185.249.40.236%3E
  96. variable_sip_allow: INVITE,%20ACK,%20OPTIONS,%20BYE,%20CANCEL,%20REGISTER,%20INFO,%20UPDATE,%20REFER,%20SUBSCRIBE,%20NOTIFY
  97. variable_sip_req_user: 31307910414
  98. variable_sip_req_port: 5060
  99. variable_sip_req_uri: 31307910414%40185.249.40.236%3A5060
  100. variable_sip_req_host: 185.249.40.236
  101. variable_sip_to_user: 31307910414
  102. variable_sip_to_uri: 31307910414%40185.249.40.236
  103. variable_sip_to_host: 185.249.40.236
  104. variable_sip_contact_user: 31855004076
  105. variable_sip_contact_port: 5060
  106. variable_sip_contact_uri: 31855004076%40185.249.40.253%3A5060
  107. variable_sip_contact_host: 185.249.40.253
  108. variable_sip_user_agent: TBSIP
  109. variable_sip_via_host: 185.249.40.253
  110. variable_sip_via_port: 5060
  111. variable_sip_via_rport: 5060
  112. variable_max_forwards: 68
  113. variable_presence_id: 31855004076%40185.249.40.253
  114. variable_sip_Privacy: none
  115. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%2016209504%201%20IN%20IP4%20185.249.40.253%0D%0As%3D-%0D%0Ac%3DIN%20IP4%20185.249.40.253%0D%0At%3D0%200%0D%0Am%3Daudio%2038366%20RTP/AVP%208%20101%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0A
  116. variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
  117. variable_rtp_use_codec_string: PCMA,PCMU,G722
  118. variable_remote_video_media_flow: inactive
  119. variable_remote_text_media_flow: inactive
  120. variable_remote_audio_media_flow: sendrecv
  121. variable_audio_media_flow: sendrecv
  122. variable_remote_media_ip: 185.249.40.253
  123. variable_remote_media_port: 38366
  124. variable_rtp_audio_recv_pt: 8
  125. variable_rtp_use_codec_name: PCMA
  126. variable_rtp_use_codec_rate: 8000
  127. variable_rtp_use_codec_ptime: 20
  128. variable_rtp_use_codec_channels: 1
  129. variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
  130. variable_read_codec: PCMA
  131. variable_original_read_codec: PCMA
  132. variable_read_rate: 8000
  133. variable_original_read_rate: 8000
  134. variable_write_codec: PCMA
  135. variable_write_rate: 8000
  136. variable_dtmf_type: rfc2833
  137. variable_endpoint_disposition: RECEIVED
  138. variable_call_uuid: 7300696e-0f58-47f3-91c0-a52ccc32d979
  139. Hunt-Direction: inbound
  140. Hunt-Logical-Direction: inbound
  141. Hunt-Username: 31855004076
  142. Hunt-Dialplan: XML
  143. Hunt-Caller-ID-Name: 31855004076
  144. Hunt-Caller-ID-Number: 31855004076
  145. Hunt-Orig-Caller-ID-Name: 31855004076
  146. Hunt-Orig-Caller-ID-Number: 31855004076
  147. Hunt-Network-Addr: 185.249.40.253
  148. Hunt-ANI: 31855004076
  149. Hunt-Destination-Number: 31307910414
  150. Hunt-Unique-ID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  151. Hunt-Source: mod_sofia
  152. Hunt-Context: default
  153. Hunt-Channel-Name: sofia/default/31855004076%40185.249.40.253
  154. Hunt-Profile-Index: 1
  155. Hunt-Profile-Created-Time: 1682489758208305
  156. Hunt-Channel-Created-Time: 1682489758208305
  157. Hunt-Channel-Answered-Time: 0
  158. Hunt-Channel-Progress-Time: 0
  159. Hunt-Channel-Progress-Media-Time: 0
  160. Hunt-Channel-Hangup-Time: 0
  161. Hunt-Channel-Transfer-Time: 0
  162. Hunt-Channel-Resurrect-Time: 0
  163. Hunt-Channel-Bridged-Time: 0
  164. Hunt-Channel-Last-Hold: 0
  165. Hunt-Channel-Hold-Accum: 0
  166. Hunt-Screen-Bit: true
  167. Hunt-Privacy-Hide-Name: false
  168. Hunt-Privacy-Hide-Number: false
  169.  
  170.  
  171. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_name:
  172. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_value:
  173. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] section: dialplan
  174. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] tag_name:
  175. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  176. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 31307910414
  177. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '31307910414' limit 1
  178. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '31307910414' AND status=0 limit 1
  179. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '31307910414' and status=0 LIMIT 1
  180. 2023-04-26 08:15:58.208305 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FAXER] Custom Caller ID
  181. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 31855004076 / 31855004076
  182. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31307910414" LIMIT 1
  183. 2023-04-26 08:15:58.208305 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : inbound
  184. 2023-04-26 08:15:58.208305 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("185.249.40.253") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "31307910414"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  185. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 740489]
  186. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "740489" AND deleted = 0 limit 1
  187. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="31307910414" AND (accountid = 0 OR status = 1) LIMIT 1
  188. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  189. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 759
  190. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^31307910414.*' OR patterns = '^3130791041.*' OR patterns = '^313079104.*' OR patterns = '^31307910.*' OR patterns = '^3130791.*' OR patterns = '^313079.*' OR patterns = '^31307.*' OR patterns = '^3130.*' OR patterns = '^313.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 759 ORDER BY LENGTH(PKGPTR.patterns) DESC
  191. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="31307910414" AND A.accountid = '231' limit 1
  192. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31307910414
  193. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31307910414" LIMIT 1
  194. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call Direction : inbound
  195. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31307910414' OR number = '3130791041' OR number = '313079104' OR number = '31307910' OR number = '3130791' OR number = '313079' OR number = '31307' OR number = '3130' OR number = '313' OR number = '31' OR number = '3' OR number ='--') OR (number = '31307910414*' OR number = '3130791041*' OR number = '313079104*' OR number = '31307910*' OR number = '3130791*' OR number = '313079*' OR number = '31307*' OR number = '3130*' OR number = '313*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  196. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
  197. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31307910414' OR routing_prefix = '3130791041' OR routing_prefix = '313079104' OR routing_prefix = '31307910' OR routing_prefix = '3130791' OR routing_prefix = '313079' OR routing_prefix = '31307' OR routing_prefix = '3130' OR routing_prefix = '313' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  198. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
  199. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 231
  200. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 740489
  201. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 10000
  202. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  203. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
  204. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  205. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  206. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  207. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :inbound
  208. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31307910414" LIMIT 1
  209. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP]  Call Direction : inbound
  210. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
  211. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 691
  212. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
  213. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 0
  214. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.00000
  215. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Comment : 31307910414
  216. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 136
  217. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 231
  218. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
  219. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your10000 balance Accountid 231 !!!
  220. 2023-04-26 08:15:58.228308 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  221. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max Length Duration : 100 minutes
  222. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] INB_FREE:TRUE
  223. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] free_inbound:1
  224. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 231 AND status=0 LIMIT 1
  225. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "759" AND deleted = 0 limit 1
  226. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Actual CustomerInfo XML:231
  227. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Userinfo XML:231
  228. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Actual CustomerInfo XML : 231
  229. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 759 limit 1
  230. 2023-04-26 08:15:58.228308 [WARNING] switch_cpp.cpp:1447 [ASTPP] [user_domain] User Domain : 262876.yoursipcloud.com
  231. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP]  Maxlength : 100
  232. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  233. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [XML] Customer Recording Flag : 1
  234. 2023-04-26 08:15:58.228308 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] Call Direction : inbound
  235. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing  WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "0681405345" AND accounts.status = 0
  236. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 759 limit 1
  237. 2023-04-26 08:15:58.228308 [WARNING] switch_cpp.cpp:1447 [ASTPP] [XML] User Domain : 262876.yoursipcloud.com
  238. 2023-04-26 08:15:58.228308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 759  and status = 0 limit 1
  239. 2023-04-26 08:15:58.248309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [XML] Custom Function Name :: custom_inbound_4
  240. 2023-04-26 08:15:58.248309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  241. <document type="freeswitch/xml">
  242. <section name="dialplan" description="ASTPP Dialplan">
  243. <context name="default">
  244. <extension name="31307910414">
  245. <condition field="destination_number" expression="31307910414">
  246. <action application="set" data="effective_destination_number=31307910414"/>
  247. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  248. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  249. <action application="set" data="callstart=2023-04-26 06:15:58"/>
  250. <action application="set" data="hangup_after_bridge=true"/>
  251. <action application="set" data="continue_on_fail=TRUE"/>
  252. <action application="set" data="account_id=231"/>
  253. <action application="set" data="parent_id=0"/>
  254. <action application="set" data="entity_id=3"/>
  255. <action application="set" data="call_processed=internal"/>
  256. <action application="set" data="call_direction=inbound"/>
  257. <action application="set" data="accountname=SBC1.."/>
  258. <action application="set" data="filename1=astpp.pbx.lua"/>
  259. <action application="set" data="origination_rates_did=ID:691|CODE:^31307910414.*|DESTINATION:31307910414|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:759"/>
  260. <action application="set" data="origination_rates=0"/>
  261. <action application="set" data="original_caller_id_name=31855004076"/>
  262. <action application="set" data="original_caller_id_number=31855004076"/>
  263. <action application="set" data="effective_caller_id_name=31855004076"/>
  264. <action application="set" data="effective_caller_id_number=31855004076"/>
  265. <action application="set" data="receiver_accid=759"/>
  266. <action application="export" data="domain_name=262876.yoursipcloud.com"/>
  267. <action application="export" data="sip_to_host=262876.yoursipcloud.com"/>
  268. <action application="export" data="presence_data=x|||Ingmar(262876)|||||||||DID|||185.249.40.253"/>
  269. <action application="export" data="call_type=4"/>
  270. <action application="set" data="calltype=STANDARD"/>
  271. <action application="set" data="accountcode=262876"/>
  272. <action application="set" data="caller_did_account_id=231"/>
  273. <action application="set" data="did_number=31307910414"/>
  274. <action application="set" data="did_init_inc=0"/>
  275. <action application="set" data="did_inc=0"/>
  276. <action application="set" data="did_cost=0.00000"/>
  277. <action application="set" data="did_connectcost=0.00000"/>
  278. <action application="set" data="origination_rates_did=0"/>
  279. <action application="transfer" data="0681405345 XML default"/>
  280. </condition>
  281. </extension>
  282. </context>
  283. </section>
  284. </document>
  285. Dialplan: sofia/default/31855004076@185.249.40.253 parsing [default->31307910414] continue=false
  286. Dialplan: sofia/default/31855004076@185.249.40.253 Regex (PASS) [31307910414] destination_number(31307910414) =~ /31307910414/ break=on-false
  287. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_destination_number=31307910414)
  288. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  289. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  290. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(callstart=2023-04-26 06:15:58)
  291. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(hangup_after_bridge=true)
  292. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(continue_on_fail=TRUE)
  293. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(account_id=231)
  294. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(parent_id=0)
  295. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(entity_id=3)
  296. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_processed=internal)
  297. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_direction=inbound)
  298. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(accountname=SBC1..)
  299. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(filename1=astpp.pbx.lua)
  300. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates_did=ID:691|CODE:^31307910414.*|DESTINATION:31307910414|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:759)
  301. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates=0)
  302. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_name=31855004076)
  303. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_number=31855004076)
  304. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_name=31855004076)
  305. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_number=31855004076)
  306. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(receiver_accid=759)
  307. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(domain_name=262876.yoursipcloud.com)
  308. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(sip_to_host=262876.yoursipcloud.com)
  309. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=x|||Ingmar(262876)|||||||||DID|||185.249.40.253)
  310. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(call_type=4)
  311. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(calltype=STANDARD)
  312. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(accountcode=262876)
  313. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(caller_did_account_id=231)
  314. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(did_number=31307910414)
  315. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(did_init_inc=0)
  316. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(did_inc=0)
  317. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(did_cost=0.00000)
  318. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(did_connectcost=0.00000)
  319. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates_did=0)
  320. Dialplan: sofia/default/31855004076@185.249.40.253 Action transfer(0681405345 XML default)
  321. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:287 (sofia/default/31855004076@185.249.40.253) State Change CS_ROUTING -> CS_EXECUTE
  322. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING going to sleep
  323. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_EXECUTE (Cur 3 Tot 635757)
  324. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:651 (sofia/default/31855004076@185.249.40.253) State EXECUTE
  325. 2023-04-26 08:15:58.248309 [DEBUG] mod_sofia.c:209 sofia/default/31855004076@185.249.40.253 SOFIA EXECUTE
  326. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:329 sofia/default/31855004076@185.249.40.253 Standard EXECUTE
  327. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_destination_number=31307910414)
  328. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_destination_number]=[31307910414]
  329. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_app=sched_hangup)
  330. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_app]=[sched_hangup]
  331. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  332. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  333. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(callstart=2023-04-26 06:15:58)
  334. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [callstart]=[2023-04-26 06:15:58]
  335. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(hangup_after_bridge=true)
  336. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [hangup_after_bridge]=[true]
  337. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(continue_on_fail=TRUE)
  338. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [continue_on_fail]=[TRUE]
  339. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(account_id=231)
  340. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [account_id]=[231]
  341. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(parent_id=0)
  342. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [parent_id]=[0]
  343. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(entity_id=3)
  344. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [entity_id]=[3]
  345. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_processed=internal)
  346. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_processed]=[internal]
  347. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_direction=inbound)
  348. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_direction]=[inbound]
  349. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(accountname=SBC1..)
  350. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [accountname]=[SBC1..]
  351. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(filename1=astpp.pbx.lua)
  352. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [filename1]=[astpp.pbx.lua]
  353. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates_did=ID:691|CODE:^31307910414.*|DESTINATION:31307910414|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:759)
  354. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates_did]=[ID:691|CODE:^31307910414.*|DESTINATION:31307910414|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:759]
  355. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates=0)
  356. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates]=[0]
  357. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_name=31855004076)
  358. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_name]=[31855004076]
  359. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_number=31855004076)
  360. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_number]=[31855004076]
  361. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_name=31855004076)
  362. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_name]=[31855004076]
  363. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_number=31855004076)
  364. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_number]=[31855004076]
  365. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(receiver_accid=759)
  366. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [receiver_accid]=[759]
  367. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(domain_name=262876.yoursipcloud.com)
  368. 2023-04-26 08:15:58.248309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [domain_name]=[262876.yoursipcloud.com]
  369. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(sip_to_host=262876.yoursipcloud.com)
  370. 2023-04-26 08:15:58.248309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [sip_to_host]=[262876.yoursipcloud.com]
  371. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=x|||Ingmar(262876)|||||||||DID|||185.249.40.253)
  372. 2023-04-26 08:15:58.248309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||Ingmar(262876)|||||||||DID|||185.249.40.253]
  373. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(call_type=4)
  374. 2023-04-26 08:15:58.248309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [call_type]=[4]
  375. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(calltype=STANDARD)
  376. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [calltype]=[STANDARD]
  377. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(accountcode=262876)
  378. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [accountcode]=[262876]
  379. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(caller_did_account_id=231)
  380. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [caller_did_account_id]=[231]
  381. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(did_number=31307910414)
  382. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [did_number]=[31307910414]
  383. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(did_init_inc=0)
  384. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [did_init_inc]=[0]
  385. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(did_inc=0)
  386. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [did_inc]=[0]
  387. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(did_cost=0.00000)
  388. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [did_cost]=[0.00000]
  389. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(did_connectcost=0.00000)
  390. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [did_connectcost]=[0.00000]
  391. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates_did=0)
  392. 2023-04-26 08:15:58.248309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates_did]=[0]
  393. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 transfer(0681405345 XML default)
  394. 2023-04-26 08:15:58.248309 [DEBUG] switch_ivr.c:2243 (sofia/default/31855004076@185.249.40.253) State Change CS_EXECUTE -> CS_ROUTING
  395. 2023-04-26 08:15:58.248309 [NOTICE] switch_ivr.c:2250 Transfer sofia/default/31855004076@185.249.40.253 to XML[0681405345@default]
  396. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:651 (sofia/default/31855004076@185.249.40.253) State EXECUTE going to sleep
  397. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_ROUTING (Cur 3 Tot 635757)
  398. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING
  399. 2023-04-26 08:15:58.248309 [DEBUG] mod_sofia.c:145 Call appears to be already acknowledged
  400. 2023-04-26 08:15:58.248309 [DEBUG] mod_sofia.c:154 sofia/default/31855004076@185.249.40.253 SOFIA ROUTING
  401. 2023-04-26 08:15:58.248309 [DEBUG] switch_core_state_machine.c:236 sofia/default/31855004076@185.249.40.253 Standard ROUTING
  402. 2023-04-26 08:15:58.248309 [INFO] mod_dialplan_xml.c:637 Processing 31855004076 <31855004076>->0681405345 in context default
  403. 2023-04-26 08:15:58.248309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  404. 2023-04-26 08:15:58.248309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  405. 2023-04-26 08:15:58.268308 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [xml_handler] Params:
  406. Event-Name: REQUEST_PARAMS
  407. Core-UUID: ea9d74c5-64c7-47f9-8036-72e9783891f2
  408. FreeSWITCH-Hostname: multitenant-1
  409. FreeSWITCH-Switchname: multitenant-1
  410. FreeSWITCH-IPv4: 185.249.40.236
  411. FreeSWITCH-IPv6: %3A%3A1
  412. Event-Date-Local: 2023-04-26%2008%3A15%3A58
  413. Event-Date-GMT: Wed,%2026%20Apr%202023%2006%3A15%3A58%20GMT
  414. Event-Date-Timestamp: 1682489758248309
  415. Event-Calling-File: mod_dialplan_xml.c
  416. Event-Calling-Function: dialplan_xml_locate
  417. Event-Calling-Line-Number: 608
  418. Event-Sequence: 52518959
  419. Channel-State: CS_ROUTING
  420. Channel-Call-State: RINGING
  421. Channel-State-Number: 2
  422. Channel-Name: sofia/default/31855004076%40185.249.40.253
  423. Unique-ID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  424. Call-Direction: inbound
  425. Presence-Call-Direction: inbound
  426. Channel-HIT-Dialplan: true
  427. Channel-Presence-ID: 31855004076%40185.249.40.253
  428. Channel-Presence-Data: x%7C%7C%7CIngmar(262876)%7C%7C%7C%7C%7C%7C%7C%7C%7CDID%7C%7C%7C185.249.40.253
  429. Channel-Call-UUID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  430. Answer-State: ringing
  431. Channel-Read-Codec-Name: PCMA
  432. Channel-Read-Codec-Rate: 8000
  433. Channel-Read-Codec-Bit-Rate: 64000
  434. Channel-Write-Codec-Name: PCMA
  435. Channel-Write-Codec-Rate: 8000
  436. Channel-Write-Codec-Bit-Rate: 64000
  437. Caller-Direction: inbound
  438. Caller-Logical-Direction: inbound
  439. Caller-Username: 31855004076
  440. Caller-Dialplan: XML
  441. Caller-Caller-ID-Name: 31855004076
  442. Caller-Caller-ID-Number: 31855004076
  443. Caller-Orig-Caller-ID-Name: 31855004076
  444. Caller-Orig-Caller-ID-Number: 31855004076
  445. Caller-Network-Addr: 185.249.40.253
  446. Caller-ANI: 31855004076
  447. Caller-Destination-Number: 0681405345
  448. Caller-Unique-ID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  449. Caller-Source: mod_sofia
  450. Caller-Transfer-Source: 1682489758%3A38c0252b-af37-468c-bdea-5931a0a39969%3Abl_xfer%3A0681405345/default/XML
  451. Caller-Context: default
  452. Caller-RDNIS: 31307910414
  453. Caller-Channel-Name: sofia/default/31855004076%40185.249.40.253
  454. Caller-Profile-Index: 2
  455. Caller-Profile-Created-Time: 1682489758248309
  456. Caller-Channel-Created-Time: 1682489758208305
  457. Caller-Channel-Answered-Time: 0
  458. Caller-Channel-Progress-Time: 0
  459. Caller-Channel-Progress-Media-Time: 0
  460. Caller-Channel-Hangup-Time: 0
  461. Caller-Channel-Transfer-Time: 0
  462. Caller-Channel-Resurrect-Time: 0
  463. Caller-Channel-Bridged-Time: 0
  464. Caller-Channel-Last-Hold: 0
  465. Caller-Channel-Hold-Accum: 0
  466. Caller-Screen-Bit: true
  467. Caller-Privacy-Hide-Name: false
  468. Caller-Privacy-Hide-Number: false
  469. variable_direction: inbound
  470. variable_uuid: 7300696e-0f58-47f3-91c0-a52ccc32d979
  471. variable_session_id: 635757
  472. variable_sip_from_user: 31855004076
  473. variable_sip_from_uri: 31855004076%40185.249.40.253
  474. variable_sip_from_host: 185.249.40.253
  475. variable_video_media_flow: disabled
  476. variable_text_media_flow: disabled
  477. variable_channel_name: sofia/default/31855004076%40185.249.40.253
  478. variable_sip_call_id: 02165EC6D181400000AE893E%40UDP_5060.sbc1.controlsbc.com
  479. variable_sip_local_network_addr: 185.249.40.236
  480. variable_sip_network_ip: 185.249.40.253
  481. variable_sip_network_port: 5060
  482. variable_sip_invite_stamp: 1682489758208305
  483. variable_sip_received_ip: 185.249.40.253
  484. variable_sip_received_port: 5060
  485. variable_sip_via_protocol: udp
  486. variable_sip_authorized: true
  487. variable_sip_acl_authed_by: default
  488. variable_sip_from_user_stripped: 31855004076
  489. variable_sip_from_tag: EC4630303330333099C20501
  490. variable_sofia_profile_name: default
  491. variable_sofia_profile_url: sip%3Amod_sofia%40185.249.40.236%3A5060
  492. variable_recovery_profile_name: default
  493. variable_sip_P-Asserted-Identity: 31855004076
  494. variable_sip_cid_type: pid
  495. variable_sip_full_route: %3Csip%3A185.249.40.236%3A5060%3Blr%3Btransport%3Dudp%3E
  496. variable_sip_full_via: SIP/2.0/UDP%20185.249.40.253%3A5060%3Bbranch%3Dz9hG4bK714A7AA71839DCFCA8280A3778DADF8E%3Brport%3D5060
  497. variable_sip_from_display: 31855004076
  498. variable_sip_full_from: %2231855004076%22%20%3Csip%3A31855004076%40185.249.40.253%3E%3Btag%3DEC4630303330333099C20501
  499. variable_sip_full_to: %3Csip%3A31307910414%40185.249.40.236%3E
  500. variable_sip_allow: INVITE,%20ACK,%20OPTIONS,%20BYE,%20CANCEL,%20REGISTER,%20INFO,%20UPDATE,%20REFER,%20SUBSCRIBE,%20NOTIFY
  501. variable_sip_req_user: 31307910414
  502. variable_sip_req_port: 5060
  503. variable_sip_req_uri: 31307910414%40185.249.40.236%3A5060
  504. variable_sip_req_host: 185.249.40.236
  505. variable_sip_to_user: 31307910414
  506. variable_sip_to_uri: 31307910414%40185.249.40.236
  507. variable_sip_contact_user: 31855004076
  508. variable_sip_contact_port: 5060
  509. variable_sip_contact_uri: 31855004076%40185.249.40.253%3A5060
  510. variable_sip_contact_host: 185.249.40.253
  511. variable_sip_user_agent: TBSIP
  512. variable_sip_via_host: 185.249.40.253
  513. variable_sip_via_port: 5060
  514. variable_sip_via_rport: 5060
  515. variable_presence_id: 31855004076%40185.249.40.253
  516. variable_sip_Privacy: none
  517. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%2016209504%201%20IN%20IP4%20185.249.40.253%0D%0As%3D-%0D%0Ac%3DIN%20IP4%20185.249.40.253%0D%0At%3D0%200%0D%0Am%3Daudio%2038366%20RTP/AVP%208%20101%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0A
  518. variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
  519. variable_rtp_use_codec_string: PCMA,PCMU,G722
  520. variable_remote_video_media_flow: inactive
  521. variable_remote_text_media_flow: inactive
  522. variable_remote_audio_media_flow: sendrecv
  523. variable_audio_media_flow: sendrecv
  524. variable_remote_media_ip: 185.249.40.253
  525. variable_remote_media_port: 38366
  526. variable_rtp_audio_recv_pt: 8
  527. variable_rtp_use_codec_name: PCMA
  528. variable_rtp_use_codec_rate: 8000
  529. variable_rtp_use_codec_ptime: 20
  530. variable_rtp_use_codec_channels: 1
  531. variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
  532. variable_read_codec: PCMA
  533. variable_original_read_codec: PCMA
  534. variable_read_rate: 8000
  535. variable_original_read_rate: 8000
  536. variable_write_codec: PCMA
  537. variable_write_rate: 8000
  538. variable_dtmf_type: rfc2833
  539. variable_endpoint_disposition: RECEIVED
  540. variable_effective_destination_number: 31307910414
  541. variable_bridge_pre_execute_bleg_app: sched_hangup
  542. variable_bridge_pre_execute_bleg_data: %2B6000%20normal_clearing
  543. variable_callstart: 2023-04-26%2006%3A15%3A58
  544. variable_hangup_after_bridge: true
  545. variable_continue_on_fail: TRUE
  546. variable_account_id: 231
  547. variable_parent_id: 0
  548. variable_entity_id: 3
  549. variable_call_processed: internal
  550. variable_call_direction: inbound
  551. variable_accountname: SBC1..
  552. variable_filename1: astpp.pbx.lua
  553. variable_origination_rates: 0
  554. variable_original_caller_id_name: 31855004076
  555. variable_original_caller_id_number: 31855004076
  556. variable_effective_caller_id_name: 31855004076
  557. variable_effective_caller_id_number: 31855004076
  558. variable_receiver_accid: 759
  559. variable_domain_name: 262876.yoursipcloud.com
  560. variable_sip_to_host: 262876.yoursipcloud.com
  561. variable_presence_data: x%7C%7C%7CIngmar(262876)%7C%7C%7C%7C%7C%7C%7C%7C%7CDID%7C%7C%7C185.249.40.253
  562. variable_call_type: 4
  563. variable_export_vars: domain_name,sip_to_host,presence_data,call_type
  564. variable_calltype: STANDARD
  565. variable_accountcode: 262876
  566. variable_caller_did_account_id: 231
  567. variable_did_number: 31307910414
  568. variable_did_init_inc: 0
  569. variable_did_inc: 0
  570. variable_did_cost: 0.00000
  571. variable_did_connectcost: 0.00000
  572. variable_origination_rates_did: 0
  573. variable_current_application_data: 0681405345%20XML%20default
  574. variable_current_application: transfer
  575. variable_max_forwards: 67
  576. variable_transfer_history: 1682489758%3A38c0252b-af37-468c-bdea-5931a0a39969%3Abl_xfer%3A0681405345/default/XML
  577. variable_transfer_source: 1682489758%3A38c0252b-af37-468c-bdea-5931a0a39969%3Abl_xfer%3A0681405345/default/XML
  578. variable_call_uuid: 7300696e-0f58-47f3-91c0-a52ccc32d979
  579. Hunt-Direction: inbound
  580. Hunt-Logical-Direction: inbound
  581. Hunt-Username: 31855004076
  582. Hunt-Dialplan: XML
  583. Hunt-Caller-ID-Name: 31855004076
  584. Hunt-Caller-ID-Number: 31855004076
  585. Hunt-Orig-Caller-ID-Name: 31855004076
  586. Hunt-Orig-Caller-ID-Number: 31855004076
  587. Hunt-Network-Addr: 185.249.40.253
  588. Hunt-ANI: 31855004076
  589. Hunt-Destination-Number: 0681405345
  590. Hunt-Unique-ID: 7300696e-0f58-47f3-91c0-a52ccc32d979
  591. Hunt-Source: mod_sofia
  592. Hunt-Transfer-Source: 1682489758%3A38c0252b-af37-468c-bdea-5931a0a39969%3Abl_xfer%3A0681405345/default/XML
  593. Hunt-Context: default
  594. Hunt-RDNIS: 31307910414
  595. Hunt-Channel-Name: sofia/default/31855004076%40185.249.40.253
  596. Hunt-Profile-Index: 2
  597. Hunt-Profile-Created-Time: 1682489758248309
  598. Hunt-Channel-Created-Time: 1682489758208305
  599. Hunt-Channel-Answered-Time: 0
  600. Hunt-Channel-Progress-Time: 0
  601. Hunt-Channel-Progress-Media-Time: 0
  602. Hunt-Channel-Hangup-Time: 0
  603. Hunt-Channel-Transfer-Time: 0
  604. Hunt-Channel-Resurrect-Time: 0
  605. Hunt-Channel-Bridged-Time: 0
  606. Hunt-Channel-Last-Hold: 0
  607. Hunt-Channel-Hold-Accum: 0
  608. Hunt-Screen-Bit: true
  609. Hunt-Privacy-Hide-Name: false
  610. Hunt-Privacy-Hide-Number: false
  611.  
  612.  
  613. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_name:
  614. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] tag_name:
  615. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_value:
  616. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] section: dialplan
  617. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  618. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 0681405345
  619. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '0681405345' limit 1
  620. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0681405345' AND status=0 limit 1
  621. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '0681405345' and status=0 LIMIT 1
  622. 2023-04-26 08:15:58.268308 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FAXER] Custom Caller ID
  623. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 31855004076 / 31855004076
  624. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="0681405345" LIMIT 1
  625. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="0681405345"  AND domains.domain="262876.yoursipcloud.com" limit 1
  626. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : outbound
  627. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 262876]
  628. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "262876" AND deleted = 0 limit 1
  629. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0681405345.*' OR blocked_patterns = '^068140534.*' OR blocked_patterns = '^06814053.*' OR blocked_patterns = '^0681405.*' OR blocked_patterns = '^068140.*' OR blocked_patterns = '^06814.*' OR blocked_patterns = '^0681.*' OR blocked_patterns = '^068.*' OR blocked_patterns = '^06.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 759 limit 1
  630. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="0681405345" AND (accountid = 0 OR status = 1) LIMIT 1
  631. 2023-04-26 08:15:58.268308 [NOTICE] switch_cpp.cpp:1447 [ASTPP] Localization Id: 1
  632. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1
  633. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :"0/31,+/".....0681405345
  634. 2023-04-26 08:15:58.268308 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 0681405345
  635. 2023-04-26 08:15:58.268308 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 31681405345
  636. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :"0/31,+/".....31681405345
  637. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^31681405345.*' OR patterns = '^3168140534.*' OR patterns = '^316814053.*' OR patterns = '^31681405.*' OR patterns = '^3168140.*' OR patterns = '^316814.*' OR patterns = '^31681.*' OR patterns = '^3168.*' OR patterns = '^316.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 759 ORDER BY LENGTH(PKGPTR.patterns) DESC
  638. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="31681405345" AND A.accountid = '759' limit 1
  639. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31681405345
  640. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  641. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="262876.yoursipcloud.com" limit 1
  642. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call Direction : outbound
  643. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31681405345' OR number = '3168140534' OR number = '316814053' OR number = '31681405' OR number = '3168140' OR number = '316814' OR number = '31681' OR number = '3168' OR number = '316' OR number = '31' OR number = '3' OR number ='--') OR (number = '31681405345*' OR number = '3168140534*' OR number = '316814053*' OR number = '31681405*' OR number = '3168140*' OR number = '316814*' OR number = '31681*' OR number = '3168*' OR number = '316*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  644. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
  645. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31681405345' OR routing_prefix = '3168140534' OR routing_prefix = '316814053' OR routing_prefix = '31681405' OR routing_prefix = '3168140' OR routing_prefix = '316814' OR routing_prefix = '31681' OR routing_prefix = '3168' OR routing_prefix = '316' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 12 limit 1
  646. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
  647. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 759
  648. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 262876
  649. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 10
  650. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  651. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 6
  652. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  653. 2023-04-26 08:15:58.268308 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  654. 2023-04-26 08:15:58.268308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 6 AND status = 0
  655. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :outbound
  656. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 6 AND status = 0
  657. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 6 OR accountid=759)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  658. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP]  Call Direction : outbound
  659. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
  660. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 9004
  661. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.07200
  662. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 1
  663. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.05400
  664. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Comment : Nederland mobiel
  665. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 0
  666. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 759
  667. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk ID:
  668. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Routing type:
  669. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
  670. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your10 balance Accountid 759 !!!
  671. 2023-04-26 08:15:58.288313 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  672. 2023-04-26 08:15:58.288313 [NOTICE] switch_cpp.cpp:1447 [ASTPP] FINDING LIMIT FOR RESELLER: 12
  673. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "12" AND deleted = 0 limit 1
  674. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^31681405345.*' OR blocked_patterns = '^3168140534.*' OR blocked_patterns = '^316814053.*' OR blocked_patterns = '^31681405.*' OR blocked_patterns = '^3168140.*' OR blocked_patterns = '^316814.*' OR blocked_patterns = '^31681.*' OR blocked_patterns = '^3168.*' OR blocked_patterns = '^316.*' OR blocked_patterns = '^31.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 12 limit 1
  675. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Reseller Information ===================
  676. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 12
  677. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 3847299300
  678. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 99999.94043
  679. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  680. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 44
  681. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 44 AND status = 0
  682. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :outbound
  683. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 44 AND status = 0
  684. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 44 OR accountid=12)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  685. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP]  Call Direction : outbound
  686. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
  687. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 2846863
  688. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
  689. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 0
  690. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.00605
  691. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Comment : Netherlands Mobile
  692. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 0
  693. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 12
  694. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk ID: 4
  695. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Routing type:
  696. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
  697. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your99999.94043 balance Accountid 12 !!!
  698. 2023-04-26 08:15:58.288313 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  699. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Reseller xml_user_rates : ID:9004|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:6|MARKUP:0|CI:0|ACCID:759||ID:2846863|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.00605|INC:1|INITIALBLOCK:1|RATEGROUP:44|MARKUP:0|CI:0|ACCID:12
  700. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  701. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Lossless Routing Status : 0
  702. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max Length Duration : 100 minutes
  703. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] [DIALPLAN] User Rate ID : 9004
  704. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id        :4
  705. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [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 = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (4)  AND TR.effective_date <= UTC_TIMESTAMP() ORDER by FIELD(TR.trunk_id,4),LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC,TR.effective_date DESC
  706. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Termination Rates Information ===================
  707. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 114270
  708. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Code : ^3168.*
  709. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Destination : Netherlands Mobile
  710. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
  711. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Free Seconds : 0
  712. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Prefix : ^3168.*
  713. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Strip :
  714. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Prepend :
  715. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Carrier id : 4
  716. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] carrier_name : SBC1
  717. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] dialplan_variable :
  718. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Failover gateway : SBC2
  719. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Vendor id : 231
  720. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Max channels : 0
  721. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk Name : SBCs
  722. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================END OF TERMINATION RATES=======================
  723. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 759 AND status=0 LIMIT 1
  724. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP]  Maxlength : 100
  725. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  726. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] [XML] Customer Recording Flag : 1
  727. 2023-04-26 08:15:58.288313 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] Call Direction : outbound
  728. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 44 AND status = 0
  729. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [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 = 231) AND status=0 limit 1
  730. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from trunks where id = 4) AND status=0 limit 1
  731. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Anonymous CHECK:31855004076
  732. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31307910414" LIMIT 1
  733. 2023-04-26 08:15:58.288313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Generated XML:
  734. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  735. <document type="freeswitch/xml">
  736. <section name="dialplan" description="ASTPP Dialplan">
  737. <context name="default">
  738. <extension name="31681405345">
  739. <condition field="destination_number" expression="0681405345">
  740. <action application="set" data="effective_destination_number=31681405345"/>
  741. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  742. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  743. <action application="set" data="callstart=2023-04-26 06:15:58"/>
  744. <action application="set" data="hangup_after_bridge=true"/>
  745. <action application="set" data="continue_on_fail=TRUE"/>
  746. <action application="set" data="account_id=759"/>
  747. <action application="set" data="parent_id=12"/>
  748. <action application="set" data="entity_id=0"/>
  749. <action application="set" data="call_processed=internal"/>
  750. <action application="set" data="call_direction=outbound"/>
  751. <action application="set" data="accountname=default"/>
  752. <action application="set" data="filename1=astpp.pbx.lua"/>
  753. <action application="set" data="origination_rates=ID:9004|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:6|MARKUP:0|CI:0|ACCID:759||ID:2846863|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.00605|INC:1|INITIALBLOCK:1|RATEGROUP:44|MARKUP:0|CI:0|ACCID:12"/>
  754. <action application="set" data="original_caller_id_name=31855004076"/>
  755. <action application="set" data="original_caller_id_number=31855004076"/>
  756. <action application="limit" data="db 262876 user_262876 10 "/>
  757. <action application="limit" data="hash CPS_262876 CPS_user_262876 1/1 "/>
  758.  
  759. <action application="set" data="effective_caller_id_name=31855004076"/>
  760. <action application="set" data="effective_caller_id_number=31855004076"/>
  761. <action application="set" data="calltype=STANDARD"/>
  762. <action application="set" data="termination_rates=ID:114270|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:4|PROVIDER:231"/>
  763. <action application="set" data="trunk_id=4"/>
  764. <action application="set" data="provider_id=231"/>
  765. <action application="set" data="rate_flag=2"/>
  766. <action application="set" data="force_trunk_flag=9004"/>
  767. <action application="export" data="presence_data=trunk_id=4"/>
  768. <action application="set" data="intcall=0"/>
  769. <action application="export" data="presence_id=31681405345"/>
  770. <action application="export" data="presence_data=x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile"/>
  771. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345"/>
  772. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345"/>
  773. </condition>
  774. </extension>
  775. </context>
  776. </section>
  777. </document>
  778. Dialplan: sofia/default/31855004076@185.249.40.253 parsing [default->31681405345] continue=false
  779. Dialplan: sofia/default/31855004076@185.249.40.253 Regex (PASS) [31681405345] destination_number(0681405345) =~ /0681405345/ break=on-false
  780. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_destination_number=31681405345)
  781. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  782. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  783. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(callstart=2023-04-26 06:15:58)
  784. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(hangup_after_bridge=true)
  785. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(continue_on_fail=TRUE)
  786. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(account_id=759)
  787. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(parent_id=12)
  788. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(entity_id=0)
  789. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_processed=internal)
  790. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_direction=outbound)
  791. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(accountname=default)
  792. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(filename1=astpp.pbx.lua)
  793. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates=ID:9004|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:6|MARKUP:0|CI:0|ACCID:759||ID:2846863|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.00605|INC:1|INITIALBLOCK:1|RATEGROUP:44|MARKUP:0|CI:0|ACCID:12)
  794. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_name=31855004076)
  795. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_number=31855004076)
  796. Dialplan: sofia/default/31855004076@185.249.40.253 Action limit(db 262876 user_262876 10 )
  797. Dialplan: sofia/default/31855004076@185.249.40.253 Action limit(hash CPS_262876 CPS_user_262876 1/1 )
  798. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_name=31855004076)
  799. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_number=31855004076)
  800. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(calltype=STANDARD)
  801. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(termination_rates=ID:114270|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:4|PROVIDER:231)
  802. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(trunk_id=4)
  803. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(provider_id=231)
  804. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(rate_flag=2)
  805. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(force_trunk_flag=9004)
  806. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=trunk_id=4)
  807. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(intcall=0)
  808. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_id=31681405345)
  809. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile)
  810. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  811. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345)
  812. 2023-04-26 08:15:58.288313 [DEBUG] switch_core_state_machine.c:287 (sofia/default/31855004076@185.249.40.253) State Change CS_ROUTING -> CS_EXECUTE
  813. 2023-04-26 08:15:58.288313 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING going to sleep
  814. 2023-04-26 08:15:58.288313 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_EXECUTE (Cur 3 Tot 635757)
  815. 2023-04-26 08:15:58.288313 [DEBUG] switch_core_state_machine.c:651 (sofia/default/31855004076@185.249.40.253) State EXECUTE
  816. 2023-04-26 08:15:58.288313 [DEBUG] mod_sofia.c:209 sofia/default/31855004076@185.249.40.253 SOFIA EXECUTE
  817. 2023-04-26 08:15:58.288313 [DEBUG] switch_core_state_machine.c:329 sofia/default/31855004076@185.249.40.253 Standard EXECUTE
  818. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_destination_number=31681405345)
  819. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_destination_number]=[31681405345]
  820. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_app=sched_hangup)
  821. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_app]=[sched_hangup]
  822. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  823. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  824. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(callstart=2023-04-26 06:15:58)
  825. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [callstart]=[2023-04-26 06:15:58]
  826. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(hangup_after_bridge=true)
  827. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [hangup_after_bridge]=[true]
  828. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(continue_on_fail=TRUE)
  829. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [continue_on_fail]=[TRUE]
  830. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(account_id=759)
  831. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [account_id]=[759]
  832. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(parent_id=12)
  833. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [parent_id]=[12]
  834. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(entity_id=0)
  835. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [entity_id]=[0]
  836. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_processed=internal)
  837. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_processed]=[internal]
  838. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_direction=outbound)
  839. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_direction]=[outbound]
  840. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(accountname=default)
  841. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [accountname]=[default]
  842. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(filename1=astpp.pbx.lua)
  843. 2023-04-26 08:15:58.288313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [filename1]=[astpp.pbx.lua]
  844. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates=ID:9004|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:6|MARKUP:0|CI:0|ACCID:759||ID:2846863|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.00605|INC:1|INITIALBLOCK:1|RATEGROUP:44|MARKUP:0|CI:0|ACCID:12)
  845. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates]=[ID:9004|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:6|MARKUP:0|CI:0|ACCID:759||ID:2846863|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:|COST:0.00605|INC:1|INITIALBLOCK:1|RATEGROUP:44|MARKUP:0|CI:0|ACCID:12]
  846. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_name=31855004076)
  847. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_name]=[31855004076]
  848. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_number=31855004076)
  849. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_number]=[31855004076]
  850. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 limit(db 262876 user_262876 10 )
  851. 2023-04-26 08:15:58.308311 [DEBUG] switch_limit.c:124 incr called: 262876_user_262876 max:10, interval:0
  852. 2023-04-26 08:15:58.308311 [DEBUG] mod_db.c:194 Usage for 262876_user_262876 is now 1/10
  853. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 limit(hash CPS_262876 CPS_user_262876 1/1 )
  854. 2023-04-26 08:15:58.308311 [DEBUG] switch_limit.c:124 incr called: CPS_262876_CPS_user_262876 max:1, interval:1
  855. 2023-04-26 08:15:58.308311 [DEBUG] mod_hash.c:198 Usage for CPS_262876_CPS_user_262876 is now 1/1 for the last 1 seconds
  856. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_name=31855004076)
  857. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_name]=[31855004076]
  858. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_number=31855004076)
  859. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_number]=[31855004076]
  860. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(calltype=STANDARD)
  861. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [calltype]=[STANDARD]
  862. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(termination_rates=ID:114270|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:4|PROVIDER:231)
  863. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [termination_rates]=[ID:114270|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:4|PROVIDER:231]
  864. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(trunk_id=4)
  865. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [trunk_id]=[4]
  866. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(provider_id=231)
  867. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [provider_id]=[231]
  868. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(rate_flag=2)
  869. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [rate_flag]=[2]
  870. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(force_trunk_flag=9004)
  871. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [force_trunk_flag]=[9004]
  872. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=trunk_id=4)
  873. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[trunk_id=4]
  874. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(intcall=0)
  875. 2023-04-26 08:15:58.308311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [intcall]=[0]
  876. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_id=31681405345)
  877. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_id]=[31681405345]
  878. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile)
  879. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile]
  880. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  881. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [domain_name]=[262876.yoursipcloud.com] to event
  882. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [sip_to_host]=[262876.yoursipcloud.com] to event
  883. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile] to event
  884. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [call_type]=[4] to event
  885. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile] to event
  886. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_id]=[31681405345] to event
  887. 2023-04-26 08:15:58.308311 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x//12|||Ingmar(262876)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=4|||STD|||185.249.40.253|||0.00605 // ^3168.* // Netherlands Mobile] to event
  888. 2023-04-26 08:15:58.308311 [DEBUG] switch_ivr_originate.c:2242 Parsing global variables
  889. 2023-04-26 08:15:58.308311 [DEBUG] switch_ivr_originate.c:2804 Parsing session specific variables
  890. 2023-04-26 08:15:58.308311 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31681405345 [bb19ce1b-d877-4174-a89c-5cf8af2154b3]
  891. 2023-04-26 08:15:58.308311 [DEBUG] mod_sofia.c:5089 (sofia/default/31681405345) State Change CS_NEW -> CS_INIT
  892. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_INIT (Cur 4 Tot 635758)
  893. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT
  894. 2023-04-26 08:15:58.308311 [DEBUG] mod_sofia.c:93 sofia/default/31681405345 SOFIA INIT
  895. 2023-04-26 08:15:58.308311 [DEBUG] sofia_glue.c:1618 sofia/default/31681405345 sending invite version: 1.10.5 -release-17-25569c1631 64bit
  896. Local SDP:
  897. v=0
  898. o=FreeSWITCH 1682459314 1682459315 IN IP4 185.249.40.236
  899. s=FreeSWITCH
  900. c=IN IP4 185.249.40.236
  901. t=0 0
  902. m=audio 30444 RTP/AVP 8 101
  903. a=rtpmap:8 PCMA/8000
  904. a=rtpmap:101 telephone-event/8000
  905. a=fmtp:101 0-16
  906. a=ptime:20
  907. a=sendrecv
  908.  
  909. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:40 sofia/default/31681405345 Standard INIT
  910. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31681405345) State Change CS_INIT -> CS_ROUTING
  911. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT going to sleep
  912. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_ROUTING (Cur 4 Tot 635758)
  913. 2023-04-26 08:15:58.308311 [DEBUG] sofia.c:7326 Channel sofia/default/31681405345 entering state [calling][0]
  914. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING
  915. 2023-04-26 08:15:58.308311 [DEBUG] mod_sofia.c:154 sofia/default/31681405345 SOFIA ROUTING
  916. 2023-04-26 08:15:58.308311 [DEBUG] switch_ivr_originate.c:67 (sofia/default/31681405345) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  917. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING going to sleep
  918. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_CONSUME_MEDIA (Cur 4 Tot 635758)
  919. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:663 (sofia/default/31681405345) State CONSUME_MEDIA
  920. 2023-04-26 08:15:58.308311 [DEBUG] switch_core_state_machine.c:663 (sofia/default/31681405345) State CONSUME_MEDIA going to sleep
  921. 2023-04-26 08:15:58.468309 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31855004076@185.249.40.253 [ed6b5235-1a0b-4275-a34e-faedce095175]
  922. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_NEW (Cur 5 Tot 635759)
  923. 2023-04-26 08:15:58.468309 [DEBUG] sofia.c:10280 sofia/default/31855004076@185.249.40.253 receiving invite from 185.249.40.253:5060 version: 1.10.5 -release-17-25569c1631 64bit
  924. 2023-04-26 08:15:58.468309 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.249.40.253:0.
  925. 2023-04-26 08:15:58.468309 [DEBUG] sofia.c:10403 IP 185.249.40.253 Approved by acl "default[]". Access Granted.
  926. 2023-04-26 08:15:58.468309 [DEBUG] sofia.c:7326 Channel sofia/default/31855004076@185.249.40.253 entering state [received][100]
  927. 2023-04-26 08:15:58.468309 [DEBUG] sofia.c:7336 Remote SDP:
  928. v=0
  929. o=- 16209510 1 IN IP4 185.249.40.253
  930. s=-
  931. c=IN IP4 185.249.40.253
  932. t=0 0
  933. m=audio 38372 RTP/AVP 8 101
  934. a=rtpmap:101 telephone-event/8000
  935. a=ptime:20
  936.  
  937. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  938. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  939. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  940. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G722:9:8000:20:64000:1]
  941. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 101@8000
  942. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/31855004076@185.249.40.253 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  943. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_codec.c:111 sofia/default/31855004076@185.249.40.253 Original read codec set to PCMA:8
  944. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000
  945. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_media.c:5911 sofia/default/31855004076@185.249.40.253 Set 2833 dtmf send payload to 101 recv payload to 101
  946. 2023-04-26 08:15:58.468309 [DEBUG] sofia.c:7760 (sofia/default/31855004076@185.249.40.253) State Change CS_NEW -> CS_INIT
  947. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:604 (sofia/default/31855004076@185.249.40.253) State NEW
  948. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_INIT (Cur 5 Tot 635759)
  949. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31855004076@185.249.40.253) State INIT
  950. 2023-04-26 08:15:58.468309 [DEBUG] mod_sofia.c:93 sofia/default/31855004076@185.249.40.253 SOFIA INIT
  951. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:40 sofia/default/31855004076@185.249.40.253 Standard INIT
  952. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31855004076@185.249.40.253) State Change CS_INIT -> CS_ROUTING
  953. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31855004076@185.249.40.253) State INIT going to sleep
  954. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_ROUTING (Cur 5 Tot 635759)
  955. 2023-04-26 08:15:58.468309 [DEBUG] switch_channel.c:2332 (sofia/default/31855004076@185.249.40.253) Callstate Change DOWN -> RINGING
  956. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING
  957. 2023-04-26 08:15:58.468309 [DEBUG] mod_sofia.c:154 sofia/default/31855004076@185.249.40.253 SOFIA ROUTING
  958. 2023-04-26 08:15:58.468309 [DEBUG] switch_core_state_machine.c:236 sofia/default/31855004076@185.249.40.253 Standard ROUTING
  959. 2023-04-26 08:15:58.468309 [INFO] mod_dialplan_xml.c:637 Processing 31855004076 <31855004076>->31681405345 in context default
  960. 2023-04-26 08:15:58.468309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  961. 2023-04-26 08:15:58.468309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  962. 2023-04-26 08:15:58.488308 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [xml_handler] Params:
  963. Event-Name: REQUEST_PARAMS
  964. Core-UUID: ea9d74c5-64c7-47f9-8036-72e9783891f2
  965. FreeSWITCH-Hostname: multitenant-1
  966. FreeSWITCH-Switchname: multitenant-1
  967. FreeSWITCH-IPv4: 185.249.40.236
  968. FreeSWITCH-IPv6: %3A%3A1
  969. Event-Date-Local: 2023-04-26%2008%3A15%3A58
  970. Event-Date-GMT: Wed,%2026%20Apr%202023%2006%3A15%3A58%20GMT
  971. Event-Date-Timestamp: 1682489758468309
  972. Event-Calling-File: mod_dialplan_xml.c
  973. Event-Calling-Function: dialplan_xml_locate
  974. Event-Calling-Line-Number: 608
  975. Event-Sequence: 52519039
  976. Channel-State: CS_ROUTING
  977. Channel-Call-State: RINGING
  978. Channel-State-Number: 2
  979. Channel-Name: sofia/default/31855004076%40185.249.40.253
  980. Unique-ID: ed6b5235-1a0b-4275-a34e-faedce095175
  981. Call-Direction: inbound
  982. Presence-Call-Direction: inbound
  983. Channel-HIT-Dialplan: true
  984. Channel-Presence-ID: 31855004076%40185.249.40.253
  985. Channel-Call-UUID: ed6b5235-1a0b-4275-a34e-faedce095175
  986. Answer-State: ringing
  987. Channel-Read-Codec-Name: PCMA
  988. Channel-Read-Codec-Rate: 8000
  989. Channel-Read-Codec-Bit-Rate: 64000
  990. Channel-Write-Codec-Name: PCMA
  991. Channel-Write-Codec-Rate: 8000
  992. Channel-Write-Codec-Bit-Rate: 64000
  993. Caller-Direction: inbound
  994. Caller-Logical-Direction: inbound
  995. Caller-Username: 31855004076
  996. Caller-Dialplan: XML
  997. Caller-Caller-ID-Name: 31855004076
  998. Caller-Caller-ID-Number: 31855004076
  999. Caller-Orig-Caller-ID-Name: 31855004076
  1000. Caller-Orig-Caller-ID-Number: 31855004076
  1001. Caller-Network-Addr: 185.249.40.253
  1002. Caller-ANI: 31855004076
  1003. Caller-Destination-Number: 31681405345
  1004. Caller-Unique-ID: ed6b5235-1a0b-4275-a34e-faedce095175
  1005. Caller-Source: mod_sofia
  1006. Caller-Context: default
  1007. Caller-Channel-Name: sofia/default/31855004076%40185.249.40.253
  1008. Caller-Profile-Index: 1
  1009. Caller-Profile-Created-Time: 1682489758468309
  1010. Caller-Channel-Created-Time: 1682489758468309
  1011. Caller-Channel-Answered-Time: 0
  1012. Caller-Channel-Progress-Time: 0
  1013. Caller-Channel-Progress-Media-Time: 0
  1014. Caller-Channel-Hangup-Time: 0
  1015. Caller-Channel-Transfer-Time: 0
  1016. Caller-Channel-Resurrect-Time: 0
  1017. Caller-Channel-Bridged-Time: 0
  1018. Caller-Channel-Last-Hold: 0
  1019. Caller-Channel-Hold-Accum: 0
  1020. Caller-Screen-Bit: true
  1021. Caller-Privacy-Hide-Name: false
  1022. Caller-Privacy-Hide-Number: false
  1023. variable_direction: inbound
  1024. variable_uuid: ed6b5235-1a0b-4275-a34e-faedce095175
  1025. variable_session_id: 635759
  1026. variable_sip_from_user: 31855004076
  1027. variable_sip_from_uri: 31855004076%40185.249.40.253
  1028. variable_sip_from_host: 185.249.40.253
  1029. variable_video_media_flow: disabled
  1030. variable_text_media_flow: disabled
  1031. variable_channel_name: sofia/default/31855004076%40185.249.40.253
  1032. variable_sip_call_id: 02165EC6D181400000AE8942%40UDP_5060.sbc1.controlsbc.com
  1033. variable_sip_local_network_addr: 185.249.40.236
  1034. variable_sip_network_ip: 185.249.40.253
  1035. variable_sip_network_port: 5060
  1036. variable_sip_invite_stamp: 1682489758468309
  1037. variable_sip_received_ip: 185.249.40.253
  1038. variable_sip_received_port: 5060
  1039. variable_sip_via_protocol: udp
  1040. variable_sip_authorized: true
  1041. variable_sip_acl_authed_by: default
  1042. variable_sip_from_user_stripped: 31855004076
  1043. variable_sip_from_tag: DB063030333033309BC20501
  1044. variable_sofia_profile_name: default
  1045. variable_sofia_profile_url: sip%3Amod_sofia%40185.249.40.236%3A5060
  1046. variable_recovery_profile_name: default
  1047. variable_sip_P-Asserted-Identity: 31855004076
  1048. variable_sip_cid_type: pid
  1049. variable_sip_full_route: %3Csip%3A185.249.40.236%3A5060%3Blr%3Btransport%3Dudp%3E
  1050. variable_sip_full_via: SIP/2.0/UDP%20185.249.40.253%3A5060%3Bbranch%3Dz9hG4bKC07BE1A0D7CD4414CC1ECBDDCC3F82D0%3Brport%3D5060
  1051. variable_sip_from_display: 31855004076
  1052. variable_sip_full_from: %2231855004076%22%20%3Csip%3A31855004076%40185.249.40.253%3E%3Btag%3DDB063030333033309BC20501
  1053. variable_sip_full_to: %3Csip%3A31681405345%40185.249.40.236%3E
  1054. variable_sip_allow: INVITE,%20ACK,%20OPTIONS,%20BYE,%20CANCEL,%20REGISTER,%20INFO,%20UPDATE,%20REFER,%20SUBSCRIBE,%20NOTIFY
  1055. variable_sip_req_user: 31681405345
  1056. variable_sip_req_port: 5060
  1057. variable_sip_req_uri: 31681405345%40185.249.40.236%3A5060
  1058. variable_sip_req_host: 185.249.40.236
  1059. variable_sip_to_user: 31681405345
  1060. variable_sip_to_uri: 31681405345%40185.249.40.236
  1061. variable_sip_to_host: 185.249.40.236
  1062. variable_sip_contact_user: 31855004076
  1063. variable_sip_contact_port: 5060
  1064. variable_sip_contact_uri: 31855004076%40185.249.40.253%3A5060
  1065. variable_sip_contact_host: 185.249.40.253
  1066. variable_sip_user_agent: TBSIP
  1067. variable_sip_via_host: 185.249.40.253
  1068. variable_sip_via_port: 5060
  1069. variable_sip_via_rport: 5060
  1070. variable_max_forwards: 64
  1071. variable_presence_id: 31855004076%40185.249.40.253
  1072. variable_sip_Privacy: none
  1073. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%2016209510%201%20IN%20IP4%20185.249.40.253%0D%0As%3D-%0D%0Ac%3DIN%20IP4%20185.249.40.253%0D%0At%3D0%200%0D%0Am%3Daudio%2038372%20RTP/AVP%208%20101%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dptime%3A20%0D%0A
  1074. variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
  1075. variable_rtp_use_codec_string: PCMA,PCMU,G722
  1076. variable_remote_video_media_flow: inactive
  1077. variable_remote_text_media_flow: inactive
  1078. variable_remote_audio_media_flow: sendrecv
  1079. variable_audio_media_flow: sendrecv
  1080. variable_remote_media_ip: 185.249.40.253
  1081. variable_remote_media_port: 38372
  1082. variable_rtp_audio_recv_pt: 8
  1083. variable_rtp_use_codec_name: PCMA
  1084. variable_rtp_use_codec_rate: 8000
  1085. variable_rtp_use_codec_ptime: 20
  1086. variable_rtp_use_codec_channels: 1
  1087. variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
  1088. variable_read_codec: PCMA
  1089. variable_original_read_codec: PCMA
  1090. variable_read_rate: 8000
  1091. variable_original_read_rate: 8000
  1092. variable_write_codec: PCMA
  1093. variable_write_rate: 8000
  1094. variable_dtmf_type: rfc2833
  1095. variable_endpoint_disposition: RECEIVED
  1096. variable_call_uuid: ed6b5235-1a0b-4275-a34e-faedce095175
  1097. Hunt-Direction: inbound
  1098. Hunt-Logical-Direction: inbound
  1099. Hunt-Username: 31855004076
  1100. Hunt-Dialplan: XML
  1101. Hunt-Caller-ID-Name: 31855004076
  1102. Hunt-Caller-ID-Number: 31855004076
  1103. Hunt-Orig-Caller-ID-Name: 31855004076
  1104. Hunt-Orig-Caller-ID-Number: 31855004076
  1105. Hunt-Network-Addr: 185.249.40.253
  1106. Hunt-ANI: 31855004076
  1107. Hunt-Destination-Number: 31681405345
  1108. Hunt-Unique-ID: ed6b5235-1a0b-4275-a34e-faedce095175
  1109. Hunt-Source: mod_sofia
  1110. Hunt-Context: default
  1111. Hunt-Channel-Name: sofia/default/31855004076%40185.249.40.253
  1112. Hunt-Profile-Index: 1
  1113. Hunt-Profile-Created-Time: 1682489758468309
  1114. Hunt-Channel-Created-Time: 1682489758468309
  1115. Hunt-Channel-Answered-Time: 0
  1116. Hunt-Channel-Progress-Time: 0
  1117. Hunt-Channel-Progress-Media-Time: 0
  1118. Hunt-Channel-Hangup-Time: 0
  1119. Hunt-Channel-Transfer-Time: 0
  1120. Hunt-Channel-Resurrect-Time: 0
  1121. Hunt-Channel-Bridged-Time: 0
  1122. Hunt-Channel-Last-Hold: 0
  1123. Hunt-Channel-Hold-Accum: 0
  1124. Hunt-Screen-Bit: true
  1125. Hunt-Privacy-Hide-Name: false
  1126. Hunt-Privacy-Hide-Number: false
  1127.  
  1128.  
  1129. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_value:
  1130. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_name:
  1131. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] tag_name:
  1132. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] section: dialplan
  1133. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  1134. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 31681405345
  1135. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '31681405345' limit 1
  1136. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '31681405345' AND status=0 limit 1
  1137. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '31681405345' and status=0 LIMIT 1
  1138. 2023-04-26 08:15:58.488308 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FAXER] Custom Caller ID
  1139. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 31855004076 / 31855004076
  1140. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  1141. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="185.249.40.236" limit 1
  1142. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : outbound
  1143. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("185.249.40.253") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "31681405345"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  1144. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 740489]
  1145. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "740489" AND deleted = 0 limit 1
  1146. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^31681405345.*' OR blocked_patterns = '^3168140534.*' OR blocked_patterns = '^316814053.*' OR blocked_patterns = '^31681405.*' OR blocked_patterns = '^3168140.*' OR blocked_patterns = '^316814.*' OR blocked_patterns = '^31681.*' OR blocked_patterns = '^3168.*' OR blocked_patterns = '^316.*' OR blocked_patterns = '^31.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 231 limit 1
  1147. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="31681405345" AND (accountid = 0 OR status = 1) LIMIT 1
  1148. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^31681405345.*' OR patterns = '^3168140534.*' OR patterns = '^316814053.*' OR patterns = '^31681405.*' OR patterns = '^3168140.*' OR patterns = '^316814.*' OR patterns = '^31681.*' OR patterns = '^3168.*' OR patterns = '^316.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 231 ORDER BY LENGTH(PKGPTR.patterns) DESC
  1149. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="31681405345" AND A.accountid = '231' limit 1
  1150. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31681405345
  1151. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  1152. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="185.249.40.236" limit 1
  1153. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call Direction : outbound
  1154. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31681405345' OR number = '3168140534' OR number = '316814053' OR number = '31681405' OR number = '3168140' OR number = '316814' OR number = '31681' OR number = '3168' OR number = '316' OR number = '31' OR number = '3' OR number ='--') OR (number = '31681405345*' OR number = '3168140534*' OR number = '316814053*' OR number = '31681405*' OR number = '3168140*' OR number = '316814*' OR number = '31681*' OR number = '3168*' OR number = '316*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  1155. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
  1156. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31681405345' OR routing_prefix = '3168140534' OR routing_prefix = '316814053' OR routing_prefix = '31681405' OR routing_prefix = '3168140' OR routing_prefix = '316814' OR routing_prefix = '31681' OR routing_prefix = '3168' OR routing_prefix = '316' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  1157. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
  1158. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 231
  1159. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 740489
  1160. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 0.1278
  1161. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  1162. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
  1163. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  1164. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  1165. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  1166. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :outbound
  1167. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  1168. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 1 OR accountid=231)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  1169. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP]  Call Direction : outbound
  1170. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
  1171. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 3590735
  1172. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.07200
  1173. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 1
  1174. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.05400
  1175. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Comment : Nederland mobiel
  1176. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 0
  1177. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 231
  1178. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk ID: 7
  1179. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Routing type:
  1180. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
  1181. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your0.1278 balance Accountid 231 !!!
  1182. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max Length Duration : 1.0333333333333 minutes
  1183. 2023-04-26 08:15:58.488308 [INFO] switch_cpp.cpp:1447 [ASTPP] [DIALPLAN] User Rate ID : 3590735
  1184. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id        :7
  1185. 2023-04-26 08:15:58.488308 [DEBUG] switch_cpp.cpp:1447 [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 = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (7)  AND TR.effective_date <= UTC_TIMESTAMP() ORDER by FIELD(TR.trunk_id,7),LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC,TR.effective_date DESC
  1186. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Termination Rates Information ===================
  1187. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 127133
  1188. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Code : ^3168.*
  1189. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Destination : Netherlands Mobile
  1190. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
  1191. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Free Seconds : 1
  1192. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Prefix : ^3168.*
  1193. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Strip :
  1194. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Prepend :
  1195. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Carrier id : 7
  1196. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] carrier_name : SBC1
  1197. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] dialplan_variable :
  1198. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Failover gateway : SBC2
  1199. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Vendor id : 231
  1200. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Max channels : 0
  1201. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk Name : SBCs new
  1202. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================END OF TERMINATION RATES=======================
  1203. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 231 AND status=0 LIMIT 1
  1204. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP]  Maxlength : 1.0333333333333
  1205. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  1206. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] [XML] Customer Recording Flag : 1
  1207. 2023-04-26 08:15:58.508309 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] Call Direction : outbound
  1208. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  1209. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [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 = 231) AND status=0 limit 1
  1210. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [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 = 7) AND status=0 limit 1
  1211. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Anonymous CHECK:31855004076
  1212. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  1213. 2023-04-26 08:15:58.508309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Generated XML:
  1214. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  1215. <document type="freeswitch/xml">
  1216. <section name="dialplan" description="ASTPP Dialplan">
  1217. <context name="default">
  1218. <extension name="31681405345">
  1219. <condition field="destination_number" expression="31681405345">
  1220. <action application="set" data="effective_destination_number=31681405345"/>
  1221. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  1222. <action application="set" data="bridge_pre_execute_bleg_data=+62 normal_clearing"/>
  1223. <action application="set" data="callstart=2023-04-26 06:15:58"/>
  1224. <action application="set" data="hangup_after_bridge=true"/>
  1225. <action application="set" data="continue_on_fail=TRUE"/>
  1226. <action application="set" data="account_id=231"/>
  1227. <action application="set" data="parent_id=0"/>
  1228. <action application="set" data="entity_id=3"/>
  1229. <action application="set" data="call_processed=internal"/>
  1230. <action application="set" data="call_direction=outbound"/>
  1231. <action application="set" data="accountname=SBC1.."/>
  1232. <action application="set" data="filename1=astpp.pbx.lua"/>
  1233. <action application="set" data="origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231"/>
  1234. <action application="set" data="original_caller_id_name=31855004076"/>
  1235. <action application="set" data="original_caller_id_number=31855004076"/>
  1236.  
  1237. <action application="set" data="effective_caller_id_name=31855004076"/>
  1238. <action application="set" data="effective_caller_id_number=31855004076"/>
  1239. <action application="set" data="calltype=STANDARD"/>
  1240. <action application="set" data="termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231"/>
  1241. <action application="set" data="trunk_id=7"/>
  1242. <action application="set" data="provider_id=231"/>
  1243. <action application="set" data="rate_flag=0"/>
  1244. <action application="set" data="force_trunk_flag=3590735"/>
  1245. <action application="export" data="presence_data=trunk_id=7"/>
  1246. <action application="set" data="intcall=0"/>
  1247. <action application="export" data="presence_id=31681405345"/>
  1248. <action application="export" data="presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253"/>
  1249. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345"/>
  1250. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345"/>
  1251. </condition>
  1252. </extension>
  1253. </context>
  1254. </section>
  1255. </document>
  1256. Dialplan: sofia/default/31855004076@185.249.40.253 parsing [default->31681405345] continue=false
  1257. Dialplan: sofia/default/31855004076@185.249.40.253 Regex (PASS) [31681405345] destination_number(31681405345) =~ /31681405345/ break=on-false
  1258. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_destination_number=31681405345)
  1259. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  1260. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_data=+62 normal_clearing)
  1261. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(callstart=2023-04-26 06:15:58)
  1262. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(hangup_after_bridge=true)
  1263. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(continue_on_fail=TRUE)
  1264. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(account_id=231)
  1265. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(parent_id=0)
  1266. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(entity_id=3)
  1267. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_processed=internal)
  1268. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_direction=outbound)
  1269. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(accountname=SBC1..)
  1270. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(filename1=astpp.pbx.lua)
  1271. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231)
  1272. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_name=31855004076)
  1273. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_number=31855004076)
  1274. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_name=31855004076)
  1275. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_number=31855004076)
  1276. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(calltype=STANDARD)
  1277. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231)
  1278. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(trunk_id=7)
  1279. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(provider_id=231)
  1280. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(rate_flag=0)
  1281. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(force_trunk_flag=3590735)
  1282. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=trunk_id=7)
  1283. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(intcall=0)
  1284. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_id=31681405345)
  1285. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253)
  1286. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  1287. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345)
  1288. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:287 (sofia/default/31855004076@185.249.40.253) State Change CS_ROUTING -> CS_EXECUTE
  1289. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING going to sleep
  1290. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_EXECUTE (Cur 5 Tot 635759)
  1291. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:651 (sofia/default/31855004076@185.249.40.253) State EXECUTE
  1292. 2023-04-26 08:15:58.508309 [DEBUG] mod_sofia.c:209 sofia/default/31855004076@185.249.40.253 SOFIA EXECUTE
  1293. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:329 sofia/default/31855004076@185.249.40.253 Standard EXECUTE
  1294. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_destination_number=31681405345)
  1295. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_destination_number]=[31681405345]
  1296. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_app=sched_hangup)
  1297. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_app]=[sched_hangup]
  1298. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_data=+62 normal_clearing)
  1299. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_data]=[+62 normal_clearing]
  1300. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(callstart=2023-04-26 06:15:58)
  1301. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [callstart]=[2023-04-26 06:15:58]
  1302. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(hangup_after_bridge=true)
  1303. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [hangup_after_bridge]=[true]
  1304. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(continue_on_fail=TRUE)
  1305. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [continue_on_fail]=[TRUE]
  1306. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(account_id=231)
  1307. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [account_id]=[231]
  1308. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(parent_id=0)
  1309. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [parent_id]=[0]
  1310. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(entity_id=3)
  1311. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [entity_id]=[3]
  1312. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_processed=internal)
  1313. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_processed]=[internal]
  1314. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_direction=outbound)
  1315. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_direction]=[outbound]
  1316. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(accountname=SBC1..)
  1317. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [accountname]=[SBC1..]
  1318. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(filename1=astpp.pbx.lua)
  1319. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [filename1]=[astpp.pbx.lua]
  1320. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231)
  1321. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates]=[ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231]
  1322. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_name=31855004076)
  1323. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_name]=[31855004076]
  1324. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_number=31855004076)
  1325. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_number]=[31855004076]
  1326. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_name=31855004076)
  1327. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_name]=[31855004076]
  1328. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_number=31855004076)
  1329. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_number]=[31855004076]
  1330. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(calltype=STANDARD)
  1331. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [calltype]=[STANDARD]
  1332. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231)
  1333. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [termination_rates]=[ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231]
  1334. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(trunk_id=7)
  1335. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [trunk_id]=[7]
  1336. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(provider_id=231)
  1337. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [provider_id]=[231]
  1338. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(rate_flag=0)
  1339. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [rate_flag]=[0]
  1340. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(force_trunk_flag=3590735)
  1341. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [force_trunk_flag]=[3590735]
  1342. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=trunk_id=7)
  1343. 2023-04-26 08:15:58.508309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[trunk_id=7]
  1344. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(intcall=0)
  1345. 2023-04-26 08:15:58.508309 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [intcall]=[0]
  1346. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_id=31681405345)
  1347. 2023-04-26 08:15:58.508309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_id]=[31681405345]
  1348. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253)
  1349. 2023-04-26 08:15:58.508309 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253]
  1350. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  1351. 2023-04-26 08:15:58.508309 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253] to event
  1352. 2023-04-26 08:15:58.508309 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_id]=[31681405345] to event
  1353. 2023-04-26 08:15:58.508309 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253] to event
  1354. 2023-04-26 08:15:58.508309 [DEBUG] switch_ivr_originate.c:2242 Parsing global variables
  1355. 2023-04-26 08:15:58.508309 [DEBUG] switch_ivr_originate.c:2804 Parsing session specific variables
  1356. 2023-04-26 08:15:58.508309 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31681405345 [45f1f8d5-6c04-44cf-81d8-a8e8b2915b57]
  1357. 2023-04-26 08:15:58.508309 [DEBUG] mod_sofia.c:5089 (sofia/default/31681405345) State Change CS_NEW -> CS_INIT
  1358. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_INIT (Cur 6 Tot 635760)
  1359. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT
  1360. 2023-04-26 08:15:58.508309 [DEBUG] mod_sofia.c:93 sofia/default/31681405345 SOFIA INIT
  1361. 2023-04-26 08:15:58.508309 [DEBUG] sofia_glue.c:1618 sofia/default/31681405345 sending invite version: 1.10.5 -release-17-25569c1631 64bit
  1362. Local SDP:
  1363. v=0
  1364. o=FreeSWITCH 1682461642 1682461643 IN IP4 185.249.40.236
  1365. s=FreeSWITCH
  1366. c=IN IP4 185.249.40.236
  1367. t=0 0
  1368. m=audio 28116 RTP/AVP 8 101
  1369. a=rtpmap:8 PCMA/8000
  1370. a=rtpmap:101 telephone-event/8000
  1371. a=fmtp:101 0-16
  1372. a=ptime:20
  1373. a=sendrecv
  1374.  
  1375. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:40 sofia/default/31681405345 Standard INIT
  1376. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31681405345) State Change CS_INIT -> CS_ROUTING
  1377. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT going to sleep
  1378. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_ROUTING (Cur 6 Tot 635760)
  1379. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING
  1380. 2023-04-26 08:15:58.508309 [DEBUG] mod_sofia.c:154 sofia/default/31681405345 SOFIA ROUTING
  1381. 2023-04-26 08:15:58.508309 [DEBUG] switch_ivr_originate.c:67 (sofia/default/31681405345) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  1382. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING going to sleep
  1383. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_CONSUME_MEDIA (Cur 6 Tot 635760)
  1384. 2023-04-26 08:15:58.508309 [DEBUG] sofia.c:7326 Channel sofia/default/31681405345 entering state [calling][0]
  1385. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:663 (sofia/default/31681405345) State CONSUME_MEDIA
  1386. 2023-04-26 08:15:58.508309 [DEBUG] switch_core_state_machine.c:663 (sofia/default/31681405345) State CONSUME_MEDIA going to sleep
  1387. 2023-04-26 08:15:58.668309 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31855004076@185.249.40.253 [606a9cca-5301-4d51-b564-b779fefe2470]
  1388. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_NEW (Cur 7 Tot 635761)
  1389. 2023-04-26 08:15:58.668309 [DEBUG] sofia.c:10280 sofia/default/31855004076@185.249.40.253 receiving invite from 185.249.40.253:5060 version: 1.10.5 -release-17-25569c1631 64bit
  1390. 2023-04-26 08:15:58.668309 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.249.40.253:0.
  1391. 2023-04-26 08:15:58.668309 [DEBUG] sofia.c:10403 IP 185.249.40.253 Approved by acl "default[]". Access Granted.
  1392. 2023-04-26 08:15:58.668309 [DEBUG] sofia.c:7326 Channel sofia/default/31855004076@185.249.40.253 entering state [received][100]
  1393. 2023-04-26 08:15:58.668309 [DEBUG] sofia.c:7336 Remote SDP:
  1394. v=0
  1395. o=- 16209515 1 IN IP4 185.249.40.253
  1396. s=-
  1397. c=IN IP4 185.249.40.253
  1398. t=0 0
  1399. m=audio 38378 RTP/AVP 8 101
  1400. a=rtpmap:101 telephone-event/8000
  1401. a=ptime:20
  1402.  
  1403. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  1404. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  1405. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  1406. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G722:9:8000:20:64000:1]
  1407. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 101@8000
  1408. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/31855004076@185.249.40.253 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  1409. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_codec.c:111 sofia/default/31855004076@185.249.40.253 Original read codec set to PCMA:8
  1410. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000
  1411. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_media.c:5911 sofia/default/31855004076@185.249.40.253 Set 2833 dtmf send payload to 101 recv payload to 101
  1412. 2023-04-26 08:15:58.668309 [DEBUG] sofia.c:7760 (sofia/default/31855004076@185.249.40.253) State Change CS_NEW -> CS_INIT
  1413. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:604 (sofia/default/31855004076@185.249.40.253) State NEW
  1414. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_INIT (Cur 7 Tot 635761)
  1415. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31855004076@185.249.40.253) State INIT
  1416. 2023-04-26 08:15:58.668309 [DEBUG] mod_sofia.c:93 sofia/default/31855004076@185.249.40.253 SOFIA INIT
  1417. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:40 sofia/default/31855004076@185.249.40.253 Standard INIT
  1418. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31855004076@185.249.40.253) State Change CS_INIT -> CS_ROUTING
  1419. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31855004076@185.249.40.253) State INIT going to sleep
  1420. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_ROUTING (Cur 7 Tot 635761)
  1421. 2023-04-26 08:15:58.668309 [DEBUG] switch_channel.c:2332 (sofia/default/31855004076@185.249.40.253) Callstate Change DOWN -> RINGING
  1422. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING
  1423. 2023-04-26 08:15:58.668309 [DEBUG] mod_sofia.c:154 sofia/default/31855004076@185.249.40.253 SOFIA ROUTING
  1424. 2023-04-26 08:15:58.668309 [DEBUG] switch_core_state_machine.c:236 sofia/default/31855004076@185.249.40.253 Standard ROUTING
  1425. 2023-04-26 08:15:58.668309 [INFO] mod_dialplan_xml.c:637 Processing 31855004076 <31855004076>->31681405345 in context default
  1426. 2023-04-26 08:15:58.668309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  1427. 2023-04-26 08:15:58.668309 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  1428. 2023-04-26 08:15:58.688311 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [xml_handler] Params:
  1429. Event-Name: REQUEST_PARAMS
  1430. Core-UUID: ea9d74c5-64c7-47f9-8036-72e9783891f2
  1431. FreeSWITCH-Hostname: multitenant-1
  1432. FreeSWITCH-Switchname: multitenant-1
  1433. FreeSWITCH-IPv4: 185.249.40.236
  1434. FreeSWITCH-IPv6: %3A%3A1
  1435. Event-Date-Local: 2023-04-26%2008%3A15%3A58
  1436. Event-Date-GMT: Wed,%2026%20Apr%202023%2006%3A15%3A58%20GMT
  1437. Event-Date-Timestamp: 1682489758668309
  1438. Event-Calling-File: mod_dialplan_xml.c
  1439. Event-Calling-Function: dialplan_xml_locate
  1440. Event-Calling-Line-Number: 608
  1441. Event-Sequence: 52519113
  1442. Channel-State: CS_ROUTING
  1443. Channel-Call-State: RINGING
  1444. Channel-State-Number: 2
  1445. Channel-Name: sofia/default/31855004076%40185.249.40.253
  1446. Unique-ID: 606a9cca-5301-4d51-b564-b779fefe2470
  1447. Call-Direction: inbound
  1448. Presence-Call-Direction: inbound
  1449. Channel-HIT-Dialplan: true
  1450. Channel-Presence-ID: 31855004076%40185.249.40.253
  1451. Channel-Call-UUID: 606a9cca-5301-4d51-b564-b779fefe2470
  1452. Answer-State: ringing
  1453. Channel-Read-Codec-Name: PCMA
  1454. Channel-Read-Codec-Rate: 8000
  1455. Channel-Read-Codec-Bit-Rate: 64000
  1456. Channel-Write-Codec-Name: PCMA
  1457. Channel-Write-Codec-Rate: 8000
  1458. Channel-Write-Codec-Bit-Rate: 64000
  1459. Caller-Direction: inbound
  1460. Caller-Logical-Direction: inbound
  1461. Caller-Username: 31855004076
  1462. Caller-Dialplan: XML
  1463. Caller-Caller-ID-Name: 31855004076
  1464. Caller-Caller-ID-Number: 31855004076
  1465. Caller-Orig-Caller-ID-Name: 31855004076
  1466. Caller-Orig-Caller-ID-Number: 31855004076
  1467. Caller-Network-Addr: 185.249.40.253
  1468. Caller-ANI: 31855004076
  1469. Caller-Destination-Number: 31681405345
  1470. Caller-Unique-ID: 606a9cca-5301-4d51-b564-b779fefe2470
  1471. Caller-Source: mod_sofia
  1472. Caller-Context: default
  1473. Caller-Channel-Name: sofia/default/31855004076%40185.249.40.253
  1474. Caller-Profile-Index: 1
  1475. Caller-Profile-Created-Time: 1682489758668309
  1476. Caller-Channel-Created-Time: 1682489758668309
  1477. Caller-Channel-Answered-Time: 0
  1478. Caller-Channel-Progress-Time: 0
  1479. Caller-Channel-Progress-Media-Time: 0
  1480. Caller-Channel-Hangup-Time: 0
  1481. Caller-Channel-Transfer-Time: 0
  1482. Caller-Channel-Resurrect-Time: 0
  1483. Caller-Channel-Bridged-Time: 0
  1484. Caller-Channel-Last-Hold: 0
  1485. Caller-Channel-Hold-Accum: 0
  1486. Caller-Screen-Bit: true
  1487. Caller-Privacy-Hide-Name: false
  1488. Caller-Privacy-Hide-Number: false
  1489. variable_direction: inbound
  1490. variable_uuid: 606a9cca-5301-4d51-b564-b779fefe2470
  1491. variable_session_id: 635761
  1492. variable_sip_from_user: 31855004076
  1493. variable_sip_from_uri: 31855004076%40185.249.40.253
  1494. variable_sip_from_host: 185.249.40.253
  1495. variable_video_media_flow: disabled
  1496. variable_text_media_flow: disabled
  1497. variable_channel_name: sofia/default/31855004076%40185.249.40.253
  1498. variable_sip_call_id: 02165EC6D181400000AE8944%40UDP_5060.sbc1.controlsbc.com
  1499. variable_sip_local_network_addr: 185.249.40.236
  1500. variable_sip_network_ip: 185.249.40.253
  1501. variable_sip_network_port: 5060
  1502. variable_sip_invite_stamp: 1682489758668309
  1503. variable_sip_received_ip: 185.249.40.253
  1504. variable_sip_received_port: 5060
  1505. variable_sip_via_protocol: udp
  1506. variable_sip_authorized: true
  1507. variable_sip_acl_authed_by: default
  1508. variable_sip_from_user_stripped: 31855004076
  1509. variable_sip_from_tag: 13E13030333033309DC20501
  1510. variable_sofia_profile_name: default
  1511. variable_sofia_profile_url: sip%3Amod_sofia%40185.249.40.236%3A5060
  1512. variable_recovery_profile_name: default
  1513. variable_sip_P-Asserted-Identity: 31855004076
  1514. variable_sip_cid_type: pid
  1515. variable_sip_full_route: %3Csip%3A185.249.40.236%3A5060%3Blr%3Btransport%3Dudp%3E
  1516. variable_sip_full_via: SIP/2.0/UDP%20185.249.40.253%3A5060%3Bbranch%3Dz9hG4bKC8ACA6BA1E980C33FBCA8B44D9ADD8AC%3Brport%3D5060
  1517. variable_sip_from_display: 31855004076
  1518. variable_sip_full_from: %2231855004076%22%20%3Csip%3A31855004076%40185.249.40.253%3E%3Btag%3D13E13030333033309DC20501
  1519. variable_sip_full_to: %3Csip%3A31681405345%40185.249.40.236%3E
  1520. variable_sip_allow: INVITE,%20ACK,%20OPTIONS,%20BYE,%20CANCEL,%20REGISTER,%20INFO,%20UPDATE,%20REFER,%20SUBSCRIBE,%20NOTIFY
  1521. variable_sip_req_user: 31681405345
  1522. variable_sip_req_port: 5060
  1523. variable_sip_req_uri: 31681405345%40185.249.40.236%3A5060
  1524. variable_sip_req_host: 185.249.40.236
  1525. variable_sip_to_user: 31681405345
  1526. variable_sip_to_uri: 31681405345%40185.249.40.236
  1527. variable_sip_to_host: 185.249.40.236
  1528. variable_sip_contact_user: 31855004076
  1529. variable_sip_contact_port: 5060
  1530. variable_sip_contact_uri: 31855004076%40185.249.40.253%3A5060
  1531. variable_sip_contact_host: 185.249.40.253
  1532. variable_sip_user_agent: TBSIP
  1533. variable_sip_via_host: 185.249.40.253
  1534. variable_sip_via_port: 5060
  1535. variable_sip_via_rport: 5060
  1536. variable_max_forwards: 61
  1537. variable_presence_id: 31855004076%40185.249.40.253
  1538. variable_sip_Privacy: none
  1539. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%2016209515%201%20IN%20IP4%20185.249.40.253%0D%0As%3D-%0D%0Ac%3DIN%20IP4%20185.249.40.253%0D%0At%3D0%200%0D%0Am%3Daudio%2038378%20RTP/AVP%208%20101%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dptime%3A20%0D%0A
  1540. variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
  1541. variable_rtp_use_codec_string: PCMA,PCMU,G722
  1542. variable_remote_video_media_flow: inactive
  1543. variable_remote_text_media_flow: inactive
  1544. variable_remote_audio_media_flow: sendrecv
  1545. variable_audio_media_flow: sendrecv
  1546. variable_remote_media_ip: 185.249.40.253
  1547. variable_remote_media_port: 38378
  1548. variable_rtp_audio_recv_pt: 8
  1549. variable_rtp_use_codec_name: PCMA
  1550. variable_rtp_use_codec_rate: 8000
  1551. variable_rtp_use_codec_ptime: 20
  1552. variable_rtp_use_codec_channels: 1
  1553. variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
  1554. variable_read_codec: PCMA
  1555. variable_original_read_codec: PCMA
  1556. variable_read_rate: 8000
  1557. variable_original_read_rate: 8000
  1558. variable_write_codec: PCMA
  1559. variable_write_rate: 8000
  1560. variable_dtmf_type: rfc2833
  1561. variable_endpoint_disposition: RECEIVED
  1562. variable_call_uuid: 606a9cca-5301-4d51-b564-b779fefe2470
  1563. Hunt-Direction: inbound
  1564. Hunt-Logical-Direction: inbound
  1565. Hunt-Username: 31855004076
  1566. Hunt-Dialplan: XML
  1567. Hunt-Caller-ID-Name: 31855004076
  1568. Hunt-Caller-ID-Number: 31855004076
  1569. Hunt-Orig-Caller-ID-Name: 31855004076
  1570. Hunt-Orig-Caller-ID-Number: 31855004076
  1571. Hunt-Network-Addr: 185.249.40.253
  1572. Hunt-ANI: 31855004076
  1573. Hunt-Destination-Number: 31681405345
  1574. Hunt-Unique-ID: 606a9cca-5301-4d51-b564-b779fefe2470
  1575. Hunt-Source: mod_sofia
  1576. Hunt-Context: default
  1577. Hunt-Channel-Name: sofia/default/31855004076%40185.249.40.253
  1578. Hunt-Profile-Index: 1
  1579. Hunt-Profile-Created-Time: 1682489758668309
  1580. Hunt-Channel-Created-Time: 1682489758668309
  1581. Hunt-Channel-Answered-Time: 0
  1582. Hunt-Channel-Progress-Time: 0
  1583. Hunt-Channel-Progress-Media-Time: 0
  1584. Hunt-Channel-Hangup-Time: 0
  1585. Hunt-Channel-Transfer-Time: 0
  1586. Hunt-Channel-Resurrect-Time: 0
  1587. Hunt-Channel-Bridged-Time: 0
  1588. Hunt-Channel-Last-Hold: 0
  1589. Hunt-Channel-Hold-Accum: 0
  1590. Hunt-Screen-Bit: true
  1591. Hunt-Privacy-Hide-Name: false
  1592. Hunt-Privacy-Hide-Number: false
  1593.  
  1594.  
  1595. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_value:
  1596. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] tag_name:
  1597. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_name:
  1598. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] section: dialplan
  1599. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  1600. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 31681405345
  1601. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '31681405345' limit 1
  1602. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '31681405345' AND status=0 limit 1
  1603. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '31681405345' and status=0 LIMIT 1
  1604. 2023-04-26 08:15:58.688311 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FAXER] Custom Caller ID
  1605. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 31855004076 / 31855004076
  1606. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  1607. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="185.249.40.236" limit 1
  1608. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : outbound
  1609. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("185.249.40.253") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "31681405345"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  1610. 2023-04-26 08:15:58.688311 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 740489]
  1611. 2023-04-26 08:15:58.688311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "740489" AND deleted = 0 limit 1
  1612. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^31681405345.*' OR blocked_patterns = '^3168140534.*' OR blocked_patterns = '^316814053.*' OR blocked_patterns = '^31681405.*' OR blocked_patterns = '^3168140.*' OR blocked_patterns = '^316814.*' OR blocked_patterns = '^31681.*' OR blocked_patterns = '^3168.*' OR blocked_patterns = '^316.*' OR blocked_patterns = '^31.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 231 limit 1
  1613. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="31681405345" AND (accountid = 0 OR status = 1) LIMIT 1
  1614. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^31681405345.*' OR patterns = '^3168140534.*' OR patterns = '^316814053.*' OR patterns = '^31681405.*' OR patterns = '^3168140.*' OR patterns = '^316814.*' OR patterns = '^31681.*' OR patterns = '^3168.*' OR patterns = '^316.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 231 ORDER BY LENGTH(PKGPTR.patterns) DESC
  1615. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="31681405345" AND A.accountid = '231' limit 1
  1616. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31681405345
  1617. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  1618. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="185.249.40.236" limit 1
  1619. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call Direction : outbound
  1620. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31681405345' OR number = '3168140534' OR number = '316814053' OR number = '31681405' OR number = '3168140' OR number = '316814' OR number = '31681' OR number = '3168' OR number = '316' OR number = '31' OR number = '3' OR number ='--') OR (number = '31681405345*' OR number = '3168140534*' OR number = '316814053*' OR number = '31681405*' OR number = '3168140*' OR number = '316814*' OR number = '31681*' OR number = '3168*' OR number = '316*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  1621. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
  1622. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31681405345' OR routing_prefix = '3168140534' OR routing_prefix = '316814053' OR routing_prefix = '31681405' OR routing_prefix = '3168140' OR routing_prefix = '316814' OR routing_prefix = '31681' OR routing_prefix = '3168' OR routing_prefix = '316' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  1623. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
  1624. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 231
  1625. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 740489
  1626. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 0.1278
  1627. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  1628. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
  1629. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  1630. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  1631. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  1632. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :outbound
  1633. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  1634. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 1 OR accountid=231)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  1635. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP]  Call Direction : outbound
  1636. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
  1637. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 3590735
  1638. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.07200
  1639. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 1
  1640. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.05400
  1641. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Comment : Nederland mobiel
  1642. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 0
  1643. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 231
  1644. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk ID: 7
  1645. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Routing type:
  1646. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
  1647. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your0.1278 balance Accountid 231 !!!
  1648. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max Length Duration : 1.0333333333333 minutes
  1649. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] [DIALPLAN] User Rate ID : 3590735
  1650. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id        :7
  1651. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [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 = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (7)  AND TR.effective_date <= UTC_TIMESTAMP() ORDER by FIELD(TR.trunk_id,7),LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC,TR.effective_date DESC
  1652. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Termination Rates Information ===================
  1653. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 127133
  1654. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Code : ^3168.*
  1655. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Destination : Netherlands Mobile
  1656. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
  1657. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Free Seconds : 1
  1658. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Prefix : ^3168.*
  1659. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Strip :
  1660. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Prepend :
  1661. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Carrier id : 7
  1662. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] carrier_name : SBC1
  1663. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] dialplan_variable :
  1664. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Failover gateway : SBC2
  1665. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Vendor id : 231
  1666. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Max channels : 0
  1667. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk Name : SBCs new
  1668. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================END OF TERMINATION RATES=======================
  1669. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 231 AND status=0 LIMIT 1
  1670. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP]  Maxlength : 1.0333333333333
  1671. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  1672. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] [XML] Customer Recording Flag : 1
  1673. 2023-04-26 08:15:58.708311 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] Call Direction : outbound
  1674. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  1675. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [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 = 231) AND status=0 limit 1
  1676. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [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 = 7) AND status=0 limit 1
  1677. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Anonymous CHECK:31855004076
  1678. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  1679. 2023-04-26 08:15:58.708311 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Generated XML:
  1680. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  1681. <document type="freeswitch/xml">
  1682. <section name="dialplan" description="ASTPP Dialplan">
  1683. <context name="default">
  1684. <extension name="31681405345">
  1685. <condition field="destination_number" expression="31681405345">
  1686. <action application="set" data="effective_destination_number=31681405345"/>
  1687. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  1688. <action application="set" data="bridge_pre_execute_bleg_data=+62 normal_clearing"/>
  1689. <action application="set" data="callstart=2023-04-26 06:15:58"/>
  1690. <action application="set" data="hangup_after_bridge=true"/>
  1691. <action application="set" data="continue_on_fail=TRUE"/>
  1692. <action application="set" data="account_id=231"/>
  1693. <action application="set" data="parent_id=0"/>
  1694. <action application="set" data="entity_id=3"/>
  1695. <action application="set" data="call_processed=internal"/>
  1696. <action application="set" data="call_direction=outbound"/>
  1697. <action application="set" data="accountname=SBC1.."/>
  1698. <action application="set" data="filename1=astpp.pbx.lua"/>
  1699. <action application="set" data="origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231"/>
  1700. <action application="set" data="original_caller_id_name=31855004076"/>
  1701. <action application="set" data="original_caller_id_number=31855004076"/>
  1702.  
  1703. <action application="set" data="effective_caller_id_name=31855004076"/>
  1704. <action application="set" data="effective_caller_id_number=31855004076"/>
  1705. <action application="set" data="calltype=STANDARD"/>
  1706. <action application="set" data="termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231"/>
  1707. <action application="set" data="trunk_id=7"/>
  1708. <action application="set" data="provider_id=231"/>
  1709. <action application="set" data="rate_flag=0"/>
  1710. <action application="set" data="force_trunk_flag=3590735"/>
  1711. <action application="export" data="presence_data=trunk_id=7"/>
  1712. <action application="set" data="intcall=0"/>
  1713. <action application="export" data="presence_id=31681405345"/>
  1714. <action application="export" data="presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253"/>
  1715. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345"/>
  1716. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345"/>
  1717. </condition>
  1718. </extension>
  1719. </context>
  1720. </section>
  1721. </document>
  1722. Dialplan: sofia/default/31855004076@185.249.40.253 parsing [default->31681405345] continue=false
  1723. Dialplan: sofia/default/31855004076@185.249.40.253 Regex (PASS) [31681405345] destination_number(31681405345) =~ /31681405345/ break=on-false
  1724. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_destination_number=31681405345)
  1725. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  1726. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_data=+62 normal_clearing)
  1727. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(callstart=2023-04-26 06:15:58)
  1728. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(hangup_after_bridge=true)
  1729. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(continue_on_fail=TRUE)
  1730. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(account_id=231)
  1731. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(parent_id=0)
  1732. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(entity_id=3)
  1733. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_processed=internal)
  1734. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_direction=outbound)
  1735. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(accountname=SBC1..)
  1736. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(filename1=astpp.pbx.lua)
  1737. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231)
  1738. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_name=31855004076)
  1739. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_number=31855004076)
  1740. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_name=31855004076)
  1741. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_number=31855004076)
  1742. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(calltype=STANDARD)
  1743. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231)
  1744. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(trunk_id=7)
  1745. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(provider_id=231)
  1746. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(rate_flag=0)
  1747. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(force_trunk_flag=3590735)
  1748. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=trunk_id=7)
  1749. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(intcall=0)
  1750. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_id=31681405345)
  1751. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253)
  1752. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  1753. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345)
  1754. 2023-04-26 08:15:58.708311 [DEBUG] switch_core_state_machine.c:287 (sofia/default/31855004076@185.249.40.253) State Change CS_ROUTING -> CS_EXECUTE
  1755. 2023-04-26 08:15:58.708311 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING going to sleep
  1756. 2023-04-26 08:15:58.708311 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_EXECUTE (Cur 7 Tot 635761)
  1757. 2023-04-26 08:15:58.708311 [DEBUG] switch_core_state_machine.c:651 (sofia/default/31855004076@185.249.40.253) State EXECUTE
  1758. 2023-04-26 08:15:58.708311 [DEBUG] mod_sofia.c:209 sofia/default/31855004076@185.249.40.253 SOFIA EXECUTE
  1759. 2023-04-26 08:15:58.708311 [DEBUG] switch_core_state_machine.c:329 sofia/default/31855004076@185.249.40.253 Standard EXECUTE
  1760. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_destination_number=31681405345)
  1761. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_destination_number]=[31681405345]
  1762. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_app=sched_hangup)
  1763. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_app]=[sched_hangup]
  1764. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_data=+62 normal_clearing)
  1765. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_data]=[+62 normal_clearing]
  1766. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(callstart=2023-04-26 06:15:58)
  1767. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [callstart]=[2023-04-26 06:15:58]
  1768. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(hangup_after_bridge=true)
  1769. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [hangup_after_bridge]=[true]
  1770. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(continue_on_fail=TRUE)
  1771. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [continue_on_fail]=[TRUE]
  1772. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(account_id=231)
  1773. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [account_id]=[231]
  1774. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(parent_id=0)
  1775. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [parent_id]=[0]
  1776. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(entity_id=3)
  1777. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [entity_id]=[3]
  1778. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_processed=internal)
  1779. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_processed]=[internal]
  1780. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_direction=outbound)
  1781. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_direction]=[outbound]
  1782. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(accountname=SBC1..)
  1783. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [accountname]=[SBC1..]
  1784. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(filename1=astpp.pbx.lua)
  1785. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [filename1]=[astpp.pbx.lua]
  1786. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231)
  1787. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates]=[ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231]
  1788. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_name=31855004076)
  1789. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_name]=[31855004076]
  1790. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_number=31855004076)
  1791. 2023-04-26 08:15:58.708311 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_number]=[31855004076]
  1792. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_name=31855004076)
  1793. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_name]=[31855004076]
  1794. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_number=31855004076)
  1795. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_number]=[31855004076]
  1796. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(calltype=STANDARD)
  1797. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [calltype]=[STANDARD]
  1798. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231)
  1799. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [termination_rates]=[ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231]
  1800. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(trunk_id=7)
  1801. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [trunk_id]=[7]
  1802. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(provider_id=231)
  1803. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [provider_id]=[231]
  1804. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(rate_flag=0)
  1805. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [rate_flag]=[0]
  1806. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(force_trunk_flag=3590735)
  1807. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [force_trunk_flag]=[3590735]
  1808. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=trunk_id=7)
  1809. 2023-04-26 08:15:58.728314 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[trunk_id=7]
  1810. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(intcall=0)
  1811. 2023-04-26 08:15:58.728314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [intcall]=[0]
  1812. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_id=31681405345)
  1813. 2023-04-26 08:15:58.728314 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_id]=[31681405345]
  1814. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253)
  1815. 2023-04-26 08:15:58.728314 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253]
  1816. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  1817. 2023-04-26 08:15:58.728314 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253] to event
  1818. 2023-04-26 08:15:58.728314 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_id]=[31681405345] to event
  1819. 2023-04-26 08:15:58.728314 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253] to event
  1820. 2023-04-26 08:15:58.728314 [DEBUG] switch_ivr_originate.c:2242 Parsing global variables
  1821. 2023-04-26 08:15:58.728314 [DEBUG] switch_ivr_originate.c:2804 Parsing session specific variables
  1822. 2023-04-26 08:15:58.728314 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31681405345 [df0a6153-6178-4e1b-9038-8cad1faacfc4]
  1823. 2023-04-26 08:15:58.728314 [DEBUG] mod_sofia.c:5089 (sofia/default/31681405345) State Change CS_NEW -> CS_INIT
  1824. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_INIT (Cur 8 Tot 635762)
  1825. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT
  1826. 2023-04-26 08:15:58.728314 [DEBUG] mod_sofia.c:93 sofia/default/31681405345 SOFIA INIT
  1827. 2023-04-26 08:15:58.728314 [DEBUG] sofia_glue.c:1618 sofia/default/31681405345 sending invite version: 1.10.5 -release-17-25569c1631 64bit
  1828. Local SDP:
  1829. v=0
  1830. o=FreeSWITCH 1682464940 1682464941 IN IP4 185.249.40.236
  1831. s=FreeSWITCH
  1832. c=IN IP4 185.249.40.236
  1833. t=0 0
  1834. m=audio 24818 RTP/AVP 8 101
  1835. a=rtpmap:8 PCMA/8000
  1836. a=rtpmap:101 telephone-event/8000
  1837. a=fmtp:101 0-16
  1838. a=ptime:20
  1839. a=sendrecv
  1840.  
  1841. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:40 sofia/default/31681405345 Standard INIT
  1842. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31681405345) State Change CS_INIT -> CS_ROUTING
  1843. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT going to sleep
  1844. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_ROUTING (Cur 8 Tot 635762)
  1845. 2023-04-26 08:15:58.728314 [DEBUG] sofia.c:7326 Channel sofia/default/31681405345 entering state [calling][0]
  1846. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING
  1847. 2023-04-26 08:15:58.728314 [DEBUG] mod_sofia.c:154 sofia/default/31681405345 SOFIA ROUTING
  1848. 2023-04-26 08:15:58.728314 [DEBUG] switch_ivr_originate.c:67 (sofia/default/31681405345) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  1849. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING going to sleep
  1850. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_CONSUME_MEDIA (Cur 8 Tot 635762)
  1851. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:663 (sofia/default/31681405345) State CONSUME_MEDIA
  1852. 2023-04-26 08:15:58.728314 [DEBUG] switch_core_state_machine.c:663 (sofia/default/31681405345) State CONSUME_MEDIA going to sleep
  1853. 2023-04-26 08:15:58.848312 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31855004076@185.249.40.253 [c4dfbbd7-11f4-444b-b3ea-ba85beff3245]
  1854. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_NEW (Cur 9 Tot 635763)
  1855. 2023-04-26 08:15:58.848312 [DEBUG] sofia.c:10280 sofia/default/31855004076@185.249.40.253 receiving invite from 185.249.40.253:5060 version: 1.10.5 -release-17-25569c1631 64bit
  1856. 2023-04-26 08:15:58.848312 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 185.249.40.253:0.
  1857. 2023-04-26 08:15:58.848312 [DEBUG] sofia.c:10403 IP 185.249.40.253 Approved by acl "default[]". Access Granted.
  1858. 2023-04-26 08:15:58.848312 [DEBUG] sofia.c:7326 Channel sofia/default/31855004076@185.249.40.253 entering state [received][100]
  1859. 2023-04-26 08:15:58.848312 [DEBUG] sofia.c:7336 Remote SDP:
  1860. v=0
  1861. o=- 16209518 1 IN IP4 185.249.40.253
  1862. s=-
  1863. c=IN IP4 185.249.40.253
  1864. t=0 0
  1865. m=audio 38384 RTP/AVP 8 101
  1866. a=rtpmap:101 telephone-event/8000
  1867. a=ptime:20
  1868.  
  1869. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  1870. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  1871. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  1872. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G722:9:8000:20:64000:1]
  1873. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 101@8000
  1874. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/31855004076@185.249.40.253 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  1875. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_codec.c:111 sofia/default/31855004076@185.249.40.253 Original read codec set to PCMA:8
  1876. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000
  1877. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_media.c:5911 sofia/default/31855004076@185.249.40.253 Set 2833 dtmf send payload to 101 recv payload to 101
  1878. 2023-04-26 08:15:58.848312 [DEBUG] sofia.c:7760 (sofia/default/31855004076@185.249.40.253) State Change CS_NEW -> CS_INIT
  1879. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:604 (sofia/default/31855004076@185.249.40.253) State NEW
  1880. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_INIT (Cur 9 Tot 635763)
  1881. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31855004076@185.249.40.253) State INIT
  1882. 2023-04-26 08:15:58.848312 [DEBUG] mod_sofia.c:93 sofia/default/31855004076@185.249.40.253 SOFIA INIT
  1883. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:40 sofia/default/31855004076@185.249.40.253 Standard INIT
  1884. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31855004076@185.249.40.253) State Change CS_INIT -> CS_ROUTING
  1885. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31855004076@185.249.40.253) State INIT going to sleep
  1886. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_ROUTING (Cur 9 Tot 635763)
  1887. 2023-04-26 08:15:58.848312 [DEBUG] switch_channel.c:2332 (sofia/default/31855004076@185.249.40.253) Callstate Change DOWN -> RINGING
  1888. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING
  1889. 2023-04-26 08:15:58.848312 [DEBUG] mod_sofia.c:154 sofia/default/31855004076@185.249.40.253 SOFIA ROUTING
  1890. 2023-04-26 08:15:58.848312 [DEBUG] switch_core_state_machine.c:236 sofia/default/31855004076@185.249.40.253 Standard ROUTING
  1891. 2023-04-26 08:15:58.848312 [INFO] mod_dialplan_xml.c:637 Processing 31855004076 <31855004076>->31681405345 in context default
  1892. 2023-04-26 08:15:58.848312 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  1893. 2023-04-26 08:15:58.848312 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  1894. 2023-04-26 08:15:58.868334 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [xml_handler] Params:
  1895. Event-Name: REQUEST_PARAMS
  1896. Core-UUID: ea9d74c5-64c7-47f9-8036-72e9783891f2
  1897. FreeSWITCH-Hostname: multitenant-1
  1898. FreeSWITCH-Switchname: multitenant-1
  1899. FreeSWITCH-IPv4: 185.249.40.236
  1900. FreeSWITCH-IPv6: %3A%3A1
  1901. Event-Date-Local: 2023-04-26%2008%3A15%3A58
  1902. Event-Date-GMT: Wed,%2026%20Apr%202023%2006%3A15%3A58%20GMT
  1903. Event-Date-Timestamp: 1682489758848312
  1904. Event-Calling-File: mod_dialplan_xml.c
  1905. Event-Calling-Function: dialplan_xml_locate
  1906. Event-Calling-Line-Number: 608
  1907. Event-Sequence: 52519187
  1908. Channel-State: CS_ROUTING
  1909. Channel-Call-State: RINGING
  1910. Channel-State-Number: 2
  1911. Channel-Name: sofia/default/31855004076%40185.249.40.253
  1912. Unique-ID: c4dfbbd7-11f4-444b-b3ea-ba85beff3245
  1913. Call-Direction: inbound
  1914. Presence-Call-Direction: inbound
  1915. Channel-HIT-Dialplan: true
  1916. Channel-Presence-ID: 31855004076%40185.249.40.253
  1917. Channel-Call-UUID: c4dfbbd7-11f4-444b-b3ea-ba85beff3245
  1918. Answer-State: ringing
  1919. Channel-Read-Codec-Name: PCMA
  1920. Channel-Read-Codec-Rate: 8000
  1921. Channel-Read-Codec-Bit-Rate: 64000
  1922. Channel-Write-Codec-Name: PCMA
  1923. Channel-Write-Codec-Rate: 8000
  1924. Channel-Write-Codec-Bit-Rate: 64000
  1925. Caller-Direction: inbound
  1926. Caller-Logical-Direction: inbound
  1927. Caller-Username: 31855004076
  1928. Caller-Dialplan: XML
  1929. Caller-Caller-ID-Name: 31855004076
  1930. Caller-Caller-ID-Number: 31855004076
  1931. Caller-Orig-Caller-ID-Name: 31855004076
  1932. Caller-Orig-Caller-ID-Number: 31855004076
  1933. Caller-Network-Addr: 185.249.40.253
  1934. Caller-ANI: 31855004076
  1935. Caller-Destination-Number: 31681405345
  1936. Caller-Unique-ID: c4dfbbd7-11f4-444b-b3ea-ba85beff3245
  1937. Caller-Source: mod_sofia
  1938. Caller-Context: default
  1939. Caller-Channel-Name: sofia/default/31855004076%40185.249.40.253
  1940. Caller-Profile-Index: 1
  1941. Caller-Profile-Created-Time: 1682489758848312
  1942. Caller-Channel-Created-Time: 1682489758848312
  1943. Caller-Channel-Answered-Time: 0
  1944. Caller-Channel-Progress-Time: 0
  1945. Caller-Channel-Progress-Media-Time: 0
  1946. Caller-Channel-Hangup-Time: 0
  1947. Caller-Channel-Transfer-Time: 0
  1948. Caller-Channel-Resurrect-Time: 0
  1949. Caller-Channel-Bridged-Time: 0
  1950. Caller-Channel-Last-Hold: 0
  1951. Caller-Channel-Hold-Accum: 0
  1952. Caller-Screen-Bit: true
  1953. Caller-Privacy-Hide-Name: false
  1954. Caller-Privacy-Hide-Number: false
  1955. variable_direction: inbound
  1956. variable_uuid: c4dfbbd7-11f4-444b-b3ea-ba85beff3245
  1957. variable_session_id: 635763
  1958. variable_sip_from_user: 31855004076
  1959. variable_sip_from_uri: 31855004076%40185.249.40.253
  1960. variable_sip_from_host: 185.249.40.253
  1961. variable_video_media_flow: disabled
  1962. variable_text_media_flow: disabled
  1963. variable_channel_name: sofia/default/31855004076%40185.249.40.253
  1964. variable_sip_call_id: 02165EC6D181400000AE8946%40UDP_5060.sbc1.controlsbc.com
  1965. variable_sip_local_network_addr: 185.249.40.236
  1966. variable_sip_network_ip: 185.249.40.253
  1967. variable_sip_network_port: 5060
  1968. variable_sip_invite_stamp: 1682489758848312
  1969. variable_sip_received_ip: 185.249.40.253
  1970. variable_sip_received_port: 5060
  1971. variable_sip_via_protocol: udp
  1972. variable_sip_authorized: true
  1973. variable_sip_acl_authed_by: default
  1974. variable_sip_from_user_stripped: 31855004076
  1975. variable_sip_from_tag: F7D73030333033309FC20501
  1976. variable_sofia_profile_name: default
  1977. variable_sofia_profile_url: sip%3Amod_sofia%40185.249.40.236%3A5060
  1978. variable_recovery_profile_name: default
  1979. variable_sip_P-Asserted-Identity: 31855004076
  1980. variable_sip_cid_type: pid
  1981. variable_sip_full_route: %3Csip%3A185.249.40.236%3A5060%3Blr%3Btransport%3Dudp%3E
  1982. variable_sip_full_via: SIP/2.0/UDP%20185.249.40.253%3A5060%3Bbranch%3Dz9hG4bK57C83C79A31EC231B4126A248176DD89%3Brport%3D5060
  1983. variable_sip_from_display: 31855004076
  1984. variable_sip_full_from: %2231855004076%22%20%3Csip%3A31855004076%40185.249.40.253%3E%3Btag%3DF7D73030333033309FC20501
  1985. variable_sip_full_to: %3Csip%3A31681405345%40185.249.40.236%3E
  1986. variable_sip_allow: INVITE,%20ACK,%20OPTIONS,%20BYE,%20CANCEL,%20REGISTER,%20INFO,%20UPDATE,%20REFER,%20SUBSCRIBE,%20NOTIFY
  1987. variable_sip_req_user: 31681405345
  1988. variable_sip_req_port: 5060
  1989. variable_sip_req_uri: 31681405345%40185.249.40.236%3A5060
  1990. variable_sip_req_host: 185.249.40.236
  1991. variable_sip_to_user: 31681405345
  1992. variable_sip_to_uri: 31681405345%40185.249.40.236
  1993. variable_sip_to_host: 185.249.40.236
  1994. variable_sip_contact_user: 31855004076
  1995. variable_sip_contact_port: 5060
  1996. variable_sip_contact_uri: 31855004076%40185.249.40.253%3A5060
  1997. variable_sip_contact_host: 185.249.40.253
  1998. variable_sip_user_agent: TBSIP
  1999. variable_sip_via_host: 185.249.40.253
  2000. variable_sip_via_port: 5060
  2001. variable_sip_via_rport: 5060
  2002. variable_max_forwards: 58
  2003. variable_presence_id: 31855004076%40185.249.40.253
  2004. variable_sip_Privacy: none
  2005. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%2016209518%201%20IN%20IP4%20185.249.40.253%0D%0As%3D-%0D%0Ac%3DIN%20IP4%20185.249.40.253%0D%0At%3D0%200%0D%0Am%3Daudio%2038384%20RTP/AVP%208%20101%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dptime%3A20%0D%0A
  2006. variable_ep_codec_string: CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
  2007. variable_rtp_use_codec_string: PCMA,PCMU,G722
  2008. variable_remote_video_media_flow: inactive
  2009. variable_remote_text_media_flow: inactive
  2010. variable_remote_audio_media_flow: sendrecv
  2011. variable_audio_media_flow: sendrecv
  2012. variable_remote_media_ip: 185.249.40.253
  2013. variable_remote_media_port: 38384
  2014. variable_rtp_audio_recv_pt: 8
  2015. variable_rtp_use_codec_name: PCMA
  2016. variable_rtp_use_codec_rate: 8000
  2017. variable_rtp_use_codec_ptime: 20
  2018. variable_rtp_use_codec_channels: 1
  2019. variable_rtp_last_audio_codec_string: PCMA%408000h%4020i%401c
  2020. variable_read_codec: PCMA
  2021. variable_original_read_codec: PCMA
  2022. variable_read_rate: 8000
  2023. variable_original_read_rate: 8000
  2024. variable_write_codec: PCMA
  2025. variable_write_rate: 8000
  2026. variable_dtmf_type: rfc2833
  2027. variable_endpoint_disposition: RECEIVED
  2028. variable_call_uuid: c4dfbbd7-11f4-444b-b3ea-ba85beff3245
  2029. Hunt-Direction: inbound
  2030. Hunt-Logical-Direction: inbound
  2031. Hunt-Username: 31855004076
  2032. Hunt-Dialplan: XML
  2033. Hunt-Caller-ID-Name: 31855004076
  2034. Hunt-Caller-ID-Number: 31855004076
  2035. Hunt-Orig-Caller-ID-Name: 31855004076
  2036. Hunt-Orig-Caller-ID-Number: 31855004076
  2037. Hunt-Network-Addr: 185.249.40.253
  2038. Hunt-ANI: 31855004076
  2039. Hunt-Destination-Number: 31681405345
  2040. Hunt-Unique-ID: c4dfbbd7-11f4-444b-b3ea-ba85beff3245
  2041. Hunt-Source: mod_sofia
  2042. Hunt-Context: default
  2043. Hunt-Channel-Name: sofia/default/31855004076%40185.249.40.253
  2044. Hunt-Profile-Index: 1
  2045. Hunt-Profile-Created-Time: 1682489758848312
  2046. Hunt-Channel-Created-Time: 1682489758848312
  2047. Hunt-Channel-Answered-Time: 0
  2048. Hunt-Channel-Progress-Time: 0
  2049. Hunt-Channel-Progress-Media-Time: 0
  2050. Hunt-Channel-Hangup-Time: 0
  2051. Hunt-Channel-Transfer-Time: 0
  2052. Hunt-Channel-Resurrect-Time: 0
  2053. Hunt-Channel-Bridged-Time: 0
  2054. Hunt-Channel-Last-Hold: 0
  2055. Hunt-Channel-Hold-Accum: 0
  2056. Hunt-Screen-Bit: true
  2057. Hunt-Privacy-Hide-Name: false
  2058. Hunt-Privacy-Hide-Number: false
  2059.  
  2060.  
  2061. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_value:
  2062. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] section: dialplan
  2063. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] key_name:
  2064. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [xml_REQUEST] tag_name:
  2065. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  2066. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 31681405345
  2067. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '31681405345' limit 1
  2068. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '31681405345' AND status=0 limit 1
  2069. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '31681405345' and status=0 LIMIT 1
  2070. 2023-04-26 08:15:58.868334 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FAXER] Custom Caller ID
  2071. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 31855004076 / 31855004076
  2072. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  2073. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="185.249.40.236" limit 1
  2074. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : outbound
  2075. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("185.249.40.253") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "31681405345"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  2076. 2023-04-26 08:15:58.868334 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 740489]
  2077. 2023-04-26 08:15:58.868334 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "740489" AND deleted = 0 limit 1
  2078. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^31681405345.*' OR blocked_patterns = '^3168140534.*' OR blocked_patterns = '^316814053.*' OR blocked_patterns = '^31681405.*' OR blocked_patterns = '^3168140.*' OR blocked_patterns = '^316814.*' OR blocked_patterns = '^31681.*' OR blocked_patterns = '^3168.*' OR blocked_patterns = '^316.*' OR blocked_patterns = '^31.*' OR blocked_patterns = '^3.*' OR blocked_patterns ='--') AND accountid = 231 limit 1
  2079. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="31681405345" AND (accountid = 0 OR status = 1) LIMIT 1
  2080. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^31681405345.*' OR patterns = '^3168140534.*' OR patterns = '^316814053.*' OR patterns = '^31681405.*' OR patterns = '^3168140.*' OR patterns = '^316814.*' OR patterns = '^31681.*' OR patterns = '^3168.*' OR patterns = '^316.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 231 ORDER BY LENGTH(PKGPTR.patterns) DESC
  2081. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="31681405345" AND A.accountid = '231' limit 1
  2082. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31681405345
  2083. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  2084. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="31681405345"  AND domains.domain="185.249.40.236" limit 1
  2085. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call Direction : outbound
  2086. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31681405345' OR number = '3168140534' OR number = '316814053' OR number = '31681405' OR number = '3168140' OR number = '316814' OR number = '31681' OR number = '3168' OR number = '316' OR number = '31' OR number = '3' OR number ='--') OR (number = '31681405345*' OR number = '3168140534*' OR number = '316814053*' OR number = '31681405*' OR number = '3168140*' OR number = '316814*' OR number = '31681*' OR number = '3168*' OR number = '316*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  2087. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
  2088. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31681405345' OR routing_prefix = '3168140534' OR routing_prefix = '316814053' OR routing_prefix = '31681405' OR routing_prefix = '3168140' OR routing_prefix = '316814' OR routing_prefix = '31681' OR routing_prefix = '3168' OR routing_prefix = '316' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  2089. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
  2090. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 231
  2091. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 740489
  2092. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 0.1278
  2093. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  2094. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
  2095. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  2096. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  2097. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  2098. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :outbound
  2099. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  2100. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 1 OR accountid=231)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  2101. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP]  Call Direction : outbound
  2102. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Rates Information ===================
  2103. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 3590735
  2104. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.07200
  2105. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds : 1
  2106. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.05400
  2107. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Comment : Nederland mobiel
  2108. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 0
  2109. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 231
  2110. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk ID: 7
  2111. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Routing type:
  2112. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] ================================================================
  2113. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Your0.1278 balance Accountid 231 !!!
  2114. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max Length Duration : 1.0333333333333 minutes
  2115. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] [DIALPLAN] User Rate ID : 3590735
  2116. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id        :7
  2117. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [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 = '^31681405345.*' OR pattern = '^3168140534.*' OR pattern = '^316814053.*' OR pattern = '^31681405.*' OR pattern = '^3168140.*' OR pattern = '^316814.*' OR pattern = '^31681.*' OR pattern = '^3168.*' OR pattern = '^316.*' OR pattern = '^31.*' OR pattern = '^3.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (7)  AND TR.effective_date <= UTC_TIMESTAMP() ORDER by FIELD(TR.trunk_id,7),LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC,TR.effective_date DESC
  2118. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Termination Rates Information ===================
  2119. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 127133
  2120. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Code : ^3168.*
  2121. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Destination : Netherlands Mobile
  2122. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00000
  2123. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Free Seconds : 1
  2124. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Prefix : ^3168.*
  2125. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Strip :
  2126. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Prepend :
  2127. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Carrier id : 7
  2128. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] carrier_name : SBC1
  2129. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] dialplan_variable :
  2130. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Failover gateway : SBC2
  2131. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Vendor id : 231
  2132. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Max channels : 0
  2133. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] Trunk Name : SBCs new
  2134. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================END OF TERMINATION RATES=======================
  2135. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 231 AND status=0 LIMIT 1
  2136. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP]  Maxlength : 1.0333333333333
  2137. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  2138. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] [XML] Customer Recording Flag : 1
  2139. 2023-04-26 08:15:58.888313 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] Call Direction : outbound
  2140. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  2141. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [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 = 231) AND status=0 limit 1
  2142. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [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 = 7) AND status=0 limit 1
  2143. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Anonymous CHECK:31855004076
  2144. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31681405345" LIMIT 1
  2145. 2023-04-26 08:15:58.888313 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Generated XML:
  2146. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  2147. <document type="freeswitch/xml">
  2148. <section name="dialplan" description="ASTPP Dialplan">
  2149. <context name="default">
  2150. <extension name="31681405345">
  2151. <condition field="destination_number" expression="31681405345">
  2152. <action application="set" data="effective_destination_number=31681405345"/>
  2153. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  2154. <action application="set" data="bridge_pre_execute_bleg_data=+62 normal_clearing"/>
  2155. <action application="set" data="callstart=2023-04-26 06:15:58"/>
  2156. <action application="set" data="hangup_after_bridge=true"/>
  2157. <action application="set" data="continue_on_fail=TRUE"/>
  2158. <action application="set" data="account_id=231"/>
  2159. <action application="set" data="parent_id=0"/>
  2160. <action application="set" data="entity_id=3"/>
  2161. <action application="set" data="call_processed=internal"/>
  2162. <action application="set" data="call_direction=outbound"/>
  2163. <action application="set" data="accountname=SBC1.."/>
  2164. <action application="set" data="filename1=astpp.pbx.lua"/>
  2165. <action application="set" data="origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231"/>
  2166. <action application="set" data="original_caller_id_name=31855004076"/>
  2167. <action application="set" data="original_caller_id_number=31855004076"/>
  2168.  
  2169. <action application="set" data="effective_caller_id_name=31855004076"/>
  2170. <action application="set" data="effective_caller_id_number=31855004076"/>
  2171. <action application="set" data="calltype=STANDARD"/>
  2172. <action application="set" data="termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231"/>
  2173. <action application="set" data="trunk_id=7"/>
  2174. <action application="set" data="provider_id=231"/>
  2175. <action application="set" data="rate_flag=0"/>
  2176. <action application="set" data="force_trunk_flag=3590735"/>
  2177. <action application="export" data="presence_data=trunk_id=7"/>
  2178. <action application="set" data="intcall=0"/>
  2179. <action application="export" data="presence_id=31681405345"/>
  2180. <action application="export" data="presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253"/>
  2181. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345"/>
  2182. <action application="bridge" data="[leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345"/>
  2183. </condition>
  2184. </extension>
  2185. </context>
  2186. </section>
  2187. </document>
  2188. Dialplan: sofia/default/31855004076@185.249.40.253 parsing [default->31681405345] continue=false
  2189. Dialplan: sofia/default/31855004076@185.249.40.253 Regex (PASS) [31681405345] destination_number(31681405345) =~ /31681405345/ break=on-false
  2190. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_destination_number=31681405345)
  2191. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  2192. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(bridge_pre_execute_bleg_data=+62 normal_clearing)
  2193. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(callstart=2023-04-26 06:15:58)
  2194. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(hangup_after_bridge=true)
  2195. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(continue_on_fail=TRUE)
  2196. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(account_id=231)
  2197. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(parent_id=0)
  2198. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(entity_id=3)
  2199. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_processed=internal)
  2200. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(call_direction=outbound)
  2201. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(accountname=SBC1..)
  2202. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(filename1=astpp.pbx.lua)
  2203. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231)
  2204. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_name=31855004076)
  2205. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(original_caller_id_number=31855004076)
  2206. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_name=31855004076)
  2207. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(effective_caller_id_number=31855004076)
  2208. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(calltype=STANDARD)
  2209. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231)
  2210. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(trunk_id=7)
  2211. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(provider_id=231)
  2212. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(rate_flag=0)
  2213. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(force_trunk_flag=3590735)
  2214. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=trunk_id=7)
  2215. Dialplan: sofia/default/31855004076@185.249.40.253 Action set(intcall=0)
  2216. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_id=31681405345)
  2217. Dialplan: sofia/default/31855004076@185.249.40.253 Action export(presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253)
  2218. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  2219. Dialplan: sofia/default/31855004076@185.249.40.253 Action bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC2/31681405345)
  2220. 2023-04-26 08:15:58.888313 [DEBUG] switch_core_state_machine.c:287 (sofia/default/31855004076@185.249.40.253) State Change CS_ROUTING -> CS_EXECUTE
  2221. 2023-04-26 08:15:58.888313 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31855004076@185.249.40.253) State ROUTING going to sleep
  2222. 2023-04-26 08:15:58.888313 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31855004076@185.249.40.253) Running State Change CS_EXECUTE (Cur 9 Tot 635763)
  2223. 2023-04-26 08:15:58.888313 [DEBUG] switch_core_state_machine.c:651 (sofia/default/31855004076@185.249.40.253) State EXECUTE
  2224. 2023-04-26 08:15:58.888313 [DEBUG] mod_sofia.c:209 sofia/default/31855004076@185.249.40.253 SOFIA EXECUTE
  2225. 2023-04-26 08:15:58.888313 [DEBUG] switch_core_state_machine.c:329 sofia/default/31855004076@185.249.40.253 Standard EXECUTE
  2226. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_destination_number=31681405345)
  2227. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_destination_number]=[31681405345]
  2228. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_app=sched_hangup)
  2229. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_app]=[sched_hangup]
  2230. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(bridge_pre_execute_bleg_data=+62 normal_clearing)
  2231. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [bridge_pre_execute_bleg_data]=[+62 normal_clearing]
  2232. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(callstart=2023-04-26 06:15:58)
  2233. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [callstart]=[2023-04-26 06:15:58]
  2234. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(hangup_after_bridge=true)
  2235. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [hangup_after_bridge]=[true]
  2236. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(continue_on_fail=TRUE)
  2237. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [continue_on_fail]=[TRUE]
  2238. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(account_id=231)
  2239. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [account_id]=[231]
  2240. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(parent_id=0)
  2241. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [parent_id]=[0]
  2242. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(entity_id=3)
  2243. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [entity_id]=[3]
  2244. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_processed=internal)
  2245. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_processed]=[internal]
  2246. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(call_direction=outbound)
  2247. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [call_direction]=[outbound]
  2248. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(accountname=SBC1..)
  2249. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [accountname]=[SBC1..]
  2250. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(filename1=astpp.pbx.lua)
  2251. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [filename1]=[astpp.pbx.lua]
  2252. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(origination_rates=ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231)
  2253. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [origination_rates]=[ID:3590735|CODE:^3168.*|DESTINATION:Nederland mobiel|CONNECTIONCOST:0.07200|INCLUDEDSECONDS:1|CT:|COST:0.05400|INC:60|INITIALBLOCK:60|RATEGROUP:1|MARKUP:0|CI:0|ACCID:231]
  2254. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_name=31855004076)
  2255. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_name]=[31855004076]
  2256. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(original_caller_id_number=31855004076)
  2257. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [original_caller_id_number]=[31855004076]
  2258. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_name=31855004076)
  2259. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_name]=[31855004076]
  2260. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(effective_caller_id_number=31855004076)
  2261. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [effective_caller_id_number]=[31855004076]
  2262. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(calltype=STANDARD)
  2263. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [calltype]=[STANDARD]
  2264. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(termination_rates=ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231)
  2265. 2023-04-26 08:15:58.888313 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [termination_rates]=[ID:127133|CODE:^3168.*|DESTINATION:Netherlands Mobile|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:1|COST:0.00065|INC:1|INITIALBLOCK:1|TRUNK:7|PROVIDER:231]
  2266. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(trunk_id=7)
  2267. 2023-04-26 08:15:58.908314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [trunk_id]=[7]
  2268. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(provider_id=231)
  2269. 2023-04-26 08:15:58.908314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [provider_id]=[231]
  2270. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(rate_flag=0)
  2271. 2023-04-26 08:15:58.908314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [rate_flag]=[0]
  2272. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(force_trunk_flag=3590735)
  2273. 2023-04-26 08:15:58.908314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [force_trunk_flag]=[3590735]
  2274. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=trunk_id=7)
  2275. 2023-04-26 08:15:58.908314 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[trunk_id=7]
  2276. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 set(intcall=0)
  2277. 2023-04-26 08:15:58.908314 [DEBUG] mod_dptools.c:1672 SET sofia/default/31855004076@185.249.40.253 [intcall]=[0]
  2278. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_id=31681405345)
  2279. 2023-04-26 08:15:58.908314 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_id]=[31681405345]
  2280. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 export(presence_data=x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253)
  2281. 2023-04-26 08:15:58.908314 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253]
  2282. EXECUTE [depth=0] sofia/default/31855004076@185.249.40.253 bridge([leg_timeout=0,absolute_codec_string=^^:PCMA]sofia/gateway/SBC1/31681405345)
  2283. 2023-04-26 08:15:58.908314 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253] to event
  2284. 2023-04-26 08:15:58.908314 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_id]=[31681405345] to event
  2285. 2023-04-26 08:15:58.908314 [DEBUG] switch_channel.c:1264 sofia/default/31855004076@185.249.40.253 EXPORTING[export_vars] [presence_data]=[x|||Carrier_two_trunks(740489)|||^3168.* // Nederland mobiel // 0.05400 |||SBCs new // ^3168.* // Netherlands Mobile // 0.00065 // trunk_id=7|||STD|||185.249.40.253] to event
  2286. 2023-04-26 08:15:58.908314 [DEBUG] switch_ivr_originate.c:2242 Parsing global variables
  2287. 2023-04-26 08:15:58.908314 [DEBUG] switch_ivr_originate.c:2804 Parsing session specific variables
  2288. 2023-04-26 08:15:58.908314 [NOTICE] switch_channel.c:1118 New Channel sofia/default/31681405345 [80322c59-e289-4636-b511-6fe3b444f2d2]
  2289. 2023-04-26 08:15:58.908314 [DEBUG] mod_sofia.c:5089 (sofia/default/31681405345) State Change CS_NEW -> CS_INIT
  2290. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_INIT (Cur 10 Tot 635764)
  2291. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT
  2292. 2023-04-26 08:15:58.908314 [DEBUG] mod_sofia.c:93 sofia/default/31681405345 SOFIA INIT
  2293. 2023-04-26 08:15:58.908314 [DEBUG] sofia_glue.c:1618 sofia/default/31681405345 sending invite version: 1.10.5 -release-17-25569c1631 64bit
  2294. Local SDP:
  2295. v=0
  2296. o=FreeSWITCH 1682472284 1682472285 IN IP4 185.249.40.236
  2297. s=FreeSWITCH
  2298. c=IN IP4 185.249.40.236
  2299. t=0 0
  2300. m=audio 17474 RTP/AVP 8 101
  2301. a=rtpmap:8 PCMA/8000
  2302. a=rtpmap:101 telephone-event/8000
  2303. a=fmtp:101 0-16
  2304. a=ptime:20
  2305. a=sendrecv
  2306.  
  2307. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:40 sofia/default/31681405345 Standard INIT
  2308. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:48 (sofia/default/31681405345) State Change CS_INIT -> CS_ROUTING
  2309. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:628 (sofia/default/31681405345) State INIT going to sleep
  2310. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:585 (sofia/default/31681405345) Running State Change CS_ROUTING (Cur 10 Tot 635764)
  2311. 2023-04-26 08:15:58.908314 [DEBUG] sofia.c:7326 Channel sofia/default/31681405345 entering state [calling][0]
  2312. 2023-04-26 08:15:58.908314 [DEBUG] switch_core_state_machine.c:644 (sofia/default/31681405345) State ROUTING
  2313. 2023-04-26 08:15:58.908314 [DEBUG] mod_sofia.c:154 sofia/default/31681405345 SOFIA ROUTING
  2314. 2023-04-26 08:15:58.908314 [DEBUG] switch_ivr_originate.c:67 (sofia/default/31681405345) State Change CS_ROUTING -> CS_CONSUME_MEDIA