From Prashant kumar, 2 Years ago, written in FreeSWITCH.
- go back
Embed
Viewing differences between and Codec error displaying during outbound call
  1.      ┌────────────────────────────────────────────────────────────────────┐
  2.      │                • MobaXterm Personal Edition v20.3 •                │
  3.      │              (X server, SSH client and network tools)              │
  4.      │                                                                    │
  5.      │ ➤ Your computer drives are accessible through the /drives path     │
  6.      │ ➤ Your DISPLAY is set to 192.168.1.13:2.0                          │
  7.      │ ➤ When using SSH, your remote DISPLAY is automatically forwarded   │
  8.      │ ➤ Each command status is specified by a special symbol (✔ or ✘)    │
  9.      │                                                                    │
  10.      │ • Important:                                                       │
  11.      │ This is MobaXterm Personal Edition. The Professional edition       │
  12.      │ allows you to customize MobaXterm for your company: you can add    │
  13.      │ your own logo, your parameters, your welcome message and generate  │
  14.      │ either an MSI installation package or a portable executable.       │
  15.      │ We can also modify MobaXterm or develop the plugins you need.      │
  16.      │ For more information: https://mobaxterm.mobatek.net/download.html  │
  17.      └────────────────────────────────────────────────────────────────────┘
  18.  
  19.   08/02/2022   15:49.31   /home/mobaxterm  ssh -i qa2-Prashant.pem admin@13.233.144.222
  20. X11 forwarding request failed on channel 0
  21. Linux ip-172-31-15-133 4.9.0-16-amd64 #1 SMP Debian 4.9.272-2 (2021-07-19) x86_64
  22.  
  23. The programs included with the Debian GNU/Linux system are free software;
  24. the exact distribution terms for each program are described in the
  25. individual files in /usr/share/doc/*/copyright.
  26.  
  27. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
  28. permitted by applicable law.
  29. Last login: Tue Feb  8 09:55:57 2022 from 150.129.107.251
  30. admin@ip-172-31-15-133:~$
  31. admin@ip-172-31-15-133:~$
  32. admin@ip-172-31-15-133:~$ sudo su
  33. root@ip-172-31-15-133:/home/admin#
  34. root@ip-172-31-15-133:/home/admin#
  35. root@ip-172-31-15-133:/home/admin#
  36. root@ip-172-31-15-133:/home/admin# systemctl status opensips
  37. ● opensips.service - LSB: Start the OpenSIPS SIP server
  38.    Loaded: loaded (/etc/init.d/opensips; generated; vendor preset: enabled)
  39.    Active: active (running) since Tue 2022-02-08 07:16:16 UTC; 3h 3min ago
  40.      Docs: man:systemd-sysv-generator(8)
  41.   Process: 14535 ExecStop=/etc/init.d/opensips stop (code=exited, status=0/SUCCESS)
  42.   Process: 14546 ExecStart=/etc/init.d/opensips start (code=exited, status=0/SUCCESS)
  43.     Tasks: 13 (limit: 4915)
  44.    CGroup: /system.slice/opensips.service
  45.            ├─14565 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  46.            ├─14566 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  47.            ├─14567 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  48.            ├─14568 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  49.            ├─14569 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  50.            ├─14570 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  51.            ├─14571 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  52.            ├─14572 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  53.            ├─14573 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  54.            ├─14574 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  55.            ├─14575 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  56.            ├─14576 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  57.            └─14577 /usr/local/sbin/opensips -P /var/run/opensips/opensips.pid -m 64 -M 4 -u opensips -g opensips -f /usr/local/etc/opens
  58.  
  59. Feb 08 10:19:46 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:46 [14570]  calls getting null acctcode: <null> Feb  8 10:19:46 [14570] C
  60. Feb 08 10:19:46 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:46 [14570] ERROR:auth_db:get_ha1: failed to query database
  61. Feb 08 10:19:48 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:48 [14569] Mjk1NWQzNWQ4YmM4ZDE5ZDAyZmEyNWY4OWQwNjMzYmM.|start|recieved UD
  62. Feb 08 10:19:54 ip-172-31-15-133 opensips[14546]: 4ZDE5ZDAyZmEyNWY4OWQwNjMzYmM.|start|recieved internal reply 200 OKFeb  8 10:19:48 [145
  63. Feb 08 10:19:54 ip-172-31-15-133 opensips[14546]: GE4ZWMzNTE4ZTA3YzllYjIxYzdjMGM.|log|routing call to arbitrary media server 13.233.144.
  64. Feb 08 10:19:54 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:54 [14572] ERROR:core:db_do_raw_query: error while submitting query
  65. Feb 08 10:19:54 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:54 [14572] ERROR:avpops:db_query_avp: raw_query failed: db0(usr_preferenc
  66. Feb 08 10:19:55 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:54 [14572]  calls getting null acctcode: <null> Feb  8 10:19:55 [14571] N
  67. Feb 08 10:19:55 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:55 [14571] ERROR:core:db_do_raw_query: error while submitting query
  68. Feb 08 10:19:55 ip-172-31-15-133 opensips[14546]: Feb  8 10:19:55 [14571] ERROR:avpops:db_query_avp: raw_query failed: db0(usr_preferenc
  69. root@ip-172-31-15-133:/home/admin#
  70. root@ip-172-31-15-133:/home/admin#
  71. root@ip-172-31-15-133:/home/admin# systemctl stop opensips
  72. root@ip-172-31-15-133:/home/admin#
  73. root@ip-172-31-15-133:/home/admin#
  74. root@ip-172-31-15-133:/home/admin# systemctl status opensips
  75. ● opensips.service - LSB: Start the OpenSIPS SIP server
  76.    Loaded: loaded (/etc/init.d/opensips; generated; vendor preset: enabled)
  77.    Active: inactive (dead)
  78.      Docs: man:systemd-sysv-generator(8)
  79.  
  80. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 12(14577) [Timer handler]
  81. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 1(14566) [MI FIFO] termin
  82. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 5(14570) [SIP receiver ud
  83. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 11(14576) [SIP receiver u
  84. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 2(14567) [time_keeper] te
  85. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 3(14568) [timer] terminat
  86. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 4(14569) [SIP receiver ud
  87. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:shutdown_opensips: process 10(14575) [SIP receiver u
  88. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Feb  8 10:20:09 [14565] INFO:core:cleanup: cleanup
  89. Feb 08 10:20:09 ip-172-31-15-133 opensips[14546]: Thank you for running opensips
  90. root@ip-172-31-15-133:/home/admin#
  91. root@ip-172-31-15-133:/home/admin#
  92. root@ip-172-31-15-133:/home/admin# systemctl restart freeswitch
  93. You have new mail in /var/mail/root
  94. root@ip-172-31-15-133:/home/admin#
  95. You have new mail in /var/mail/root
  96. root@ip-172-31-15-133:/home/admin#
  97. root@ip-172-31-15-133:/home/admin#
  98. root@ip-172-31-15-133:/home/admin#
  99. root@ip-172-31-15-133:/home/admin#
  100. root@ip-172-31-15-133:/home/admin# cd /opt/ASTPP/freeswitch/scripts/
  101. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts#
  102. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts#
  103. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts# ls
  104. addons.lua  astpp  astpp-callingcards.lua  did_call_forwarding.lua  priority_base_routing.lua
  105. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts#
  106. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts# cd astpp
  107. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  108. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  109. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# ls
  110. astpp_cent7.lua  astpp_deb9.lua  astpp.lua  constant.lua  lib  scripts
  111. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  112. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# vim astpp.lua
  113. You have new mail in /var/mail/root
  114. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  115. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  116. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  117. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  118. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# ls
  119. astpp_cent7.lua  astpp_deb9.lua  astpp.lua  constant.lua  lib  scripts
  120. You have new mail in /var/mail/root
  121. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  122. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# vim astpp_
  123. astpp_cent7.lua  astpp_deb9.lua
  124. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# vim astpp_
  125. astpp_cent7.lua  astpp_deb9.lua
  126. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# vim astpp_deb9.lua
  127. You have new mail in /var/mail/root
  128. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  129. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  130. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  131. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp#
  132. root@ip-172-31-15-133:/opt/ASTPP/freeswitch/scripts/astpp# cd /usr/share/freeswitch/scripts
  133. You have new mail in /var/mail/root
  134. root@ip-172-31-15-133:/usr/share/freeswitch/scripts#
  135. root@ip-172-31-15-133:/usr/share/freeswitch/scripts# vim astpp
  136. root@ip-172-31-15-133:/usr/share/freeswitch/scripts#
  137. root@ip-172-31-15-133:/usr/share/freeswitch/scripts#
  138. root@ip-172-31-15-133:/usr/share/freeswitch/scripts# cd astpp/
  139. astpp_cent7.lua  astpp_deb9.lua   astpp.lua        constant.lua     lib/             scripts/
  140. root@ip-172-31-15-133:/usr/share/freeswitch/scripts# cd astpp/
  141. astpp_cent7.lua  astpp_deb9.lua   astpp.lua        constant.lua     lib/             scripts/
  142. root@ip-172-31-15-133:/usr/share/freeswitch/scripts# cd astpp/
  143. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  144. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  145. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp# vim astpp.lua
  146. You have new mail in /var/mail/root
  147. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  148. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  149. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  150. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  151. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  152.  
  153. You have new mail in /var/mail/root
  154. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  155. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  156. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  157. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp#
  158. root@ip-172-31-15-133:/usr/share/freeswitch/scripts/astpp# fs_cli -pd8WYJaV7YZn88jvEqw1U
  159. .=======================================================.
  160. |            _____ ____     ____ _     ___              |
  161. |           |  ___/ ___|   / ___| |   |_ _|             |
  162. |           | |_  \___ \  | |   | |    | |              |
  163. |           |  _|  ___) | | |___| |___ | |              |
  164. |           |_|   |____/   \____|_____|___|             |
  165. |                                                       |
  166. .=======================================================.
  167. | Anthony Minessale II, Ken Rice,                       |
  168. | Michael Jerris, Travis Cross                          |
  169. | FreeSWITCH (http://www.freeswitch.org)                |
  170. | Paypal Donations Appreciated: paypal@freeswitch.org   |
  171. | Brought to you by ClueCon http://www.cluecon.com/     |
  172. .=======================================================.
  173.  
  174. .=======================================================================================================.
  175. |       _                            _    ____ _             ____                                       |
  176. |      / \   _ __  _ __  _   _  __ _| |  / ___| |_   _  ___ / ___|___  _ __                             |
  177. |     / _ \ | '_ \| '_ \| | | |/ _` | | | |   | | | | |/ _ \ |   / _ \| '_ \                            |
  178. |    / ___ \| | | | | | | |_| | (_| | | | |___| | |_| |  __/ |__| (_) | | | |                           |
  179. |   /_/   \_\_| |_|_| |_|\__,_|\__,_|_|  \____|_|\__,_|\___|\____\___/|_| |_|                           |
  180. |                                                                                                       |
  181. |    ____ _____ ____    ____             __                                                             |
  182. |   |  _ \_   _/ ___|  / ___|___  _ __  / _| ___ _ __ ___ _ __   ___ ___                                |
  183. |   | |_) || || |     | |   / _ \| '_ \| |_ / _ \ '__/ _ \ '_ \ / __/ _ \                               |
  184. |   |  _ < | || |___  | |__| (_) | | | |  _|  __/ | |  __/ | | | (_|  __/                               |
  185. |   |_| \_\|_| \____|  \____\___/|_| |_|_|  \___|_|  \___|_| |_|\___\___|                               |
  186. |                                                                                                       |
  187. |     ____ _             ____                                                                           |
  188. |    / ___| |_   _  ___ / ___|___  _ __         ___ ___  _ __ ___                                       |
  189. |   | |   | | | | |/ _ \ |   / _ \| '_ \       / __/ _ \| '_ ` _ \                                      |
  190. |   | |___| | |_| |  __/ |__| (_) | | | |  _  | (_| (_) | | | | | |                                     |
  191. |    \____|_|\__,_|\___|\____\___/|_| |_| (_)  \___\___/|_| |_| |_|                                     |
  192. |                                                                                                       |
  193. .=======================================================================================================.
  194.  
  195. Type /help <enter> to see a list of commands
  196.  
  197.  
  198.  
  199.  
  200. [This app Best viewed at 160x60 or more..]
  201. +OK log level  [7]
  202. freeswitch@ip-172-31-15-133>
  203. freeswitch@ip-172-31-15-133>
  204. freeswitch@ip-172-31-15-133>
  205. freeswitch@ip-172-31-15-133>
  206. 2022-02-08 11:01:26.588026 96.43% [NOTICE] sofia_reg.c:459 Registering Alpesh
  207. 2022-02-08 11:01:26.728029 96.43% [ERR] sofia_reg.c:2677 Alpesh Failed Registration with status Service Unavailable [503]. failure #32
  208. 2022-02-08 11:01:27.588022 96.43% [WARNING] sofia_reg.c:516 Alpesh Failed Registration [503], setting retry to 30 seconds.
  209. 2022-02-08 11:01:32.548054 97.07% [NOTICE] switch_channel.c:1123 New Channel sofia/default/+1604785422@46.101.114.158 [b4bb4fe3-84c5-499b-a511-1f4b04908127]
  210. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_NEW (Cur 1 Tot 15)
  211. 2022-02-08 11:01:32.548054 97.07% [INFO] sofia.c:10462 sofia/default/+1604785422@46.101.114.158 receiving invite from 46.101.114.158:5077 version: 1.10.7 -release-19-883d2cb662 64bit call-id: 50d9700b-0371-123b-d299-ba05d31eb9f9
  212. 2022-02-08 11:01:32.548054 97.07% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 46.101.114.158:0.
  213. 2022-02-08 11:01:32.548054 97.07% [DEBUG] sofia.c:10585 IP 46.101.114.158 Approved by acl "default[]". Access Granted.
  214. 2022-02-08 11:01:32.548054 97.07% [DEBUG] sofia.c:7499 Channel sofia/default/+1604785422@46.101.114.158 entering state [received][100]
  215. 2022-02-08 11:01:32.548054 97.07% [DEBUG] sofia.c:7509 Remote SDP:
  216. v=0
  217. o=FreeSWITCH 1644284828 1644284829 IN IP4 46.101.114.158
  218. s=FreeSWITCH
  219. c=IN IP4 46.101.114.158
  220. t=0 0
  221. m=audio 33264 RTP/AVP 0 101
  222. a=rtpmap:0 PCMU/8000
  223. a=rtpmap:101 telephone-event/8000
  224. a=fmtp:101 0-16
  225. a=ptime:20
  226.  
  227. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  228. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  229. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  230. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  231. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/+1604785422@46.101.114.158 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
  232. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_codec.c:111 sofia/default/+1604785422@46.101.114.158 Original read codec set to PCMU:0
  233. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  234. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_media.c:5973 sofia/default/+1604785422@46.101.114.158 Set 2833 dtmf send payload to 101 recv payload to 101
  235. 2022-02-08 11:01:32.548054 97.07% [DEBUG] sofia.c:7933 (sofia/default/+1604785422@46.101.114.158) State Change CS_NEW -> CS_INIT
  236. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:600 (sofia/default/+1604785422@46.101.114.158) State NEW
  237. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_INIT (Cur 1 Tot 15)
  238. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:624 (sofia/default/+1604785422@46.101.114.158) State INIT
  239. 2022-02-08 11:01:32.548054 97.07% [DEBUG] mod_sofia.c:97 sofia/default/+1604785422@46.101.114.158 SOFIA INIT
  240. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:40 sofia/default/+1604785422@46.101.114.158 Standard INIT
  241. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:48 (sofia/default/+1604785422@46.101.114.158) State Change CS_INIT -> CS_ROUTING
  242. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:624 (sofia/default/+1604785422@46.101.114.158) State INIT going to sleep
  243. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_ROUTING (Cur 1 Tot 15)
  244. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_channel.c:2380 (sofia/default/+1604785422@46.101.114.158) Callstate Change DOWN -> RINGING
  245. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:640 (sofia/default/+1604785422@46.101.114.158) State ROUTING
  246. 2022-02-08 11:01:32.548054 97.07% [DEBUG] mod_sofia.c:158 sofia/default/+1604785422@46.101.114.158 SOFIA ROUTING
  247. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_core_state_machine.c:230 sofia/default/+1604785422@46.101.114.158 Standard ROUTING
  248. 2022-02-08 11:01:32.548054 97.07% [INFO] mod_dialplan_xml.c:639 Processing 1604785422 <+1604785422>->109560 in context default
  249. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes')
  250. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  251. 2022-02-08 11:01:32.548054 97.07% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [xml_handler] Params:
  252. Event-Name: REQUEST_PARAMS
  253. Core-UUID: dae52d9c-ce8e-4d58-8937-6f103a597dbe
  254. FreeSWITCH-Hostname: ip-172-31-15-133
  255. FreeSWITCH-Switchname: ip-172-31-15-133
  256. FreeSWITCH-IPv4: 172.31.15.133
  257. FreeSWITCH-IPv6: %3A%3A1
  258. Event-Date-Local: 2022-02-08%2011%3A01%3A32
  259. Event-Date-GMT: Tue,%2008%20Feb%202022%2011%3A01%3A32%20GMT
  260. Event-Date-Timestamp: 1644318092548054
  261. Event-Calling-File: mod_dialplan_xml.c
  262. Event-Calling-Function: dialplan_xml_locate
  263. Event-Calling-Line-Number: 610
  264. Event-Sequence: 2052
  265. Channel-State: CS_ROUTING
  266. Channel-Call-State: RINGING
  267. Channel-State-Number: 2
  268. Channel-Name: sofia/default/%2B1604785422%4046.101.114.158
  269. Unique-ID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  270. Call-Direction: inbound
  271. Presence-Call-Direction: inbound
  272. Channel-HIT-Dialplan: true
  273. Channel-Presence-ID: %2B1604785422%4046.101.114.158
  274. Channel-Call-UUID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  275. Answer-State: ringing
  276. Channel-Read-Codec-Name: PCMU
  277. Channel-Read-Codec-Rate: 8000
  278. Channel-Read-Codec-Bit-Rate: 64000
  279. Channel-Write-Codec-Name: PCMU
  280. Channel-Write-Codec-Rate: 8000
  281. Channel-Write-Codec-Bit-Rate: 64000
  282. Caller-Direction: inbound
  283. Caller-Logical-Direction: inbound
  284. Caller-Username: %2B1604785422
  285. Caller-Dialplan: XML
  286. Caller-Caller-ID-Name: 1604785422
  287. Caller-Caller-ID-Number: %2B1604785422
  288. Caller-Orig-Caller-ID-Name: 1604785422
  289. Caller-Orig-Caller-ID-Number: %2B1604785422
  290. Caller-Network-Addr: 46.101.114.158
  291. Caller-ANI: %2B1604785422
  292. Caller-Destination-Number: 109560
  293. Caller-Unique-ID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  294. Caller-Source: mod_sofia
  295. Caller-Context: default
  296. Caller-Channel-Name: sofia/default/%2B1604785422%4046.101.114.158
  297. Caller-Profile-Index: 1
  298. Caller-Profile-Created-Time: 1644318092548054
  299. Caller-Channel-Created-Time: 1644318092548054
  300. Caller-Channel-Answered-Time: 0
  301. Caller-Channel-Progress-Time: 0
  302. Caller-Channel-Progress-Media-Time: 0
  303. Caller-Channel-Hangup-Time: 0
  304. Caller-Channel-Transfer-Time: 0
  305. Caller-Channel-Resurrect-Time: 0
  306. Caller-Channel-Bridged-Time: 0
  307. Caller-Channel-Last-Hold: 0
  308. Caller-Channel-Hold-Accum: 0
  309. Caller-Screen-Bit: true
  310. Caller-Privacy-Hide-Name: false
  311. Caller-Privacy-Hide-Number: false
  312. variable_direction: inbound
  313. variable_uuid: b4bb4fe3-84c5-499b-a511-1f4b04908127
  314. variable_session_id: 15
  315. variable_sip_from_user: %2B1604785422
  316. variable_sip_from_uri: %2B1604785422%4046.101.114.158
  317. variable_sip_from_host: 46.101.114.158
  318. variable_video_media_flow: disabled
  319. variable_text_media_flow: disabled
  320. variable_channel_name: sofia/default/%2B1604785422%4046.101.114.158
  321. variable_sip_call_id: 50d9700b-0371-123b-d299-ba05d31eb9f9
  322. variable_sip_local_network_addr: 13.233.144.222
  323. variable_sip_network_ip: 46.101.114.158
  324. variable_sip_network_port: 5077
  325. variable_sip_invite_stamp: 1644318092548054
  326. variable_sip_received_ip: 46.101.114.158
  327. variable_sip_received_port: 5077
  328. variable_sip_via_protocol: udp
  329. variable_sip_authorized: true
  330. variable_sip_acl_authed_by: default
  331. variable_sip_from_user_stripped: 1604785422
  332. variable_sip_from_tag: v0DSSvja86jKr
  333. variable_sofia_profile_name: default
  334. variable_sofia_profile_url: sip%3Amod_sofia%4013.233.144.222%3A5074
  335. variable_recovery_profile_name: default
  336. variable_sip_Remote-Party-ID: %221604785422%22%20%3Csip%3A%2B1604785422%4046.101.114.158%3E%3Bparty%3Dcalling%3Bscreen%3Dyes%3Bprivacy%3Doff
  337. variable_sip_cid_type: rpid
  338. variable_sip_full_via: SIP/2.0/UDP%2046.101.114.158%3A5077%3Brport%3D5077%3Bbranch%3Dz9hG4bKQ9yF4ap3D8e3F
  339. variable_sip_from_display: 1604785422
  340. variable_sip_full_from: %221604785422%22%20%3Csip%3A%2B1604785422%4046.101.114.158%3E%3Btag%3Dv0DSSvja86jKr
  341. variable_sip_full_to: %3Csip%3A109560%4013.233.144.222%3A5074%3E
  342. variable_sip_allow: INVITE,%20ACK,%20BYE,%20CANCEL,%20OPTIONS,%20MESSAGE,%20INFO,%20UPDATE,%20REGISTER,%20REFER,%20NOTIFY,%20PUBLISH,%20SUBSCRIBE
  343. variable_sip_req_user: 109560
  344. variable_sip_req_port: 5074
  345. variable_sip_req_uri: 109560%4013.233.144.222%3A5074
  346. variable_sip_req_host: 13.233.144.222
  347. variable_sip_to_user: 109560
  348. variable_sip_to_port: 5074
  349. variable_sip_to_uri: 109560%4013.233.144.222%3A5074
  350. variable_sip_to_host: 13.233.144.222
  351. variable_sip_contact_params: transport%3Dudp%3Bgw%3DPK-Default-Gateway
  352. variable_sip_contact_user: gw%2BPK-Default-Gateway
  353. variable_sip_contact_port: 5077
  354. variable_sip_contact_uri: gw%2BPK-Default-Gateway%4046.101.114.158%3A5077
  355. variable_sip_contact_host: 46.101.114.158
  356. variable_sip_user_agent: ASTPP
  357. variable_sip_via_host: 46.101.114.158
  358. variable_sip_via_port: 5077
  359. variable_sip_via_rport: 5077
  360. variable_max_forwards: 69
  361. variable_presence_id: %2B1604785422%4046.101.114.158
  362. variable_switch_r_sdp: v%3D0%0D%0Ao%3DFreeSWITCH%201644284828%201644284829%20IN%20IP4%2046.101.114.158%0D%0As%3DFreeSWITCH%0D%0Ac%3DIN%20IP4%2046.101.114.158%0D%0At%3D0%200%0D%0Am%3Daudio%2033264%20RTP/AVP%200%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0A
  363. variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b
  364. variable_rtp_use_codec_string: PCMU,PCMA
  365. variable_remote_video_media_flow: inactive
  366. variable_remote_text_media_flow: inactive
  367. variable_remote_audio_media_flow: sendrecv
  368. variable_audio_media_flow: sendrecv
  369. variable_remote_media_ip: 46.101.114.158
  370. variable_remote_media_port: 33264
  371. variable_rtp_audio_recv_pt: 0
  372. variable_rtp_use_codec_name: PCMU
  373. variable_rtp_use_codec_rate: 8000
  374. variable_rtp_use_codec_ptime: 20
  375. variable_rtp_use_codec_channels: 1
  376. variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c
  377. variable_read_codec: PCMU
  378. variable_original_read_codec: PCMU
  379. variable_read_rate: 8000
  380. variable_original_read_rate: 8000
  381. variable_write_codec: PCMU
  382. variable_write_rate: 8000
  383. variable_dtmf_type: rfc2833
  384. variable_endpoint_disposition: RECEIVED
  385. variable_call_uuid: b4bb4fe3-84c5-499b-a511-1f4b04908127
  386. Hunt-Direction: inbound
  387. Hunt-Logical-Direction: inbound
  388. Hunt-Username: %2B1604785422
  389. Hunt-Dialplan: XML
  390. Hunt-Caller-ID-Name: 1604785422
  391. Hunt-Caller-ID-Number: %2B1604785422
  392. Hunt-Orig-Caller-ID-Name: 1604785422
  393. Hunt-Orig-Caller-ID-Number: %2B1604785422
  394. Hunt-Network-Addr: 46.101.114.158
  395. Hunt-ANI: %2B1604785422
  396. Hunt-Destination-Number: 109560
  397. Hunt-Unique-ID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  398. Hunt-Source: mod_sofia
  399. Hunt-Context: default
  400. Hunt-Channel-Name: sofia/default/%2B1604785422%4046.101.114.158
  401. Hunt-Profile-Index: 1
  402. Hunt-Profile-Created-Time: 1644318092548054
  403. Hunt-Channel-Created-Time: 1644318092548054
  404. Hunt-Channel-Answered-Time: 0
  405. Hunt-Channel-Progress-Time: 0
  406. Hunt-Channel-Progress-Media-Time: 0
  407. Hunt-Channel-Hangup-Time: 0
  408. Hunt-Channel-Transfer-Time: 0
  409. Hunt-Channel-Resurrect-Time: 0
  410. Hunt-Channel-Bridged-Time: 0
  411. Hunt-Channel-Last-Hold: 0
  412. Hunt-Channel-Hold-Accum: 0
  413. Hunt-Screen-Bit: true
  414. Hunt-Privacy-Hide-Name: false
  415. Hunt-Privacy-Hide-Number: false
  416.  
  417.  
  418. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_value:
  419. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] tag_name:
  420. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_name:
  421. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] section: dialplan
  422. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 109560
  423. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '109560' AND status=0 limit 1
  424. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+PK-Default-Gateway
  425. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  426. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '109560' limit 1
  427. 2022-02-08 11:01:32.548054 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 1604785422 / +1604785422
  428. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [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, A.codec as did_codec FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  429. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  430. 2022-02-08 11:01:32.548054 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  431. 2022-02-08 11:01:32.568001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  432. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [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("46.101.114.158") 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 "109560"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  433. 2022-02-08 11:01:32.568001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 3673942894]
  434. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "3673942894" AND deleted = 0 limit 1
  435. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT balance FROM accounts WHERE id =4
  436. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="109560" AND (accountid = 0 OR status = 1) LIMIT 1
  437. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  438. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 4
  439. 2022-02-08 11:01:32.568001 97.07% [DEBUG] switch_cpp.cpp:1465 [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 = '^109560.*' OR patterns = '^10956.*' OR patterns = '^1095.*' OR patterns = '^109.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 4 ORDER BY LENGTH(PKGPTR.patterns) DESC
  440. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [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 ="109560" AND A.accountid = '3' limit 1
  441. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 109560
  442. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [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, A.codec as did_codec FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  443. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  444. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  445. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  446. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '109560' OR number = '10956' OR number = '1095' OR number = '109' OR number = '10' OR number = '1' OR number ='--') OR (number = '109560*' OR number = '10956*' OR number = '1095*' OR number = '109*' OR number = '10*' OR number = '1*' OR number ='--') OR (number = '+1604785422' OR number = '+160478542' OR number = '+16047854' OR number = '+1604785' OR number = '+160478' OR number = '+16047' OR number = '+1604' OR number = '+160' OR number = '+16' OR number = '+1' OR number = '+' OR number ='--') OR (number = '+1604785422*' OR number = '+160478542*' OR number = '+16047854*' OR number = '+1604785*' OR number = '+160478*' OR number = '+16047*' OR number = '+1604*' OR number = '+160*' OR number = '+16*' OR number = '+1*' OR number = '+*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  447. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  448. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '109560' OR routing_prefix = '10956' OR routing_prefix = '1095' OR routing_prefix = '109' OR routing_prefix = '10' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  449. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  450. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 3
  451. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 3673942894
  452. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT balance FROM accounts WHERE id =4
  453. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 297.2211
  454. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  455. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  456. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  457. 2022-02-08 11:01:32.588003 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  458. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  459. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  460. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [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, A.codec as did_codec FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  461. 2022-02-08 11:01:32.588003 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  462. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  463. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  464. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  465. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.00000
  466. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
  467. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday from demand_based_routing where pricelist_id = '1' and status=0
  468. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.00000
  469. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  470. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 1
  471. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  472. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  473. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  474. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 109560
  475. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
  476. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 3
  477. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  478. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT balance FROM accounts WHERE id =4
  479. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your297.2211 balance Accountid 3 !!!
  480. 2022-02-08 11:01:32.608002 97.07% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  481. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  482. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  483. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  484. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 3 AND status=0 LIMIT 1
  485. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "4" AND deleted = 0 limit 1
  486. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:3
  487. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:3
  488. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 3
  489. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  490. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  491. 2022-02-08 11:01:32.608002 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 0
  492. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 4  and status = 0 limit 1
  493. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_4
  494. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  495. <document type="freeswitch/xml">
  496. <section name="dialplan" description="ASTPP Dialplan">
  497. <context name="default">
  498. <extension name="109560">
  499. <condition field="destination_number" expression="109560">
  500. <action application="set" data="effective_destination_number=109560"/>
  501. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  502. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  503. <action application="set" data="callstart=2022-02-08 11:01:32"/>
  504. <action application="set" data="hangup_after_bridge=true"/>
  505. <action application="set" data="continue_on_fail=TRUE"/>
  506. <action application="set" data="account_id=3"/>
  507. <action application="set" data="parent_id=0"/>
  508. <action application="set" data="entity_id=3"/>
  509. <action application="set" data="call_processed=internal"/>
  510. <action application="set" data="call_direction=inbound"/>
  511. <action application="set" data="accountname=EntDemo"/>
  512. <action application="set" data="origination_rates_did=ID:1|CODE:^109560.*|DESTINATION:109560|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:4"/>
  513. <action application="set" data="origination_rates=0"/>
  514. <action application="set" data="original_caller_id_name=1604785422"/>
  515. <action application="set" data="original_caller_id_number=+1604785422"/>
  516. <action application="export" data="is_recording=1"/>
  517. <action application="export" data="media_bug_answer_req=true"/>
  518. <action application="export" data="record_sample_rate=8000"/>
  519. <action application="export" data="execute_on_answer=record_session $${recordings_dir}/${uuid}.wav"/>
  520. <action application="set" data="effective_caller_id_name=1604785422"/>
  521. <action application="set" data="effective_caller_id_number=+1604785422"/>
  522. <action application="set" data="receiver_accid=4"/>
  523. <action application="set" data="did_id=1"/>
  524. <action application="set" data="transfer_call_type=4"/>
  525. <action application="set" data="transfer_extensions=7701150005"/>
  526. <action application="set" data="busy_status=1"/>
  527. <action application="set" data="no_answer_status=1"/>
  528. <action application="set" data="always_status=0"/>
  529. <action application="set" data="transfer_status=0"/>
  530. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  531. <action application="export" data="domain_name="/>
  532. <action application="export" data="sip_to_host="/>
  533. <action application="export" data="presence_data=x|||admin's(5365342801)|||||||||DID|||46.101.114.158"/>
  534. <action application="export" data="call_type=4"/>
  535. <action application="set" data="calltype=STANDARD"/>
  536. <action application="set" data="accountcode=5365342801"/>
  537. <action application="set" data="caller_did_account_id=3"/>
  538. <action application="set" data="did_number=109560"/>
  539. <action application="set" data="did_init_inc=0"/>
  540. <action application="set" data="did_inc=0"/>
  541. <action application="set" data="did_cost=0.00000"/>
  542. <action application="set" data="did_connectcost=0.00000"/>
  543. <action application="set" data="origination_rates_did=0"/>
  544. <action application="transfer" data="7701150005 XML default"/>
  545. </condition>
  546. </extension>
  547. </context>
  548. </section>
  549. </document>
  550. Dialplan: sofia/default/+1604785422@46.101.114.158 parsing [default->109560] continue=false
  551. Dialplan: sofia/default/+1604785422@46.101.114.158 Regex (PASS) [109560] destination_number(109560) =~ /109560/ break=on-false
  552. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(effective_destination_number=109560)
  553. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  554. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  555. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(callstart=2022-02-08 11:01:32)
  556. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(hangup_after_bridge=true)
  557. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(continue_on_fail=TRUE)
  558. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(account_id=3)
  559. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(parent_id=0)
  560. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(entity_id=3)
  561. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(call_processed=internal)
  562. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(call_direction=inbound)
  563. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(accountname=EntDemo)
  564. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(origination_rates_did=ID:1|CODE:^109560.*|DESTINATION:109560|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:4)
  565. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(origination_rates=0)
  566. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(original_caller_id_name=1604785422)
  567. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(original_caller_id_number=+1604785422)
  568. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(is_recording=1)
  569. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(media_bug_answer_req=true)
  570. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(record_sample_rate=8000)
  571. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(execute_on_answer=record_session $${recordings_dir}/${uuid}.wav)
  572. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(effective_caller_id_name=1604785422)
  573. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(effective_caller_id_number=+1604785422)
  574. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(receiver_accid=4)
  575. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(did_id=1)
  576. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(transfer_call_type=4)
  577. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(transfer_extensions=7701150005)
  578. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(busy_status=1)
  579. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(no_answer_status=1)
  580. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(always_status=0)
  581. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(transfer_status=0)
  582. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(variable_sip_to_host=${domain_name})
  583. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(domain_name=)
  584. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(sip_to_host=)
  585. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(presence_data=x|||admin's(5365342801)|||||||||DID|||46.101.114.158)
  586. Dialplan: sofia/default/+1604785422@46.101.114.158 Action export(call_type=4)
  587. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(calltype=STANDARD)
  588. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(accountcode=5365342801)
  589. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(caller_did_account_id=3)
  590. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(did_number=109560)
  591. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(did_init_inc=0)
  592. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(did_inc=0)
  593. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(did_cost=0.00000)
  594. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(did_connectcost=0.00000)
  595. Dialplan: sofia/default/+1604785422@46.101.114.158 Action set(origination_rates_did=0)
  596. Dialplan: sofia/default/+1604785422@46.101.114.158 Action transfer(7701150005 XML default)
  597. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_core_state_machine.c:281 (sofia/default/+1604785422@46.101.114.158) State Change CS_ROUTING -> CS_EXECUTE
  598. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_core_state_machine.c:640 (sofia/default/+1604785422@46.101.114.158) State ROUTING going to sleep
  599. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_EXECUTE (Cur 1 Tot 15)
  600. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_core_state_machine.c:647 (sofia/default/+1604785422@46.101.114.158) State EXECUTE
  601. 2022-02-08 11:01:32.608002 97.07% [DEBUG] mod_sofia.c:213 sofia/default/+1604785422@46.101.114.158 SOFIA EXECUTE
  602. 2022-02-08 11:01:32.608002 97.07% [DEBUG] switch_core_state_machine.c:323 sofia/default/+1604785422@46.101.114.158 Standard EXECUTE
  603. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(effective_destination_number=109560)
  604. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [effective_destination_number]=[109560]
  605. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(bridge_pre_execute_bleg_app=sched_hangup)
  606. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [bridge_pre_execute_bleg_app]=[sched_hangup]
  607. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  608. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  609. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(callstart=2022-02-08 11:01:32)
  610. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [callstart]=[2022-02-08 11:01:32]
  611. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(hangup_after_bridge=true)
  612. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [hangup_after_bridge]=[true]
  613. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(continue_on_fail=TRUE)
  614. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [continue_on_fail]=[TRUE]
  615. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(account_id=3)
  616. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [account_id]=[3]
  617. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(parent_id=0)
  618. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [parent_id]=[0]
  619. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(entity_id=3)
  620. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [entity_id]=[3]
  621. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(call_processed=internal)
  622. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [call_processed]=[internal]
  623. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(call_direction=inbound)
  624. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [call_direction]=[inbound]
  625. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(accountname=EntDemo)
  626. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [accountname]=[EntDemo]
  627. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(origination_rates_did=ID:1|CODE:^109560.*|DESTINATION:109560|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:4)
  628. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [origination_rates_did]=[ID:1|CODE:^109560.*|DESTINATION:109560|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:4]
  629. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(origination_rates=0)
  630. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [origination_rates]=[0]
  631. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(original_caller_id_name=1604785422)
  632. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [original_caller_id_name]=[1604785422]
  633. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(original_caller_id_number=+1604785422)
  634. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [original_caller_id_number]=[+1604785422]
  635. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(is_recording=1)
  636. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [is_recording]=[1]
  637. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(media_bug_answer_req=true)
  638. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [media_bug_answer_req]=[true]
  639. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(record_sample_rate=8000)
  640. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [record_sample_rate]=[8000]
  641. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(execute_on_answer=record_session /var/lib/freeswitch/recordings/b4bb4fe3-84c5-499b-a511-1f4b04908127.wav)
  642. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [execute_on_answer]=[record_session /var/lib/freeswitch/recordings/b4bb4fe3-84c5-499b-a511-1f4b04908127.wav]
  643. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(effective_caller_id_name=1604785422)
  644. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [effective_caller_id_name]=[1604785422]
  645. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(effective_caller_id_number=+1604785422)
  646. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [effective_caller_id_number]=[+1604785422]
  647. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(receiver_accid=4)
  648. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [receiver_accid]=[4]
  649. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(did_id=1)
  650. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [did_id]=[1]
  651. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(transfer_call_type=4)
  652. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [transfer_call_type]=[4]
  653. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(transfer_extensions=7701150005)
  654. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [transfer_extensions]=[7701150005]
  655. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(busy_status=1)
  656. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [busy_status]=[1]
  657. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(no_answer_status=1)
  658. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [no_answer_status]=[1]
  659. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(always_status=0)
  660. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [always_status]=[0]
  661. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(transfer_status=0)
  662. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [transfer_status]=[0]
  663. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(variable_sip_to_host=172.31.15.133)
  664. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [variable_sip_to_host]=[172.31.15.133]
  665. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(domain_name=)
  666. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[UNDEF]
  667. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(sip_to_host=)
  668. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[UNDEF]
  669. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(presence_data=x|||admin's(5365342801)|||||||||DID|||46.101.114.158)
  670. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||admin's(5365342801)|||||||||DID|||46.101.114.158]
  671. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 export(call_type=4)
  672. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[4]
  673. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(calltype=STANDARD)
  674. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [calltype]=[STANDARD]
  675. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(accountcode=5365342801)
  676. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [accountcode]=[5365342801]
  677. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(caller_did_account_id=3)
  678. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [caller_did_account_id]=[3]
  679. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(did_number=109560)
  680. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [did_number]=[109560]
  681. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(did_init_inc=0)
  682. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [did_init_inc]=[0]
  683. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(did_inc=0)
  684. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [did_inc]=[0]
  685. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(did_cost=0.00000)
  686. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [did_cost]=[0.00000]
  687. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(did_connectcost=0.00000)
  688. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [did_connectcost]=[0.00000]
  689. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 set(origination_rates_did=0)
  690. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_dptools.c:1685 SET sofia/default/+1604785422@46.101.114.158 [origination_rates_did]=[0]
  691. EXECUTE [depth=0] sofia/default/+1604785422@46.101.114.158 transfer(7701150005 XML default)
  692. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_ivr.c:2289 (sofia/default/+1604785422@46.101.114.158) State Change CS_EXECUTE -> CS_ROUTING
  693. 2022-02-08 11:01:32.628008 97.07% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/+1604785422@46.101.114.158 to XML[7701150005@default]
  694. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_core_state_machine.c:647 (sofia/default/+1604785422@46.101.114.158) State EXECUTE going to sleep
  695. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_ROUTING (Cur 1 Tot 15)
  696. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_core_state_machine.c:640 (sofia/default/+1604785422@46.101.114.158) State ROUTING
  697. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
  698. 2022-02-08 11:01:32.628008 97.07% [DEBUG] mod_sofia.c:158 sofia/default/+1604785422@46.101.114.158 SOFIA ROUTING
  699. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_core_state_machine.c:230 sofia/default/+1604785422@46.101.114.158 Standard ROUTING
  700. 2022-02-08 11:01:32.628008 97.07% [INFO] mod_dialplan_xml.c:639 Processing 1604785422 <+1604785422>->7701150005 in context default
  701. 2022-02-08 11:01:32.628008 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes')
  702. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  703. 2022-02-08 11:01:32.647999 97.07% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [xml_handler] Params:
  704. Event-Name: REQUEST_PARAMS
  705. Core-UUID: dae52d9c-ce8e-4d58-8937-6f103a597dbe
  706. FreeSWITCH-Hostname: ip-172-31-15-133
  707. FreeSWITCH-Switchname: ip-172-31-15-133
  708. FreeSWITCH-IPv4: 172.31.15.133
  709. FreeSWITCH-IPv6: %3A%3A1
  710. Event-Date-Local: 2022-02-08%2011%3A01%3A32
  711. Event-Date-GMT: Tue,%2008%20Feb%202022%2011%3A01%3A32%20GMT
  712. Event-Date-Timestamp: 1644318092628008
  713. Event-Calling-File: mod_dialplan_xml.c
  714. Event-Calling-Function: dialplan_xml_locate
  715. Event-Calling-Line-Number: 610
  716. Event-Sequence: 2146
  717. Channel-State: CS_ROUTING
  718. Channel-Call-State: RINGING
  719. Channel-State-Number: 2
  720. Channel-Name: sofia/default/%2B1604785422%4046.101.114.158
  721. Unique-ID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  722. Call-Direction: inbound
  723. Presence-Call-Direction: inbound
  724. Channel-HIT-Dialplan: true
  725. Channel-Presence-ID: %2B1604785422%4046.101.114.158
  726. Channel-Presence-Data: x%7C%7C%7Cadmin's(5365342801)%7C%7C%7C%7C%7C%7C%7C%7C%7CDID%7C%7C%7C46.101.114.158
  727. Channel-Call-UUID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  728. Answer-State: ringing
  729. Channel-Read-Codec-Name: PCMU
  730. Channel-Read-Codec-Rate: 8000
  731. Channel-Read-Codec-Bit-Rate: 64000
  732. Channel-Write-Codec-Name: PCMU
  733. Channel-Write-Codec-Rate: 8000
  734. Channel-Write-Codec-Bit-Rate: 64000
  735. Caller-Direction: inbound
  736. Caller-Logical-Direction: inbound
  737. Caller-Username: %2B1604785422
  738. Caller-Dialplan: XML
  739. Caller-Caller-ID-Name: 1604785422
  740. Caller-Caller-ID-Number: %2B1604785422
  741. Caller-Orig-Caller-ID-Name: 1604785422
  742. Caller-Orig-Caller-ID-Number: %2B1604785422
  743. Caller-Network-Addr: 46.101.114.158
  744. Caller-ANI: %2B1604785422
  745. Caller-Destination-Number: 7701150005
  746. Caller-Unique-ID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  747. Caller-Source: mod_sofia
  748. Caller-Transfer-Source: 1644318092%3A10249d53-4f3f-4106-8e62-2a17e511974c%3Abl_xfer%3A7701150005/default/XML
  749. Caller-Context: default
  750. Caller-RDNIS: 109560
  751. Caller-Channel-Name: sofia/default/%2B1604785422%4046.101.114.158
  752. Caller-Profile-Index: 2
  753. Caller-Profile-Created-Time: 1644318092628008
  754. Caller-Channel-Created-Time: 1644318092548054
  755. Caller-Channel-Answered-Time: 0
  756. Caller-Channel-Progress-Time: 0
  757. Caller-Channel-Progress-Media-Time: 0
  758. Caller-Channel-Hangup-Time: 0
  759. Caller-Channel-Transfer-Time: 0
  760. Caller-Channel-Resurrect-Time: 0
  761. Caller-Channel-Bridged-Time: 0
  762. Caller-Channel-Last-Hold: 0
  763. Caller-Channel-Hold-Accum: 0
  764. Caller-Screen-Bit: true
  765. Caller-Privacy-Hide-Name: false
  766. Caller-Privacy-Hide-Number: false
  767. variable_direction: inbound
  768. variable_uuid: b4bb4fe3-84c5-499b-a511-1f4b04908127
  769. variable_session_id: 15
  770. variable_sip_from_user: %2B1604785422
  771. variable_sip_from_uri: %2B1604785422%4046.101.114.158
  772. variable_sip_from_host: 46.101.114.158
  773. variable_video_media_flow: disabled
  774. variable_text_media_flow: disabled
  775. variable_channel_name: sofia/default/%2B1604785422%4046.101.114.158
  776. variable_sip_call_id: 50d9700b-0371-123b-d299-ba05d31eb9f9
  777. variable_sip_local_network_addr: 13.233.144.222
  778. variable_sip_network_ip: 46.101.114.158
  779. variable_sip_network_port: 5077
  780. variable_sip_invite_stamp: 1644318092548054
  781. variable_sip_received_ip: 46.101.114.158
  782. variable_sip_received_port: 5077
  783. variable_sip_via_protocol: udp
  784. variable_sip_authorized: true
  785. variable_sip_acl_authed_by: default
  786. variable_sip_from_user_stripped: 1604785422
  787. variable_sip_from_tag: v0DSSvja86jKr
  788. variable_sofia_profile_name: default
  789. variable_sofia_profile_url: sip%3Amod_sofia%4013.233.144.222%3A5074
  790. variable_recovery_profile_name: default
  791. variable_sip_Remote-Party-ID: %221604785422%22%20%3Csip%3A%2B1604785422%4046.101.114.158%3E%3Bparty%3Dcalling%3Bscreen%3Dyes%3Bprivacy%3Doff
  792. variable_sip_cid_type: rpid
  793. variable_sip_full_via: SIP/2.0/UDP%2046.101.114.158%3A5077%3Brport%3D5077%3Bbranch%3Dz9hG4bKQ9yF4ap3D8e3F
  794. variable_sip_from_display: 1604785422
  795. variable_sip_full_from: %221604785422%22%20%3Csip%3A%2B1604785422%4046.101.114.158%3E%3Btag%3Dv0DSSvja86jKr
  796. variable_sip_full_to: %3Csip%3A109560%4013.233.144.222%3A5074%3E
  797. variable_sip_allow: INVITE,%20ACK,%20BYE,%20CANCEL,%20OPTIONS,%20MESSAGE,%20INFO,%20UPDATE,%20REGISTER,%20REFER,%20NOTIFY,%20PUBLISH,%20SUBSCRIBE
  798. variable_sip_req_user: 109560
  799. variable_sip_req_port: 5074
  800. variable_sip_req_uri: 109560%4013.233.144.222%3A5074
  801. variable_sip_req_host: 13.233.144.222
  802. variable_sip_to_user: 109560
  803. variable_sip_to_port: 5074
  804. variable_sip_to_uri: 109560%4013.233.144.222%3A5074
  805. variable_sip_contact_params: transport%3Dudp%3Bgw%3DPK-Default-Gateway
  806. variable_sip_contact_user: gw%2BPK-Default-Gateway
  807. variable_sip_contact_port: 5077
  808. variable_sip_contact_uri: gw%2BPK-Default-Gateway%4046.101.114.158%3A5077
  809. variable_sip_contact_host: 46.101.114.158
  810. variable_sip_user_agent: ASTPP
  811. variable_sip_via_host: 46.101.114.158
  812. variable_sip_via_port: 5077
  813. variable_sip_via_rport: 5077
  814. variable_presence_id: %2B1604785422%4046.101.114.158
  815. variable_switch_r_sdp: v%3D0%0D%0Ao%3DFreeSWITCH%201644284828%201644284829%20IN%20IP4%2046.101.114.158%0D%0As%3DFreeSWITCH%0D%0Ac%3DIN%20IP4%2046.101.114.158%0D%0At%3D0%200%0D%0Am%3Daudio%2033264%20RTP/AVP%200%20101%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0A
  816. variable_ep_codec_string: CORE_PCM_MODULE.PCMU%408000h%4020i%4064000b
  817. variable_rtp_use_codec_string: PCMU,PCMA
  818. variable_remote_video_media_flow: inactive
  819. variable_remote_text_media_flow: inactive
  820. variable_remote_audio_media_flow: sendrecv
  821. variable_audio_media_flow: sendrecv
  822. variable_remote_media_ip: 46.101.114.158
  823. variable_remote_media_port: 33264
  824. variable_rtp_audio_recv_pt: 0
  825. variable_rtp_use_codec_name: PCMU
  826. variable_rtp_use_codec_rate: 8000
  827. variable_rtp_use_codec_ptime: 20
  828. variable_rtp_use_codec_channels: 1
  829. variable_rtp_last_audio_codec_string: PCMU%408000h%4020i%401c
  830. variable_read_codec: PCMU
  831. variable_original_read_codec: PCMU
  832. variable_read_rate: 8000
  833. variable_original_read_rate: 8000
  834. variable_write_codec: PCMU
  835. variable_write_rate: 8000
  836. variable_dtmf_type: rfc2833
  837. variable_endpoint_disposition: RECEIVED
  838. variable_effective_destination_number: 109560
  839. variable_bridge_pre_execute_bleg_app: sched_hangup
  840. variable_bridge_pre_execute_bleg_data: %2B6000%20normal_clearing
  841. variable_callstart: 2022-02-08%2011%3A01%3A32
  842. variable_hangup_after_bridge: true
  843. variable_continue_on_fail: TRUE
  844. variable_account_id: 3
  845. variable_parent_id: 0
  846. variable_entity_id: 3
  847. variable_call_processed: internal
  848. variable_call_direction: inbound
  849. variable_accountname: EntDemo
  850. variable_origination_rates: 0
  851. variable_original_caller_id_name: 1604785422
  852. variable_original_caller_id_number: %2B1604785422
  853. variable_is_recording: 1
  854. variable_media_bug_answer_req: true
  855. variable_record_sample_rate: 8000
  856. variable_execute_on_answer: record_session%20/var/lib/freeswitch/recordings/b4bb4fe3-84c5-499b-a511-1f4b04908127.wav
  857. variable_effective_caller_id_name: 1604785422
  858. variable_effective_caller_id_number: %2B1604785422
  859. variable_receiver_accid: 4
  860. variable_did_id: 1
  861. variable_transfer_call_type: 4
  862. variable_transfer_extensions: 7701150005
  863. variable_busy_status: 1
  864. variable_no_answer_status: 1
  865. variable_always_status: 0
  866. variable_transfer_status: 0
  867. variable_variable_sip_to_host: 172.31.15.133
  868. variable_presence_data: x%7C%7C%7Cadmin's(5365342801)%7C%7C%7C%7C%7C%7C%7C%7C%7CDID%7C%7C%7C46.101.114.158
  869. variable_call_type: 4
  870. variable_export_vars: is_recording,media_bug_answer_req,record_sample_rate,execute_on_answer,presence_data,call_type
  871. variable_calltype: STANDARD
  872. variable_accountcode: 5365342801
  873. variable_caller_did_account_id: 3
  874. variable_did_number: 109560
  875. variable_did_init_inc: 0
  876. variable_did_inc: 0
  877. variable_did_cost: 0.00000
  878. variable_did_connectcost: 0.00000
  879. variable_origination_rates_did: 0
  880. variable_current_application_data: 7701150005%20XML%20default
  881. variable_current_application: transfer
  882. variable_max_forwards: 68
  883. variable_transfer_history: 1644318092%3A10249d53-4f3f-4106-8e62-2a17e511974c%3Abl_xfer%3A7701150005/default/XML
  884. variable_transfer_source: 1644318092%3A10249d53-4f3f-4106-8e62-2a17e511974c%3Abl_xfer%3A7701150005/default/XML
  885. variable_call_uuid: b4bb4fe3-84c5-499b-a511-1f4b04908127
  886. Hunt-Direction: inbound
  887. Hunt-Logical-Direction: inbound
  888. Hunt-Username: %2B1604785422
  889. Hunt-Dialplan: XML
  890. Hunt-Caller-ID-Name: 1604785422
  891. Hunt-Caller-ID-Number: %2B1604785422
  892. Hunt-Orig-Caller-ID-Name: 1604785422
  893. Hunt-Orig-Caller-ID-Number: %2B1604785422
  894. Hunt-Network-Addr: 46.101.114.158
  895. Hunt-ANI: %2B1604785422
  896. Hunt-Destination-Number: 7701150005
  897. Hunt-Unique-ID: b4bb4fe3-84c5-499b-a511-1f4b04908127
  898. Hunt-Source: mod_sofia
  899. Hunt-Transfer-Source: 1644318092%3A10249d53-4f3f-4106-8e62-2a17e511974c%3Abl_xfer%3A7701150005/default/XML
  900. Hunt-Context: default
  901. Hunt-RDNIS: 109560
  902. Hunt-Channel-Name: sofia/default/%2B1604785422%4046.101.114.158
  903. Hunt-Profile-Index: 2
  904. Hunt-Profile-Created-Time: 1644318092628008
  905. Hunt-Channel-Created-Time: 1644318092548054
  906. Hunt-Channel-Answered-Time: 0
  907. Hunt-Channel-Progress-Time: 0
  908. Hunt-Channel-Progress-Media-Time: 0
  909. Hunt-Channel-Hangup-Time: 0
  910. Hunt-Channel-Transfer-Time: 0
  911. Hunt-Channel-Resurrect-Time: 0
  912. Hunt-Channel-Bridged-Time: 0
  913. Hunt-Channel-Last-Hold: 0
  914. Hunt-Channel-Hold-Accum: 0
  915. Hunt-Screen-Bit: true
  916. Hunt-Privacy-Hide-Name: false
  917. Hunt-Privacy-Hide-Number: false
  918.  
  919.  
  920. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_value:
  921. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] section: dialplan
  922. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] tag_name:
  923. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [xml_REQUEST] key_name:
  924. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 7701150005
  925. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '7701150005' AND status=0 limit 1
  926. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 1604785422 / +1604785422
  927. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [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, A.codec as did_codec FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701150005" LIMIT 1
  928. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701150005" LIMIT 1
  929. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  930. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="7701150005" limit 1
  931. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  932. 2022-02-08 11:01:32.647999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 5365342801]
  933. 2022-02-08 11:01:32.647999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "5365342801" AND deleted = 0 limit 1
  934. 2022-02-08 11:01:32.668011 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^7701150005.*' OR blocked_patterns = '^770115000.*' OR blocked_patterns = '^77011500.*' OR blocked_patterns = '^7701150.*' OR blocked_patterns = '^770115.*' OR blocked_patterns = '^77011.*' OR blocked_patterns = '^7701.*' OR blocked_patterns = '^770.*' OR blocked_patterns = '^77.*' OR blocked_patterns = '^7.*' OR blocked_patterns ='--') AND accountid = 4 limit 1
  935. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="7701150005" AND (accountid = 0 OR status = 1) LIMIT 1
  936. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [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 = '^7701150005.*' OR patterns = '^770115000.*' OR patterns = '^77011500.*' OR patterns = '^7701150.*' OR patterns = '^770115.*' OR patterns = '^77011.*' OR patterns = '^7701.*' OR patterns = '^770.*' OR patterns = '^77.*' OR patterns = '^7.*' OR patterns ='--') AND accountid = 4 ORDER BY LENGTH(PKGPTR.patterns) DESC
  937. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [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 ="7701150005" AND A.accountid = '4' limit 1
  938. 2022-02-08 11:01:32.687999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 7701150005
  939. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [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, A.codec as did_codec FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701150005" LIMIT 1
  940. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] 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,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="7701150005" LIMIT 1
  941. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  942. 2022-02-08 11:01:32.687999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="7701150005" limit 1
  943. 2022-02-08 11:01:32.687999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
  944. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '7701150005' OR number = '770115000' OR number = '77011500' OR number = '7701150' OR number = '770115' OR number = '77011' OR number = '7701' OR number = '770' OR number = '77' OR number = '7' OR number ='--') OR (number = '7701150005*' OR number = '770115000*' OR number = '77011500*' OR number = '7701150*' OR number = '770115*' OR number = '77011*' OR number = '7701*' OR number = '770*' OR number = '77*' OR number = '7*' OR number ='--') OR (number = '+1604785422' OR number = '+160478542' OR number = '+16047854' OR number = '+1604785' OR number = '+160478' OR number = '+16047' OR number = '+1604' OR number = '+160' OR number = '+16' OR number = '+1' OR number = '+' OR number ='--') OR (number = '+1604785422*' OR number = '+160478542*' OR number = '+16047854*' OR number = '+1604785*' OR number = '+160478*' OR number = '+16047*' OR number = '+1604*' OR number = '+160*' OR number = '+16*' OR number = '+1*' OR number = '+*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  945. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  946. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '7701150005' OR routing_prefix = '770115000' OR routing_prefix = '77011500' OR routing_prefix = '7701150' OR routing_prefix = '770115' OR routing_prefix = '77011' OR routing_prefix = '7701' OR routing_prefix = '770' OR routing_prefix = '77' OR routing_prefix = '7' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  947. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  948. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 4
  949. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 5365342801
  950. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3702.7789
  951. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  952. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 3
  953. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  954. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  955. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 3 AND status = 0
  956. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
  957. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 3 AND status = 0
  958. 2022-02-08 11:01:32.708001 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^7701150005.*' OR pattern = '^770115000.*' OR pattern = '^77011500.*' OR pattern = '^7701150.*' OR pattern = '^770115.*' OR pattern = '^77011.*' OR pattern = '^7701.*' OR pattern = '^770.*' OR pattern = '^77.*' OR pattern = '^7.*' OR pattern ='--') AND (caller_id_pattern = '^+1604785422.*' OR caller_id_pattern = '^+160478542.*' OR caller_id_pattern = '^+16047854.*' OR caller_id_pattern = '^+1604785.*' OR caller_id_pattern = '^+160478.*' OR caller_id_pattern = '^+16047.*' OR caller_id_pattern = '^+1604.*' OR caller_id_pattern = '^+160.*' OR caller_id_pattern = '^+16.*' OR caller_id_pattern = '^+1.*' OR caller_id_pattern = '^+.*' OR caller_id_pattern ='^.*') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 3 OR accountid=4)  ORDER BY accountid DESC,LENGTH(pattern),LENGTH(caller_id_pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  959. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : outbound
  960. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  961. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:3.00000
  962. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:3
  963. 2022-02-08 11:01:32.708001 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday from demand_based_routing where pricelist_id = '3' and status=0
  964. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] holiday_based_routing :
  965. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] today_date :8-2
  966. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] demand_based_condition :
  967. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] current_time :11.01
  968. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] current_wday :3
  969. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match for priority :5
  970. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:3.45
  971. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  972. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 3
  973. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  974. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  975. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 3.45
  976. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : UK-Entdemo
  977. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 89
  978. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 4
  979. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID:
  980. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type:
  981. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  982. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3702.7789 balance Accountid 4 !!!
  983. 2022-02-08 11:01:32.727999 97.07% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  984. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  985. 2022-02-08 11:01:32.727999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id :
  986. 2022-02-08 11:01:32.727999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=3 ORDER by id asc
  987. 2022-02-08 11:01:32.727999 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^7701150005.*' OR pattern = '^770115000.*' OR pattern = '^77011500.*' OR pattern = '^7701150.*' OR pattern = '^770115.*' OR pattern = '^77011.*' OR pattern = '^7701.*' OR pattern = '^770.*' OR pattern = '^77.*' OR pattern = '^7.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (4,6) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC
  988. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information ===================
  989. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 2
  990. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^77.*
  991. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination : UK-Entdemo
  992. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  993. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0
  994. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^77.*
  995. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip :
  996. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend :
  997. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 4
  998. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : Ent-Demo
  999. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable :
  1000. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway :
  1001. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 3
  1002. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0
  1003. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk Name : Ent-Demo
  1004. 2022-02-08 11:01:32.727999 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES=======================
  1005. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information ===================
  1006. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 12
  1007. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^77.*
  1008. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination : Continue_on_fail
  1009. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  1010. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0
  1011. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^77.*
  1012. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip :
  1013. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend :
  1014. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 6
  1015. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : Continue_to_fail_Gw
  1016. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable :
  1017. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway :
  1018. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 3
  1019. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0
  1020. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk Name : Continue_to_fail_Trunk
  1021. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES=======================
  1022. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 4 AND status=0 LIMIT 1
  1023. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  1024. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  1025. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  1026. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 3 AND status = 0
  1027. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from accounts where id = 3) AND status=0 limit 1
  1028. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from trunks where id = 4) AND status=0 limit 1
  1029. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec  FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="+1604785422" limit 1
  1030. 2022-02-08 11:01:32.747994 97.07% [ERR] mod_lua.cpp:202 /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:1498: attempt to index local 'sip_codec_for_outbound' (a nil value)
  1031. stack traceback:
  1032.         /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:1498: in function 'get_sip_codec'
  1033.         /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:322: in function 'freeswitch_xml_outbound'
  1034.         ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:911: in main chunk
  1035.         [C]: in function 'dofile'
  1036.         /usr/share/freeswitch/scripts/astpp/astpp.lua:95: in main chunk
  1037. 2022-02-08 11:01:32.747994 97.07% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  1038. 2022-02-08 11:01:32.747994 97.07% [WARNING] mod_dialplan_xml.c:669 Context default not found
  1039. 2022-02-08 11:01:32.747994 97.07% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  1040. 2022-02-08 11:01:32.747994 97.07% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/+1604785422@46.101.114.158 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  1041. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:640 (sofia/default/+1604785422@46.101.114.158) State ROUTING going to sleep
  1042. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_HANGUP (Cur 1 Tot 15)
  1043. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:844 (sofia/default/+1604785422@46.101.114.158) Callstate Change RINGING -> HANGUP
  1044. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:846 (sofia/default/+1604785422@46.101.114.158) State HANGUP
  1045. 2022-02-08 11:01:32.747994 97.07% [DEBUG] mod_sofia.c:468 Channel sofia/default/+1604785422@46.101.114.158 hanging up, cause: NO_ROUTE_DESTINATION
  1046. 2022-02-08 11:01:32.747994 97.07% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  1047. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:59 sofia/default/+1604785422@46.101.114.158 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  1048. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:846 (sofia/default/+1604785422@46.101.114.158) State HANGUP going to sleep
  1049. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:616 (sofia/default/+1604785422@46.101.114.158) State Change CS_HANGUP -> CS_REPORTING
  1050. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_REPORTING (Cur 1 Tot 15)
  1051. 2022-02-08 11:01:32.747994 97.07% [DEBUG] switch_core_state_machine.c:932 (sofia/default/+1604785422@46.101.114.158) State REPORTING
  1052. 2022-02-08 11:01:32.747994 97.07% [INFO] mod_json_cdr.c:271 Process [b4bb4fe3-84c5-499b-a511-1f4b04908127.cdr.json]
  1053. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:168 sofia/default/+1604785422@46.101.114.158 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  1054. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:932 (sofia/default/+1604785422@46.101.114.158) State REPORTING going to sleep
  1055. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:607 (sofia/default/+1604785422@46.101.114.158) State Change CS_REPORTING -> CS_DESTROY
  1056. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_session.c:1753 Session 15 (sofia/default/+1604785422@46.101.114.158) Locked, Waiting on external entities
  1057. 2022-02-08 11:01:32.768085 97.07% [NOTICE] switch_core_session.c:1771 Session 15 (sofia/default/+1604785422@46.101.114.158) Ended
  1058. 2022-02-08 11:01:32.768085 97.07% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/+1604785422@46.101.114.158 [CS_DESTROY]
  1059. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:735 (sofia/default/+1604785422@46.101.114.158) Running State Change CS_DESTROY (Cur 0 Tot 15)
  1060. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:745 (sofia/default/+1604785422@46.101.114.158) State DESTROY
  1061. 2022-02-08 11:01:32.768085 97.07% [DEBUG] mod_sofia.c:379 sofia/default/+1604785422@46.101.114.158 SOFIA DESTROY
  1062. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:175 sofia/default/+1604785422@46.101.114.158 Standard DESTROY
  1063. 2022-02-08 11:01:32.768085 97.07% [DEBUG] switch_core_state_machine.c:745 (sofia/default/+1604785422@46.101.114.158) State DESTROY going to sleep
  1064. freeswitch@ip-172-31-15-133>
  1065.