1. 2020-11-19 14:37:29.910318 [NOTICE] switch_channel.c:1118 New Channel sofia/default/8138902220@192.168.8.6 [5c18286f-5ad9-4a3f-a129-a79f09917d30]
2. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_NEW (Cur 1 Tot 28510)
3. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:10243 sofia/default/8138902220@192.168.8.6 receiving invite from 192.168.8.6:5060 version: 1.10.1 -release-12-f9990221e6 64bit
4. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:10337 verifying acl "default" for ip/port 192.168.8.6:0.
5. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:10366 IP 192.168.8.6 Approved by acl "default[]". Access Granted.
6. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [received][100]
7. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:7300 Remote SDP:
8. v=0
9. o=- 1054601244 1054601244 IN IP4 192.168.8.6
10. s=Asterisk
11. c=IN IP4 192.168.8.6
12. t=0 0
13. m=audio 16050 RTP/AVP 0 8 3 111 9 101
14. a=rtpmap:0 PCMU/8000
15. a=rtpmap:8 PCMA/8000
16. a=rtpmap:3 GSM/8000
17. a=rtpmap:111 G726-32/8000
18. a=rtpmap:9 G722/8000
19. a=rtpmap:101 telephone-event/8000
20. a=fmtp:101 0-16
21. a=ptime:20
22. a=maxptime:150
23.  
24. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
25. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
26. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
27. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
28. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5645 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
29. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
30. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
31. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
32. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G726-32:111:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
33. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G726-32:111:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
34. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
35. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5590 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
36. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5506 Set telephone-event payload to 101@8000
37. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:3834 Set Codec sofia/default/8138902220@192.168.8.6 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
38. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_codec.c:111 sofia/default/8138902220@192.168.8.6 Original read codec set to PCMU:0
39. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5849 Set telephone-event payload to 101@8000
40. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_media.c:5907 sofia/default/8138902220@192.168.8.6 Set 2833 dtmf send payload to 101 recv payload to 101
41. 2020-11-19 14:37:29.910318 [DEBUG] sofia.c:7724 (sofia/default/8138902220@192.168.8.6) State Change CS_NEW -> CS_INIT
42. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:604 (sofia/default/8138902220@192.168.8.6) State NEW
43. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_INIT (Cur 1 Tot 28510)
44. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:628 (sofia/default/8138902220@192.168.8.6) State INIT
45. 2020-11-19 14:37:29.910318 [DEBUG] mod_sofia.c:93 sofia/default/8138902220@192.168.8.6 SOFIA INIT
46. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:40 sofia/default/8138902220@192.168.8.6 Standard INIT
47. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:48 (sofia/default/8138902220@192.168.8.6) State Change CS_INIT -> CS_ROUTING
48. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:628 (sofia/default/8138902220@192.168.8.6) State INIT going to sleep
49. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 28510)
50. 2020-11-19 14:37:29.910318 [DEBUG] switch_channel.c:2332 (sofia/default/8138902220@192.168.8.6) Callstate Change DOWN -> RINGING
51. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING
52. 2020-11-19 14:37:29.910318 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING
53. 2020-11-19 14:37:29.910318 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING
54. 2020-11-19 14:37:29.910318 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->9088999989 in context default
55. 2020-11-19 14:37:29.910318 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
56. 2020-11-19 14:37:29.910318 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
57. 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params:
58. Event-Name: REQUEST_PARAMS
59. Core-UUID: ab3e105f-e6f4-458f-b102-a4065f4859ae
60. FreeSWITCH-Hostname: soultech
61. FreeSWITCH-Switchname: soultech
62. FreeSWITCH-IPv4: 192.168.8.3
63. FreeSWITCH-IPv6: %3A%3A1
64. Event-Date-Local: 2020-11-19%2014%3A37%3A29
65. Event-Date-GMT: Thu,%2019%20Nov%202020%2013%3A37%3A29%20GMT
66. Event-Date-Timestamp: 1605793049910318
67. Event-Calling-File: mod_dialplan_xml.c
68. Event-Calling-Function: dialplan_xml_locate
69. Event-Calling-Line-Number: 608
70. Event-Sequence: 555749
71. Channel-State: CS_ROUTING
72. Channel-Call-State: RINGING
73. Channel-State-Number: 2
74. Channel-Name: sofia/default/8138902220%40192.168.8.6
75. Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
76. Call-Direction: inbound
77. Presence-Call-Direction: inbound
78. Channel-HIT-Dialplan: true
79. Channel-Presence-ID: 8138902220%40192.168.8.6
80. Channel-Call-UUID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
81. Answer-State: ringing
82. Channel-Read-Codec-Name: PCMU
83. Channel-Read-Codec-Rate: 8000
84. Channel-Read-Codec-Bit-Rate: 64000
85. Channel-Write-Codec-Name: PCMU
86. Channel-Write-Codec-Rate: 8000
87. Channel-Write-Codec-Bit-Rate: 64000
88. Caller-Direction: inbound
89. Caller-Logical-Direction: inbound
90. Caller-Username: 8138902220
91. Caller-Dialplan: XML
92. Caller-Caller-ID-Name: 8138902220
93. Caller-Caller-ID-Number: 8138902220
94. Caller-Orig-Caller-ID-Name: 8138902220
95. Caller-Orig-Caller-ID-Number: 8138902220
96. Caller-Network-Addr: 192.168.8.6
97. Caller-ANI: 8138902220
98. Caller-Destination-Number: 9088999989
99. Caller-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
100. Caller-Source: mod_sofia
101. Caller-Context: default
102. Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6
103. Caller-Profile-Index: 1
104. Caller-Profile-Created-Time: 1605793049910318
105. Caller-Channel-Created-Time: 1605793049910318
106. Caller-Channel-Answered-Time: 0
107. Caller-Channel-Progress-Time: 0
108. Caller-Channel-Progress-Media-Time: 0
109. Caller-Channel-Hangup-Time: 0
110. Caller-Channel-Transfer-Time: 0
111. Caller-Channel-Resurrect-Time: 0
112. Caller-Channel-Bridged-Time: 0
113. Caller-Channel-Last-Hold: 0
114. Caller-Channel-Hold-Accum: 0
115. Caller-Screen-Bit: true
116. Caller-Privacy-Hide-Name: false
117. Caller-Privacy-Hide-Number: false
118. variable_direction: inbound
119. variable_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30
120. variable_session_id: 28510
121. variable_sip_from_user: 8138902220
122. variable_sip_from_uri: 8138902220%40192.168.8.6
123. variable_sip_from_host: 192.168.8.6
124. variable_video_media_flow: disabled
125. variable_text_media_flow: disabled
126. variable_channel_name: sofia/default/8138902220%40192.168.8.6
127. variable_sip_call_id: a2b73d1d-26d9-4a65-b280-1c62b2d98c30
128. variable_sip_local_network_addr: 192.168.8.3
129. variable_sip_network_ip: 192.168.8.6
130. variable_sip_network_port: 5060
131. variable_sip_invite_stamp: 1605793049910318
132. variable_sip_received_ip: 192.168.8.6
133. variable_sip_received_port: 5060
134. variable_sip_via_protocol: udp
135. variable_sip_authorized: true
136. variable_sip_acl_authed_by: default
137. variable_sip_from_user_stripped: 8138902220
138. variable_sip_from_tag: a251beb8-e6dd-4c47-b493-aba69df9be3c
139. variable_sofia_profile_name: default
140. variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060
141. variable_recovery_profile_name: default
142. variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPj3ea88895-62a2-4c68-9a9e-54489e70cdb3
143. variable_sip_from_display: 8138902220
144. variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3Da251beb8-e6dd-4c47-b493-aba69df9be3c
145. variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E
146. variable_sip_allow: OPTIONS,%20SUBSCRIBE,%20NOTIFY,%20PUBLISH,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20PRACK,%20REGISTER,%20MESSAGE,%20REFER
147. variable_sip_req_user: 9088999989
148. variable_sip_req_uri: 9088999989%40192.168.8.3
149. variable_sip_req_host: 192.168.8.3
150. variable_sip_to_user: 9088999989
151. variable_sip_to_uri: 9088999989%40192.168.8.3
152. variable_sip_to_host: 192.168.8.3
153. variable_sip_contact_user: asterisk
154. variable_sip_contact_port: 5060
155. variable_sip_contact_uri: asterisk%40192.168.8.6%3A5060
156. variable_sip_contact_host: 192.168.8.6
157. variable_sip_user_agent: FPBX-14.0.13.40(13.29.2)
158. variable_sip_via_host: 192.168.8.6
159. variable_sip_via_port: 5060
160. variable_sip_via_rport: 5060
161. variable_max_forwards: 70
162. variable_presence_id: 8138902220%40192.168.8.6
163. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201054601244%201054601244%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2016050%20RTP/AVP%200%208%203%20111%209%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A3%20GSM/8000%0D%0Aa%3Drtpmap%3A111%20G726-32/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dmaxptime%3A150%0D%0A
164. variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
165. variable_rtp_use_codec_string: PCMA,PCMU
166. variable_remote_video_media_flow: inactive
167. variable_remote_text_media_flow: inactive
168. variable_remote_audio_media_flow: sendrecv
169. variable_audio_media_flow: sendrecv
170. variable_remote_media_ip: 192.168.8.6
171. variable_remote_media_port: 16050
172. variable_rtp_audio_recv_pt: 0
173. variable_rtp_use_codec_name: PCMU
174. variable_rtp_use_codec_rate: 8000
175. variable_rtp_use_codec_ptime: 20
176. variable_rtp_use_codec_channels: 1
177. variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c
178. variable_read_codec: PCMU
179. variable_original_read_codec: PCMU
180. variable_read_rate: 8000
181. variable_original_read_rate: 8000
182. variable_write_codec: PCMU
183. variable_write_rate: 8000
184. variable_dtmf_type: rfc2833
185. variable_endpoint_disposition: RECEIVED
186. variable_call_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30
187. Hunt-Direction: inbound
188. Hunt-Logical-Direction: inbound
189. Hunt-Username: 8138902220
190. Hunt-Dialplan: XML
191. Hunt-Caller-ID-Name: 8138902220
192. Hunt-Caller-ID-Number: 8138902220
193. Hunt-Orig-Caller-ID-Name: 8138902220
194. Hunt-Orig-Caller-ID-Number: 8138902220
195. Hunt-Network-Addr: 192.168.8.6
196. Hunt-ANI: 8138902220
197. Hunt-Destination-Number: 9088999989
198. Hunt-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
199. Hunt-Source: mod_sofia
200. Hunt-Context: default
201. Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6
202. Hunt-Profile-Index: 1
203. Hunt-Profile-Created-Time: 1605793049910318
204. Hunt-Channel-Created-Time: 1605793049910318
205. Hunt-Channel-Answered-Time: 0
206. Hunt-Channel-Progress-Time: 0
207. Hunt-Channel-Progress-Media-Time: 0
208. Hunt-Channel-Hangup-Time: 0
209. Hunt-Channel-Transfer-Time: 0
210. Hunt-Channel-Resurrect-Time: 0
211. Hunt-Channel-Bridged-Time: 0
212. Hunt-Channel-Last-Hold: 0
213. Hunt-Channel-Hold-Accum: 0
214. Hunt-Screen-Bit: true
215. Hunt-Privacy-Hide-Name: false
216. Hunt-Privacy-Hide-Number: false
217.  
218.  
219. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name:
220. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value:
221. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name:
222. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
223. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0
224. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9088999989
225. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9088999989' limit 1
226. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9088999989' AND status=0 limit 1
227. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9088999989' and status=0 LIMIT 1
228. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 8138902220 / 8138902220
229. 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
230. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
231. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" LIMIT 1
232. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : inbound
233. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.8.6") 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 "9088999989"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
234. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299]
235. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
236. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
237. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" AND A.accountid = '123' limit 1
238. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9088999989
239. 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
240. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
241. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" LIMIT 1
242. 2020-11-19 14:37:29.950325 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : inbound
243. 2020-11-19 14:37:29.950325 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
244. 2020-11-19 14:37:29.950325 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
245. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9088999989" AND (accountid = 0 OR status = 1) LIMIT 1
246. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound
247. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :138
248. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^9088999989.*' OR patterns = '^908899998.*' OR patterns = '^90889999.*' OR patterns = '^9088999.*' OR patterns = '^908899.*' OR patterns = '^90889.*' OR patterns = '^9088.*' OR patterns = '^908.*' OR patterns = '^90.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 138 ORDER BY LENGTH(PKGPTR.patterns) DESC
249. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '9088999989' OR number = '908899998' OR number = '90889999' OR number = '9088999' OR number = '908899' OR number = '90889' OR number = '9088' OR number = '908' OR number = '90' OR number = '9' OR number ='--') OR (number = '9088999989*' OR number = '908899998*' OR number = '90889999*' OR number = '9088999*' OR number = '908899*' OR number = '90889*' OR number = '9088*' OR number = '908*' OR number = '90*' OR number = '9*' OR number ='--') OR (number = '8138902220' OR number = '813890222' OR number = '81389022' OR number = '8138902' OR number = '813890' OR number = '81389' OR number = '8138' OR number = '813' OR number = '81' OR number = '8' OR number ='--') OR (number = '8138902220*' OR number = '813890222*' OR number = '81389022*' OR number = '8138902*' OR number = '813890*' OR number = '81389*' OR number = '8138*' OR number = '813*' OR number = '81*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
250. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1
251. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9088999989' OR routing_prefix = '908899998' OR routing_prefix = '90889999' OR routing_prefix = '9088999' OR routing_prefix = '908899' OR routing_prefix = '90889' OR routing_prefix = '9088' OR routing_prefix = '908' OR routing_prefix = '90' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
252. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information ===================
253. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123
254. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299
255. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66
256. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
257. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1
258. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0
259. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] ========================================================
260. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
261. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :inbound
262. 2020-11-19 14:37:29.990251 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
263. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
264. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" LIMIT 1
265. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: inbound
266. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Rates Information ===================
267. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] ID : 47
268. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Connectcost : 0.00000
269. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Includedseconds : 0
270. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Cost : 10.00000
271. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] comment : 9088999989
272. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Country Id : 141
273. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Accid : 123
274. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] ================================================================
275. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Your6856.66 balance Accountid 123 !!!
276. 2020-11-19 14:37:29.990251 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Limiting call to config max length 100 mins!
277. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] Call Max length duration : 100 minutes
278. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] INB_FREE:TRUE
279. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] free_inbound:1
280. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 123 AND status=0 LIMIT 1
281. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
282. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
283. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML:123
284. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Userinfo XML:123
285. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML : 123
286. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3
287. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1
288. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition : [{"extensions":"6350951709","no_answer_call_type":"11"}]
289. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition : [{"hour":"00-23","minute":"00-59","wday":"2-2","mday":"1-31","mon":"1-12","year":"2020-2020","extensions":"6350951709","no_answer_call_type":"11","priority":"1"}]
290. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition_str : 6350951709
291. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] priority : 1
292. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] condition_str :  time-of-day= "00:00-23:59"  wday= "2-2"  mday= "1-31"  mon= "1-12"  year= "2020-2020"
293. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] maxlength::::::::: 100
294. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1
295. 2020-11-19 14:37:29.990251 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng
296. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_11
297. 2020-11-19 14:37:29.990251 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3
298. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1
299. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] time_condition::::::::::::::::::::::::47
300. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name::::::::::::::::::::::::47
301. 2020-11-19 14:37:29.990251 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
302. <document type="freeswitch/xml">
303. <section name="dialplan" description="ASTPP Dialplan">
304. <context name="default">
305. <extension name="TimeTC" continue="true">
306. <condition time-of-day= "00:01-23:59" break="never">
307. <action application="set" data="office_status=open" inline="true"/>
308. <action application="set" data="extensions=6350951709" inline="true"/>
309. <action application="set" data="no_answer_call_type=11" inline="true"/>
310. </condition>
311. </extension>
312. <extension name="TimeTC" continue="true">
313. <condition  time-of-day= "00:00-23:59"  wday= "2-2"  mday= "1-31"  mon= "1-12"  year= "2020-2020"  break="never">
314. <action application="set" data="office_status=open" inline="true"/>
315. <action application="set" data="extensions=6350951709" inline="true"/>
316. <action application="set" data="no_answer_call_type=11" inline="true"/>
317. </condition>
318. </extension>
319. <extension name="tod route, x9088999989">
320. <condition field="destination_number" expression="^(9088999989)$">
321. <action application="execute_extension" data="9088999989_${office_status}"/>
322. </condition>
323. </extension>
324. <extension name="office is open">
325. <condition field="destination_number" expression="^(9088999989_open)$">
326. <action application="set" data="set_extensions=${extensions}"/>
327. <action application="set" data="no_answer_flag=true"/>
328. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
329. <action application="set" data="no_answer_number=${extensions}" />
330. <action application="transfer" data="138 XML default"/>
331. </condition>
332. </extension>
333. <extension name="9088999989">
334. <condition field="destination_number" expression="9088999989">
335. <action application="set" data="effective_destination_number=9088999989"/>
336. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
337. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
338. <action application="set" data="callstart=2020-11-19 13:37:25"/>
339. <action application="set" data="hangup_after_bridge=true"/>
340. <action application="set" data="continue_on_fail=TRUE"/>
341. <action application="set" data="account_id=123"/>
342. <action application="set" data="parent_id=0"/>
343. <action application="set" data="entity_id=0"/>
344. <action application="set" data="call_processed=internal"/>
345. <action application="set" data="call_direction=inbound"/>
346. <action application="set" data="accountname=HOD1"/>
347. <action application="set" data="origination_rates_did=ID:47|CODE:^9088999989.*|DESTINATION:9088999989|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:10.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:138"/>
348. <action application="set" data="origination_rates=0"/>
349. <action application="set" data="original_caller_id_name=8138902220"/>
350. <action application="set" data="original_caller_id_number=8138902220"/>
351. <action application="set" data="effective_caller_id_name=8138902220"/>
352. <action application="set" data="effective_caller_id_number=8138902220"/>
353. <action application="set" data="receiver_accid=138"/>
354. <action application="set" data="domain_name=test446.9mobile.nativetalk.com.ng"/>
355. <action application="set" data="sip_to_host=test446.9mobile.nativetalk.com.ng"/>
356. <action application="export" data="domain_name=test446.9mobile.nativetalk.com.ng"/>
357. <action application="export" data="sip_to_host=test446.9mobile.nativetalk.com.ng"/>
358. <action application="export" data="presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 10.00000||||||DID"/>
359. <action application="export" data="call_type=11"/>
360. </condition>
361. </extension>
362. </context>
363. </section>
364. </document>
365. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true
366. Dialplan: sofia/default/8138902220@192.168.8.6 Date/Time Match (PASS) [TimeTC] break=never
367. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(office_status=open) INLINE
368. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(office_status=open)
369. 2020-11-19 14:37:29.990251 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [office_status]=[open]
370. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(extensions=6350951709) INLINE
371. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(extensions=6350951709)
372. 2020-11-19 14:37:29.990251 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [extensions]=[6350951709]
373. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_call_type=11) INLINE
374. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(no_answer_call_type=11)
375. 2020-11-19 14:37:29.990251 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_call_type]=[11]
376. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true
377. Dialplan: sofia/default/8138902220@192.168.8.6 Date/TimeMatch (FAIL) [TimeTC] break=never
378. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->tod route, x9088999989] continue=false
379. Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [tod route, x9088999989] destination_number(9088999989) =~ /^(9088999989)$/ break=on-false
380. Dialplan: sofia/default/8138902220@192.168.8.6 Action execute_extension(9088999989_${office_status})
381. 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE
382. 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep
383. 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 28510)
384. 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE
385. 2020-11-19 14:37:29.990251 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE
386. 2020-11-19 14:37:29.990251 [DEBUG] switch_core_state_machine.c:329 sofia/default/8138902220@192.168.8.6 Standard EXECUTE
387. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 execute_extension(9088999989_open)
388. 2020-11-19 14:37:29.990251 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->9088999989_open in context default
389. 2020-11-19 14:37:30.010248 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
390. 2020-11-19 14:37:30.010248 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
391. 2020-11-19 14:37:30.030263 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params:
392. Event-Name: REQUEST_PARAMS
393. Core-UUID: ab3e105f-e6f4-458f-b102-a4065f4859ae
394. FreeSWITCH-Hostname: soultech
395. FreeSWITCH-Switchname: soultech
396. FreeSWITCH-IPv4: 192.168.8.3
397. FreeSWITCH-IPv6: %3A%3A1
398. Event-Date-Local: 2020-11-19%2014%3A37%3A29
399. Event-Date-GMT: Thu,%2019%20Nov%202020%2013%3A37%3A29%20GMT
400. Event-Date-Timestamp: 1605793049990251
401. Event-Calling-File: mod_dialplan_xml.c
402. Event-Calling-Function: dialplan_xml_locate
403. Event-Calling-Line-Number: 608
404. Event-Sequence: 555759
405. Channel-State: CS_EXECUTE
406. Channel-Call-State: RINGING
407. Channel-State-Number: 4
408. Channel-Name: sofia/default/8138902220%40192.168.8.6
409. Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
410. Call-Direction: inbound
411. Presence-Call-Direction: inbound
412. Channel-HIT-Dialplan: true
413. Channel-Presence-ID: 8138902220%40192.168.8.6
414. Channel-Call-UUID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
415. Answer-State: ringing
416. Channel-Read-Codec-Name: PCMU
417. Channel-Read-Codec-Rate: 8000
418. Channel-Read-Codec-Bit-Rate: 64000
419. Channel-Write-Codec-Name: PCMU
420. Channel-Write-Codec-Rate: 8000
421. Channel-Write-Codec-Bit-Rate: 64000
422. Caller-Direction: inbound
423. Caller-Logical-Direction: inbound
424. Caller-Username: 8138902220
425. Caller-Dialplan: XML
426. Caller-Caller-ID-Name: 8138902220
427. Caller-Caller-ID-Number: 8138902220
428. Caller-Orig-Caller-ID-Name: 8138902220
429. Caller-Orig-Caller-ID-Number: 8138902220
430. Caller-Network-Addr: 192.168.8.6
431. Caller-ANI: 8138902220
432. Caller-Destination-Number: 9088999989
433. Caller-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
434. Caller-Source: mod_sofia
435. Caller-Context: default
436. Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6
437. Caller-Profile-Index: 1
438. Caller-Profile-Created-Time: 1605793049910318
439. Caller-Channel-Created-Time: 1605793049910318
440. Caller-Channel-Answered-Time: 0
441. Caller-Channel-Progress-Time: 0
442. Caller-Channel-Progress-Media-Time: 0
443. Caller-Channel-Hangup-Time: 0
444. Caller-Channel-Transfer-Time: 0
445. Caller-Channel-Resurrect-Time: 0
446. Caller-Channel-Bridged-Time: 0
447. Caller-Channel-Last-Hold: 0
448. Caller-Channel-Hold-Accum: 0
449. Caller-Screen-Bit: true
450. Caller-Privacy-Hide-Name: false
451. Caller-Privacy-Hide-Number: false
452. variable_direction: inbound
453. variable_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30
454. variable_session_id: 28510
455. variable_sip_from_user: 8138902220
456. variable_sip_from_uri: 8138902220%40192.168.8.6
457. variable_sip_from_host: 192.168.8.6
458. variable_video_media_flow: disabled
459. variable_text_media_flow: disabled
460. variable_channel_name: sofia/default/8138902220%40192.168.8.6
461. variable_sip_call_id: a2b73d1d-26d9-4a65-b280-1c62b2d98c30
462. variable_sip_local_network_addr: 192.168.8.3
463. variable_sip_network_ip: 192.168.8.6
464. variable_sip_network_port: 5060
465. variable_sip_invite_stamp: 1605793049910318
466. variable_sip_received_ip: 192.168.8.6
467. variable_sip_received_port: 5060
468. variable_sip_via_protocol: udp
469. variable_sip_authorized: true
470. variable_sip_acl_authed_by: default
471. variable_sip_from_user_stripped: 8138902220
472. variable_sip_from_tag: a251beb8-e6dd-4c47-b493-aba69df9be3c
473. variable_sofia_profile_name: default
474. variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060
475. variable_recovery_profile_name: default
476. variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPj3ea88895-62a2-4c68-9a9e-54489e70cdb3
477. variable_sip_from_display: 8138902220
478. variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3Da251beb8-e6dd-4c47-b493-aba69df9be3c
479. variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E
480. variable_sip_allow: OPTIONS,%20SUBSCRIBE,%20NOTIFY,%20PUBLISH,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20PRACK,%20REGISTER,%20MESSAGE,%20REFER
481. variable_sip_req_user: 9088999989
482. variable_sip_req_uri: 9088999989%40192.168.8.3
483. variable_sip_req_host: 192.168.8.3
484. variable_sip_to_user: 9088999989
485. variable_sip_to_uri: 9088999989%40192.168.8.3
486. variable_sip_to_host: 192.168.8.3
487. variable_sip_contact_user: asterisk
488. variable_sip_contact_port: 5060
489. variable_sip_contact_uri: asterisk%40192.168.8.6%3A5060
490. variable_sip_contact_host: 192.168.8.6
491. variable_sip_user_agent: FPBX-14.0.13.40(13.29.2)
492. variable_sip_via_host: 192.168.8.6
493. variable_sip_via_port: 5060
494. variable_sip_via_rport: 5060
495. variable_max_forwards: 70
496. variable_presence_id: 8138902220%40192.168.8.6
497. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201054601244%201054601244%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2016050%20RTP/AVP%200%208%203%20111%209%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A3%20GSM/8000%0D%0Aa%3Drtpmap%3A111%20G726-32/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dmaxptime%3A150%0D%0A
498. variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
499. variable_rtp_use_codec_string: PCMA,PCMU
500. variable_remote_video_media_flow: inactive
501. variable_remote_text_media_flow: inactive
502. variable_remote_audio_media_flow: sendrecv
503. variable_audio_media_flow: sendrecv
504. variable_remote_media_ip: 192.168.8.6
505. variable_remote_media_port: 16050
506. variable_rtp_audio_recv_pt: 0
507. variable_rtp_use_codec_name: PCMU
508. variable_rtp_use_codec_rate: 8000
509. variable_rtp_use_codec_ptime: 20
510. variable_rtp_use_codec_channels: 1
511. variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c
512. variable_read_codec: PCMU
513. variable_original_read_codec: PCMU
514. variable_read_rate: 8000
515. variable_original_read_rate: 8000
516. variable_write_codec: PCMU
517. variable_write_rate: 8000
518. variable_dtmf_type: rfc2833
519. variable_endpoint_disposition: RECEIVED
520. variable_office_status: open
521. variable_extensions: 6350951709
522. variable_no_answer_call_type: 11
523. variable_DP_MATCH: ARRAY%3A%3A9088999989%7C%3A9088999989
524. variable_call_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30
525. variable_current_application_data: 9088999989_open
526. variable_current_application: execute_extension
527. Hunt-Direction: inbound
528. Hunt-Logical-Direction: inbound
529. Hunt-Username: 8138902220
530. Hunt-Dialplan: XML
531. Hunt-Caller-ID-Name: 8138902220
532. Hunt-Caller-ID-Number: 8138902220
533. Hunt-Orig-Caller-ID-Name: 8138902220
534. Hunt-Orig-Caller-ID-Number: 8138902220
535. Hunt-Network-Addr: 192.168.8.6
536. Hunt-ANI: 8138902220
537. Hunt-Destination-Number: 9088999989_open
538. Hunt-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
539. Hunt-Source: mod_sofia
540. Hunt-Context: default
541. Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6
542. Hunt-Profile-Created-Time: 1605793049910318
543. Hunt-Channel-Created-Time: 1605793049910318
544. Hunt-Channel-Answered-Time: 0
545. Hunt-Channel-Progress-Time: 0
546. Hunt-Channel-Progress-Media-Time: 0
547. Hunt-Channel-Hangup-Time: 0
548. Hunt-Channel-Transfer-Time: 0
549. Hunt-Channel-Resurrect-Time: 0
550. Hunt-Channel-Bridged-Time: 0
551. Hunt-Channel-Last-Hold: 0
552. Hunt-Channel-Hold-Accum: 0
553. Hunt-Screen-Bit: true
554. Hunt-Privacy-Hide-Name: false
555. Hunt-Privacy-Hide-Number: false
556.  
557.  
558. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name:
559. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value:
560. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name:
561. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
562. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0
563. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 9088999989
564. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9088999989' limit 1
565. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '9088999989' AND status=0 limit 1
566. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9088999989' and status=0 LIMIT 1
567. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 8138902220 / 8138902220
568. 2020-11-19 14:37:30.030263 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
569. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
570. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" LIMIT 1
571. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : inbound
572. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.8.6") 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 "9088999989"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
573. 2020-11-19 14:37:30.030263 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299]
574. 2020-11-19 14:37:30.030263 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
575. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
576. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" AND A.accountid = '123' limit 1
577. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9088999989
578. 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
579. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
580. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" LIMIT 1
581. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : inbound
582. 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
583. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
584. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="9088999989" AND (accountid = 0 OR status = 1) LIMIT 1
585. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] call_direction :inbound
586. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] DID_ACCOUNTID :138
587. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE (patterns = '^9088999989.*' OR patterns = '^908899998.*' OR patterns = '^90889999.*' OR patterns = '^9088999.*' OR patterns = '^908899.*' OR patterns = '^90889.*' OR patterns = '^9088.*' OR patterns = '^908.*' OR patterns = '^90.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 138 ORDER BY LENGTH(PKGPTR.patterns) DESC
588. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '9088999989' OR number = '908899998' OR number = '90889999' OR number = '9088999' OR number = '908899' OR number = '90889' OR number = '9088' OR number = '908' OR number = '90' OR number = '9' OR number ='--') OR (number = '9088999989*' OR number = '908899998*' OR number = '90889999*' OR number = '9088999*' OR number = '908899*' OR number = '90889*' OR number = '9088*' OR number = '908*' OR number = '90*' OR number = '9*' OR number ='--') OR (number = '8138902220' OR number = '813890222' OR number = '81389022' OR number = '8138902' OR number = '813890' OR number = '81389' OR number = '8138' OR number = '813' OR number = '81' OR number = '8' OR number ='--') OR (number = '8138902220*' OR number = '813890222*' OR number = '81389022*' OR number = '8138902*' OR number = '813890*' OR number = '81389*' OR number = '8138*' OR number = '813*' OR number = '81*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
589. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Call Barring Status : -1
590. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9088999989' OR routing_prefix = '908899998' OR routing_prefix = '90889999' OR routing_prefix = '9088999' OR routing_prefix = '908899' OR routing_prefix = '90889' OR routing_prefix = '9088' OR routing_prefix = '908' OR routing_prefix = '90' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
591. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Account Information ===================
592. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] User id : 123
593. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Account code : 1135674299
594. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Balance : 6856.66
595. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
596. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Ratecard id : 1
597. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] CID Pool : 0
598. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] ========================================================
599. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
600. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_RATES] call_direction :inbound
601. 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
602. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
603. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [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 ="9088999989" LIMIT 1
604. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] call_direction:::::: inbound
605. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] =============== Rates Information ===================
606. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] ID : 47
607. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Connectcost : 0.00000
608. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Includedseconds : 0
609. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Cost : 10.00000
610. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] comment : 9088999989
611. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Country Id : 141
612. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Accid : 123
613. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] ================================================================
614. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Your6856.66 balance Accountid 123 !!!
615. 2020-11-19 14:37:30.050254 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [FIND_MAXLENGTH] Limiting call to config max length 100 mins!
616. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] Call Max length duration : 100 minutes
617. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] INB_FREE:TRUE
618. 2020-11-19 14:37:30.050254 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] free_inbound:1
619. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 123 AND status=0 LIMIT 1
620. 2020-11-19 14:37:30.050254 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
621. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
622. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML:123
623. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Userinfo XML:123
624. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [userinfo] Actual CustomerInfo XML : 123
625. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3
626. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1
627. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition : [{"extensions":"6350951709","no_answer_call_type":"11"}]
628. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition : [{"hour":"00-23","minute":"00-59","wday":"2-2","mday":"1-31","mon":"1-12","year":"2020-2020","extensions":"6350951709","no_answer_call_type":"11","priority":"1"}]
629. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] failover_timecondition_str : 6350951709
630. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] priority : 1
631. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] condition_str :  time-of-day= "00:00-23:59"  wday= "2-2"  mday= "1-31"  mon= "1-12"  year= "2020-2020"
632. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] maxlength::::::::: 100
633. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1
634. 2020-11-19 14:37:30.070249 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng
635. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name:::::::::::::::::::::::::custom_inbound_11
636. 2020-11-19 14:37:30.070249 [INFO] switch_cpp.cpp:1443 [ASTPP] [TIME_COND] timecondition_id : 3
637. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '3' and status =0 LIMIT 1
638. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] time_condition::::::::::::::::::::::::47
639. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] custom_function_name::::::::::::::::::::::::47
640. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
641. <document type="freeswitch/xml">
642. <section name="dialplan" description="ASTPP Dialplan">
643. <context name="default">
644. <extension name="TimeTC" continue="true">
645. <condition time-of-day= "00:01-23:59" break="never">
646. <action application="set" data="office_status=open" inline="true"/>
647. <action application="set" data="extensions=6350951709" inline="true"/>
648. <action application="set" data="no_answer_call_type=11" inline="true"/>
649. </condition>
650. </extension>
651. <extension name="TimeTC" continue="true">
652. <condition  time-of-day= "00:00-23:59"  wday= "2-2"  mday= "1-31"  mon= "1-12"  year= "2020-2020"  break="never">
653. <action application="set" data="office_status=open" inline="true"/>
654. <action application="set" data="extensions=6350951709" inline="true"/>
655. <action application="set" data="no_answer_call_type=11" inline="true"/>
656. </condition>
657. </extension>
658. <extension name="tod route, x9088999989">
659. <condition field="destination_number" expression="^(9088999989)$">
660. <action application="execute_extension" data="9088999989_${office_status}"/>
661. </condition>
662. </extension>
663. <extension name="office is open">
664. <condition field="destination_number" expression="^(9088999989_open)$">
665. <action application="set" data="set_extensions=${extensions}"/>
666. <action application="set" data="no_answer_flag=true"/>
667. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
668. <action application="set" data="no_answer_number=${extensions}" />
669. <action application="transfer" data="138 XML default"/>
670. </condition>
671. </extension>
672. <extension name="9088999989">
673. <condition field="destination_number" expression="9088999989">
674. <action application="set" data="effective_destination_number=9088999989"/>
675. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
676. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
677. <action application="set" data="callstart=2020-11-19 13:37:25"/>
678. <action application="set" data="hangup_after_bridge=true"/>
679. <action application="set" data="continue_on_fail=TRUE"/>
680. <action application="set" data="account_id=123"/>
681. <action application="set" data="parent_id=0"/>
682. <action application="set" data="entity_id=0"/>
683. <action application="set" data="call_processed=internal"/>
684. <action application="set" data="call_direction=inbound"/>
685. <action application="set" data="accountname=HOD1"/>
686. <action application="set" data="origination_rates_did=ID:47|CODE:^9088999989.*|DESTINATION:9088999989|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:10.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:141|ACCID:138"/>
687. <action application="set" data="origination_rates=0"/>
688. <action application="set" data="original_caller_id_name=8138902220"/>
689. <action application="set" data="original_caller_id_number=8138902220"/>
690. <action application="set" data="effective_caller_id_name=8138902220"/>
691. <action application="set" data="effective_caller_id_number=8138902220"/>
692. <action application="set" data="receiver_accid=138"/>
693. <action application="set" data="domain_name=test446.9mobile.nativetalk.com.ng"/>
694. <action application="set" data="sip_to_host=test446.9mobile.nativetalk.com.ng"/>
695. <action application="export" data="domain_name=test446.9mobile.nativetalk.com.ng"/>
696. <action application="export" data="sip_to_host=test446.9mobile.nativetalk.com.ng"/>
697. <action application="export" data="presence_data=x|||martins(1135674299)|||^9088999989.* // 9088999989 // 10.00000||||||DID"/>
698. <action application="export" data="call_type=11"/>
699. </condition>
700. </extension>
701. </context>
702. </section>
703. </document>
704. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true
705. Dialplan: sofia/default/8138902220@192.168.8.6 Date/Time Match (PASS) [TimeTC] break=never
706. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(office_status=open) INLINE
707. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(office_status=open)
708. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [office_status]=[open]
709. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(extensions=6350951709) INLINE
710. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(extensions=6350951709)
711. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [extensions]=[6350951709]
712. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_call_type=11) INLINE
713. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_call_type=11)
714. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_call_type]=[11]
715. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->TimeTC] continue=true
716. Dialplan: sofia/default/8138902220@192.168.8.6 Date/TimeMatch (FAIL) [TimeTC] break=never
717. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->tod route, x9088999989] continue=false
718. Dialplan: sofia/default/8138902220@192.168.8.6 Regex (FAIL) [tod route, x9088999989] destination_number(9088999989_open) =~ /^(9088999989)$/ break=on-false
719. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->office is open] continue=false
720. Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [office is open] destination_number(9088999989_open) =~ /^(9088999989_open)$/ break=on-false
721. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(set_extensions=${extensions})
722. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_flag=true)
723. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_call_type=${no_answer_call_type})
724. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_number=${extensions})
725. Dialplan: sofia/default/8138902220@192.168.8.6 Action transfer(138 XML default)
726. 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(set_extensions=${extensions})
727. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(set_extensions=6350951709)
728. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [set_extensions]=[6350951709]
729. 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(no_answer_flag=true)
730. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_flag=true)
731. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_flag]=[true]
732. 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type})
733. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_call_type=11)
734. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_call_type]=[11]
735. 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] set(no_answer_number=${extensions})
736. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 set(no_answer_number=6350951709)
737. 2020-11-19 14:37:30.070249 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_number]=[6350951709]
738. 2020-11-19 14:37:30.070249 [NOTICE] switch_core_session.c:3017 Execute [depth=1] transfer(138 XML default)
739. EXECUTE [depth=1] sofia/default/8138902220@192.168.8.6 transfer(138 XML default)
740. 2020-11-19 14:37:30.070249 [DEBUG] switch_ivr.c:2231 (sofia/default/8138902220@192.168.8.6) State Change CS_EXECUTE -> CS_ROUTING
741. 2020-11-19 14:37:30.070249 [NOTICE] switch_ivr.c:2238 Transfer sofia/default/8138902220@192.168.8.6 to XML[138@default]
742. 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
743. 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_ROUTING (Cur 1 Tot 28510)
744. 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING
745. 2020-11-19 14:37:30.070249 [DEBUG] mod_sofia.c:145 Call appears to be already acknowledged
746. 2020-11-19 14:37:30.070249 [DEBUG] mod_sofia.c:154 sofia/default/8138902220@192.168.8.6 SOFIA ROUTING
747. 2020-11-19 14:37:30.070249 [DEBUG] switch_core_state_machine.c:236 sofia/default/8138902220@192.168.8.6 Standard ROUTING
748. 2020-11-19 14:37:30.070249 [INFO] mod_dialplan_xml.c:637 Processing 8138902220 <8138902220>->138 in context default
749. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
750. 2020-11-19 14:37:30.070249 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
751. 2020-11-19 14:37:30.090247 [NOTICE] switch_cpp.cpp:1443 [ASTPP] [xml_handler] Params:
752. Event-Name: REQUEST_PARAMS
753. Core-UUID: ab3e105f-e6f4-458f-b102-a4065f4859ae
754. FreeSWITCH-Hostname: soultech
755. FreeSWITCH-Switchname: soultech
756. FreeSWITCH-IPv4: 192.168.8.3
757. FreeSWITCH-IPv6: %3A%3A1
758. Event-Date-Local: 2020-11-19%2014%3A37%3A30
759. Event-Date-GMT: Thu,%2019%20Nov%202020%2013%3A37%3A30%20GMT
760. Event-Date-Timestamp: 1605793050070249
761. Event-Calling-File: mod_dialplan_xml.c
762. Event-Calling-Function: dialplan_xml_locate
763. Event-Calling-Line-Number: 608
764. Event-Sequence: 555778
765. Channel-State: CS_ROUTING
766. Channel-Call-State: RINGING
767. Channel-State-Number: 2
768. Channel-Name: sofia/default/8138902220%40192.168.8.6
769. Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
770. Call-Direction: inbound
771. Presence-Call-Direction: inbound
772. Channel-HIT-Dialplan: true
773. Channel-Presence-ID: 8138902220%40192.168.8.6
774. Channel-Call-UUID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
775. Answer-State: ringing
776. Channel-Read-Codec-Name: PCMU
777. Channel-Read-Codec-Rate: 8000
778. Channel-Read-Codec-Bit-Rate: 64000
779. Channel-Write-Codec-Name: PCMU
780. Channel-Write-Codec-Rate: 8000
781. Channel-Write-Codec-Bit-Rate: 64000
782. Caller-Direction: inbound
783. Caller-Logical-Direction: inbound
784. Caller-Username: 8138902220
785. Caller-Dialplan: XML
786. Caller-Caller-ID-Name: 8138902220
787. Caller-Caller-ID-Number: 8138902220
788. Caller-Orig-Caller-ID-Name: 8138902220
789. Caller-Orig-Caller-ID-Number: 8138902220
790. Caller-Network-Addr: 192.168.8.6
791. Caller-ANI: 8138902220
792. Caller-Destination-Number: 138
793. Caller-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
794. Caller-Source: mod_sofia
795. Caller-Transfer-Source: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML
796. Caller-Context: default
797. Caller-RDNIS: 9088999989_open
798. Caller-Channel-Name: sofia/default/8138902220%40192.168.8.6
799. Caller-Profile-Index: 2
800. Caller-Profile-Created-Time: 1605793050070249
801. Caller-Channel-Created-Time: 1605793049910318
802. Caller-Channel-Answered-Time: 0
803. Caller-Channel-Progress-Time: 0
804. Caller-Channel-Progress-Media-Time: 0
805. Caller-Channel-Hangup-Time: 0
806. Caller-Channel-Transfer-Time: 0
807. Caller-Channel-Resurrect-Time: 0
808. Caller-Channel-Bridged-Time: 0
809. Caller-Channel-Last-Hold: 0
810. Caller-Channel-Hold-Accum: 0
811. Caller-Screen-Bit: true
812. Caller-Privacy-Hide-Name: false
813. Caller-Privacy-Hide-Number: false
814. variable_direction: inbound
815. variable_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30
816. variable_session_id: 28510
817. variable_sip_from_user: 8138902220
818. variable_sip_from_uri: 8138902220%40192.168.8.6
819. variable_sip_from_host: 192.168.8.6
820. variable_video_media_flow: disabled
821. variable_text_media_flow: disabled
822. variable_channel_name: sofia/default/8138902220%40192.168.8.6
823. variable_sip_call_id: a2b73d1d-26d9-4a65-b280-1c62b2d98c30
824. variable_sip_local_network_addr: 192.168.8.3
825. variable_sip_network_ip: 192.168.8.6
826. variable_sip_network_port: 5060
827. variable_sip_invite_stamp: 1605793049910318
828. variable_sip_received_ip: 192.168.8.6
829. variable_sip_received_port: 5060
830. variable_sip_via_protocol: udp
831. variable_sip_authorized: true
832. variable_sip_acl_authed_by: default
833. variable_sip_from_user_stripped: 8138902220
834. variable_sip_from_tag: a251beb8-e6dd-4c47-b493-aba69df9be3c
835. variable_sofia_profile_name: default
836. variable_sofia_profile_url: sip%3Amod_sofia%40192.168.8.3%3A5060
837. variable_recovery_profile_name: default
838. variable_sip_full_via: SIP/2.0/UDP%20192.168.8.6%3A5060%3Brport%3D5060%3Bbranch%3Dz9hG4bKPj3ea88895-62a2-4c68-9a9e-54489e70cdb3
839. variable_sip_from_display: 8138902220
840. variable_sip_full_from: %228138902220%22%20%3Csip%3A8138902220%40192.168.8.6%3E%3Btag%3Da251beb8-e6dd-4c47-b493-aba69df9be3c
841. variable_sip_full_to: %3Csip%3A9088999989%40192.168.8.3%3E
842. variable_sip_allow: OPTIONS,%20SUBSCRIBE,%20NOTIFY,%20PUBLISH,%20INVITE,%20ACK,%20BYE,%20CANCEL,%20UPDATE,%20PRACK,%20REGISTER,%20MESSAGE,%20REFER
843. variable_sip_req_user: 9088999989
844. variable_sip_req_uri: 9088999989%40192.168.8.3
845. variable_sip_req_host: 192.168.8.3
846. variable_sip_to_user: 9088999989
847. variable_sip_to_uri: 9088999989%40192.168.8.3
848. variable_sip_to_host: 192.168.8.3
849. variable_sip_contact_user: asterisk
850. variable_sip_contact_port: 5060
851. variable_sip_contact_uri: asterisk%40192.168.8.6%3A5060
852. variable_sip_contact_host: 192.168.8.6
853. variable_sip_user_agent: FPBX-14.0.13.40(13.29.2)
854. variable_sip_via_host: 192.168.8.6
855. variable_sip_via_port: 5060
856. variable_sip_via_rport: 5060
857. variable_presence_id: 8138902220%40192.168.8.6
858. variable_switch_r_sdp: v%3D0%0D%0Ao%3D-%201054601244%201054601244%20IN%20IP4%20192.168.8.6%0D%0As%3DAsterisk%0D%0Ac%3DIN%20IP4%20192.168.8.6%0D%0At%3D0%200%0D%0Am%3Daudio%2016050%20RTP/AVP%200%208%203%20111%209%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A3%20GSM/8000%0D%0Aa%3Drtpmap%3A111%20G726-32/8000%0D%0Aa%3Drtpmap%3A9%20G722/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0Aa%3Dmaxptime%3A150%0D%0A
859. variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b,CORE_PCM_MODULE.PCMA%408000h%4020i%4064000b
860. variable_rtp_use_codec_string: PCMA,PCMU
861. variable_remote_video_media_flow: inactive
862. variable_remote_text_media_flow: inactive
863. variable_remote_audio_media_flow: sendrecv
864. variable_audio_media_flow: sendrecv
865. variable_remote_media_ip: 192.168.8.6
866. variable_remote_media_port: 16050
867. variable_rtp_audio_recv_pt: 0
868. variable_rtp_use_codec_name: PCMU
869. variable_rtp_use_codec_rate: 8000
870. variable_rtp_use_codec_ptime: 20
871. variable_rtp_use_codec_channels: 1
872. variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c
873. variable_read_codec: PCMU
874. variable_original_read_codec: PCMU
875. variable_read_rate: 8000
876. variable_original_read_rate: 8000
877. variable_write_codec: PCMU
878. variable_write_rate: 8000
879. variable_dtmf_type: rfc2833
880. variable_endpoint_disposition: RECEIVED
881. variable_office_status: open
882. variable_extensions: 6350951709
883. variable_DP_MATCH: ARRAY%3A%3A9088999989_open%7C%3A9088999989_open
884. variable_set_extensions: 6350951709
885. variable_no_answer_flag: true
886. variable_no_answer_call_type: 11
887. variable_no_answer_number: 6350951709
888. variable_current_application_data: 138%20XML%20default
889. variable_current_application: transfer
890. variable_max_forwards: 69
891. variable_transfer_history: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML
892. variable_transfer_source: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML
893. variable_call_uuid: 5c18286f-5ad9-4a3f-a129-a79f09917d30
894. Hunt-Direction: inbound
895. Hunt-Logical-Direction: inbound
896. Hunt-Username: 8138902220
897. Hunt-Dialplan: XML
898. Hunt-Caller-ID-Name: 8138902220
899. Hunt-Caller-ID-Number: 8138902220
900. Hunt-Orig-Caller-ID-Name: 8138902220
901. Hunt-Orig-Caller-ID-Number: 8138902220
902. Hunt-Network-Addr: 192.168.8.6
903. Hunt-ANI: 8138902220
904. Hunt-Destination-Number: 138
905. Hunt-Unique-ID: 5c18286f-5ad9-4a3f-a129-a79f09917d30
906. Hunt-Source: mod_sofia
907. Hunt-Transfer-Source: 1605793050%3A6de6e9a9-e580-433b-a2e6-96b37b72018b%3Abl_xfer%3A138/default/XML
908. Hunt-Context: default
909. Hunt-RDNIS: 9088999989_open
910. Hunt-Channel-Name: sofia/default/8138902220%40192.168.8.6
911. Hunt-Profile-Index: 2
912. Hunt-Profile-Created-Time: 1605793050070249
913. Hunt-Channel-Created-Time: 1605793049910318
914. Hunt-Channel-Answered-Time: 0
915. Hunt-Channel-Progress-Time: 0
916. Hunt-Channel-Progress-Media-Time: 0
917. Hunt-Channel-Hangup-Time: 0
918. Hunt-Channel-Transfer-Time: 0
919. Hunt-Channel-Resurrect-Time: 0
920. Hunt-Channel-Bridged-Time: 0
921. Hunt-Channel-Last-Hold: 0
922. Hunt-Channel-Hold-Accum: 0
923. Hunt-Screen-Bit: true
924. Hunt-Privacy-Hide-Name: false
925. Hunt-Privacy-Hide-Number: false
926.  
927.  
928. 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name:
929. 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name:
930. 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
931. 2020-11-19 14:37:30.090247 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value:
932. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] blind_flag: 0
933. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 138
934. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '138' limit 1
935. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '138' AND status=0 limit 1
936. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '138' and status=0 LIMIT 1
937. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 8138902220 / 8138902220
938. 2020-11-19 14:37:30.110327 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
939. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
940. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [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 ="138" LIMIT 1
941. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [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="138"  AND domains.domain="192.168.8.3" limit 1
942. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
943. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("192.168.8.6") 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 "138"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
944. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 1135674299]
945. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
946. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE number = "1135674299" AND deleted = 0 limit 1
947. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^138.*' OR blocked_patterns = '^13.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 123 limit 1
948. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [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 ="138" AND A.accountid = '123' limit 1
949. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 138
950. 2020-11-19 14:37:30.110327 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
951. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
952. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [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 ="138" LIMIT 1
953. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [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="138"  AND domains.domain="192.168.8.3" limit 1
954. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] New Call direction : outbound
955. 2020-11-19 14:37:30.110327 [NOTICE] switch_cpp.cpp:1443 [ASTPP] HARSH2: 1
956. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
957. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="138" AND (accountid = 0 OR status = 1) LIMIT 1
958. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET domains] Query :SELECT * FROM domains WHERE accountid = 138 limit 1
959. 2020-11-19 14:37:30.110327 [WARNING] switch_cpp.cpp:1443 [ASTPP] [user_domain] user_domaintest446.9mobile.nativetalk.com.ng
960. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
961. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [sandip] accountidSELECT * FROM accounts WHERE id = "138" AND deleted = 0 limit 1
962. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^138.*' OR blocked_patterns = '^13.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 138 limit 1
963. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated ringgroup_no_answer_forward:138
964. 2020-11-19 14:37:30.110327 [INFO] switch_cpp.cpp:1443 [ASTPP] [PBX] call_type : 11
965. 2020-11-19 14:37:30.110327 [DEBUG] switch_cpp.cpp:1443 [ASTPP] Generated XML:
966. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
967. <document type="freeswitch/xml">
968. <section name="dialplan" description="ASTPP Dialplan">
969. <context name="default">
970. <extension name="138">
971. <condition field="destination_number" expression="138">
972. <action application="export" data="bypass_media=true"/>
973. <action application="export" data="did_user_domain=test446.9mobile.nativetalk.com.ng"/>
974. <action application="set" data="continue_on_fail=TRUE"/>
975. <action application="set" data="ignore_early_media=true"/>
976. <action application="set" data="no_answer_flag=false"/>
977. <action application="set" data="did_calltype=11"/>
978. <action application="set" data="did_extensions=6350951709"/>
979. <action application="bridge" data="user/6350951709@test446.9mobile.nativetalk.com.ng"/>
980. </condition>
981. </extension>
982. </context>
983. </section>
984. </document>
985. Dialplan: sofia/default/8138902220@192.168.8.6 parsing [default->138] continue=false
986. Dialplan: sofia/default/8138902220@192.168.8.6 Regex (PASS) [138] destination_number(138) =~ /138/ break=on-false
987. Dialplan: sofia/default/8138902220@192.168.8.6 Action export(bypass_media=true)
988. Dialplan: sofia/default/8138902220@192.168.8.6 Action export(did_user_domain=test446.9mobile.nativetalk.com.ng)
989. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(continue_on_fail=TRUE)
990. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(ignore_early_media=true)
991. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(no_answer_flag=false)
992. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(did_calltype=11)
993. Dialplan: sofia/default/8138902220@192.168.8.6 Action set(did_extensions=6350951709)
994. Dialplan: sofia/default/8138902220@192.168.8.6 Action bridge(user/6350951709@test446.9mobile.nativetalk.com.ng)
995. 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:287 (sofia/default/8138902220@192.168.8.6) State Change CS_ROUTING -> CS_EXECUTE
996. 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:644 (sofia/default/8138902220@192.168.8.6) State ROUTING going to sleep
997. 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 1 Tot 28510)
998. 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE
999. 2020-11-19 14:37:30.110327 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE
1000. 2020-11-19 14:37:30.110327 [DEBUG] switch_core_state_machine.c:329 sofia/default/8138902220@192.168.8.6 Standard EXECUTE
1001. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 export(bypass_media=true)
1002. 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [bypass_media]=[true]
1003. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 export(did_user_domain=test446.9mobile.nativetalk.com.ng)
1004. 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [did_user_domain]=[test446.9mobile.nativetalk.com.ng]
1005. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(continue_on_fail=TRUE)
1006. 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [continue_on_fail]=[TRUE]
1007. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(ignore_early_media=true)
1008. 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [ignore_early_media]=[true]
1009. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(no_answer_flag=false)
1010. 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [no_answer_flag]=[false]
1011. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(did_calltype=11)
1012. 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [did_calltype]=[11]
1013. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 set(did_extensions=6350951709)
1014. 2020-11-19 14:37:30.110327 [DEBUG] mod_dptools.c:1672 SET sofia/default/8138902220@192.168.8.6 [did_extensions]=[6350951709]
1015. EXECUTE [depth=0] sofia/default/8138902220@192.168.8.6 bridge(user/6350951709@test446.9mobile.nativetalk.com.ng)
1016. 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [bypass_media]=[true] to event
1017. 2020-11-19 14:37:30.110327 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [did_user_domain]=[test446.9mobile.nativetalk.com.ng] to event
1018. 2020-11-19 14:37:30.110327 [DEBUG] switch_ivr_originate.c:2212 Parsing global variables
1019. 2020-11-19 14:37:30.150253 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [bypass_media]=[true] to event
1020. 2020-11-19 14:37:30.150253 [DEBUG] switch_channel.c:1264 sofia/default/8138902220@192.168.8.6 EXPORTING[export_vars] [did_user_domain]=[test446.9mobile.nativetalk.com.ng] to event
1021. 2020-11-19 14:37:30.150253 [DEBUG] switch_ivr_originate.c:2212 Parsing global variables
1022. 2020-11-19 14:37:30.150253 [NOTICE] switch_channel.c:1118 New Channel sofia/default/6350951709@197.156.235.60:39572 [1357859f-1159-4416-8535-ecfdb786db2c]
1023. 2020-11-19 14:37:30.150253 [DEBUG] mod_sofia.c:5096 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_NEW -> CS_INIT
1024. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_INIT (Cur 2 Tot 28511)
1025. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:628 (sofia/default/6350951709@197.156.235.60:39572) State INIT
1026. 2020-11-19 14:37:30.150253 [DEBUG] mod_sofia.c:93 sofia/default/6350951709@197.156.235.60:39572 SOFIA INIT
1027. 2020-11-19 14:37:30.150253 [DEBUG] sofia_glue.c:1618 sofia/default/6350951709@197.156.235.60:39572 sending invite version: 1.10.1 -release-12-f9990221e6 64bit
1028. Local SDP:
1029. v=0
1030. o=- 1054601244 1054601244 IN IP4 192.168.8.6
1031. s=Asterisk
1032. c=IN IP4 192.168.8.6
1033. t=0 0
1034. m=audio 16050 RTP/AVP 0 8 3 111 9 101
1035. a=rtpmap:0 PCMU/8000
1036. a=rtpmap:8 PCMA/8000
1037. a=rtpmap:3 GSM/8000
1038. a=rtpmap:111 G726-32/8000
1039. a=rtpmap:9 G722/8000
1040. a=rtpmap:101 telephone-event/8000
1041. a=fmtp:101 0-16
1042. a=ptime:20
1043. a=maxptime:150
1044.  
1045. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:40 sofia/default/6350951709@197.156.235.60:39572 Standard INIT
1046. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:48 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_INIT -> CS_ROUTING
1047. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:628 (sofia/default/6350951709@197.156.235.60:39572) State INIT going to sleep
1048. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_ROUTING (Cur 2 Tot 28511)
1049. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:644 (sofia/default/6350951709@197.156.235.60:39572) State ROUTING
1050. 2020-11-19 14:37:30.150253 [DEBUG] mod_sofia.c:154 sofia/default/6350951709@197.156.235.60:39572 SOFIA ROUTING
1051. 2020-11-19 14:37:30.150253 [DEBUG] switch_ivr_originate.c:67 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_ROUTING -> CS_CONSUME_MEDIA
1052. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:644 (sofia/default/6350951709@197.156.235.60:39572) State ROUTING going to sleep
1053. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 28511)
1054. 2020-11-19 14:37:30.150253 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [calling][0]
1055. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:663 (sofia/default/6350951709@197.156.235.60:39572) State CONSUME_MEDIA
1056. 2020-11-19 14:37:30.150253 [DEBUG] switch_core_state_machine.c:663 (sofia/default/6350951709@197.156.235.60:39572) State CONSUME_MEDIA going to sleep
1057. 2020-11-19 14:37:30.650250 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [proceeding][180]
1058. 2020-11-19 14:37:30.650250 [NOTICE] sofia.c:7401 Ring-Ready sofia/default/6350951709@197.156.235.60:39572!
1059. 2020-11-19 14:37:30.650250 [DEBUG] switch_channel.c:3437 (sofia/default/6350951709@197.156.235.60:39572) Callstate Change DOWN -> RINGING
1060. 2020-11-19 14:37:30.650250 [NOTICE] mod_sofia.c:2505 Ring-Ready sofia/default/8138902220@192.168.8.6!
1061. 2020-11-19 14:37:30.650250 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [early][180]
1062. 2020-11-19 14:37:30.650250 [NOTICE] switch_ivr_originate.c:553 Ring Ready sofia/default/8138902220@192.168.8.6!
1063. 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [completing][200]
1064. 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7300 Remote SDP:
1065. v=0
1066. o=- 8 2 IN IP4 197.156.235.60
1067. s=CounterPath eyeBeam 1.5
1068. c=IN IP4 197.156.235.60
1069. t=0 0
1070. m=audio 26728 RTP/AVP 0 8 101
1071. a=rtpmap:101 telephone-event/8000
1072. a=fmtp:101 0-15
1073.  
1074. 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/6350951709@197.156.235.60:39572 entering state [ready][200]
1075. 2020-11-19 14:37:38.190317 [NOTICE] sofia.c:8430 Channel [sofia/default/6350951709@197.156.235.60:39572] has been answered
1076. 2020-11-19 14:37:38.190317 [DEBUG] switch_channel.c:3865 (sofia/default/6350951709@197.156.235.60:39572) Callstate Change RINGING -> ACTIVE
1077. 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_originate.c:3806 Originate Resulted in Success: [sofia/default/6350951709@197.156.235.60:39572]
1078. 2020-11-19 14:37:38.190317 [NOTICE] switch_ivr.c:820 Channel [sofia/default/8138902220@192.168.8.6] has been answered
1079. 2020-11-19 14:37:38.190317 [DEBUG] switch_channel.c:3865 (sofia/default/8138902220@192.168.8.6) Callstate Change RINGING -> ACTIVE
1080. 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [completed][200]
1081. 2020-11-19 14:37:38.190317 [DEBUG] sofia.c:7290 Channel sofia/default/8138902220@192.168.8.6 entering state [ready][200]
1082. 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_originate.c:3806 Originate Resulted in Success: [sofia/default/6350951709@197.156.235.60:39572]
1083. 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_bridge.c:1590 (sofia/default/8138902220@192.168.8.6) State Change CS_EXECUTE -> CS_HIBERNATE
1084. 2020-11-19 14:37:38.190317 [DEBUG] switch_ivr_bridge.c:1591 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_CONSUME_MEDIA -> CS_HIBERNATE
1085. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
1086. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_HIBERNATE (Cur 2 Tot 28511)
1087. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_HIBERNATE (Cur 2 Tot 28511)
1088. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/6350951709@197.156.235.60:39572) State HIBERNATE
1089. 2020-11-19 14:37:38.190317 [DEBUG] mod_sofia.c:191 sofia/default/6350951709@197.156.235.60:39572 SOFIA HIBERNATE
1090. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:421 sofia/default/6350951709@197.156.235.60:39572 Standard HIBERNATE
1091. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/6350951709@197.156.235.60:39572) State HIBERNATE going to sleep
1092. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/8138902220@192.168.8.6) State HIBERNATE
1093. 2020-11-19 14:37:38.190317 [DEBUG] mod_sofia.c:191 sofia/default/8138902220@192.168.8.6 SOFIA HIBERNATE
1094. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:421 sofia/default/8138902220@192.168.8.6 Standard HIBERNATE
1095. 2020-11-19 14:37:38.190317 [DEBUG] switch_core_state_machine.c:666 (sofia/default/8138902220@192.168.8.6) State HIBERNATE going to sleep
1096. 2020-11-19 14:37:43.410316 [NOTICE] sofia.c:1084 Hangup sofia/default/6350951709@197.156.235.60:39572 [CS_HIBERNATE] [NORMAL_CLEARING]
1097. 2020-11-19 14:37:43.410316 [DEBUG] switch_ivr_bridge.c:1337 sofia/default/6350951709@197.156.235.60:39572 skip receive message [UNBRIDGE] (channel is hungup already)
1098. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_HANGUP (Cur 2 Tot 28511)
1099. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:848 (sofia/default/6350951709@197.156.235.60:39572) Callstate Change ACTIVE -> HANGUP
1100. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/6350951709@197.156.235.60:39572) State HANGUP
1101. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:460 Channel sofia/default/6350951709@197.156.235.60:39572 hanging up, cause: NORMAL_CLEARING
1102. 2020-11-19 14:37:43.410316 [DEBUG] switch_ivr_bridge.c:1473 (sofia/default/8138902220@192.168.8.6) State Change CS_HIBERNATE -> CS_EXECUTE
1103. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_EXECUTE (Cur 2 Tot 28511)
1104. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:60 sofia/default/6350951709@197.156.235.60:39572 Standard HANGUP, cause: NORMAL_CLEARING
1105. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/6350951709@197.156.235.60:39572) State HANGUP going to sleep
1106. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:620 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_HANGUP -> CS_REPORTING
1107. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE
1108. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:209 sofia/default/8138902220@192.168.8.6 SOFIA EXECUTE
1109. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:329 sofia/default/8138902220@192.168.8.6 Standard EXECUTE
1110. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_state_machine.c:386 sofia/default/8138902220@192.168.8.6 has executed the last dialplan instruction, hanging up.
1111. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_state_machine.c:388 Hangup sofia/default/8138902220@192.168.8.6 [CS_EXECUTE] [NORMAL_CLEARING]
1112. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_REPORTING (Cur 2 Tot 28511)
1113. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/6350951709@197.156.235.60:39572) State REPORTING
1114. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:651 (sofia/default/8138902220@192.168.8.6) State EXECUTE going to sleep
1115. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_HANGUP (Cur 2 Tot 28511)
1116. 2020-11-19 14:37:43.410316 [INFO] mod_json_cdr.c:271 Process [1357859f-1159-4416-8535-ecfdb786db2c.cdr.json]
1117. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:848 (sofia/default/8138902220@192.168.8.6) Callstate Change ACTIVE -> HANGUP
1118. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP
1119. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:454 sofia/default/8138902220@192.168.8.6 Overriding SIP cause 480 with 200 from the other leg
1120. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:460 Channel sofia/default/8138902220@192.168.8.6 hanging up, cause: NORMAL_CLEARING
1121. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:514 Sending BYE to sofia/default/8138902220@192.168.8.6
1122. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:60 sofia/default/8138902220@192.168.8.6 Standard HANGUP, cause: NORMAL_CLEARING
1123. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:850 (sofia/default/8138902220@192.168.8.6) State HANGUP going to sleep
1124. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:620 (sofia/default/8138902220@192.168.8.6) State Change CS_HANGUP -> CS_REPORTING
1125. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:585 (sofia/default/8138902220@192.168.8.6) Running State Change CS_REPORTING (Cur 2 Tot 28511)
1126. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING
1127. 2020-11-19 14:37:43.410316 [INFO] mod_json_cdr.c:271 Process [5c18286f-5ad9-4a3f-a129-a79f09917d30.cdr.json]
1128. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:174 sofia/default/6350951709@197.156.235.60:39572 Standard REPORTING, cause: NORMAL_CLEARING
1129. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/6350951709@197.156.235.60:39572) State REPORTING going to sleep
1130. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:611 (sofia/default/6350951709@197.156.235.60:39572) State Change CS_REPORTING -> CS_DESTROY
1131. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_session.c:1726 Session 28511 (sofia/default/6350951709@197.156.235.60:39572) Locked, Waiting on external entities
1132. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1744 Session 28511 (sofia/default/6350951709@197.156.235.60:39572) Ended
1133. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/6350951709@197.156.235.60:39572 [CS_DESTROY]
1134. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:739 (sofia/default/6350951709@197.156.235.60:39572) Running State Change CS_DESTROY (Cur 1 Tot 28511)
1135. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/6350951709@197.156.235.60:39572) State DESTROY
1136. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:365 sofia/default/6350951709@197.156.235.60:39572 SOFIA DESTROY
1137. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:181 sofia/default/6350951709@197.156.235.60:39572 Standard DESTROY
1138. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/6350951709@197.156.235.60:39572) State DESTROY going to sleep
1139. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:174 sofia/default/8138902220@192.168.8.6 Standard REPORTING, cause: NORMAL_CLEARING
1140. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:936 (sofia/default/8138902220@192.168.8.6) State REPORTING going to sleep
1141. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:611 (sofia/default/8138902220@192.168.8.6) State Change CS_REPORTING -> CS_DESTROY
1142. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_session.c:1726 Session 28510 (sofia/default/8138902220@192.168.8.6) Locked, Waiting on external entities
1143. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1744 Session 28510 (sofia/default/8138902220@192.168.8.6) Ended
1144. 2020-11-19 14:37:43.410316 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/8138902220@192.168.8.6 [CS_DESTROY]
1145. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:739 (sofia/default/8138902220@192.168.8.6) Running State Change CS_DESTROY (Cur 0 Tot 28511)
1146. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY
1147. 2020-11-19 14:37:43.410316 [DEBUG] mod_sofia.c:365 sofia/default/8138902220@192.168.8.6 SOFIA DESTROY
1148. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:181 sofia/default/8138902220@192.168.8.6 Standard DESTROY
1149. 2020-11-19 14:37:43.410316 [DEBUG] switch_core_state_machine.c:749 (sofia/default/8138902220@192.168.8.6) State DESTROY going to sleep
1150. 2020-11-19 14:41:21.270318 [NOTICE] switch_channel.c:1118 New Channel sofia/default/200@41.190.24.110 [6441c73a-6690-4d21-99a6-030e4e0fd66a]
1151. 2020-11-19 14:41:21.270318 [DEBUG] switch_core_state_machine.c:585 (sofia/default/200@41.190.24.110) Running State Change CS_NEW (Cur 1 Tot 28512)
1152. 2020-11-19 14:41:21.270318 [DEBUG] sofia.c:10243 sofia/default/200@41.190.24.110 receiving invite from 156.96.150.42:60515 version: 1.10.1 -release-12-f9990221e6 64bit
1153. 2020-11-19 14:41:21.270318 [DEBUG] sofia.c:10337 verifying acl "default" for ip/port 156.96.150.42:0.
1154. 2020-11-19 14:41:21.270318 [WARNING] sofia_reg.c:1793 SIP auth challenge (INVITE) on sofia profile 'default' for [900442037690895@41.190.24.110] from ip 156.96.150.42
1155. 2020-11-19 14:41:21.270318 [DEBUG] switch_core_state_machine.c:604 (sofia/default/200@41.190.24.110) State NEW
1156. 2020-11-19 14:41:21.270318 [DEBUG] sofia.c:2426 detaching session 6441c73a-6690-4d21-99a6-030e4e0fd66a
1157. 2020-11-19 14:41:31.330308 [WARNING] switch_core_state_machine.c:688 6441c73a-6690-4d21-99a6-030e4e0fd66a sofia/default/200@41.190.24.110 Abandoned
1158. 2020-11-19 14:41:31.330308 [NOTICE] switch_core_state_machine.c:691 Hangup sofia/default/200@41.190.24.110 [CS_NEW] [WRONG_CALL_STATE]
1159. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:585 (sofia/default/200@41.190.24.110) Running State Change CS_HANGUP (Cur 1 Tot 28512)
1160. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:848 (sofia/default/200@41.190.24.110) Callstate Change DOWN -> HANGUP
1161. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:850 (sofia/default/200@41.190.24.110) State HANGUP
1162. 2020-11-19 14:41:31.330308 [DEBUG] mod_sofia.c:460 Channel sofia/default/200@41.190.24.110 hanging up, cause: WRONG_CALL_STATE
1163. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:60 sofia/default/200@41.190.24.110 Standard HANGUP, cause: WRONG_CALL_STATE
1164. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:850 (sofia/default/200@41.190.24.110) State HANGUP going to sleep
1165. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:620 (sofia/default/200@41.190.24.110) State Change CS_HANGUP -> CS_REPORTING
1166. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:585 (sofia/default/200@41.190.24.110) Running State Change CS_REPORTING (Cur 1 Tot 28512)
1167. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:936 (sofia/default/200@41.190.24.110) State REPORTING
1168. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:174 sofia/default/200@41.190.24.110 Standard REPORTING, cause: WRONG_CALL_STATE
1169. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:936 (sofia/default/200@41.190.24.110) State REPORTING going to sleep
1170. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:611 (sofia/default/200@41.190.24.110) State Change CS_REPORTING -> CS_DESTROY
1171. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_session.c:1726 Session 28512 (sofia/default/200@41.190.24.110) Locked, Waiting on external entities
1172. 2020-11-19 14:41:31.330308 [NOTICE] switch_core_session.c:1744 Session 28512 (sofia/default/200@41.190.24.110) Ended
1173. 2020-11-19 14:41:31.330308 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/200@41.190.24.110 [CS_DESTROY]
1174. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:739 (sofia/default/200@41.190.24.110) Running State Change CS_DESTROY (Cur 0 Tot 28512)
1175. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:749 (sofia/default/200@41.190.24.110) State DESTROY
1176. 2020-11-19 14:41:31.330308 [DEBUG] mod_sofia.c:365 sofia/default/200@41.190.24.110 SOFIA DESTROY
1177. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:181 sofia/default/200@41.190.24.110 Standard DESTROY
1178. 2020-11-19 14:41:31.330308 [DEBUG] switch_core_state_machine.c:749 (sofia/default/200@41.190.24.110) State DESTROY going to sleep
1179.