From DID-TC-RG-PSTN, 1 Week ago, written in HTML5.
- view diff
Embed
  1.  
  2. 2024-12-16 13:10:33.295285 98.00% [NOTICE] switch_channel.c:1142 New Channel sofia/default/1234@00133897.yoursipcloud.com [cef11b45-f79f-4ae3-98d8-7e10f9a444c4]
  3. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_NEW (Cur 17 Tot 1667)
  4. 2024-12-16 13:10:33.295285 98.00% [INFO] sofia.c:10459 sofia/default/1234@00133897.yoursipcloud.com receiving invite from 185.249.40.236:5060 version: 1.10.10-release  64bit call-id: DLGCH_KB4dHz46HGp6Py4EHCYbJygdLQoqGH59
  5. 2024-12-16 13:10:33.295285 98.00% [DEBUG] sofia.c:10553 verifying acl "default" for ip/port 185.249.40.236:0.
  6. 2024-12-16 13:10:33.295285 98.00% [DEBUG] sofia.c:10582 IP 185.249.40.236 Approved by acl "default[]". Access Granted.
  7. 2024-12-16 13:10:33.295285 98.00% [DEBUG] sofia.c:7493 Channel sofia/default/1234@00133897.yoursipcloud.com entering state [received][100]
  8. 2024-12-16 13:10:33.295285 98.00% [DEBUG] sofia.c:7503 Remote SDP:
  9. v=0
  10. o=Z 0 0 IN IP4 103.240.35.46
  11. s=Z
  12. c=IN IP4 103.240.35.46
  13. t=0 0
  14. m=audio 8000 RTP/AVP 3 110 8 0 97 101
  15. a=rtpmap:110 speex/8000
  16. a=rtpmap:97 iLBC/8000
  17. a=fmtp:97 mode=30
  18. a=rtpmap:101 telephone-event/8000
  19. a=fmtp:101 0-16
  20.  
  21. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  22. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  23. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1]
  24. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
  25. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
  26. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [speex:110:8000:20:0:1]/[G729:18:8000:20:8000:1]
  27. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  28. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  29. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  30. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  31. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  32. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  33. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  34. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  35. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
  36. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [iLBC:97:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
  37. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [iLBC:97:8000:30:0:1]/[G729:18:8000:20:8000:1]
  38. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5438 Set telephone-event payload to 101@8000
  39. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:3734 Set Codec sofia/default/1234@00133897.yoursipcloud.com PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  40. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_codec.c:111 sofia/default/1234@00133897.yoursipcloud.com Original read codec set to PCMA:8
  41. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5798 Set telephone-event payload to 101@8000
  42. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_media.c:5856 sofia/default/1234@00133897.yoursipcloud.com Set 2833 dtmf send payload to 101 recv payload to 101
  43. 2024-12-16 13:10:33.295285 98.00% [DEBUG] sofia.c:7927 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_NEW -> CS_INIT
  44. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:600 (sofia/default/1234@00133897.yoursipcloud.com) State NEW
  45. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_INIT (Cur 17 Tot 1667)
  46. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1234@00133897.yoursipcloud.com) State INIT
  47. 2024-12-16 13:10:33.295285 98.00% [DEBUG] mod_sofia.c:97 sofia/default/1234@00133897.yoursipcloud.com SOFIA INIT
  48. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:40 sofia/default/1234@00133897.yoursipcloud.com Standard INIT
  49. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:48 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_INIT -> CS_ROUTING
  50. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/1234@00133897.yoursipcloud.com) State INIT going to sleep
  51. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_ROUTING (Cur 17 Tot 1667)
  52. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_channel.c:2399 (sofia/default/1234@00133897.yoursipcloud.com) Callstate Change DOWN -> RINGING
  53. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1234@00133897.yoursipcloud.com) State ROUTING
  54. 2024-12-16 13:10:33.295285 98.00% [DEBUG] mod_sofia.c:158 sofia/default/1234@00133897.yoursipcloud.com SOFIA ROUTING
  55. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_core_state_machine.c:230 sofia/default/1234@00133897.yoursipcloud.com Standard ROUTING
  56. 2024-12-16 13:10:33.295285 98.00% [INFO] mod_dialplan_xml.c:639 Processing 1234 <1234>->31855004076 in context default
  57. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  58. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  59. 2024-12-16 13:10:33.295285 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  60. 2024-12-16 13:10:33.295285 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 31855004076
  61. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '31855004076' limit 1
  62. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '31855004076' AND status=0 limit 1
  63. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '31855004076' and status=0 LIMIT 1
  64. 2024-12-16 13:10:33.295285 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : TEST / 318002666436
  65. 2024-12-16 13:10:33.295285 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  66. 2024-12-16 13:10:33.295285 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  67. 2024-12-16 13:10:33.295285 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 00133897]
  68. 2024-12-16 13:10:33.295285 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "00133897" AND deleted = 0 limit 1
  69. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="31855004076" AND (accountid = 0 OR status = 1) LIMIT 1
  70. 2024-12-16 13:10:33.315277 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 1
  71. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1
  72. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  73. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 1884
  74. 2024-12-16 13:10:33.315277 98.00% [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 = '^31855004076.*' OR patterns = '^3185500407.*' OR patterns = '^318550040.*' OR patterns = '^31855004.*' OR patterns = '^3185500.*' OR patterns = '^318550.*' OR patterns = '^31855.*' OR patterns = '^3185.*' OR patterns = '^318.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 1884 ORDER BY LENGTH(PKGPTR.patterns) DESC
  75. 2024-12-16 13:10:33.315277 98.00% [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 ="31855004076" AND A.accountid = '1884' limit 1
  76. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31855004076
  77. 2024-12-16 13:10:33.315277 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  78. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  79. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '318002666436' OR number = '31800266643' OR number = '3180026664' OR number = '318002666' OR number = '31800266' OR number = '3180026' OR number = '318002' OR number = '31800' OR number = '3180' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '318002666436*' OR number = '31800266643*' OR number = '3180026664*' OR number = '318002666*' OR number = '31800266*' OR number = '3180026*' OR number = '318002*' OR number = '31800*' OR number = '3180*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  80. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  81. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31855004076' OR routing_prefix = '3185500407' OR routing_prefix = '318550040' OR routing_prefix = '31855004' OR routing_prefix = '3185500' OR routing_prefix = '318550' OR routing_prefix = '31855' OR routing_prefix = '3185' OR routing_prefix = '318' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 12 limit 1
  82. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  83. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 1884
  84. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 00133897
  85. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 10
  86. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  87. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 6
  88. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  89. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  90. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 6 AND status = 0
  91. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  92. 2024-12-16 13:10:33.315277 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  93. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  94. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  95. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 183
  96. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  97. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  98. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  99. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 31855004076
  100. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 136
  101. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 1884
  102. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  103. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your10 balance Accountid 1884 !!!
  104. 2024-12-16 13:10:33.315277 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  105. 2024-12-16 13:10:33.315277 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 12
  106. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "12" AND deleted = 0 limit 1
  107. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  108. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 12
  109. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 3847299300
  110. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 99300.97566
  111. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  112. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 44
  113. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 44 AND status = 0
  114. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  115. 2024-12-16 13:10:33.315277 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  116. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  117. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  118. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 183
  119. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  120. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  121. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  122. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 31855004076
  123. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 136
  124. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 12
  125. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  126. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your99300.97566 balance Accountid 12 !!!
  127. 2024-12-16 13:10:33.315277 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  128. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884||ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884
  129. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  130. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 0
  131. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  132. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  133. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  134. 2024-12-16 13:10:33.315277 98.00% [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 = 1884 AND status=0 LIMIT 1
  135. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "1884" AND deleted = 0 limit 1
  136. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:1884
  137. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:1884
  138. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 1884
  139. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 1884 limit 1
  140. 2024-12-16 13:10:33.315277 98.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : 00133897.yoursipcloud.com
  141. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 107
  142. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '107' and status =0 LIMIT 1
  143. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
  144. 2024-12-16 13:10:33.315277 98.00% [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":"2024-2024","extensions":"377","no_answer_call_type":"7","priority":"1"}]
  145. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
  146. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '277' LIMIT 1
  147. 2024-12-16 13:10:33.315277 98.00% [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= "2024-2024"
  148. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  149. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  150. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  151. 2024-12-16 13:10:33.315277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  152. 2024-12-16 13:10:33.315277 98.00% [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 = "107" AND accounts.status = 0
  153. 2024-12-16 13:10:33.315277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 1884 limit 1
  154. 2024-12-16 13:10:33.335279 98.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : 00133897.yoursipcloud.com
  155. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 1884  and status = 0 limit 1
  156. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  157. 2024-12-16 13:10:33.335279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 107
  158. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '107' and status =0 LIMIT 1
  159. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  160. <document type="freeswitch/xml">
  161. <section name="dialplan" description="ASTPP Dialplan">
  162. <context name="default">
  163. <extension name="+31 6 26673579" continue="true">
  164. <condition break="never">
  165. <action application="set" data="timezone=Europe/Amsterdam" inline="true"/>
  166. </condition>
  167. <condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2024-2024"  break="never">
  168. <action application="set" data="office_status=open" inline="true"/>
  169. <action application="set" data="extensions=377" inline="true"/>
  170. <action application="set" data="no_answer_call_type=7" inline="true"/>
  171. </condition>
  172. </extension>
  173. <extension name="tod route, x31855004076">
  174. <condition field="destination_number" expression="^(\+?)?(31855004076)$">
  175. <action application="execute_extension" data="31855004076_${office_status}"/>
  176. </condition>
  177. </extension>
  178. <extension name="office is open">
  179. <condition field="destination_number" expression="^(\+?)?(31855004076_open)$">
  180. <action application="set" data="domain_name=00133897.yoursipcloud.com"/>
  181. <action application="set" data="set_extensions=${extensions}"/>
  182. <action application="set" data="no_answer_flag=true"/>
  183. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
  184. <action application="set" data="no_answer_number=${extensions}" />
  185. <action application="transfer" data="1884 XML default"/>
  186. </condition>
  187. </extension>
  188. <extension name="31855004076">
  189. <condition field="destination_number" expression="31855004076">
  190. <action application="set" data="effective_destination_number=31855004076"/>
  191. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  192. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  193. <action application="set" data="callstart=2024-12-16 13:10:33"/>
  194. <action application="set" data="hangup_after_bridge=true"/>
  195. <action application="set" data="continue_on_fail=TRUE"/>
  196. <action application="set" data="account_id=1884"/>
  197. <action application="set" data="parent_id=12"/>
  198. <action application="set" data="entity_id=0"/>
  199. <action application="set" data="call_processed=internal"/>
  200. <action application="set" data="call_direction=inbound"/>
  201. <action application="set" data="accountname=default"/>
  202. <action application="set" data="filename1=astpp.pbx.lua"/>
  203. <action application="set" data="origination_rates_did=ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884||ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884"/>
  204. <action application="set" data="origination_rates=0"/>
  205. <action application="set" data="original_caller_id_name=TEST"/>
  206. <action application="set" data="original_caller_id_number=318002666436"/>
  207. <action application="limit" data="db 00133897 user_00133897 10 "/>
  208. <action application="limit" data="hash CPS_00133897 CPS_user_00133897 1/1 "/>
  209. <action application="set" data="effective_caller_id_name=TEST"/>
  210. <action application="set" data="effective_caller_id_number=318002666436"/>
  211. <action application="set" data="receiver_accid=1884"/>
  212. <action application="export" data="domain_name=00133897.yoursipcloud.com"/>
  213. <action application="export" data="sip_to_host=00133897.yoursipcloud.com"/>
  214. <action application="export" data="presence_data=x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250"/>
  215. <action application="export" data="call_type=11"/>
  216. </condition>
  217. </extension>
  218. </context>
  219. </document>
  220. Dialplan: sofia/default/1234@00133897.yoursipcloud.com parsing [default->+31 6 26673579] continue=true
  221. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Absolute Condition [+31 6 26673579]
  222. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(timezone=Europe/Amsterdam) INLINE
  223. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(timezone=Europe/Amsterdam)
  224. 2024-12-16 13:10:33.335279 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [timezone]=[Europe/Amsterdam]
  225. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Date/Time Match (PASS) [+31 6 26673579] break=never
  226. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(office_status=open) INLINE
  227. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(office_status=open)
  228. 2024-12-16 13:10:33.335279 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [office_status]=[open]
  229. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(extensions=377) INLINE
  230. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(extensions=377)
  231. 2024-12-16 13:10:33.335279 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [extensions]=[377]
  232. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(no_answer_call_type=7) INLINE
  233. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(no_answer_call_type=7)
  234. 2024-12-16 13:10:33.335279 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [no_answer_call_type]=[7]
  235. Dialplan: sofia/default/1234@00133897.yoursipcloud.com parsing [default->tod route, x31855004076] continue=false
  236. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Regex (PASS) [tod route, x31855004076] destination_number(31855004076) =~ /^(\+?)?(31855004076)$/ break=on-false
  237. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action execute_extension(31855004076_${office_status})
  238. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_core_state_machine.c:281 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_ROUTING -> CS_EXECUTE
  239. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1234@00133897.yoursipcloud.com) State ROUTING going to sleep
  240. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_EXECUTE (Cur 17 Tot 1667)
  241. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/1234@00133897.yoursipcloud.com) State EXECUTE
  242. 2024-12-16 13:10:33.335279 98.00% [DEBUG] mod_sofia.c:213 sofia/default/1234@00133897.yoursipcloud.com SOFIA EXECUTE
  243. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_core_state_machine.c:323 sofia/default/1234@00133897.yoursipcloud.com Standard EXECUTE
  244. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com execute_extension(31855004076_open)
  245. 2024-12-16 13:10:33.335279 98.00% [INFO] mod_dialplan_xml.c:639 Processing 1234 <1234>->31855004076_open in context default
  246. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  247. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  248. 2024-12-16 13:10:33.335279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  249. 2024-12-16 13:10:33.335279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 31855004076
  250. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '31855004076' limit 1
  251. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '31855004076' AND status=0 limit 1
  252. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '31855004076' and status=0 LIMIT 1
  253. 2024-12-16 13:10:33.335279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : TEST / 318002666436
  254. 2024-12-16 13:10:33.335279 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  255. 2024-12-16 13:10:33.335279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  256. 2024-12-16 13:10:33.335279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 00133897]
  257. 2024-12-16 13:10:33.335279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "00133897" AND deleted = 0 limit 1
  258. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="31855004076" AND (accountid = 0 OR status = 1) LIMIT 1
  259. 2024-12-16 13:10:33.355279 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 1
  260. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1
  261. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  262. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 1884
  263. 2024-12-16 13:10:33.355279 98.00% [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 = '^31855004076.*' OR patterns = '^3185500407.*' OR patterns = '^318550040.*' OR patterns = '^31855004.*' OR patterns = '^3185500.*' OR patterns = '^318550.*' OR patterns = '^31855.*' OR patterns = '^3185.*' OR patterns = '^318.*' OR patterns = '^31.*' OR patterns = '^3.*' OR patterns ='--') AND accountid = 1884 ORDER BY LENGTH(PKGPTR.patterns) DESC
  264. 2024-12-16 13:10:33.355279 98.00% [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 ="31855004076" AND A.accountid = '1884' limit 1
  265. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 31855004076
  266. 2024-12-16 13:10:33.355279 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  267. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  268. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '31855004076' OR number = '3185500407' OR number = '318550040' OR number = '31855004' OR number = '3185500' OR number = '318550' OR number = '31855' OR number = '3185' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '31855004076*' OR number = '3185500407*' OR number = '318550040*' OR number = '31855004*' OR number = '3185500*' OR number = '318550*' OR number = '31855*' OR number = '3185*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--') OR (number = '318002666436' OR number = '31800266643' OR number = '3180026664' OR number = '318002666' OR number = '31800266' OR number = '3180026' OR number = '318002' OR number = '31800' OR number = '3180' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '318002666436*' OR number = '31800266643*' OR number = '3180026664*' OR number = '318002666*' OR number = '31800266*' OR number = '3180026*' OR number = '318002*' OR number = '31800*' OR number = '3180*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  269. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  270. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '31855004076' OR routing_prefix = '3185500407' OR routing_prefix = '318550040' OR routing_prefix = '31855004' OR routing_prefix = '3185500' OR routing_prefix = '318550' OR routing_prefix = '31855' OR routing_prefix = '3185' OR routing_prefix = '318' OR routing_prefix = '31' OR routing_prefix = '3' OR routing_prefix ='--') AND status = 0 and reseller_id = 12 limit 1
  271. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  272. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 1884
  273. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 00133897
  274. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 10
  275. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  276. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 6
  277. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  278. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  279. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 6 AND status = 0
  280. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  281. 2024-12-16 13:10:33.355279 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  282. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  283. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  284. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 183
  285. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  286. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  287. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  288. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 31855004076
  289. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 136
  290. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 1884
  291. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  292. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your10 balance Accountid 1884 !!!
  293. 2024-12-16 13:10:33.355279 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  294. 2024-12-16 13:10:33.355279 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 12
  295. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "12" AND deleted = 0 limit 1
  296. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  297. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 12
  298. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 3847299300
  299. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 99300.97566
  300. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  301. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 44
  302. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 44 AND status = 0
  303. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  304. 2024-12-16 13:10:33.355279 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="31855004076" LIMIT 1
  305. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  306. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  307. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 183
  308. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  309. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  310. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  311. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : 31855004076
  312. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 136
  313. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 12
  314. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  315. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your99300.97566 balance Accountid 12 !!!
  316. 2024-12-16 13:10:33.355279 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  317. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884||ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884
  318. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  319. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 0
  320. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  321. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  322. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  323. 2024-12-16 13:10:33.355279 98.00% [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 = 1884 AND status=0 LIMIT 1
  324. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "1884" AND deleted = 0 limit 1
  325. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:1884
  326. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:1884
  327. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 1884
  328. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 1884 limit 1
  329. 2024-12-16 13:10:33.355279 98.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : 00133897.yoursipcloud.com
  330. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Timecondition Id : 107
  331. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '107' and status =0 LIMIT 1
  332. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Failover Timecondition : [{"extensions":"#","no_answer_call_type":"12"}]
  333. 2024-12-16 13:10:33.355279 98.00% [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":"2024-2024","extensions":"377","no_answer_call_type":"7","priority":"1"}]
  334. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] Priority : 1
  335. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from timezone WHERE id = '277' LIMIT 1
  336. 2024-12-16 13:10:33.355279 98.00% [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= "2024-2024"
  337. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  338. 2024-12-16 13:10:33.355279 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  339. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  340. 2024-12-16 13:10:33.355279 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  341. 2024-12-16 13:10:33.355279 98.00% [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 = "107" AND accounts.status = 0
  342. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 1884 limit 1
  343. 2024-12-16 13:10:33.375277 98.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : 00133897.yoursipcloud.com
  344. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 1884  and status = 0 limit 1
  345. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_11
  346. 2024-12-16 13:10:33.375277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [TIME_COND] TimeCondition Id : 107
  347. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_TIME_CONDITION_QUERY] Query :SELECT * from time_condition WHERE id = '107' and status =0 LIMIT 1
  348. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  349. <document type="freeswitch/xml">
  350. <section name="dialplan" description="ASTPP Dialplan">
  351. <context name="default">
  352. <extension name="+31 6 26673579" continue="true">
  353. <condition break="never">
  354. <action application="set" data="timezone=Europe/Amsterdam" inline="true"/>
  355. </condition>
  356. <condition  time-of-day= "00:00-23:59"  wday= "1-7"  mday= "1-31"  mon= "1-12"  year= "2024-2024"  break="never">
  357. <action application="set" data="office_status=open" inline="true"/>
  358. <action application="set" data="extensions=377" inline="true"/>
  359. <action application="set" data="no_answer_call_type=7" inline="true"/>
  360. </condition>
  361. </extension>
  362. <extension name="tod route, x31855004076">
  363. <condition field="destination_number" expression="^(\+?)?(31855004076)$">
  364. <action application="execute_extension" data="31855004076_${office_status}"/>
  365. </condition>
  366. </extension>
  367. <extension name="office is open">
  368. <condition field="destination_number" expression="^(\+?)?(31855004076_open)$">
  369. <action application="set" data="domain_name=00133897.yoursipcloud.com"/>
  370. <action application="set" data="set_extensions=${extensions}"/>
  371. <action application="set" data="no_answer_flag=true"/>
  372. <action application="set" data="no_answer_call_type=${no_answer_call_type}"/>
  373. <action application="set" data="no_answer_number=${extensions}" />
  374. <action application="transfer" data="1884 XML default"/>
  375. </condition>
  376. </extension>
  377. <extension name="31855004076">
  378. <condition field="destination_number" expression="31855004076">
  379. <action application="set" data="effective_destination_number=31855004076"/>
  380. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  381. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  382. <action application="set" data="callstart=2024-12-16 13:10:33"/>
  383. <action application="set" data="hangup_after_bridge=true"/>
  384. <action application="set" data="continue_on_fail=TRUE"/>
  385. <action application="set" data="account_id=1884"/>
  386. <action application="set" data="parent_id=12"/>
  387. <action application="set" data="entity_id=0"/>
  388. <action application="set" data="call_processed=internal"/>
  389. <action application="set" data="call_direction=inbound"/>
  390. <action application="set" data="accountname=default"/>
  391. <action application="set" data="filename1=astpp.pbx.lua"/>
  392. <action application="set" data="origination_rates_did=ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884||ID:183|CODE:^31855004076.*|DESTINATION:31855004076|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:11|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:136|ACCID:1884"/>
  393. <action application="set" data="origination_rates=0"/>
  394. <action application="set" data="original_caller_id_name=TEST"/>
  395. <action application="set" data="original_caller_id_number=318002666436"/>
  396. <action application="limit" data="db 00133897 user_00133897 10 "/>
  397. <action application="limit" data="hash CPS_00133897 CPS_user_00133897 1/1 "/>
  398. <action application="set" data="effective_caller_id_name=TEST"/>
  399. <action application="set" data="effective_caller_id_number=318002666436"/>
  400. <action application="set" data="receiver_accid=1884"/>
  401. <action application="export" data="domain_name=00133897.yoursipcloud.com"/>
  402. <action application="export" data="sip_to_host=00133897.yoursipcloud.com"/>
  403. <action application="export" data="presence_data=x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250"/>
  404. <action application="export" data="call_type=11"/>
  405. </condition>
  406. </extension>
  407. </context>
  408. </document>
  409. Dialplan: sofia/default/1234@00133897.yoursipcloud.com parsing [default->+31 6 26673579] continue=true
  410. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Absolute Condition [+31 6 26673579]
  411. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(timezone=Europe/Amsterdam) INLINE
  412. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(timezone=Europe/Amsterdam)
  413. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [timezone]=[Europe/Amsterdam]
  414. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Date/Time Match (PASS) [+31 6 26673579] break=never
  415. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(office_status=open) INLINE
  416. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(office_status=open)
  417. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [office_status]=[open]
  418. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(extensions=377) INLINE
  419. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(extensions=377)
  420. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [extensions]=[377]
  421. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(no_answer_call_type=7) INLINE
  422. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(no_answer_call_type=7)
  423. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [no_answer_call_type]=[7]
  424. Dialplan: sofia/default/1234@00133897.yoursipcloud.com parsing [default->tod route, x31855004076] continue=false
  425. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Regex (FAIL) [tod route, x31855004076] destination_number(31855004076_open) =~ /^(\+?)?(31855004076)$/ break=on-false
  426. Dialplan: sofia/default/1234@00133897.yoursipcloud.com parsing [default->office is open] continue=false
  427. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Regex (PASS) [office is open] destination_number(31855004076_open) =~ /^(\+?)?(31855004076_open)$/ break=on-false
  428. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(domain_name=00133897.yoursipcloud.com)
  429. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(set_extensions=${extensions})
  430. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(no_answer_flag=true)
  431. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(no_answer_call_type=${no_answer_call_type})
  432. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(no_answer_number=${extensions})
  433. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action transfer(1884 XML default)
  434. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_core_session.c:3089 Execute [depth=1] set(domain_name=00133897.yoursipcloud.com)
  435. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(domain_name=00133897.yoursipcloud.com)
  436. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [domain_name]=[00133897.yoursipcloud.com]
  437. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_core_session.c:3089 Execute [depth=1] set(set_extensions=${extensions})
  438. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(set_extensions=377)
  439. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [set_extensions]=[377]
  440. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_core_session.c:3089 Execute [depth=1] set(no_answer_flag=true)
  441. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(no_answer_flag=true)
  442. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [no_answer_flag]=[true]
  443. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_core_session.c:3089 Execute [depth=1] set(no_answer_call_type=${no_answer_call_type})
  444. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(no_answer_call_type=7)
  445. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [no_answer_call_type]=[7]
  446. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_core_session.c:3089 Execute [depth=1] set(no_answer_number=${extensions})
  447. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com set(no_answer_number=377)
  448. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [no_answer_number]=[377]
  449. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_core_session.c:3089 Execute [depth=1] transfer(1884 XML default)
  450. EXECUTE [depth=1] sofia/default/1234@00133897.yoursipcloud.com transfer(1884 XML default)
  451. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_ivr.c:2288 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_EXECUTE -> CS_ROUTING
  452. 2024-12-16 13:10:33.375277 98.00% [NOTICE] switch_ivr.c:2295 Transfer sofia/default/1234@00133897.yoursipcloud.com to XML[1884@default]
  453. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/1234@00133897.yoursipcloud.com) State EXECUTE going to sleep
  454. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_ROUTING (Cur 17 Tot 1667)
  455. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1234@00133897.yoursipcloud.com) State ROUTING
  456. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
  457. 2024-12-16 13:10:33.375277 98.00% [DEBUG] mod_sofia.c:158 sofia/default/1234@00133897.yoursipcloud.com SOFIA ROUTING
  458. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_core_state_machine.c:230 sofia/default/1234@00133897.yoursipcloud.com Standard ROUTING
  459. 2024-12-16 13:10:33.375277 98.00% [INFO] mod_dialplan_xml.c:639 Processing 1234 <1234>->1884 in context default
  460. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  461. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  462. 2024-12-16 13:10:33.375277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  463. 2024-12-16 13:10:33.375277 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 1884
  464. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '1884' limit 1
  465. 2024-12-16 13:10:33.375277 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '1884' AND status=0 limit 1
  466. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '1884' and status=0 LIMIT 1
  467. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : TEST / 318002666436
  468. 2024-12-16 13:10:33.395278 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="1884" LIMIT 1
  469. 2024-12-16 13:10:33.395278 98.00% [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 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="1884"  AND domains.domain="00133897.yoursipcloud.com" limit 1
  470. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  471. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 00133897]
  472. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "00133897" AND deleted = 0 limit 1
  473. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^1884.*' OR blocked_patterns = '^188.*' OR blocked_patterns = '^18.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 1884 limit 1
  474. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="1884" AND (accountid = 0 OR status = 1) LIMIT 1
  475. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "1884" AND deleted = 0 limit 1
  476. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^1884.*' OR blocked_patterns = '^188.*' OR blocked_patterns = '^18.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 1884 limit 1
  477. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward :1884
  478. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward2 :1884
  479. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] select accountid from domains where domain = '00133897.yoursipcloud.com'
  480. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Accountid 1884
  481. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] select number,first_name from accounts where id = '1884'
  482. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 1884 limit 1
  483. 2024-12-16 13:10:33.395278 98.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [ringgroup_no_answer_forward] User Domain00133897.yoursipcloud.com
  484. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated RingGroup No Answer Forward3 :1884
  485. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [DID_PBX_INFO]Userinfo ID  :1884
  486. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 7
  487. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Ring Group
  488. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET RING GROUP INFO] Query :SELECT id as ringgroup_id,name as ringgroup_name,strategy as ringgroup_strategy,destinations as ringgroup_destinations,description as ringgroup_description,announcementid as ringgroup_announcementid,call_record as ringgroup_call_record,skip_busy as ringgroup_skip_busy,ringbackid as ringgroup_ringbackid,calleridname as ringgroup_calleridname,calleridnumber as ringgroup_calleridnumber,no_answer as ringgroup_no_answer,no_answer_call_type as no_answer_call_type,no_answer_call_type_value from pbx_ringgroup WHERE id = 377 and status = 0 LIMIT 1
  489. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Final Count : 0===
  490. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 1884  and status = 0 limit 1
  491. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] RingGroup Recording Flag : 1
  492. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 1884
  493. 2024-12-16 13:10:33.395278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] RingGroup Dlr Str : [sip_invite_params=user=Forwarded-PSTN,sip_h_p-call_type='custom_forward',sip_h_P-RGPSTnAcctCode=00133897,call_timeout=30,confirm=false,announcement=no_file,dialed_user=31626673579#,leg_timeout=30,leg_delay_start=0]sofia/${sofia_profile_name}/31626673579@00133897.yoursipcloud.com:5060|
  494. 2024-12-16 13:10:33.395278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '315' LIMIT 1
  495. 2024-12-16 13:10:33.395278 98.00% [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
  496. 2024-12-16 13:10:33.395278 98.00% [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
  497. 2024-12-16 13:10:33.415278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Userinfo2 :1884
  498. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  499. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  500. <document type="freeswitch/xml">
  501. <section name="dialplan" description="ASTPP Dialplan">
  502. <context name="default">
  503. <extension name="1884">
  504. <condition field="destination_number" expression="1884">
  505. <action application="export" data="presence_data=x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250"/>
  506. <action application="export" data="did_user_domain=00133897.yoursipcloud.com"/>
  507. <action application="set" data="continue_on_fail=TRUE"/>
  508. <action application="set" data="ignore_early_media=true"/>
  509. <action application="set" data="no_answer_flag=false"/>
  510. <action application="set" data="did_calltype=7"/>
  511. <action application="set" data="did_extensions=377"/>
  512. <action application="set" data="sip_h_P-ring_timeout=30"/>
  513. <action application="set" data="group_confirm_key=exec"/>
  514. <action application="set" data="group_confirm_file=lua /usr/share/freeswitch/scripts/astpp/lib/pbx/astpp.confirm.lua"/>
  515. <action application="set" data="callstart=2024-12-16 13:10:33"/>
  516. <action application="set" data="account_id=1884"/>
  517. <action application="set" data="effective_caller_id_name=TEST"/>
  518. <action application="set" data="effective_caller_id_number=318002666436"/>
  519. <action application="set" data="original_caller_id_name=TEST"/>
  520. <action application="set" data="original_caller_id_number=318002666436"/>
  521. <action application="set" data="parent_id=12"/>
  522. <action application="set" data="effective_destination_number=31855004076"/>
  523. <action application="set" data="ringback=/var/www/html/astpp//upload/pbx/meldtekst_1_nieuweversiesept2013_.wav"/>
  524. <action application="set" data="module_name=pbx"/>
  525. <action application="db" data="insert/pickup_any_group_${callgroup}/377/${uuid}"/>
  526. <action application="set" data="dialed_extension=transfer_call"/>
  527. <action application="export" data="dialed_extension=transfer_call"/>
  528. <action application="bind_meta_app" data="2 b s execute_extension::transfer_call_2 XML default"/>
  529. <action application="bind_meta_app" data="3 b s execute_extension::transfer_call_3 XML default"/>
  530. <action application="export" data="ring_group_transfer=true"/>
  531. <action application="bridge" data="{sip_h_P-call_type='custom_forward',ignore_early_media=true}[sip_invite_params=user=Forwarded-PSTN,sip_h_p-call_type='custom_forward',sip_h_P-RGPSTnAcctCode=00133897,call_timeout=30,confirm=false,announcement=no_file,dialed_user=31626673579#,leg_timeout=30,leg_delay_start=0]sofia/${sofia_profile_name}/31626673579@00133897.yoursipcloud.com:5060|"/>
  532. <action application="set" data="original_did_number=1884"/>
  533. </condition>
  534. </extension>
  535. </context>
  536. </document>
  537. Dialplan: sofia/default/1234@00133897.yoursipcloud.com parsing [default->1884] continue=false
  538. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Regex (PASS) [1884] destination_number(1884) =~ /1884/ break=on-false
  539. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action export(presence_data=x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250)
  540. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action export(did_user_domain=00133897.yoursipcloud.com)
  541. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(continue_on_fail=TRUE)
  542. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(ignore_early_media=true)
  543. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(no_answer_flag=false)
  544. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(did_calltype=7)
  545. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(did_extensions=377)
  546. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(sip_h_P-ring_timeout=30)
  547. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(group_confirm_key=exec)
  548. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(group_confirm_file=lua /usr/share/freeswitch/scripts/astpp/lib/pbx/astpp.confirm.lua)
  549. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(callstart=2024-12-16 13:10:33)
  550. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(account_id=1884)
  551. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(effective_caller_id_name=TEST)
  552. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(effective_caller_id_number=318002666436)
  553. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(original_caller_id_name=TEST)
  554. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(original_caller_id_number=318002666436)
  555. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(parent_id=12)
  556. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(effective_destination_number=31855004076)
  557. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(ringback=/var/www/html/astpp//upload/pbx/meldtekst_1_nieuweversiesept2013_.wav)
  558. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(module_name=pbx)
  559. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action db(insert/pickup_any_group_${callgroup}/377/${uuid})
  560. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(dialed_extension=transfer_call)
  561. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action export(dialed_extension=transfer_call)
  562. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
  563. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
  564. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action export(ring_group_transfer=true)
  565. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action bridge({sip_h_P-call_type='custom_forward',ignore_early_media=true}[sip_invite_params=user=Forwarded-PSTN,sip_h_p-call_type='custom_forward',sip_h_P-RGPSTnAcctCode=00133897,call_timeout=30,confirm=false,announcement=no_file,dialed_user=31626673579#,leg_timeout=30,leg_delay_start=0]sofia/${sofia_profile_name}/31626673579@00133897.yoursipcloud.com:5060|)
  566. Dialplan: sofia/default/1234@00133897.yoursipcloud.com Action set(original_did_number=1884)
  567. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:281 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_ROUTING -> CS_EXECUTE
  568. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/1234@00133897.yoursipcloud.com) State ROUTING going to sleep
  569. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_EXECUTE (Cur 17 Tot 1667)
  570. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/1234@00133897.yoursipcloud.com) State EXECUTE
  571. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_sofia.c:213 sofia/default/1234@00133897.yoursipcloud.com SOFIA EXECUTE
  572. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:323 sofia/default/1234@00133897.yoursipcloud.com Standard EXECUTE
  573. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com export(presence_data=x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250)
  574. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [presence_data]=[x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250]
  575. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com export(did_user_domain=00133897.yoursipcloud.com)
  576. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [did_user_domain]=[00133897.yoursipcloud.com]
  577. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(continue_on_fail=TRUE)
  578. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [continue_on_fail]=[TRUE]
  579. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(ignore_early_media=true)
  580. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [ignore_early_media]=[true]
  581. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(no_answer_flag=false)
  582. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [no_answer_flag]=[false]
  583. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(did_calltype=7)
  584. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [did_calltype]=[7]
  585. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(did_extensions=377)
  586. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [did_extensions]=[377]
  587. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(sip_h_P-ring_timeout=30)
  588. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [sip_h_P-ring_timeout]=[30]
  589. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(group_confirm_key=exec)
  590. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [group_confirm_key]=[exec]
  591. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(group_confirm_file=lua /usr/share/freeswitch/scripts/astpp/lib/pbx/astpp.confirm.lua)
  592. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [group_confirm_file]=[lua /usr/share/freeswitch/scripts/astpp/lib/pbx/astpp.confirm.lua]
  593. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(callstart=2024-12-16 13:10:33)
  594. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [callstart]=[2024-12-16 13:10:33]
  595. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(account_id=1884)
  596. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [account_id]=[1884]
  597. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(effective_caller_id_name=TEST)
  598. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [effective_caller_id_name]=[TEST]
  599. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(effective_caller_id_number=318002666436)
  600. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [effective_caller_id_number]=[318002666436]
  601. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(original_caller_id_name=TEST)
  602. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [original_caller_id_name]=[TEST]
  603. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(original_caller_id_number=318002666436)
  604. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [original_caller_id_number]=[318002666436]
  605. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(parent_id=12)
  606. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [parent_id]=[12]
  607. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(effective_destination_number=31855004076)
  608. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [effective_destination_number]=[31855004076]
  609. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(ringback=/var/www/html/astpp//upload/pbx/meldtekst_1_nieuweversiesept2013_.wav)
  610. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [ringback]=[/var/www/html/astpp//upload/pbx/meldtekst_1_nieuweversiesept2013_.wav]
  611. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(module_name=pbx)
  612. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [module_name]=[pbx]
  613. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com db(insert/pickup_any_group_/377/cef11b45-f79f-4ae3-98d8-7e10f9a444c4)
  614. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(dialed_extension=transfer_call)
  615. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [dialed_extension]=[transfer_call]
  616. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com export(dialed_extension=transfer_call)
  617. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [dialed_extension]=[transfer_call]
  618. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com bind_meta_app(2 b s execute_extension::transfer_call_2 XML default)
  619. 2024-12-16 13:10:33.415278 98.00% [INFO] switch_ivr_async.c:4782 Bound B-Leg: *2 execute_extension::transfer_call_2 XML default
  620. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com bind_meta_app(3 b s execute_extension::transfer_call_3 XML default)
  621. 2024-12-16 13:10:33.415278 98.00% [INFO] switch_ivr_async.c:4782 Bound B-Leg: *3 execute_extension::transfer_call_3 XML default
  622. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com export(ring_group_transfer=true)
  623. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [ring_group_transfer]=[true]
  624. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com bridge({sip_h_P-call_type='custom_forward',ignore_early_media=true}[sip_invite_params=user=Forwarded-PSTN,sip_h_p-call_type='custom_forward',sip_h_P-RGPSTnAcctCode=00133897,call_timeout=30,confirm=false,announcement=no_file,dialed_user=31626673579#,leg_timeout=30,leg_delay_start=0]sofia/default/31626673579@00133897.yoursipcloud.com:5060|)
  625. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1288 sofia/default/1234@00133897.yoursipcloud.com EXPORTING[export_vars] [presence_data]=[x|||Crediteuren(00133897)|||||||||DID|||111.223.26.250] to event
  626. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1288 sofia/default/1234@00133897.yoursipcloud.com EXPORTING[export_vars] [did_user_domain]=[00133897.yoursipcloud.com] to event
  627. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1288 sofia/default/1234@00133897.yoursipcloud.com EXPORTING[export_vars] [dialed_extension]=[transfer_call] to event
  628. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_channel.c:1288 sofia/default/1234@00133897.yoursipcloud.com EXPORTING[export_vars] [ring_group_transfer]=[true] to event
  629. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_ivr_originate.c:2297 Parsing global variables
  630. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_ivr_originate.c:2859 Parsing session specific variables
  631. 2024-12-16 13:10:33.415278 98.00% [NOTICE] switch_channel.c:1142 New Channel sofia/default/31626673579@00133897.yoursipcloud.com:5060 [d26a1f01-ab81-4459-9112-353da36a8170]
  632. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_sofia.c:5110 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State Change CS_NEW -> CS_INIT
  633. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_ivr_originate.c:3167 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Setting leg timeout to 30
  634. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Running State Change CS_INIT (Cur 18 Tot 1668)
  635. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State INIT
  636. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_sofia.c:97 sofia/default/31626673579@00133897.yoursipcloud.com:5060 SOFIA INIT
  637. 2024-12-16 13:10:33.415278 98.00% [INFO] sofia_glue.c:1659 sofia/default/31626673579@00133897.yoursipcloud.com:5060 sending invite call-id: (null)
  638. 2024-12-16 13:10:33.415278 98.00% [DEBUG] sofia_glue.c:1662 sofia/default/31626673579@00133897.yoursipcloud.com:5060 sending invite version: 1.10.10-release  64bit
  639. Local SDP:
  640. v=0
  641. o=FreeSWITCH 1734331693 1734331694 IN IP4 185.249.40.236
  642. s=FreeSWITCH
  643. c=IN IP4 185.249.40.236
  644. t=0 0
  645. m=audio 22940 RTP/AVP 8 101
  646. a=rtpmap:8 PCMA/8000
  647. a=rtpmap:101 telephone-event/8000
  648. a=fmtp:101 0-15
  649. a=ptime:20
  650. a=sendrecv
  651.  
  652. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:40 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Standard INIT
  653. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:48 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State Change CS_INIT -> CS_ROUTING
  654. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State INIT going to sleep
  655. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Running State Change CS_ROUTING (Cur 18 Tot 1668)
  656. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State ROUTING
  657. 2024-12-16 13:10:33.415278 98.00% [DEBUG] mod_sofia.c:158 sofia/default/31626673579@00133897.yoursipcloud.com:5060 SOFIA ROUTING
  658. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_ivr_originate.c:67 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  659. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State ROUTING going to sleep
  660. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Running State Change CS_CONSUME_MEDIA (Cur 18 Tot 1668)
  661. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:659 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State CONSUME_MEDIA
  662. 2024-12-16 13:10:33.415278 98.00% [DEBUG] switch_core_state_machine.c:659 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State CONSUME_MEDIA going to sleep
  663. 2024-12-16 13:10:33.415278 98.00% [DEBUG] sofia.c:7493 Channel sofia/default/31626673579@00133897.yoursipcloud.com:5060 entering state [calling][0]
  664. 2024-12-16 13:10:33.435278 98.00% [NOTICE] switch_channel.c:1142 New Channel sofia/default/318002666436@185.249.40.236:5060 [6ee6b425-d7a1-4dab-af7d-d7722a62ecb1]
  665. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_NEW (Cur 19 Tot 1669)
  666. 2024-12-16 13:10:33.435278 98.00% [INFO] sofia.c:10459 sofia/default/318002666436@185.249.40.236:5060 receiving invite from 185.249.40.236:5060 version: 1.10.10-release  64bit call-id: DLGCH_CzwiLRsWGwYjIjIpN2IKPgEZNF8dKwk+HRg8NiQfAxV3Qy4UAWI1FhUTJgMRfR05CUkjKDcq
  667. 2024-12-16 13:10:33.435278 98.00% [DEBUG] sofia.c:10553 verifying acl "default" for ip/port 185.249.40.236:0.
  668. 2024-12-16 13:10:33.435278 98.00% [DEBUG] sofia.c:10582 IP 185.249.40.236 Approved by acl "default[]". Access Granted.
  669. 2024-12-16 13:10:33.435278 98.00% [DEBUG] sofia.c:7493 Channel sofia/default/318002666436@185.249.40.236:5060 entering state [received][100]
  670. 2024-12-16 13:10:33.435278 98.00% [DEBUG] sofia.c:7503 Remote SDP:
  671. v=0
  672. o=FreeSWITCH 1734331693 1734331694 IN IP4 185.249.40.236
  673. s=FreeSWITCH
  674. c=IN IP4 185.249.40.236
  675. t=0 0
  676. m=audio 22940 RTP/AVP 8 101
  677. a=rtpmap:8 PCMA/8000
  678. a=rtpmap:101 telephone-event/8000
  679. a=fmtp:101 0-15
  680. a=ptime:20
  681.  
  682. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  683. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  684. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  685. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  686. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5438 Set telephone-event payload to 101@8000
  687. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:3734 Set Codec sofia/default/318002666436@185.249.40.236:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  688. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_codec.c:111 sofia/default/318002666436@185.249.40.236:5060 Original read codec set to PCMA:8
  689. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5798 Set telephone-event payload to 101@8000
  690. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_media.c:5856 sofia/default/318002666436@185.249.40.236:5060 Set 2833 dtmf send payload to 101 recv payload to 101
  691. 2024-12-16 13:10:33.435278 98.00% [DEBUG] sofia.c:7927 (sofia/default/318002666436@185.249.40.236:5060) State Change CS_NEW -> CS_INIT
  692. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:600 (sofia/default/318002666436@185.249.40.236:5060) State NEW
  693. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_INIT (Cur 19 Tot 1669)
  694. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/318002666436@185.249.40.236:5060) State INIT
  695. 2024-12-16 13:10:33.435278 98.00% [DEBUG] mod_sofia.c:97 sofia/default/318002666436@185.249.40.236:5060 SOFIA INIT
  696. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:40 sofia/default/318002666436@185.249.40.236:5060 Standard INIT
  697. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:48 (sofia/default/318002666436@185.249.40.236:5060) State Change CS_INIT -> CS_ROUTING
  698. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/318002666436@185.249.40.236:5060) State INIT going to sleep
  699. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_ROUTING (Cur 19 Tot 1669)
  700. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_channel.c:2399 (sofia/default/318002666436@185.249.40.236:5060) Callstate Change DOWN -> RINGING
  701. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/318002666436@185.249.40.236:5060) State ROUTING
  702. 2024-12-16 13:10:33.435278 98.00% [DEBUG] mod_sofia.c:158 sofia/default/318002666436@185.249.40.236:5060 SOFIA ROUTING
  703. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_core_state_machine.c:230 sofia/default/318002666436@185.249.40.236:5060 Standard ROUTING
  704. 2024-12-16 13:10:33.435278 98.00% [INFO] mod_dialplan_xml.c:639 Processing TEST <318002666436>-><null>31626673579 in context default
  705. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  706. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  707. 2024-12-16 13:10:33.435278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  708. 2024-12-16 13:10:33.435278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : <null>31626673579
  709. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '<null>31626673579' limit 1
  710. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '<null>31626673579' AND status=0 limit 1
  711. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '<null>31626673579' and status=0 LIMIT 1
  712. 2024-12-16 13:10:33.435278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 318002666436 / 318002666436
  713. 2024-12-16 13:10:33.435278 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="<null>31626673579" LIMIT 1
  714. 2024-12-16 13:10:33.435278 98.00% [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 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="<null>31626673579"  AND domains.domain="00133897.yoursipcloud.com" limit 1
  715. 2024-12-16 13:10:33.435278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  716. 2024-12-16 13:10:33.435278 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 263083]
  717. 2024-12-16 13:10:33.435278 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "263083" AND deleted = 0 limit 1
  718. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^<null>31626673579.*' OR blocked_patterns = '^<null>3162667357.*' OR blocked_patterns = '^<null>316266735.*' OR blocked_patterns = '^<null>31626673.*' OR blocked_patterns = '^<null>3162667.*' OR blocked_patterns = '^<null>316266.*' OR blocked_patterns = '^<null>31626.*' OR blocked_patterns = '^<null>3162.*' OR blocked_patterns = '^<null>316.*' OR blocked_patterns = '^<null>31.*' OR blocked_patterns = '^<null>3.*' OR blocked_patterns = '^<null>.*' OR blocked_patterns = '^<null.*' OR blocked_patterns = '^<nul.*' OR blocked_patterns = '^<nu.*' OR blocked_patterns = '^<n.*' OR blocked_patterns = '^<.*' OR blocked_patterns ='--') AND accountid = 1061 limit 1
  719. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="<null>31626673579" AND (accountid = 0 OR status = 1) LIMIT 1
  720. 2024-12-16 13:10:33.455286 98.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 1
  721. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate,dst_base_cid FROM localization WHERE id = 1 AND status=0 limit 1
  722. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/31,+/".....<null>31626673579
  723. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/31,+/".....<null>31626673579
  724. 2024-12-16 13:10:33.455286 98.00% [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 = '^<null>31626673579.*' OR patterns = '^<null>3162667357.*' OR patterns = '^<null>316266735.*' OR patterns = '^<null>31626673.*' OR patterns = '^<null>3162667.*' OR patterns = '^<null>316266.*' OR patterns = '^<null>31626.*' OR patterns = '^<null>3162.*' OR patterns = '^<null>316.*' OR patterns = '^<null>31.*' OR patterns = '^<null>3.*' OR patterns = '^<null>.*' OR patterns = '^<null.*' OR patterns = '^<nul.*' OR patterns = '^<nu.*' OR patterns = '^<n.*' OR patterns = '^<.*' OR patterns ='--') AND accountid = 1061 ORDER BY LENGTH(PKGPTR.patterns) DESC
  725. 2024-12-16 13:10:33.455286 98.00% [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 ="<null>31626673579" AND A.accountid = '1061' limit 1
  726. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : <null>31626673579
  727. 2024-12-16 13:10:33.455286 98.00% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="<null>31626673579" LIMIT 1
  728. 2024-12-16 13:10:33.455286 98.00% [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 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="<null>31626673579"  AND domains.domain="00133897.yoursipcloud.com" limit 1
  729. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
  730. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '<null>31626673579' OR number = '<null>3162667357' OR number = '<null>316266735' OR number = '<null>31626673' OR number = '<null>3162667' OR number = '<null>316266' OR number = '<null>31626' OR number = '<null>3162' OR number = '<null>316' OR number = '<null>31' OR number = '<null>3' OR number = '<null>' OR number = '<null' OR number = '<nul' OR number = '<nu' OR number = '<n' OR number = '<' OR number ='--') OR (number = '<null>31626673579*' OR number = '<null>3162667357*' OR number = '<null>316266735*' OR number = '<null>31626673*' OR number = '<null>3162667*' OR number = '<null>316266*' OR number = '<null>31626*' OR number = '<null>3162*' OR number = '<null>316*' OR number = '<null>31*' OR number = '<null>3*' OR number = '<null>*' OR number = '<null*' OR number = '<nul*' OR number = '<nu*' OR number = '<n*' OR number = '<*' OR number ='--') OR (number = '318002666436' OR number = '31800266643' OR number = '3180026664' OR number = '318002666' OR number = '31800266' OR number = '3180026' OR number = '318002' OR number = '31800' OR number = '3180' OR number = '318' OR number = '31' OR number = '3' OR number ='--') OR (number = '318002666436*' OR number = '31800266643*' OR number = '3180026664*' OR number = '318002666*' OR number = '31800266*' OR number = '3180026*' OR number = '318002*' OR number = '31800*' OR number = '3180*' OR number = '318*' OR number = '31*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  731. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  732. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '<null>31626673579' OR routing_prefix = '<null>3162667357' OR routing_prefix = '<null>316266735' OR routing_prefix = '<null>31626673' OR routing_prefix = '<null>3162667' OR routing_prefix = '<null>316266' OR routing_prefix = '<null>31626' OR routing_prefix = '<null>3162' OR routing_prefix = '<null>316' OR routing_prefix = '<null>31' OR routing_prefix = '<null>3' OR routing_prefix = '<null>' OR routing_prefix = '<null' OR routing_prefix = '<nul' OR routing_prefix = '<nu' OR routing_prefix = '<n' OR routing_prefix = '<' OR routing_prefix ='--') AND status = 0 and reseller_id = 12 limit 1
  733. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  734. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 1061
  735. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 263083
  736. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 8.614
  737. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  738. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 6
  739. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  740. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  741. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 6 AND status = 0
  742. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
  743. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 6 AND status = 0
  744. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^<null>31626673579.*' OR pattern = '^<null>3162667357.*' OR pattern = '^<null>316266735.*' OR pattern = '^<null>31626673.*' OR pattern = '^<null>3162667.*' OR pattern = '^<null>316266.*' OR pattern = '^<null>31626.*' OR pattern = '^<null>3162.*' OR pattern = '^<null>316.*' OR pattern = '^<null>31.*' OR pattern = '^<null>3.*' OR pattern = '^<null>.*' OR pattern = '^<null.*' OR pattern = '^<nul.*' OR pattern = '^<nu.*' OR pattern = '^<n.*' OR pattern = '^<.*' OR pattern ='--') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 6 OR accountid=1061)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  745. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : outbound
  746. 2024-12-16 13:10:33.455286 98.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Rates Not Found :
  747. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  Post Cdrs : 0
  748. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 1061
  749. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  750. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  751. <document type="freeswitch/xml">
  752. <section name="dialplan" description="ASTPP Dialplan">
  753. <context name="default">
  754. <extension name="<null>31626673579">
  755. <condition field="destination_number" expression="<null>31626673579">
  756. <action application="log" data="WARNING Accountcode . Dialed number (<null>31626673579)  origination rates not found!!"/>
  757. <action application="playback" data="/usr/share/freeswitch/sounds/en/us/callie/astpp-badphone.wav"/>
  758. <action application="set" data="original_caller_id_name=318002666436"/>
  759. <action application="set" data="original_caller_id_number=318002666436"/>
  760. <action application="set" data="error_cdr=1"/>
  761. <action application="set" data="callstart=2024-12-16 13:10:33"/>
  762. <action application="set" data="account_id=1061"/>
  763. <action application="set" data="parent_id=12"/>
  764. <action application="set" data="call_direction=outbound"/>
  765. <action application="set" data="sip_ignore_remote_cause=true"/>
  766. <action application="set" data="call_processed=internal"/>
  767. <action application="set" data="effective_destination_number=<null>31626673579"/>
  768. <action application="set" data="last_bridge_hangup_cause=ORIGINATION_RATE_NOT_FOUND"/>
  769. <action application="hangup" data="ORIGINATION_RATE_NOT_FOUND"/>
  770. </condition>
  771. </extension>
  772. </context>
  773. </document>
  774. Dialplan: sofia/default/318002666436@185.249.40.236:5060 parsing [default-><null>31626673579] continue=false
  775. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Regex (PASS) [<null>31626673579] destination_number(<null>31626673579) =~ /<null>31626673579/ break=on-false
  776. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action log(WARNING Accountcode . Dialed number (<null>31626673579)  origination rates not found!!)
  777. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action playback(/usr/share/freeswitch/sounds/en/us/callie/astpp-badphone.wav)
  778. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(original_caller_id_name=318002666436)
  779. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(original_caller_id_number=318002666436)
  780. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(error_cdr=1)
  781. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(callstart=2024-12-16 13:10:33)
  782. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(account_id=1061)
  783. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(parent_id=12)
  784. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(call_direction=outbound)
  785. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(sip_ignore_remote_cause=true)
  786. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(call_processed=internal)
  787. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(effective_destination_number=<null>31626673579)
  788. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action set(last_bridge_hangup_cause=ORIGINATION_RATE_NOT_FOUND)
  789. Dialplan: sofia/default/318002666436@185.249.40.236:5060 Action hangup(ORIGINATION_RATE_NOT_FOUND)
  790. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_state_machine.c:281 (sofia/default/318002666436@185.249.40.236:5060) State Change CS_ROUTING -> CS_EXECUTE
  791. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/318002666436@185.249.40.236:5060) State ROUTING going to sleep
  792. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_EXECUTE (Cur 19 Tot 1669)
  793. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/318002666436@185.249.40.236:5060) State EXECUTE
  794. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_sofia.c:213 sofia/default/318002666436@185.249.40.236:5060 SOFIA EXECUTE
  795. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_state_machine.c:323 sofia/default/318002666436@185.249.40.236:5060 Standard EXECUTE
  796. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 log(WARNING Accountcode . Dialed number (<null>31626673579)  origination rates not found!!)
  797. 2024-12-16 13:10:33.455286 98.00% [WARNING] mod_dptools.c:1865 Accountcode . Dialed number (<null>31626673579)  origination rates not found!!
  798. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_session.c:2791 Application playback Requires media! pre_answering channel sofia/default/318002666436@185.249.40.236:5060
  799. 2024-12-16 13:10:33.455286 98.00% [INFO] switch_core_session.c:2793 Sending early media
  800. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_media.c:8659 AUDIO RTP [sofia/default/318002666436@185.249.40.236:5060] 185.249.40.236 port 24510 -> 185.249.40.236 port 22940 codec: 8 ms: 20
  801. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_rtp.c:4373 Starting timer [soft] 160 bytes per 20ms
  802. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_media.c:8972 sofia/default/318002666436@185.249.40.236:5060 Set 2833 dtmf send payload to 101
  803. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_media.c:8979 sofia/default/318002666436@185.249.40.236:5060 Set 2833 dtmf receive payload to 101
  804. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_core_media.c:9002 sofia/default/318002666436@185.249.40.236:5060 Set rtp dtmf delay to 40
  805. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_sofia.c:2607 Ring SDP:
  806. v=0
  807. o=FreeSWITCH 1734330123 1734330124 IN IP4 185.249.40.236
  808. s=FreeSWITCH
  809. c=IN IP4 185.249.40.236
  810. t=0 0
  811. m=audio 24510 RTP/AVP 8 101
  812. a=rtpmap:8 PCMA/8000
  813. a=rtpmap:101 telephone-event/8000
  814. a=fmtp:101 0-15
  815. a=ptime:20
  816. a=sendrecv
  817.  
  818. 2024-12-16 13:10:33.455286 98.00% [NOTICE] mod_sofia.c:2610 Pre-Answer sofia/default/318002666436@185.249.40.236:5060!
  819. 2024-12-16 13:10:33.455286 98.00% [DEBUG] switch_channel.c:3585 (sofia/default/318002666436@185.249.40.236:5060) Callstate Change RINGING -> EARLY
  820. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 playback(/usr/share/freeswitch/sounds/en/us/callie/astpp-badphone.wav)
  821. 2024-12-16 13:10:33.455286 98.00% [WARNING] mod_sndfile.c:281 Error Opening File [/usr/share/freeswitch/sounds/en/us/callie/astpp-badphone.wav] [System error : No such file or directory.]
  822. 2024-12-16 13:10:33.455286 98.00% [DEBUG] sofia.c:7493 Channel sofia/default/318002666436@185.249.40.236:5060 entering state [early][183]
  823. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(original_caller_id_name=318002666436)
  824. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [original_caller_id_name]=[318002666436]
  825. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(original_caller_id_number=318002666436)
  826. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [original_caller_id_number]=[318002666436]
  827. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(error_cdr=1)
  828. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [error_cdr]=[1]
  829. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(callstart=2024-12-16 13:10:33)
  830. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [callstart]=[2024-12-16 13:10:33]
  831. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(account_id=1061)
  832. 2024-12-16 13:10:33.455286 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [account_id]=[1061]
  833. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(parent_id=12)
  834. 2024-12-16 13:10:33.475277 98.00% [DEBUG] sofia.c:7493 Channel sofia/default/31626673579@00133897.yoursipcloud.com:5060 entering state [proceeding][183]
  835. 2024-12-16 13:10:33.475277 98.00% [DEBUG] sofia.c:7503 Remote SDP:
  836. v=0
  837. o=FreeSWITCH 1734330123 1734330124 IN IP4 185.249.40.236
  838. s=FreeSWITCH
  839. c=IN IP4 185.249.40.236
  840. t=0 0
  841. m=audio 24510 RTP/AVP 8 101
  842. a=rtpmap:8 PCMA/8000
  843. a=rtpmap:101 telephone-event/8000
  844. a=fmtp:101 0-15
  845. a=ptime:20
  846.  
  847. 2024-12-16 13:10:33.475277 98.00% [NOTICE] sofia.c:7506 Pre-Answer sofia/default/31626673579@00133897.yoursipcloud.com:5060!
  848. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [parent_id]=[12]
  849. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(call_direction=outbound)
  850. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [call_direction]=[outbound]
  851. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_channel.c:3585 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Callstate Change DOWN -> EARLY
  852. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(sip_ignore_remote_cause=true)
  853. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  854. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  855. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:5438 Set telephone-event payload to 101@8000
  856. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:3734 Set Codec sofia/default/31626673579@00133897.yoursipcloud.com:5060 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  857. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_codec.c:111 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Original read codec set to PCMA:8
  858. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [sip_ignore_remote_cause]=[true]
  859. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:5798 Set telephone-event payload to 101@8000
  860. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:5856 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Set 2833 dtmf send payload to 101 recv payload to 101
  861. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:8659 AUDIO RTP [sofia/default/31626673579@00133897.yoursipcloud.com:5060] 185.249.40.236 port 22940 -> 185.249.40.236 port 24510 codec: 8 ms: 20
  862. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(call_processed=internal)
  863. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_rtp.c:4373 Starting timer [soft] 160 bytes per 20ms
  864. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [call_processed]=[internal]
  865. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(effective_destination_number=<null>31626673579)
  866. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [effective_destination_number]=[<null>31626673579]
  867. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 set(last_bridge_hangup_cause=ORIGINATION_RATE_NOT_FOUND)
  868. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/318002666436@185.249.40.236:5060 [last_bridge_hangup_cause]=[ORIGINATION_RATE_NOT_FOUND]
  869. EXECUTE [depth=0] sofia/default/318002666436@185.249.40.236:5060 hangup(ORIGINATION_RATE_NOT_FOUND)
  870. 2024-12-16 13:10:33.475277 98.00% [NOTICE] mod_dptools.c:1374 Hangup sofia/default/318002666436@185.249.40.236:5060 [CS_EXECUTE] [NORMAL_CLEARING]
  871. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_session.c:2979 sofia/default/318002666436@185.249.40.236:5060 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already)
  872. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:8972 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Set 2833 dtmf send payload to 101
  873. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/318002666436@185.249.40.236:5060) State EXECUTE going to sleep
  874. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:8979 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Set 2833 dtmf receive payload to 101
  875. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_HANGUP (Cur 19 Tot 1669)
  876. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_media.c:9002 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Set rtp dtmf delay to 40
  877. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:844 (sofia/default/318002666436@185.249.40.236:5060) Callstate Change EARLY -> HANGUP
  878. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/318002666436@185.249.40.236:5060) State HANGUP
  879. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:469 Channel sofia/default/318002666436@185.249.40.236:5060 hanging up, cause: NORMAL_CLEARING
  880. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:614 Responding to INVITE with: 480
  881. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:59 sofia/default/318002666436@185.249.40.236:5060 Standard HANGUP, cause: NORMAL_CLEARING
  882. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/318002666436@185.249.40.236:5060) State HANGUP going to sleep
  883. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:616 (sofia/default/318002666436@185.249.40.236:5060) State Change CS_HANGUP -> CS_REPORTING
  884. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_REPORTING (Cur 19 Tot 1669)
  885. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/318002666436@185.249.40.236:5060) State REPORTING
  886. 2024-12-16 13:10:33.475277 98.00% [INFO] mod_json_cdr.c:272 Process [6ee6b425-d7a1-4dab-af7d-d7722a62ecb1.cdr.json]
  887. 2024-12-16 13:10:33.475277 98.00% [DEBUG] sofia.c:6672 Remote Reason: 16
  888. 2024-12-16 13:10:33.475277 98.00% [DEBUG] sofia.c:7493 Channel sofia/default/31626673579@00133897.yoursipcloud.com:5060 entering state [terminated][480]
  889. 2024-12-16 13:10:33.475277 98.00% [NOTICE] sofia.c:8735 Hangup sofia/default/31626673579@00133897.yoursipcloud.com:5060 [CS_CONSUME_MEDIA] [NORMAL_CLEARING]
  890. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Running State Change CS_HANGUP (Cur 19 Tot 1669)
  891. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:844 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Callstate Change EARLY -> HANGUP
  892. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State HANGUP
  893. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:469 Channel sofia/default/31626673579@00133897.yoursipcloud.com:5060 hanging up, cause: NORMAL_CLEARING
  894. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:59 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Standard HANGUP, cause: NORMAL_CLEARING
  895. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State HANGUP going to sleep
  896. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:616 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State Change CS_HANGUP -> CS_REPORTING
  897. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Running State Change CS_REPORTING (Cur 19 Tot 1669)
  898. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State REPORTING
  899. 2024-12-16 13:10:33.475277 98.00% [INFO] mod_json_cdr.c:272 Process [d26a1f01-ab81-4459-9112-353da36a8170.cdr.json]
  900. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:168 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Standard REPORTING, cause: NORMAL_CLEARING
  901. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State REPORTING going to sleep
  902. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:607 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State Change CS_REPORTING -> CS_DESTROY
  903. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_session.c:1744 Session 1668 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Locked, Waiting on external entities
  904. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_ivr_originate.c:4052 Originate Resulted in Error Cause: 16 [NORMAL_CLEARING]
  905. 2024-12-16 13:10:33.475277 98.00% [NOTICE] switch_core_session.c:1762 Session 1668 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Ended
  906. 2024-12-16 13:10:33.475277 98.00% [NOTICE] switch_core_session.c:1766 Close Channel sofia/default/31626673579@00133897.yoursipcloud.com:5060 [CS_DESTROY]
  907. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:735 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) Running State Change CS_DESTROY (Cur 18 Tot 1669)
  908. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State DESTROY
  909. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:380 sofia/default/31626673579@00133897.yoursipcloud.com:5060 SOFIA DESTROY
  910. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:175 sofia/default/31626673579@00133897.yoursipcloud.com:5060 Standard DESTROY
  911. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/31626673579@00133897.yoursipcloud.com:5060) State DESTROY going to sleep
  912. 2024-12-16 13:10:33.475277 98.00% [INFO] mod_dptools.c:3635 Originate Failed.  Cause: NORMAL_CLEARING
  913. EXECUTE [depth=0] sofia/default/1234@00133897.yoursipcloud.com set(original_did_number=1884)
  914. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_dptools.c:1671 SET sofia/default/1234@00133897.yoursipcloud.com [original_did_number]=[1884]
  915. 2024-12-16 13:10:33.475277 98.00% [NOTICE] switch_core_state_machine.c:382 sofia/default/1234@00133897.yoursipcloud.com has executed the last dialplan instruction, hanging up.
  916. 2024-12-16 13:10:33.475277 98.00% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/1234@00133897.yoursipcloud.com [CS_EXECUTE] [NORMAL_CLEARING]
  917. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/1234@00133897.yoursipcloud.com) State EXECUTE going to sleep
  918. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_HANGUP (Cur 18 Tot 1669)
  919. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:844 (sofia/default/1234@00133897.yoursipcloud.com) Callstate Change RINGING -> HANGUP
  920. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1234@00133897.yoursipcloud.com) State HANGUP
  921. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:463 sofia/default/1234@00133897.yoursipcloud.com Overriding SIP cause 480 with 480 from the other leg
  922. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:469 Channel sofia/default/1234@00133897.yoursipcloud.com hanging up, cause: NORMAL_CLEARING
  923. 2024-12-16 13:10:33.475277 98.00% [DEBUG] mod_sofia.c:614 Responding to INVITE with: 480
  924. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:59 sofia/default/1234@00133897.yoursipcloud.com Standard HANGUP, cause: NORMAL_CLEARING
  925. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:846 (sofia/default/1234@00133897.yoursipcloud.com) State HANGUP going to sleep
  926. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:616 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_HANGUP -> CS_REPORTING
  927. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_REPORTING (Cur 18 Tot 1669)
  928. 2024-12-16 13:10:33.475277 98.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1234@00133897.yoursipcloud.com) State REPORTING
  929. 2024-12-16 13:10:33.475277 98.00% [INFO] mod_json_cdr.c:272 Process [cef11b45-f79f-4ae3-98d8-7e10f9a444c4.cdr.json]
  930. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:168 sofia/default/318002666436@185.249.40.236:5060 Standard REPORTING, cause: NORMAL_CLEARING
  931. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/318002666436@185.249.40.236:5060) State REPORTING going to sleep
  932. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:607 (sofia/default/318002666436@185.249.40.236:5060) State Change CS_REPORTING -> CS_DESTROY
  933. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_session.c:1744 Session 1669 (sofia/default/318002666436@185.249.40.236:5060) Locked, Waiting on external entities
  934. 2024-12-16 13:10:33.535280 98.00% [NOTICE] switch_core_session.c:1762 Session 1669 (sofia/default/318002666436@185.249.40.236:5060) Ended
  935. 2024-12-16 13:10:33.535280 98.00% [NOTICE] switch_core_session.c:1766 Close Channel sofia/default/318002666436@185.249.40.236:5060 [CS_DESTROY]
  936. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:735 (sofia/default/318002666436@185.249.40.236:5060) Running State Change CS_DESTROY (Cur 17 Tot 1669)
  937. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/318002666436@185.249.40.236:5060) State DESTROY
  938. 2024-12-16 13:10:33.535280 98.00% [DEBUG] mod_sofia.c:380 sofia/default/318002666436@185.249.40.236:5060 SOFIA DESTROY
  939. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:175 sofia/default/318002666436@185.249.40.236:5060 Standard DESTROY
  940. 2024-12-16 13:10:33.535280 98.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/318002666436@185.249.40.236:5060) State DESTROY going to sleep
  941. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:168 sofia/default/1234@00133897.yoursipcloud.com Standard REPORTING, cause: NORMAL_CLEARING
  942. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:932 (sofia/default/1234@00133897.yoursipcloud.com) State REPORTING going to sleep
  943. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:607 (sofia/default/1234@00133897.yoursipcloud.com) State Change CS_REPORTING -> CS_DESTROY
  944. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_session.c:1744 Session 1667 (sofia/default/1234@00133897.yoursipcloud.com) Locked, Waiting on external entities
  945. 2024-12-16 13:10:33.555279 98.00% [NOTICE] switch_core_session.c:1762 Session 1667 (sofia/default/1234@00133897.yoursipcloud.com) Ended
  946. 2024-12-16 13:10:33.555279 98.00% [NOTICE] switch_core_session.c:1766 Close Channel sofia/default/1234@00133897.yoursipcloud.com [CS_DESTROY]
  947. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:735 (sofia/default/1234@00133897.yoursipcloud.com) Running State Change CS_DESTROY (Cur 16 Tot 1669)
  948. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1234@00133897.yoursipcloud.com) State DESTROY
  949. 2024-12-16 13:10:33.555279 98.00% [DEBUG] mod_sofia.c:380 sofia/default/1234@00133897.yoursipcloud.com SOFIA DESTROY
  950. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:175 sofia/default/1234@00133897.yoursipcloud.com Standard DESTROY
  951. 2024-12-16 13:10:33.555279 98.00% [DEBUG] switch_core_state_machine.c:745 (sofia/default/1234@00133897.yoursipcloud.com) State DESTROY going to sleep
  952.