FreeSWITCH Pastebin

when gatways inactive display TR not found error

From Prashant Kumar, 1 Year ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/7156300e
Embed
Download Paste or View Raw
  1. freeswitch@devangASTPP>
  2. freeswitch@devangASTPP>
  3. 2022-08-10 10:04:08.285543 89.73% [NOTICE] switch_channel.c:1123 New Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 [9286459f-0e84-4027-8141-4114255a3130]
  4. 2022-08-10 10:04:08.285543 89.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_NEW (Cur 1 Tot 52)
  5. 2022-08-10 10:04:08.285543 89.73% [INFO] sofia.c:10462 sofia/default/8822934216@astppqa605.astppbilling.org:5072 receiving invite from 103.240.35.46:56624 version: 1.10.7 -release 64bit call-id: MTYxNDE5ZDEyNzAzMGZkMmJhZjkwODg4ODU5ZDNmMDQ.
  6. 2022-08-10 10:04:08.285543 89.73% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0.
  7. 2022-08-10 10:04:08.285543 89.73% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [999007070@astppqa605.astppbilling.org] from ip 103.240.35.46
  8. 2022-08-10 10:04:08.285543 89.73% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State NEW
  9. 2022-08-10 10:04:08.285543 89.73% [DEBUG] sofia.c:2419 detaching session 9286459f-0e84-4027-8141-4114255a3130
  10. 2022-08-10 10:04:08.605540 89.73% [DEBUG] sofia.c:2532 Re-attaching to session 9286459f-0e84-4027-8141-4114255a3130
  11. 2022-08-10 10:04:08.625543 89.73% [INFO] sofia.c:10462 sofia/default/8822934216@astppqa605.astppbilling.org:5072 receiving invite from 103.240.35.46:56624 version: 1.10.7 -release 64bit call-id: MTYxNDE5ZDEyNzAzMGZkMmJhZjkwODg4ODU5ZDNmMDQ.
  12. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 103.240.35.46:0.
  13. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
  14. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:7499 Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 entering state [received][100]
  15. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:7509 Remote SDP:
  16. v=0
  17. o=Z 0 0 IN IP4 103.240.35.46
  18. s=Z
  19. c=IN IP4 103.240.35.46
  20. t=0 0
  21. m=audio 8000 RTP/AVP 3 110 8 0 98 101
  22. a=rtpmap:110 speex/8000
  23. a=rtpmap:98 iLBC/8000
  24. a=fmtp:98 mode=20
  25. a=rtpmap:101 telephone-event/8000
  26. a=fmtp:101 0-15
  27.  
  28. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  29. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  30. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
  31. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
  32. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  33. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  34. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  35. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  36. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  37. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  38. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
  39. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
  40. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  41. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/8822934216@astppqa605.astppbilling.org:5072 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  42. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_codec.c:111 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Original read codec set to PCMA:8
  43. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  44. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_media.c:5973 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Set 2833 dtmf send payload to 101 recv payload to 101
  45. 2022-08-10 10:04:08.625543 89.73% [DEBUG] sofia.c:7933 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_NEW -> CS_INIT
  46. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_INIT (Cur 1 Tot 52)
  47. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State INIT
  48. 2022-08-10 10:04:08.625543 89.73% [DEBUG] mod_sofia.c:97 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA INIT
  49. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:40 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard INIT
  50. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_INIT -> CS_ROUTING
  51. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State INIT going to sleep
  52. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_ROUTING (Cur 1 Tot 52)
  53. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_channel.c:2380 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Callstate Change DOWN -> RINGING
  54. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State ROUTING
  55. 2022-08-10 10:04:08.625543 89.73% [DEBUG] mod_sofia.c:158 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA ROUTING
  56. 2022-08-10 10:04:08.625543 89.73% [DEBUG] switch_core_state_machine.c:230 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard ROUTING
  57. 2022-08-10 10:04:08.625543 89.73% [INFO] mod_dialplan_xml.c:639 Processing 8822934216 <8822934216>->999007070 in context default
  58. 2022-08-10 10:04:08.625543 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  59. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  60. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  61. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  62. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  63. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 999007070
  64. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '999007070' limit 1
  65. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  66. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '999007070' and status=0 LIMIT 1
  67. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER8822934216
  68. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  69. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '999007070' limit 1
  70. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 8822934216 / 8822934216
  71. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number
  72. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 999007070 AND status=0 limit 1
  73. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  74. 2022-08-10 10:04:08.645538 89.73% [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="999007070"  AND domains.domain="astppqa605.astppbilling.org" limit 1
  75. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  76. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 999001]
  77. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "999001" AND deleted = 0 limit 1
  78. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^999007070.*' OR blocked_patterns = '^99900707.*' OR blocked_patterns = '^9990070.*' OR blocked_patterns = '^999007.*' OR blocked_patterns = '^99900.*' OR blocked_patterns = '^9990.*' OR blocked_patterns = '^999.*' OR blocked_patterns = '^99.*' OR blocked_patterns = '^9.*' OR blocked_patterns ='--') AND accountid = 21 limit 1
  79. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
  80. 2022-08-10 10:04:08.645538 89.73% [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 = '^999007070.*' OR patterns = '^99900707.*' OR patterns = '^9990070.*' OR patterns = '^999007.*' OR patterns = '^99900.*' OR patterns = '^9990.*' OR patterns = '^999.*' OR patterns = '^99.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 21 ORDER BY LENGTH(PKGPTR.patterns) DESC
  81. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_SPEEDDIAL] Query :SELECT A.number FROM speed_dial as A,accounts as B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.speed_num ="999007070" AND A.accountid = '21' limit 1
  82. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 999007070
  83. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  84. 2022-08-10 10:04:08.645538 89.73% [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="999007070"  AND domains.domain="astppqa605.astppbilling.org" limit 1
  85. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
  86. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '999007070' OR number = '99900707' OR number = '9990070' OR number = '999007' OR number = '99900' OR number = '9990' OR number = '999' OR number = '99' OR number = '9' OR number ='--') OR (number = '999007070*' OR number = '99900707*' OR number = '9990070*' OR number = '999007*' OR number = '99900*' OR number = '9990*' OR number = '999*' OR number = '99*' OR number = '9*' OR number ='--') OR (number = '8822934216' OR number = '882293421' OR number = '88229342' OR number = '8822934' OR number = '882293' OR number = '88229' OR number = '8822' OR number = '882' OR number = '88' OR number = '8' OR number ='--') OR (number = '8822934216*' OR number = '882293421*' OR number = '88229342*' OR number = '8822934*' OR number = '882293*' OR number = '88229*' OR number = '8822*' OR number = '882*' OR number = '88*' OR number = '8*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  87. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  88. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '999007070' OR routing_prefix = '99900707' OR routing_prefix = '9990070' OR routing_prefix = '999007' OR routing_prefix = '99900' OR routing_prefix = '9990' OR routing_prefix = '999' OR routing_prefix = '99' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  89. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  90. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 21
  91. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 999001
  92. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 49783.3664
  93. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  94. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 5
  95. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  96. 2022-08-10 10:04:08.645538 89.73% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  97. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
  98. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::5
  99. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
  100. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
  101. 2022-08-10 10:04:08.645538 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::5
  102. 2022-08-10 10:04:08.665540 89.73% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-5
  103. 2022-08-10 10:04:09.505553 89.10% [NOTICE] switch_channel.c:1123 New Channel sofia/default/5352@142.132.184.134 [17965cb5-f78e-4e1c-8bc4-3e02c13afe7d]
  104. 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5352@142.132.184.134) Running State Change CS_NEW (Cur 2 Tot 53)
  105. 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-5
  106. 2022-08-10 10:04:09.505553 89.10% [INFO] sofia.c:10462 sofia/default/5352@142.132.184.134 receiving invite from 51.79.18.155:20726 version: 1.10.7 -release 64bit call-id: 9m5sbOrN29OmOyB32znQwo..
  107. 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :my-rates-5
  108. 2022-08-10 10:04:09.505553 89.10% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 51.79.18.155:0.
  109. 2022-08-10 10:04:09.505553 89.10% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [+6468827959@142.132.184.134] from ip 51.79.18.155
  110. 2022-08-10 10:04:09.505553 89.10% [DEBUG] switch_core_state_machine.c:600 (sofia/default/5352@142.132.184.134) State NEW
  111. 2022-08-10 10:04:09.505553 89.10% [DEBUG] sofia.c:2419 detaching session 17965cb5-f78e-4e1c-8bc4-3e02c13afe7d
  112. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING]0 GOT___SUCCESS2022-08-10 10:04:09
  113. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING] 1=GOT___SUCCESS=pattern::^999.*
  114. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [ROUTES_CACHING] 1=GOT___SUCCESS=caller_id_pattern::^.*
  115. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : outbound
  116. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  117. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.40000
  118. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:5
  119. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '5' and status=0
  120. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] holiday_based_routing :
  121. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Query :SELECT gmttime from timezone where id = '118'
  122. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Data :GMT+00:00
  123. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Holiday Plus timezone
  124. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -05:00 :
  125. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_date:10
  126. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted Holiday current_time_month:Aug
  127. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :10-8
  128. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Hliday today_date :1
  129. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] today_date mday:-
  130. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] demand_based_condition :
  131. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT gmttime from timezone where id = '118'
  132. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Data :GMT+00:00
  133. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Plus timezone
  134. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If timezone like = +05:00 :
  135. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted current_time: 10.04
  136. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] BEFORE current_wday :Wed
  137. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]If Holiday timezone like = -00:00 :
  138. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Converted DAY current_wday:Wed
  139. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] AFTER current_wday :Wed
  140. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Current Day Number4
  141. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Demand based routing Match emand_based_condition_value['wday'][1] :-7
  142. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.40000
  143. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  144. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 10053
  145. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  146. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  147. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.40000
  148. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : RSA
  149. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 116
  150. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 21
  151. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID:
  152. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type:
  153. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  154. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your49783.3664 balance Accountid 21 !!!
  155. 2022-08-10 10:04:09.525536 89.10% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  156. 2022-08-10 10:04:09.525536 89.10% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  157. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id :
  158. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=5 ORDER by id asc
  159. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^999007070.*' OR pattern = '^99900707.*' OR pattern = '^9990070.*' OR pattern = '^999007.*' OR pattern = '^99900.*' OR pattern = '^9990.*' OR pattern = '^999.*' OR pattern = '^99.*' OR pattern = '^9.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (4) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC
  160. 2022-08-10 10:04:09.525536 89.10% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [Dialplan] No Termination Rates Found...!!!
  161. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  Post Cdrs : 0
  162. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 21
  163. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  164. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  165. <document type="freeswitch/xml">
  166. <section name="dialplan" description="ASTPP Dialplan">
  167. <context name="default">
  168. <extension name="999007070">
  169. <condition field="destination_number" expression="999007070">
  170. <action application="log" data="WARNING Accountcode 999001. Dialed number (999007070) termination rates not found!!"/>
  171. <action application="set" data="original_caller_id_name=8822934216"/>
  172. <action application="set" data="original_caller_id_number=8822934216"/>
  173. <action application="set" data="error_cdr=1"/>
  174. <action application="set" data="callstart=2022-08-10 10:04:09"/>
  175. <action application="set" data="account_id=21"/>
  176. <action application="set" data="parent_id=0"/>
  177. <action application="set" data="call_direction=outbound"/>
  178. <action application="set" data="sip_ignore_remote_cause=true"/>
  179. <action application="set" data="call_processed=internal"/>
  180. <action application="set" data="effective_destination_number=999007070"/>
  181. <action application="set" data="last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND"/>
  182. <action application="hangup" data="TERMINATION_RATE_NOT_FOUND"/>
  183. </condition>
  184. </extension>
  185. </context>
  186. </section>
  187. </document>
  188. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 parsing [default->999007070] continue=false
  189. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Regex (PASS) [999007070] destination_number(999007070) =~ /999007070/ break=on-false
  190. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action log(WARNING Accountcode 999001. Dialed number (999007070) termination rates not found!!)
  191. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(original_caller_id_name=8822934216)
  192. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(original_caller_id_number=8822934216)
  193. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(error_cdr=1)
  194. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(callstart=2022-08-10 10:04:09)
  195. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(account_id=21)
  196. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(parent_id=0)
  197. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(call_direction=outbound)
  198. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(sip_ignore_remote_cause=true)
  199. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(call_processed=internal)
  200. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(effective_destination_number=999007070)
  201. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action set(last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND)
  202. Dialplan: sofia/default/8822934216@astppqa605.astppbilling.org:5072 Action hangup(TERMINATION_RATE_NOT_FOUND)
  203. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_ROUTING -> CS_EXECUTE
  204. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State ROUTING going to sleep
  205. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_EXECUTE (Cur 2 Tot 53)
  206. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State EXECUTE
  207. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_sofia.c:213 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA EXECUTE
  208. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:323 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard EXECUTE
  209. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 log(WARNING Accountcode 999001. Dialed number (999007070) termination rates not found!!)
  210. 2022-08-10 10:04:09.525536 89.10% [WARNING] mod_dptools.c:1879 Accountcode 999001. Dialed number (999007070) termination rates not found!!
  211. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(original_caller_id_name=8822934216)
  212. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [original_caller_id_name]=[8822934216]
  213. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(original_caller_id_number=8822934216)
  214. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [original_caller_id_number]=[8822934216]
  215. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(error_cdr=1)
  216. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [error_cdr]=[1]
  217. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(callstart=2022-08-10 10:04:09)
  218. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [callstart]=[2022-08-10 10:04:09]
  219. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(account_id=21)
  220. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [account_id]=[21]
  221. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(parent_id=0)
  222. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [parent_id]=[0]
  223. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(call_direction=outbound)
  224. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [call_direction]=[outbound]
  225. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(sip_ignore_remote_cause=true)
  226. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [sip_ignore_remote_cause]=[true]
  227. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(call_processed=internal)
  228. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [call_processed]=[internal]
  229. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(effective_destination_number=999007070)
  230. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [effective_destination_number]=[999007070]
  231. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 set(last_bridge_hangup_cause=TERMINATION_RATE_NOT_FOUND)
  232. 2022-08-10 10:04:09.525536 89.10% [DEBUG] mod_dptools.c:1685 SET sofia/default/8822934216@astppqa605.astppbilling.org:5072 [last_bridge_hangup_cause]=[TERMINATION_RATE_NOT_FOUND]
  233. EXECUTE [depth=0] sofia/default/8822934216@astppqa605.astppbilling.org:5072 hangup(TERMINATION_RATE_NOT_FOUND)
  234. 2022-08-10 10:04:09.525536 89.10% [NOTICE] mod_dptools.c:1387 Hangup sofia/default/8822934216@astppqa605.astppbilling.org:5072 [CS_EXECUTE] [NORMAL_CLEARING]
  235. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_session.c:2983 sofia/default/8822934216@astppqa605.astppbilling.org:5072 skip receive message [PHONE_EVENT] (channel is hungup already)
  236. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State EXECUTE going to sleep
  237. 2022-08-10 10:04:09.525536 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_HANGUP (Cur 2 Tot 53)
  238. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Callstate Change RINGING -> HANGUP
  239. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State HANGUP
  240. 2022-08-10 10:04:09.545545 89.10% [DEBUG] mod_sofia.c:468 Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 hanging up, cause: NORMAL_CLEARING
  241. 2022-08-10 10:04:09.545545 89.10% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 480
  242. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:59 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard HANGUP, cause: NORMAL_CLEARING
  243. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State HANGUP going to sleep
  244. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_HANGUP -> CS_REPORTING
  245. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_REPORTING (Cur 2 Tot 53)
  246. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State REPORTING
  247. 2022-08-10 10:04:09.545545 89.10% [INFO] mod_json_cdr.c:271 Process [9286459f-0e84-4027-8141-4114255a3130.cdr.json]
  248. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:168 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard REPORTING, cause: NORMAL_CLEARING
  249. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State REPORTING going to sleep
  250. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:607 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State Change CS_REPORTING -> CS_DESTROY
  251. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_session.c:1753 Session 52 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Locked, Waiting on external entities
  252. 2022-08-10 10:04:09.545545 89.10% [NOTICE] switch_core_session.c:1771 Session 52 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Ended
  253. 2022-08-10 10:04:09.545545 89.10% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/8822934216@astppqa605.astppbilling.org:5072 [CS_DESTROY]
  254. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:735 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) Running State Change CS_DESTROY (Cur 1 Tot 53)
  255. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State DESTROY
  256. 2022-08-10 10:04:09.545545 89.10% [DEBUG] mod_sofia.c:379 sofia/default/8822934216@astppqa605.astppbilling.org:5072 SOFIA DESTROY
  257. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:175 sofia/default/8822934216@astppqa605.astppbilling.org:5072 Standard DESTROY
  258. 2022-08-10 10:04:09.545545 89.10% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8822934216@astppqa605.astppbilling.org:5072) State DESTROY going to sleep
  259. freeswitch@devangASTPP> /exit
  260.  
  261. root@devangASTPP:/opt/ASTPP#
  262. root@devangASTPP:/opt/ASTPP

Reply to "when gatways inactive display TR not found error"