From Prashant Kumar, 1 Year ago, written in FreeSWITCH.
- view diff
Embed
  1. 2022-12-06 12:07:51.186191 92.40% [ERR] sofia_reg.c:2677 813646 Failed Registration with status Service Unavailable [503]. failure #130
  2. 2022-12-06 12:07:52.186181 92.50% [WARNING] sofia_reg.c:516 813646 Failed Registration [503], setting retry to 30 seconds.
  3. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
  4. 2022-12-06 12:08:06.346166 90.80% [NOTICE] switch_channel.c:1123 New Channel sofia/default/990010@astppqa601.astppbilling.org:5076 [7bd8d17a-0e2a-4669-90a6-234cd2842d3c]
  5. 2022-12-06 12:08:06.346166 90.80% [DEBUG] mod_sofia.c:5121 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_NEW -> CS_INIT
  6. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_INIT (Cur 1 Tot 107)
  7. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT
  8. 2022-12-06 12:08:06.346166 90.80% [DEBUG] mod_sofia.c:97 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA INIT
  9. 2022-12-06 12:08:06.346166 90.80% [INFO] sofia_glue.c:1651 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite call-id: (null)
  10. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia_glue.c:1654 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite version: 1.10.7 -release 64bit
  11. Local SDP:
  12. v=0
  13. o=FreeSWITCH 1670298466 1670298467 IN IP4 142.132.184.134
  14. s=FreeSWITCH
  15. c=IN IP4 142.132.184.134
  16. t=0 0
  17. m=audio 30020 RTP/AVP 8 0 101
  18. a=rtpmap:8 PCMA/8000
  19. a=rtpmap:0 PCMU/8000
  20. a=rtpmap:101 telephone-event/8000
  21. a=fmtp:101 0-15
  22. a=ptime:20
  23. a=sendrecv
  24.  
  25. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:40 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard INIT
  26. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:48 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING
  27. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT going to sleep
  28. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 107)
  29. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING
  30. 2022-12-06 12:08:06.346166 90.80% [DEBUG] mod_sofia.c:158 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA ROUTING
  31. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_ivr_originate.c:67 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  32. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING going to sleep
  33. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_CONSUME_MEDIA (Cur 1 Tot 107)
  34. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [calling][0]
  35. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA
  36. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA going to sleep
  37. 2022-12-06 12:08:06.346166 90.80% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1515121325@142.132.184.134 [6df21960-68b8-497f-a313-c865353eeeeb]
  38. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@142.132.184.134) Running State Change CS_NEW (Cur 2 Tot 108)
  39. 2022-12-06 12:08:06.346166 90.80% [INFO] sofia.c:10462 sofia/default/1515121325@142.132.184.134 receiving invite from 142.132.184.134:5076 version: 1.10.7 -release 64bit call-id: 7bbe7d3d-f001-123b-c298-9600013c8d14
  40. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 142.132.184.134:0.
  41. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia.c:10585 IP 142.132.184.134 Approved by acl "default[]". Access Granted.
  42. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/1515121325@142.132.184.134 entering state [received][100]
  43. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia.c:7509 Remote SDP:
  44. v=0
  45. o=FreeSWITCH 1670298466 1670298467 IN IP4 142.132.184.134
  46. s=FreeSWITCH
  47. c=IN IP4 142.132.184.134
  48. t=0 0
  49. m=audio 30020 RTP/AVP 8 0 101
  50. a=rtpmap:8 PCMA/8000
  51. a=rtpmap:0 PCMU/8000
  52. a=rtpmap:101 telephone-event/8000
  53. a=fmtp:101 0-15
  54. a=ptime:20
  55.  
  56. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  57. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  58. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  59. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  60. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  61. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  62. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  63. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1515121325@142.132.184.134 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  64. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_codec.c:111 sofia/default/1515121325@142.132.184.134 Original read codec set to PCMA:8
  65. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  66. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_media.c:5973 sofia/default/1515121325@142.132.184.134 Set 2833 dtmf send payload to 101 recv payload to 101
  67. 2022-12-06 12:08:06.346166 90.80% [DEBUG] sofia.c:7933 (sofia/default/1515121325@142.132.184.134) State Change CS_NEW -> CS_INIT
  68. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1515121325@142.132.184.134) State NEW
  69. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@142.132.184.134) Running State Change CS_INIT (Cur 2 Tot 108)
  70. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1515121325@142.132.184.134) State INIT
  71. 2022-12-06 12:08:06.346166 90.80% [DEBUG] mod_sofia.c:97 sofia/default/1515121325@142.132.184.134 SOFIA INIT
  72. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:40 sofia/default/1515121325@142.132.184.134 Standard INIT
  73. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1515121325@142.132.184.134) State Change CS_INIT -> CS_ROUTING
  74. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1515121325@142.132.184.134) State INIT going to sleep
  75. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@142.132.184.134) Running State Change CS_ROUTING (Cur 2 Tot 108)
  76. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_channel.c:2380 (sofia/default/1515121325@142.132.184.134) Callstate Change DOWN -> RINGING
  77. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1515121325@142.132.184.134) State ROUTING
  78. 2022-12-06 12:08:06.346166 90.80% [DEBUG] mod_sofia.c:158 sofia/default/1515121325@142.132.184.134 SOFIA ROUTING
  79. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_core_state_machine.c:230 sofia/default/1515121325@142.132.184.134 Standard ROUTING
  80. 2022-12-06 12:08:06.346166 90.80% [INFO] mod_dialplan_xml.c:639 Processing 990010 <1515121325>->990010 in context default
  81. 2022-12-06 12:08:06.346166 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  82. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  83. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  84. 2022-12-06 12:08:06.346166 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  85. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Voice Broadcast Destination Number 1515121325
  86. 2022-12-06 12:08:06.366141 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  87. 2022-12-06 12:08:06.366141 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1515121325
  88. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1515121325' limit 1
  89. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  90. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1515121325' and status=0 LIMIT 1
  91. 2022-12-06 12:08:06.366141 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERmod_sofia
  92. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  93. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '1515121325' limit 1
  94. 2022-12-06 12:08:06.366141 90.80% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  95. 2022-12-06 12:08:06.366141 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 990010 / 1515121325
  96. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1325
  97. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 151512 AND status=0 limit 1
  98. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  99. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1515121325"  AND domains.domain="astppqa601.astppbilling.org" limit 1
  100. 2022-12-06 12:08:06.366141 90.80% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  101. 2022-12-06 12:08:06.366141 90.80% [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("142.132.184.134") 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 "1515121325"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  102. 2022-12-06 12:08:06.366141 90.80% [ERR] switch_core_sqldb.c:1310 ERR: [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("142.132.184.134") 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 "1515121325"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
  103. [STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
  104. ]
  105. 2022-12-06 12:08:06.366141 90.80% [ERR] mod_lua.cpp:202 /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: assertion failed!
  106. stack traceback:
  107.         [C]: in function 'assert'
  108.         /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: in function </usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:300>
  109.         (...tail calls...)
  110.         ./astpp/scripts/astpp.dialplan.lua:266: in main chunk
  111.         [C]: in function 'dofile'
  112.         ./astpp/astpp_deb9.lua:138: in main chunk
  113. 2022-12-06 12:08:06.366141 90.80% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  114. 2022-12-06 12:08:06.366141 90.80% [WARNING] mod_dialplan_xml.c:669 Context default not found
  115. 2022-12-06 12:08:06.366141 90.80% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  116. 2022-12-06 12:08:06.366141 90.80% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1515121325@142.132.184.134 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  117. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1515121325@142.132.184.134) State ROUTING going to sleep
  118. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@142.132.184.134) Running State Change CS_HANGUP (Cur 2 Tot 108)
  119. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1515121325@142.132.184.134) Callstate Change RINGING -> HANGUP
  120. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1515121325@142.132.184.134) State HANGUP
  121. 2022-12-06 12:08:06.366141 90.80% [DEBUG] mod_sofia.c:468 Channel sofia/default/1515121325@142.132.184.134 hanging up, cause: NO_ROUTE_DESTINATION
  122. 2022-12-06 12:08:06.366141 90.80% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  123. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:59 sofia/default/1515121325@142.132.184.134 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  124. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1515121325@142.132.184.134) State HANGUP going to sleep
  125. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1515121325@142.132.184.134) State Change CS_HANGUP -> CS_REPORTING
  126. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1515121325@142.132.184.134) Running State Change CS_REPORTING (Cur 2 Tot 108)
  127. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1515121325@142.132.184.134) State REPORTING
  128. 2022-12-06 12:08:06.366141 90.80% [DEBUG] sofia.c:6678 Remote Reason: 3
  129. 2022-12-06 12:08:06.366141 90.80% [INFO] mod_json_cdr.c:271 Process [6df21960-68b8-497f-a313-c865353eeeeb.cdr.json]
  130. 2022-12-06 12:08:06.366141 90.80% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [terminated][404]
  131. 2022-12-06 12:08:06.366141 90.80% [NOTICE] sofia.c:8738 Hangup sofia/default/990010@astppqa601.astppbilling.org:5076 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
  132. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 2 Tot 108)
  133. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:844 (sofia/default/990010@astppqa601.astppbilling.org:5076) Callstate Change DOWN -> HANGUP
  134. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990010@astppqa601.astppbilling.org:5076) State HANGUP
  135. 2022-12-06 12:08:06.366141 90.80% [DEBUG] mod_sofia.c:468 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 hanging up, cause: NO_ROUTE_DESTINATION
  136. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:59 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  137. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990010@astppqa601.astppbilling.org:5076) State HANGUP going to sleep
  138. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:616 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING
  139. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 2 Tot 108)
  140. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/990010@astppqa601.astppbilling.org:5076) State REPORTING
  141. 2022-12-06 12:08:06.366141 90.80% [INFO] mod_json_cdr.c:271 Process [7bd8d17a-0e2a-4669-90a6-234cd2842d3c.cdr.json]
  142. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:168 sofia/default/1515121325@142.132.184.134 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  143. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1515121325@142.132.184.134) State REPORTING going to sleep
  144. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1515121325@142.132.184.134) State Change CS_REPORTING -> CS_DESTROY
  145. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_session.c:1753 Session 108 (sofia/default/1515121325@142.132.184.134) Locked, Waiting on external entities
  146. 2022-12-06 12:08:06.366141 90.80% [NOTICE] switch_core_session.c:1771 Session 108 (sofia/default/1515121325@142.132.184.134) Ended
  147. 2022-12-06 12:08:06.366141 90.80% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1515121325@142.132.184.134 [CS_DESTROY]
  148. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1515121325@142.132.184.134) Running State Change CS_DESTROY (Cur 1 Tot 108)
  149. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1515121325@142.132.184.134) State DESTROY
  150. 2022-12-06 12:08:06.366141 90.80% [DEBUG] mod_sofia.c:379 sofia/default/1515121325@142.132.184.134 SOFIA DESTROY
  151. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:175 sofia/default/1515121325@142.132.184.134 Standard DESTROY
  152. 2022-12-06 12:08:06.366141 90.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1515121325@142.132.184.134) State DESTROY going to sleep
  153. 2022-12-06 12:08:06.386140 90.80% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
  154. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:168 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  155. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:932 (sofia/default/990010@astppqa601.astppbilling.org:5076) State REPORTING going to sleep
  156. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:607 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_REPORTING -> CS_DESTROY
  157. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_session.c:1753 Session 107 (sofia/default/990010@astppqa601.astppbilling.org:5076) Locked, Waiting on external entities
  158. 2022-12-06 12:08:06.646150 90.80% [NOTICE] switch_core_session.c:1771 Session 107 (sofia/default/990010@astppqa601.astppbilling.org:5076) Ended
  159. 2022-12-06 12:08:06.646150 90.80% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/990010@astppqa601.astppbilling.org:5076 [CS_DESTROY]
  160. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:735 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_DESTROY (Cur 0 Tot 108)
  161. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/990010@astppqa601.astppbilling.org:5076) State DESTROY
  162. 2022-12-06 12:08:06.646150 90.80% [DEBUG] mod_sofia.c:379 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA DESTROY
  163. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:175 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard DESTROY
  164. 2022-12-06 12:08:06.646150 90.80% [DEBUG] switch_core_state_machine.c:745 (sofia/default/990010@astppqa601.astppbilling.org:5076) State DESTROY going to sleep
  165. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
  166. 2022-12-06 12:08:11.386175 89.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/990010@astppqa601.astppbilling.org:5076 [933fe54f-8a32-48df-99cb-6415744b2d47]
  167. 2022-12-06 12:08:11.386175 89.67% [DEBUG] mod_sofia.c:5121 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_NEW -> CS_INIT
  168. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_INIT (Cur 1 Tot 109)
  169. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT
  170. 2022-12-06 12:08:11.386175 89.67% [DEBUG] mod_sofia.c:97 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA INIT
  171. 2022-12-06 12:08:11.386175 89.67% [INFO] sofia_glue.c:1651 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite call-id: (null)
  172. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia_glue.c:1654 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite version: 1.10.7 -release 64bit
  173. Local SDP:
  174. v=0
  175. o=FreeSWITCH 1670310823 1670310824 IN IP4 142.132.184.134
  176. s=FreeSWITCH
  177. c=IN IP4 142.132.184.134
  178. t=0 0
  179. m=audio 17668 RTP/AVP 8 0 101
  180. a=rtpmap:8 PCMA/8000
  181. a=rtpmap:0 PCMU/8000
  182. a=rtpmap:101 telephone-event/8000
  183. a=fmtp:101 0-15
  184. a=ptime:20
  185. a=sendrecv
  186.  
  187. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard INIT
  188. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING
  189. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT going to sleep
  190. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 109)
  191. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING
  192. 2022-12-06 12:08:11.386175 89.67% [DEBUG] mod_sofia.c:158 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA ROUTING
  193. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_ivr_originate.c:67 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  194. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING going to sleep
  195. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_CONSUME_MEDIA (Cur 1 Tot 109)
  196. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA
  197. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA going to sleep
  198. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [calling][0]
  199. 2022-12-06 12:08:11.386175 89.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/2536854752@142.132.184.134 [1bd93420-f977-4dae-b9c1-0474e287a6f8]
  200. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@142.132.184.134) Running State Change CS_NEW (Cur 2 Tot 110)
  201. 2022-12-06 12:08:11.386175 89.67% [INFO] sofia.c:10462 sofia/default/2536854752@142.132.184.134 receiving invite from 142.132.184.134:5076 version: 1.10.7 -release 64bit call-id: 7ec06274-f001-123b-c298-9600013c8d14
  202. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 142.132.184.134:0.
  203. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia.c:10585 IP 142.132.184.134 Approved by acl "default[]". Access Granted.
  204. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/2536854752@142.132.184.134 entering state [received][100]
  205. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia.c:7509 Remote SDP:
  206. v=0
  207. o=FreeSWITCH 1670310823 1670310824 IN IP4 142.132.184.134
  208. s=FreeSWITCH
  209. c=IN IP4 142.132.184.134
  210. t=0 0
  211. m=audio 17668 RTP/AVP 8 0 101
  212. a=rtpmap:8 PCMA/8000
  213. a=rtpmap:0 PCMU/8000
  214. a=rtpmap:101 telephone-event/8000
  215. a=fmtp:101 0-15
  216. a=ptime:20
  217.  
  218. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  219. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  220. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  221. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  222. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  223. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  224. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  225. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/2536854752@142.132.184.134 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  226. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_codec.c:111 sofia/default/2536854752@142.132.184.134 Original read codec set to PCMA:8
  227. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  228. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_media.c:5973 sofia/default/2536854752@142.132.184.134 Set 2833 dtmf send payload to 101 recv payload to 101
  229. 2022-12-06 12:08:11.386175 89.67% [DEBUG] sofia.c:7933 (sofia/default/2536854752@142.132.184.134) State Change CS_NEW -> CS_INIT
  230. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:600 (sofia/default/2536854752@142.132.184.134) State NEW
  231. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@142.132.184.134) Running State Change CS_INIT (Cur 2 Tot 110)
  232. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/2536854752@142.132.184.134) State INIT
  233. 2022-12-06 12:08:11.386175 89.67% [DEBUG] mod_sofia.c:97 sofia/default/2536854752@142.132.184.134 SOFIA INIT
  234. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/2536854752@142.132.184.134 Standard INIT
  235. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/2536854752@142.132.184.134) State Change CS_INIT -> CS_ROUTING
  236. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/2536854752@142.132.184.134) State INIT going to sleep
  237. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@142.132.184.134) Running State Change CS_ROUTING (Cur 2 Tot 110)
  238. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_channel.c:2380 (sofia/default/2536854752@142.132.184.134) Callstate Change DOWN -> RINGING
  239. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/2536854752@142.132.184.134) State ROUTING
  240. 2022-12-06 12:08:11.386175 89.67% [DEBUG] mod_sofia.c:158 sofia/default/2536854752@142.132.184.134 SOFIA ROUTING
  241. 2022-12-06 12:08:11.386175 89.67% [DEBUG] switch_core_state_machine.c:230 sofia/default/2536854752@142.132.184.134 Standard ROUTING
  242. 2022-12-06 12:08:11.386175 89.67% [INFO] mod_dialplan_xml.c:639 Processing 990010 <2536854752>->990010 in context default
  243. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  244. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  245. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  246. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  247. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Voice Broadcast Destination Number 2536854752
  248. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  249. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 2536854752
  250. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '2536854752' limit 1
  251. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  252. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '2536854752' and status=0 LIMIT 1
  253. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERmod_sofia
  254. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  255. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '2536854752' limit 1
  256. 2022-12-06 12:08:11.406144 89.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  257. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 990010 / 2536854752
  258. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 4752
  259. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 253685 AND status=0 limit 1
  260. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  261. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="2536854752"  AND domains.domain="astppqa601.astppbilling.org" limit 1
  262. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  263. 2022-12-06 12:08:11.406144 89.67% [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("142.132.184.134") 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 "2536854752"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  264. 2022-12-06 12:08:11.406144 89.67% [ERR] switch_core_sqldb.c:1310 ERR: [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("142.132.184.134") 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 "2536854752"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
  265. [STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
  266. ]
  267. 2022-12-06 12:08:11.406144 89.67% [ERR] mod_lua.cpp:202 /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: assertion failed!
  268. stack traceback:
  269.         [C]: in function 'assert'
  270.         /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: in function </usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:300>
  271.         (...tail calls...)
  272.         ./astpp/scripts/astpp.dialplan.lua:266: in main chunk
  273.         [C]: in function 'dofile'
  274.         ./astpp/astpp_deb9.lua:138: in main chunk
  275. 2022-12-06 12:08:11.406144 89.67% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  276. 2022-12-06 12:08:11.406144 89.67% [WARNING] mod_dialplan_xml.c:669 Context default not found
  277. 2022-12-06 12:08:11.406144 89.67% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  278. 2022-12-06 12:08:11.406144 89.67% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/2536854752@142.132.184.134 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  279. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/2536854752@142.132.184.134) State ROUTING going to sleep
  280. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@142.132.184.134) Running State Change CS_HANGUP (Cur 2 Tot 110)
  281. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:844 (sofia/default/2536854752@142.132.184.134) Callstate Change RINGING -> HANGUP
  282. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/2536854752@142.132.184.134) State HANGUP
  283. 2022-12-06 12:08:11.406144 89.67% [DEBUG] mod_sofia.c:468 Channel sofia/default/2536854752@142.132.184.134 hanging up, cause: NO_ROUTE_DESTINATION
  284. 2022-12-06 12:08:11.406144 89.67% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  285. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:59 sofia/default/2536854752@142.132.184.134 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  286. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/2536854752@142.132.184.134) State HANGUP going to sleep
  287. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:616 (sofia/default/2536854752@142.132.184.134) State Change CS_HANGUP -> CS_REPORTING
  288. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/2536854752@142.132.184.134) Running State Change CS_REPORTING (Cur 2 Tot 110)
  289. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/2536854752@142.132.184.134) State REPORTING
  290. 2022-12-06 12:08:11.406144 89.67% [INFO] mod_json_cdr.c:271 Process [1bd93420-f977-4dae-b9c1-0474e287a6f8.cdr.json]
  291. 2022-12-06 12:08:11.406144 89.67% [DEBUG] sofia.c:6678 Remote Reason: 3
  292. 2022-12-06 12:08:11.406144 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [terminated][404]
  293. 2022-12-06 12:08:11.406144 89.67% [NOTICE] sofia.c:8738 Hangup sofia/default/990010@astppqa601.astppbilling.org:5076 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
  294. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 2 Tot 110)
  295. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:844 (sofia/default/990010@astppqa601.astppbilling.org:5076) Callstate Change DOWN -> HANGUP
  296. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990010@astppqa601.astppbilling.org:5076) State HANGUP
  297. 2022-12-06 12:08:11.406144 89.67% [DEBUG] mod_sofia.c:468 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 hanging up, cause: NO_ROUTE_DESTINATION
  298. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:59 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  299. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990010@astppqa601.astppbilling.org:5076) State HANGUP going to sleep
  300. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:616 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING
  301. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 2 Tot 110)
  302. 2022-12-06 12:08:11.406144 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/990010@astppqa601.astppbilling.org:5076) State REPORTING
  303. 2022-12-06 12:08:11.406144 89.67% [INFO] mod_json_cdr.c:271 Process [933fe54f-8a32-48df-99cb-6415744b2d47.cdr.json]
  304. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:168 sofia/default/2536854752@142.132.184.134 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  305. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/2536854752@142.132.184.134) State REPORTING going to sleep
  306. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:607 (sofia/default/2536854752@142.132.184.134) State Change CS_REPORTING -> CS_DESTROY
  307. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_session.c:1753 Session 110 (sofia/default/2536854752@142.132.184.134) Locked, Waiting on external entities
  308. 2022-12-06 12:08:11.426133 89.67% [NOTICE] switch_core_session.c:1771 Session 110 (sofia/default/2536854752@142.132.184.134) Ended
  309. 2022-12-06 12:08:11.426133 89.67% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/2536854752@142.132.184.134 [CS_DESTROY]
  310. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:735 (sofia/default/2536854752@142.132.184.134) Running State Change CS_DESTROY (Cur 1 Tot 110)
  311. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:745 (sofia/default/2536854752@142.132.184.134) State DESTROY
  312. 2022-12-06 12:08:11.426133 89.67% [DEBUG] mod_sofia.c:379 sofia/default/2536854752@142.132.184.134 SOFIA DESTROY
  313. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:175 sofia/default/2536854752@142.132.184.134 Standard DESTROY
  314. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:745 (sofia/default/2536854752@142.132.184.134) State DESTROY going to sleep
  315. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
  316. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
  317. 2022-12-06 12:08:11.426133 89.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/990010@astppqa601.astppbilling.org:5076 [5a7d58bd-a27e-4eef-8b4f-89bed8eb76e9]
  318. 2022-12-06 12:08:11.426133 89.67% [DEBUG] mod_sofia.c:5121 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_NEW -> CS_INIT
  319. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_INIT (Cur 2 Tot 111)
  320. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT
  321. 2022-12-06 12:08:11.426133 89.67% [DEBUG] mod_sofia.c:97 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA INIT
  322. 2022-12-06 12:08:11.426133 89.67% [INFO] sofia_glue.c:1651 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite call-id: (null)
  323. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia_glue.c:1654 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite version: 1.10.7 -release 64bit
  324. Local SDP:
  325. v=0
  326. o=FreeSWITCH 1670302057 1670302058 IN IP4 142.132.184.134
  327. s=FreeSWITCH
  328. c=IN IP4 142.132.184.134
  329. t=0 0
  330. m=audio 26434 RTP/AVP 8 0 101
  331. a=rtpmap:8 PCMA/8000
  332. a=rtpmap:0 PCMU/8000
  333. a=rtpmap:101 telephone-event/8000
  334. a=fmtp:101 0-15
  335. a=ptime:20
  336. a=sendrecv
  337.  
  338. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard INIT
  339. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING
  340. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT going to sleep
  341. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 2 Tot 111)
  342. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING
  343. 2022-12-06 12:08:11.426133 89.67% [DEBUG] mod_sofia.c:158 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA ROUTING
  344. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_ivr_originate.c:67 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  345. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING going to sleep
  346. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 111)
  347. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA
  348. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA going to sleep
  349. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [calling][0]
  350. 2022-12-06 12:08:11.426133 89.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1554856322@142.132.184.134 [f0e85cfa-272e-4b2f-8810-fc44fd6ad88e]
  351. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@142.132.184.134) Running State Change CS_NEW (Cur 3 Tot 112)
  352. 2022-12-06 12:08:11.426133 89.67% [INFO] sofia.c:10462 sofia/default/1554856322@142.132.184.134 receiving invite from 142.132.184.134:5076 version: 1.10.7 -release 64bit call-id: 7ec6fb95-f001-123b-c298-9600013c8d14
  353. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 142.132.184.134:0.
  354. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia.c:10585 IP 142.132.184.134 Approved by acl "default[]". Access Granted.
  355. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/1554856322@142.132.184.134 entering state [received][100]
  356. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia.c:7509 Remote SDP:
  357. v=0
  358. o=FreeSWITCH 1670302057 1670302058 IN IP4 142.132.184.134
  359. s=FreeSWITCH
  360. c=IN IP4 142.132.184.134
  361. t=0 0
  362. m=audio 26434 RTP/AVP 8 0 101
  363. a=rtpmap:8 PCMA/8000
  364. a=rtpmap:0 PCMU/8000
  365. a=rtpmap:101 telephone-event/8000
  366. a=fmtp:101 0-15
  367. a=ptime:20
  368.  
  369. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  370. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  371. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  372. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  373. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  374. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  375. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  376. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1554856322@142.132.184.134 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  377. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_codec.c:111 sofia/default/1554856322@142.132.184.134 Original read codec set to PCMA:8
  378. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  379. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_media.c:5973 sofia/default/1554856322@142.132.184.134 Set 2833 dtmf send payload to 101 recv payload to 101
  380. 2022-12-06 12:08:11.426133 89.67% [DEBUG] sofia.c:7933 (sofia/default/1554856322@142.132.184.134) State Change CS_NEW -> CS_INIT
  381. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1554856322@142.132.184.134) State NEW
  382. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@142.132.184.134) Running State Change CS_INIT (Cur 3 Tot 112)
  383. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1554856322@142.132.184.134) State INIT
  384. 2022-12-06 12:08:11.426133 89.67% [DEBUG] mod_sofia.c:97 sofia/default/1554856322@142.132.184.134 SOFIA INIT
  385. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/1554856322@142.132.184.134 Standard INIT
  386. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1554856322@142.132.184.134) State Change CS_INIT -> CS_ROUTING
  387. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1554856322@142.132.184.134) State INIT going to sleep
  388. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@142.132.184.134) Running State Change CS_ROUTING (Cur 3 Tot 112)
  389. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_channel.c:2380 (sofia/default/1554856322@142.132.184.134) Callstate Change DOWN -> RINGING
  390. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1554856322@142.132.184.134) State ROUTING
  391. 2022-12-06 12:08:11.426133 89.67% [DEBUG] mod_sofia.c:158 sofia/default/1554856322@142.132.184.134 SOFIA ROUTING
  392. 2022-12-06 12:08:11.426133 89.67% [DEBUG] switch_core_state_machine.c:230 sofia/default/1554856322@142.132.184.134 Standard ROUTING
  393. 2022-12-06 12:08:11.426133 89.67% [INFO] mod_dialplan_xml.c:639 Processing 990010 <1554856322>->990010 in context default
  394. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  395. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  396. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  397. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  398. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Voice Broadcast Destination Number 1554856322
  399. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  400. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1554856322
  401. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1554856322' limit 1
  402. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  403. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1554856322' and status=0 LIMIT 1
  404. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERmod_sofia
  405. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  406. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '1554856322' limit 1
  407. 2022-12-06 12:08:11.446138 89.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  408. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 990010 / 1554856322
  409. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 6322
  410. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 155485 AND status=0 limit 1
  411. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  412. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1554856322"  AND domains.domain="astppqa601.astppbilling.org" limit 1
  413. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  414. 2022-12-06 12:08:11.446138 89.67% [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("142.132.184.134") 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 "1554856322"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  415. 2022-12-06 12:08:11.446138 89.67% [ERR] switch_core_sqldb.c:1310 ERR: [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("142.132.184.134") 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 "1554856322"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
  416. [STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
  417. ]
  418. 2022-12-06 12:08:11.446138 89.67% [ERR] mod_lua.cpp:202 /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: assertion failed!
  419. stack traceback:
  420.         [C]: in function 'assert'
  421.         /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: in function </usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:300>
  422.         (...tail calls...)
  423.         ./astpp/scripts/astpp.dialplan.lua:266: in main chunk
  424.         [C]: in function 'dofile'
  425.         ./astpp/astpp_deb9.lua:138: in main chunk
  426. 2022-12-06 12:08:11.446138 89.67% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  427. 2022-12-06 12:08:11.446138 89.67% [WARNING] mod_dialplan_xml.c:669 Context default not found
  428. 2022-12-06 12:08:11.446138 89.67% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  429. 2022-12-06 12:08:11.446138 89.67% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1554856322@142.132.184.134 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  430. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1554856322@142.132.184.134) State ROUTING going to sleep
  431. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@142.132.184.134) Running State Change CS_HANGUP (Cur 3 Tot 112)
  432. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1554856322@142.132.184.134) Callstate Change RINGING -> HANGUP
  433. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1554856322@142.132.184.134) State HANGUP
  434. 2022-12-06 12:08:11.446138 89.67% [DEBUG] mod_sofia.c:468 Channel sofia/default/1554856322@142.132.184.134 hanging up, cause: NO_ROUTE_DESTINATION
  435. 2022-12-06 12:08:11.446138 89.67% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  436. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:59 sofia/default/1554856322@142.132.184.134 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  437. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1554856322@142.132.184.134) State HANGUP going to sleep
  438. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1554856322@142.132.184.134) State Change CS_HANGUP -> CS_REPORTING
  439. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1554856322@142.132.184.134) Running State Change CS_REPORTING (Cur 3 Tot 112)
  440. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1554856322@142.132.184.134) State REPORTING
  441. 2022-12-06 12:08:11.446138 89.67% [INFO] mod_json_cdr.c:271 Process [f0e85cfa-272e-4b2f-8810-fc44fd6ad88e.cdr.json]
  442. 2022-12-06 12:08:11.446138 89.67% [DEBUG] sofia.c:6678 Remote Reason: 3
  443. 2022-12-06 12:08:11.446138 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [terminated][404]
  444. 2022-12-06 12:08:11.446138 89.67% [NOTICE] sofia.c:8738 Hangup sofia/default/990010@astppqa601.astppbilling.org:5076 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]
  445. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 3 Tot 112)
  446. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:844 (sofia/default/990010@astppqa601.astppbilling.org:5076) Callstate Change DOWN -> HANGUP
  447. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990010@astppqa601.astppbilling.org:5076) State HANGUP
  448. 2022-12-06 12:08:11.446138 89.67% [DEBUG] mod_sofia.c:468 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 hanging up, cause: NO_ROUTE_DESTINATION
  449. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:59 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  450. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/990010@astppqa601.astppbilling.org:5076) State HANGUP going to sleep
  451. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:616 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING
  452. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 3 Tot 112)
  453. 2022-12-06 12:08:11.446138 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/990010@astppqa601.astppbilling.org:5076) State REPORTING
  454. 2022-12-06 12:08:11.446138 89.67% [INFO] mod_json_cdr.c:271 Process [5a7d58bd-a27e-4eef-8b4f-89bed8eb76e9.cdr.json]
  455. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:168 sofia/default/1554856322@142.132.184.134 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  456. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1554856322@142.132.184.134) State REPORTING going to sleep
  457. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1554856322@142.132.184.134) State Change CS_REPORTING -> CS_DESTROY
  458. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_session.c:1753 Session 112 (sofia/default/1554856322@142.132.184.134) Locked, Waiting on external entities
  459. 2022-12-06 12:08:11.466135 89.67% [NOTICE] switch_core_session.c:1771 Session 112 (sofia/default/1554856322@142.132.184.134) Ended
  460. 2022-12-06 12:08:11.466135 89.67% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/1554856322@142.132.184.134 [CS_DESTROY]
  461. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1554856322@142.132.184.134) Running State Change CS_DESTROY (Cur 2 Tot 112)
  462. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1554856322@142.132.184.134) State DESTROY
  463. 2022-12-06 12:08:11.466135 89.67% [DEBUG] mod_sofia.c:379 sofia/default/1554856322@142.132.184.134 SOFIA DESTROY
  464. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:175 sofia/default/1554856322@142.132.184.134 Standard DESTROY
  465. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1554856322@142.132.184.134) State DESTROY going to sleep
  466. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 3 [NO_ROUTE_DESTINATION]
  467. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
  468. 2022-12-06 12:08:11.466135 89.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/990010@astppqa601.astppbilling.org:5076 [c9109721-fd10-4323-bfc6-54a214db3f1e]
  469. 2022-12-06 12:08:11.466135 89.67% [DEBUG] mod_sofia.c:5121 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_NEW -> CS_INIT
  470. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_INIT (Cur 3 Tot 113)
  471. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT
  472. 2022-12-06 12:08:11.466135 89.67% [DEBUG] mod_sofia.c:97 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA INIT
  473. 2022-12-06 12:08:11.466135 89.67% [INFO] sofia_glue.c:1651 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite call-id: (null)
  474. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia_glue.c:1654 sofia/default/990010@astppqa601.astppbilling.org:5076 sending invite version: 1.10.7 -release 64bit
  475. Local SDP:
  476. v=0
  477. o=FreeSWITCH 1670295751 1670295752 IN IP4 142.132.184.134
  478. s=FreeSWITCH
  479. c=IN IP4 142.132.184.134
  480. t=0 0
  481. m=audio 32740 RTP/AVP 8 0 101
  482. a=rtpmap:8 PCMA/8000
  483. a=rtpmap:0 PCMU/8000
  484. a=rtpmap:101 telephone-event/8000
  485. a=fmtp:101 0-15
  486. a=ptime:20
  487. a=sendrecv
  488.  
  489. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/990010@astppqa601.astppbilling.org:5076 Standard INIT
  490. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING
  491. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/990010@astppqa601.astppbilling.org:5076) State INIT going to sleep
  492. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 3 Tot 113)
  493. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING
  494. 2022-12-06 12:08:11.466135 89.67% [DEBUG] mod_sofia.c:158 sofia/default/990010@astppqa601.astppbilling.org:5076 SOFIA ROUTING
  495. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_ivr_originate.c:67 (sofia/default/990010@astppqa601.astppbilling.org:5076) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  496. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/990010@astppqa601.astppbilling.org:5076) State ROUTING going to sleep
  497. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/990010@astppqa601.astppbilling.org:5076) Running State Change CS_CONSUME_MEDIA (Cur 3 Tot 113)
  498. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA
  499. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:659 (sofia/default/990010@astppqa601.astppbilling.org:5076) State CONSUME_MEDIA going to sleep
  500. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [calling][0]
  501. 2022-12-06 12:08:11.466135 89.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/1547964325@142.132.184.134 [d3926677-3c16-486f-b11f-c6d247fcf7e8]
  502. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@142.132.184.134) Running State Change CS_NEW (Cur 4 Tot 114)
  503. 2022-12-06 12:08:11.466135 89.67% [INFO] sofia.c:10462 sofia/default/1547964325@142.132.184.134 receiving invite from 142.132.184.134:5076 version: 1.10.7 -release 64bit call-id: 7ecdba62-f001-123b-c298-9600013c8d14
  504. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 142.132.184.134:0.
  505. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia.c:10585 IP 142.132.184.134 Approved by acl "default[]". Access Granted.
  506. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/1547964325@142.132.184.134 entering state [received][100]
  507. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia.c:7509 Remote SDP:
  508. v=0
  509. o=FreeSWITCH 1670295751 1670295752 IN IP4 142.132.184.134
  510. s=FreeSWITCH
  511. c=IN IP4 142.132.184.134
  512. t=0 0
  513. m=audio 32740 RTP/AVP 8 0 101
  514. a=rtpmap:8 PCMA/8000
  515. a=rtpmap:0 PCMU/8000
  516. a=rtpmap:101 telephone-event/8000
  517. a=fmtp:101 0-15
  518. a=ptime:20
  519.  
  520. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  521. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  522. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  523. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  524. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  525. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  526. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  527. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/1547964325@142.132.184.134 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  528. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_codec.c:111 sofia/default/1547964325@142.132.184.134 Original read codec set to PCMA:8
  529. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  530. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_media.c:5973 sofia/default/1547964325@142.132.184.134 Set 2833 dtmf send payload to 101 recv payload to 101
  531. 2022-12-06 12:08:11.466135 89.67% [DEBUG] sofia.c:7933 (sofia/default/1547964325@142.132.184.134) State Change CS_NEW -> CS_INIT
  532. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1547964325@142.132.184.134) State NEW
  533. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@142.132.184.134) Running State Change CS_INIT (Cur 4 Tot 114)
  534. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1547964325@142.132.184.134) State INIT
  535. 2022-12-06 12:08:11.466135 89.67% [DEBUG] mod_sofia.c:97 sofia/default/1547964325@142.132.184.134 SOFIA INIT
  536. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/1547964325@142.132.184.134 Standard INIT
  537. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1547964325@142.132.184.134) State Change CS_INIT -> CS_ROUTING
  538. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1547964325@142.132.184.134) State INIT going to sleep
  539. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@142.132.184.134) Running State Change CS_ROUTING (Cur 4 Tot 114)
  540. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_channel.c:2380 (sofia/default/1547964325@142.132.184.134) Callstate Change DOWN -> RINGING
  541. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1547964325@142.132.184.134) State ROUTING
  542. 2022-12-06 12:08:11.466135 89.67% [DEBUG] mod_sofia.c:158 sofia/default/1547964325@142.132.184.134 SOFIA ROUTING
  543. 2022-12-06 12:08:11.466135 89.67% [DEBUG] switch_core_state_machine.c:230 sofia/default/1547964325@142.132.184.134 Standard ROUTING
  544. 2022-12-06 12:08:11.466135 89.67% [INFO] mod_dialplan_xml.c:639 Processing 990010 <1547964325>->990010 in context default
  545. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  546. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  547. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  548. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  549. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Voice Broadcast Destination Number 1547964325
  550. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  551. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1547964325
  552. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1547964325' limit 1
  553. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  554. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1547964325' and status=0 LIMIT 1
  555. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERmod_sofia
  556. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  557. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '1547964325' limit 1
  558. 2022-12-06 12:08:11.486147 89.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  559. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 990010 / 1547964325
  560. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 4325
  561. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 154796 AND status=0 limit 1
  562. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  563. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="1547964325"  AND domains.domain="astppqa601.astppbilling.org" limit 1
  564. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  565. 2022-12-06 12:08:11.486147 89.67% [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("142.132.184.134") 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 "1547964325"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  566. 2022-12-06 12:08:11.486147 89.67% [ERR] switch_core_sqldb.c:1310 ERR: [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("142.132.184.134") 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 "1547964325"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1]
  567. [STATE: HY000 CODE 1690 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.31]BIGINT UNSIGNED value is out of range in '((0x01 << (32 - substring_index(`astpp`.`ip_map`.`ip`,'/',<cache>(-(1))))) - 1)'
  568. ]
  569. 2022-12-06 12:08:11.486147 89.67% [ERR] mod_lua.cpp:202 /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: assertion failed!
  570. stack traceback:
  571.         [C]: in function 'assert'
  572.         /usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:307: in function </usr/local/freeswitch/scripts/astpp/lib/astpp.functions.lua:300>
  573.         (...tail calls...)
  574.         ./astpp/scripts/astpp.dialplan.lua:266: in main chunk
  575.         [C]: in function 'dofile'
  576.         ./astpp/astpp_deb9.lua:138: in main chunk
  577. 2022-12-06 12:08:11.486147 89.67% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  578. 2022-12-06 12:08:11.486147 89.67% [WARNING] mod_dialplan_xml.c:669 Context default not found
  579. 2022-12-06 12:08:11.486147 89.67% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  580. 2022-12-06 12:08:11.486147 89.67% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/1547964325@142.132.184.134 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  581. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1547964325@142.132.184.134) State ROUTING going to sleep
  582. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@142.132.184.134) Running State Change CS_HANGUP (Cur 4 Tot 114)
  583. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1547964325@142.132.184.134) Callstate Change RINGING -> HANGUP
  584. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1547964325@142.132.184.134) State HANGUP
  585. 2022-12-06 12:08:11.486147 89.67% [DEBUG] mod_sofia.c:468 Channel sofia/default/1547964325@142.132.184.134 hanging up, cause: NO_ROUTE_DESTINATION
  586. 2022-12-06 12:08:11.486147 89.67% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  587. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:59 sofia/default/1547964325@142.132.184.134 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  588. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1547964325@142.132.184.134) State HANGUP going to sleep
  589. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1547964325@142.132.184.134) State Change CS_HANGUP -> CS_REPORTING
  590. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1547964325@142.132.184.134) Running State Change CS_REPORTING (Cur 4 Tot 114)
  591. 2022-12-06 12:08:11.486147 89.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1547964325@142.132.184.134) State REPORTING
  592. 2022-12-06 12:08:11.486147 89.67% [DEBUG] sofia.c:6678 Remote Reason: 3
  593. 2022-12-06 12:08:11.486147 89.67% [INFO] mod_json_cdr.c:271 Process [d3926677-3c16-486f-b11f-c6d247fcf7e8.cdr.json]
  594. 2022-12-06 12:08:11.486147 89.67% [DEBUG] sofia.c:7499 Channel sofia/default/990010@astppqa601.astppbilling.org:5076 entering state [terminated][404]
  595. 2022-12-06 12:08:11.486147 89.67% [NOTICE] sofia.c:8738 Hangup sofia/default/990010@astppqa601.astppbilling.org:5076 [CS_CONSUME_MEDIA] [NO_ROUTE_DESTINATION]