FreeSWITCH Pastebin

Caller ID

From Commodious Partdridge, 3 Weeks ago, written in HTML5.
- view diff
URL https://pastebin.freeswitch.org/view/646382e3
Embed
Download Paste or View Raw
  1. +OK log level  [7]
  2. 2024-10-29 10:05:51.633543 99.00% [NOTICE] switch_channel.c:1123 New Channel sofia/default/27876300012@196.7.219.43:8356 [d95650a3-b85c-46a8-9da4-5a4dfb3fb23c]
  3. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_NEW (Cur 3 Tot 42400)
  4. 2024-10-29 10:05:51.633543 99.00% [INFO] sofia.c:10462 sofia/default/27876300012@196.7.219.43:8356 receiving invite from 102.220.232.100:5060 version: 1.10.7 -release 64bit call-id: dd3b41e2-c65ea80-9a68c5b4-2d4c08ee
  5. 2024-10-29 10:05:51.633543 99.00% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 102.220.232.100:0.
  6. 2024-10-29 10:05:51.633543 99.00% [DEBUG] sofia.c:10585 IP 102.220.232.100 Approved by acl "default[]". Access Granted.
  7. 2024-10-29 10:05:51.633543 99.00% [DEBUG] sofia.c:7499 Channel sofia/default/27876300012@196.7.219.43:8356 entering state [received][100]
  8. 2024-10-29 10:05:51.633543 99.00% [DEBUG] sofia.c:7509 Remote SDP:
  9. v=0
  10. o=bk 598470 1 IN IP4 196.7.219.43                                                                                                                                                                                  
  11. s=-                                                                                                                                                                                                                
  12. c=IN IP4 196.7.219.43                                                                                                                                                                                              
  13. t=0 0                                                                                                                                                                                                              
  14. m=audio 46176 RTP/AVP 8 18 0 101                                                                                                                                                                                  
  15. a=rtpmap:8 PCMA/8000                                                                                                                                                                                              
  16. a=rtpmap:18 G729/8000                                                                                                                                                                                              
  17. a=fmtp:18 annexb=no                                                                                                                                                                                                
  18. a=rtpmap:0 PCMU/8000                                                                                                                                                                                              
  19. a=rtpmap:101 telephone-event/8000                                                                                                                                                                                  
  20. a=fmtp:101 0-16                                                                                                                                                                                                    
  21. a=ptime:20                                                                                                                                                                                                        
  22. a=ptime:20                                                                                                                                                                                                        
  23. a=ptime:20                                                                                                                                                                                                        
  24.  
  25. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  26. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  27. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  28. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  29. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G722:9:8000:20:64000:1]
  30. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1]
  31. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1]
  32. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[G729:18:8000:20:8000:1]
  33. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [G729:18:8000:20:8000:1] ++++ is saved as a match
  34. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[G722:9:8000:20:64000:1]
  35. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  36. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  37. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  38. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  39. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G722:9:8000:20:64000:1]
  40. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  41. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/27876300012@196.7.219.43:8356 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  42. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_codec.c:111 sofia/default/27876300012@196.7.219.43:8356 Original read codec set to PCMA:8
  43. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  44. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_media.c:5973 sofia/default/27876300012@196.7.219.43:8356 Set 2833 dtmf send payload to 101 recv payload to 101
  45. 2024-10-29 10:05:51.633543 99.00% [DEBUG] sofia.c:7933 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_NEW -> CS_INIT
  46. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:600 (sofia/default/27876300012@196.7.219.43:8356) State NEW
  47. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_INIT (Cur 3 Tot 42400)
  48. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/27876300012@196.7.219.43:8356) State INIT
  49. 2024-10-29 10:05:51.633543 99.00% [DEBUG] mod_sofia.c:97 sofia/default/27876300012@196.7.219.43:8356 SOFIA INIT
  50. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:40 sofia/default/27876300012@196.7.219.43:8356 Standard INIT
  51. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:48 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_INIT -> CS_ROUTING
  52. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:624 (sofia/default/27876300012@196.7.219.43:8356) State INIT going to sleep
  53. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_ROUTING (Cur 3 Tot 42400)
  54. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_channel.c:2380 (sofia/default/27876300012@196.7.219.43:8356) Callstate Change DOWN -> RINGING
  55. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/27876300012@196.7.219.43:8356) State ROUTING
  56. 2024-10-29 10:05:51.633543 99.00% [DEBUG] mod_sofia.c:158 sofia/default/27876300012@196.7.219.43:8356 SOFIA ROUTING
  57. 2024-10-29 10:05:51.633543 99.00% [DEBUG] switch_core_state_machine.c:230 sofia/default/27876300012@196.7.219.43:8356 Standard ROUTING
  58. 2024-10-29 10:05:51.633543 99.00% [INFO] mod_dialplan_xml.c:639 Processing Ext 112 <27876300012>->27876303962 in context default
  59. 2024-10-29 10:05:51.673539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  60. 2024-10-29 10:05:51.713543 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  61. 2024-10-29 10:05:51.713543 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')                                                                                                                                                                                                
  62. 2024-10-29 10:05:51.713543 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  63. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 27876303962
  64. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '27876303962' AND status=0 limit 1
  65. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER27876300012
  66. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  67. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '27876303962' limit 1
  68. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '467' and username = '27876303962' limit 1
  69. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL] Query :SELECT local_effective_caller_id_name,local_effective_caller_id_number FROM sip_devices WHERE username = '27876300012' limit 1                                                                                                                                                                                                  
  70. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan COMINNG] Caller Id name / number : 27876300012 / 27876300012
  71. 2024-10-29 10:05:51.753542 99.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  72. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 27876300012 / 27876300012
  73. 2024-10-29 10:05:51.753542 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id: 43
  74. 2024-10-29 10:05:51.753542 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  75. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  76. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  77. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  78. 2024-10-29 10:05:51.753542 99.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, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="27876303962" LIMIT 1                                    
  79. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  80. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  81. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 196.7.219.43
  82. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 8773282952]
  83. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "8773282952" OR id = "8773282952") AND deleted = 0 limit 1
  84. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  85. 2024-10-29 10:05:51.753542 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id : 43
  86. 2024-10-29 10:05:51.753542 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  87. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  88. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  89. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  90. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="27876303962" AND (accountid = 0 OR status = 1) LIMIT 1
  91. 2024-10-29 10:05:51.753542 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 55
  92. 2024-10-29 10:05:51.753542 99.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 = 55 AND status=0 limit 1                                                                                                                                                                                          
  93. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  94. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 467
  95. 2024-10-29 10:05:51.753542 99.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 = '^27876303962.*' OR patterns = '^2787630396.*' OR patterns = '^278763039.*' OR patterns = '^27876303.*' OR patterns = '^2787630.*' OR patterns = '^278763.*' OR patterns = '^27876.*' OR patterns = '^2787.*' OR patterns = '^278.*' OR patterns = '^27.*' OR patterns = '^2.*' OR patterns ='--') AND accountid = 467 ORDER BY LENGTH(PKGPTR.patterns) DESC                                                                                                                                                                                                            
  96. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Package ID : 879
  97. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Product ID : 307
  98. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from products WHERE id = 307 AND status = 0
  99. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Apply On Rategroups For Free Product :
  100. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Package Type : 1 Call Direction : inbound [0:inbound,1:outbound,2:both]
  101. 2024-10-29 10:05:51.753542 99.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 ="27876303962" AND A.accountid = '419' limit 1                                                                                                                                                                
  102. 2024-10-29 10:05:51.753542 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 27876303962
  103. 2024-10-29 10:05:51.753542 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id: 43
  104. 2024-10-29 10:05:51.753542 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  105. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  106. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  107. 2024-10-29 10:05:51.753542 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  108. 2024-10-29 10:05:51.753542 99.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, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="27876303962" LIMIT 1                                    
  109. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  110. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  111. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '27876303962' OR number = '2787630396' OR number = '278763039' OR number = '27876303' OR number = '2787630' OR number = '278763' OR number = '27876' OR number = '2787' OR number = '278' OR number = '27' OR number = '2' OR number ='--') OR (number = '27876303962*' OR number = '2787630396*' OR number = '278763039*' OR number = '27876303*' OR number = '2787630*' OR number = '278763*' OR number = '27876*' OR number = '2787*' OR number = '278*' OR number = '27*' OR number = '2*' OR number ='--') OR (number = '27876300012' OR number = '2787630001' OR number = '278763000' OR number = '27876300' OR number = '2787630' OR number = '278763' OR number = '27876' OR number = '2787' OR number = '278' OR number = '27' OR number = '2' OR number ='--') OR (number = '27876300012*' OR number = '2787630001*' OR number = '278763000*' OR number = '27876300*' OR number = '2787630*' OR number = '278763*' OR number = '27876*' OR number = '2787*' OR number = '278*' OR number = '27*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC                                                                                                                                                                                  
  112. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  113. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '27876303962' OR routing_prefix = '2787630396' OR routing_prefix = '278763039' OR routing_prefix = '27876303' OR routing_prefix = '2787630' OR routing_prefix = '278763' OR routing_prefix = '27876' OR routing_prefix = '2787' OR routing_prefix = '278' OR routing_prefix = '27' OR routing_prefix = '2' OR routing_prefix ='--') AND status = 0 and reseller_id = 405 limit 1                                                                          
  114. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  115. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 419
  116. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 8773282952
  117. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  118. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 8.9478
  119. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  120. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 187
  121. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 8
  122. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  123. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 187 AND status = 0
  124. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  125. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :43.....27876303962
  126. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_RESELLER] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.connectcost,A.includedseconds,A.cost,C.reseller_cost as reseller_cost ,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination,D.id as product_id FROM dids AS A,accounts AS B, reseller_products AS C, products AS D WHERE B.status=0 AND B.deleted=0 AND A.product_id=C.product_id AND A.parent_id=C.account_id AND B.id=A.accountid AND A.number ="27876303962" LIMIT 1                                                                                                              
  127. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  128. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  129. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 203
  130. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  131. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  132. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  133. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : George Western Cape
  134. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 171
  135. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 419
  136. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  137. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  138. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your8.9478 balance Accountid 419 !!!
  139. 2024-10-29 10:05:51.773539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  140. 2024-10-29 10:05:51.773539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 405
  141. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "405" OR number = "405") AND deleted = 0 limit 1
  142. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  143. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  144. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 405
  145. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 6840389175
  146. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  147. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 8.9478
  148. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  149. 2024-10-29 10:05:51.773539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 189
  150. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 189 AND status = 0
  151. 2024-10-29 10:05:51.773539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  152. 2024-10-29 10:05:51.773539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id: 43
  153. 2024-10-29 10:05:51.773539 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  154. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  155. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  156. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27876303962
  157. 2024-10-29 10:05:51.793538 99.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, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="27876303962" LIMIT 1                                    
  158. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  159. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  160. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  161. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 203
  162. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  163. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  164. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  165. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : George Western Cape
  166. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 171
  167. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 405
  168. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  169. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  170. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your8.9478 balance Accountid 405 !!!
  171. 2024-10-29 10:05:51.793538 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  172. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] check_routing_type for resellers origination rates  
  173. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:467||ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:405                                                                                                                                                                                        
  174. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  175. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 0
  176. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 60 minutes
  177. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  178. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  179. 2024-10-29 10:05:51.793538 99.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 = 419 AND status=0 LIMIT 1                                                                                                                                                                                      
  180. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (id = "467" OR number = "467") AND deleted = 0 limit 1
  181. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] account call balance :SELECT * FROM accounts WHERE id =467
  182. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:419
  183. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:419
  184. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 419
  185. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 60
  186. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_sip_device_info_for_did_pstn_call] Query :SELECT username FROM sip_devices WHERE username = '27876300012' and status = 0 limit 1
  187. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  188. 2024-10-29 10:05:51.793538 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 0
  189. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_4
  190. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  191. <document type="freeswitch/xml">                                                                                                                                                                                  
  192. <section name="dialplan" description="ASTPP Dialplan">                                                                                                                                                            
  193. <context name="default">                                                                                                                                                                                          
  194. <extension name="27876303962">                                                                                                                                                                                    
  195. <condition field="destination_number" expression="27876303962">                                                                                                                                                    
  196. <action application="set" data="effective_destination_number=27876303962"/>                                                                                                                                        
  197. <action application="set" data="execute_on_answer_1=sched_hangup +3600 normal_clearing"/>                                                                                                                          
  198. <action application="set" data="notify_flag=0"/>                                                                                                                                                                  
  199. <action application="set" data="notify_credit_limit=450.00000"/>                                                                                                                                                  
  200. <action application="set" data="type=0"/>                                                                                                                                                                          
  201. <action application="set" data="callstart=2024-10-29 10:05:51"/>                                                                                                                                                  
  202. <action application="set" data="hangup_after_bridge=true"/>                                                                                                                                                        
  203. <action application="set" data="continue_on_fail=TRUE"/>                                                                                                                                                          
  204. <action application="set" data="account_id=419"/>                                                                                                                                                                  
  205. <action application="set" data="parent_id=405"/>                                                                                                                                                                  
  206. <action application="set" data="entity_id=0"/>                                                                                                                                                                    
  207. <action application="set" data="call_processed=internal"/>                                                                                                                                                        
  208. <action application="set" data="call_direction=inbound"/>                                                                                                                                                          
  209. <action application="set" data="accountname=default"/>                                                                                                                                                            
  210. <action application="set" data="origination_rates_did=ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:467||ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:405"/>          
  211. <action application="set" data="origination_rates=0"/>                                                                                                                                                            
  212. <action application="set" data="original_caller_id_name=27876300012"/>                                                                                                                                            
  213. <action application="set" data="original_caller_id_number=27876300012"/>                                                                                                                                          
  214. <action application="limit" data="db 8773282952 user_8773282952 16 "/>                                                                                                                                            
  215. <action application="export" data="is_recording=1"/>                                                                                                                                                              
  216. <action application="export" data="media_bug_answer_req=true"/>                                                                                                                                                    
  217. <action application="export" data="record_sample_rate=8000"/>                                                                                                                                                      
  218. <action application="export" data="execute_on_answer_2=record_session $${recordings_dir}/${uuid}.wav"/>                                                                                                            
  219. <action application="set" data="effective_caller_id_name=27876300012"/>                                                                                                                                            
  220. <action application="set" data="effective_caller_id_number=27876300012"/>                                                                                                                                          
  221. <action application="set" data="receiver_accid=467"/>                                                                                                                                                              
  222. <action application="export" data="domain_name="/>                                                                                                                                                                
  223. <action application="export" data="sip_to_host="/>                                                                                                                                                                
  224. <action application="export" data="presence_data=x//405|||BizVoice - Account(8773282952)|||^27876303962.* // George Western Cape // 0.00000|||||||||DID|||196.7.219.43"/>                                          
  225. <action application="export" data="call_type=4"/>                                                                                                                                                                  
  226. <action application="set" data="calltype=STANDARD"/>                                                                                                                                                              
  227. <action application="set" data="accountcode=4910157719"/>                                                                                                                                                          
  228. <action application="set" data="caller_did_account_id=419"/>                                                                                                                                                      
  229. <action application="set" data="did_number=27876303962"/>                                                                                                                                                          
  230. <action application="set" data="did_init_inc=1"/>                                                                                                                                                                  
  231. <action application="set" data="did_inc=1"/>                                                                                                                                                                      
  232. <action application="set" data="did_cost=0.00000"/>                                                                                                                                                                
  233. <action application="set" data="did_connectcost=0.00000"/>                                                                                                                                                        
  234. <action application="set" data="origination_rates_did=0"/>                                                                                                                                                        
  235. <action application="set" data="did_id=203"/>                                                                                                                                                                      
  236. <action application="transfer" data="0740451462 XML default"/>                                                                                                                                                    
  237. </condition>                                                                                                                                                                                                      
  238. </extension>                                                                                                                                                                                                      
  239. </context>                                                                                                                                                                                                        
  240. </section>                                                                                                                                                                                                        
  241. </document>                                                                                                                                                                                                        
  242. Dialplan: sofia/default/27876300012@196.7.219.43:8356 parsing [default->27876303962] continue=false
  243. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Regex (PASS) [27876303962] destination_number(27876303962) =~ /27876303962/ break=on-false
  244. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(effective_destination_number=27876303962)
  245. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(execute_on_answer_1=sched_hangup +3600 normal_clearing)
  246. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(notify_flag=0)
  247. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(notify_credit_limit=450.00000)
  248. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(type=0)
  249. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(callstart=2024-10-29 10:05:51)
  250. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(hangup_after_bridge=true)
  251. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(continue_on_fail=TRUE)
  252. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(account_id=419)
  253. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(parent_id=405)
  254. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(entity_id=0)
  255. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(call_processed=internal)
  256. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(call_direction=inbound)
  257. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(accountname=default)
  258. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(origination_rates_did=ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:467||ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:405)                                                                                                                                                                                              
  259. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(origination_rates=0)
  260. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(original_caller_id_name=27876300012)
  261. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(original_caller_id_number=27876300012)
  262. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action limit(db 8773282952 user_8773282952 16 )
  263. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(is_recording=1)
  264. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(media_bug_answer_req=true)
  265. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(record_sample_rate=8000)
  266. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(execute_on_answer_2=record_session $${recordings_dir}/${uuid}.wav)
  267. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(effective_caller_id_name=27876300012)
  268. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(effective_caller_id_number=27876300012)
  269. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(receiver_accid=467)
  270. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(domain_name=)
  271. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(sip_to_host=)
  272. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(presence_data=x//405|||BizVoice - Account(8773282952)|||^27876303962.* // George Western Cape // 0.00000|||||||||DID|||196.7.219.43)
  273. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action export(call_type=4)
  274. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(calltype=STANDARD)
  275. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(accountcode=4910157719)
  276. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(caller_did_account_id=419)
  277. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(did_number=27876303962)
  278. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(did_init_inc=1)
  279. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(did_inc=1)
  280. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(did_cost=0.00000)
  281. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(did_connectcost=0.00000)
  282. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(origination_rates_did=0)
  283. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(did_id=203)
  284. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action transfer(0740451462 XML default)
  285. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_core_state_machine.c:281 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_ROUTING -> CS_EXECUTE
  286. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/27876300012@196.7.219.43:8356) State ROUTING going to sleep
  287. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_EXECUTE (Cur 3 Tot 42400)
  288. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/27876300012@196.7.219.43:8356) State EXECUTE
  289. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_sofia.c:213 sofia/default/27876300012@196.7.219.43:8356 SOFIA EXECUTE
  290. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_core_state_machine.c:323 sofia/default/27876300012@196.7.219.43:8356 Standard EXECUTE
  291. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(effective_destination_number=27876303962)
  292. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [effective_destination_number]=[27876303962]
  293. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(execute_on_answer_1=sched_hangup +3600 normal_clearing)
  294. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [execute_on_answer_1]=[sched_hangup +3600 normal_clearing]
  295. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(notify_flag=0)
  296. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [notify_flag]=[0]
  297. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(notify_credit_limit=450.00000)
  298. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [notify_credit_limit]=[450.00000]
  299. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(type=0)
  300. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [type]=[0]
  301. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(callstart=2024-10-29 10:05:51)
  302. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [callstart]=[2024-10-29 10:05:51]
  303. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(hangup_after_bridge=true)
  304. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [hangup_after_bridge]=[true]
  305. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(continue_on_fail=TRUE)
  306. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [continue_on_fail]=[TRUE]
  307. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(account_id=419)
  308. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [account_id]=[419]
  309. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(parent_id=405)
  310. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [parent_id]=[405]
  311. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(entity_id=0)
  312. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [entity_id]=[0]
  313. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(call_processed=internal)
  314. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [call_processed]=[internal]
  315. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(call_direction=inbound)
  316. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [call_direction]=[inbound]
  317. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(accountname=default)
  318. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [accountname]=[default]
  319. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(origination_rates_did=ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:467||ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:405)                                                                                                                                                                                              
  320. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [origination_rates_did]=[ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:0|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:467||ID:203|CODE:^27876303962.*|DESTINATION:George Western Cape|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:4|COST:0.00000|INC:1|INITIALBLOCK:1|RATEGROUP:0|MARKUP:0|CI:171|ACCID:405]                                                                                                                                                
  321. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(origination_rates=0)
  322. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [origination_rates]=[0]
  323. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(original_caller_id_name=27876300012)
  324. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [original_caller_id_name]=[27876300012]
  325. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(original_caller_id_number=27876300012)
  326. 2024-10-29 10:05:51.793538 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [original_caller_id_number]=[27876300012]
  327. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 limit(db 8773282952 user_8773282952 16 )
  328. 2024-10-29 10:05:51.793538 99.00% [DEBUG] switch_limit.c:124 incr called: 8773282952_user_8773282952 max:16, interval:0
  329. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_db.c:194 Usage for 8773282952_user_8773282952 is now 1/16
  330. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(is_recording=1)
  331. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [is_recording]=[1]
  332. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(media_bug_answer_req=true)
  333. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [media_bug_answer_req]=[true]
  334. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(record_sample_rate=8000)
  335. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [record_sample_rate]=[8000]
  336. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(execute_on_answer_2=record_session /usr/local/freeswitch/recordings/d95650a3-b85c-46a8-9da4-5a4dfb3fb23c.wav)
  337. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [execute_on_answer_2]=[record_session /usr/local/freeswitch/recordings/d95650a3-b85c-46a8-9da4-5a4dfb3fb23c.wav]
  338. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(effective_caller_id_name=27876300012)
  339. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [effective_caller_id_name]=[27876300012]
  340. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(effective_caller_id_number=27876300012)
  341. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [effective_caller_id_number]=[27876300012]
  342. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(receiver_accid=467)
  343. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [receiver_accid]=[467]
  344. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(domain_name=)
  345. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[UNDEF]
  346. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(sip_to_host=)
  347. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[UNDEF]
  348. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(presence_data=x//405|||BizVoice - Account(8773282952)|||^27876303962.* // George Western Cape // 0.00000|||||||||DID|||196.7.219.43)
  349. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x//405|||BizVoice - Account(8773282952)|||^27876303962.* // George Western Cape // 0.00000|||||||||DID|||196.7.219.43]                                                                                                                                                                                                          
  350. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 export(call_type=4)
  351. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[4]
  352. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(calltype=STANDARD)
  353. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [calltype]=[STANDARD]
  354. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(accountcode=4910157719)
  355. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [accountcode]=[4910157719]
  356. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(caller_did_account_id=419)
  357. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [caller_did_account_id]=[419]
  358. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(did_number=27876303962)
  359. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [did_number]=[27876303962]
  360. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(did_init_inc=1)
  361. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [did_init_inc]=[1]
  362. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(did_inc=1)
  363. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [did_inc]=[1]
  364. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(did_cost=0.00000)
  365. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [did_cost]=[0.00000]
  366. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(did_connectcost=0.00000)
  367. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [did_connectcost]=[0.00000]
  368. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(origination_rates_did=0)
  369. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [origination_rates_did]=[0]
  370. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(did_id=203)
  371. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [did_id]=[203]
  372. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 transfer(0740451462 XML default)
  373. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_ivr.c:2289 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_EXECUTE -> CS_ROUTING
  374. 2024-10-29 10:05:51.813539 99.00% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/27876300012@196.7.219.43:8356 to XML[0740451462@default]
  375. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/27876300012@196.7.219.43:8356) State EXECUTE going to sleep
  376. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_ROUTING (Cur 3 Tot 42400)
  377. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/27876300012@196.7.219.43:8356) State ROUTING
  378. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_sofia.c:149 Call appears to be already acknowledged
  379. 2024-10-29 10:05:51.813539 99.00% [DEBUG] mod_sofia.c:158 sofia/default/27876300012@196.7.219.43:8356 SOFIA ROUTING
  380. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_core_state_machine.c:230 sofia/default/27876300012@196.7.219.43:8356 Standard ROUTING
  381. 2024-10-29 10:05:51.813539 99.00% [INFO] mod_dialplan_xml.c:639 Processing Ext 112 <27876300012>->0740451462 in context default
  382. 2024-10-29 10:05:51.813539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  383. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  384. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')                                                                                                                                                                                                
  385. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  386. 2024-10-29 10:05:51.813539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 0740451462
  387. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '0740451462' AND status=0 limit 1
  388. 2024-10-29 10:05:51.813539 99.00% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  389. 2024-10-29 10:05:51.813539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 27876300012 / 27876300012
  390. 2024-10-29 10:05:51.813539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id: 43
  391. 2024-10-29 10:05:51.813539 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  392. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....0740451462
  393. 2024-10-29 10:05:51.813539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 0740451462
  394. 2024-10-29 10:05:51.813539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 27740451462
  395. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  396. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  397. 2024-10-29 10:05:51.813539 99.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, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="27740451462" LIMIT 1                                    
  398. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  399. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="0740451462" limit 1                                                                                                                                                                    
  400. 2024-10-29 10:05:51.813539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  401. 2024-10-29 10:05:51.813539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [OPENSIP_FROM_IP] from_ip : 196.7.219.43
  402. 2024-10-29 10:05:51.813539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 4910157719]
  403. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "4910157719" OR id = "4910157719") AND deleted = 0 limit 1
  404. 2024-10-29 10:05:51.813539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^0740451462.*' OR blocked_patterns = '^074045146.*' OR blocked_patterns = '^07404514.*' OR blocked_patterns = '^0740451.*' OR blocked_patterns = '^074045.*' OR blocked_patterns = '^07404.*' OR blocked_patterns = '^0740.*' OR blocked_patterns = '^074.*' OR blocked_patterns = '^07.*' OR blocked_patterns = '^0.*' OR blocked_patterns ='--') AND accountid = 467 limit 1                                                                                                              
  405. 2024-10-29 10:05:51.813539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id : 43
  406. 2024-10-29 10:05:51.813539 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  407. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....0740451462
  408. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 0740451462
  409. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 27740451462
  410. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  411. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  412. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="27740451462" AND (accountid = 0 OR status = 1) LIMIT 1
  413. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Localization Id: 55
  414. 2024-10-29 10:05:51.833539 99.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 = 55 AND status=0 limit 1                                                                                                                                                                                          
  415. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  416. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  417. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  418. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  419. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  420. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  421. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  422. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  423. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  424. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  425. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  426. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  427. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  428. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  429. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  430. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  431. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  432. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....0740451462                                                                                                              
  433. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 0740451462
  434. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 27740451462
  435. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"1/001/*/*,2/002/*/*,3/003/*/*,4/004/*/*,5/005/*/*,6/006/*/*,7/007/*/*,8/008/*/*,9/009/*/*,0027/27/*/*,00/00/*/*,01/271/*/*,02/272/*/*,03/273/*/*,04/274/*/*,05/275/*/*,06/276/*/*,07/277/*/*,08/278/*/*".....27740451462                                                                                                            
  436. 2024-10-29 10:05:51.833539 99.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 = '^27740451462.*' OR patterns = '^2774045146.*' OR patterns = '^277404514.*' OR patterns = '^27740451.*' OR patterns = '^2774045.*' OR patterns = '^277404.*' OR patterns = '^27740.*' OR patterns = '^2774.*' OR patterns = '^277.*' OR patterns = '^27.*' OR patterns = '^2.*' OR patterns ='--') AND accountid = 467 ORDER BY LENGTH(PKGPTR.patterns) DESC                                                                                                                                                                                                            
  437. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Package ID : 879
  438. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Product ID : 307
  439. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from products WHERE id = 307 AND status = 0
  440. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Apply On Rategroups For Free Product :
  441. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Package Type : 1 Call Direction : outbound [0:inbound,1:outbound,2:both]
  442. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_COUNTER_INFO] Query :SELECT used_seconds FROM counters  WHERE  accountid = 467 AND package_id = 879 AND status=1 LIMIT 1
  443. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] Remaining Minutes : 4.2333333333333
  444. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] Package Id : 879
  445. 2024-10-29 10:05:51.833539 99.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 ="27740451462" AND A.accountid = '467' limit 1                                                                                                                                                                
  446. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 27740451462
  447. 2024-10-29 10:05:51.833539 99.00% [NOTICE] switch_cpp.cpp:1465 [ASTPP] DID Global Translation Id: 43
  448. 2024-10-29 10:05:51.833539 99.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 = 43 AND status=0 limit 1                                                                                                                                                                                          
  449. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  450. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  451. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"0/27/*/*,270/00/*/*,10/27010/*/*".....27740451462
  452. 2024-10-29 10:05:51.833539 99.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, A.codec as did_codec,A.provider_id as provider_id,A.always as always,A.always_destination as always_destination FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="27740451462" LIMIT 1                                    
  453. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  454. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="27740451462" limit 1                                                                                                                                                                  
  455. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
  456. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type,accountid FROM call_barring WHERE ((number = '27740451462' OR number = '2774045146' OR number = '277404514' OR number = '27740451' OR number = '2774045' OR number = '277404' OR number = '27740' OR number = '2774' OR number = '277' OR number = '27' OR number = '2' OR number ='--') OR (number = '27740451462*' OR number = '2774045146*' OR number = '277404514*' OR number = '27740451*' OR number = '2774045*' OR number = '277404*' OR number = '27740*' OR number = '2774*' OR number = '277*' OR number = '27*' OR number = '2*' OR number ='--') OR (number = '27876300012' OR number = '2787630001' OR number = '278763000' OR number = '27876300' OR number = '2787630' OR number = '278763' OR number = '27876' OR number = '2787' OR number = '278' OR number = '27' OR number = '2' OR number ='--') OR (number = '27876300012*' OR number = '2787630001*' OR number = '278763000*' OR number = '27876300*' OR number = '2787630*' OR number = '278763*' OR number = '27876*' OR number = '2787*' OR number = '278*' OR number = '27*' OR number = '2*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC                                                                                                                                                                                  
  457. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  458. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] Caller Id : 27876300012
  459. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] CLI Pool Id : 8
  460. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] Query :Select count(*) as count from dids where number='27876300012' and accountid = "467" and status=0
  461. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_COUNT] COUNT :0
  462. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_CLI_POOL] Query :Select count(*) as count from ani_map where number='27876300012' and status=0
  463. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  Post Cdrs : 0
  464. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_sip_device_info_for_did_pstn_call] Query :SELECT username FROM sip_devices WHERE username = '27876300012' and status = 0 limit 1
  465. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 467
  466. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  467. <?xml version="1.0" encoding="UTF-8" standalone="no"?>                                                                                                                                                            
  468. <document type="freeswitch/xml">                                                                                                                                                                                  
  469. <section name="dialplan" description="ASTPP Dialplan">                                                                                                                                                            
  470. <context name="default">                                                                                                                                                                                          
  471. <extension name="0740451462">                                                                                                                                                                                      
  472. <condition field="destination_number" expression="0740451462">                                                                                                                                                    
  473. <action application="log" data="WARNING CALLERID_NOT_FOUND 467"/>                                                                                                                                                  
  474. <action application="playback" data=""/>                                                                                                                                                                          
  475. <action application="set" data="original_caller_id_name=27876300012"/>                                                                                                                                            
  476. <action application="set" data="original_caller_id_number=27876300012"/>                                                                                                                                          
  477. <action application="set" data="error_cdr=1"/>                                                                                                                                                                    
  478. <action application="set" data="callstart=2024-10-29 10:05:51"/>                                                                                                                                                  
  479. <action application="set" data="account_id=467"/>                                                                                                                                                                  
  480. <action application="set" data="parent_id=425"/>                                                                                                                                                                  
  481. <action application="set" data="call_direction=outbound"/>                                                                                                                                                        
  482. <action application="set" data="sip_ignore_remote_cause=true"/>                                                                                                                                                    
  483. <action application="set" data="call_processed=internal"/>                                                                                                                                                        
  484. <action application="set" data="effective_destination_number=27740451462"/>                                                                                                                                        
  485. <action application="set" data="last_bridge_hangup_cause=CALLERID_NOT_FOUND"/>                                                                                                                                    
  486. <action application="hangup" data="CALLERID_NOT_FOUND"/>                                                                                                                                                          
  487. </condition>                                                                                                                                                                                                      
  488. </extension>                                                                                                                                                                                                      
  489. </context>                                                                                                                                                                                                        
  490. </section>                                                                                                                                                                                                        
  491. </document>                                                                                                                                                                                                        
  492. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP]  Post Cdrs : 0
  493. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_sip_device_info_for_did_pstn_call] Query :SELECT username FROM sip_devices WHERE username = '27876300012' and status = 0 limit 1
  494. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 467
  495. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  496. <?xml version="1.0" encoding="UTF-8" standalone="no"?>                                                                                                                                                            
  497. <document type="freeswitch/xml">                                                                                                                                                                                  
  498. <section name="dialplan" description="ASTPP Dialplan">                                                                                                                                                            
  499. <context name="default">                                                                                                                                                                                          
  500. <extension name="0740451462">                                                                                                                                                                                      
  501. <condition field="destination_number" expression="0740451462">                                                                                                                                                    
  502. <action application="log" data="WARNING Accountcode 4910157719. Dialed number (27740451462) is blocked for account!!"/>                                                                                            
  503. <action application="playback" data="/usr/local/freeswitch/sounds/en/us/callie/astpp-badnumber.wav"/>                                                                                                              
  504. <action application="set" data="original_caller_id_name=27876300012"/>                                                                                                                                            
  505. <action application="set" data="original_caller_id_number=27876300012"/>                                                                                                                                          
  506. <action application="set" data="error_cdr=1"/>                                                                                                                                                                    
  507. <action application="set" data="callstart=2024-10-29 10:05:51"/>                                                                                                                                                  
  508. <action application="set" data="account_id=467"/>                                                                                                                                                                  
  509. <action application="set" data="parent_id=425"/>                                                                                                                                                                  
  510. <action application="set" data="call_direction=outbound"/>                                                                                                                                                        
  511. <action application="set" data="sip_ignore_remote_cause=true"/>                                                                                                                                                    
  512. <action application="set" data="call_processed=internal"/>                                                                                                                                                        
  513. <action application="set" data="effective_destination_number=27740451462"/>                                                                                                                                        
  514. <action application="set" data="last_bridge_hangup_cause=DESTINATION_BLOCKED"/>                                                                                                                                    
  515. <action application="hangup" data="DESTINATION_BLOCKED"/>                                                                                                                                                          
  516. </condition>                                                                                                                                                                                                      
  517. </extension>                                                                                                                                                                                                      
  518. </context>                                                                                                                                                                                                        
  519. </section>                                                                                                                                                                                                        
  520. </document>                                                                                                                                                                                                        
  521. Dialplan: sofia/default/27876300012@196.7.219.43:8356 parsing [default->0740451462] continue=false
  522. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Regex (PASS) [0740451462] destination_number(0740451462) =~ /0740451462/ break=on-false
  523. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action log(WARNING Accountcode 4910157719. Dialed number (27740451462) is blocked for account!!)
  524. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action playback(/usr/local/freeswitch/sounds/en/us/callie/astpp-badnumber.wav)
  525. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(original_caller_id_name=27876300012)
  526. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(original_caller_id_number=27876300012)
  527. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(error_cdr=1)
  528. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(callstart=2024-10-29 10:05:51)
  529. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(account_id=467)
  530. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(parent_id=425)
  531. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(call_direction=outbound)
  532. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(sip_ignore_remote_cause=true)
  533. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(call_processed=internal)
  534. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(effective_destination_number=27740451462)
  535. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action set(last_bridge_hangup_cause=DESTINATION_BLOCKED)
  536. Dialplan: sofia/default/27876300012@196.7.219.43:8356 Action hangup(DESTINATION_BLOCKED)
  537. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_state_machine.c:281 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_ROUTING -> CS_EXECUTE
  538. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_state_machine.c:640 (sofia/default/27876300012@196.7.219.43:8356) State ROUTING going to sleep
  539. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_EXECUTE (Cur 3 Tot 42400)
  540. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_state_machine.c:647 (sofia/default/27876300012@196.7.219.43:8356) State EXECUTE
  541. 2024-10-29 10:05:51.833539 99.00% [DEBUG] mod_sofia.c:213 sofia/default/27876300012@196.7.219.43:8356 SOFIA EXECUTE
  542. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_state_machine.c:323 sofia/default/27876300012@196.7.219.43:8356 Standard EXECUTE
  543. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 log(WARNING Accountcode 4910157719. Dialed number (27740451462) is blocked for account!!)
  544. 2024-10-29 10:05:51.833539 99.00% [WARNING] mod_dptools.c:1879 Accountcode 4910157719. Dialed number (27740451462) is blocked for account!!
  545. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_session.c:2795 Application playback Requires media! pre_answering channel sofia/default/27876300012@196.7.219.43:8356
  546. 2024-10-29 10:05:51.833539 99.00% [INFO] switch_core_session.c:2797 Sending early media
  547. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/27876300012@196.7.219.43:8356] 102.220.232.20 port 30864 -> 196.7.219.43 port 46176 codec: 8 ms: 20
  548. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
  549. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_media.c:9089 sofia/default/27876300012@196.7.219.43:8356 Set 2833 dtmf send payload to 101
  550. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_media.c:9096 sofia/default/27876300012@196.7.219.43:8356 Set 2833 dtmf receive payload to 101
  551. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_core_media.c:9119 sofia/default/27876300012@196.7.219.43:8356 Set rtp dtmf delay to 40
  552. 2024-10-29 10:05:51.833539 99.00% [DEBUG] mod_sofia.c:2610 Ring SDP:
  553. v=0                                                                                                                                                                                                                
  554. o=FreeSWITCH 1730165487 1730165488 IN IP4 102.220.232.20                                                                                                                                                          
  555. s=FreeSWITCH                                                                                                                                                                                                      
  556. c=IN IP4 102.220.232.20                                                                                                                                                                                            
  557. t=0 0                                                                                                                                                                                                              
  558. m=audio 30864 RTP/AVP 8 101                                                                                                                                                                                        
  559. a=rtpmap:8 PCMA/8000                                                                                                                                                                                              
  560. a=rtpmap:101 telephone-event/8000                                                                                                                                                                                  
  561. a=fmtp:101 0-15                                                                                                                                                                                                    
  562. a=ptime:20                                                                                                                                                                                                        
  563. a=sendrecv                                                                                                                                                                                                        
  564.  
  565. 2024-10-29 10:05:51.833539 99.00% [NOTICE] mod_sofia.c:2613 Pre-Answer sofia/default/27876300012@196.7.219.43:8356!
  566. 2024-10-29 10:05:51.833539 99.00% [DEBUG] switch_channel.c:3622 (sofia/default/27876300012@196.7.219.43:8356) Callstate Change RINGING -> EARLY
  567. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 playback(/usr/local/freeswitch/sounds/en/us/callie/astpp-badnumber.wav)
  568. 2024-10-29 10:05:51.833539 99.00% [DEBUG] sofia.c:7499 Channel sofia/default/27876300012@196.7.219.43:8356 entering state [early][183]
  569. 2024-10-29 10:05:51.873539 99.00% [DEBUG] switch_core_file.c:444 File /usr/local/freeswitch/sounds/en/us/callie/astpp-badnumber.wav sample rate 22050 doesn't match requested rate 8000
  570. 2024-10-29 10:05:51.873539 99.00% [DEBUG] switch_ivr_play_say.c:1556 Codec Activated L16@8000hz 1 channels 20ms
  571. 2024-10-29 10:05:52.173543 99.00% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
  572. 2024-10-29 10:05:53.873543 98.97% [DEBUG] switch_ivr_play_say.c:2001 done playing file /usr/local/freeswitch/sounds/en/us/callie/astpp-badnumber.wav
  573. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(original_caller_id_name=27876300012)
  574. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [original_caller_id_name]=[27876300012]
  575. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(original_caller_id_number=27876300012)
  576. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [original_caller_id_number]=[27876300012]
  577. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(error_cdr=1)
  578. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [error_cdr]=[1]
  579. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(callstart=2024-10-29 10:05:51)
  580. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [callstart]=[2024-10-29 10:05:51]
  581. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(account_id=467)
  582. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [account_id]=[467]
  583. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(parent_id=425)
  584. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [parent_id]=[425]
  585. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(call_direction=outbound)
  586. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [call_direction]=[outbound]
  587. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(sip_ignore_remote_cause=true)
  588. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [sip_ignore_remote_cause]=[true]
  589. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(call_processed=internal)
  590. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [call_processed]=[internal]
  591. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(effective_destination_number=27740451462)
  592. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [effective_destination_number]=[27740451462]
  593. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 set(last_bridge_hangup_cause=DESTINATION_BLOCKED)
  594. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_dptools.c:1685 SET sofia/default/27876300012@196.7.219.43:8356 [last_bridge_hangup_cause]=[DESTINATION_BLOCKED]
  595. EXECUTE [depth=0] sofia/default/27876300012@196.7.219.43:8356 hangup(DESTINATION_BLOCKED)
  596. 2024-10-29 10:05:53.873543 98.97% [NOTICE] mod_dptools.c:1387 Hangup sofia/default/27876300012@196.7.219.43:8356 [CS_EXECUTE] [NORMAL_CLEARING]
  597. 2024-10-29 10:05:53.873543 98.97% [DEBUG] switch_core_session.c:2983 sofia/default/27876300012@196.7.219.43:8356 skip receive message [PHONE_EVENT] (channel is hungup already)
  598. 2024-10-29 10:05:53.873543 98.97% [DEBUG] switch_core_state_machine.c:647 (sofia/default/27876300012@196.7.219.43:8356) State EXECUTE going to sleep
  599. 2024-10-29 10:05:53.873543 98.97% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_HANGUP (Cur 3 Tot 42400)
  600. 2024-10-29 10:05:53.873543 98.97% [DEBUG] switch_core_state_machine.c:844 (sofia/default/27876300012@196.7.219.43:8356) Callstate Change EARLY -> HANGUP
  601. 2024-10-29 10:05:53.873543 98.97% [DEBUG] switch_core_state_machine.c:846 (sofia/default/27876300012@196.7.219.43:8356) State HANGUP
  602. 2024-10-29 10:05:53.873543 98.97% [DEBUG] mod_sofia.c:468 Channel sofia/default/27876300012@196.7.219.43:8356 hanging up, cause: NORMAL_CLEARING
  603. 2024-10-29 10:05:53.893539 98.97% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 480
  604. 2024-10-29 10:05:53.893539 98.97% [DEBUG] switch_core_state_machine.c:59 sofia/default/27876300012@196.7.219.43:8356 Standard HANGUP, cause: NORMAL_CLEARING
  605. 2024-10-29 10:05:53.893539 98.97% [DEBUG] switch_core_state_machine.c:846 (sofia/default/27876300012@196.7.219.43:8356) State HANGUP going to sleep
  606. 2024-10-29 10:05:53.893539 98.97% [DEBUG] switch_core_state_machine.c:616 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_HANGUP -> CS_REPORTING
  607. 2024-10-29 10:05:53.893539 98.97% [DEBUG] switch_core_state_machine.c:581 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_REPORTING (Cur 3 Tot 42400)
  608. 2024-10-29 10:05:53.893539 98.97% [DEBUG] switch_core_state_machine.c:932 (sofia/default/27876300012@196.7.219.43:8356) State REPORTING
  609. 2024-10-29 10:05:53.893539 98.97% [INFO] mod_json_cdr.c:271 Process [d95650a3-b85c-46a8-9da4-5a4dfb3fb23c.cdr.json]
  610. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:168 sofia/default/27876300012@196.7.219.43:8356 Standard REPORTING, cause: NORMAL_CLEARING
  611. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:932 (sofia/default/27876300012@196.7.219.43:8356) State REPORTING going to sleep
  612. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:607 (sofia/default/27876300012@196.7.219.43:8356) State Change CS_REPORTING -> CS_DESTROY
  613. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_session.c:1753 Session 42400 (sofia/default/27876300012@196.7.219.43:8356) Locked, Waiting on external entities
  614. 2024-10-29 10:05:53.993539 98.97% [NOTICE] switch_core_session.c:1771 Session 42400 (sofia/default/27876300012@196.7.219.43:8356) Ended
  615. 2024-10-29 10:05:53.993539 98.97% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/27876300012@196.7.219.43:8356 [CS_DESTROY]
  616. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:735 (sofia/default/27876300012@196.7.219.43:8356) Running State Change CS_DESTROY (Cur 2 Tot 42400)
  617. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:745 (sofia/default/27876300012@196.7.219.43:8356) State DESTROY
  618. 2024-10-29 10:05:53.993539 98.97% [DEBUG] mod_sofia.c:379 sofia/default/27876300012@196.7.219.43:8356 SOFIA DESTROY
  619. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:175 sofia/default/27876300012@196.7.219.43:8356 Standard DESTROY
  620. 2024-10-29 10:05:53.993539 98.97% [DEBUG] switch_core_state_machine.c:745 (sofia/default/27876300012@196.7.219.43:8356) State DESTROY going to sleep
  621.  

Reply to "Caller ID "