FreeSWITCH Pastebin

after code update DID call transfer error getting

From Prashant Kumar, 1 Month ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/adac6bb5
Embed
Download Paste or View Raw
  1. +OK log level  [7]
  2. freeswitch@inextrix>
  3. freeswitch@inextrix>
  4. 2024-03-11 13:37:39.136481 97.30% [NOTICE] switch_channel.c:1142 New Channel sofia/default/5541843311@192.168.1.115 [1120e62e-2e23-415f-b25f-5cbf7dc7f7a6]
  5. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5541843311@192.168.1.115) Running State Change CS_NEW (Cur 1 Tot 2)
  6. 2024-03-11 13:37:39.136481 97.30% [INFO] sofia.c:10459 sofia/default/5541843311@192.168.1.115 receiving invite from 192.168.1.115:5060 version: 1.10.10-release  64bit call-id: 5e9cda78-5a4f-123d-83b0-000c2970c6f4
  7. 2024-03-11 13:37:39.136481 97.30% [DEBUG] sofia.c:10553 verifying acl "default" for ip/port 192.168.1.115:0.
  8. 2024-03-11 13:37:39.136481 97.30% [DEBUG] sofia.c:10582 IP 192.168.1.115 Approved by acl "default[]". Access Granted.
  9. 2024-03-11 13:37:39.136481 97.30% [DEBUG] sofia.c:7493 Channel sofia/default/5541843311@192.168.1.115 entering state [received][100]
  10. 2024-03-11 13:37:39.136481 97.30% [DEBUG] sofia.c:7503 Remote SDP:
  11. v=0
  12. o=FreeSWITCH 1710141497 1710141498 IN IP4 192.168.1.115
  13. s=FreeSWITCH
  14. c=IN IP4 192.168.1.115
  15. t=0 0
  16. m=audio 22762 RTP/AVP 8 18 101
  17. a=rtpmap:8 PCMA/8000
  18. a=rtpmap:18 G729/8000
  19. a=rtpmap:101 telephone-event/8000
  20. a=fmtp:101 0-15
  21. a=ptime:20
  22.  
  23. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  24. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  25. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  26. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1]
  27. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1]
  28. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5438 Set telephone-event payload to 101@8000
  29. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:3734 Set Codec sofia/default/5541843311@192.168.1.115 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  30. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_codec.c:111 sofia/default/5541843311@192.168.1.115 Original read codec set to PCMA:8
  31. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5798 Set telephone-event payload to 101@8000
  32. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_media.c:5856 sofia/default/5541843311@192.168.1.115 Set 2833 dtmf send payload to 101 recv payload to 101
  33. 2024-03-11 13:37:39.136481 97.30% [DEBUG] sofia.c:7927 (sofia/default/5541843311@192.168.1.115) State Change CS_NEW -> CS_INIT
  34. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:600 (sofia/default/5541843311@192.168.1.115) State NEW
  35. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5541843311@192.168.1.115) Running State Change CS_INIT (Cur 1 Tot 2)
  36. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:624 (sofia/default/5541843311@192.168.1.115) State INIT
  37. 2024-03-11 13:37:39.136481 97.30% [DEBUG] mod_sofia.c:97 sofia/default/5541843311@192.168.1.115 SOFIA INIT
  38. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:40 sofia/default/5541843311@192.168.1.115 Standard INIT
  39. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:48 (sofia/default/5541843311@192.168.1.115) State Change CS_INIT -> CS_ROUTING
  40. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:624 (sofia/default/5541843311@192.168.1.115) State INIT going to sleep
  41. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5541843311@192.168.1.115) Running State Change CS_ROUTING (Cur 1 Tot 2)
  42. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_channel.c:2399 (sofia/default/5541843311@192.168.1.115) Callstate Change DOWN -> RINGING
  43. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:640 (sofia/default/5541843311@192.168.1.115) State ROUTING
  44. 2024-03-11 13:37:39.136481 97.30% [DEBUG] mod_sofia.c:158 sofia/default/5541843311@192.168.1.115 SOFIA ROUTING
  45. 2024-03-11 13:37:39.136481 97.30% [DEBUG] switch_core_state_machine.c:230 sofia/default/5541843311@192.168.1.115 Standard ROUTING
  46. 2024-03-11 13:37:39.136481 97.30% [INFO] mod_dialplan_xml.c:639 Processing 5541843311 <5541843311>->100770 in context default
  47. 2024-03-11 13:37:39.156441 97.30% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  48. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  49. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
  50. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  51. 2024-03-11 13:37:39.156441 97.30% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 100770
  52. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '100770' AND status=0 limit 1
  53. 2024-03-11 13:37:39.156441 97.30% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERUSERNAME
  54. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  55. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '100770' limit 1
  56. 2024-03-11 13:37:39.156441 97.30% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 5541843311 / 5541843311
  57. 2024-03-11 13:37:39.156441 97.30% [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.use_did_as_cid_flag, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="100770" LIMIT 1
  58. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="100770" LIMIT 1
  59. 2024-03-11 13:37:39.156441 97.30% [ERR] switch_core_sqldb.c:1308 ERR: [SELECT A.id as id,A.provider_id as provider_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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="100770" LIMIT 1]
  60. [STATE: 42S22 CODE 1054 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.36]Unknown column 'A.transfer_status' in 'field list'
  61. ]
  62. 2024-03-11 13:37:39.156441 97.30% [ERR] mod_lua.cpp:202 ...tch/scripts/astpp/lib/addons/astpp.did.call.transfer.lua:20: assertion failed!
  63. stack traceback:
  64.         [C]: in function 'assert'
  65.         ...tch/scripts/astpp/lib/addons/astpp.did.call.transfer.lua:20: in function 'check_did_for_did_call_transfer'
  66.         ./astpp/lib/astpp.functions.lua:239: in function 'check_did'
  67.         ./astpp/lib/astpp.functions.lua:116: in function 'define_call_direction'
  68.         ./astpp/scripts/astpp.dialplan.lua:256: in main chunk
  69.         [C]: in function 'dofile'
  70.         ./astpp/astpp_deb9.lua:138: in main chunk
  71. 2024-03-11 13:37:39.156441 97.30% [ERR] mod_lua.cpp:269 LUA script parse/execute error!
  72. 2024-03-11 13:37:39.156441 97.30% [WARNING] mod_dialplan_xml.c:669 Context default not found
  73. 2024-03-11 13:37:39.156441 97.30% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  74. 2024-03-11 13:37:39.156441 97.30% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/5541843311@192.168.1.115 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  75. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:640 (sofia/default/5541843311@192.168.1.115) State ROUTING going to sleep
  76. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5541843311@192.168.1.115) Running State Change CS_HANGUP (Cur 1 Tot 2)
  77. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:844 (sofia/default/5541843311@192.168.1.115) Callstate Change RINGING -> HANGUP
  78. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:846 (sofia/default/5541843311@192.168.1.115) State HANGUP
  79. 2024-03-11 13:37:39.156441 97.30% [DEBUG] mod_sofia.c:469 Channel sofia/default/5541843311@192.168.1.115 hanging up, cause: NO_ROUTE_DESTINATION
  80. 2024-03-11 13:37:39.156441 97.30% [DEBUG] mod_sofia.c:614 Responding to INVITE with: 404
  81. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:59 sofia/default/5541843311@192.168.1.115 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  82. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:846 (sofia/default/5541843311@192.168.1.115) State HANGUP going to sleep
  83. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:616 (sofia/default/5541843311@192.168.1.115) State Change CS_HANGUP -> CS_REPORTING
  84. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5541843311@192.168.1.115) Running State Change CS_REPORTING (Cur 1 Tot 2)
  85. 2024-03-11 13:37:39.156441 97.30% [DEBUG] switch_core_state_machine.c:932 (sofia/default/5541843311@192.168.1.115) State REPORTING
  86. 2024-03-11 13:37:39.156441 97.30% [INFO] mod_json_cdr.c:272 Process [1120e62e-2e23-415f-b25f-5cbf7dc7f7a6.cdr.json]
  87. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:168 sofia/default/5541843311@192.168.1.115 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  88. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:932 (sofia/default/5541843311@192.168.1.115) State REPORTING going to sleep
  89. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:607 (sofia/default/5541843311@192.168.1.115) State Change CS_REPORTING -> CS_DESTROY
  90. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_session.c:1744 Session 2 (sofia/default/5541843311@192.168.1.115) Locked, Waiting on external entities
  91. 2024-03-11 13:37:39.176419 97.30% [NOTICE] switch_core_session.c:1762 Session 2 (sofia/default/5541843311@192.168.1.115) Ended
  92. 2024-03-11 13:37:39.176419 97.30% [NOTICE] switch_core_session.c:1766 Close Channel sofia/default/5541843311@192.168.1.115 [CS_DESTROY]
  93. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:735 (sofia/default/5541843311@192.168.1.115) Running State Change CS_DESTROY (Cur 0 Tot 2)
  94. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:745 (sofia/default/5541843311@192.168.1.115) State DESTROY
  95. 2024-03-11 13:37:39.176419 97.30% [DEBUG] mod_sofia.c:380 sofia/default/5541843311@192.168.1.115 SOFIA DESTROY
  96. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:175 sofia/default/5541843311@192.168.1.115 Standard DESTROY
  97. 2024-03-11 13:37:39.176419 97.30% [DEBUG] switch_core_state_machine.c:745 (sofia/default/5541843311@192.168.1.115) State DESTROY going to sleep
  98. freeswitch@inextrix>
  99. freeswitch@inextrix>
  100. 2024-03-11 13:39:24.956411 97.90% [WARNING] sofia_reg.c:1842 SIP auth challenge (INVITE) on sofia profile 'default' for [1873269483@pkvm7.astppbilling.org] from ip 192.168.1.1
  101. 2024-03-11 13:39:25.156434 97.90% [WARNING] sofia_reg.c:1842 SIP auth challenge (INVITE) on sofia profile 'default' for [4727985745@pkvm7.astppbilling.org] from ip 192.168.1.1
  102. 2024-03-11 13:39:25.336492 97.90% [CONSOLE] mod_voicemail.c:4068 Event Thread Started
  103. freeswitch@inextrix>

Reply to "after code update DID call transfer error getting"