FreeSWITCH Pastebin

Gerald-TR_not_found

From Devang, 5 Years ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/85c17a35
Embed
Download Paste or View Raw
  1. span style="color: goldenrod; font-weight: bold;"> 2019-04-30 12:22:57.674080 [DEBUG] sofia.c:9873 sofia/default/18323352735@login.lugertel.com receiving invite from 166.173.61.47:22516 version: 1.6.19 git 7a77e0b 2017-07-13 12:01:45Z 64bit
  2. 2019-04-30 12:22:57.674080 [DEBUG] sofia.c:10044 IP 166.173.61.47 Rejected by acl "default". Falling back to Digest auth.
  3. 2019-04-30 12:22:57.694002 [DEBUG] sofia.c:7084 Channel sofia/default/18323352735@login.lugertel.com entering state [received][100]
  4. 2019-04-30 12:22:57.694002 [DEBUG] sofia.c:7094 Remote SDP:
  5. v=0
  6. o=- 3765633777 3765633777 IN IP4 10.199.189.217
  7. s=pjmedia
  8. b=AS:84
  9. t=0 0
  10. a=X-nat:0
  11. m=audio 4000 RTP/AVP 0 8 96
  12. c=IN IP4 10.199.189.217
  13. b=TIAS:64000
  14. a=rtpmap:0 PCMU/8000
  15. a=rtpmap:8 PCMA/8000
  16. a=rtpmap:96 telephone-event/8000
  17. a=fmtp:96 0-16
  18. a=rtcp:4001 IN IP4 10.199.189.217
  19.  
  20. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  21. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  22. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  23. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  24. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  25. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4504 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  26. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  27. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4449 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  28. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4365 Set telephone-event payload to 96@8000
  29. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:3061 Set Codec sofia/default/18323352735@login.lugertel.com PCMU/8000 20 ms 160 samples 64000 bits 1 channels
  30. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_codec.c:111 sofia/default/18323352735@login.lugertel.com Original read codec set to PCMU:0
  31. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4708 Set telephone-event payload to 96@8000
  32. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_media.c:4767 sofia/default/18323352735@login.lugertel.com Set 2833 dtmf send payload to 96 recv payload to 96
  33. 2019-04-30 12:22:57.694002 [DEBUG] sofia.c:7507 (sofia/default/18323352735@login.lugertel.com) State Change CS_NEW -> CS_INIT
  34. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:584 (sofia/default/18323352735@login.lugertel.com) Running State Change CS_INIT (Cur 1 Tot 123782)
  35. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:627 (sofia/default/18323352735@login.lugertel.com) State INIT
  36. 2019-04-30 12:22:57.694002 [DEBUG] mod_sofia.c:90 sofia/default/18323352735@login.lugertel.com SOFIA INIT
  37. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:40 sofia/default/18323352735@login.lugertel.com Standard INIT
  38. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:48 (sofia/default/18323352735@login.lugertel.com) State Change CS_INIT -> CS_ROUTING
  39. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:627 (sofia/default/18323352735@login.lugertel.com) State INIT going to sleep
  40. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:584 (sofia/default/18323352735@login.lugertel.com) Running State Change CS_ROUTING (Cur 1 Tot 123782)
  41. 2019-04-30 12:22:57.694002 [DEBUG] switch_channel.c:2249 (sofia/default/18323352735@login.lugertel.com) Callstate Change DOWN -> RINGING
  42. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:643 (sofia/default/18323352735@login.lugertel.com) State ROUTING
  43. 2019-04-30 12:22:57.694002 [DEBUG] mod_sofia.c:143 sofia/default/18323352735@login.lugertel.com SOFIA ROUTING
  44. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:236 sofia/default/18323352735@login.lugertel.com Standard ROUTING
  45. 2019-04-30 12:22:57.694002 [INFO] mod_dialplan_xml.c:637 Processing 18323352735 <18323352735>->22549366911 in context default
  46. 2019-04-30 12:22:57.694002 [DEBUG] freeswitch_lua.cpp:365 DBH handle 0x7f82700602f0 Connected.
  47. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM system WHERE group_title IN ('global','opensips','callingcard')
  48. 2019-04-30 12:22:57.694002 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [xml_handler] Params:
  49. 'Event-Name: REQUEST_PARAMS
  50. Core-UUID: 0a2e92b8-66a3-11e9-b415-7bf171c29d1f
  51. FreeSWITCH-Hostname: D6014.dallas-idc.com
  52. FreeSWITCH-Switchname: D6014.dallas-idc.com
  53. FreeSWITCH-IPv4: 74.63.227.206
  54. FreeSWITCH-IPv6: %3A%3A1
  55. Event-Date-Local: 2019-04-30%2012%3A22%3A57
  56. Event-Date-GMT: Tue,%2030%20Apr%202019%2017%3A22%3A57%20GMT
  57. Event-Date-Timestamp: 1556644977694002
  58. Event-Calling-File: mod_dialplan_xml.c
  59. Event-Calling-Function: dialplan_xml_locate
  60. Event-Calling-Line-Number: 608
  61. Event-Sequence: 2713658
  62. Channel-State: CS_ROUTING
  63. Channel-Call-State: RINGING
  64. Channel-State-Number: 2
  65. Channel-Name: sofia/default/18323352735%40login.lugertel.com
  66. Unique-ID: 98d307e2-6b6c-11e9-a1d4-7bf171c29d1f
  67. Call-Direction: inbound
  68. Presence-Call-Direction: inbound
  69. Channel-HIT-Dialplan: true
  70. Channel-Presence-ID: 18323352735%40login.lugertel.com
  71. Channel-Call-UUID: 98d307e2-6b6c-11e9-a1d4-7bf171c29d1f
  72. Answer-State: ringing
  73. Channel-Read-Codec-Name: PCMU
  74. Channel-Read-Codec-Rate: 8000
  75. Channel-Read-Codec-Bit-Rate: 64000
  76. Channel-Write-Codec-Name: PCMU
  77. Channel-Write-Codec-Rate: 8000
  78. Channel-Write-Codec-Bit-Rate: 64000
  79. Caller-Direction: inbound
  80. Caller-Logical-Direction: inbound
  81. Caller-Username: 18323352735
  82. Caller-Dialplan: XML
  83. Caller-Caller-ID-Name: 18323352735
  84. Caller-Caller-ID-Number: 18323352735
  85. Caller-Orig-Caller-ID-Name: 18323352735
  86. Caller-Orig-Caller-ID-Number: 18323352735
  87. Caller-Network-Addr: 166.173.61.47
  88. Caller-ANI: 18323352735
  89. Caller-Destination-Number: 22549366911
  90. Caller-Unique-ID: 98d307e2-6b6c-11e9-a1d4-7bf171c29d1f
  91. Caller-Source: mod_sofia
  92. Caller-Context: default
  93. Caller-Channel-Name: sofia/default/18323352735%40login.lugertel.com
  94. Caller-Profile-Index: 1
  95. Caller-Profile-Created-Time: 1556644977694002
  96. Caller-Channel-Created-Time: 1556644977694002
  97. Caller-Channel-Answered-Time: 0
  98. Caller-Channel-Progress-Time: 0
  99. Caller-Channel-Progress-Media-Time: 0
  100. Caller-Channel-Hangup-Time: 0
  101. Caller-Channel-Transfer-Time: 0
  102. Caller-Channel-Resurrect-Time: 0
  103. Caller-Channel-Bridged-Time: 0
  104. Caller-Channel-Last-Hold: 0
  105. Caller-Channel-Hold-Accum: 0
  106. Caller-Screen-Bit: true
  107. Caller-Privacy-Hide-Name: false
  108. Caller-Privacy-Hide-Number: false
  109. variable_direction: inbound
  110. variable_uuid: 98d307e2-6b6c-11e9-a1d4-7bf171c29d1f
  111. variable_session_id: 123782
  112. variable_sip_from_user: 18323352735
  113. variable_sip_from_uri: 18323352735%40login.lugertel.com
  114. variable_sip_from_host: login.lugertel.com
  115. variable_video_media_flow: sendrecv
  116. variable_channel_name: sofia/default/18323352735%40login.lugertel.com
  117. variable_sip_call_id: WilUifZLM5niKvJty2Rs5SZbrLZmyFQ9
  118. variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
  119. variable_sip_local_network_addr: 74.63.227.206
  120. variable_sip_network_ip: 166.173.61.47
  121. variable_sip_network_port: 22516
  122. variable_sip_invite_stamp: 1556644977674080
  123. variable_sip_received_ip: 166.173.61.47
  124. variable_sip_received_port: 22516
  125. variable_sip_via_protocol: udp
  126. variable_sip_authorized: true
  127. variable_Event-Name: REQUEST_PARAMS
  128. variable_Core-UUID: 0a2e92b8-66a3-11e9-b415-7bf171c29d1f
  129. variable_FreeSWITCH-Hostname: D6014.dallas-idc.com
  130. variable_FreeSWITCH-Switchname: D6014.dallas-idc.com
  131. variable_FreeSWITCH-IPv4: 74.63.227.206
  132. variable_FreeSWITCH-IPv6: %3A%3A1
  133. variable_Event-Date-Local: 2019-04-30%2012%3A22%3A57
  134. variable_Event-Date-GMT: Tue,%2030%20Apr%202019%2017%3A22%3A57%20GMT
  135. variable_Event-Date-Timestamp: 1556644977674080
  136. variable_Event-Calling-File: sofia.c
  137. variable_Event-Calling-Function: sofia_handle_sip_i_invite
  138. variable_Event-Calling-Line-Number: 10096
  139. variable_Event-Sequence: 2713649
  140. variable_sip_number_alias: 18323352735
  141. variable_sip_auth_username: 18323352735
  142. variable_sip_auth_realm: login.lugertel.com
  143. variable_number_alias: 18323352735
  144. variable_requested_user_name: 18323352735
  145. variable_requested_domain_name: 74.63.227.206
  146. variable_effective_caller_id_name: Gerald%20Chenyi
  147. variable_effective_caller_id_number: 18323352735
  148. variable_sipcall: true
  149. variable_accountcode: 18323352735
  150. variable_user_name: 18323352735
  151. variable_domain_name: 74.63.227.206
  152. variable_sip_from_user_stripped: 18323352735
  153. variable_sip_from_tag: gcC7bqMkkOcq5A8mh4oxFlqex0Q5nqQ7
  154. variable_sofia_profile_name: default
  155. variable_recovery_profile_name: default
  156. variable_sip_full_via: SIP/2.0/UDP%20166.173.61.47%3A22516%3Brport%3D22516%3Bbranch%3Dz9hG4bKPje-YSWYjYo0svmWZA6ZKUxXRb8Cx0qLtN
  157. variable_sip_full_from: sip%3A18323352735%40login.lugertel.com%3Btag%3DgcC7bqMkkOcq5A8mh4oxFlqex0Q5nqQ7
  158. variable_sip_full_to: sip%3A22549366911%40login.lugertel.com
  159. variable_sip_allow: PRACK,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20INFO,%20SUBSCRIBE,%20NOTIFY,%20REFER,%20MESSAGE,%20OPTIONS
  160. variable_sip_req_user: 22549366911
  161. variable_sip_req_port: 5060
  162. variable_sip_req_uri: 22549366911%40login.lugertel.com%3A5060
  163. variable_sip_req_host: login.lugertel.com
  164. variable_sip_to_user: 22549366911
  165. variable_sip_to_uri: 22549366911%40login.lugertel.com
  166. variable_sip_to_host: login.lugertel.com
  167. variable_sip_contact_params: ob
  168. variable_sip_contact_user: 18323352735
  169. variable_sip_contact_port: 22516
  170. variable_sip_contact_uri: 18323352735%40166.173.61.47%3A22516
  171. variable_sip_contact_host: 166.173.61.47
  172. variable_sip_user_agent: LugerTel
  173. variable_sip_via_host: 166.173.61.47
  174. variable_sip_via_port: 22516
  175. variable_sip_via_rport: 22516
  176. variable_max_forwards: 70
  177. variable_presence_id: 18323352735%40login.lugertel.com
  178. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%203765633777%203765633777%20IN%20IP4%2010.199.189.217%0D%0As%3Dpjmedia%0D%0Ab%3DAS%3A84%0D%0At%3D0%200%0D%0Aa%3DX-nat%3A0%0D%0Am%3Daudio%204000%20RTP/AVP%200%208%2096%0D%0Ac%3DIN%20IP4%2010.199.189.217%0D%0Ab%3DTIAS%3A64000%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A96%20telephone-event/8000%0D%0Aa%3Dfmtp%3A96%200-16%0D%0Aa%3Drtcp%3A4001%20IN%20IP4%2010.199.189.217%0D%0A
  179. variable_rtp_use_codec_string: PCMA,PCMU,G729
  180. variable_audio_media_flow: sendrecv
  181. variable_rtp_remote_audio_rtcp_port: 4001
  182. variable_remote_media_ip: 10.199.189.217
  183. variable_remote_media_port: 4000
  184. variable_rtp_audio_recv_pt: 0
  185. variable_rtp_use_codec_name: PCMU
  186. variable_rtp_use_codec_rate: 8000
  187. variable_rtp_use_codec_ptime: 20
  188. variable_rtp_use_codec_channels: 1
  189. variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c
  190. variable_read_codec: PCMU
  191. variable_original_read_codec: PCMU
  192. variable_read_rate: 8000
  193. variable_original_read_rate: 8000
  194. variable_write_codec: PCMU
  195. variable_write_rate: 8000
  196. variable_dtmf_type: rfc2833
  197. variable_endpoint_disposition: RECEIVED
  198. variable_call_uuid: 98d307e2-6b6c-11e9-a1d4-7bf171c29d1f
  199. Hunt-Direction: inbound
  200. Hunt-Logical-Direction: inbound
  201. Hunt-Username: 18323352735
  202. Hunt-Dialplan: XML
  203. Hunt-Caller-ID-Name: 18323352735
  204. Hunt-Caller-ID-Number: 18323352735
  205. Hunt-Orig-Caller-ID-Name: 18323352735
  206. Hunt-Orig-Caller-ID-Number: 18323352735
  207. Hunt-Network-Addr: 166.173.61.47
  208. Hunt-ANI: 18323352735
  209. Hunt-Destination-Number: 22549366911
  210. Hunt-Unique-ID: 98d307e2-6b6c-11e9-a1d4-7bf171c29d1f
  211. Hunt-Source: mod_sofia
  212. Hunt-Context: default
  213. Hunt-Channel-Name: sofia/default/18323352735%40login.lugertel.com
  214. Hunt-Profile-Index: 1
  215. Hunt-Profile-Created-Time: 1556644977694002
  216. Hunt-Channel-Created-Time: 1556644977694002
  217. Hunt-Channel-Answered-Time: 0
  218. Hunt-Channel-Progress-Time: 0
  219. Hunt-Channel-Progress-Media-Time: 0
  220. Hunt-Channel-Hangup-Time: 0
  221. Hunt-Channel-Transfer-Time: 0
  222. Hunt-Channel-Resurrect-Time: 0
  223. Hunt-Channel-Bridged-Time: 0
  224. Hunt-Channel-Last-Hold: 0
  225. Hunt-Channel-Hold-Accum: 0
  226. Hunt-Screen-Bit: true
  227. Hunt-Privacy-Hide-Name: false
  228. Hunt-Privacy-Hide-Number: false
  229.  
  230. '
  231. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [xml_REQUEST] key_name:
  232. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [xml_REQUEST] key_value:
  233. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [xml_REQUEST] tag_name:
  234. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [xml_REQUEST] section: dialplan
  235. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Dialed number : 22549366911
  236. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = 22549366911 AND status=0 limit 1
  237. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Caller Id name / number  : Gerald Chenyi / 18323352735
  238. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,B.id as accountid,B.number as account_code,B.did_cid_translation as did_cid_translation,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.always,A.always_destination,A.leg_timeout FROM dids AS A,accounts AS B WHERE A.status=0 AND B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="22549366911" LIMIT 1
  239. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT 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 WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="22549366911" limit 1
  240. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Call direction : outbound
  241. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_LOCAL_NUMBER_INFO] Query :select * from local_number WHERE number = '22549366911' and status = 0 limit 1
  242. 2019-04-30 12:22:57.694002 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [Accountcode : 18323352735]
  243. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix from pricelists WHERE (routing_prefix ='^22549366911.*' OR routing_prefix ='^2254936691.*' OR routing_prefix ='^225493669.*' OR routing_prefix ='^22549366.*' OR routing_prefix ='^2254936.*' OR routing_prefix ='^225493.*' OR routing_prefix ='^22549.*' OR routing_prefix ='^2254.*' OR routing_prefix ='^225.*' OR routing_prefix ='^22.*' OR routing_prefix ='^2.*' OR routing_prefix ='--') AND status = 0 limit 1
  244. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "18323352735" OR id="18323352735") AND status=0 AND deleted=0 AND (expiry >= '2019-04-30 17:22:57' OR expiry = '0000-00-00 00:00:00') limit 1
  245. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns ='^22549366911.*' OR blocked_patterns ='^2254936691.*' OR blocked_patterns ='^225493669.*' OR blocked_patterns ='^22549366.*' OR blocked_patterns ='^2254936.*' OR blocked_patterns ='^225493.*' OR blocked_patterns ='^22549.*' OR blocked_patterns ='^2254.*' OR blocked_patterns ='^225.*' OR blocked_patterns ='^22.*' OR blocked_patterns ='^2.*' OR blocked_patterns ='--') AND accountid = 444 limit 1
  246. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT * FROM packages  as P inner join package_patterns as PKGPTR on P.id = PKGPTR.package_id WHERE (patterns ='^22549366911.*' OR patterns ='^2254936691.*' OR patterns ='^225493669.*' OR patterns ='^22549366.*' OR patterns ='^2254936.*' OR patterns ='^225493.*' OR patterns ='^22549.*' OR patterns ='^2254.*' OR patterns ='^225.*' OR patterns ='^22.*' OR patterns ='^2.*' OR patterns ='--') AND status = 0 AND pricelist_id = 1 ORDER BY LENGTH(PKGPTR.patterns) DESC LIMIT 1
  247. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="22549366911" AND A.accountid = '444' limit 1
  248. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 22549366911
  249. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,B.id as accountid,B.number as account_code,B.did_cid_translation as did_cid_translation,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.always,A.always_destination,A.leg_timeout FROM dids AS A,accounts AS B WHERE A.status=0 AND B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="22549366911" LIMIT 1
  250. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT 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 WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="22549366911" limit 1
  251. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [Dialplan] New Call direction : outbound
  252. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Account Information ===================
  253. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] User id : 444
  254. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Account code : 18323352735
  255. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  256. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Ratecard id : 1
  257. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] ========================================================
  258. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [DIALPLAN] Caller ID Translation Starts
  259. 2019-04-30 12:22:57.694002 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] Before number translation : 18323352735
  260. 2019-04-30 12:22:57.694002 [WARNING] switch_cpp.cpp:1365 [ASTPP] [DONUMBERTRANSLATION] After  number translation : 8323352735
  261. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [DIALPLAN] Caller ID Translation Ends
  262. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  263. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') AND status = 0 AND pricelist_id = 1  ORDER BY LENGTH(pattern) DESC,cost DESC LIMIT 1
  264. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] =============== Rates Information ===================
  265. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] ID : 809
  266. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Connectcost : 0.00000
  267. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Includedseconds : 5
  268. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Cost : 0.40000
  269. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] comment : Ivory Coast
  270. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Accid : 444
  271. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Trunk ID: 0
  272. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Routing type:
  273. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] ================================================================
  274. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] Call Max length duration : 98.621 minutes
  275. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [Dialplan] Routing Type : 1
  276. 2019-04-30 12:22:57.694002 [INFO] switch_cpp.cpp:1365 [ASTPP] [DIALPLAN] User Rate ID : 809
  277. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Trunk ids 1111******************:0
  278. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_COUNTER_INFO] force_trunk_type here :1
  279. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES]1111122222 Query :SELECT TK.id as trunk_id,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.cid_translation,TK.leg_timeout,TK.dialed_modify,TK.maxchannels,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select percentage from routing where routes_id=(select id from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1) AND trunk_id = TR.trunk_id limit 1) as percentage,(select call_count from routing where routes_id=(select id from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1) AND trunk_id = TR.trunk_id) as trunk_count,(select call_count from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1 ) as routes_count,100 * (select call_count from routing where routes_id=(select id from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1) AND trunk_id = TR.trunk_id) / (select call_count from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1 ) AS percent_atual,(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 ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (0)
  280. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Trunk ids ******************:0
  281. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_ROUTING_TYPE] Routing type ******************:1
  282. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.cid_translation,TK.leg_timeout,TK.dialed_modify,TK.maxchannels,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select percentage from routing where routes_id=(select id from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1) AND trunk_id = TR.trunk_id limit 1) as percentage,(select call_count from routing where routes_id=(select id from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1) AND trunk_id = TR.trunk_id) as trunk_count,(select call_count from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1 ) as routes_count,100 * (select call_count from routing where routes_id=(select id from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1) AND trunk_id = TR.trunk_id) / (select call_count from routes where (pattern ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') and pricelist_id=1  ORDER BY LENGTH(pattern) DESC,cost DESC limit 1 ) AS percent_atual,(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 ='^22549366911.*' OR pattern ='^2254936691.*' OR pattern ='^225493669.*' OR pattern ='^22549366.*' OR pattern ='^2254936.*' OR pattern ='^225493.*' OR pattern ='^22549.*' OR pattern ='^2254.*' OR pattern ='^225.*' OR pattern ='^22.*' OR pattern ='^2.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (0)  ORDER by IF( percent_atual >= percentage, percentage, '' ) ASC , IF( percent_atual <= percentage, percentage, '' ) DESC
  283. 2019-04-30 12:22:57.694002 [NOTICE] switch_cpp.cpp:1365 [ASTPP] [Dialplan] No termination rates found...!!!
  284. 2019-04-30 12:22:57.694002 [DEBUG] switch_cpp.cpp:1365 [ASTPP] Generated XML:
  285. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  286. <document type="freeswitch/xml">
  287. <section name="dialplan" description="ASTPP Dialplan">
  288. <context name="default">
  289. <extension name="22549366911">
  290. <condition field="destination_number" expression="22549366911">
  291. <action application="log" data="WARNING Accountcode 18323352735. Dialed number (22549366911) termination rates not found!!"/>
  292. <action application="playback" data="/usr/local/freeswitch/sounds/en/us/callie/astpp-badphone.wav"/>
  293. <action application="set" data="original_caller_id_name=Gerald Chenyi"/>
  294. <action application="set" data="original_caller_id_number=Gerald Chenyi"/>
  295. <action application="set" data="error_cdr=1"/>
  296. <action application="set" data="callstart=2019-04-30 17:22:57"/>
  297. <action application="set" data="account_id=444"/>
  298. <action application="set" data="call_direction=outbound"/>
  299. <action application="set" data="sip_ignore_remote_cause=true"/>
  300. <action application="set" data="call_processed=internal"/>
  301. <action application="set" data="effective_destination_number=22549366911"/>
  302. <action application="set" data="last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND"/>
  303. <action application="hangup" data="TERMINATION_RATE_NOT_FOUND"/>
  304. </condition>
  305. </extension>
  306. </context>
  307. </section>
  308. </document>
  309. 2019-04-30 12:22:57.694002 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7f82700602f0 released.
  310. Dialplan: sofia/default/18323352735@login.lugertel.com parsing [default->22549366911] continue=false
  311. Dialplan: sofia/default/18323352735@login.lugertel.com Regex (PASS) [22549366911] destination_number(22549366911) =~ /22549366911/ break=on-false
  312. Dialplan: sofia/default/18323352735@login.lugertel.com Action log(WARNING Accountcode 18323352735. Dialed number (22549366911) termination rates not found!!)
  313. Dialplan: sofia/default/18323352735@login.lugertel.com Action playback(/usr/local/freeswitch/sounds/en/us/callie/astpp-badphone.wav)
  314. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(original_caller_id_name=Gerald Chenyi)
  315. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(original_caller_id_number=Gerald Chenyi)
  316. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(error_cdr=1)
  317. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(callstart=2019-04-30 17:22:57)
  318. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(account_id=444)
  319. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(call_direction=outbound)
  320. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(sip_ignore_remote_cause=true)
  321. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(call_processed=internal)
  322. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(effective_destination_number=22549366911)
  323. Dialplan: sofia/default/18323352735@login.lugertel.com Action set(last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND)
  324. Dialplan: sofia/default/18323352735@login.lugertel.com Action hangup(TERMINATION_RATE_NOT_FOUND)
  325. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:286 (sofia/default/18323352735@login.lugertel.com) State Change CS_ROUTING -> CS_EXECUTE
  326. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:643 (sofia/default/18323352735@login.lugertel.com) State ROUTING going to sleep
  327. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:584 (sofia/default/18323352735@login.lugertel.com) Running State Change CS_EXECUTE (Cur 1 Tot 123782)
  328. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:650 (sofia/default/18323352735@login.lugertel.com) State EXECUTE
  329. 2019-04-30 12:22:57.694002 [DEBUG] mod_sofia.c:198 sofia/default/18323352735@login.lugertel.com SOFIA EXECUTE
  330. 2019-04-30 12:22:57.694002 [DEBUG] switch_core_state_machine.c:328 sofia/default/18323352735@login.lugertel.com Standard EXECUTE
  331. EXECUTE sofia/default/18323352735@login.lugertel.com log(WARNING Accountcode 18323352735. Dialed number (22549366911) termination rates not found!!)
  332. 2019-04-30 12:22:57.694002 [WARNING] mod_dptools.c:1742 Accountcode 18323352735. Dialed number (22549366911) termination rates not found!!
  333.  

Reply to "Gerald-TR_not_found"