FreeSWITCH Pastebin

test

From Palak, 1 Year ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/b74b2691
Embed
Download Paste or View Raw
  1. Hunt-RDNIS: 23418870231
  2. Hunt-Channel-Name: sofia/default/5760419167%40billing.delaphonegh.com
  3. Hunt-Profile-Index: 2
  4. Hunt-Profile-Created-Time: 1662550671773172
  5. Hunt-Channel-Created-Time: 1662550671693128
  6. Hunt-Channel-Answered-Time: 0
  7. Hunt-Channel-Progress-Time: 0
  8. Hunt-Channel-Progress-Media-Time: 0
  9. Hunt-Channel-Hangup-Time: 0
  10. Hunt-Channel-Transfer-Time: 0
  11. Hunt-Channel-Resurrect-Time: 0
  12. Hunt-Channel-Bridged-Time: 0
  13. Hunt-Channel-Last-Hold: 0
  14. Hunt-Channel-Hold-Accum: 0
  15. Hunt-Screen-Bit: true
  16. Hunt-Privacy-Hide-Name: false
  17. Hunt-Privacy-Hide-Number: false
  18.  
  19.  
  20. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_value:
  21. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] section: dialplan
  22. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] key_name:
  23. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [xml_REQUEST] tag_name:
  24. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [DIALPLAN] OUTBOUND_service
  25. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 233553109295
  26. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '233553109295' AND status=0 limit 1
  27. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : +233242436874 / +233242436874
  28. 2022-09-07 11:37:51.793140 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
  29. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  30. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [DIALPLAN] OUTBOUND_service
  31. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Dialed number : 233209029456
  32. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '233209029456' AND status=0 limit 1
  33. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="233553109295" LIMIT 1
  34. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Caller Id name / number  : 5760419167 / 5760419167
  35. 2022-09-07 11:37:51.793140 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
  36. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  37. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [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 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="233553109295" limit 1
  38. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="233209029456" LIMIT 1
  39. 2022-09-07 11:37:51.793140 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
  40. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("54.172.60.3") BETWEEN(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) & 0xffffffff ^((0x1 <<(32 -  SUBSTRING_INDEX(`ip`, '/', -1))) -1 )) AND(INET_ATON(SUBSTRING_INDEX(`ip`, '/', 1)) |((0x100000000 >> SUBSTRING_INDEX(`ip`,'/', -1)) -1))  AND "233553109295"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  41. 2022-09-07 11:37:51.793140 [DEBUG] switch_cpp.cpp:1443 [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 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="233209029456" limit 1
  42. 2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] Call direction : outbound
  43. 2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 8320249953]
  44. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "8320249953" AND deleted = 0 limit 1
  45. 2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Accountcode : 7969403565]
  46. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "7969403565" AND deleted = 0 limit 1
  47. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^233209029456.*' OR blocked_patterns = '^23320902945.*' OR blocked_patterns = '^2332090294.*' OR blocked_patterns = '^233209029.*' OR blocked_patterns = '^23320902.*' OR blocked_patterns = '^2332090.*' OR blocked_patterns = '^233209.*' OR blocked_patterns = '^23320.*' OR blocked_patterns = '^2332.*' OR blocked_patterns = '^233.*' OR blocked_patterns = '^23.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 1569 limit 1
  48. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^233553109295.*' OR blocked_patterns = '^23355310929.*' OR blocked_patterns = '^2335531092.*' OR blocked_patterns = '^233553109.*' OR blocked_patterns = '^23355310.*' OR blocked_patterns = '^2335531.*' OR blocked_patterns = '^233553.*' OR blocked_patterns = '^23355.*' OR blocked_patterns = '^2335.*' OR blocked_patterns = '^233.*' OR blocked_patterns = '^23.*' OR blocked_patterns = '^2.*' OR blocked_patterns ='--') AND accountid = 1329 limit 1
  49. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 ="233209029456" AND A.accountid = '1569' limit 1
  50. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 ="233553109295" AND A.accountid = '1329' limit 1
  51. 2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 233209029456
  52. 2022-09-07 11:37:51.813146 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
  53. 2022-09-07 11:37:51.813146 [INFO] switch_cpp.cpp:1443 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 233553109295
  54. 2022-09-07 11:37:51.813146 [NOTICE] switch_cpp.cpp:1443 [ASTPP] DID global translation id: 1
  55. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  56. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  57. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="233209029456" LIMIT 1
  58. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="233553109295" LIMIT 1
  59. 2022-09-07 11:37:51.813146 [DEBUG] switch_cpp.cpp:1443 [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 FROM sip_devices as sip_devices,accounts as  accoun

Reply to "test"