FreeSWITCH Pastebin

sip routing addon installed during call error show

From Prashant Kumar, 2 Years ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/6a500826
Embed
Download Paste or View Raw
  1. freeswitch@gibfibre>
  2. 2022-09-28 03:53:54.435541 [NOTICE] switch_channel.c:1118 New Channel sofia/default/9656140894@46.101.114.158:5068 [2b6a1f55-2de1-4d45-a4ec-d2c847e7da01]
  3. 2022-09-28 03:53:54.435541 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9656140894@46.101.114.158:5068) Running State Change CS_NEW (Cur 1 Tot 2)
  4. 2022-09-28 03:53:54.435541 [DEBUG] sofia.c:10280 sofia/default/9656140894@46.101.114.158:5068 receiving invite from 103.240.35.46:36082 version: 1.10.5 -release-17-25569c1631 64bit
  5. 2022-09-28 03:53:54.435541 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 103.240.35.46:0.
  6. 2022-09-28 03:53:54.435541 [DEBUG] sofia.c:2434 detaching session 2b6a1f55-2de1-4d45-a4ec-d2c847e7da01
  7. 2022-09-28 03:53:54.435541 [WARNING] sofia_reg.c:1794 SIP auth challenge (INVITE) on sofia profile 'default' for [10303030@46.101.114.158] from ip 103.240.35.46
  8. 2022-09-28 03:53:54.435541 [DEBUG] switch_core_state_machine.c:604 (sofia/default/9656140894@46.101.114.158:5068) State NEW
  9. 2022-09-28 03:53:54.775540 [DEBUG] sofia.c:2544 Re-attaching to session 2b6a1f55-2de1-4d45-a4ec-d2c847e7da01
  10. 2022-09-28 03:53:54.775540 [DEBUG] sofia.c:10280 sofia/default/9656140894@46.101.114.158:5068 receiving invite from 103.240.35.46:36082 version: 1.10.5 -release-17-25569c1631 64bit
  11. 2022-09-28 03:53:54.775540 [DEBUG] sofia.c:10374 verifying acl "default" for ip/port 103.240.35.46:0.
  12. 2022-09-28 03:53:54.795539 [DEBUG] sofia.c:11477 Setting NAT mode based on via received
  13. 2022-09-28 03:53:54.795539 [DEBUG] sofia.c:7326 Channel sofia/default/9656140894@46.101.114.158:5068 entering state [received][100]
  14. 2022-09-28 03:53:54.795539 [DEBUG] sofia.c:7336 Remote SDP:
  15. v=0
  16. o=Z 0 0 IN IP4 103.240.35.46
  17. s=Z
  18. c=IN IP4 103.240.35.46
  19. t=0 0
  20. m=audio 8000 RTP/AVP 3 110 8 0 98 101
  21. a=rtpmap:110 speex/8000
  22. a=rtpmap:98 iLBC/8000
  23. a=fmtp:98 mode=20
  24. a=rtpmap:101 telephone-event/8000
  25. a=fmtp:101 0-15
  26.  
  27. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  28. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  29. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
  30. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
  31. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  32. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  33. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  34. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  35. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  36. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5649 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  37. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
  38. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5594 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
  39. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5510 Set telephone-event payload to 101@8000
  40. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:3839 Set Codec sofia/default/9656140894@46.101.114.158:5068 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  41. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_codec.c:111 sofia/default/9656140894@46.101.114.158:5068 Original read codec set to PCMA:8
  42. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5853 Set telephone-event payload to 101@8000
  43. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_media.c:5911 sofia/default/9656140894@46.101.114.158:5068 Set 2833 dtmf send payload to 101 recv payload to 101
  44. 2022-09-28 03:53:54.795539 [DEBUG] sofia.c:7760 (sofia/default/9656140894@46.101.114.158:5068) State Change CS_NEW -> CS_INIT
  45. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9656140894@46.101.114.158:5068) Running State Change CS_INIT (Cur 1 Tot 2)
  46. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9656140894@46.101.114.158:5068) State INIT
  47. 2022-09-28 03:53:54.795539 [DEBUG] mod_sofia.c:93 sofia/default/9656140894@46.101.114.158:5068 SOFIA INIT
  48. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:40 sofia/default/9656140894@46.101.114.158:5068 Standard INIT
  49. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:48 (sofia/default/9656140894@46.101.114.158:5068) State Change CS_INIT -> CS_ROUTING
  50. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:628 (sofia/default/9656140894@46.101.114.158:5068) State INIT going to sleep
  51. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9656140894@46.101.114.158:5068) Running State Change CS_ROUTING (Cur 1 Tot 2)
  52. 2022-09-28 03:53:54.795539 [DEBUG] switch_channel.c:2332 (sofia/default/9656140894@46.101.114.158:5068) Callstate Change DOWN -> RINGING
  53. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9656140894@46.101.114.158:5068) State ROUTING
  54. 2022-09-28 03:53:54.795539 [DEBUG] mod_sofia.c:154 sofia/default/9656140894@46.101.114.158:5068 SOFIA ROUTING
  55. 2022-09-28 03:53:54.795539 [DEBUG] switch_core_state_machine.c:236 sofia/default/9656140894@46.101.114.158:5068 Standard ROUTING
  56. 2022-09-28 03:53:54.795539 [INFO] mod_dialplan_xml.c:637 Processing 9656140894 <9656140894>->10303030 in context default
  57. 2022-09-28 03:53:54.815533 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  58. 2022-09-28 03:53:54.815533 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  59. 2022-09-28 03:53:54.835540 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 10303030
  60. 2022-09-28 03:53:54.835540 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '10303030' AND status=0 limit 1
  61. 2022-09-28 03:53:54.835540 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 9656140894 / 9656140894
  62. 2022-09-28 03:53:54.835540 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="10303030" LIMIT 1
  63. 2022-09-28 03:53:54.835540 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,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="10303030" limit 1
  64. 2022-09-28 03:53:54.835540 [ERR] switch_core_sqldb.c:1355 ERR: [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 WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="10303030" limit 1]
  65. [STATE: 42S22 CODE 1054 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.23]Unknown column 'sip_devices.codec' in 'field list'
  66. ]
  67. 2022-09-28 03:53:54.835540 [ERR] mod_lua.cpp:202 ...hare/freeswitch/scripts/astpp/lib/addons/sip_routing.lua:29: assertion failed!
  68. stack traceback:
  69.         [C]: in function 'assert'
  70.         ...hare/freeswitch/scripts/astpp/lib/addons/sip_routing.lua:29: in function 'check_local_call'
  71.         /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:63: in function 'define_call_direction'
  72.         ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:108: in main chunk
  73.         [C]: in function 'dofile'
  74.         /usr/share/freeswitch/scripts/astpp/astpp.lua:85: in main chunk
  75. 2022-09-28 03:53:54.835540 [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  76. 2022-09-28 03:53:54.835540 [WARNING] mod_dialplan_xml.c:667 Context default not found
  77. 2022-09-28 03:53:54.835540 [INFO] switch_core_state_machine.c:312 No Route, Aborting
  78. 2022-09-28 03:53:54.835540 [NOTICE] switch_core_state_machine.c:313 Hangup sofia/default/9656140894@46.101.114.158:5068 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  79. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:644 (sofia/default/9656140894@46.101.114.158:5068) State ROUTING going to sleep
  80. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9656140894@46.101.114.158:5068) Running State Change CS_HANGUP (Cur 1 Tot 2)
  81. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:848 (sofia/default/9656140894@46.101.114.158:5068) Callstate Change RINGING -> HANGUP
  82. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9656140894@46.101.114.158:5068) State HANGUP
  83. 2022-09-28 03:53:54.835540 [DEBUG] mod_sofia.c:453 Channel sofia/default/9656140894@46.101.114.158:5068 hanging up, cause: NO_ROUTE_DESTINATION
  84. 2022-09-28 03:53:54.835540 [DEBUG] mod_sofia.c:598 Responding to INVITE with: 404
  85. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:60 sofia/default/9656140894@46.101.114.158:5068 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  86. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:850 (sofia/default/9656140894@46.101.114.158:5068) State HANGUP going to sleep
  87. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:620 (sofia/default/9656140894@46.101.114.158:5068) State Change CS_HANGUP -> CS_REPORTING
  88. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:585 (sofia/default/9656140894@46.101.114.158:5068) Running State Change CS_REPORTING (Cur 1 Tot 2)
  89. 2022-09-28 03:53:54.835540 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9656140894@46.101.114.158:5068) State REPORTING
  90. 2022-09-28 03:53:54.835540 [INFO] mod_json_cdr.c:271 Process [2b6a1f55-2de1-4d45-a4ec-d2c847e7da01.cdr.json]
  91. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:174 sofia/default/9656140894@46.101.114.158:5068 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  92. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:936 (sofia/default/9656140894@46.101.114.158:5068) State REPORTING going to sleep
  93. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:611 (sofia/default/9656140894@46.101.114.158:5068) State Change CS_REPORTING -> CS_DESTROY
  94. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_session.c:1726 Session 2 (sofia/default/9656140894@46.101.114.158:5068) Locked, Waiting on external entities
  95. 2022-09-28 03:53:54.855552 [NOTICE] switch_core_session.c:1744 Session 2 (sofia/default/9656140894@46.101.114.158:5068) Ended
  96. 2022-09-28 03:53:54.855552 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/9656140894@46.101.114.158:5068 [CS_DESTROY]
  97. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:739 (sofia/default/9656140894@46.101.114.158:5068) Running State Change CS_DESTROY (Cur 0 Tot 2)
  98. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9656140894@46.101.114.158:5068) State DESTROY
  99. 2022-09-28 03:53:54.855552 [DEBUG] mod_sofia.c:364 sofia/default/9656140894@46.101.114.158:5068 SOFIA DESTROY
  100. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:181 sofia/default/9656140894@46.101.114.158:5068 Standard DESTROY
  101. 2022-09-28 03:53:54.855552 [DEBUG] switch_core_state_machine.c:749 (sofia/default/9656140894@46.101.114.158:5068) State DESTROY going to sleep
  102. freeswitch@gibfibre>

Reply to "sip routing addon installed during call error show"