From Prashant Kumar, 10 Months ago, written in Plain Text.
- view diff
Embed
  1. Type /help <enter> to see a list of commands
  2.  
  3.  
  4.  
  5.  
  6. [This app Best viewed at 160x60 or more..]
  7. +OK log level  [7]
  8. freeswitch@FS1ClusterQA>
  9. freeswitch@FS1ClusterQA>
  10. freeswitch@FS1ClusterQA>
  11. 2023-05-24 14:28:12.665376 89.03% [NOTICE] switch_channel.c:1123 New Channel sofia/default/8000500020@13.232.246.166 [6ed8ba99-c050-43c9-8898-811996657d91]
  12. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_NEW (Cur 1 Tot 9136)
  13. 2023-05-24 14:28:12.665376 89.03% [INFO] sofia.c:10462 sofia/default/8000500020@13.232.246.166 receiving invite from 78.47.101.152:5060 version: 1.10.7 -release 64bit call-id: 0e11a8ed-74e2-123c-65b2-02c9c4cfda14
  14. 2023-05-24 14:28:12.665376 89.03% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 78.47.101.152:0.
  15. 2023-05-24 14:28:12.665376 89.03% [DEBUG] sofia.c:10585 IP 78.47.101.152 Approved by acl "default[]". Access Granted.
  16. 2023-05-24 14:28:12.665376 89.03% [DEBUG] sofia.c:7499 Channel sofia/default/8000500020@13.232.246.166 entering state [received][100]
  17. 2023-05-24 14:28:12.665376 89.03% [DEBUG] sofia.c:7509 Remote SDP:
  18. v=0
  19. o=FreeSWITCH 1684912484 1684912485 IN IP4 13.232.246.166
  20. s=FreeSWITCH
  21. c=IN IP4 13.232.246.166
  22. t=0 0
  23. m=audio 26008 RTP/AVP 0 101
  24. a=rtpmap:0 PCMU/8000
  25. a=rtpmap:101 telephone-event/8000
  26. a=fmtp:101 0-15
  27. a=ptime:20
  28.  
  29. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  30. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  31. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  32. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  33. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/8000500020@13.232.246.166 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
  34. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_codec.c:111 sofia/default/8000500020@13.232.246.166 Original read codec set to PCMU:0
  35. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  36. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_media.c:5973 sofia/default/8000500020@13.232.246.166 Set 2833 dtmf send payload to 101 recv payload to 101
  37. 2023-05-24 14:28:12.665376 89.03% [DEBUG] sofia.c:7933 (sofia/default/8000500020@13.232.246.166) State Change CS_NEW -> CS_INIT
  38. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8000500020@13.232.246.166) State NEW
  39. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_INIT (Cur 1 Tot 9136)
  40. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8000500020@13.232.246.166) State INIT
  41. 2023-05-24 14:28:12.665376 89.03% [DEBUG] mod_sofia.c:97 sofia/default/8000500020@13.232.246.166 SOFIA INIT
  42. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:40 sofia/default/8000500020@13.232.246.166 Standard INIT
  43. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8000500020@13.232.246.166) State Change CS_INIT -> CS_ROUTING
  44. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8000500020@13.232.246.166) State INIT going to sleep
  45. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_ROUTING (Cur 1 Tot 9136)
  46. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_channel.c:2380 (sofia/default/8000500020@13.232.246.166) Callstate Change DOWN -> RINGING
  47. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8000500020@13.232.246.166) State ROUTING
  48. 2023-05-24 14:28:12.665376 89.03% [DEBUG] mod_sofia.c:158 sofia/default/8000500020@13.232.246.166 SOFIA ROUTING
  49. 2023-05-24 14:28:12.665376 89.03% [DEBUG] switch_core_state_machine.c:230 sofia/default/8000500020@13.232.246.166 Standard ROUTING
  50. 2023-05-24 14:28:12.665376 89.03% [INFO] mod_dialplan_xml.c:639 Processing 8000500020 <8000500020>->18001802222 in context default
  51. 2023-05-24 14:28:12.685324 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  52. 2023-05-24 14:28:12.705344 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  53. 2023-05-24 14:28:12.705344 89.03% [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')
  54. 2023-05-24 14:28:12.705344 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  55. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  56. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 18001802222
  57. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '18001802222' limit 1
  58. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '18001802222' AND status=0 limit 1
  59. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '18001802222' and status=0 LIMIT 1
  60. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+Cluster
  61. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  62. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = '78.47.101.152' limit 1
  63. 2023-05-24 14:28:12.725317 89.03% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  64. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : "8000500020" / 8000500020
  65. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 02222
  66. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 180018 AND status=0 limit 1
  67. 2023-05-24 14:28:12.725317 89.03% [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 ="18001802222" LIMIT 1
  68. 2023-05-24 14:28:12.725317 89.03% [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 ="18001802222" LIMIT 1
  69. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  70. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="19" and did_id ="2" and number ="8000500020" and status = '0' LIMIT 1
  71. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  72. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 13.232.246.166
  73. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 8871003436]
  74. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =18001802222
  75. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "8871003436" AND deleted = 0 limit 1
  76. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =19
  77. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="18001802222" AND (accountid = 0 OR status = 1) LIMIT 1
  78. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  79. 2023-05-24 14:28:12.725317 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 19
  80. 2023-05-24 14:28:12.725317 89.03% [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 = '^18001802222.*' OR patterns = '^1800180222.*' OR patterns = '^180018022.*' OR patterns = '^18001802.*' OR patterns = '^1800180.*' OR patterns = '^180018.*' OR patterns = '^18001.*' OR patterns = '^1800.*' OR patterns = '^180.*' OR patterns = '^18.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 19 ORDER BY LENGTH(PKGPTR.patterns) DESC
  81. 2023-05-24 14:28:12.725317 89.03% [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 ="18001802222" AND A.accountid = '20' limit 1
  82. 2023-05-24 14:28:12.725317 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 18001802222
  83. 2023-05-24 14:28:12.725317 89.03% [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 ="18001802222" LIMIT 1
  84. 2023-05-24 14:28:12.765312 89.03% [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 ="18001802222" LIMIT 1
  85. 2023-05-24 14:28:12.765312 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  86. 2023-05-24 14:28:12.765312 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="19" and did_id ="2" and number ="8000500020" and status = '0' LIMIT 1
  87. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  88. 2023-05-24 14:28:12.765312 89.03% [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 = '18001802222' OR number = '1800180222' OR number = '180018022' OR number = '18001802' OR number = '1800180' OR number = '180018' OR number = '18001' OR number = '1800' OR number = '180' OR number = '18' OR number = '1' OR number ='--') OR (number = '18001802222*' OR number = '1800180222*' OR number = '180018022*' OR number = '18001802*' OR number = '1800180*' OR number = '180018*' OR number = '18001*' OR number = '1800*' OR number = '180*' OR number = '18*' OR number = '1*' OR number ='--') OR (number = '8000500020' OR number = '800050002' OR number = '80005000' OR number = '8000500' OR number = '800050' OR number = '80005' OR number = '8000' OR number = '800' OR number = '80' OR number = '8' OR number ='--') OR (number = '8000500020*' OR number = '800050002*' OR number = '80005000*' OR number = '8000500*' OR number = '800050*' OR number = '80005*' OR number = '8000*' OR number = '800*' OR number = '80*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  89. 2023-05-24 14:28:12.765312 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  90. 2023-05-24 14:28:12.765312 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '18001802222' OR routing_prefix = '1800180222' OR routing_prefix = '180018022' OR routing_prefix = '18001802' OR routing_prefix = '1800180' OR routing_prefix = '180018' OR routing_prefix = '18001' OR routing_prefix = '1800' OR routing_prefix = '180' OR routing_prefix = '18' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  91. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  92. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 20
  93. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 8871003436
  94. 2023-05-24 14:28:12.765312 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =19
  95. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 49980.28
  96. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  97. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  98. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  99. 2023-05-24 14:28:12.765312 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  100. 2023-05-24 14:28:12.765312 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  101. 2023-05-24 14:28:12.785338 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  102. 2023-05-24 14:28:12.785338 89.03% [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 ="18001802222" LIMIT 1
  103. 2023-05-24 14:28:12.785338 89.03% [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 ="18001802222" LIMIT 1
  104. 2023-05-24 14:28:12.785338 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  105. 2023-05-24 14:28:12.785338 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="19" and did_id ="2" and number ="8000500020" and status = '0' LIMIT 1
  106. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  107. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  108. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:1.45000
  109. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
  110. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '1' and status=0
  111. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:1.45000
  112. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  113. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 2
  114. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  115. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  116. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 1.45000
  117. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : Delhi Delhi
  118. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 131
  119. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 20
  120. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  121. 2023-05-24 14:28:12.785338 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =19
  122. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your49980.28 balance Accountid 20 !!!
  123. 2023-05-24 14:28:12.785338 89.03% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  124. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  125. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  126. 2023-05-24 14:28:12.785338 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  127. 2023-05-24 14:28:12.785338 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_OVERRIDE_CALLERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,accountid FROM accounts_callerid WHERE accountid = 20 AND status=0 LIMIT 1
  128. 2023-05-24 14:28:12.785338 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "19" AND deleted = 0 limit 1
  129. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =19
  130. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:20
  131. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:20
  132. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 20
  133. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 19 limit 1
  134. 2023-05-24 14:28:12.805501 89.03% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta1.astppbilling.org
  135. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  136. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  137. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  138. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  139. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing  WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "1" AND accounts.status = 0
  140. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :18001802222
  141. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :18001802222
  142. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 19 limit 1
  143. 2023-05-24 14:28:12.805501 89.03% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta1.astppbilling.org
  144. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_10
  145. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT daily_call_credit_limit,daily_call_used_limit,monthly_call_credit_limit,monthly_call_used_limit FROM accounts WHERE (number = 19 or id = 19 ) and status = 0 limit 1
  146. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 10
  147. 2023-05-24 14:28:12.805501 89.03% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : IVR
  148. 2023-05-24 14:28:12.805501 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_IVR_INFO] Query :SELECT * from pbx_ivr_specification WHERE id = 1 and status=0 LIMIT 1
  149. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '' LIMIT 1
  150. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  151. <document type="freeswitch/xml">
  152. <section name="dialplan" description="ASTPP Dialplan">
  153. <context name="default">
  154. <extension name="18001802222">
  155. <condition field="destination_number" expression="18001802222">
  156. <action application="set" data="effective_destination_number=18001802222"/>
  157. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  158. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  159. <action application="set" data="notify_flag=0"/>
  160. <action application="set" data="notify_credit_limit=5.00000"/>
  161. <action application="set" data="type=3"/>
  162. <action application="set" data="callstart=2023-05-24 14:28:12"/>
  163. <action application="set" data="hangup_after_bridge=true"/>
  164. <action application="set" data="continue_on_fail=TRUE"/>
  165. <action application="set" data="account_id=20"/>
  166. <action application="set" data="parent_id=0"/>
  167. <action application="set" data="entity_id=3"/>
  168. <action application="set" data="call_processed=internal"/>
  169. <action application="set" data="call_direction=inbound"/>
  170. <action application="set" data="accountname=default"/>
  171. <action application="set" data="filename1=astpp.pbx.lua"/>
  172. <action application="set" data="origination_rates_did=ID:2|CODE:^18001802222.*|DESTINATION:Delhi Delhi|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:1.45000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:131|ACCID:19"/>
  173. <action application="set" data="origination_rates=0"/>
  174. <action application="set" data="original_caller_id_name="8000500020""/>
  175. <action application="set" data="original_caller_id_number=8000500020"/>
  176. <action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
  177. <action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
  178. <action application="set" data="effective_caller_id_name="8000500020""/>
  179. <action application="set" data="effective_caller_id_number=8000500020"/>
  180. <action application="set" data="receiver_accid=19"/>
  181. <action application="set" data="did_id=2"/>
  182. <action application="set" data="transfer_call_type=4"/>
  183. <action application="set" data="transfer_extensions="/>
  184. <action application="set" data="busy_status=1"/>
  185. <action application="set" data="no_answer_status=1"/>
  186. <action application="set" data="always_status=1"/>
  187. <action application="set" data="transfer_status=1"/>
  188. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  189. <action application="set" data="variable_sip_network_ip=78.47.101.152"/>
  190. <action application="set" data="variable_sip_network_port=5060"/>
  191. <action application="export" data="domain_name=clusterguibeta1.astppbilling.org"/>
  192. <action application="export" data="sip_to_host=clusterguibeta1.astppbilling.org"/>
  193. <action application="export" data="presence_data=x|||PK DID and Outbound Call services(8871003436)|||^18001802222.* // Delhi Delhi // 1.45000|||||||||DID|||13.232.246.166"/>
  194. <action application="export" data="call_type=10"/>
  195. <action application="set" data="did_calltype=10"/>
  196. <action application="set" data="did_extensions=1"/>
  197. <action application="set" data="daily_call_credit_limit=0.00000"/>
  198. <action application="set" data="monthly_call_credit_limit=0.00000"/>
  199. <action application="set" data="daily_call_used_limit=0.00000"/>
  200. <action application="set" data="monthly_call_used_limit=0.00000"/>
  201. <action application="set" data="ringback="/>
  202. <action application="set" data="module_name=pbx"/>
  203. <action application="set" data="sip_h_P-call_type=custom_forward"/>
  204. <action application="set" data="sip_h_P-Accountcode=19"/>
  205. <action application="set" data="variable_sip_to_host=clusterguibeta1.astppbilling.org"/>
  206. <action application="set" data="userinfo_id=20"/>
  207. <action application="set" data="variable_sip_to_host=clusterguibeta1.astppbilling.org"/>
  208. <action application="set" data="original_did_number=18001802222"/>
  209.     <action application="answer"/>
  210. <action application="ivr" data="PKIVR0"/>
  211. <action application="lua" data="astpp/lib/pbx/astpp-failover_ivr_destination.lua"/>
  212. </condition>
  213. </extension>
  214. </context>
  215. </section>
  216. </document>
  217. Dialplan: sofia/default/8000500020@13.232.246.166 parsing [default->18001802222] continue=false
  218. Dialplan: sofia/default/8000500020@13.232.246.166 Regex (PASS) [18001802222] destination_number(18001802222) =~ /18001802222/ break=on-false
  219. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(effective_destination_number=18001802222)
  220. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  221. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  222. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(notify_flag=0)
  223. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(notify_credit_limit=5.00000)
  224. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(type=3)
  225. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(callstart=2023-05-24 14:28:12)
  226. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(hangup_after_bridge=true)
  227. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(continue_on_fail=TRUE)
  228. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(account_id=20)
  229. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(parent_id=0)
  230. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(entity_id=3)
  231. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(call_processed=internal)
  232. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(call_direction=inbound)
  233. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(accountname=default)
  234. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(filename1=astpp.pbx.lua)
  235. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(origination_rates_did=ID:2|CODE:^18001802222.*|DESTINATION:Delhi Delhi|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:1.45000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:131|ACCID:19)
  236. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(origination_rates=0)
  237. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(original_caller_id_name=)
  238. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(original_caller_id_number=8000500020)
  239. Dialplan: sofia/default/8000500020@13.232.246.166 Action hash(insert/${domain_name}-last_dial/${caller_id_number}/${destination_number})
  240. Dialplan: sofia/default/8000500020@13.232.246.166 Action hash(insert/${domain_name}-call_return/${destination_number}/${caller_id_number})
  241. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(effective_caller_id_name=)
  242. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(effective_caller_id_number=8000500020)
  243. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(receiver_accid=19)
  244. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(did_id=2)
  245. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(transfer_call_type=4)
  246. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(transfer_extensions=)
  247. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(busy_status=1)
  248. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(no_answer_status=1)
  249. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(always_status=1)
  250. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(transfer_status=1)
  251. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(variable_sip_to_host=${domain_name})
  252. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(variable_sip_network_ip=78.47.101.152)
  253. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(variable_sip_network_port=5060)
  254. Dialplan: sofia/default/8000500020@13.232.246.166 Action export(domain_name=clusterguibeta1.astppbilling.org)
  255. Dialplan: sofia/default/8000500020@13.232.246.166 Action export(sip_to_host=clusterguibeta1.astppbilling.org)
  256. Dialplan: sofia/default/8000500020@13.232.246.166 Action export(presence_data=x|||PK DID and Outbound Call services(8871003436)|||^18001802222.* // Delhi Delhi // 1.45000|||||||||DID|||13.232.246.166)
  257. Dialplan: sofia/default/8000500020@13.232.246.166 Action export(call_type=10)
  258. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(did_calltype=10)
  259. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(did_extensions=1)
  260. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(daily_call_credit_limit=0.00000)
  261. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(monthly_call_credit_limit=0.00000)
  262. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(daily_call_used_limit=0.00000)
  263. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(monthly_call_used_limit=0.00000)
  264. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(ringback=)
  265. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(module_name=pbx)
  266. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(sip_h_P-call_type=custom_forward)
  267. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(sip_h_P-Accountcode=19)
  268. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(variable_sip_to_host=clusterguibeta1.astppbilling.org)
  269. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(userinfo_id=20)
  270. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(variable_sip_to_host=clusterguibeta1.astppbilling.org)
  271. Dialplan: sofia/default/8000500020@13.232.246.166 Action set(original_did_number=18001802222)
  272. Dialplan: sofia/default/8000500020@13.232.246.166 Action answer()
  273. Dialplan: sofia/default/8000500020@13.232.246.166 Action ivr(PKIVR0)
  274. Dialplan: sofia/default/8000500020@13.232.246.166 Action lua(astpp/lib/pbx/astpp-failover_ivr_destination.lua)
  275. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8000500020@13.232.246.166) State Change CS_ROUTING -> CS_EXECUTE
  276. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8000500020@13.232.246.166) State ROUTING going to sleep
  277. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_EXECUTE (Cur 1 Tot 9136)
  278. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8000500020@13.232.246.166) State EXECUTE
  279. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_sofia.c:213 sofia/default/8000500020@13.232.246.166 SOFIA EXECUTE
  280. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_core_state_machine.c:323 sofia/default/8000500020@13.232.246.166 Standard EXECUTE
  281. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(effective_destination_number=18001802222)
  282. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [effective_destination_number]=[18001802222]
  283. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(bridge_pre_execute_bleg_app=sched_hangup)
  284. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [bridge_pre_execute_bleg_app]=[sched_hangup]
  285. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  286. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  287. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(notify_flag=0)
  288. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [notify_flag]=[0]
  289. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(notify_credit_limit=5.00000)
  290. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [notify_credit_limit]=[5.00000]
  291. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(type=3)
  292. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [type]=[3]
  293. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(callstart=2023-05-24 14:28:12)
  294. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [callstart]=[2023-05-24 14:28:12]
  295. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(hangup_after_bridge=true)
  296. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [hangup_after_bridge]=[true]
  297. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(continue_on_fail=TRUE)
  298. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [continue_on_fail]=[TRUE]
  299. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(account_id=20)
  300. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [account_id]=[20]
  301. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(parent_id=0)
  302. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [parent_id]=[0]
  303. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(entity_id=3)
  304. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [entity_id]=[3]
  305. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(call_processed=internal)
  306. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [call_processed]=[internal]
  307. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(call_direction=inbound)
  308. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [call_direction]=[inbound]
  309. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(accountname=default)
  310. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [accountname]=[default]
  311. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(filename1=astpp.pbx.lua)
  312. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [filename1]=[astpp.pbx.lua]
  313. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(origination_rates_did=ID:2|CODE:^18001802222.*|DESTINATION:Delhi Delhi|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:1.45000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:131|ACCID:19)
  314. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [origination_rates_did]=[ID:2|CODE:^18001802222.*|DESTINATION:Delhi Delhi|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:1.45000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:131|ACCID:19]
  315. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(origination_rates=0)
  316. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [origination_rates]=[0]
  317. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(original_caller_id_name=)
  318. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [original_caller_id_name]=[UNDEF]
  319. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(original_caller_id_number=8000500020)
  320. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [original_caller_id_number]=[8000500020]
  321. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 hash(insert/167.235.194.5-last_dial/8000500020/18001802222)
  322. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 hash(insert/167.235.194.5-call_return/18001802222/8000500020)
  323. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(effective_caller_id_name=)
  324. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [effective_caller_id_name]=[UNDEF]
  325. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(effective_caller_id_number=8000500020)
  326. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [effective_caller_id_number]=[8000500020]
  327. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(receiver_accid=19)
  328. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [receiver_accid]=[19]
  329. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(did_id=2)
  330. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [did_id]=[2]
  331. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(transfer_call_type=4)
  332. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [transfer_call_type]=[4]
  333. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(transfer_extensions=)
  334. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [transfer_extensions]=[UNDEF]
  335. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(busy_status=1)
  336. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [busy_status]=[1]
  337. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(no_answer_status=1)
  338. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [no_answer_status]=[1]
  339. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(always_status=1)
  340. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [always_status]=[1]
  341. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(transfer_status=1)
  342. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [transfer_status]=[1]
  343. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(variable_sip_to_host=167.235.194.5)
  344. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [variable_sip_to_host]=[167.235.194.5]
  345. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(variable_sip_network_ip=78.47.101.152)
  346. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [variable_sip_network_ip]=[78.47.101.152]
  347. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(variable_sip_network_port=5060)
  348. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [variable_sip_network_port]=[5060]
  349. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 export(domain_name=clusterguibeta1.astppbilling.org)
  350. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[clusterguibeta1.astppbilling.org]
  351. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 export(sip_to_host=clusterguibeta1.astppbilling.org)
  352. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[clusterguibeta1.astppbilling.org]
  353. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 export(presence_data=x|||PK DID and Outbound Call services(8871003436)|||^18001802222.* // Delhi Delhi // 1.45000|||||||||DID|||13.232.246.166)
  354. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||PK DID and Outbound Call services(8871003436)|||^18001802222.* // Delhi Delhi // 1.45000|||||||||DID|||13.232.246.166]
  355. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 export(call_type=10)
  356. 2023-05-24 14:28:12.825315 89.03% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[10]
  357. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(did_calltype=10)
  358. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [did_calltype]=[10]
  359. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(did_extensions=1)
  360. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [did_extensions]=[1]
  361. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(daily_call_credit_limit=0.00000)
  362. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [daily_call_credit_limit]=[0.00000]
  363. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(monthly_call_credit_limit=0.00000)
  364. 2023-05-24 14:28:12.825315 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [monthly_call_credit_limit]=[0.00000]
  365. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(daily_call_used_limit=0.00000)
  366. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [daily_call_used_limit]=[0.00000]
  367. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(monthly_call_used_limit=0.00000)
  368. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [monthly_call_used_limit]=[0.00000]
  369. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(ringback=)
  370. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [ringback]=[UNDEF]
  371. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(module_name=pbx)
  372. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [module_name]=[pbx]
  373. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(sip_h_P-call_type=custom_forward)
  374. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [sip_h_P-call_type]=[custom_forward]
  375. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(sip_h_P-Accountcode=19)
  376. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [sip_h_P-Accountcode]=[19]
  377. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(variable_sip_to_host=clusterguibeta1.astppbilling.org)
  378. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [variable_sip_to_host]=[clusterguibeta1.astppbilling.org]
  379. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(userinfo_id=20)
  380. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [userinfo_id]=[20]
  381. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(variable_sip_to_host=clusterguibeta1.astppbilling.org)
  382. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [variable_sip_to_host]=[clusterguibeta1.astppbilling.org]
  383. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 set(original_did_number=18001802222)
  384. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_dptools.c:1685 SET sofia/default/8000500020@13.232.246.166 [original_did_number]=[18001802222]
  385. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 answer()
  386. 2023-05-24 14:28:12.845335 89.03% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/8000500020@13.232.246.166] 167.235.194.5 port 16402 -> 13.232.246.166 port 26008 codec: 0 ms: 20
  387. 2023-05-24 14:28:12.845335 89.03% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
  388. 2023-05-24 14:28:12.845335 89.03% [DEBUG] switch_core_media.c:9089 sofia/default/8000500020@13.232.246.166 Set 2833 dtmf send payload to 101
  389. 2023-05-24 14:28:12.845335 89.03% [DEBUG] switch_core_media.c:9096 sofia/default/8000500020@13.232.246.166 Set 2833 dtmf receive payload to 101
  390. 2023-05-24 14:28:12.845335 89.03% [DEBUG] switch_core_media.c:9119 sofia/default/8000500020@13.232.246.166 Set rtp dtmf delay to 40
  391. 2023-05-24 14:28:12.845335 89.03% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/8000500020@13.232.246.166:
  392. v=0
  393. o=FreeSWITCH 1684922090 1684922091 IN IP4 167.235.194.5
  394. s=FreeSWITCH
  395. c=IN IP4 167.235.194.5
  396. t=0 0
  397. m=audio 16402 RTP/AVP 0 101
  398. a=rtpmap:0 PCMU/8000
  399. a=rtpmap:101 telephone-event/8000
  400. a=fmtp:101 0-15
  401. a=ptime:20
  402. a=sendrecv
  403.  
  404. 2023-05-24 14:28:12.845335 89.03% [NOTICE] mod_dptools.c:1419 Channel [sofia/default/8000500020@13.232.246.166] has been answered
  405. 2023-05-24 14:28:12.845335 89.03% [DEBUG] switch_channel.c:3950 (sofia/default/8000500020@13.232.246.166) Callstate Change RINGING -> ACTIVE
  406. 2023-05-24 14:28:12.845335 89.03% [DEBUG] sofia.c:7499 Channel sofia/default/8000500020@13.232.246.166 entering state [completed][200]
  407. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 ivr(PKIVR0)
  408. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exit'
  409. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-sub'
  410. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exec-app'
  411. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-play-sound'
  412. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-back'
  413. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-top'
  414. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:883 building menu 'PKIVR0'
  415. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '1'
  416. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '2'
  417. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '3'
  418. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '4'
  419. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '5'
  420. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '3419085661'
  421. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '918871343676'
  422. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '880000078080'
  423. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '10090303043'
  424. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_menu.c:486 Executing IVR menu PKIVR0
  425. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_core_file.c:444 File /var/www/html/astpp/upload/pbx/ASTPPWelcomeWithDTMFFeaturesNumber_240523020630.wav sample rate 16000 doesn't match requested rate 8000
  426. 2023-05-24 14:28:12.865318 89.03% [DEBUG] switch_ivr_play_say.c:1556 Codec Activated L16@8000hz 1 channels 20ms
  427. 2023-05-24 14:28:12.985331 89.03% [DEBUG] sofia.c:7499 Channel sofia/default/8000500020@13.232.246.166 entering state [ready][200]
  428. 2023-05-24 14:28:13.625352 88.73% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
  429. 2023-05-24 14:28:32.765338 89.43% [DEBUG] switch_rtp.c:8179 RTP RECV DTMF 5:960
  430. 2023-05-24 14:28:32.765338 89.43% [INFO] switch_channel.c:527 RECV DTMF 5:960
  431. 2023-05-24 14:28:32.765338 89.43% [DEBUG] switch_ivr_play_say.c:2001 done playing file /var/www/html/astpp/upload/pbx/ASTPPWelcomeWithDTMFFeaturesNumber_240523020630.wav
  432. 2023-05-24 14:28:32.765338 89.43% [DEBUG] switch_ivr_menu.c:378 waiting for 19/20 digits t/o 2000
  433. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_ivr_menu.c:425 digits '5'
  434. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_ivr_menu.c:580 IVR action on menu 'PKIVR0' matched '5' param 'transfer ${original_did_number}#PBX#7#1 XML ${domain_name}'
  435. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_ivr_menu.c:584 switch_ivr_menu_execute todo=[2]
  436. EXECUTE [depth=0] sofia/default/8000500020@13.232.246.166 transfer(18001802222#PBX#7#1 XML clusterguibeta1.astppbilling.org)
  437. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_ivr.c:2289 (sofia/default/8000500020@13.232.246.166) State Change CS_EXECUTE -> CS_ROUTING
  438. 2023-05-24 14:28:34.765354 91.53% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/8000500020@13.232.246.166 to XML[18001802222#PBX#7#1@clusterguibeta1.astppbilling.org]
  439. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_ivr_menu.c:676 exit-sound '(null)'
  440. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8000500020@13.232.246.166) State EXECUTE going to sleep
  441. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_ROUTING (Cur 1 Tot 9136)
  442. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_channel.c:2380 (sofia/default/8000500020@13.232.246.166) Callstate Change ACTIVE -> RINGING
  443. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8000500020@13.232.246.166) State ROUTING
  444. 2023-05-24 14:28:34.765354 91.53% [DEBUG] mod_sofia.c:158 sofia/default/8000500020@13.232.246.166 SOFIA ROUTING
  445. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_core_state_machine.c:230 sofia/default/8000500020@13.232.246.166 Standard ROUTING
  446. 2023-05-24 14:28:34.765354 91.53% [INFO] mod_dialplan_xml.c:639 Processing 8000500020 <8000500020>->18001802222#PBX#7#1 in context clusterguibeta1.astppbilling.org
  447. 2023-05-24 14:28:34.765354 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  448. 2023-05-24 14:28:34.765354 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  449. 2023-05-24 14:28:34.765354 91.53% [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')
  450. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  451. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  452. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 18001802222#PBX#7#1
  453. 2023-05-24 14:28:34.785327 91.53% [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 ="18001802222" LIMIT 1
  454. 2023-05-24 14:28:34.785327 91.53% [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 ="18001802222" LIMIT 1
  455. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  456. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "19" AND deleted = 0 limit 1
  457. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :19
  458. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 19 limit 1
  459. 2023-05-24 14:28:34.785327 91.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainclusterguibeta1.astppbilling.org
  460. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 7
  461. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Ring Group
  462. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : Query - SELECT call_screening from accounts WHERE id = '19' LIMIT 1
  463. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : Screening Option -
  464. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : is_intro_recorded - false
  465. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : introduction_recording_name -
  466. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET RING GROUP INFO] Query :SELECT id as ringgroup_id,name as ringgroup_name,strategy as ringgroup_strategy,destinations as ringgroup_destinations,description as ringgroup_description,announcementid as ringgroup_announcementid,call_record as ringgroup_call_record,skip_busy as ringgroup_skip_busy,ringbackid as ringgroup_ringbackid,calleridname as ringgroup_calleridname,greetingid as ringgroup_greetingid,calleridnumber as ringgroup_calleridnumber,no_answer as ringgroup_no_answer,no_answer_call_type as no_answer_call_type,voicemail_set,no_answer_call_type_value, greetingid as ringgroup_greetingid, music_on_hold_type,music_on_hold from pbx_ringgroup WHERE id = 1 and status = 0 LIMIT 1
  467. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX]  Conference greetingid::3
  468. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '3' LIMIT 1
  469. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== music_file_name=File name==================file_example_WAV_1MG_240523022118.wav
  470. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '4' LIMIT 1
  471. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] music on hold recording name :- /var/www/html/astpp//upload/pbx/sample-15s_240523022242.wav
  472. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 19 limit 1
  473. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== announcement===================0
  474. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Final Count : 0===
  475. 2023-05-24 14:28:34.785327 91.53% [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="8871003676"  AND domains.domain="clusterguibeta1.astppbilling.org" limit 1
  476. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 35 limit 1
  477. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC1]
  478. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT 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="8871003676"  AND domains.domain="clusterguibeta1.astppbilling.org" limit 1
  479. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_extensions_forwarding] Query :select sip_devices.id,sip_device_routing.call_forwarding_flag,sip_device_routing.call_forwarding_destination from sip_devices JOIN sip_device_routing ON sip_devices.id = sip_device_routing.sip_device_id where sip_devices.username = "8871003676"
  480. 2023-05-24 14:28:34.785327 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC3]
  481. 2023-05-24 14:28:34.785327 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT 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="8871003676"  AND domains.domain="clusterguibeta1.astppbilling.org" limit 1
  482. 2023-05-24 14:28:34.825338 91.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Final Count : 0===
  483. 2023-05-24 14:28:34.825338 91.53% [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="10404000000#"  AND domains.domain="clusterguibeta1.astppbilling.org" limit 1
  484. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX_SIP_ROUTING] [GET_ROUTING_INFO] Query :SELECT * from sip_device_routing WHERE sip_device_id = 35 limit 1
  485. 2023-05-24 14:28:34.825338 91.53% [ERR] mod_lua.cpp:202 ...ip_pbx/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:289: attempt to concatenate a nil value
  486. stack traceback:
  487.         ...ip_pbx/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:289: in function 'did_pbx_info'
  488.         ...ip_pbx/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:2063: in function 'ringgroup_no_answer_forward'
  489.         ./astpp/scripts/astpp.dialplan.lua:63: in main chunk
  490.         [C]: in function 'dofile'
  491.         ./astpp/astpp_deb9.lua:138: in main chunk
  492. 2023-05-24 14:28:34.825338 91.53% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  493. 2023-05-24 14:28:34.825338 91.53% [WARNING] mod_dialplan_xml.c:669 Context clusterguibeta1.astppbilling.org not found
  494. 2023-05-24 14:28:34.825338 91.53% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  495. 2023-05-24 14:28:34.825338 91.53% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/8000500020@13.232.246.166 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  496. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8000500020@13.232.246.166) State ROUTING going to sleep
  497. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_HANGUP (Cur 1 Tot 9136)
  498. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8000500020@13.232.246.166) Callstate Change RINGING -> HANGUP
  499. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8000500020@13.232.246.166) State HANGUP
  500. 2023-05-24 14:28:34.825338 91.53% [DEBUG] mod_sofia.c:468 Channel sofia/default/8000500020@13.232.246.166 hanging up, cause: NO_ROUTE_DESTINATION
  501. 2023-05-24 14:28:34.825338 91.53% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/8000500020@13.232.246.166
  502. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:59 sofia/default/8000500020@13.232.246.166 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  503. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8000500020@13.232.246.166) State HANGUP going to sleep
  504. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8000500020@13.232.246.166) State Change CS_HANGUP -> CS_REPORTING
  505. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8000500020@13.232.246.166) Running State Change CS_REPORTING (Cur 1 Tot 9136)
  506. 2023-05-24 14:28:34.825338 91.53% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8000500020@13.232.246.166) State REPORTING
  507. 2023-05-24 14:28:34.825338 91.53% [INFO] mod_json_cdr.c:271 Process [6ed8ba99-c050-43c9-8898-811996657d91.cdr.json]
  508. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:168 sofia/default/8000500020@13.232.246.166 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  509. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8000500020@13.232.246.166) State REPORTING going to sleep
  510. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:607 (sofia/default/8000500020@13.232.246.166) State Change CS_REPORTING -> CS_DESTROY
  511. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_session.c:1753 Session 9136 (sofia/default/8000500020@13.232.246.166) Locked, Waiting on external entities
  512. 2023-05-24 14:28:34.865324 91.53% [NOTICE] switch_core_session.c:1771 Session 9136 (sofia/default/8000500020@13.232.246.166) Ended
  513. 2023-05-24 14:28:34.865324 91.53% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/8000500020@13.232.246.166 [CS_DESTROY]
  514. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:735 (sofia/default/8000500020@13.232.246.166) Running State Change CS_DESTROY (Cur 0 Tot 9136)
  515. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8000500020@13.232.246.166) State DESTROY
  516. 2023-05-24 14:28:34.865324 91.53% [DEBUG] mod_sofia.c:379 sofia/default/8000500020@13.232.246.166 SOFIA DESTROY
  517. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:175 sofia/default/8000500020@13.232.246.166 Standard DESTROY
  518. 2023-05-24 14:28:34.865324 91.53% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8000500020@13.232.246.166) State DESTROY going to sleep
  519. freeswitch@FS1ClusterQA>
  520. freeswitch@FS1ClusterQA>
  521. freeswitch@FS1ClusterQA>
  522. freeswitch@FS1ClusterQA> /exit