FreeSWITCH Pastebin

Time Condition error issue

From Prashant Kumar, 8 Months ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/f8703e5a
Embed
Download Paste or View Raw
  1. freeswitch@FS1ClusterQA>
  2. 2023-09-16 12:18:36.889454 97.67% [NOTICE] switch_channel.c:1123 New Channel sofia/default/8700847196@13.232.246.166 [932098c6-dc56-443d-8a8a-6de018c74dae]
  3. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_NEW (Cur 1 Tot 89)
  4. 2023-09-16 12:18:36.889454 97.67% [INFO] sofia.c:10462 sofia/default/8700847196@13.232.246.166 receiving invite from 78.47.101.152:5073 version: 1.10.7 -release 64bit call-id: 00d8efc8-cf2e-123c-1193-02c9c4cfda14
  5. 2023-09-16 12:18:36.889454 97.67% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 78.47.101.152:0.
  6. 2023-09-16 12:18:36.889454 97.67% [DEBUG] sofia.c:10585 IP 78.47.101.152 Approved by acl "default[]". Access Granted.
  7. 2023-09-16 12:18:36.889454 97.67% [DEBUG] sofia.c:7499 Channel sofia/default/8700847196@13.232.246.166 entering state [received][100]
  8. 2023-09-16 12:18:36.889454 97.67% [DEBUG] sofia.c:7509 Remote SDP:
  9. v=0
  10. o=FreeSWITCH 1694844256 1694844257 IN IP4 13.232.246.166
  11. s=FreeSWITCH
  12. c=IN IP4 13.232.246.166
  13. t=0 0
  14. m=audio 22460 RTP/AVP 8 101
  15. a=rtpmap:8 PCMA/8000
  16. a=rtpmap:101 telephone-event/8000
  17. a=fmtp:101 0-15
  18. a=ptime:20
  19.  
  20. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  21. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  22. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  23. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  24. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/8700847196@13.232.246.166 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  25. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_codec.c:111 sofia/default/8700847196@13.232.246.166 Original read codec set to PCMA:8
  26. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  27. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_media.c:5973 sofia/default/8700847196@13.232.246.166 Set 2833 dtmf send payload to 101 recv payload to 101
  28. 2023-09-16 12:18:36.889454 97.67% [DEBUG] sofia.c:7933 (sofia/default/8700847196@13.232.246.166) State Change CS_NEW -> CS_INIT
  29. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8700847196@13.232.246.166) State NEW
  30. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_INIT (Cur 1 Tot 89)
  31. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8700847196@13.232.246.166) State INIT
  32. 2023-09-16 12:18:36.889454 97.67% [DEBUG] mod_sofia.c:97 sofia/default/8700847196@13.232.246.166 SOFIA INIT
  33. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:40 sofia/default/8700847196@13.232.246.166 Standard INIT
  34. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8700847196@13.232.246.166) State Change CS_INIT -> CS_ROUTING
  35. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8700847196@13.232.246.166) State INIT going to sleep
  36. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_ROUTING (Cur 1 Tot 89)
  37. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_channel.c:2380 (sofia/default/8700847196@13.232.246.166) Callstate Change DOWN -> RINGING
  38. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8700847196@13.232.246.166) State ROUTING
  39. 2023-09-16 12:18:36.889454 97.67% [DEBUG] mod_sofia.c:158 sofia/default/8700847196@13.232.246.166 SOFIA ROUTING
  40. 2023-09-16 12:18:36.889454 97.67% [DEBUG] switch_core_state_machine.c:230 sofia/default/8700847196@13.232.246.166 Standard ROUTING
  41. 2023-09-16 12:18:36.889454 97.67% [INFO] mod_dialplan_xml.c:639 Processing 8700847196 <8700847196>->1080200 in context default
  42. 2023-09-16 12:18:36.909472 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  43. 2023-09-16 12:18:36.929446 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  44. 2023-09-16 12:18:36.929446 97.67% [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')
  45. 2023-09-16 12:18:36.929446 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  46. 2023-09-16 12:18:36.949465 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  47. 2023-09-16 12:18:36.949465 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1080200
  48. 2023-09-16 12:18:36.949465 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1080200' limit 1
  49. 2023-09-16 12:18:36.949465 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1080200' AND status=0 limit 1
  50. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1080200' and status=0 LIMIT 1
  51. 2023-09-16 12:18:36.969457 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+ClusterServer
  52. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  53. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = '78.47.101.152' limit 1
  54. 2023-09-16 12:18:36.969457 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  55. 2023-09-16 12:18:36.969457 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : "8700847196" / 8700847196
  56. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 0
  57. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 108020 AND status=0 limit 1
  58. 2023-09-16 12:18:36.969457 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  59. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  60. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  61. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  62. 2023-09-16 12:18:36.969457 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  63. 2023-09-16 12:18:36.989467 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  64. 2023-09-16 12:18:36.989467 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 13.232.246.166
  65. 2023-09-16 12:18:36.989467 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9810050033]
  66. 2023-09-16 12:18:36.989467 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =1080200
  67. 2023-09-16 12:18:36.989467 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "9810050033" OR id = "9810050033") AND deleted = 0 limit 1
  68. 2023-09-16 12:18:36.989467 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  69. 2023-09-16 12:18:36.989467 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="1080200" AND (accountid = 0 OR status = 1) LIMIT 1
  70. 2023-09-16 12:18:36.989467 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  71. 2023-09-16 12:18:36.989467 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 16
  72. 2023-09-16 12:18:36.989467 97.67% [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 = '^1080200.*' OR patterns = '^108020.*' OR patterns = '^10802.*' OR patterns = '^1080.*' OR patterns = '^108.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 16 ORDER BY LENGTH(PKGPTR.patterns) DESC
  73. 2023-09-16 12:18:37.009442 97.67% [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 ="1080200" AND A.accountid = '10' limit 1
  74. 2023-09-16 12:18:37.009442 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 1080200
  75. 2023-09-16 12:18:37.009442 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  76. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  77. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  78. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  79. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  80. 2023-09-16 12:18:37.009442 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  81. 2023-09-16 12:18:37.009442 97.67% [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 = '1080200' OR number = '108020' OR number = '10802' OR number = '1080' OR number = '108' OR number = '10' OR number = '1' OR number ='--') OR (number = '1080200*' OR number = '108020*' OR number = '10802*' OR number = '1080*' OR number = '108*' OR number = '10*' OR number = '1*' OR number ='--') OR (number = '8700847196' OR number = '870084719' OR number = '87008471' OR number = '8700847' OR number = '870084' OR number = '87008' OR number = '8700' OR number = '870' OR number = '87' OR number = '8' OR number ='--') OR (number = '8700847196*' OR number = '870084719*' OR number = '87008471*' OR number = '8700847*' OR number = '870084*' OR number = '87008*' OR number = '8700*' OR number = '870*' OR number = '87*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  82. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  83. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '1080200' OR routing_prefix = '108020' OR routing_prefix = '10802' OR routing_prefix = '1080' OR routing_prefix = '108' OR routing_prefix = '10' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  84. 2023-09-16 12:18:37.009442 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  85. 2023-09-16 12:18:37.009442 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 10
  86. 2023-09-16 12:18:37.009442 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9810050033
  87. 2023-09-16 12:18:37.009442 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  88. 2023-09-16 12:18:37.029456 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 499986.51
  89. 2023-09-16 12:18:37.029456 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  90. 2023-09-16 12:18:37.029456 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  91. 2023-09-16 12:18:37.029456 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  92. 2023-09-16 12:18:37.029456 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  93. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  94. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  95. 2023-09-16 12:18:37.029456 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  96. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  97. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  98. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  99. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  100. 2023-09-16 12:18:37.029456 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 16  and status = 0 limit 1
  101. 2023-09-16 12:18:37.049443 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :0.....1080200
  102. 2023-09-16 12:18:37.049443 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_RESELLER] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.connectcost,A.includedseconds,A.cost,C.reseller_cost as reseller_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,A.always as always,A.always_destination as always_destination,D.id as product_id FROM dids AS A,accounts AS B, reseller_products AS C, products AS D WHERE B.status=0 AND B.deleted=0 AND A.product_id=C.product_id AND A.parent_id=C.account_id AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  103. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  104. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  105. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.99000
  106. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
  107. 2023-09-16 12:18:37.049443 97.67% [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
  108. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.99000
  109. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  110. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 6
  111. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  112. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  113. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.99000
  114. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 1080200
  115. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 52
  116. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 10
  117. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  118. 2023-09-16 12:18:37.049443 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  119. 2023-09-16 12:18:37.049443 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your499986.51 balance Accountid 10 !!!
  120. 2023-09-16 12:18:37.049443 97.67% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  121. 2023-09-16 12:18:37.049443 97.67% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 14
  122. 2023-09-16 12:18:37.049443 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "14" OR number = "14") AND deleted = 0 limit 1
  123. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  124. 2023-09-16 12:18:37.069450 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  125. 2023-09-16 12:18:37.069450 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 14
  126. 2023-09-16 12:18:37.069450 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9810050077
  127. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  128. 2023-09-16 12:18:37.069450 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 499986.51
  129. 2023-09-16 12:18:37.069450 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  130. 2023-09-16 12:18:37.069450 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  131. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  132. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  133. 2023-09-16 12:18:37.069450 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  134. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  135. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  136. 2023-09-16 12:18:37.069450 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  137. 2023-09-16 12:18:37.089441 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  138. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  139. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  140. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.77000
  141. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
  142. 2023-09-16 12:18:37.089441 97.67% [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
  143. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.77000
  144. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  145. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 6
  146. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  147. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  148. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.77000
  149. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 1080200
  150. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 52
  151. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 14
  152. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  153. 2023-09-16 12:18:37.089441 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  154. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your499986.51 balance Accountid 14 !!!
  155. 2023-09-16 12:18:37.089441 97.67% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  156. 2023-09-16 12:18:37.089441 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Daily call credit limit : 7786.5584415584
  157. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14
  158. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  159. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 1
  160. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  161. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  162. 2023-09-16 12:18:37.089441 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  163. 2023-09-16 12:18:37.089441 97.67% [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 = 10 AND status=0 LIMIT 1
  164. 2023-09-16 12:18:37.089441 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "16" OR number = "16") AND deleted = 0 limit 1
  165. 2023-09-16 12:18:37.089441 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  166. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:10
  167. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:10
  168. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 10
  169. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 16 limit 1
  170. 2023-09-16 12:18:37.109425 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta3.astppbilling.org
  171. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 2
  172. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
  173. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"100009000#","no_answer_call_type":"12"}]
  174. span style="color: green; font-weight: bold;"> 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition : [{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-12","year":"2023-2023","extensions":"7065545454444#","no_answer_call_type":"12","priority":"1"}]
  175. span style="color: green; font-weight: bold;"> 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
  176. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '194' LIMIT 1
  177. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"
  178. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  179. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_sip_device_info_for_did_pstn_call] Query :SELECT username FROM sip_devices WHERE username = 'gw+ClusterServer' and status = 0 limit 1
  180. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  181. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  182. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  183. 2023-09-16 12:18:37.109425 97.67% [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 = "2" AND accounts.status = 0
  184. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :1080200
  185. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :1080200
  186. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 16 limit 1
  187. 2023-09-16 12:18:37.109425 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta3.astppbilling.org
  188. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  189. 2023-09-16 12:18:37.109425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 2
  190. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
  191. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  192. <document type="freeswitch/xml">
  193. <section name="dialplan" description="ASTPP Dialplan">
  194. <context name="default">
  195. <extension name="PKTimeCondition" continue="true">
  196. <condition time-of-day= "00:01-23:59" break="never">
  197. <action application="set" data="office_status=open" inline="true"/>
  198. <action application="set" data="extensions=100009000#" inline="true"/>
  199. <action application="set" data="no_answer_did_number=1080200" inline="true"/>
  200. <action application="set" data="no_answer_call_type=12" inline="true"/>
  201. </condition>
  202. </extension>
  203. <extension name="PKTimeCondition" continue="true">
  204. <condition break="never">
  205. <action application="set" data="timezone=Asia/Kolkata" inline="true"/>
  206. </condition>
  207. <condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
  208. <action application="set" data="office_status=open" inline="true"/>
  209. <action application="set" data="extensions=7065545454444#" inline="true"/>
  210. <action application="set" data="no_answer_did_number=1080200" inline="true"/>
  211. <action application="set" data="no_answer_call_type=12" inline="true"/>
  212. </condition>
  213. </extension>
  214. <extension name="tod route, x1080200">
  215. <condition field="destination_number" expression="^(\+?)?(1080200)$">
  216. <action application="execute_extension" data="1080200_${office_status}"/>
  217. </condition>
  218. </extension>
  219. <extension name="office is open">
  220. <condition field="destination_number" expression="^(\+?)?(1080200_open)$">
  221. <action application="set" data="domain_name=clusterguibeta3.astppbilling.org"/>
  222. <action application="set" data="set_extensions=${extensions}"/>
  223. <action application="set" data="original_caller_id_name="8700847196""/>
  224. <action application="set" data="original_caller_id_number="8700847196""/>
  225. <action application="set" data="callstart=2023-09-16 12:18:37"/>
  226. <action application="set" data="account_id=16"/>
  227. <action application="set" data="call_direction=inbound"/>
  228. <action application="set" data="call_type=11"/>
  229. <action application="set" data="receiver_accid=16"/>
  230. <action application="set" data="origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14"/>
  231. <action application="set" data="module_name=pbx"/>
  232. <action application="set" data="original_did_number=1080200"/>
  233. <action application="set" data="no_answer_flag=true"/>
  234. <action application="set" data="no_answer_did_number=1080200" inline="true"/>
  235. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
  236. <action application="set" data="no_answer_number=${extensions}" />
  237. <action application="transfer" data="16 XML default"/>
  238. </condition>
  239. </extension>
  240. <extension name="1080200">
  241. <condition field="destination_number" expression="1080200">
  242. <action application="set" data="effective_destination_number=1080200"/>
  243. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  244. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  245. <action application="set" data="notify_flag=0"/>
  246. <action application="set" data="notify_credit_limit=5.00000"/>
  247. <action application="set" data="type=3"/>
  248. <action application="set" data="callstart=2023-09-16 12:18:37"/>
  249. <action application="set" data="hangup_after_bridge=true"/>
  250. <action application="set" data="continue_on_fail=TRUE"/>
  251. <action application="set" data="account_id=10"/>
  252. <action application="set" data="parent_id=14"/>
  253. <action application="set" data="entity_id=3"/>
  254. <action application="set" data="call_processed=internal"/>
  255. <action application="set" data="call_direction=inbound"/>
  256. <action application="set" data="accountname=default"/>
  257. <action application="set" data="filename1=astpp.pbx.lua"/>
  258. <action application="set" data="origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14"/>
  259. <action application="set" data="origination_rates=0"/>
  260. <action application="set" data="original_caller_id_name="8700847196""/>
  261. <action application="set" data="original_caller_id_number=8700847196"/>
  262. <action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
  263. <action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
  264. <action application="set" data="effective_caller_id_name="8700847196""/>
  265. <action application="set" data="effective_caller_id_number=8700847196"/>
  266. <action application="set" data="receiver_accid=16"/>
  267. <action application="set" data="did_id=6"/>
  268. <action application="set" data="transfer_call_type=4"/>
  269. <action application="set" data="transfer_extensions=10666666666666"/>
  270. <action application="set" data="busy_status=1"/>
  271. <action application="set" data="no_answer_status=1"/>
  272. <action application="set" data="always_status=1"/>
  273. <action application="set" data="transfer_status=1"/>
  274. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  275. <action application="set" data="variable_sip_network_ip=78.47.101.152"/>
  276. <action application="set" data="variable_sip_network_port=5073"/>
  277. <action application="export" data="domain_name=clusterguibeta3.astppbilling.org"/>
  278. <action application="export" data="sip_to_host=clusterguibeta3.astppbilling.org"/>
  279. <action application="export" data="presence_data=x//14|||PK Call Service Provider(9810050033)|||^1080200.* // 1080200 // 0.99000|||||||||DID|||13.232.246.166"/>
  280. <action application="export" data="call_type=11"/>
  281. </condition>
  282. </extension>
  283. </context>
  284. </section>
  285. </document>
  286. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->PKTimeCondition] continue=true
  287. Dialplan: sofia/default/8700847196@13.232.246.166 Date/Time Match (PASS) [PKTimeCondition] break=never
  288. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(office_status=open) INLINE
  289. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(office_status=open)
  290. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [office_status]=[open]
  291. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(extensions=100009000#) INLINE
  292. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(extensions=100009000#)
  293. span style="color: goldenrod; font-weight: bold;"> 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [extensions]=[100009000#]
  294. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_did_number=1080200) INLINE
  295. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(no_answer_did_number=1080200)
  296. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_did_number]=[1080200]
  297. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_call_type=12) INLINE
  298. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(no_answer_call_type=12)
  299. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_call_type]=[12]
  300. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->PKTimeCondition] continue=true
  301. Dialplan: sofia/default/8700847196@13.232.246.166 Absolute Condition [PKTimeCondition]
  302. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(timezone=Asia/Kolkata) INLINE
  303. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(timezone=Asia/Kolkata)
  304. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [timezone]=[Asia/Kolkata]
  305. Dialplan: sofia/default/8700847196@13.232.246.166 Date/Time Match (PASS) [PKTimeCondition] break=never
  306. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(office_status=open) INLINE
  307. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(office_status=open)
  308. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [office_status]=[open]
  309. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(extensions=7065545454444#) INLINE
  310. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(extensions=7065545454444#)
  311. span style="color: goldenrod; font-weight: bold;"> 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [extensions]=[7065545454444#]
  312. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_did_number=1080200) INLINE
  313. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(no_answer_did_number=1080200)
  314. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_did_number]=[1080200]
  315. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_call_type=12) INLINE
  316. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 set(no_answer_call_type=12)
  317. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_call_type]=[12]
  318. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->tod route, x1080200] continue=false
  319. Dialplan: sofia/default/8700847196@13.232.246.166 Regex (PASS) [tod route, x1080200] destination_number(1080200) =~ /^(\+?)?(1080200)$/ break=on-false
  320. Dialplan: sofia/default/8700847196@13.232.246.166 Action execute_extension(1080200_${office_status})
  321. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8700847196@13.232.246.166) State Change CS_ROUTING -> CS_EXECUTE
  322. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8700847196@13.232.246.166) State ROUTING going to sleep
  323. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_EXECUTE (Cur 1 Tot 89)
  324. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8700847196@13.232.246.166) State EXECUTE
  325. 2023-09-16 12:18:37.109425 97.67% [DEBUG] mod_sofia.c:213 sofia/default/8700847196@13.232.246.166 SOFIA EXECUTE
  326. 2023-09-16 12:18:37.109425 97.67% [DEBUG] switch_core_state_machine.c:323 sofia/default/8700847196@13.232.246.166 Standard EXECUTE
  327. EXECUTE [depth=0] sofia/default/8700847196@13.232.246.166 execute_extension(1080200_open)
  328. 2023-09-16 12:18:37.109425 97.67% [INFO] mod_dialplan_xml.c:639 Processing 8700847196 <8700847196>->1080200_open in context default
  329. 2023-09-16 12:18:37.129419 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  330. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  331. 2023-09-16 12:18:37.129419 97.67% [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')
  332. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  333. 2023-09-16 12:18:37.129419 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  334. 2023-09-16 12:18:37.129419 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1080200
  335. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1080200' limit 1
  336. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1080200' AND status=0 limit 1
  337. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1080200' and status=0 LIMIT 1
  338. 2023-09-16 12:18:37.129419 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+ClusterServer
  339. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  340. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = '78.47.101.152' limit 1
  341. 2023-09-16 12:18:37.129419 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  342. 2023-09-16 12:18:37.129419 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : "8700847196" / 8700847196
  343. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 0
  344. 2023-09-16 12:18:37.129419 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 108020 AND status=0 limit 1
  345. 2023-09-16 12:18:37.149418 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  346. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  347. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  348. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  349. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  350. 2023-09-16 12:18:37.149418 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  351. 2023-09-16 12:18:37.149418 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 13.232.246.166
  352. 2023-09-16 12:18:37.149418 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9810050033]
  353. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =1080200
  354. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "9810050033" OR id = "9810050033") AND deleted = 0 limit 1
  355. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  356. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="1080200" AND (accountid = 0 OR status = 1) LIMIT 1
  357. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  358. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 16
  359. 2023-09-16 12:18:37.149418 97.67% [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 = '^1080200.*' OR patterns = '^108020.*' OR patterns = '^10802.*' OR patterns = '^1080.*' OR patterns = '^108.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 16 ORDER BY LENGTH(PKGPTR.patterns) DESC
  360. 2023-09-16 12:18:37.149418 97.67% [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 ="1080200" AND A.accountid = '10' limit 1
  361. 2023-09-16 12:18:37.149418 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 1080200
  362. 2023-09-16 12:18:37.149418 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  363. 2023-09-16 12:18:37.149418 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  364. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  365. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  366. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  367. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  368. 2023-09-16 12:18:37.169421 97.67% [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 = '1080200' OR number = '108020' OR number = '10802' OR number = '1080' OR number = '108' OR number = '10' OR number = '1' OR number ='--') OR (number = '1080200*' OR number = '108020*' OR number = '10802*' OR number = '1080*' OR number = '108*' OR number = '10*' OR number = '1*' OR number ='--') OR (number = '8700847196' OR number = '870084719' OR number = '87008471' OR number = '8700847' OR number = '870084' OR number = '87008' OR number = '8700' OR number = '870' OR number = '87' OR number = '8' OR number ='--') OR (number = '8700847196*' OR number = '870084719*' OR number = '87008471*' OR number = '8700847*' OR number = '870084*' OR number = '87008*' OR number = '8700*' OR number = '870*' OR number = '87*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  369. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  370. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '1080200' OR routing_prefix = '108020' OR routing_prefix = '10802' OR routing_prefix = '1080' OR routing_prefix = '108' OR routing_prefix = '10' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  371. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  372. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 10
  373. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9810050033
  374. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  375. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 499986.51
  376. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  377. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  378. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  379. 2023-09-16 12:18:37.169421 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  380. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  381. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  382. 2023-09-16 12:18:37.169421 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  383. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  384. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  385. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  386. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  387. 2023-09-16 12:18:37.169421 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 16  and status = 0 limit 1
  388. 2023-09-16 12:18:37.189433 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :0.....1080200
  389. 2023-09-16 12:18:37.189433 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_RESELLER] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.connectcost,A.includedseconds,A.cost,C.reseller_cost as reseller_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,A.always as always,A.always_destination as always_destination,D.id as product_id FROM dids AS A,accounts AS B, reseller_products AS C, products AS D WHERE B.status=0 AND B.deleted=0 AND A.product_id=C.product_id AND A.parent_id=C.account_id AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  390. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  391. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  392. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.99000
  393. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
  394. 2023-09-16 12:18:37.189433 97.67% [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
  395. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.99000
  396. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  397. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 6
  398. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  399. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  400. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.99000
  401. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 1080200
  402. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 52
  403. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 10
  404. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  405. 2023-09-16 12:18:37.189433 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  406. 2023-09-16 12:18:37.189433 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your499986.51 balance Accountid 10 !!!
  407. 2023-09-16 12:18:37.189433 97.67% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  408. 2023-09-16 12:18:37.189433 97.67% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 14
  409. 2023-09-16 12:18:37.189433 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "14" OR number = "14") AND deleted = 0 limit 1
  410. 2023-09-16 12:18:37.189433 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  411. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  412. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 14
  413. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9810050077
  414. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  415. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 499986.51
  416. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  417. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  418. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  419. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  420. 2023-09-16 12:18:37.209475 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  421. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  422. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  423. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  424. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  425. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  426. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  427. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.77000
  428. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:1
  429. 2023-09-16 12:18:37.209475 97.67% [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
  430. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.77000
  431. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  432. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 6
  433. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  434. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  435. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.77000
  436. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 1080200
  437. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 52
  438. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 14
  439. 2023-09-16 12:18:37.209475 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  440. 2023-09-16 12:18:37.209475 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  441. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your499986.51 balance Accountid 14 !!!
  442. 2023-09-16 12:18:37.229440 97.67% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  443. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Daily call credit limit : 7786.5584415584
  444. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14
  445. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  446. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 1
  447. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  448. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  449. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  450. 2023-09-16 12:18:37.229440 97.67% [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 = 10 AND status=0 LIMIT 1
  451. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "16" OR number = "16") AND deleted = 0 limit 1
  452. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =16
  453. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:10
  454. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:10
  455. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 10
  456. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 16 limit 1
  457. 2023-09-16 12:18:37.229440 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : clusterguibeta3.astppbilling.org
  458. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 2
  459. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
  460. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"100009000#","no_answer_call_type":"12"}]
  461. span style="color: green; font-weight: bold;"> 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition : [{"hour":"00-23","minute":"00-59","wday":"1-7","mday":"1-31","mon":"1-12","year":"2023-2023","extensions":"7065545454444#","no_answer_call_type":"12","priority":"1"}]
  462. span style="color: green; font-weight: bold;"> 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
  463. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '194' LIMIT 1
  464. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Condition Str :  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"
  465. 2023-09-16 12:18:37.229440 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  466. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_sip_device_info_for_did_pstn_call] Query :SELECT username FROM sip_devices WHERE username = 'gw+ClusterServer' and status = 0 limit 1
  467. 2023-09-16 12:18:37.229440 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  468. 2023-09-16 12:18:37.249434 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  469. 2023-09-16 12:18:37.249434 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  470. 2023-09-16 12:18:37.249434 97.67% [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 = "2" AND accounts.status = 0
  471. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as redial] destination_number :1080200
  472. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Set number as return] destination_number :1080200
  473. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 16 limit 1
  474. 2023-09-16 12:18:37.249434 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : clusterguibeta3.astppbilling.org
  475. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  476. 2023-09-16 12:18:37.249434 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 2
  477. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '2' and status =0 LIMIT 1
  478. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  479. <document type="freeswitch/xml">
  480. <section name="dialplan" description="ASTPP Dialplan">
  481. <context name="default">
  482. <extension name="PKTimeCondition" continue="true">
  483. <condition time-of-day= "00:01-23:59" break="never">
  484. <action application="set" data="office_status=open" inline="true"/>
  485. <action application="set" data="extensions=100009000#" inline="true"/>
  486. <action application="set" data="no_answer_did_number=1080200" inline="true"/>
  487. <action application="set" data="no_answer_call_type=12" inline="true"/>
  488. </condition>
  489. </extension>
  490. <extension name="PKTimeCondition" continue="true">
  491. <condition break="never">
  492. <action application="set" data="timezone=Asia/Kolkata" inline="true"/>
  493. </condition>
  494. <condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
  495. <action application="set" data="office_status=open" inline="true"/>
  496. <action application="set" data="extensions=7065545454444#" inline="true"/>
  497. <action application="set" data="no_answer_did_number=1080200" inline="true"/>
  498. <action application="set" data="no_answer_call_type=12" inline="true"/>
  499. </condition>
  500. </extension>
  501. <extension name="tod route, x1080200">
  502. <condition field="destination_number" expression="^(\+?)?(1080200)$">
  503. <action application="execute_extension" data="1080200_${office_status}"/>
  504. </condition>
  505. </extension>
  506. <extension name="office is open">
  507. <condition field="destination_number" expression="^(\+?)?(1080200_open)$">
  508. <action application="set" data="domain_name=clusterguibeta3.astppbilling.org"/>
  509. <action application="set" data="set_extensions=${extensions}"/>
  510. <action application="set" data="original_caller_id_name="8700847196""/>
  511. <action application="set" data="original_caller_id_number="8700847196""/>
  512. <action application="set" data="callstart=2023-09-16 12:18:37"/>
  513. <action application="set" data="account_id=16"/>
  514. <action application="set" data="call_direction=inbound"/>
  515. <action application="set" data="call_type=11"/>
  516. <action application="set" data="receiver_accid=16"/>
  517. <action application="set" data="origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14"/>
  518. <action application="set" data="module_name=pbx"/>
  519. <action application="set" data="original_did_number=1080200"/>
  520. <action application="set" data="no_answer_flag=true"/>
  521. <action application="set" data="no_answer_did_number=1080200" inline="true"/>
  522. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
  523. <action application="set" data="no_answer_number=${extensions}" />
  524. <action application="transfer" data="16 XML default"/>
  525. </condition>
  526. </extension>
  527. <extension name="1080200">
  528. <condition field="destination_number" expression="1080200">
  529. <action application="set" data="effective_destination_number=1080200"/>
  530. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  531. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  532. <action application="set" data="notify_flag=0"/>
  533. <action application="set" data="notify_credit_limit=5.00000"/>
  534. <action application="set" data="type=3"/>
  535. <action application="set" data="callstart=2023-09-16 12:18:37"/>
  536. <action application="set" data="hangup_after_bridge=true"/>
  537. <action application="set" data="continue_on_fail=TRUE"/>
  538. <action application="set" data="account_id=10"/>
  539. <action application="set" data="parent_id=14"/>
  540. <action application="set" data="entity_id=3"/>
  541. <action application="set" data="call_processed=internal"/>
  542. <action application="set" data="call_direction=inbound"/>
  543. <action application="set" data="accountname=default"/>
  544. <action application="set" data="filename1=astpp.pbx.lua"/>
  545. <action application="set" data="origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14"/>
  546. <action application="set" data="origination_rates=0"/>
  547. <action application="set" data="original_caller_id_name="8700847196""/>
  548. <action application="set" data="original_caller_id_number=8700847196"/>
  549. <action application="hash" data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"/>
  550. <action application="hash" data="insert/${domain_name}-call_return/${destination_number}/${caller_id_number}"/>
  551. <action application="set" data="effective_caller_id_name="8700847196""/>
  552. <action application="set" data="effective_caller_id_number=8700847196"/>
  553. <action application="set" data="receiver_accid=16"/>
  554. <action application="set" data="did_id=6"/>
  555. <action application="set" data="transfer_call_type=4"/>
  556. <action application="set" data="transfer_extensions=10666666666666"/>
  557. <action application="set" data="busy_status=1"/>
  558. <action application="set" data="no_answer_status=1"/>
  559. <action application="set" data="always_status=1"/>
  560. <action application="set" data="transfer_status=1"/>
  561. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  562. <action application="set" data="variable_sip_network_ip=78.47.101.152"/>
  563. <action application="set" data="variable_sip_network_port=5073"/>
  564. <action application="export" data="domain_name=clusterguibeta3.astppbilling.org"/>
  565. <action application="export" data="sip_to_host=clusterguibeta3.astppbilling.org"/>
  566. <action application="export" data="presence_data=x//14|||PK Call Service Provider(9810050033)|||^1080200.* // 1080200 // 0.99000|||||||||DID|||13.232.246.166"/>
  567. <action application="export" data="call_type=11"/>
  568. </condition>
  569. </extension>
  570. </context>
  571. </section>
  572. </document>
  573. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->PKTimeCondition] continue=true
  574. Dialplan: sofia/default/8700847196@13.232.246.166 Date/Time Match (PASS) [PKTimeCondition] break=never
  575. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(office_status=open) INLINE
  576. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(office_status=open)
  577. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [office_status]=[open]
  578. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(extensions=100009000#) INLINE
  579. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(extensions=100009000#)
  580. span style="color: goldenrod; font-weight: bold;"> 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [extensions]=[100009000#]
  581. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_did_number=1080200) INLINE
  582. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_did_number=1080200)
  583. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_did_number]=[1080200]
  584. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_call_type=12) INLINE
  585. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_call_type=12)
  586. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_call_type]=[12]
  587. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->PKTimeCondition] continue=true
  588. Dialplan: sofia/default/8700847196@13.232.246.166 Absolute Condition [PKTimeCondition]
  589. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(timezone=Asia/Kolkata) INLINE
  590. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(timezone=Asia/Kolkata)
  591. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [timezone]=[Asia/Kolkata]
  592. Dialplan: sofia/default/8700847196@13.232.246.166 Date/Time Match (PASS) [PKTimeCondition] break=never
  593. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(office_status=open) INLINE
  594. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(office_status=open)
  595. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [office_status]=[open]
  596. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(extensions=7065545454444#) INLINE
  597. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(extensions=7065545454444#)
  598. span style="color: goldenrod; font-weight: bold;"> 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [extensions]=[7065545454444#]
  599. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_did_number=1080200) INLINE
  600. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_did_number=1080200)
  601. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_did_number]=[1080200]
  602. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_call_type=12) INLINE
  603. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_call_type=12)
  604. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_call_type]=[12]
  605. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->tod route, x1080200] continue=false
  606. Dialplan: sofia/default/8700847196@13.232.246.166 Regex (FAIL) [tod route, x1080200] destination_number(1080200_open) =~ /^(\+?)?(1080200)$/ break=on-false
  607. Dialplan: sofia/default/8700847196@13.232.246.166 parsing [default->office is open] continue=false
  608. Dialplan: sofia/default/8700847196@13.232.246.166 Regex (PASS) [office is open] destination_number(1080200_open) =~ /^(\+?)?(1080200_open)$/ break=on-false
  609. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(domain_name=clusterguibeta3.astppbilling.org)
  610. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(set_extensions=${extensions})
  611. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(original_caller_id_name=)
  612. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(original_caller_id_number=)
  613. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(callstart=2023-09-16 12:18:37)
  614. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(account_id=16)
  615. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(call_direction=inbound)
  616. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(call_type=11)
  617. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(receiver_accid=16)
  618. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14)
  619. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(module_name=pbx)
  620. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(original_did_number=1080200)
  621. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_flag=true)
  622. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_did_number=1080200) INLINE
  623. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_did_number=1080200)
  624. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_did_number]=[1080200]
  625. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_call_type=${no_answer_call_type})
  626. Dialplan: sofia/default/8700847196@13.232.246.166 Action set(no_answer_number=${extensions})
  627. Dialplan: sofia/default/8700847196@13.232.246.166 Action transfer(16 XML default)
  628. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(domain_name=clusterguibeta3.astppbilling.org)
  629. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(domain_name=clusterguibeta3.astppbilling.org)
  630. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [domain_name]=[clusterguibeta3.astppbilling.org]
  631. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(set_extensions=${extensions})
  632. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(set_extensions=7065545454444#)
  633. span style="color: goldenrod; font-weight: bold;"> 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [set_extensions]=[7065545454444#]
  634. span style="color: cornflowerblue; font-weight: bold;"> 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(original_caller_id_name=)
  635. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(original_caller_id_name=)
  636. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [original_caller_id_name]=[UNDEF]
  637. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(original_caller_id_number=)
  638. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(original_caller_id_number=)
  639. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [original_caller_id_number]=[UNDEF]
  640. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(callstart=2023-09-16 12:18:37)
  641. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(callstart=2023-09-16 12:18:37)
  642. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [callstart]=[2023-09-16 12:18:37]
  643. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(account_id=16)
  644. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(account_id=16)
  645. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [account_id]=[16]
  646. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(call_direction=inbound)
  647. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(call_direction=inbound)
  648. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [call_direction]=[inbound]
  649. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(call_type=11)
  650. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(call_type=11)
  651. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [call_type]=[11]
  652. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(receiver_accid=16)
  653. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(receiver_accid=16)
  654. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [receiver_accid]=[16]
  655. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14)
  656. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(origination_rates_did=ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14)
  657. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [origination_rates_did]=[ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.99000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:16||ID:6|CODE:^1080200.*|DESTINATION:1080200|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.77000|INC:60|INITIALBLOCK:60|RATEGROUP:0|MARKUP:0|CI:52|ACCID:14]
  658. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(module_name=pbx)
  659. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(module_name=pbx)
  660. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [module_name]=[pbx]
  661. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(original_did_number=1080200)
  662. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(original_did_number=1080200)
  663. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [original_did_number]=[1080200]
  664. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_flag=true)
  665. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_flag=true)
  666. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_flag]=[true]
  667. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type})
  668. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_call_type=12)
  669. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_call_type]=[12]
  670. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] set(no_answer_number=${extensions})
  671. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 set(no_answer_number=7065545454444#)
  672. span style="color: goldenrod; font-weight: bold;"> 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_dptools.c:1685 SET sofia/default/8700847196@13.232.246.166 [no_answer_number]=[7065545454444#]
  673. span style="color: cornflowerblue; font-weight: bold;"> 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_core_session.c:3095 Execute [depth=1] transfer(16 XML default)
  674. EXECUTE [depth=1] sofia/default/8700847196@13.232.246.166 transfer(16 XML default)
  675. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_ivr.c:2289 (sofia/default/8700847196@13.232.246.166) State Change CS_EXECUTE -> CS_ROUTING
  676. 2023-09-16 12:18:37.249434 97.67% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/8700847196@13.232.246.166 to XML[16@default]
  677. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8700847196@13.232.246.166) State EXECUTE going to sleep
  678. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_ROUTING (Cur 1 Tot 89)
  679. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8700847196@13.232.246.166) State ROUTING
  680. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
  681. 2023-09-16 12:18:37.249434 97.67% [DEBUG] mod_sofia.c:158 sofia/default/8700847196@13.232.246.166 SOFIA ROUTING
  682. 2023-09-16 12:18:37.249434 97.67% [DEBUG] switch_core_state_machine.c:230 sofia/default/8700847196@13.232.246.166 Standard ROUTING
  683. 2023-09-16 12:18:37.249434 97.67% [INFO] mod_dialplan_xml.c:639 Processing 8700847196 <8700847196>->16 in context default
  684. 2023-09-16 12:18:37.269425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  685. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  686. 2023-09-16 12:18:37.269425 97.67% [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')
  687. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  688. 2023-09-16 12:18:37.269425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  689. 2023-09-16 12:18:37.269425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 16
  690. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '16' limit 1
  691. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '16' AND status=0 limit 1
  692. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '16' and status=0 LIMIT 1
  693. 2023-09-16 12:18:37.269425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERgw+ClusterServer
  694. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  695. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = '78.47.101.152' limit 1
  696. 2023-09-16 12:18:37.269425 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  697. 2023-09-16 12:18:37.269425 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : "8700847196" / 8700847196
  698. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number
  699. 2023-09-16 12:18:37.269425 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 16 AND status=0 limit 1
  700. 2023-09-16 12:18:37.289455 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="16" LIMIT 1
  701. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="16" LIMIT 1
  702. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  703. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  704. 2023-09-16 12:18:37.289455 97.67% [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="16"  AND domains.domain="78.47.101.152" limit 1
  705. 2023-09-16 12:18:37.289455 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  706. 2023-09-16 12:18:37.289455 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 13.232.246.166
  707. 2023-09-16 12:18:37.289455 97.67% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9810050033]
  708. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =16
  709. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "9810050033" OR id = "9810050033") AND deleted = 0 limit 1
  710. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^16.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 10 limit 1
  711. 2023-09-16 12:18:37.289455 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="16" AND (accountid = 0 OR status = 1) LIMIT 1
  712. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ no_answer_did_number :1080200
  713. 2023-09-16 12:18:37.309439 97.67% [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,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  714. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1080200" LIMIT 1
  715. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  716. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  717. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID12] Query :SELECT call_type,extensions from inbound_routes where accountid ="16" and did_id ="6" and number ="8700847196" and status = '0' LIMIT 1
  718. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ accountid :16
  719. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "16" OR number = "16") AND deleted = 0 limit 1
  720. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^16.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 16 limit 1
  721. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :16
  722. 2023-09-16 12:18:37.309439 97.67% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 16 limit 1
  723. 2023-09-16 12:18:37.309439 97.67% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainclusterguibeta3.astppbilling.org
  724. 2023-09-16 12:18:37.309439 97.67% [ERR] mod_lua.cpp:202 .../local/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:2292: attempt to concatenate local 'act_number' (a nil value)
  725. stack traceback:
  726.         .../local/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:2292: in function 'get_accounts_info_for_call_limit'
  727.         .../local/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:45: in function 'did_pbx_info'
  728.         .../local/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:2113: in function 'ringgroup_no_answer_forward'
  729.         ./astpp/scripts/astpp.dialplan.lua:377: in main chunk
  730.         [C]: in function 'dofile'
  731.         ./astpp/astpp_deb9.lua:138: in main chunk
  732. 2023-09-16 12:18:37.309439 97.67% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  733. 2023-09-16 12:18:37.329422 97.67% [WARNING] mod_dialplan_xml.c:669 Context default not found
  734. 2023-09-16 12:18:37.329422 97.67% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  735. 2023-09-16 12:18:37.329422 97.67% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/8700847196@13.232.246.166 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  736. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8700847196@13.232.246.166) State ROUTING going to sleep
  737. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_HANGUP (Cur 1 Tot 89)
  738. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8700847196@13.232.246.166) Callstate Change RINGING -> HANGUP
  739. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8700847196@13.232.246.166) State HANGUP
  740. 2023-09-16 12:18:37.329422 97.67% [DEBUG] mod_sofia.c:468 Channel sofia/default/8700847196@13.232.246.166 hanging up, cause: NO_ROUTE_DESTINATION
  741. 2023-09-16 12:18:37.329422 97.67% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  742. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:59 sofia/default/8700847196@13.232.246.166 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  743. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8700847196@13.232.246.166) State HANGUP going to sleep
  744. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8700847196@13.232.246.166) State Change CS_HANGUP -> CS_REPORTING
  745. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8700847196@13.232.246.166) Running State Change CS_REPORTING (Cur 1 Tot 89)
  746. 2023-09-16 12:18:37.329422 97.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8700847196@13.232.246.166) State REPORTING
  747. 2023-09-16 12:18:37.329422 97.67% [INFO] mod_json_cdr.c:271 Process [932098c6-dc56-443d-8a8a-6de018c74dae.cdr.json]
  748. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:168 sofia/default/8700847196@13.232.246.166 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  749. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8700847196@13.232.246.166) State REPORTING going to sleep
  750. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:607 (sofia/default/8700847196@13.232.246.166) State Change CS_REPORTING -> CS_DESTROY
  751. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_session.c:1753 Session 89 (sofia/default/8700847196@13.232.246.166) Locked, Waiting on external entities
  752. 2023-09-16 12:18:37.389430 97.67% [NOTICE] switch_core_session.c:1771 Session 89 (sofia/default/8700847196@13.232.246.166) Ended
  753. 2023-09-16 12:18:37.389430 97.67% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/8700847196@13.232.246.166 [CS_DESTROY]
  754. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:735 (sofia/default/8700847196@13.232.246.166) Running State Change CS_DESTROY (Cur 0 Tot 89)
  755. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8700847196@13.232.246.166) State DESTROY
  756. 2023-09-16 12:18:37.389430 97.67% [DEBUG] mod_sofia.c:379 sofia/default/8700847196@13.232.246.166 SOFIA DESTROY
  757. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:175 sofia/default/8700847196@13.232.246.166 Standard DESTROY
  758. 2023-09-16 12:18:37.389430 97.67% [DEBUG] switch_core_state_machine.c:745 (sofia/default/8700847196@13.232.246.166) State DESTROY going to sleep
  759. freeswitch@FS1ClusterQA>
  760. freeswitch@FS1ClusterQA>
  761. freeswitch@FS1ClusterQA>

Reply to "Time Condition error issue "