FreeSWITCH Pastebin

when try to inbound call in v6, displayed error

From Prashant Kumar, 2 Years ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/d379f6cd
Embed
Download Paste or View Raw
  1. freeswitch@AlphaQA>
  2. freeswitch@AlphaQA>
  3. freeswitch@AlphaQA>
  4. 2022-10-14 08:19:41.113901 24.93% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [857524@alpha4.astppbilling.org] from ip 103.240.35.46
  5. 2022-10-14 08:19:41.293903 24.97% [CONSOLE] mod_voicemail.c:4065 Event Thread Started
  6. 2022-10-14 08:19:41.313895 24.97% [CONSOLE] sofia_presence.c:1620 Event Thread Started
  7. 2022-10-14 08:19:41.573898 24.97% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [857524@alpha4.astppbilling.org] from ip 103.240.35.46
  8. 2022-10-14 08:19:41.653895 24.97% [WARNING] sofia_reg.c:1861 SIP auth challenge (REGISTER) on sofia profile 'default' for [857524@alpha4.astppbilling.org] from ip 103.240.35.46
  9. 2022-10-14 08:19:42.293890 24.97% [WARNING] sofia_reg.c:3223 Can't find user [857524@alpha4.astppbilling.org] from 103.240.35.46
  10. You must define a domain called 'alpha4.astppbilling.org' in your directory and add a user with the id="857524" attribute
  11. and you must configure your device to use the proper domain in its authentication credentials.
  12. 2022-10-14 08:19:42.293890 24.97% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [857524@alpha4.astppbilling.org] from ip 103.240.35.46
  13. 2022-10-14 08:19:42.393894 24.97% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [857524@alpha4.astppbilling.org] from ip 103.240.35.46
  14. 2022-10-14 08:24:02.773912 39.40% [NOTICE] switch_channel.c:1123 New Channel sofia/default/10302222@46.101.114.158 [846319ec-77b4-45e8-842b-64adb537458c]
  15. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/10302222@46.101.114.158) Running State Change CS_NEW (Cur 1 Tot 1)
  16. 2022-10-14 08:24:02.773912 39.40% [INFO] sofia.c:10462 sofia/default/10302222@46.101.114.158 receiving invite from 46.101.114.158:5064 version: 1.10.7 -release 64bit call-id: 66dab056-c63c-123b-3793-ba05d31eb9f9
  17. 2022-10-14 08:24:02.773912 39.40% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 46.101.114.158:0.
  18. 2022-10-14 08:24:02.773912 39.40% [DEBUG] sofia.c:10585 IP 46.101.114.158 Approved by acl "default[]". Access Granted.
  19. 2022-10-14 08:24:02.773912 39.40% [DEBUG] sofia.c:7499 Channel sofia/default/10302222@46.101.114.158 entering state [received][100]
  20. 2022-10-14 08:24:02.773912 39.40% [DEBUG] sofia.c:7509 Remote SDP:
  21. v=0
  22. o=FreeSWITCH 1665703268 1665703269 IN IP4 46.101.114.158
  23. s=FreeSWITCH
  24. c=IN IP4 46.101.114.158
  25. t=0 0
  26. m=audio 32574 RTP/AVP 8 101
  27. a=rtpmap:8 PCMA/8000
  28. a=rtpmap:101 telephone-event/8000
  29. a=fmtp:101 0-15
  30. a=ptime:20
  31.  
  32. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  33. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  34. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  35. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  36. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/10302222@46.101.114.158 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  37. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_codec.c:111 sofia/default/10302222@46.101.114.158 Original read codec set to PCMA:8
  38. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  39. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_media.c:5973 sofia/default/10302222@46.101.114.158 Set 2833 dtmf send payload to 101 recv payload to 101
  40. 2022-10-14 08:24:02.773912 39.40% [DEBUG] sofia.c:7933 (sofia/default/10302222@46.101.114.158) State Change CS_NEW -> CS_INIT
  41. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:600 (sofia/default/10302222@46.101.114.158) State NEW
  42. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/10302222@46.101.114.158) Running State Change CS_INIT (Cur 1 Tot 1)
  43. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:624 (sofia/default/10302222@46.101.114.158) State INIT
  44. 2022-10-14 08:24:02.773912 39.40% [DEBUG] mod_sofia.c:97 sofia/default/10302222@46.101.114.158 SOFIA INIT
  45. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:40 sofia/default/10302222@46.101.114.158 Standard INIT
  46. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:48 (sofia/default/10302222@46.101.114.158) State Change CS_INIT -> CS_ROUTING
  47. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:624 (sofia/default/10302222@46.101.114.158) State INIT going to sleep
  48. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/10302222@46.101.114.158) Running State Change CS_ROUTING (Cur 1 Tot 1)
  49. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_channel.c:2380 (sofia/default/10302222@46.101.114.158) Callstate Change DOWN -> RINGING
  50. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:640 (sofia/default/10302222@46.101.114.158) State ROUTING
  51. 2022-10-14 08:24:02.773912 39.40% [DEBUG] mod_sofia.c:158 sofia/default/10302222@46.101.114.158 SOFIA ROUTING
  52. 2022-10-14 08:24:02.773912 39.40% [DEBUG] switch_core_state_machine.c:230 sofia/default/10302222@46.101.114.158 Standard ROUTING
  53. 2022-10-14 08:24:02.773912 39.40% [INFO] mod_dialplan_xml.c:639 Processing 9869754093 <10302222>->10302222 in context default
  54. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  55. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  56. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  57. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  58. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  59. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 10302222
  60. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '10302222' limit 1
  61. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  62. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '10302222' and status=0 LIMIT 1
  63. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+BetaServer
  64. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  65. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '10302222' limit 1
  66. 2022-10-14 08:24:02.793906 39.40% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  67. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 9869754093 / 10302222
  68. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 22
  69. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 103022 AND status=0 limit 1
  70. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  71. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  72. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  73. 2022-10-14 08:24:02.793906 39.40% [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 ="10302222" LIMIT 1
  74. 2022-10-14 08:24:02.793906 39.40% [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 ="10302222" LIMIT 1
  75. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  76. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="19103" and did_id ="29" and number ="10302222" and status = '0' LIMIT 1
  77. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  78. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("46.101.114.158") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "10302222"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  79. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 3673942894]
  80. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =10302222
  81. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "3673942894" AND deleted = 0 limit 1
  82. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =19103
  83. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
  84. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1
  85. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  86. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 19103
  87. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^10302222.*' OR patterns = '^1030222.*' OR patterns = '^103022.*' OR patterns = '^10302.*' OR patterns = '^1030.*' OR patterns = '^103.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 19103 ORDER BY LENGTH(PKGPTR.patterns) DESC
  88. 2022-10-14 08:24:02.793906 39.40% [ERR] switch_core_sqldb.c:1310 ERR: [SELECT *,P.id as package_id,P.product_id as product_id FROM packages_view as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_id WHERE P.is_terminated = 0 AND (patterns = '^10302222.*' OR patterns = '^1030222.*' OR patterns = '^103022.*' OR patterns = '^10302.*' OR patterns = '^1030.*' OR patterns = '^103.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 19103 ORDER BY LENGTH(PKGPTR.patterns) DESC]
  89. [STATE: HY000 CODE 1525 ERROR: [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.30]Incorrect DATETIME value: '0000-00-00 00:00:00'
  90. ]
  91. 2022-10-14 08:24:02.793906 39.40% [ERR] mod_lua.cpp:202 ./astpp/lib/astpp.functions.lua:1297: assertion failed!
  92. stack traceback:
  93.         [C]: in function 'assert'
  94.         ./astpp/lib/astpp.functions.lua:1297: in function 'package_calculation'
  95.         ./astpp/scripts/astpp.dialplan.lua:363: in main chunk
  96.         [C]: in function 'dofile'
  97.         ./astpp/astpp_deb9.lua:138: in main chunk
  98. 2022-10-14 08:24:02.793906 39.40% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  99. 2022-10-14 08:24:02.793906 39.40% [WARNING] mod_dialplan_xml.c:669 Context default not found
  100. 2022-10-14 08:24:02.793906 39.40% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  101. 2022-10-14 08:24:02.793906 39.40% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/10302222@46.101.114.158 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  102. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_core_state_machine.c:640 (sofia/default/10302222@46.101.114.158) State ROUTING going to sleep
  103. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/10302222@46.101.114.158) Running State Change CS_HANGUP (Cur 1 Tot 1)
  104. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_core_state_machine.c:844 (sofia/default/10302222@46.101.114.158) Callstate Change RINGING -> HANGUP
  105. 2022-10-14 08:24:02.793906 39.40% [DEBUG] switch_core_state_machine.c:846 (sofia/default/10302222@46.101.114.158) State HANGUP
  106. 2022-10-14 08:24:02.793906 39.40% [DEBUG] mod_sofia.c:468 Channel sofia/default/10302222@46.101.114.158 hanging up, cause: NO_ROUTE_DESTINATION
  107. 2022-10-14 08:24:02.813898 39.40% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  108. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:59 sofia/default/10302222@46.101.114.158 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  109. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:846 (sofia/default/10302222@46.101.114.158) State HANGUP going to sleep
  110. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:616 (sofia/default/10302222@46.101.114.158) State Change CS_HANGUP -> CS_REPORTING
  111. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/10302222@46.101.114.158) Running State Change CS_REPORTING (Cur 1 Tot 1)
  112. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:932 (sofia/default/10302222@46.101.114.158) State REPORTING
  113. 2022-10-14 08:24:02.813898 39.40% [INFO] mod_json_cdr.c:271 Process [846319ec-77b4-45e8-842b-64adb537458c.cdr.json]
  114. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:168 sofia/default/10302222@46.101.114.158 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  115. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:932 (sofia/default/10302222@46.101.114.158) State REPORTING going to sleep
  116. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:607 (sofia/default/10302222@46.101.114.158) State Change CS_REPORTING -> CS_DESTROY
  117. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_session.c:1753 Session 1 (sofia/default/10302222@46.101.114.158) Locked, Waiting on external entities
  118. 2022-10-14 08:24:02.813898 39.40% [NOTICE] switch_core_session.c:1771 Session 1 (sofia/default/10302222@46.101.114.158) Ended
  119. 2022-10-14 08:24:02.813898 39.40% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/10302222@46.101.114.158 [CS_DESTROY]
  120. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:735 (sofia/default/10302222@46.101.114.158) Running State Change CS_DESTROY (Cur 0 Tot 1)
  121. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:745 (sofia/default/10302222@46.101.114.158) State DESTROY
  122. 2022-10-14 08:24:02.813898 39.40% [DEBUG] mod_sofia.c:379 sofia/default/10302222@46.101.114.158 SOFIA DESTROY
  123. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:175 sofia/default/10302222@46.101.114.158 Standard DESTROY
  124. 2022-10-14 08:24:02.813898 39.40% [DEBUG] switch_core_state_machine.c:745 (sofia/default/10302222@46.101.114.158) State DESTROY going to sleep
  125. freeswitch@AlphaQA>

Reply to "when try to inbound call in v6, displayed error"