FreeSWITCH Pastebin

DID cal transfer when addon not install pbx instal

From Prashant kumar, 1 Year ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/4eae4ad8
Embed
Download Paste or View Raw
  1. +OK log level  [7]
  2. freeswitch@ip-172-31-14-218>
  3. freeswitch@ip-172-31-14-218>
  4. freeswitch@ip-172-31-14-218>
  5. 2022-05-18 04:24:20.742248 94.57% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [1000@3.7.66.233] from ip 163.172.74.58
  6. 2022-05-18 04:24:20.862277 94.57% [WARNING] sofia_reg.c:3223 Can't find user [1000@3.7.66.233] from 163.172.74.58
  7. You must define a domain called '3.7.66.233' in your directory and add a user with the id="1000" attribute
  8. and you must configure your device to use the proper domain in its authentication credentials.
  9. 2022-05-18 04:24:20.862277 94.57% [WARNING] sofia_reg.c:1806 SIP auth failure (REGISTER) on sofia profile 'default' for [1000@3.7.66.233] from ip 163.172.74.58
  10. 2022-05-18 04:24:21.102254 94.57% [NOTICE] switch_channel.c:1123 New Channel sofia/default/9750900539@w07version60.astppbilling.org:5074 [ef5eeb3f-abc3-48ff-b304-45f32ee935bf]
  11. 2022-05-18 04:24:21.102254 94.57% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Running State Change CS_NEW (Cur 1 Tot 3)
  12. 2022-05-18 04:24:21.102254 94.57% [INFO] sofia.c:10462 sofia/default/9750900539@w07version60.astppbilling.org:5074 receiving invite from 117.247.91.162:54027 version: 1.10.7 -release-19-883d2cb662 64bit call-id: IEbb5I8ad-vIVjLLh_u9mQ..
  13. 2022-05-18 04:24:21.102254 94.57% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0.
  14. 2022-05-18 04:24:21.102254 94.57% [DEBUG] sofia.c:2419 detaching session ef5eeb3f-abc3-48ff-b304-45f32ee935bf
  15. 2022-05-18 04:24:21.102254 94.57% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [103003030@w07version60.astppbilling.org] from ip 117.247.91.162
  16. 2022-05-18 04:24:21.102254 94.57% [DEBUG] switch_core_state_machine.c:600 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State NEW
  17. 2022-05-18 04:24:21.222268 94.57% [DEBUG] sofia.c:2532 Re-attaching to session ef5eeb3f-abc3-48ff-b304-45f32ee935bf
  18. 2022-05-18 04:24:21.222268 94.57% [INFO] sofia.c:10462 sofia/default/9750900539@w07version60.astppbilling.org:5074 receiving invite from 117.247.91.162:54027 version: 1.10.7 -release-19-883d2cb662 64bit call-id: IEbb5I8ad-vIVjLLh_u9mQ..
  19. 2022-05-18 04:24:21.222268 94.57% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0.
  20. 2022-05-18 04:24:21.242250 94.57% [DEBUG] sofia.c:11672 Setting NAT mode based on via port
  21. 2022-05-18 04:24:21.242250 94.57% [DEBUG] sofia.c:7499 Channel sofia/default/9750900539@w07version60.astppbilling.org:5074 entering state [received][100]
  22. 2022-05-18 04:24:21.242250 94.57% [DEBUG] sofia.c:7509 Remote SDP:
  23. v=0
  24. o=Z 0 0 IN IP4 117.247.91.162
  25. s=Z
  26. c=IN IP4 117.247.91.162
  27. t=0 0
  28. m=audio 8000 RTP/AVP 3 110 8 0 97 101
  29. a=rtpmap:110 speex/8000
  30. a=rtpmap:97 iLBC/8000
  31. a=fmtp:97 mode=30
  32. a=rtpmap:101 telephone-event/8000
  33. a=fmtp:101 0-16
  34.  
  35. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  36. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  37. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
  38. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
  39. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  40. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  41. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  42. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  43. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  44. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  45. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
  46. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
  47. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  48. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/9750900539@w07version60.astppbilling.org:5074 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  49. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_codec.c:111 sofia/default/9750900539@w07version60.astppbilling.org:5074 Original read codec set to PCMA:8
  50. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  51. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_media.c:5973 sofia/default/9750900539@w07version60.astppbilling.org:5074 Set 2833 dtmf send payload to 101 recv payload to 101
  52. 2022-05-18 04:24:21.242250 94.57% [DEBUG] sofia.c:7933 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State Change CS_NEW -> CS_INIT
  53. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Running State Change CS_INIT (Cur 1 Tot 3)
  54. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State INIT
  55. 2022-05-18 04:24:21.242250 94.57% [DEBUG] mod_sofia.c:97 sofia/default/9750900539@w07version60.astppbilling.org:5074 SOFIA INIT
  56. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:40 sofia/default/9750900539@w07version60.astppbilling.org:5074 Standard INIT
  57. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:48 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State Change CS_INIT -> CS_ROUTING
  58. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State INIT going to sleep
  59. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Running State Change CS_ROUTING (Cur 1 Tot 3)
  60. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_channel.c:2380 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Callstate Change DOWN -> RINGING
  61. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State ROUTING
  62. 2022-05-18 04:24:21.242250 94.57% [DEBUG] mod_sofia.c:158 sofia/default/9750900539@w07version60.astppbilling.org:5074 SOFIA ROUTING
  63. 2022-05-18 04:24:21.242250 94.57% [DEBUG] switch_core_state_machine.c:230 sofia/default/9750900539@w07version60.astppbilling.org:5074 Standard ROUTING
  64. 2022-05-18 04:24:21.242250 94.57% [INFO] mod_dialplan_xml.c:639 Processing 9750900539 <9750900539>->103003030 in context default
  65. 2022-05-18 04:24:21.282249 94.57% [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')
  66. 2022-05-18 04:24:21.282249 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  67. 2022-05-18 04:24:21.322246 94.57% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  68. 2022-05-18 04:24:21.322246 94.57% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 103003030
  69. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '103003030' limit 1
  70. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '103003030' AND status=0 limit 1
  71. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '103003030' and status=0 LIMIT 1
  72. 2022-05-18 04:24:21.322246 94.57% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9750900539
  73. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  74. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'w07version60.astppbilling.org' limit 1
  75. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '22' and username = '103003030' limit 1
  76. 2022-05-18 04:24:21.322246 94.57% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 9750900539 / 9750900539
  77. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 030
  78. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 103003 AND status=0 limit 1
  79. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="103003030" LIMIT 1
  80. 2022-05-18 04:24:21.322246 94.57% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="103003030" LIMIT 1
  81. 2022-05-18 04:24:21.322246 94.57% [ERR] switch_core_sqldb.c:1310 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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="103003030" LIMIT 1]
  82. [STATE: 42S22 CODE 1054 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.25]Unknown column 'A.transfer_status' in 'field list'
  83. ]
  84. 2022-05-18 04:24:21.322246 94.57% [ERR] mod_lua.cpp:202 ...tch/scripts/astpp/lib/addons/astpp.did.call.transfer.lua:8: assertion failed!
  85. stack traceback:
  86.         [C]: in function 'assert'
  87.         ...tch/scripts/astpp/lib/addons/astpp.did.call.transfer.lua:8: in function 'check_did_for_did_call_transfer'
  88.         /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:176: in function 'check_did'
  89.         /usr/share/freeswitch/scripts/astpp/lib/astpp.functions.lua:70: in function 'define_call_direction'
  90.         ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:199: in main chunk
  91.         [C]: in function 'dofile'
  92.         /usr/share/freeswitch/scripts/astpp/astpp.lua:98: in main chunk
  93. 2022-05-18 04:24:21.322246 94.57% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  94. 2022-05-18 04:24:21.322246 94.57% [WARNING] mod_dialplan_xml.c:669 Context default not found
  95. 2022-05-18 04:24:21.322246 94.57% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  96. 2022-05-18 04:24:21.322246 94.57% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/9750900539@w07version60.astppbilling.org:5074 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  97. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State ROUTING going to sleep
  98. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Running State Change CS_HANGUP (Cur 1 Tot 3)
  99. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:844 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Callstate Change RINGING -> HANGUP
  100. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State HANGUP
  101. 2022-05-18 04:24:21.322246 94.57% [DEBUG] mod_sofia.c:468 Channel sofia/default/9750900539@w07version60.astppbilling.org:5074 hanging up, cause: NO_ROUTE_DESTINATION
  102. 2022-05-18 04:24:21.322246 94.57% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  103. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:59 sofia/default/9750900539@w07version60.astppbilling.org:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  104. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State HANGUP going to sleep
  105. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:616 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State Change CS_HANGUP -> CS_REPORTING
  106. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Running State Change CS_REPORTING (Cur 1 Tot 3)
  107. 2022-05-18 04:24:21.322246 94.57% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State REPORTING
  108. 2022-05-18 04:24:21.322246 94.57% [INFO] mod_json_cdr.c:271 Process [ef5eeb3f-abc3-48ff-b304-45f32ee935bf.cdr.json]
  109. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:168 sofia/default/9750900539@w07version60.astppbilling.org:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  110. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State REPORTING going to sleep
  111. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:607 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State Change CS_REPORTING -> CS_DESTROY
  112. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_session.c:1753 Session 3 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Locked, Waiting on external entities
  113. 2022-05-18 04:24:21.362252 94.57% [NOTICE] switch_core_session.c:1771 Session 3 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Ended
  114. 2022-05-18 04:24:21.362252 94.57% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/9750900539@w07version60.astppbilling.org:5074 [CS_DESTROY]
  115. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:735 (sofia/default/9750900539@w07version60.astppbilling.org:5074) Running State Change CS_DESTROY (Cur 0 Tot 3)
  116. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State DESTROY
  117. 2022-05-18 04:24:21.362252 94.57% [DEBUG] mod_sofia.c:379 sofia/default/9750900539@w07version60.astppbilling.org:5074 SOFIA DESTROY
  118. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:175 sofia/default/9750900539@w07version60.astppbilling.org:5074 Standard DESTROY
  119. 2022-05-18 04:24:21.362252 94.57% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9750900539@w07version60.astppbilling.org:5074) State DESTROY going to sleep
  120. freeswitch@ip-172-31-14-218>

Reply to "DID cal transfer when addon not install pbx instal"