From Freeswicthlog, 2 Months ago, written in FreeSWITCH.
- view diff
Embed
  1. span style="color: cornflowerblue; font-weight: bold;"> 2024-03-06 10:53:40.072805 35.03% [NOTICE] switch_channel.c:1142 New Channel sofia/default/100@1.1.1.1 [90214da9-79c4-46c6-9a65-0c68273eeb24]
  2. 2024-03-06 10:53:40.072805 35.03% [DEBUG] switch_core_state_machine.c:581 (sofia/default/100@1.1.1.1) Running State Change CS_NEW (Cur 1 Tot 24764)
  3. 2024-03-06 10:53:40.072805 35.03% [INFO] sofia.c:10459 sofia/default/100@1.1.1.1 receiving invite from 165.22.241.242:60149 version: 1.10.10-release  64bit call-id: 965562644477320494040068
  4. 2024-03-06 10:53:40.072805 35.03% [DEBUG] sofia.c:10553 verifying acl "default" for ip/port 165.22.241.242:0.
  5. 2024-03-06 10:53:40.072805 35.03% [WARNING] sofia_reg.c:1842 SIP auth challenge (INVITE) on sofia profile 'default' for [100@1.1.1.1] from ip 165.22.241.242
  6. 2024-03-06 10:53:40.072805 35.03% [DEBUG] switch_core_state_machine.c:600 (sofia/default/100@1.1.1.1) State NEW
  7. 2024-03-06 10:53:40.072805 35.03% [DEBUG] sofia.c:2419 detaching session 90214da9-79c4-46c6-9a65-0c68273eeb24
  8. 2024-03-06 10:53:50.112816 35.23% [WARNING] switch_core_state_machine.c:684 90214da9-79c4-46c6-9a65-0c68273eeb24 sofia/default/100@1.1.1.1 Abandoned
  9. 2024-03-06 10:53:50.112816 35.23% [NOTICE] switch_core_state_machine.c:687 Hangup sofia/default/100@1.1.1.1 [CS_NEW] [WRONG_CALL_STATE]
  10. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:581 (sofia/default/100@1.1.1.1) Running State Change CS_HANGUP (Cur 1 Tot 24764)
  11. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:844 (sofia/default/100@1.1.1.1) Callstate Change DOWN -> HANGUP
  12. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:846 (sofia/default/100@1.1.1.1) State HANGUP
  13. 2024-03-06 10:53:50.112816 35.23% [DEBUG] mod_sofia.c:469 Channel sofia/default/100@1.1.1.1 hanging up, cause: WRONG_CALL_STATE
  14. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:59 sofia/default/100@1.1.1.1 Standard HANGUP, cause: WRONG_CALL_STATE
  15. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:846 (sofia/default/100@1.1.1.1) State HANGUP going to sleep
  16. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:616 (sofia/default/100@1.1.1.1) State Change CS_HANGUP -> CS_REPORTING
  17. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:581 (sofia/default/100@1.1.1.1) Running State Change CS_REPORTING (Cur 1 Tot 24764)
  18. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:932 (sofia/default/100@1.1.1.1) State REPORTING
  19. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:168 sofia/default/100@1.1.1.1 Standard REPORTING, cause: WRONG_CALL_STATE
  20. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:932 (sofia/default/100@1.1.1.1) State REPORTING going to sleep
  21. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:607 (sofia/default/100@1.1.1.1) State Change CS_REPORTING -> CS_DESTROY
  22. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_session.c:1744 Session 24764 (sofia/default/100@1.1.1.1) Locked, Waiting on external entities
  23. 2024-03-06 10:53:50.112816 35.23% [NOTICE] switch_core_session.c:1762 Session 24764 (sofia/default/100@1.1.1.1) Ended
  24. 2024-03-06 10:53:50.112816 35.23% [NOTICE] switch_core_session.c:1766 Close Channel sofia/default/100@1.1.1.1 [CS_DESTROY]
  25. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:735 (sofia/default/100@1.1.1.1) Running State Change CS_DESTROY (Cur 0 Tot 24764)
  26. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:745 (sofia/default/100@1.1.1.1) State DESTROY
  27. 2024-03-06 10:53:50.112816 35.23% [DEBUG] mod_sofia.c:380 sofia/default/100@1.1.1.1 SOFIA DESTROY
  28. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:175 sofia/default/100@1.1.1.1 Standard DESTROY
  29. 2024-03-06 10:53:50.112816 35.23% [DEBUG] switch_core_state_machine.c:745 (sofia/default/100@1.1.1.1) State DESTROY going to sleep
  30. 2024-03-06 10:53:55.692808 35.33% [NOTICE] switch_channel.c:1142 New Channel sofia/default/8481338745@demov6.astppbilling.org [a26f9e9d-2193-4846-9ef8-d4b3be04e7b5]
  31. 2024-03-06 10:53:55.692808 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8481338745@demov6.astppbilling.org) Running State Change CS_NEW (Cur 1 Tot 24765)
  32. 2024-03-06 10:53:55.692808 35.33% [INFO] sofia.c:10459 sofia/default/8481338745@demov6.astppbilling.org receiving invite from 189.56.44.140:65476 version: 1.10.10-release  64bit call-id: MjJmYWYyNWE4YWU2MTJlNWQ0NjczZThiNTIxZDM5NGY.
  33. 2024-03-06 10:53:55.692808 35.33% [DEBUG] sofia.c:10553 verifying acl "default" for ip/port 189.56.44.140:0.
  34. 2024-03-06 10:53:55.692808 35.33% [DEBUG] sofia.c:10582 IP 189.56.44.140 Approved by acl "default[]". Access Granted.
  35. 2024-03-06 10:53:55.712810 35.33% [DEBUG] sofia.c:7493 Channel sofia/default/8481338745@demov6.astppbilling.org entering state [received][100]
  36. 2024-03-06 10:53:55.712810 35.33% [DEBUG] sofia.c:7503 Remote SDP:
  37. v=0
  38. o=Zoiper_user 0 0 IN IP4 189.56.44.140
  39. s=Zoiper_session
  40. i=(o=IN IP4 10.0.20.46)
  41. c=IN IP4 189.56.44.140
  42. t=0 0
  43. m=audio 20488 RTP/AVP 3 0 8 110 98 101
  44. a=rtpmap:3 GSM/8000
  45. a=rtpmap:0 PCMU/8000
  46. a=rtpmap:8 PCMA/8000
  47. a=rtpmap:110 speex/8000
  48. a=rtpmap:98 iLBC/8000
  49. a=fmtp:98 mode=20
  50. a=rtpmap:101 telephone-event/8000
  51. a=fmtp:101 0-15
  52.  
  53. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  54. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  55. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [GSM:3:8000:20:13200:1]/[G729:18:8000:20:8000:1]
  56. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  57. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  58. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  59. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  60. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  61. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5588 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  62. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  63. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[G729:18:8000:20:8000:1]
  64. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMA:8:8000:20:64000:1]
  65. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [speex:110:8000:20:0:1]/[PCMU:0:8000:20:64000:1]
  66. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [speex:110:8000:20:0:1]/[G729:18:8000:20:8000:1]
  67. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMA:8:8000:20:64000:1]
  68. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [iLBC:98:8000:30:0:1]/[PCMU:0:8000:20:64000:1]
  69. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5526 Audio Codec Compare [iLBC:98:8000:30:0:1]/[G729:18:8000:20:8000:1]
  70. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5438 Set telephone-event payload to 101@8000
  71. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:3734 Set Codec sofia/default/8481338745@demov6.astppbilling.org PCMU/8000 20 ms 160 samples 64000 bits 1 channels
  72. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_codec.c:111 sofia/default/8481338745@demov6.astppbilling.org Original read codec set to PCMU:0
  73. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5798 Set telephone-event payload to 101@8000
  74. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_media.c:5856 sofia/default/8481338745@demov6.astppbilling.org Set 2833 dtmf send payload to 101 recv payload to 101
  75. 2024-03-06 10:53:55.712810 35.33% [DEBUG] sofia.c:7927 (sofia/default/8481338745@demov6.astppbilling.org) State Change CS_NEW -> CS_INIT
  76. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:600 (sofia/default/8481338745@demov6.astppbilling.org) State NEW
  77. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8481338745@demov6.astppbilling.org) Running State Change CS_INIT (Cur 1 Tot 24765)
  78. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8481338745@demov6.astppbilling.org) State INIT
  79. 2024-03-06 10:53:55.712810 35.33% [DEBUG] mod_sofia.c:97 sofia/default/8481338745@demov6.astppbilling.org SOFIA INIT
  80. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:40 sofia/default/8481338745@demov6.astppbilling.org Standard INIT
  81. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:48 (sofia/default/8481338745@demov6.astppbilling.org) State Change CS_INIT -> CS_ROUTING
  82. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:624 (sofia/default/8481338745@demov6.astppbilling.org) State INIT going to sleep
  83. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8481338745@demov6.astppbilling.org) Running State Change CS_ROUTING (Cur 1 Tot 24765)
  84. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_channel.c:2399 (sofia/default/8481338745@demov6.astppbilling.org) Callstate Change DOWN -> RINGING
  85. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8481338745@demov6.astppbilling.org) State ROUTING
  86. 2024-03-06 10:53:55.712810 35.33% [DEBUG] mod_sofia.c:158 sofia/default/8481338745@demov6.astppbilling.org SOFIA ROUTING
  87. 2024-03-06 10:53:55.712810 35.33% [DEBUG] switch_core_state_machine.c:230 sofia/default/8481338745@demov6.astppbilling.org Standard ROUTING
  88. 2024-03-06 10:53:55.712810 35.33% [INFO] mod_dialplan_xml.c:639 Processing Teste <8481338745>->13054472817 in context default
  89. 2024-03-06 10:53:55.732792 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] CACHE FAIL
  90. 2024-03-06 10:53:55.732792 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  91. 2024-03-06 10:53:55.732792 35.33% [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','stir_shaken')
  92. 2024-03-06 10:53:55.732792 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  93. 2024-03-06 10:53:55.752985 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  94. 2024-03-06 10:53:55.752985 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 13054472817
  95. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '13054472817' limit 1
  96. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '13054472817' AND status=0 limit 1
  97. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '13054472817' and status=0 LIMIT 1
  98. 2024-03-06 10:53:55.752985 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER8481338745
  99. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  100. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'demov6.astppbilling.org' limit 1
  101. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '2' and username = '13054472817' limit 1
  102. 2024-03-06 10:53:55.752985 35.33% [WARNING] switch_cpp.cpp:1465 [ASTPP] [FAXER] Custom Caller ID
  103. 2024-03-06 10:53:55.752985 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : Teste / 8481338745
  104. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 72817
  105. 2024-03-06 10:53:55.752985 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 130544 AND status=0 limit 1
  106. 2024-03-06 10:53:55.752985 35.33% [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 ="13054472817" LIMIT 1
  107. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,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 ="13054472817" LIMIT 1
  108. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  109. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  110. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="13054472817"  AND domains.domain="demov6.astppbilling.org" limit 1
  111. 2024-03-06 10:53:55.772809 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : outbound
  112. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [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("189.56.44.140") 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 "13054472817"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  113. 2024-03-06 10:53:55.772809 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 4727985745]
  114. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_acc_info] Query :SELECT count(id) as id FROM local_number WHERE number =13054472817
  115. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE (number = "4727985745" OR id = "4727985745") AND deleted = 0 limit 1
  116. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^13054472817.*' OR blocked_patterns = '^1305447281.*' OR blocked_patterns = '^130544728.*' OR blocked_patterns = '^13054472.*' OR blocked_patterns = '^1305447.*' OR blocked_patterns = '^130544.*' OR blocked_patterns = '^13054.*' OR blocked_patterns = '^1305.*' OR blocked_patterns = '^130.*' OR blocked_patterns = '^13.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 2 limit 1
  117. 2024-03-06 10:53:55.772809 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="13054472817" AND (accountid = 0 OR status = 1) LIMIT 1
  118. 2024-03-06 10:53:55.792790 35.33% [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 = '^13054472817.*' OR patterns = '^1305447281.*' OR patterns = '^130544728.*' OR patterns = '^13054472.*' OR patterns = '^1305447.*' OR patterns = '^130544.*' OR patterns = '^13054.*' OR patterns = '^1305.*' OR patterns = '^130.*' OR patterns = '^13.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 2 ORDER BY LENGTH(PKGPTR.patterns) DESC
  119. 2024-03-06 10:53:55.792790 35.33% [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 ="13054472817" AND A.accountid = '2' limit 1
  120. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 13054472817
  121. 2024-03-06 10:53:55.792790 35.33% [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 ="13054472817" LIMIT 1
  122. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,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 ="13054472817" LIMIT 1
  123. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  124. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  125. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.id as sip_id,sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation,sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="13054472817"  AND domains.domain="demov6.astppbilling.org" limit 1
  126. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : outbound
  127. 2024-03-06 10:53:55.792790 35.33% [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 = '13054472817' OR number = '1305447281' OR number = '130544728' OR number = '13054472' OR number = '1305447' OR number = '130544' OR number = '13054' OR number = '1305' OR number = '130' OR number = '13' OR number = '1' OR number ='--') OR (number = '13054472817*' OR number = '1305447281*' OR number = '130544728*' OR number = '13054472*' OR number = '1305447*' OR number = '130544*' OR number = '13054*' OR number = '1305*' OR number = '130*' OR number = '13*' OR number = '1*' OR number ='--') OR (number = '8481338745' OR number = '848133874' OR number = '84813387' OR number = '8481338' OR number = '848133' OR number = '84813' OR number = '8481' OR number = '848' OR number = '84' OR number = '8' OR number ='--') OR (number = '8481338745*' OR number = '848133874*' OR number = '84813387*' OR number = '8481338*' OR number = '848133*' OR number = '84813*' OR number = '8481*' OR number = '848*' OR number = '84*' OR number = '8*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  128. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  129. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '13054472817' OR routing_prefix = '1305447281' OR routing_prefix = '130544728' OR routing_prefix = '13054472' OR routing_prefix = '1305447' OR routing_prefix = '130544' OR routing_prefix = '13054' OR routing_prefix = '1305' OR routing_prefix = '130' OR routing_prefix = '13' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  130. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  131. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 2
  132. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 4727985745
  133. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 23.2317
  134. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  135. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 24
  136. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  137. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  138. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 24 AND status = 0
  139. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :outbound
  140. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 24 AND status = 0
  141. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^13054472817.*' OR pattern = '^1305447281.*' OR pattern = '^130544728.*' OR pattern = '^13054472.*' OR pattern = '^1305447.*' OR pattern = '^130544.*' OR pattern = '^13054.*' OR pattern = '^1305.*' OR pattern = '^130.*' OR pattern = '^13.*' OR pattern = '^1.*' OR pattern ='--') AND (caller_id_pattern = '^8481338745.*' OR caller_id_pattern = '^848133874.*' OR caller_id_pattern = '^84813387.*' OR caller_id_pattern = '^8481338.*' OR caller_id_pattern = '^848133.*' OR caller_id_pattern = '^84813.*' OR caller_id_pattern = '^8481.*' OR caller_id_pattern = '^848.*' OR caller_id_pattern = '^84.*' OR caller_id_pattern = '^8.*' OR caller_id_pattern ='^.*') AND status = 0 AND effective_date <= UTC_TIMESTAMP() AND (pricelist_id = 24 OR accountid=2)  ORDER BY accountid DESC,LENGTH(pattern) DESC,LENGTH(caller_id_pattern) DESC,cost DESC,effective_date DESC LIMIT 1
  142. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : outbound
  143. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]Going For Check Demand Base Routing
  144. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] OLD COST:0.1000000000
  145. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing]pricelist_id:24
  146. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] Query :SELECT demand_based_condition,holiday,timezone_name from demand_based_routing where pricelist_id = '24' and status=0
  147. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Demand_Base_Routing] NEW COST:0.1000000000
  148. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  149. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 21
  150. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.0000000000
  151. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  152. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.1000000000
  153. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment :
  154. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 0
  155. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 2
  156. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Trunk ID: 1,1,1
  157. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Routing type:
  158. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  159. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [Shadow_billing_rates]SHADOWBILLING:0|ID:21|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|CT:|COST:0.1000000000|INC:1|INITIALBLOCK:1|RATEGROUP:24|MARKUP:0|CI:0|ACCID:2!!!
  160. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your23.2317 balance Accountid 2 !!!
  161. 2024-03-06 10:53:55.792790 35.33% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Limiting Call To Config Max Length 100 mins!
  162. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE ID 2
  163. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE RATE 0.1000000000
  164. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE CONNECT COST 0.0000000000
  165. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INITIAL INC 1
  166. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INC 1
  167. 2024-03-06 10:53:55.792790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  168. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query Rate Carrier Id :
  169. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES_TRUNKS] Query :SELECT GROUP_CONCAT(trunk_id) as ids FROM routing WHERE pricelist_id=24 ORDER by id asc
  170. 2024-03-06 10:53:55.792790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.sip_cid_type,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^13054472817.*' OR pattern = '^1305447281.*' OR pattern = '^130544728.*' OR pattern = '^13054472.*' OR pattern = '^1305447.*' OR pattern = '^130544.*' OR pattern = '^13054.*' OR pattern = '^1305.*' OR pattern = '^130.*' OR pattern = '^13.*' OR pattern = '^1.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (25) AND TR.effective_date <= UTC_TIMESTAMP() ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence,TR.effective_date DESC
  171. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Termination Rates Information ===================
  172. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 43
  173. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Code : ^1.*
  174. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Destination :
  175. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.0000000000
  176. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Free Seconds : 0
  177. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Prefix : ^1.*
  178. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Strip :
  179. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Prepend :
  180. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Carrier id : 25
  181. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] carrier_name : TestD
  182. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] dialplan_variable :
  183. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Failover gateway :
  184. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Vendor id : 3
  185. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] Max channels : 0
  186. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================END OF TERMINATION RATES=======================
  187. 2024-03-06 10:53:55.812790 35.33% [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 = 2 AND status=0 LIMIT 1
  188. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  189. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_sip_device_info_for_did_pstn_call] Query :SELECT username FROM sip_devices WHERE username = '8481338745' and status = 0 limit 1
  190. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  191. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 0
  192. 2024-03-06 10:53:55.812790 35.33% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : outbound
  193. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 24 AND status = 0
  194. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from accounts where id = 3) AND status=0 limit 1
  195. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,out_caller_id_terminate,number_terminate,dst_base_cid FROM localization WHERE id=(SELECT localization_id from trunks where id = 25) AND status=0 limit 1
  196. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_LOCALIZATION] Query :"972/454566788899/*/*".....8481338745DBCLI13054472817
  197. 2024-03-06 10:53:55.812790 35.33% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] Before- Localization CLI/DST : 8481338745DBCLI13054472817
  198. 2024-03-06 10:53:55.812790 35.33% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [DONUMBERTRANSLATION] After- Localization CLI/DST : 8481338745
  199. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [sip_codec_for_outbound] Query :SELECT sip_devices.codec as sip_codec FROM sip_devices as sip_devices,accounts as  accounts ,domains WHERE accounts.id=domains.accountid AND accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="8481338745"  AND domains.domain="demov6.astppbilling.org" limit 1
  200. 2024-03-06 10:53:55.812790 35.33% [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 ="13054472817" LIMIT 1
  201. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_DID_CALL_TRANSFER] Query :SELECT A.id as id,A.provider_id as provider_id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag,A.transfer_status,A.busy_status,A.no_answer_status,A.always_status,A.transfer_call_type,A.transfer_extensions,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 ="13054472817" LIMIT 1
  202. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  203. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  204. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [attestation] COMING FOR STIR/SHAKEN :
  205. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [attestation] COMING FOR STIR/SHAKEN For Enable/Disable:0
  206. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [attestation] COMING FOR STIR/SHAKEN For Outbound:0
  207. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [attestation] COMING FOR STIR/SHAKEN For Outbound:0
  208. 2024-03-06 10:53:55.812790 35.33% [WARNING] switch_cpp.cpp:1465 [ASTPP] User applicable_on_outbound_calls : 0
  209. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [outbound_call_prefixes]: 1
  210. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [outbound_call_prefixes]: 0
  211. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [tmp_value]: 1
  212. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [first_prefix]: 1
  213. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [attestation] Query :Select count(*) as count from dids where number='8481338745' and status=0 and accountid =2
  214. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [attestation] COUNT: 0
  215. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [return_flag_outbound_attestation]: B
  216. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:
  217. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  218. <document type="freeswitch/xml">
  219. <section name="dialplan" description="ASTPP Dialplan">
  220. <context name="default">
  221. <extension name="13054472817">
  222. <condition field="destination_number" expression="13054472817">
  223. <action application="set" data="effective_destination_number=13054472817"/>
  224. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  225. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  226. <action application="set" data="type=0"/>
  227. <action application="set" data="nibble_account=2"/>
  228. <action application="set" data="nibble_rate=0.1000000000"/>
  229. <action application="set" data="nibble_minimum=0.0000000000"/>
  230. <action application="set" data="nibble_increment=30"/>
  231. <action application="nibblebill" data="heartbeat 30"/>
  232. <action application="set" data="callstart=2024-03-06 10:53:55"/>
  233. <action application="set" data="hangup_after_bridge=true"/>
  234. <action application="set" data="continue_on_fail=TRUE"/>
  235. <action application="set" data="account_id=2"/>
  236. <action application="set" data="parent_id=0"/>
  237. <action application="set" data="entity_id=0"/>
  238. <action application="set" data="call_processed=internal"/>
  239. <action application="set" data="call_direction=outbound"/>
  240. <action application="set" data="accountname=Rising"/>
  241. <action application="set" data="filename1=astpp.pbx.lua"/>
  242. <action application="set" data="origination_rates=SHADOWBILLING:0|ID:21|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|CT:|COST:0.1000000000|INC:1|INITIALBLOCK:1|RATEGROUP:24|MARKUP:0|CI:0|ACCID:2"/>
  243. <action application="set" data="original_caller_id_name=Teste"/>
  244. <action application="set" data="original_caller_id_number=8481338745"/>
  245. <action application="limit" data="db 4727985745 user_4727985745 1 "/>
  246.  
  247. <action application="export" data="is_recording=1"/>
  248. <action application="export" data="media_bug_answer_req=true"/>
  249. <action application="export" data="RECORD_STEREO=true"/>
  250. <action application="export" data="record_sample_rate=8000"/>
  251. <action application="export" data="execute_on_answer=record_session $${recordings_dir}/${uuid}.wav"/>
  252. <action application="set" data="effective_caller_id_name=Teste"/>
  253. <action application="set" data="effective_caller_id_number=8481338745"/>
  254. <action application="set" data="calltype=STANDARD"/>
  255. <action application="set" data="termination_rates=ID:43|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|COST:0.0000000000|INC:0|INITIALBLOCK:0|TRUNK:25|PROVIDER:3"/>
  256. <action application="set" data="trunk_id=25"/>
  257. <action application="set" data="provider_id=3"/>
  258. <action application="set" data="rate_flag=0"/>
  259. <action application="set" data="daily_call_credit_limit=0.00000"/>
  260. <action application="set" data="monthly_call_credit_limit=0.00000"/>
  261. <action application="set" data="daily_call_used_limit=0.00000"/>
  262. <action application="set" data="monthly_call_used_limit=0.00000"/>
  263. <action application="set" data="quality_trunk_seq=25"/>
  264. <action application="set" data="force_trunk_flag=0"/>
  265. <action application="export" data="presence_data=trunk_id=25"/>
  266. <action application="set" data="intcall=0"/>
  267. <action application="export" data="presence_id=13054472817"/>
  268. <action application="export" data="presence_data=x|||Inextrix(4727985745)|||^1.* //  // 0.1000000000 |||Test Rising // ^1.* //  // 0.0000000000 // trunk_id=25|||STD|||189.56.44.140"/>
  269. <action application="set" data="sip_h_X-ASTPP-Stir-Verification=Not Verified"/>
  270. <action application="export" data="sip_h_X-ASTPP-Stir-Verification=Not Verified"/>
  271. <action application="set" data="stir_status=2"/>
  272. <action application="set" data="sip_stir_shaken_attest=B"/>
  273. <action application="bridge" data="{leg_timeout=0,sip_stir_shaken_attest=B}[leg_timeout=0]sofia/gateway/TestD/13054472817"/>
  274. </condition>
  275. </extension>
  276. </context>
  277. </section>
  278. </document>
  279. Dialplan: sofia/default/8481338745@demov6.astppbilling.org parsing [default->13054472817] continue=false
  280. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Regex (PASS) [13054472817] destination_number(13054472817) =~ /13054472817/ break=on-false
  281. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(effective_destination_number=13054472817)
  282. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(bridge_pre_execute_bleg_app=sched_hangup)
  283. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  284. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(type=0)
  285. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(nibble_account=2)
  286. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(nibble_rate=0.1000000000)
  287. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(nibble_minimum=0.0000000000)
  288. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(nibble_increment=30)
  289. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action nibblebill(heartbeat 30)
  290. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(callstart=2024-03-06 10:53:55)
  291. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(hangup_after_bridge=true)
  292. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(continue_on_fail=TRUE)
  293. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(account_id=2)
  294. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(parent_id=0)
  295. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(entity_id=0)
  296. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(call_processed=internal)
  297. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(call_direction=outbound)
  298. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(accountname=Rising)
  299. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(filename1=astpp.pbx.lua)
  300. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(origination_rates=SHADOWBILLING:0|ID:21|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|CT:|COST:0.1000000000|INC:1|INITIALBLOCK:1|RATEGROUP:24|MARKUP:0|CI:0|ACCID:2)
  301. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(original_caller_id_name=Teste)
  302. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(original_caller_id_number=8481338745)
  303. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action limit(db 4727985745 user_4727985745 1 )
  304. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(is_recording=1)
  305. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(media_bug_answer_req=true)
  306. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(RECORD_STEREO=true)
  307. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(record_sample_rate=8000)
  308. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(execute_on_answer=record_session $${recordings_dir}/${uuid}.wav)
  309. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(effective_caller_id_name=Teste)
  310. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(effective_caller_id_number=8481338745)
  311. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(calltype=STANDARD)
  312. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(termination_rates=ID:43|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|COST:0.0000000000|INC:0|INITIALBLOCK:0|TRUNK:25|PROVIDER:3)
  313. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(trunk_id=25)
  314. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(provider_id=3)
  315. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(rate_flag=0)
  316. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(daily_call_credit_limit=0.00000)
  317. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(monthly_call_credit_limit=0.00000)
  318. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(daily_call_used_limit=0.00000)
  319. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(monthly_call_used_limit=0.00000)
  320. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(quality_trunk_seq=25)
  321. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(force_trunk_flag=0)
  322. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(presence_data=trunk_id=25)
  323. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(intcall=0)
  324. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(presence_id=13054472817)
  325. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(presence_data=x|||Inextrix(4727985745)|||^1.* //  // 0.1000000000 |||Test Rising // ^1.* //  // 0.0000000000 // trunk_id=25|||STD|||189.56.44.140)
  326. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(sip_h_X-ASTPP-Stir-Verification=Not Verified)
  327. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action export(sip_h_X-ASTPP-Stir-Verification=Not Verified)
  328. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(stir_status=2)
  329. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action set(sip_stir_shaken_attest=B)
  330. Dialplan: sofia/default/8481338745@demov6.astppbilling.org Action bridge({leg_timeout=0,sip_stir_shaken_attest=B}[leg_timeout=0]sofia/gateway/TestD/13054472817)
  331. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_core_state_machine.c:281 (sofia/default/8481338745@demov6.astppbilling.org) State Change CS_ROUTING -> CS_EXECUTE
  332. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_core_state_machine.c:640 (sofia/default/8481338745@demov6.astppbilling.org) State ROUTING going to sleep
  333. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8481338745@demov6.astppbilling.org) Running State Change CS_EXECUTE (Cur 1 Tot 24765)
  334. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8481338745@demov6.astppbilling.org) State EXECUTE
  335. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_sofia.c:213 sofia/default/8481338745@demov6.astppbilling.org SOFIA EXECUTE
  336. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_core_state_machine.c:323 sofia/default/8481338745@demov6.astppbilling.org Standard EXECUTE
  337. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(effective_destination_number=13054472817)
  338. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [effective_destination_number]=[13054472817]
  339. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(bridge_pre_execute_bleg_app=sched_hangup)
  340. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [bridge_pre_execute_bleg_app]=[sched_hangup]
  341. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  342. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  343. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(type=0)
  344. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [type]=[0]
  345. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(nibble_account=2)
  346. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [nibble_account]=[2]
  347. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(nibble_rate=0.1000000000)
  348. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [nibble_rate]=[0.1000000000]
  349. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(nibble_minimum=0.0000000000)
  350. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [nibble_minimum]=[0.0000000000]
  351. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(nibble_increment=30)
  352. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [nibble_increment]=[30]
  353. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org nibblebill(heartbeat 30)
  354. 2024-03-06 10:53:55.812790 35.33% [WARNING] switch_core_session.c:1684 sofia/default/8481338745@demov6.astppbilling.org using scheduler due to bypass media or media is not established.
  355. 2024-03-06 10:53:55.812790 35.33% [DEBUG] switch_scheduler.c:263 Added task 268 switch_core_session_sched_heartbeat (a26f9e9d-2193-4846-9ef8-d4b3be04e7b5) to run at 1709722465
  356. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(callstart=2024-03-06 10:53:55)
  357. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [callstart]=[2024-03-06 10:53:55]
  358. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(hangup_after_bridge=true)
  359. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [hangup_after_bridge]=[true]
  360. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(continue_on_fail=TRUE)
  361. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [continue_on_fail]=[TRUE]
  362. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(account_id=2)
  363. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [account_id]=[2]
  364. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(parent_id=0)
  365. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [parent_id]=[0]
  366. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(entity_id=0)
  367. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [entity_id]=[0]
  368. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(call_processed=internal)
  369. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [call_processed]=[internal]
  370. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(call_direction=outbound)
  371. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [call_direction]=[outbound]
  372. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(accountname=Rising)
  373. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [accountname]=[Rising]
  374. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(filename1=astpp.pbx.lua)
  375. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [filename1]=[astpp.pbx.lua]
  376. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(origination_rates=SHADOWBILLING:0|ID:21|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|CT:|COST:0.1000000000|INC:1|INITIALBLOCK:1|RATEGROUP:24|MARKUP:0|CI:0|ACCID:2)
  377. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [origination_rates]=[SHADOWBILLING:0|ID:21|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|CT:|COST:0.1000000000|INC:1|INITIALBLOCK:1|RATEGROUP:24|MARKUP:0|CI:0|ACCID:2]
  378. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(original_caller_id_name=Teste)
  379. 2024-03-06 10:53:55.812790 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [original_caller_id_name]=[Teste]
  380. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(original_caller_id_number=8481338745)
  381. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [original_caller_id_number]=[8481338745]
  382. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org limit(db 4727985745 user_4727985745 1 )
  383. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_limit.c:124 incr called: 4727985745_user_4727985745 max:1, interval:0
  384. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_db.c:194 Usage for 4727985745_user_4727985745 is now 1/1
  385. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(is_recording=1)
  386. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [is_recording]=[1]
  387. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(media_bug_answer_req=true)
  388. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [media_bug_answer_req]=[true]
  389. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(RECORD_STEREO=true)
  390. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [RECORD_STEREO]=[true]
  391. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(record_sample_rate=8000)
  392. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [record_sample_rate]=[8000]
  393. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(execute_on_answer=record_session /usr/local/freeswitch/recordings/a26f9e9d-2193-4846-9ef8-d4b3be04e7b5.wav)
  394. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [execute_on_answer]=[record_session /usr/local/freeswitch/recordings/a26f9e9d-2193-4846-9ef8-d4b3be04e7b5.wav]
  395. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(effective_caller_id_name=Teste)
  396. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [effective_caller_id_name]=[Teste]
  397. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(effective_caller_id_number=8481338745)
  398. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [effective_caller_id_number]=[8481338745]
  399. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(calltype=STANDARD)
  400. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [calltype]=[STANDARD]
  401. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(termination_rates=ID:43|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|COST:0.0000000000|INC:0|INITIALBLOCK:0|TRUNK:25|PROVIDER:3)
  402. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [termination_rates]=[ID:43|CODE:^1.*|DESTINATION:|CONNECTIONCOST:0.0000000000|INCLUDEDSECONDS:0|COST:0.0000000000|INC:0|INITIALBLOCK:0|TRUNK:25|PROVIDER:3]
  403. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(trunk_id=25)
  404. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [trunk_id]=[25]
  405. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(provider_id=3)
  406. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [provider_id]=[3]
  407. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(rate_flag=0)
  408. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [rate_flag]=[0]
  409. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(daily_call_credit_limit=0.00000)
  410. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [daily_call_credit_limit]=[0.00000]
  411. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(monthly_call_credit_limit=0.00000)
  412. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [monthly_call_credit_limit]=[0.00000]
  413. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(daily_call_used_limit=0.00000)
  414. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [daily_call_used_limit]=[0.00000]
  415. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(monthly_call_used_limit=0.00000)
  416. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [monthly_call_used_limit]=[0.00000]
  417. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(quality_trunk_seq=25)
  418. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [quality_trunk_seq]=[25]
  419. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(force_trunk_flag=0)
  420. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [force_trunk_flag]=[0]
  421. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(presence_data=trunk_id=25)
  422. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [presence_data]=[trunk_id=25]
  423. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(intcall=0)
  424. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [intcall]=[0]
  425. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(presence_id=13054472817)
  426. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [presence_id]=[13054472817]
  427. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(presence_data=x|||Inextrix(4727985745)|||^1.* //  // 0.1000000000 |||Test Rising // ^1.* //  // 0.0000000000 // trunk_id=25|||STD|||189.56.44.140)
  428. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [presence_data]=[x|||Inextrix(4727985745)|||^1.* //  // 0.1000000000 |||Test Rising // ^1.* //  // 0.0000000000 // trunk_id=25|||STD|||189.56.44.140]
  429. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(sip_h_X-ASTPP-Stir-Verification=Not Verified)
  430. 2024-03-06 10:53:55.832799 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [sip_h_X-ASTPP-Stir-Verification]=[Not Verified]
  431. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org export(sip_h_X-ASTPP-Stir-Verification=Not Verified)
  432. 2024-03-06 10:53:55.832799 35.33% [DEBUG] switch_channel.c:1334 EXPORT (export_vars) [sip_h_X-ASTPP-Stir-Verification]=[Not Verified]
  433. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(stir_status=2)
  434. 2024-03-06 10:53:55.852797 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [stir_status]=[2]
  435. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org set(sip_stir_shaken_attest=B)
  436. 2024-03-06 10:53:55.852797 35.33% [DEBUG] mod_dptools.c:1671 SET sofia/default/8481338745@demov6.astppbilling.org [sip_stir_shaken_attest]=[B]
  437. EXECUTE [depth=0] sofia/default/8481338745@demov6.astppbilling.org bridge({leg_timeout=0,sip_stir_shaken_attest=B}[leg_timeout=0]sofia/gateway/TestD/13054472817)
  438. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [is_recording]=[1] to event
  439. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [media_bug_answer_req]=[true] to event
  440. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [RECORD_STEREO]=[true] to event
  441. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [record_sample_rate]=[8000] to event
  442. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [execute_on_answer]=[record_session /usr/local/freeswitch/recordings/a26f9e9d-2193-4846-9ef8-d4b3be04e7b5.wav] to event
  443. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [presence_data]=[x|||Inextrix(4727985745)|||^1.* //  // 0.1000000000 |||Test Rising // ^1.* //  // 0.0000000000 // trunk_id=25|||STD|||189.56.44.140] to event
  444. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [presence_id]=[13054472817] to event
  445. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [presence_data]=[x|||Inextrix(4727985745)|||^1.* //  // 0.1000000000 |||Test Rising // ^1.* //  // 0.0000000000 // trunk_id=25|||STD|||189.56.44.140] to event
  446. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_channel.c:1288 sofia/default/8481338745@demov6.astppbilling.org EXPORTING[export_vars] [sip_h_X-ASTPP-Stir-Verification]=[Not Verified] to event
  447. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_ivr_originate.c:2297 Parsing global variables
  448. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_ivr_originate.c:2859 Parsing session specific variables
  449. 2024-03-06 10:53:55.852797 35.33% [NOTICE] switch_channel.c:1142 New Channel sofia/default/13054472817 [62e9984d-25b5-4261-acc2-aba1d7163ed2]
  450. 2024-03-06 10:53:55.852797 35.33% [DEBUG] mod_sofia.c:5110 (sofia/default/13054472817) State Change CS_NEW -> CS_INIT
  451. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/13054472817) Running State Change CS_INIT (Cur 2 Tot 24766)
  452. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:624 (sofia/default/13054472817) State INIT
  453. 2024-03-06 10:53:55.852797 35.33% [DEBUG] mod_sofia.c:97 sofia/default/13054472817 SOFIA INIT
  454. 2024-03-06 10:53:55.852797 35.33% [INFO] sofia_glue.c:1659 sofia/default/13054472817 sending invite call-id: (null)
  455. 2024-03-06 10:53:55.852797 35.33% [DEBUG] sofia_glue.c:1662 sofia/default/13054472817 sending invite version: 1.10.10-release  64bit
  456. Local SDP:
  457. v=0
  458. o=FreeSWITCH 1709695071 1709695072 IN IP4 65.108.61.118
  459. s=FreeSWITCH
  460. c=IN IP4 65.108.61.118
  461. t=0 0
  462. m=audio 27364 RTP/AVP 0 101
  463. a=rtpmap:0 PCMU/8000
  464. a=rtpmap:101 telephone-event/8000
  465. a=fmtp:101 0-15
  466. a=ptime:20
  467. a=sendrecv
  468.  
  469. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:40 sofia/default/13054472817 Standard INIT
  470. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:48 (sofia/default/13054472817) State Change CS_INIT -> CS_ROUTING
  471. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:624 (sofia/default/13054472817) State INIT going to sleep
  472. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/13054472817) Running State Change CS_ROUTING (Cur 2 Tot 24766)
  473. 2024-03-06 10:53:55.852797 35.33% [DEBUG] sofia.c:7493 Channel sofia/default/13054472817 entering state [calling][0]
  474. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:640 (sofia/default/13054472817) State ROUTING
  475. 2024-03-06 10:53:55.852797 35.33% [DEBUG] mod_sofia.c:158 sofia/default/13054472817 SOFIA ROUTING
  476. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_ivr_originate.c:67 (sofia/default/13054472817) State Change CS_ROUTING -> CS_CONSUME_MEDIA
  477. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:640 (sofia/default/13054472817) State ROUTING going to sleep
  478. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/13054472817) Running State Change CS_CONSUME_MEDIA (Cur 2 Tot 24766)
  479. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:659 (sofia/default/13054472817) State CONSUME_MEDIA
  480. 2024-03-06 10:53:55.852797 35.33% [DEBUG] switch_core_state_machine.c:659 (sofia/default/13054472817) State CONSUME_MEDIA going to sleep
  481. 2024-03-06 10:53:56.032792 35.33% [DEBUG] sofia.c:7493 Channel sofia/default/13054472817 entering state [terminated][403]
  482. 2024-03-06 10:53:56.032792 35.33% [NOTICE] sofia.c:8735 Hangup sofia/default/13054472817 [CS_CONSUME_MEDIA] [CALL_REJECTED]
  483. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/13054472817) Running State Change CS_HANGUP (Cur 2 Tot 24766)
  484. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:844 (sofia/default/13054472817) Callstate Change DOWN -> HANGUP
  485. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:846 (sofia/default/13054472817) State HANGUP
  486. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_sofia.c:469 Channel sofia/default/13054472817 hanging up, cause: CALL_REJECTED
  487. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:59 sofia/default/13054472817 Standard HANGUP, cause: CALL_REJECTED
  488. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:846 (sofia/default/13054472817) State HANGUP going to sleep
  489. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:616 (sofia/default/13054472817) State Change CS_HANGUP -> CS_REPORTING
  490. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/13054472817) Running State Change CS_REPORTING (Cur 2 Tot 24766)
  491. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:932 (sofia/default/13054472817) State REPORTING
  492. 2024-03-06 10:53:56.032792 35.33% [INFO] mod_json_cdr.c:272 Process [62e9984d-25b5-4261-acc2-aba1d7163ed2.cdr.json]
  493. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_ivr_originate.c:4052 Originate Resulted in Error Cause: 21 [CALL_REJECTED]
  494. 2024-03-06 10:53:56.032792 35.33% [INFO] mod_dptools.c:3635 Originate Failed.  Cause: CALL_REJECTED
  495. 2024-03-06 10:53:56.032792 35.33% [NOTICE] switch_core_state_machine.c:382 sofia/default/8481338745@demov6.astppbilling.org has executed the last dialplan instruction, hanging up.
  496. 2024-03-06 10:53:56.032792 35.33% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/8481338745@demov6.astppbilling.org [CS_EXECUTE] [NORMAL_CLEARING]
  497. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:647 (sofia/default/8481338745@demov6.astppbilling.org) State EXECUTE going to sleep
  498. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8481338745@demov6.astppbilling.org) Running State Change CS_HANGUP (Cur 2 Tot 24766)
  499. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:844 (sofia/default/8481338745@demov6.astppbilling.org) Callstate Change RINGING -> HANGUP
  500. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8481338745@demov6.astppbilling.org) State HANGUP
  501. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_sofia.c:463 sofia/default/8481338745@demov6.astppbilling.org Overriding SIP cause 480 with 403 from the other leg
  502. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_sofia.c:469 Channel sofia/default/8481338745@demov6.astppbilling.org hanging up, cause: NORMAL_CLEARING
  503. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_sofia.c:614 Responding to INVITE with: 403
  504. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.1000000000 per minute to account 2
  505. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:518 Not billing 2 - call is not in answered state
  506. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:422 Doing lookup query
  507. [SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='2']
  508. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 2 (balance = 23.231700)
  509. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:523 Comparing 23.231700 to hangup balance of 0.000000, taking into account minimum charge of 0.000000
  510. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:422 Doing lookup query
  511. [SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='2']
  512. 2024-03-06 10:53:56.032792 35.33% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 2 (balance = 23.231700)
  513. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:59 sofia/default/8481338745@demov6.astppbilling.org Standard HANGUP, cause: NORMAL_CLEARING
  514. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:846 (sofia/default/8481338745@demov6.astppbilling.org) State HANGUP going to sleep
  515. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:616 (sofia/default/8481338745@demov6.astppbilling.org) State Change CS_HANGUP -> CS_REPORTING
  516. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:581 (sofia/default/8481338745@demov6.astppbilling.org) Running State Change CS_REPORTING (Cur 2 Tot 24766)
  517. 2024-03-06 10:53:56.032792 35.33% [DEBUG] switch_core_state_machine.c:932 (sofia/default/8481338745@demov6.astppbilling.org) State REPORTING
  518. 2024-03-06 10:53:56.032792 35.33% [INFO] mod_json_cdr.c:272 Process [a26f9e9d-2193-4846-9ef8-d4b3be04e7b5.cdr.json]
  519.