FreeSWITCH Pastebin

CDRS entry issue in when made time condition call

From Yash, 1 Year ago, written in FreeSWITCH.
- go back
URL https://pastebin.freeswitch.org/view/5855882d
Embed
Viewing differences between and CDRS entry issue in when made time condition call
  1. span style="color: cornflowerblue; font-weight: bold;"> 2023-06-16 06:07:59.014224 42.23% [NOTICE] switch_channel.c:1123 New Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 [afd7d3e7-1b90-4ab0-a54b-cf8c033578af]
  2. 2023-06-16 06:07:59.014224 42.23% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_NEW (Cur 1 Tot 339)
  3. 2023-06-16 06:07:59.014224 42.23% [INFO] sofia.c:10453 sofia/default/7870463271@alpha3.astppbilling.org:5076 receiving invite from 103.240.35.46:51948 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: M2RkMGJlNTNmY2I0YWYzYzZhYzU4ZmE5ZTUxMWEzNjI.
  4. 2023-06-16 06:07:59.014224 42.23% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 103.240.35.46:0.
  5. 2023-06-16 06:07:59.014224 42.23% [WARNING] sofia_reg.c:1846 SIP auth challenge (INVITE) on sofia profile 'default' for [9120201@alpha3.astppbilling.org] from ip 103.240.35.46
  6. 2023-06-16 06:07:59.014224 42.23% [DEBUG] switch_core_state_machine.c:600 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State NEW
  7. 2023-06-16 06:07:59.014224 42.23% [DEBUG] sofia.c:2419 detaching session afd7d3e7-1b90-4ab0-a54b-cf8c033578af
  8. 2023-06-16 06:07:59.654229 42.53% [DEBUG] sofia.c:2532 Re-attaching to session afd7d3e7-1b90-4ab0-a54b-cf8c033578af
  9. 2023-06-16 06:07:59.674234 42.53% [INFO] sofia.c:10453 sofia/default/7870463271@alpha3.astppbilling.org:5076 receiving invite from 103.240.35.46:51948 version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit call-id: M2RkMGJlNTNmY2I0YWYzYzZhYzU4ZmE5ZTUxMWEzNjI.
  10. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:10547 verifying acl "default" for ip/port 103.240.35.46:0.
  11. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:11668 Setting NAT mode based on via received
  12. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [received][100]
  13. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:7497 Remote SDP:
  14. v=0
  15. o=Z 0 0 IN IP4 103.240.35.46
  16. s=Z
  17. c=IN IP4 103.240.35.46
  18. t=0 0
  19. m=audio 8000 RTP/AVP 3 110 8 0 98 101
  20. a=rtpmap:110 speex/8000
  21. a=rtpmap:98 iLBC/8000
  22. a=fmtp:98 mode=20
  23. a=rtpmap:101 telephone-event/8000
  24. a=fmtp:101 0-15
  25.  
  26. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  27. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  28. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1]
  29. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
  30. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
  31. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [speex:110:8000:20:0:1]/[G729:18:8000:20:8000:1]
  32. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  33. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  34. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  35. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  36. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  37. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  38. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  39. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  40. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
  41. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
  42. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [iLBC:98:8000:30:0:1]/[G729:18:8000:20:8000:1]
  43. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 101@8000
  44. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:3750 Set Codec sofia/default/7870463271@alpha3.astppbilling.org:5076 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  45. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_codec.c:111 sofia/default/7870463271@alpha3.astppbilling.org:5076 Original read codec set to PCMA:8
  46. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000
  47. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_media.c:5850 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101 recv payload to 101
  48. 2023-06-16 06:07:59.674234 42.53% [DEBUG] sofia.c:7921 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_NEW -> CS_INIT
  49. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_INIT (Cur 1 Tot 339)
  50. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State INIT
  51. 2023-06-16 06:07:59.674234 42.53% [DEBUG] mod_sofia.c:97 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA INIT
  52. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:40 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard INIT
  53. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:48 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_INIT -> CS_ROUTING
  54. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State INIT going to sleep
  55. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 339)
  56. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_channel.c:2380 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change DOWN -> RINGING
  57. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING
  58. 2023-06-16 06:07:59.674234 42.53% [DEBUG] mod_sofia.c:158 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA ROUTING
  59. 2023-06-16 06:07:59.674234 42.53% [DEBUG] switch_core_state_machine.c:230 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard ROUTING
  60. 2023-06-16 06:07:59.674234 42.53% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->9120201 in context default
  61. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  62. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  63. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  64. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  65. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  66. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 9120201
  67. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9120201' limit 1
  68. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  69. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9120201' and status=0 LIMIT 1
  70. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271
  71. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  72. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1
  73. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '170' and username = '9120201' limit 1
  74. 2023-06-16 06:07:59.694239 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  75. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 7870463271 / 23222
  76. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1
  77. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 912020 AND status=0 limit 1
  78. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  79. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  80. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  81. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  82. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  83. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  84. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  85. 2023-06-16 06:07:59.694239 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271]
  86. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9120201
  87. 2023-06-16 06:07:59.694239 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1
  88. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  89. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
  90. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1
  91. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  92. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 170
  93. 2023-06-16 06:07:59.734244 42.53% [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 = '^9120201.*' OR patterns = '^912020.*' OR patterns = '^91202.*' OR patterns = '^9120.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 170 ORDER BY LENGTH(PKGPTR.patterns) DESC
  94. 2023-06-16 06:07:59.734244 42.53% [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 ="9120201" AND A.accountid = '170' limit 1
  95. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9120201
  96. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  97. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  98. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  99. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  100. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  101. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  102. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  103. 2023-06-16 06:07:59.734244 42.53% [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 = '9120201' OR number = '912020' OR number = '91202' OR number = '9120' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '9120201*' OR number = '912020*' OR number = '91202*' OR number = '9120*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '23222' OR number = '2322' OR number = '232' OR number = '23' OR number = '2' OR number ='--') OR (number = '23222*' OR number = '2322*' OR number = '232*' OR number = '23*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  104. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  105. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9120201' OR routing_prefix = '912020' OR routing_prefix = '91202' OR routing_prefix = '9120' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  106. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  107. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 170
  108. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7870463271
  109. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  110. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3091.8867
  111. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  112. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 29
  113. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  114. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  115. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
  116. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::29
  117. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  118. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  119. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  120. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  121. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  122. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  123. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 55
  124. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  125. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  126. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  127. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 9120201
  128. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
  129. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 170
  130. 2023-06-16 06:07:59.734244 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  131. 2023-06-16 06:07:59.734244 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  132. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3091.8867 balance Accountid 170 !!!
  133. 2023-06-16 06:07:59.774233 42.53% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  134. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  135. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  136. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  137. 2023-06-16 06:07:59.774233 42.53% [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 = 170 AND status=0 LIMIT 1
  138. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1
  139. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  140. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:170
  141. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:170
  142. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 170
  143. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1
  144. 2023-06-16 06:07:59.774233 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha3.astppbilling.org
  145. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1
  146. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1
  147. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
  148. span style="color: green; font-weight: bold;"> 2023-06-16 06:07:59.774233 42.53% [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":"347","no_answer_call_type":"11","priority":"1"}]
  149. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
  150. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "347" limit 1
  151. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1
  152. 2023-06-16 06:07:59.774233 42.53% [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"
  153. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  154. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  155. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  156. 2023-06-16 06:07:59.774233 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  157. 2023-06-16 06:07:59.774233 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing  WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "1" AND accounts.status = 0
  158. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1
  159. 2023-06-16 06:07:59.794231 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha3.astppbilling.org
  160. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  161. 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1
  162. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1
  163. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  164. <document type="freeswitch/xml">
  165. <section name="dialplan" description="ASTPP Dialplan">
  166. <context name="default">
  167. <extension name="Y test timecondi" continue="true">
  168. <condition break="never">
  169. <action application="set" data="timezone=Europe/Sarajevo" inline="true"/>
  170. </condition>
  171. <condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
  172. <action application="set" data="office_status=open" inline="true"/>
  173. <action application="set" data="extensions=5575942767" inline="true"/>
  174. <action application="set" data="no_answer_did_number=9120201" inline="true"/>
  175. <action application="set" data="no_answer_call_type=11" inline="true"/>
  176. </condition>
  177. </extension>
  178. <extension name="tod route, x9120201">
  179. <condition field="destination_number" expression="^(\+?)?(9120201)$">
  180. <action application="execute_extension" data="9120201_${office_status}"/>
  181. </condition>
  182. </extension>
  183. <extension name="office is open">
  184. <condition field="destination_number" expression="^(\+?)?(9120201_open)$">
  185. <action application="set" data="domain_name=alpha3.astppbilling.org"/>
  186. <action application="set" data="set_extensions=${extensions}"/>
  187. <action application="set" data="no_answer_flag=true"/>
  188. <action application="set" data="no_answer_did_number=9120201" inline="true"/>
  189. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
  190. <action application="set" data="no_answer_number=${extensions}" />
  191. <action application="transfer" data="170 XML default"/>
  192. </condition>
  193. </extension>
  194. <extension name="9120201">
  195. <condition field="destination_number" expression="9120201">
  196. <action application="set" data="effective_destination_number=9120201"/>
  197. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  198. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  199. <action application="set" data="notify_flag=0"/>
  200. <action application="set" data="notify_credit_limit=5.00000"/>
  201. <action application="set" data="type=0"/>
  202. <action application="set" data="callstart=2023-06-16 04:07:59"/>
  203. <action application="set" data="hangup_after_bridge=true"/>
  204. <action application="set" data="continue_on_fail=TRUE"/>
  205. <action application="set" data="account_id=170"/>
  206. <action application="set" data="parent_id=0"/>
  207. <action application="set" data="entity_id=0"/>
  208. <action application="set" data="call_processed=internal"/>
  209. <action application="set" data="call_direction=inbound"/>
  210. <action application="set" data="accountname=default"/>
  211. <action application="set" data="filename1=astpp.pbx.lua"/>
  212. <action application="sleep" data="500"/>
  213. <action application="playback" data="/usr/local/freeswitch/sounds/en/us/callie/astpp-this-call-will-last.wav"/>
  214. <action application="say" data="en NUMBER PRONOUNCED 100"/>
  215. <action application="playback" data="/usr/local/freeswitch/sounds/en/us/callie/astpp-minute.wav"/>
  216. <action application="set" data="ringback=%(2000,4000,440.0,480.0)"/>
  217. <action application="set" data="origination_rates_did=ID:55|CODE:^9120201.*|DESTINATION:9120201|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:170"/>
  218. <action application="set" data="origination_rates=0"/>
  219. <action application="set" data="original_caller_id_name=7870463271"/>
  220. <action application="set" data="original_caller_id_number=23222"/>
  221. <action application="set" data="effective_caller_id_name=7870463271"/>
  222. <action application="set" data="effective_caller_id_number=23222"/>
  223. <action application="set" data="receiver_accid=170"/>
  224. <action application="set" data="did_id=55"/>
  225. <action application="set" data="transfer_call_type=4"/>
  226. <action application="set" data="transfer_extensions="/>
  227. <action application="set" data="busy_status=1"/>
  228. <action application="set" data="no_answer_status=1"/>
  229. <action application="set" data="always_status=1"/>
  230. <action application="set" data="transfer_status=1"/>
  231. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  232. <action application="set" data="variable_sip_network_ip=103.240.35.46"/>
  233. <action application="set" data="variable_sip_network_port=51948"/>
  234. <action application="export" data="domain_name=alpha3.astppbilling.org"/>
  235. <action application="export" data="sip_to_host=alpha3.astppbilling.org"/>
  236. <action application="export" data="presence_data=x|||Yash(7870463271)|||^9120201.* // 9120201 // 0.00000|||||||||DID|||103.240.35.46"/>
  237. <action application="export" data="call_type=11"/>
  238. </condition>
  239. </extension>
  240. </context>
  241. </section>
  242. </document>
  243. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->Y test timecondi] continue=true
  244. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Absolute Condition [Y test timecondi]
  245. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(timezone=Europe/Sarajevo) INLINE
  246. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(timezone=Europe/Sarajevo)
  247. 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [timezone]=[Europe/Sarajevo]
  248. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Date/Time Match (PASS) [Y test timecondi] break=never
  249. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(office_status=open) INLINE
  250. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(office_status=open)
  251. 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [office_status]=[open]
  252. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(extensions=5575942767) INLINE
  253. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(extensions=5575942767)
  254. 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [extensions]=[5575942767]
  255. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_did_number=9120201) INLINE
  256. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_did_number=9120201)
  257. 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_did_number]=[9120201]
  258. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_call_type=11) INLINE
  259. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=11)
  260. 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[11]
  261. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->tod route, x9120201] continue=false
  262. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (PASS) [tod route, x9120201] destination_number(9120201) =~ /^(\+?)?(9120201)$/ break=on-false
  263. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action execute_extension(9120201_${office_status})
  264. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:281 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE
  265. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING going to sleep
  266. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 1 Tot 339)
  267. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE
  268. 2023-06-16 06:07:59.794231 42.53% [DEBUG] mod_sofia.c:213 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA EXECUTE
  269. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_core_state_machine.c:323 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard EXECUTE
  270. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 execute_extension(9120201_open)
  271. 2023-06-16 06:07:59.794231 42.53% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->9120201_open in context default
  272. 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  273. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  274. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  275. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  276. 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  277. 2023-06-16 06:07:59.794231 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 9120201
  278. 2023-06-16 06:07:59.794231 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '9120201' limit 1
  279. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  280. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '9120201' and status=0 LIMIT 1
  281. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271
  282. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  283. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1
  284. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '170' and username = '9120201' limit 1
  285. 2023-06-16 06:07:59.814226 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  286. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 7870463271 / 23222
  287. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 1
  288. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 912020 AND status=0 limit 1
  289. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  290. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  291. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  292. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  293. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  294. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  295. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  296. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271]
  297. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =9120201
  298. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1
  299. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  300. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
  301. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1
  302. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  303. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 170
  304. 2023-06-16 06:07:59.814226 42.53% [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 = '^9120201.*' OR patterns = '^912020.*' OR patterns = '^91202.*' OR patterns = '^9120.*' OR patterns = '^912.*' OR patterns = '^91.*' OR patterns = '^9.*' OR patterns ='--') AND accountid = 170 ORDER BY LENGTH(PKGPTR.patterns) DESC
  305. 2023-06-16 06:07:59.814226 42.53% [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 ="9120201" AND A.accountid = '170' limit 1
  306. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 9120201
  307. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  308. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  309. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  310. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  311. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  312. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  313. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  314. 2023-06-16 06:07:59.814226 42.53% [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 = '9120201' OR number = '912020' OR number = '91202' OR number = '9120' OR number = '912' OR number = '91' OR number = '9' OR number ='--') OR (number = '9120201*' OR number = '912020*' OR number = '91202*' OR number = '9120*' OR number = '912*' OR number = '91*' OR number = '9*' OR number ='--') OR (number = '23222' OR number = '2322' OR number = '232' OR number = '23' OR number = '2' OR number ='--') OR (number = '23222*' OR number = '2322*' OR number = '232*' OR number = '23*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  315. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  316. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '9120201' OR routing_prefix = '912020' OR routing_prefix = '91202' OR routing_prefix = '9120' OR routing_prefix = '912' OR routing_prefix = '91' OR routing_prefix = '9' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  317. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  318. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 170
  319. 2023-06-16 06:07:59.814226 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 7870463271
  320. 2023-06-16 06:07:59.814226 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  321. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 3091.8867
  322. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  323. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 29
  324. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  325. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  326. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
  327. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::29
  328. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  329. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  330. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  331. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  332. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  333. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  334. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 55
  335. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  336. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  337. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  338. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 9120201
  339. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
  340. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 170
  341. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  342. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  343. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your3091.8867 balance Accountid 170 !!!
  344. 2023-06-16 06:07:59.834229 42.53% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  345. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  346. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  347. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  348. 2023-06-16 06:07:59.834229 42.53% [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 = 170 AND status=0 LIMIT 1
  349. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1
  350. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =170
  351. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:170
  352. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:170
  353. 2023-06-16 06:07:59.834229 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 170
  354. 2023-06-16 06:07:59.834229 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1
  355. 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : alpha3.astppbilling.org
  356. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 1
  357. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1
  358. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
  359. span style="color: green; font-weight: bold;"> 2023-06-16 06:07:59.854238 42.53% [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":"347","no_answer_call_type":"11","priority":"1"}]
  360. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
  361. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Sipdevice Form Id] Query :SELECT username from sip_devices where id = "347" limit 1
  362. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '49' LIMIT 1
  363. 2023-06-16 06:07:59.854238 42.53% [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"
  364. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  365. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  366. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  367. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  368. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing  WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "1" AND accounts.status = 0
  369. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1
  370. 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : alpha3.astppbilling.org
  371. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  372. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 1
  373. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '1' and status =0 LIMIT 1
  374. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  375. <document type="freeswitch/xml">
  376. <section name="dialplan" description="ASTPP Dialplan">
  377. <context name="default">
  378. <extension name="Y test timecondi" continue="true">
  379. <condition break="never">
  380. <action application="set" data="timezone=Europe/Sarajevo" inline="true"/>
  381. </condition>
  382. <condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2023-2023"  break="never">
  383. <action application="set" data="office_status=open" inline="true"/>
  384. <action application="set" data="extensions=5575942767" inline="true"/>
  385. <action application="set" data="no_answer_did_number=9120201" inline="true"/>
  386. <action application="set" data="no_answer_call_type=11" inline="true"/>
  387. </condition>
  388. </extension>
  389. <extension name="tod route, x9120201">
  390. <condition field="destination_number" expression="^(\+?)?(9120201)$">
  391. <action application="execute_extension" data="9120201_${office_status}"/>
  392. </condition>
  393. </extension>
  394. <extension name="office is open">
  395. <condition field="destination_number" expression="^(\+?)?(9120201_open)$">
  396. <action application="set" data="domain_name=alpha3.astppbilling.org"/>
  397. <action application="set" data="set_extensions=${extensions}"/>
  398. <action application="set" data="no_answer_flag=true"/>
  399. <action application="set" data="no_answer_did_number=9120201" inline="true"/>
  400. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
  401. <action application="set" data="no_answer_number=${extensions}" />
  402. <action application="transfer" data="170 XML default"/>
  403. </condition>
  404. </extension>
  405. <extension name="9120201">
  406. <condition field="destination_number" expression="9120201">
  407. <action application="set" data="effective_destination_number=9120201"/>
  408. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  409. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  410. <action application="set" data="notify_flag=0"/>
  411. <action application="set" data="notify_credit_limit=5.00000"/>
  412. <action application="set" data="type=0"/>
  413. <action application="set" data="callstart=2023-06-16 04:07:59"/>
  414. <action application="set" data="hangup_after_bridge=true"/>
  415. <action application="set" data="continue_on_fail=TRUE"/>
  416. <action application="set" data="account_id=170"/>
  417. <action application="set" data="parent_id=0"/>
  418. <action application="set" data="entity_id=0"/>
  419. <action application="set" data="call_processed=internal"/>
  420. <action application="set" data="call_direction=inbound"/>
  421. <action application="set" data="accountname=default"/>
  422. <action application="set" data="filename1=astpp.pbx.lua"/>
  423. <action application="sleep" data="500"/>
  424. <action application="playback" data="/usr/local/freeswitch/sounds/en/us/callie/astpp-this-call-will-last.wav"/>
  425. <action application="say" data="en NUMBER PRONOUNCED 100"/>
  426. <action application="playback" data="/usr/local/freeswitch/sounds/en/us/callie/astpp-minute.wav"/>
  427. <action application="set" data="ringback=%(2000,4000,440.0,480.0)"/>
  428. <action application="set" data="origination_rates_did=ID:55|CODE:^9120201.*|DESTINATION:9120201|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:170"/>
  429. <action application="set" data="origination_rates=0"/>
  430. <action application="set" data="original_caller_id_name=7870463271"/>
  431. <action application="set" data="original_caller_id_number=23222"/>
  432. <action application="set" data="effective_caller_id_name=7870463271"/>
  433. <action application="set" data="effective_caller_id_number=23222"/>
  434. <action application="set" data="receiver_accid=170"/>
  435. <action application="set" data="did_id=55"/>
  436. <action application="set" data="transfer_call_type=4"/>
  437. <action application="set" data="transfer_extensions="/>
  438. <action application="set" data="busy_status=1"/>
  439. <action application="set" data="no_answer_status=1"/>
  440. <action application="set" data="always_status=1"/>
  441. <action application="set" data="transfer_status=1"/>
  442. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  443. <action application="set" data="variable_sip_network_ip=103.240.35.46"/>
  444. <action application="set" data="variable_sip_network_port=51948"/>
  445. <action application="export" data="domain_name=alpha3.astppbilling.org"/>
  446. <action application="export" data="sip_to_host=alpha3.astppbilling.org"/>
  447. <action application="export" data="presence_data=x|||Yash(7870463271)|||^9120201.* // 9120201 // 0.00000|||||||||DID|||103.240.35.46"/>
  448. <action application="export" data="call_type=11"/>
  449. </condition>
  450. </extension>
  451. </context>
  452. </section>
  453. </document>
  454. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->Y test timecondi] continue=true
  455. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Absolute Condition [Y test timecondi]
  456. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(timezone=Europe/Sarajevo) INLINE
  457. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(timezone=Europe/Sarajevo)
  458. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [timezone]=[Europe/Sarajevo]
  459. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Date/Time Match (PASS) [Y test timecondi] break=never
  460. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(office_status=open) INLINE
  461. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(office_status=open)
  462. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [office_status]=[open]
  463. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(extensions=5575942767) INLINE
  464. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(extensions=5575942767)
  465. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [extensions]=[5575942767]
  466. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_did_number=9120201) INLINE
  467. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_did_number=9120201)
  468. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_did_number]=[9120201]
  469. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_call_type=11) INLINE
  470. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=11)
  471. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[11]
  472. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->tod route, x9120201] continue=false
  473. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (FAIL) [tod route, x9120201] destination_number(9120201_open) =~ /^(\+?)?(9120201)$/ break=on-false
  474. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->office is open] continue=false
  475. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (PASS) [office is open] destination_number(9120201_open) =~ /^(\+?)?(9120201_open)$/ break=on-false
  476. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(domain_name=alpha3.astppbilling.org)
  477. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(set_extensions=${extensions})
  478. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_flag=true)
  479. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_did_number=9120201) INLINE
  480. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_did_number=9120201)
  481. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_did_number]=[9120201]
  482. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_call_type=${no_answer_call_type})
  483. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_number=${extensions})
  484. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action transfer(170 XML default)
  485. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(domain_name=alpha3.astppbilling.org)
  486. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(domain_name=alpha3.astppbilling.org)
  487. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [domain_name]=[alpha3.astppbilling.org]
  488. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(set_extensions=${extensions})
  489. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(set_extensions=5575942767)
  490. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [set_extensions]=[5575942767]
  491. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(no_answer_flag=true)
  492. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_flag=true)
  493. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_flag]=[true]
  494. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type})
  495. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_call_type=11)
  496. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_call_type]=[11]
  497. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] set(no_answer_number=${extensions})
  498. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_number=5575942767)
  499. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_number]=[5575942767]
  500. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_core_session.c:3085 Execute [depth=1] transfer(170 XML default)
  501. EXECUTE [depth=1] sofia/default/7870463271@alpha3.astppbilling.org:5076 transfer(170 XML default)
  502. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_ivr.c:2288 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_EXECUTE -> CS_ROUTING
  503. 2023-06-16 06:07:59.854238 42.53% [NOTICE] switch_ivr.c:2295 Transfer sofia/default/7870463271@alpha3.astppbilling.org:5076 to XML[170@default]
  504. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE going to sleep
  505. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_ROUTING (Cur 1 Tot 339)
  506. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING
  507. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
  508. 2023-06-16 06:07:59.854238 42.53% [DEBUG] mod_sofia.c:158 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA ROUTING
  509. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_core_state_machine.c:230 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard ROUTING
  510. 2023-06-16 06:07:59.854238 42.53% [INFO] mod_dialplan_xml.c:639 Processing 7870463271 <7870463271>->170 in context default
  511. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  512. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  513. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  514. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  515. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  516. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 170
  517. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '170' limit 1
  518. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  519. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '170' and status=0 LIMIT 1
  520. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER7870463271
  521. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  522. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'alpha3.astppbilling.org' limit 1
  523. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '170' and username = '170' limit 1
  524. 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  525. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 7870463271 / 23222
  526. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number
  527. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 170 AND status=0 limit 1
  528. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  529. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="170"  AND domains.domain="alpha3.astppbilling.org" limit 1
  530. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  531. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 7870463271]
  532. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =170
  533. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7870463271" AND deleted = 0 limit 1
  534. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^170.*' OR blocked_patterns = '^17.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 170 limit 1
  535. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
  536. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ no_answer_did_number :9120201
  537. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  538. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="9120201" LIMIT 1
  539. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  540. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] ringgroup_no_answer_forward _ accountid :170
  541. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "170" AND deleted = 0 limit 1
  542. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^170.*' OR blocked_patterns = '^17.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 170 limit 1
  543. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :170
  544. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 170 limit 1
  545. 2023-06-16 06:07:59.854238 42.53% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domainalpha3.astppbilling.org
  546. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 11
  547. 2023-06-16 06:07:59.854238 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Time Conditions
  548. 2023-06-16 06:07:59.854238 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_extensions_forwarding] Query :select sip_devices.id,sip_device_routing.call_forwarding_flag,sip_device_routing.call_forwarding_destination from sip_devices JOIN sip_device_routing ON sip_devices.id = sip_device_routing.sip_device_id where sip_devices.username = "5575942767"
  549. 2023-06-16 06:07:59.894230 42.53% [INFO] switch_cpp.cpp:1465 [ASTPP] [SIP_CODEC5]
  550. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="5575942767"  AND domains.domain="alpha3.astppbilling.org" limit 1
  551. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer_attended' limit 1
  552. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_action = 'call_transfer' limit 1
  553. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  554. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  555. <document type="freeswitch/xml">
  556. <section name="dialplan" description="ASTPP Dialplan">
  557. <context name="default">
  558. <extension name="170">
  559. <condition field="destination_number" expression="170">
  560. <action application="export" data="did_user_domain=alpha3.astppbilling.org"/>
  561. <action application="set" data="continue_on_fail=TRUE"/>
  562. <action application="set" data="ignore_early_media=true"/>
  563. <action application="set" data="no_answer_flag=false"/>
  564. <action application="set" data="did_calltype=11"/>
  565. <action application="set" data="did_extensions=5575942767"/>
  566. <action application="set" data="daily_call_credit_limit=0.00000"/>
  567. <action application="set" data="monthly_call_credit_limit=0.00000"/>
  568. <action application="set" data="daily_call_used_limit=0.00000"/>
  569. <action application="set" data="monthly_call_used_limit=0.00000"/>
  570. <action application="set" data="sip_destination_number=5575942767"/>
  571. <action application="set" data="sip_to_host=alpha3.astppbilling.org"/>
  572. <action application="set" data="user_domain=alpha3.astppbilling.org"/>
  573. <action application="db" data="insert/pickup_any_group_${callgroup}/5575942767/${uuid}"/>
  574. <action application="set" data="dialed_extension=transfer_call"/>
  575. <action application="export" data="dialed_extension=transfer_call"/>
  576. <action application="bind_meta_app" data="2 b s execute_extension::transfer_call_2 XML default"/>
  577. <action application="bind_meta_app" data="3 b s execute_extension::transfer_call_3 XML default"/>
  578. <action application="export" data="ring_group_transfer=true"/>
  579. <action application="bridge" data="user/5575942767@alpha3.astppbilling.org"/>
  580. <action application="lua" data="astpp/lib/pbx/astpp-sipdevice-routing.lua"/>
  581. </condition>
  582. </extension>
  583. </context>
  584. </section>
  585. </document>
  586. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 parsing [default->170] continue=false
  587. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Regex (PASS) [170] destination_number(170) =~ /170/ break=on-false
  588. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action export(did_user_domain=alpha3.astppbilling.org)
  589. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(continue_on_fail=TRUE)
  590. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(ignore_early_media=true)
  591. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(no_answer_flag=false)
  592. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(did_calltype=11)
  593. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(did_extensions=5575942767)
  594. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(daily_call_credit_limit=0.00000)
  595. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(monthly_call_credit_limit=0.00000)
  596. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(daily_call_used_limit=0.00000)
  597. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(monthly_call_used_limit=0.00000)
  598. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(sip_destination_number=5575942767)
  599. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(sip_to_host=alpha3.astppbilling.org)
  600. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(user_domain=alpha3.astppbilling.org)
  601. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action db(insert/pickup_any_group_${callgroup}/5575942767/${uuid})
  602. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action set(dialed_extension=transfer_call)
  603. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action export(dialed_extension=transfer_call)
  604. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
  605. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
  606. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action export(ring_group_transfer=true)
  607. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action bridge(user/5575942767@alpha3.astppbilling.org)
  608. Dialplan: sofia/default/7870463271@alpha3.astppbilling.org:5076 Action lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
  609. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:281 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_ROUTING -> CS_EXECUTE
  610. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State ROUTING going to sleep
  611. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_EXECUTE (Cur 1 Tot 339)
  612. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE
  613. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:213 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA EXECUTE
  614. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:323 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard EXECUTE
  615. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 export(did_user_domain=alpha3.astppbilling.org)
  616. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [did_user_domain]=[alpha3.astppbilling.org]
  617. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(continue_on_fail=TRUE)
  618. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [continue_on_fail]=[TRUE]
  619. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(ignore_early_media=true)
  620. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [ignore_early_media]=[true]
  621. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(no_answer_flag=false)
  622. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [no_answer_flag]=[false]
  623. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(did_calltype=11)
  624. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [did_calltype]=[11]
  625. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(did_extensions=5575942767)
  626. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [did_extensions]=[5575942767]
  627. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(daily_call_credit_limit=0.00000)
  628. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [daily_call_credit_limit]=[0.00000]
  629. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(monthly_call_credit_limit=0.00000)
  630. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [monthly_call_credit_limit]=[0.00000]
  631. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(daily_call_used_limit=0.00000)
  632. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [daily_call_used_limit]=[0.00000]
  633. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(monthly_call_used_limit=0.00000)
  634. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [monthly_call_used_limit]=[0.00000]
  635. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(sip_destination_number=5575942767)
  636. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [sip_destination_number]=[5575942767]
  637. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(sip_to_host=alpha3.astppbilling.org)
  638. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [sip_to_host]=[alpha3.astppbilling.org]
  639. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(user_domain=alpha3.astppbilling.org)
  640. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [user_domain]=[alpha3.astppbilling.org]
  641. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 db(insert/pickup_any_group_/5575942767/afd7d3e7-1b90-4ab0-a54b-cf8c033578af)
  642. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 set(dialed_extension=transfer_call)
  643. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_dptools.c:1673 SET sofia/default/7870463271@alpha3.astppbilling.org:5076 [dialed_extension]=[transfer_call]
  644. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 export(dialed_extension=transfer_call)
  645. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [dialed_extension]=[transfer_call]
  646. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
  647. 2023-06-16 06:07:59.894230 42.53% [INFO] switch_ivr_async.c:4780 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default
  648. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
  649. 2023-06-16 06:07:59.894230 42.53% [INFO] switch_ivr_async.c:4780 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default
  650. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 export(ring_group_transfer=true)
  651. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [ring_group_transfer]=[true]
  652. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 bridge(user/5575942767@alpha3.astppbilling.org)
  653. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [did_user_domain]=[alpha3.astppbilling.org] to event
  654. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
  655. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [ring_group_transfer]=[true] to event
  656. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_ivr_originate.c:2291 Parsing global variables
  657. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [did_user_domain]=[alpha3.astppbilling.org] to event
  658. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
  659. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_channel.c:1269 sofia/default/7870463271@alpha3.astppbilling.org:5076 EXPORTING[export_vars] [ring_group_transfer]=[true] to event
  660. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_ivr_originate.c:2291 Parsing global variables
  661. 2023-06-16 06:07:59.894230 42.53% [NOTICE] switch_channel.c:1123 New Channel sofia/default/5575942767@185.117.83.208:35080 [0d73261a-1319-4eb8-a388-348f777c776d]
  662. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:5117 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_NEW -> CS_INIT
  663. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_INIT (Cur 2 Tot 340)
  664. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/5575942767@185.117.83.208:35080) State INIT
  665. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:97 sofia/default/5575942767@185.117.83.208:35080 SOFIA INIT
  666. 2023-06-16 06:07:59.894230 42.53% [INFO] sofia_glue.c:1654 sofia/default/5575942767@185.117.83.208:35080 sending invite call-id: (null)
  667. 2023-06-16 06:07:59.894230 42.53% [DEBUG] sofia_glue.c:1657 sofia/default/5575942767@185.117.83.208:35080 sending invite version: 1.10.9-release git a615e85 2023-02-03 20:07:30Z 64bit
  668. Local SDP:
  669. v=0
  670. o=FreeSWITCH 1686864753 1686864754 IN IP4 95.217.238.195
  671. s=FreeSWITCH
  672. c=IN IP4 95.217.238.195
  673. t=0 0
  674. m=audio 23726 RTP/AVP 8 101
  675. a=rtpmap:8 PCMA/8000
  676. a=rtpmap:101 telephone-event/8000
  677. a=fmtp:101 0-15
  678. a=ptime:20
  679. a=sendrecv
  680.  
  681. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:40 sofia/default/5575942767@185.117.83.208:35080 Standard INIT
  682. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:48 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_INIT -> CS_ROUTING
  683. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:624 (sofia/default/5575942767@185.117.83.208:35080) State INIT going to sleep
  684. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_ROUTING (Cur 2 Tot 340)
  685. 2023-06-16 06:07:59.894230 42.53% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [calling][0]
  686. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/5575942767@185.117.83.208:35080) State ROUTING
  687. 2023-06-16 06:07:59.894230 42.53% [DEBUG] mod_sofia.c:158 sofia/default/5575942767@185.117.83.208:35080 SOFIA ROUTING
  688. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_ivr_originate.c:67 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  689. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:640 (sofia/default/5575942767@185.117.83.208:35080) State ROUTING going to sleep
  690. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 340)
  691. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:659 (sofia/default/5575942767@185.117.83.208:35080) State CONSUME_MEDIA
  692. 2023-06-16 06:07:59.894230 42.53% [DEBUG] switch_core_state_machine.c:659 (sofia/default/5575942767@185.117.83.208:35080) State CONSUME_MEDIA going to sleep
  693. 2023-06-16 06:08:03.754237 40.80% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [7543346407@alpha5.astppbilling.org] from ip 103.240.35.46
  694. 2023-06-16 06:08:04.394231 39.87% [WARNING] sofia_reg.c:3211 Can't find user [7543346407@alpha5.astppbilling.org] from 103.240.35.46
  695. You must define a domain called 'alpha5.astppbilling.org' in your directory and add a user with the id="7543346407" attribute
  696. and you must configure your device to use the proper domain in its authentication credentials.
  697. 2023-06-16 06:08:04.654244 39.87% [WARNING] sofia_reg.c:1846 SIP auth challenge (INVITE) on sofia profile 'default' for [7543346407@alpha5.astppbilling.org] from ip 103.240.35.46
  698. 2023-06-16 06:08:05.614227 38.90% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [5575942767@alpha3.astppbilling.org] from ip 185.117.83.208
  699. 2023-06-16 06:08:06.974226 38.37% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [proceeding][180]
  700. 2023-06-16 06:08:06.974226 38.37% [NOTICE] sofia.c:7598 Ring-Ready sofia/default/5575942767@185.117.83.208:35080!
  701. 2023-06-16 06:08:06.974226 38.37% [DEBUG] switch_channel.c:3494 (sofia/default/5575942767@185.117.83.208:35080) Callstate Change DOWN -> RINGING
  702. 2023-06-16 06:08:06.974226 38.37% [NOTICE] mod_sofia.c:2516 Ring-Ready sofia/default/7870463271@alpha3.astppbilling.org:5076!
  703. 2023-06-16 06:08:06.974226 38.37% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [early][180]
  704. 2023-06-16 06:08:06.974226 38.37% [NOTICE] switch_ivr_originate.c:565 Ring Ready sofia/default/7870463271@alpha3.astppbilling.org:5076!
  705. 2023-06-16 06:08:07.314242 38.63% [WARNING] sofia_reg.c:1846 SIP auth challenge (REGISTER) on sofia profile 'default' for [5575942767@alpha3.astppbilling.org] from ip 185.117.83.208
  706. 2023-06-16 06:08:10.714270 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [completing][200]
  707. 2023-06-16 06:08:10.714270 38.63% [DEBUG] sofia.c:7497 Remote SDP:
  708. v=0
  709. o=Zoiper 0 1094410467 IN IP4 10.156.235.240
  710. s=Zoiper
  711. c=IN IP4 10.156.235.240
  712. t=0 0
  713. m=audio 49432 RTP/AVP 8 106 9 0 3 101 98
  714. a=rtpmap:106 opus/48000/2
  715. a=fmtp:106 sprop-maxcapturerate=16000; minptime=20; useinbandfec=1
  716. a=rtpmap:101 telephone-event/8000
  717. a=fmtp:101 0-16
  718. a=rtpmap:98 telephone-event/48000
  719. a=fmtp:98 0-16
  720. a=rtcp-mux
  721. a=ptime:20
  722. a=direction:both
  723.  
  724. 2023-06-16 06:08:10.714270 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/5575942767@185.117.83.208:35080 entering state [ready][200]
  725. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  726. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5582 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  727. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [opus:106:48000:20:0:2]/[PCMA:8:8000:20:64000:1]
  728. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  729. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  730. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5527 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  731. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5443 Set telephone-event payload to 101@8000
  732. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:3750 Set Codec sofia/default/5575942767@185.117.83.208:35080 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  733. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_codec.c:111 sofia/default/5575942767@185.117.83.208:35080 Original read codec set to PCMA:8
  734. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5792 Set telephone-event payload to 101@8000
  735. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:5850 sofia/default/5575942767@185.117.83.208:35080 Set 2833 dtmf send payload to 101 recv payload to 101
  736. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8651 AUDIO RTP [sofia/default/5575942767@185.117.83.208:35080] 95.217.238.195 port 23726 -> 10.156.235.240 port 49432 codec: 8 ms: 20
  737. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_rtp.c:4377 Starting timer [soft] 160 bytes per 20ms
  738. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8871 Activating RTCP PORT 49432
  739. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_rtp.c:4708 RTCP send rate is: 1000 and packet rate is: 20000 Remote Port: 49432
  740. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8963 sofia/default/5575942767@185.117.83.208:35080 Set 2833 dtmf send payload to 101
  741. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8970 sofia/default/5575942767@185.117.83.208:35080 Set 2833 dtmf receive payload to 101
  742. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8993 sofia/default/5575942767@185.117.83.208:35080 Set rtp dtmf delay to 40
  743. 2023-06-16 06:08:10.714270 38.63% [NOTICE] sofia.c:8674 Channel [sofia/default/5575942767@185.117.83.208:35080] has been answered
  744. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_channel.c:3893 (sofia/default/5575942767@185.117.83.208:35080) Callstate Change RINGING -> ACTIVE
  745. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8651 AUDIO RTP [sofia/default/7870463271@alpha3.astppbilling.org:5076] 95.217.238.195 port 22716 -> 103.240.35.46 port 8000 codec: 8 ms: 20
  746. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_rtp.c:4377 Starting timer [soft] 160 bytes per 20ms
  747. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8963 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf send payload to 101
  748. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8970 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set 2833 dtmf receive payload to 101
  749. 2023-06-16 06:08:10.714270 38.63% [DEBUG] switch_core_media.c:8993 sofia/default/7870463271@alpha3.astppbilling.org:5076 Set rtp dtmf delay to 40
  750. 2023-06-16 06:08:10.714270 38.63% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/7870463271@alpha3.astppbilling.org:5076:
  751. v=0
  752. o=FreeSWITCH 1686865774 1686865775 IN IP4 95.217.238.195
  753. s=FreeSWITCH
  754. c=IN IP4 95.217.238.195
  755. t=0 0
  756. m=audio 22716 RTP/AVP 8 101
  757. a=rtpmap:8 PCMA/8000
  758. a=rtpmap:101 telephone-event/8000
  759. a=fmtp:101 0-15
  760. a=ptime:20
  761. a=sendrecv
  762.  
  763. 2023-06-16 06:08:10.714270 38.63% [NOTICE] switch_ivr_originate.c:3844 Channel [sofia/default/7870463271@alpha3.astppbilling.org:5076] has been answered
  764. 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_channel.c:3893 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change RINGING -> ACTIVE
  765. 2023-06-16 06:08:10.754229 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [completed][200]
  766. 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_ivr_originate.c:3902 Originate Resulted in Success: [sofia/default/5575942767@185.117.83.208:35080] Peer UUID: 0d73261a-1319-4eb8-a388-348f777c776d
  767. 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_ivr_originate.c:3902 Originate Resulted in Success: [sofia/default/5575942767@185.117.83.208:35080] Peer UUID: 0d73261a-1319-4eb8-a388-348f777c776d
  768. 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_ivr_bridge.c:1791 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_CONSUME_MEDIA -> CS_EXCHANGE_MEDIA
  769. 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_EXCHANGE_MEDIA (Cur 2 Tot 340)
  770. 2023-06-16 06:08:10.754229 38.63% [DEBUG] switch_core_state_machine.c:650 (sofia/default/5575942767@185.117.83.208:35080) State EXCHANGE_MEDIA
  771. 2023-06-16 06:08:10.754229 38.63% [DEBUG] mod_sofia.c:671 SOFIA EXCHANGE_MEDIA
  772. 2023-06-16 06:08:11.054226 38.63% [DEBUG] switch_rtp.c:1775 rtcp_stats_init: audio ssrc[3039066830] base_seq[35524]
  773. 2023-06-16 06:08:11.054226 38.63% [DEBUG] sofia.c:7487 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 entering state [ready][200]
  774. 2023-06-16 06:08:11.074226 38.63% [DEBUG] switch_rtp.c:7511 Correct audio ip/port confirmed.
  775. 2023-06-16 06:08:11.374231 39.20% [INFO] switch_rtp.c:7471 Auto Changing audio port from 10.156.235.240:49432 to 117.228.92.158:47448
  776. 2023-06-16 06:08:21.454233 39.77% [NOTICE] sofia.c:1065 Hangup sofia/default/5575942767@185.117.83.208:35080 [CS_EXCHANGE_MEDIA] [NORMAL_CLEARING]
  777. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_ivr_bridge.c:911 BRIDGE THREAD DONE [sofia/default/5575942767@185.117.83.208:35080]
  778. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:650 (sofia/default/5575942767@185.117.83.208:35080) State EXCHANGE_MEDIA going to sleep
  779. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_HANGUP (Cur 2 Tot 340)
  780. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:844 (sofia/default/5575942767@185.117.83.208:35080) Callstate Change ACTIVE -> HANGUP
  781. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/5575942767@185.117.83.208:35080) State HANGUP
  782. 2023-06-16 06:08:21.454233 39.77% [DEBUG] mod_sofia.c:468 Channel sofia/default/5575942767@185.117.83.208:35080 hanging up, cause: NORMAL_CLEARING
  783. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:59 sofia/default/5575942767@185.117.83.208:35080 Standard HANGUP, cause: NORMAL_CLEARING
  784. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/5575942767@185.117.83.208:35080) State HANGUP going to sleep
  785. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:616 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_HANGUP -> CS_REPORTING
  786. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_REPORTING (Cur 2 Tot 340)
  787. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/5575942767@185.117.83.208:35080) State REPORTING
  788. 2023-06-16 06:08:21.454233 39.77% [INFO] mod_json_cdr.c:272 Process [0d73261a-1319-4eb8-a388-348f777c776d.cdr.json]
  789. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:168 sofia/default/5575942767@185.117.83.208:35080 Standard REPORTING, cause: NORMAL_CLEARING
  790. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/5575942767@185.117.83.208:35080) State REPORTING going to sleep
  791. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:607 (sofia/default/5575942767@185.117.83.208:35080) State Change CS_REPORTING -> CS_DESTROY
  792. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_session.c:1743 Session 340 (sofia/default/5575942767@185.117.83.208:35080) Locked, Waiting on external entities
  793. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_ivr_bridge.c:819 sofia/default/5575942767@185.117.83.208:35080 ending bridge by request from write function
  794. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_ivr_bridge.c:911 BRIDGE THREAD DONE [sofia/default/7870463271@alpha3.astppbilling.org:5076]
  795. 2023-06-16 06:08:21.454233 39.77% [NOTICE] switch_core_session.c:1761 Session 340 (sofia/default/5575942767@185.117.83.208:35080) Ended
  796. 2023-06-16 06:08:21.454233 39.77% [NOTICE] switch_core_session.c:1765 Close Channel sofia/default/5575942767@185.117.83.208:35080 [CS_DESTROY]
  797. EXECUTE [depth=0] sofia/default/7870463271@alpha3.astppbilling.org:5076 lua(astpp/lib/pbx/astpp-sipdevice-routing.lua)
  798. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:735 (sofia/default/5575942767@185.117.83.208:35080) Running State Change CS_DESTROY (Cur 1 Tot 340)
  799. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/5575942767@185.117.83.208:35080) State DESTROY
  800. 2023-06-16 06:08:21.454233 39.77% [DEBUG] mod_sofia.c:379 sofia/default/5575942767@185.117.83.208:35080 SOFIA DESTROY
  801. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:175 sofia/default/5575942767@185.117.83.208:35080 Standard DESTROY
  802. 2023-06-16 06:08:21.454233 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/5575942767@185.117.83.208:35080) State DESTROY going to sleep
  803. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  804. 2023-06-16 06:08:21.474232 39.77% [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')
  805. 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_cpp.cpp:1465 [Astpp_SIP-Devices] This Is Last Dispositions SUCCESS This Is SIP Number : 5575942767
  806. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_cpp.cpp:1209 sofia/default/7870463271@alpha3.astppbilling.org:5076 destroy/unlink session from object
  807. 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_state_machine.c:382 sofia/default/7870463271@alpha3.astppbilling.org:5076 has executed the last dialplan instruction, hanging up.
  808. 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/7870463271@alpha3.astppbilling.org:5076 [CS_EXECUTE] [NORMAL_CLEARING]
  809. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:647 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State EXECUTE going to sleep
  810. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_HANGUP (Cur 1 Tot 340)
  811. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:844 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Callstate Change ACTIVE -> HANGUP
  812. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HANGUP
  813. 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:462 sofia/default/7870463271@alpha3.astppbilling.org:5076 Overriding SIP cause 480 with 200 from the other leg
  814. 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:468 Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 hanging up, cause: NORMAL_CLEARING
  815. 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/7870463271@alpha3.astppbilling.org:5076
  816. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:59 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard HANGUP, cause: NORMAL_CLEARING
  817. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:846 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State HANGUP going to sleep
  818. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:616 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_HANGUP -> CS_REPORTING
  819. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:581 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_REPORTING (Cur 1 Tot 340)
  820. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State REPORTING
  821. 2023-06-16 06:08:21.474232 39.77% [INFO] mod_json_cdr.c:272 Process [afd7d3e7-1b90-4ab0-a54b-cf8c033578af.cdr.json]
  822. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:168 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard REPORTING, cause: NORMAL_CLEARING
  823. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:932 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State REPORTING going to sleep
  824. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:607 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State Change CS_REPORTING -> CS_DESTROY
  825. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_session.c:1743 Session 339 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Locked, Waiting on external entities
  826. 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_session.c:1761 Session 339 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Ended
  827. 2023-06-16 06:08:21.474232 39.77% [NOTICE] switch_core_session.c:1765 Close Channel sofia/default/7870463271@alpha3.astppbilling.org:5076 [CS_DESTROY]
  828. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:735 (sofia/default/7870463271@alpha3.astppbilling.org:5076) Running State Change CS_DESTROY (Cur 0 Tot 340)
  829. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State DESTROY
  830. 2023-06-16 06:08:21.474232 39.77% [DEBUG] mod_sofia.c:379 sofia/default/7870463271@alpha3.astppbilling.org:5076 SOFIA DESTROY
  831. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:175 sofia/default/7870463271@alpha3.astppbilling.org:5076 Standard DESTROY
  832. 2023-06-16 06:08:21.474232 39.77% [DEBUG] switch_core_state_machine.c:745 (sofia/default/7870463271@alpha3.astppbilling.org:5076) State DESTROY going to sleep
  833.  

Reply to "CDRS entry issue in when made time condition call"