From Prashant kumar, 2 Years ago, written in FreeSWITCH.
- view diff
Embed
  1. freeswitch@ip-172-31-14-218>
  2. freeswitch@ip-172-31-14-218>
  3. freeswitch@ip-172-31-14-218>
  4. 2022-03-10 10:59:28.595513 95.87% [NOTICE] switch_channel.c:1123 New Channel sofia/default/9191680902@w07version61.astppbilling.org:5074 [bfa09f6f-1415-466c-bd93-1aee01685128]
  5. 2022-03-10 10:59:28.595513 95.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_NEW (Cur 1 Tot 20)
  6. 2022-03-10 10:59:28.595513 95.87% [INFO] sofia.c:10462 sofia/default/9191680902@w07version61.astppbilling.org:5074 receiving invite from 117.247.91.162:50798 version: 1.10.7 -release-19-883d2cb662 64bit call-id: ZDFmOWQ5NzAxZjY5NGFlZGQyNGQxYmQzMTFmYTRjNjc.
  7. 2022-03-10 10:59:28.595513 95.87% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0.
  8. 2022-03-10 10:59:28.595513 95.87% [DEBUG] sofia.c:2419 detaching session bfa09f6f-1415-466c-bd93-1aee01685128
  9. 2022-03-10 10:59:28.595513 95.87% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [4665206923@w07version61.astppbilling.org] from ip 117.247.91.162
  10. 2022-03-10 10:59:28.595513 95.87% [DEBUG] switch_core_state_machine.c:600 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State NEW
  11. 2022-03-10 10:59:28.715513 95.87% [DEBUG] sofia.c:2532 Re-attaching to session bfa09f6f-1415-466c-bd93-1aee01685128
  12. 2022-03-10 10:59:28.715513 95.87% [INFO] sofia.c:10462 sofia/default/9191680902@w07version61.astppbilling.org:5074 receiving invite from 117.247.91.162:50798 version: 1.10.7 -release-19-883d2cb662 64bit call-id: ZDFmOWQ5NzAxZjY5NGFlZGQyNGQxYmQzMTFmYTRjNjc.
  13. 2022-03-10 10:59:28.715513 95.87% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0.
  14. 2022-03-10 10:59:28.715513 95.87% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
  15. 2022-03-10 10:59:28.715513 95.87% [DEBUG] sofia.c:7499 Channel sofia/default/9191680902@w07version61.astppbilling.org:5074 entering state [received][100]
  16. 2022-03-10 10:59:28.715513 95.87% [DEBUG] sofia.c:7509 Remote SDP:
  17. v=0
  18. o=3cxVCE 383435700 219543480 IN IP4 192.168.1.13
  19. s=3cxVCE Audio Call
  20. c=IN IP4 192.168.1.13
  21. t=0 0
  22. m=audio 40028 RTP/AVP 0 8 3 101
  23. a=rtpmap:0 PCMU/8000
  24. a=rtpmap:8 PCMA/8000
  25. a=rtpmap:3 GSM/8000
  26. a=rtpmap:101 telephone-event/8000
  27. a=fmtp:101 0-15
  28. a=ptime:20
  29. m=video 40010 RTP/AVP 34
  30. c=IN IP4 192.168.1.13
  31. a=rtpmap:34 H263/90000
  32. a=fmtp:34 QCIF=1;CIF=1;SQCIF=1;CIF4=1
  33.  
  34. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  35. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  36. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  37. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  38. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  39. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  40. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  41. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  42. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  43. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/9191680902@w07version61.astppbilling.org:5074 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
  44. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_codec.c:111 sofia/default/9191680902@w07version61.astppbilling.org:5074 Original read codec set to PCMU:0
  45. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  46. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:5973 sofia/default/9191680902@w07version61.astppbilling.org:5074 Set 2833 dtmf send payload to 101 recv payload to 101
  47. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:6301 No matches with FTMP, fallback to ignoring FMTP
  48. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_media.c:6309 No matches with inherit_codec, fallback to ignoring PT
  49. 2022-03-10 10:59:28.715513 95.87% [DEBUG] sofia.c:7933 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State Change CS_NEW -> CS_INIT
  50. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_INIT (Cur 1 Tot 20)
  51. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State INIT
  52. 2022-03-10 10:59:28.715513 95.87% [DEBUG] mod_sofia.c:97 sofia/default/9191680902@w07version61.astppbilling.org:5074 SOFIA INIT
  53. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:40 sofia/default/9191680902@w07version61.astppbilling.org:5074 Standard INIT
  54. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:48 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State Change CS_INIT -> CS_ROUTING
  55. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State INIT going to sleep
  56. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_ROUTING (Cur 1 Tot 20)
  57. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_channel.c:2380 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Callstate Change DOWN -> RINGING
  58. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State ROUTING
  59. 2022-03-10 10:59:28.715513 95.87% [DEBUG] mod_sofia.c:158 sofia/default/9191680902@w07version61.astppbilling.org:5074 SOFIA ROUTING
  60. 2022-03-10 10:59:28.715513 95.87% [DEBUG] switch_core_state_machine.c:230 sofia/default/9191680902@w07version61.astppbilling.org:5074 Standard ROUTING
  61. 2022-03-10 10:59:28.715513 95.87% [INFO] mod_dialplan_xml.c:639 Processing 9191680902 <9191680902>->4665206923 in context default
  62. 2022-03-10 10:59:28.735484 95.87% [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')
  63. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  64. 2022-03-10 10:59:28.735484 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 4665206923
  65. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '4665206923' AND status=0 limit 1
  66. 2022-03-10 10:59:28.735484 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9191680902
  67. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  68. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '4665206923' limit 1
  69. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '5' and username = '4665206923' limit 1
  70. 2022-03-10 10:59:28.735484 95.87% [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 = '9191680902' limit 1
  71. 2022-03-10 10:59:28.735484 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan COMINNG] Caller Id name / number  : 9191680902 / 9191680902
  72. 2022-03-10 10:59:28.735484 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  :  /
  73. 2022-03-10 10:59:28.735484 95.87% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="4665206923" LIMIT 1
  74. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  75. 2022-03-10 10:59:28.735484 95.87% [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="4665206923" limit 1
  76. 2022-03-10 10:59:28.735484 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : local
  77. 2022-03-10 10:59:28.735484 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9191680902]
  78. 2022-03-10 10:59:28.735484 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9191680902" AND deleted = 0 limit 1
  79. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="4665206923" AND (accountid = 0 OR status = 1) LIMIT 1
  80. 2022-03-10 10:59:28.755483 95.87% [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 = '^4665206923.*' OR patterns = '^466520692.*' OR patterns = '^46652069.*' OR patterns = '^4665206.*' OR patterns = '^466520.*' OR patterns = '^46652.*' OR patterns = '^4665.*' OR patterns = '^466.*' OR patterns = '^46.*' OR patterns = '^4.*' OR patterns ='--') AND accountid = 7 ORDER BY LENGTH(PKGPTR.patterns) DESC
  81. 2022-03-10 10:59:28.755483 95.87% [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 ="4665206923" AND A.accountid = '7' limit 1
  82. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 4665206923
  83. 2022-03-10 10:59:28.755483 95.87% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="4665206923" LIMIT 1
  84. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  85. 2022-03-10 10:59:28.755483 95.87% [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="4665206923" limit 1
  86. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : local
  87. 2022-03-10 10:59:28.755483 95.87% [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 = '4665206923' OR number = '466520692' OR number = '46652069' OR number = '4665206' OR number = '466520' OR number = '46652' OR number = '4665' OR number = '466' OR number = '46' OR number = '4' OR number ='--') OR (number = '4665206923*' OR number = '466520692*' OR number = '46652069*' OR number = '4665206*' OR number = '466520*' OR number = '46652*' OR number = '4665*' OR number = '466*' OR number = '46*' OR number = '4*' OR number ='--') OR (number ='--') OR (number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  88. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  89. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '4665206923' OR routing_prefix = '466520692' OR routing_prefix = '46652069' OR routing_prefix = '4665206' OR routing_prefix = '466520' OR routing_prefix = '46652' OR routing_prefix = '4665' OR routing_prefix = '466' OR routing_prefix = '46' OR routing_prefix = '4' OR routing_prefix ='--') AND status = 0 and reseller_id = 4 limit 1
  90. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  91. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 7
  92. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9191680902
  93. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 40000
  94. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  95. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 17
  96. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  97. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  98. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 17 AND status = 0
  99. 2022-03-10 10:59:28.755483 95.87% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Free Inbound : 1
  100. 2022-03-10 10:59:28.755483 95.87% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Charge Per Min : 0
  101. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your40000 balance Accountid 7 !!!
  102. 2022-03-10 10:59:28.755483 95.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  103. 2022-03-10 10:59:28.755483 95.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 4
  104. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "4" AND deleted = 0 limit 1
  105. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  106. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 4
  107. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9104408877
  108. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 19998.2
  109. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  110. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  111. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  112. 2022-03-10 10:59:28.755483 95.87% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Free Inbound : 1
  113. 2022-03-10 10:59:28.755483 95.87% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Charge Per Min : 0
  114. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your19998.2 balance Accountid 4 !!!
  115. 2022-03-10 10:59:28.755483 95.87% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  116. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:17|MARKUP:0|CI:0|ACCID:7||ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:1|MARKUP:0|CI:0|ACCID:4
  117. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  118. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 1
  119. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  120. 2022-03-10 10:59:28.755483 95.87% [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="4665206923" limit 1
  121. 2022-03-10 10:59:28.755483 95.87% [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 = 7 AND status=0 LIMIT 1
  122. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  123. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  124. 2022-03-10 10:59:28.755483 95.87% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  125. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [NOTIFY] START:
  126. 2022-03-10 10:59:28.755483 95.87% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
  127. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  128. <document type="freeswitch/xml">
  129. <section name="dialplan" description="ASTPP Dialplan">
  130. <context name="default">
  131. <extension name="4665206923">
  132. <condition field="destination_number" expression="4665206923">
  133. <action application="set" data="effective_destination_number=4665206923"/>
  134. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  135. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  136. <action application="set" data="callstart=2022-03-10 10:59:28"/>
  137. <action application="set" data="hangup_after_bridge=true"/>
  138. <action application="set" data="continue_on_fail=TRUE"/>
  139. <action application="set" data="account_id=7"/>
  140. <action application="set" data="parent_id=4"/>
  141. <action application="set" data="entity_id=0"/>
  142. <action application="set" data="call_processed=internal"/>
  143. <action application="set" data="call_direction=local"/>
  144. <action application="set" data="accountname=default"/>
  145. <action application="set" data="origination_rates=ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:17|MARKUP:0|CI:0|ACCID:7||ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:1|MARKUP:0|CI:0|ACCID:4"/>
  146. <action application="set" data="calltype=LOCAL"/>
  147. <action application="set" data="receiver_accid=5"/>
  148. <action application="export" data="presence_data=x//4|||Reseller's cust(9191680902)|||^4665206923.* // Local // 0||||||Local|||117.247.91.162"/>
  149. <action application="export" data="presence_data=||||||||||||LOCAL|||192.168.1.13"/>
  150. <action application="bridge" data="[leg_timeout=30]user/4665206923@${domain_name}"/>
  151. <condition field="${cond(${user_data 4665206923@${domain_name} param vm-enabled} == true ? YES : NO)}" expression="^YES$">
  152. <action application="answer"/>
  153. <action application="export" data="voicemail_alternate_greet_id=4665206923"/>
  154. <action application="voicemail" data="default $${domain_name} 4665206923"/>
  155. <anti-action application="hangup" data="${originate_disposition}"/>
  156. </condition>
  157. </condition>
  158. </extension>
  159. </context>
  160. </section>
  161. </document>
  162. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 parsing [default->4665206923] continue=false
  163. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Regex (PASS) [4665206923] destination_number(4665206923) =~ /4665206923/ break=on-false
  164. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(effective_destination_number=4665206923)
  165. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  166. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  167. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(callstart=2022-03-10 10:59:28)
  168. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(hangup_after_bridge=true)
  169. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(continue_on_fail=TRUE)
  170. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(account_id=7)
  171. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(parent_id=4)
  172. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(entity_id=0)
  173. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(call_processed=internal)
  174. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(call_direction=local)
  175. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(accountname=default)
  176. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(origination_rates=ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:17|MARKUP:0|CI:0|ACCID:7||ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:1|MARKUP:0|CI:0|ACCID:4)
  177. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(calltype=LOCAL)
  178. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action set(receiver_accid=5)
  179. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action export(presence_data=x//4|||Reseller's cust(9191680902)|||^4665206923.* // Local // 0||||||Local|||117.247.91.162)
  180. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action export(presence_data=||||||||||||LOCAL|||192.168.1.13)
  181. Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Action bridge([leg_timeout=30]user/4665206923@${domain_name})
  182. |--- Dialplan: Processing recursive conditions level:1 [4665206923_recur_1] require-nested=TRUE
  183. |--- Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 Regex (FAIL) [4665206923_recur_1] ${cond(${user_data 4665206923@${domain_name} param vm-enabled} == true ? YES : NO)}(NO) =~ /^YES$/ break=on-false
  184. |--- Dialplan: sofia/default/9191680902@w07version61.astppbilling.org:5074 ANTI-Action hangup(${originate_disposition})
  185. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_core_state_machine.c:281 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State Change CS_ROUTING -> CS_EXECUTE
  186. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State ROUTING going to sleep
  187. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_EXECUTE (Cur 1 Tot 20)
  188. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_core_state_machine.c:647 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State EXECUTE
  189. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_sofia.c:213 sofia/default/9191680902@w07version61.astppbilling.org:5074 SOFIA EXECUTE
  190. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_core_state_machine.c:323 sofia/default/9191680902@w07version61.astppbilling.org:5074 Standard EXECUTE
  191. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(effective_destination_number=4665206923)
  192. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [effective_destination_number]=[4665206923]
  193. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(bridge_pre_execute_bleg_app=sched_hangup)
  194. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [bridge_pre_execute_bleg_app]=[sched_hangup]
  195. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  196. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  197. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(callstart=2022-03-10 10:59:28)
  198. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [callstart]=[2022-03-10 10:59:28]
  199. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(hangup_after_bridge=true)
  200. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [hangup_after_bridge]=[true]
  201. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(continue_on_fail=TRUE)
  202. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [continue_on_fail]=[TRUE]
  203. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(account_id=7)
  204. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [account_id]=[7]
  205. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(parent_id=4)
  206. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [parent_id]=[4]
  207. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(entity_id=0)
  208. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [entity_id]=[0]
  209. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(call_processed=internal)
  210. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [call_processed]=[internal]
  211. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(call_direction=local)
  212. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [call_direction]=[local]
  213. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(accountname=default)
  214. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [accountname]=[default]
  215. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(origination_rates=ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:17|MARKUP:0|CI:0|ACCID:7||ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:1|MARKUP:0|CI:0|ACCID:4)
  216. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [origination_rates]=[ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:17|MARKUP:0|CI:0|ACCID:7||ID:0|CODE:^4665206923.*|DESTINATION:Local|CONNECTIONCOST:0|INCLUDEDSECONDS:0|CT:0|COST:0|INC:60|INITIALBLOCK:0|RATEGROUP:1|MARKUP:0|CI:0|ACCID:4]
  217. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(calltype=LOCAL)
  218. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [calltype]=[LOCAL]
  219. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 set(receiver_accid=5)
  220. 2022-03-10 10:59:28.775485 95.87% [DEBUG] mod_dptools.c:1685 SET sofia/default/9191680902@w07version61.astppbilling.org:5074 [receiver_accid]=[5]
  221. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 export(presence_data=x//4|||Reseller's cust(9191680902)|||^4665206923.* // Local // 0||||||Local|||117.247.91.162)
  222. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x//4|||Reseller's cust(9191680902)|||^4665206923.* // Local // 0||||||Local|||117.247.91.162]
  223. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 export(presence_data=||||||||||||LOCAL|||192.168.1.13)
  224. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[||||||||||||LOCAL|||192.168.1.13]
  225. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 bridge([leg_timeout=30]user/4665206923@w07version61.astppbilling.org)
  226. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_channel.c:1269 sofia/default/9191680902@w07version61.astppbilling.org:5074 EXPORTING[export_vars] [presence_data]=[||||||||||||LOCAL|||192.168.1.13] to event
  227. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_channel.c:1269 sofia/default/9191680902@w07version61.astppbilling.org:5074 EXPORTING[export_vars] [presence_data]=[||||||||||||LOCAL|||192.168.1.13] to event
  228. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
  229. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_ivr_originate.c:2843 Parsing session specific variables
  230. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_channel.c:1269 sofia/default/9191680902@w07version61.astppbilling.org:5074 EXPORTING[export_vars] [presence_data]=[||||||||||||LOCAL|||192.168.1.13] to event
  231. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_channel.c:1269 sofia/default/9191680902@w07version61.astppbilling.org:5074 EXPORTING[export_vars] [presence_data]=[||||||||||||LOCAL|||192.168.1.13] to event
  232. 2022-03-10 10:59:28.775485 95.87% [DEBUG] switch_ivr_originate.c:2281 Parsing global variables
  233. 2022-03-10 10:59:28.795484 95.87% [NOTICE] switch_ivr_originate.c:3039 Cannot create outgoing channel of type [error] cause: [USER_NOT_REGISTERED]
  234. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 606 [USER_NOT_REGISTERED]
  235. 2022-03-10 10:59:28.795484 95.87% [NOTICE] switch_ivr_originate.c:3039 Cannot create outgoing channel of type [user] cause: [USER_NOT_REGISTERED]
  236. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_ivr_originate.c:4035 Originate Resulted in Error Cause: 606 [USER_NOT_REGISTERED]
  237. 2022-03-10 10:59:28.795484 95.87% [INFO] mod_dptools.c:3653 Originate Failed.  Cause: USER_NOT_REGISTERED
  238. EXECUTE [depth=0] sofia/default/9191680902@w07version61.astppbilling.org:5074 hangup(USER_NOT_REGISTERED)
  239. 2022-03-10 10:59:28.795484 95.87% [NOTICE] mod_dptools.c:1387 Hangup sofia/default/9191680902@w07version61.astppbilling.org:5074 [CS_EXECUTE] [USER_NOT_REGISTERED]
  240. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_session.c:2983 sofia/default/9191680902@w07version61.astppbilling.org:5074 skip receive message [PHONE_EVENT] (channel is hungup already)
  241. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:647 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State EXECUTE going to sleep
  242. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_HANGUP (Cur 1 Tot 20)
  243. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:844 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Callstate Change RINGING -> HANGUP
  244. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State HANGUP
  245. 2022-03-10 10:59:28.795484 95.87% [DEBUG] mod_sofia.c:468 Channel sofia/default/9191680902@w07version61.astppbilling.org:5074 hanging up, cause: USER_NOT_REGISTERED
  246. 2022-03-10 10:59:28.795484 95.87% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 480
  247. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:59 sofia/default/9191680902@w07version61.astppbilling.org:5074 Standard HANGUP, cause: USER_NOT_REGISTERED
  248. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State HANGUP going to sleep
  249. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:616 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State Change CS_HANGUP -> CS_REPORTING
  250. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_REPORTING (Cur 1 Tot 20)
  251. 2022-03-10 10:59:28.795484 95.87% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State REPORTING
  252. 2022-03-10 10:59:28.795484 95.87% [INFO] mod_json_cdr.c:271 Process [bfa09f6f-1415-466c-bd93-1aee01685128.cdr.json]
  253. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:168 sofia/default/9191680902@w07version61.astppbilling.org:5074 Standard REPORTING, cause: USER_NOT_REGISTERED
  254. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State REPORTING going to sleep
  255. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:607 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State Change CS_REPORTING -> CS_DESTROY
  256. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_session.c:1753 Session 20 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Locked, Waiting on external entities
  257. 2022-03-10 10:59:28.835569 95.87% [NOTICE] switch_core_session.c:1771 Session 20 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Ended
  258. 2022-03-10 10:59:28.835569 95.87% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/9191680902@w07version61.astppbilling.org:5074 [CS_DESTROY]
  259. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:735 (sofia/default/9191680902@w07version61.astppbilling.org:5074) Running State Change CS_DESTROY (Cur 0 Tot 20)
  260. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State DESTROY
  261. 2022-03-10 10:59:28.835569 95.87% [DEBUG] mod_sofia.c:379 sofia/default/9191680902@w07version61.astppbilling.org:5074 SOFIA DESTROY
  262. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:175 sofia/default/9191680902@w07version61.astppbilling.org:5074 Standard DESTROY
  263. 2022-03-10 10:59:28.835569 95.87% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9191680902@w07version61.astppbilling.org:5074) State DESTROY going to sleep
  264. freeswitch@ip-172-31-14-218>
  265. freeswitch@ip-172-31-14-218>
  266. freeswitch@ip-172-31-14-218>
  267. freeswitch@ip-172-31-14-218>
  268. freeswitch@ip-172-31-14-218>