From brv, 1 Year ago, written in Plain Text.
- view diff
Embed
  1. +OK log level  [7]
  2. 2023-05-17 23:52:15.023717 98.40% [NOTICE] switch_channel.c:1123 New Channel sofia/default/3438233779@187.60.60.161 [6b977858-e76c-4b03-b265-de10749cf8de]
  3. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_NEW (Cur 1 Tot 18113)
  4. 2023-05-17 23:52:15.023717 98.40% [INFO] sofia.c:10462 sofia/default/3438233779@187.60.60.161 receiving invite from 187.60.60.161:5060 version: 1.10.7 -release 64bit call-id: 3300644934-3893356334-1394719425@JKSBCQ21-02.mydomain.com
  5. 2023-05-17 23:52:15.023717 98.40% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 187.60.60.161:0.
  6. 2023-05-17 23:52:15.023717 98.40% [DEBUG] sofia.c:10585 IP 187.60.60.161 Approved by acl "default[]". Access Granted.
  7. 2023-05-17 23:52:15.023717 98.40% [DEBUG] sofia.c:7499 Channel sofia/default/3438233779@187.60.60.161 entering state [received][100]
  8. 2023-05-17 23:52:15.023717 98.40% [DEBUG] sofia.c:7509 Remote SDP:
  9. v=0
  10. o=PortaSIP 4477326320901891769 1 IN IP4 187.60.60.165
  11. s=sip call
  12. t=0 0
  13. m=audio 56498 RTP/AVP 8 0 18 97
  14. c=IN IP4 187.60.60.201
  15. a=rtpmap:8 PCMA/8000
  16. a=rtpmap:0 PCMU/8000
  17. a=rtpmap:18 G729/8000
  18. a=fmtp:18 annexb=yes
  19. a=rtpmap:97 telephone-event/8000
  20. a=fmtp:97 0-15
  21. a=ptime:20
  22.  
  23. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  24. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  25. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  26. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  27. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  28. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  29. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMA:8:8000:20:64000:1]
  30. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [G729:18:8000:20:8000:1]/[PCMU:0:8000:20:64000:1]
  31. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 97@8000
  32. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/3438233779@187.60.60.161 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  33. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_codec.c:111 sofia/default/3438233779@187.60.60.161 Original read codec set to PCMA:8
  34. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 97@8000
  35. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_media.c:5973 sofia/default/3438233779@187.60.60.161 Set 2833 dtmf send payload to 97 recv payload to 97
  36. 2023-05-17 23:52:15.023717 98.40% [DEBUG] sofia.c:7933 (sofia/default/3438233779@187.60.60.161) State Change CS_NEW -> CS_INIT
  37. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:600 (sofia/default/3438233779@187.60.60.161) State NEW
  38. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_INIT (Cur 1 Tot 18113)
  39. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:624 (sofia/default/3438233779@187.60.60.161) State INIT
  40. 2023-05-17 23:52:15.023717 98.40% [DEBUG] mod_sofia.c:97 sofia/default/3438233779@187.60.60.161 SOFIA INIT
  41. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:40 sofia/default/3438233779@187.60.60.161 Standard INIT
  42. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:48 (sofia/default/3438233779@187.60.60.161) State Change CS_INIT -> CS_ROUTING
  43. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:624 (sofia/default/3438233779@187.60.60.161) State INIT going to sleep
  44. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_ROUTING (Cur 1 Tot 18113)
  45. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_channel.c:2380 (sofia/default/3438233779@187.60.60.161) Callstate Change DOWN -> RINGING
  46. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:640 (sofia/default/3438233779@187.60.60.161) State ROUTING
  47. 2023-05-17 23:52:15.023717 98.40% [DEBUG] mod_sofia.c:158 sofia/default/3438233779@187.60.60.161 SOFIA ROUTING
  48. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_core_state_machine.c:230 sofia/default/3438233779@187.60.60.161 Standard ROUTING
  49. 2023-05-17 23:52:15.023717 98.40% [INFO] mod_dialplan_xml.c:639 Processing 3438233779 <3438233779>->551131649043 in context default
  50. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  51. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  52. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  53. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  54. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  55. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 551131649043
  56. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '551131649043' limit 1
  57. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  58. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '551131649043' and status=0 LIMIT 1
  59. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBERnobody
  60. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  61. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT accountid FROM sip_devices WHERE username = '551131649043' limit 1
  62. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 3438233779 / 3438233779
  63. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number 649043
  64. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 551131 AND status=0 limit 1
  65. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  66. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  67. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  68. 2023-05-17 23:52:15.023717 98.40% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="551131649043" LIMIT 1
  69. 2023-05-17 23:52:15.023717 98.40% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="551131649043" LIMIT 1
  70. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  71. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  72. 2023-05-17 23:52:15.023717 98.40% [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("187.60.60.161") 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 "551131649043"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  73. 2023-05-17 23:52:15.023717 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 2597915644]
  74. 2023-05-17 23:52:15.023717 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "2597915644" AND deleted = 0 limit 1
  75. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =32
  76. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]0
  77. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DID]1
  78. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  79. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 32
  80. 2023-05-17 23:52:15.043724 98.40% [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 = '^551131649043.*' OR patterns = '^55113164904.*' OR patterns = '^5511316490.*' OR patterns = '^551131649.*' OR patterns = '^55113164.*' OR patterns = '^5511316.*' OR patterns = '^551131.*' OR patterns = '^55113.*' OR patterns = '^5511.*' OR patterns = '^551.*' OR patterns = '^55.*' OR patterns = '^5.*' OR patterns ='--') AND accountid = 32 ORDER BY LENGTH(PKGPTR.patterns) DESC
  81. 2023-05-17 23:52:15.043724 98.40% [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 ="551131649043" AND A.accountid = '5' limit 1
  82. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 551131649043
  83. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]0.0
  84. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1
  85. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_DIRECTION]1.1 :: CALL IS DID
  86. 2023-05-17 23:52:15.043724 98.40% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="551131649043" LIMIT 1
  87. 2023-05-17 23:52:15.043724 98.40% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="551131649043" LIMIT 1
  88. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  89. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  90. 2023-05-17 23:52:15.043724 98.40% [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 = '551131649043' OR number = '55113164904' OR number = '5511316490' OR number = '551131649' OR number = '55113164' OR number = '5511316' OR number = '551131' OR number = '55113' OR number = '5511' OR number = '551' OR number = '55' OR number = '5' OR number ='--') OR (number = '551131649043*' OR number = '55113164904*' OR number = '5511316490*' OR number = '551131649*' OR number = '55113164*' OR number = '5511316*' OR number = '551131*' OR number = '55113*' OR number = '5511*' OR number = '551*' OR number = '55*' OR number = '5*' OR number ='--') OR (number = '3438233779' OR number = '343823377' OR number = '34382337' OR number = '3438233' OR number = '343823' OR number = '34382' OR number = '3438' OR number = '343' OR number = '34' OR number = '3' OR number ='--') OR (number = '3438233779*' OR number = '343823377*' OR number = '34382337*' OR number = '3438233*' OR number = '343823*' OR number = '34382*' OR number = '3438*' OR number = '343*' OR number = '34*' OR number = '3*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  91. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  92. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '551131649043' OR routing_prefix = '55113164904' OR routing_prefix = '5511316490' OR routing_prefix = '551131649' OR routing_prefix = '55113164' OR routing_prefix = '5511316' OR routing_prefix = '551131' OR routing_prefix = '55113' OR routing_prefix = '5511' OR routing_prefix = '551' OR routing_prefix = '55' OR routing_prefix = '5' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  93. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  94. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 5
  95. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 2597915644
  96. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =32
  97. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 909.202
  98. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  99. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  100. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  101. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  102. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.0
  103. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_PRICELIST]1.1:CACHING ID:::1
  104. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  105. 2023-05-17 23:52:15.043724 98.40% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="551131649043" LIMIT 1
  106. 2023-05-17 23:52:15.043724 98.40% [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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="551131649043" LIMIT 1
  107. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  108. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  109. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  110. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 2
  111. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  112. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  113. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  114. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : Sao Paulo SP
  115. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 28
  116. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 5
  117. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  118. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =32
  119. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your909.202 balance Accountid 5 !!!
  120. 2023-05-17 23:52:15.043724 98.40% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  121. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE ID 5
  122. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE RATE 0.00000
  123. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE CONNECT COST 0.00000
  124. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INITIAL INC 30
  125. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] NIBBLE INC 6
  126. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  127. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  128. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  129. 2023-05-17 23:52:15.043724 98.40% [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 = 5 AND status=0 LIMIT 1
  130. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "32" AND deleted = 0 limit 1
  131. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Ashish account call balance :SELECT * FROM accounts WHERE id =32
  132. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:5
  133. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:5
  134. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 5
  135. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 32 limit 1
  136. 2023-05-17 23:52:15.043724 98.40% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : ura.voz.brvoz.net
  137. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  138. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  139. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  140. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  141. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET get_record_info] Query :SELECT sip_device_routing.is_recording FROM sip_devices AS sip_devices, accounts AS accounts ,sip_device_routing AS sip_device_routing  WHERE sip_devices.accountid = accounts.id AND sip_devices.id = sip_device_routing.sip_device_id AND sip_devices.username = "6" AND accounts.status = 0
  142. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 32 limit 1
  143. 2023-05-17 23:52:15.043724 98.40% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : ura.voz.brvoz.net
  144. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 32  and status = 0 limit 1
  145. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_10
  146. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT daily_call_credit_limit,daily_call_used_limit,monthly_call_credit_limit,monthly_call_used_limit FROM accounts WHERE (number = 32 or id = 32 ) and status = 0 limit 1
  147. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 10
  148. 2023-05-17 23:52:15.043724 98.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : IVR
  149. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_IVR_INFO] Query :SELECT * from pbx_ivr_specification WHERE id = 6 and status=0 LIMIT 1
  150. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [GET_RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '' LIMIT 1
  151. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Generated XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  152. <document type="freeswitch/xml">
  153. <section name="dialplan" description="ASTPP Dialplan">
  154. <context name="default">
  155. <extension name="551131649043">
  156. <condition field="destination_number" expression="551131649043">
  157. <action application="set" data="effective_destination_number=551131649043"/>
  158. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  159. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_clearing"/>
  160. <action application="set" data="notify_flag=0"/>
  161. <action application="set" data="notify_credit_limit=5.00000"/>
  162. <action application="set" data="type=3"/>
  163. <action application="set" data="nibble_account=5"/>
  164. <action application="set" data="nibble_rate=0.00000"/>
  165. <action application="set" data="nibble_minimum=0.00000"/>
  166. <action application="set" data="nibble_increment=30"/>
  167. <action application="nibblebill" data="heartbeat 30"/>
  168. <action application="set" data="callstart=2023-05-17 23:52:15"/>
  169. <action application="set" data="hangup_after_bridge=true"/>
  170. <action application="set" data="continue_on_fail=TRUE"/>
  171. <action application="set" data="account_id=5"/>
  172. <action application="set" data="parent_id=0"/>
  173. <action application="set" data="entity_id=3"/>
  174. <action application="set" data="call_processed=internal"/>
  175. <action application="set" data="call_direction=inbound"/>
  176. <action application="set" data="accountname=DID Datora"/>
  177. <action application="set" data="origination_rates_did=ID:2|CODE:^551131649043.*|DESTINATION:Sao Paulo SP|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:6|INITIALBLOCK:30|RATEGROUP:0|MARKUP:0|CI:28|ACCID:32"/>
  178. <action application="set" data="origination_rates=0"/>
  179. <action application="set" data="original_caller_id_name=3438233779"/>
  180. <action application="set" data="original_caller_id_number=3438233779"/>
  181. <action application="limit" data="db Sao_Paulo_SP user_Sao_Paulo_SP 5 "/>
  182. <action application="set" data="effective_caller_id_name=3438233779"/>
  183. <action application="set" data="effective_caller_id_number=3438233779"/>
  184. <action application="set" data="receiver_accid=32"/>
  185. <action application="set" data="did_id=2"/>
  186. <action application="set" data="transfer_call_type=4"/>
  187. <action application="set" data="transfer_extensions="/>
  188. <action application="set" data="busy_status=1"/>
  189. <action application="set" data="no_answer_status=1"/>
  190. <action application="set" data="always_status=1"/>
  191. <action application="set" data="transfer_status=1"/>
  192. <action application="set" data="variable_sip_to_host=${domain_name}"/>
  193. <action application="set" data="variable_sip_network_ip=187.60.60.161"/>
  194. <action application="set" data="variable_sip_network_port=5060"/>
  195. <action application="export" data="domain_name=ura.voz.brvoz.net"/>
  196. <action application="export" data="sip_to_host=ura.voz.brvoz.net"/>
  197. <action application="limit" data="db 551131649043 did_551131649043 5 "/>
  198. <action application="export" data="presence_data=x|||BRVOZ IVR LOCAL(6784520270)|||||||||DID|||187.60.60.161"/>
  199. <action application="export" data="call_type=10"/>
  200. <action application="set" data="did_calltype=10"/>
  201. <action application="set" data="did_extensions=6"/>
  202. <action application="set" data="daily_call_credit_limit=0.00000"/>
  203. <action application="set" data="monthly_call_credit_limit=0.00000"/>
  204. <action application="set" data="daily_call_used_limit=0.00000"/>
  205. <action application="set" data="monthly_call_used_limit=0.00000"/>
  206. <action application="set" data="ringback="/>
  207. <action application="set" data="module_name=pbx"/>
  208. <action application="set" data="sip_h_P-call_type=custom_forward"/>
  209. <action application="set" data="sip_h_P-Accountcode=32"/>
  210. <action application="set" data="variable_sip_to_host=ura.voz.brvoz.net"/>
  211. <action application="set" data="userinfo_id=5"/>
  212. <action application="set" data="variable_sip_to_host=ura.voz.brvoz.net"/>
  213. <action application="set" data="original_did_number=551131649043"/>
  214.     <action application="answer"/>
  215. <action application="ivr" data="IVR BRVOZ0"/>
  216. <action application="lua" data="astpp/lib/pbx/astpp-failover_ivr_destination.lua"/>
  217. </condition>
  218. </extension>
  219. </context>
  220. </section>
  221. </document>
  222. Dialplan: sofia/default/3438233779@187.60.60.161 parsing [default->551131649043] continue=false
  223. Dialplan: sofia/default/3438233779@187.60.60.161 Regex (PASS) [551131649043] destination_number(551131649043) =~ /551131649043/ break=on-false
  224. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(effective_destination_number=551131649043)
  225. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(bridge_pre_execute_bleg_app=sched_hangup)
  226. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  227. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(notify_flag=0)
  228. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(notify_credit_limit=5.00000)
  229. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(type=3)
  230. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(nibble_account=5)
  231. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(nibble_rate=0.00000)
  232. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(nibble_minimum=0.00000)
  233. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(nibble_increment=30)
  234. Dialplan: sofia/default/3438233779@187.60.60.161 Action nibblebill(heartbeat 30)
  235. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(callstart=2023-05-17 23:52:15)
  236. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(hangup_after_bridge=true)
  237. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(continue_on_fail=TRUE)
  238. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(account_id=5)
  239. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(parent_id=0)
  240. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(entity_id=3)
  241. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(call_processed=internal)
  242. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(call_direction=inbound)
  243. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(accountname=DID Datora)
  244. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(origination_rates_did=ID:2|CODE:^551131649043.*|DESTINATION:Sao Paulo SP|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:6|INITIALBLOCK:30|RATEGROUP:0|MARKUP:0|CI:28|ACCID:32)
  245. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(origination_rates=0)
  246. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(original_caller_id_name=3438233779)
  247. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(original_caller_id_number=3438233779)
  248. Dialplan: sofia/default/3438233779@187.60.60.161 Action limit(db Sao_Paulo_SP user_Sao_Paulo_SP 5 )
  249. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(effective_caller_id_name=3438233779)
  250. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(effective_caller_id_number=3438233779)
  251. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(receiver_accid=32)
  252. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(did_id=2)
  253. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(transfer_call_type=4)
  254. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(transfer_extensions=)
  255. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(busy_status=1)
  256. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(no_answer_status=1)
  257. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(always_status=1)
  258. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(transfer_status=1)
  259. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(variable_sip_to_host=${domain_name})
  260. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(variable_sip_network_ip=187.60.60.161)
  261. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(variable_sip_network_port=5060)
  262. Dialplan: sofia/default/3438233779@187.60.60.161 Action export(domain_name=ura.voz.brvoz.net)
  263. Dialplan: sofia/default/3438233779@187.60.60.161 Action export(sip_to_host=ura.voz.brvoz.net)
  264. Dialplan: sofia/default/3438233779@187.60.60.161 Action limit(db 551131649043 did_551131649043 5 )
  265. Dialplan: sofia/default/3438233779@187.60.60.161 Action export(presence_data=x|||BRVOZ IVR LOCAL(6784520270)|||||||||DID|||187.60.60.161)
  266. Dialplan: sofia/default/3438233779@187.60.60.161 Action export(call_type=10)
  267. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(did_calltype=10)
  268. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(did_extensions=6)
  269. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(daily_call_credit_limit=0.00000)
  270. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(monthly_call_credit_limit=0.00000)
  271. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(daily_call_used_limit=0.00000)
  272. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(monthly_call_used_limit=0.00000)
  273. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(ringback=)
  274. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(module_name=pbx)
  275. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(sip_h_P-call_type=custom_forward)
  276. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(sip_h_P-Accountcode=32)
  277. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(variable_sip_to_host=ura.voz.brvoz.net)
  278. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(userinfo_id=5)
  279. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(variable_sip_to_host=ura.voz.brvoz.net)
  280. Dialplan: sofia/default/3438233779@187.60.60.161 Action set(original_did_number=551131649043)
  281. Dialplan: sofia/default/3438233779@187.60.60.161 Action answer()
  282. Dialplan: sofia/default/3438233779@187.60.60.161 Action ivr(IVR BRVOZ0)
  283. Dialplan: sofia/default/3438233779@187.60.60.161 Action lua(astpp/lib/pbx/astpp-failover_ivr_destination.lua)
  284. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_core_state_machine.c:281 (sofia/default/3438233779@187.60.60.161) State Change CS_ROUTING -> CS_EXECUTE
  285. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_core_state_machine.c:640 (sofia/default/3438233779@187.60.60.161) State ROUTING going to sleep
  286. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_EXECUTE (Cur 1 Tot 18113)
  287. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_core_state_machine.c:647 (sofia/default/3438233779@187.60.60.161) State EXECUTE
  288. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_sofia.c:213 sofia/default/3438233779@187.60.60.161 SOFIA EXECUTE
  289. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_core_state_machine.c:323 sofia/default/3438233779@187.60.60.161 Standard EXECUTE
  290. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(effective_destination_number=551131649043)
  291. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [effective_destination_number]=[551131649043]
  292. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(bridge_pre_execute_bleg_app=sched_hangup)
  293. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [bridge_pre_execute_bleg_app]=[sched_hangup]
  294. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(bridge_pre_execute_bleg_data=+6000 normal_clearing)
  295. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  296. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(notify_flag=0)
  297. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [notify_flag]=[0]
  298. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(notify_credit_limit=5.00000)
  299. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [notify_credit_limit]=[5.00000]
  300. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(type=3)
  301. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [type]=[3]
  302. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(nibble_account=5)
  303. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [nibble_account]=[5]
  304. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(nibble_rate=0.00000)
  305. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [nibble_rate]=[0.00000]
  306. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(nibble_minimum=0.00000)
  307. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [nibble_minimum]=[0.00000]
  308. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(nibble_increment=30)
  309. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [nibble_increment]=[30]
  310. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 nibblebill(heartbeat 30)
  311. 2023-05-17 23:52:15.043724 98.40% [WARNING] switch_core_session.c:1693 sofia/default/3438233779@187.60.60.161 using scheduler due to bypass media or media is not established.
  312. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_scheduler.c:263 Added task 6875 switch_core_session_sched_heartbeat (6b977858-e76c-4b03-b265-de10749cf8de) to run at 1684367565
  313. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(callstart=2023-05-17 23:52:15)
  314. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [callstart]=[2023-05-17 23:52:15]
  315. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(hangup_after_bridge=true)
  316. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [hangup_after_bridge]=[true]
  317. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(continue_on_fail=TRUE)
  318. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [continue_on_fail]=[TRUE]
  319. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(account_id=5)
  320. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [account_id]=[5]
  321. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(parent_id=0)
  322. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [parent_id]=[0]
  323. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(entity_id=3)
  324. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [entity_id]=[3]
  325. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(call_processed=internal)
  326. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [call_processed]=[internal]
  327. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(call_direction=inbound)
  328. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [call_direction]=[inbound]
  329. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(accountname=DID Datora)
  330. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [accountname]=[DID Datora]
  331. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(origination_rates_did=ID:2|CODE:^551131649043.*|DESTINATION:Sao Paulo SP|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:6|INITIALBLOCK:30|RATEGROUP:0|MARKUP:0|CI:28|ACCID:32)
  332. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [origination_rates_did]=[ID:2|CODE:^551131649043.*|DESTINATION:Sao Paulo SP|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:6|INITIALBLOCK:30|RATEGROUP:0|MARKUP:0|CI:28|ACCID:32]
  333. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(origination_rates=0)
  334. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [origination_rates]=[0]
  335. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(original_caller_id_name=3438233779)
  336. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [original_caller_id_name]=[3438233779]
  337. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(original_caller_id_number=3438233779)
  338. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [original_caller_id_number]=[3438233779]
  339. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 limit(db Sao_Paulo_SP user_Sao_Paulo_SP 5 )
  340. 2023-05-17 23:52:15.043724 98.40% [DEBUG] switch_limit.c:124 incr called: Sao_Paulo_SP_user_Sao_Paulo_SP max:5, interval:0
  341. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_db.c:194 Usage for Sao_Paulo_SP_user_Sao_Paulo_SP is now 1/5
  342. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(effective_caller_id_name=3438233779)
  343. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [effective_caller_id_name]=[3438233779]
  344. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(effective_caller_id_number=3438233779)
  345. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [effective_caller_id_number]=[3438233779]
  346. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(receiver_accid=32)
  347. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [receiver_accid]=[32]
  348. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(did_id=2)
  349. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [did_id]=[2]
  350. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(transfer_call_type=4)
  351. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [transfer_call_type]=[4]
  352. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(transfer_extensions=)
  353. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [transfer_extensions]=[UNDEF]
  354. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(busy_status=1)
  355. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [busy_status]=[1]
  356. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(no_answer_status=1)
  357. 2023-05-17 23:52:15.043724 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [no_answer_status]=[1]
  358. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(always_status=1)
  359. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [always_status]=[1]
  360. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(transfer_status=1)
  361. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [transfer_status]=[1]
  362. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(variable_sip_to_host=10.0.0.4)
  363. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [variable_sip_to_host]=[10.0.0.4]
  364. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(variable_sip_network_ip=187.60.60.161)
  365. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [variable_sip_network_ip]=[187.60.60.161]
  366. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(variable_sip_network_port=5060)
  367. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [variable_sip_network_port]=[5060]
  368. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 export(domain_name=ura.voz.brvoz.net)
  369. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [domain_name]=[ura.voz.brvoz.net]
  370. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 export(sip_to_host=ura.voz.brvoz.net)
  371. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [sip_to_host]=[ura.voz.brvoz.net]
  372. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 limit(db 551131649043 did_551131649043 5 )
  373. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_limit.c:124 incr called: 551131649043_did_551131649043 max:5, interval:0
  374. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_db.c:194 Usage for 551131649043_did_551131649043 is now 1/5
  375. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 export(presence_data=x|||BRVOZ IVR LOCAL(6784520270)|||||||||DID|||187.60.60.161)
  376. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [presence_data]=[x|||BRVOZ IVR LOCAL(6784520270)|||||||||DID|||187.60.60.161]
  377. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 export(call_type=10)
  378. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_channel.c:1315 EXPORT (export_vars) [call_type]=[10]
  379. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(did_calltype=10)
  380. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [did_calltype]=[10]
  381. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(did_extensions=6)
  382. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [did_extensions]=[6]
  383. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(daily_call_credit_limit=0.00000)
  384. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [daily_call_credit_limit]=[0.00000]
  385. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(monthly_call_credit_limit=0.00000)
  386. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [monthly_call_credit_limit]=[0.00000]
  387. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(daily_call_used_limit=0.00000)
  388. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [daily_call_used_limit]=[0.00000]
  389. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(monthly_call_used_limit=0.00000)
  390. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [monthly_call_used_limit]=[0.00000]
  391. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(ringback=)
  392. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [ringback]=[UNDEF]
  393. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(module_name=pbx)
  394. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [module_name]=[pbx]
  395. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(sip_h_P-call_type=custom_forward)
  396. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [sip_h_P-call_type]=[custom_forward]
  397. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(sip_h_P-Accountcode=32)
  398. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [sip_h_P-Accountcode]=[32]
  399. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(variable_sip_to_host=ura.voz.brvoz.net)
  400. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [variable_sip_to_host]=[ura.voz.brvoz.net]
  401. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(userinfo_id=5)
  402. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [userinfo_id]=[5]
  403. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(variable_sip_to_host=ura.voz.brvoz.net)
  404. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [variable_sip_to_host]=[ura.voz.brvoz.net]
  405. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 set(original_did_number=551131649043)
  406. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_dptools.c:1685 SET sofia/default/3438233779@187.60.60.161 [original_did_number]=[551131649043]
  407. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 answer()
  408. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_core_media.c:8777 AUDIO RTP [sofia/default/3438233779@187.60.60.161] 10.0.0.4 port 17792 -> 187.60.60.201 port 56498 codec: 8 ms: 20
  409. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_rtp.c:4619 Starting timer [soft] 160 bytes per 20ms
  410. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_core_media.c:9089 sofia/default/3438233779@187.60.60.161 Set 2833 dtmf send payload to 97
  411. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_core_media.c:9096 sofia/default/3438233779@187.60.60.161 Set 2833 dtmf receive payload to 97
  412. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_core_media.c:9119 sofia/default/3438233779@187.60.60.161 Set rtp dtmf delay to 40
  413. 2023-05-17 23:52:15.063727 98.40% [DEBUG] mod_sofia.c:913 Local SDP sofia/default/3438233779@187.60.60.161:
  414. v=0
  415. o=FreeSWITCH 1684349743 1684349744 IN IP4 144.22.174.75
  416. s=FreeSWITCH
  417. c=IN IP4 144.22.174.75
  418. t=0 0
  419. m=audio 17792 RTP/AVP 8 97
  420. a=rtpmap:8 PCMA/8000
  421. a=rtpmap:97 telephone-event/8000
  422. a=fmtp:97 0-15
  423. a=ptime:20
  424. a=sendrecv
  425.  
  426. 2023-05-17 23:52:15.063727 98.40% [NOTICE] mod_dptools.c:1419 Channel [sofia/default/3438233779@187.60.60.161] has been answered
  427. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_channel.c:3950 (sofia/default/3438233779@187.60.60.161) Callstate Change RINGING -> ACTIVE
  428. 2023-05-17 23:52:15.063727 98.40% [DEBUG] sofia.c:7499 Channel sofia/default/3438233779@187.60.60.161 entering state [completed][200]
  429. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 ivr(IVR BRVOZ0)
  430. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exit'
  431. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-sub'
  432. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-exec-app'
  433. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-play-sound'
  434. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-back'
  435. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_xml_add binding 'menu-top'
  436. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:883 building menu 'IVR BRVOZ0'
  437. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '1'
  438. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:968 binding menu action 'menu-exec-app' to '2'
  439. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_menu.c:486 Executing IVR menu IVR BRVOZ0
  440. 2023-05-17 23:52:15.063727 98.40% [DEBUG] switch_ivr_play_say.c:1556 Codec Activated L16@8000hz 1 channels 20ms
  441. 2023-05-17 23:52:15.103726 98.40% [DEBUG] sofia.c:7499 Channel sofia/default/3438233779@187.60.60.161 entering state [ready][200]
  442. 2023-05-17 23:52:15.243720 98.30% [DEBUG] switch_rtp.c:7934 Correct audio ip/port confirmed.
  443. 2023-05-17 23:52:29.563716 98.13% [DEBUG] switch_ivr_play_say.c:2001 done playing file /var/www/html/astpp/upload/pbx/brvoz1_090223113811.wav
  444. 2023-05-17 23:52:29.563716 98.13% [DEBUG] switch_ivr_menu.c:378 waiting for 20/20 digits t/o 2000
  445. 2023-05-17 23:52:32.583716 98.53% [DEBUG] switch_rtp.c:8179 RTP RECV DTMF 1:720
  446. 2023-05-17 23:52:32.583716 98.53% [INFO] switch_channel.c:527 RECV DTMF 1:720
  447. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_ivr_menu.c:425 digits '1'
  448. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_ivr_menu.c:580 IVR action on menu 'IVR BRVOZ0' matched '1' param 'transfer ${original_did_number}#PBX#7#5 XML ${domain_name}'
  449. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_ivr_menu.c:584 switch_ivr_menu_execute todo=[2]
  450. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 transfer(551131649043#PBX#7#5 XML ura.voz.brvoz.net)
  451. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_ivr.c:2289 (sofia/default/3438233779@187.60.60.161) State Change CS_EXECUTE -> CS_ROUTING
  452. 2023-05-17 23:52:34.583724 99.10% [NOTICE] switch_ivr.c:2296 Transfer sofia/default/3438233779@187.60.60.161 to XML[551131649043#PBX#7#5@ura.voz.brvoz.net]
  453. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_ivr_menu.c:676 exit-sound '/var/www/html/astpp/upload/pbx/brvoz2_090223113835.wav'
  454. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/3438233779@187.60.60.161) State EXECUTE going to sleep
  455. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_ROUTING (Cur 1 Tot 18113)
  456. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_channel.c:2380 (sofia/default/3438233779@187.60.60.161) Callstate Change ACTIVE -> RINGING
  457. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/3438233779@187.60.60.161) State ROUTING
  458. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_sofia.c:158 sofia/default/3438233779@187.60.60.161 SOFIA ROUTING
  459. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 5
  460. 2023-05-17 23:52:34.583724 99.10% [INFO] mod_nibblebill.c:565 Beginning new billing on 6b977858-e76c-4b03-b265-de10749cf8de
  461. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:573 19 seconds passed since last bill time of 2023-05-17 23:52:15
  462. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:590 Billing $0.000000 to 5 (Call: 6b977858-e76c-4b03-b265-de10749cf8de / 0.000000 so far)
  463. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:395 Doing update query
  464. [Update accounts SET balance=IF(posttoexternal=1,balance+0.000000,balance-0.000000) WHERE id='5']
  465. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:422 Doing lookup query
  466. [SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5']
  467. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5 (balance = 4800.701000)
  468. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:422 Doing lookup query
  469. [SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5']
  470. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5 (balance = 4800.701000)
  471. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:230 sofia/default/3438233779@187.60.60.161 Standard ROUTING
  472. 2023-05-17 23:52:34.583724 99.10% [INFO] mod_dialplan_xml.c:639 Processing 3438233779 <3438233779>->551131649043#PBX#7#5 in context ura.voz.brvoz.net
  473. 2023-05-17 23:52:34.583724 99.10% [INFO] switch_cpp.cpp:1465 [ASTPP] USING CACHE
  474. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  475. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_SYSTEM]1.0
  476. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  477. 2023-05-17 23:52:34.583724 99.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  478. 2023-05-17 23:52:34.583724 99.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 551131649043#PBX#7#5
  479. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '551131649043#PBX#7#5' limit 1
  480. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CACHING_DEBUG_ACCESS_NUMBER]1.0
  481. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [Functions] [Fifo Condition Check] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '551131649043#PBX#7#5' and status=0 LIMIT 1
  482. 2023-05-17 23:52:34.583724 99.10% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] VOICEMAIL :
  483. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Generated XML:
  484. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  485. <document type="freeswitch/xml">
  486. <section name="dialplan" description="ASTPP Dialplan">
  487. <context name="ura.voz.brvoz.net">
  488. <extension name="551131649043#PBX#7#5">
  489. <condition field="destination_number" expression="551131649043#PBX#7#5">
  490. <action application="answer"/>
  491. <action application="voicemail" data="check default ura.voz.brvoz.net 3438233779"/>
  492. </condition>
  493. </extension>
  494. </context>
  495. </section>
  496. </document>
  497. Dialplan: sofia/default/3438233779@187.60.60.161 parsing [ura.voz.brvoz.net->551131649043#PBX#7#5] continue=false
  498. Dialplan: sofia/default/3438233779@187.60.60.161 Regex (PASS) [551131649043#PBX#7#5] destination_number(551131649043#PBX#7#5) =~ /551131649043#PBX#7#5/ break=on-false
  499. Dialplan: sofia/default/3438233779@187.60.60.161 Action answer()
  500. Dialplan: sofia/default/3438233779@187.60.60.161 Action voicemail(check default ura.voz.brvoz.net 3438233779)
  501. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:281 (sofia/default/3438233779@187.60.60.161) State Change CS_ROUTING -> CS_EXECUTE
  502. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:640 (sofia/default/3438233779@187.60.60.161) State ROUTING going to sleep
  503. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_EXECUTE (Cur 1 Tot 18113)
  504. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_channel.c:2382 (sofia/default/3438233779@187.60.60.161) Callstate Change RINGING -> ACTIVE
  505. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:647 (sofia/default/3438233779@187.60.60.161) State EXECUTE
  506. 2023-05-17 23:52:34.583724 99.10% [DEBUG] mod_sofia.c:213 sofia/default/3438233779@187.60.60.161 SOFIA EXECUTE
  507. 2023-05-17 23:52:34.583724 99.10% [INFO] switch_core_session.c:1707 sofia/default/3438233779@187.60.60.161 setting session heartbeat to 30 second(s).
  508. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_core_state_machine.c:323 sofia/default/3438233779@187.60.60.161 Standard EXECUTE
  509. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 answer()
  510. EXECUTE [depth=0] sofia/default/3438233779@187.60.60.161 voicemail(check default ura.voz.brvoz.net 3438233779)
  511. 2023-05-17 23:52:34.583724 99.10% [DEBUG] switch_ivr_play_say.c:70 No language specified - Using [en]
  512. 2023-05-17 23:52:34.823725 99.10% [WARNING] mod_voicemail.c:2464 Can't find user [3438233779@ura.voz.brvoz.net]
  513. 2023-05-17 23:52:34.823725 99.10% [DEBUG] switch_ivr_play_say.c:70 No language specified - Using [en]
  514. 2023-05-17 23:52:34.823725 99.10% [DEBUG] switch_ivr_play_say.c:250 Handle play-file:[voicemail/vm-goodbye.wav] (en:en)
  515. 2023-05-17 23:52:34.823725 99.10% [DEBUG] switch_ivr_play_say.c:1556 Codec Activated L16@8000hz 1 channels 20ms
  516. 2023-05-17 23:52:35.043727 99.10% [DEBUG] switch_scheduler.c:147 Deleting task 6875 switch_core_session_sched_heartbeat (6b977858-e76c-4b03-b265-de10749cf8de)
  517. 2023-05-17 23:52:35.583719 99.07% [DEBUG] switch_ivr_play_say.c:2001 done playing file /usr/local/freeswitch/sounds/en/us/callie/voicemail/vm-goodbye.wav
  518. 2023-05-17 23:52:35.683721 99.07% [NOTICE] switch_core_state_machine.c:382 sofia/default/3438233779@187.60.60.161 has executed the last dialplan instruction, hanging up.
  519. 2023-05-17 23:52:35.683721 99.07% [NOTICE] switch_core_state_machine.c:384 Hangup sofia/default/3438233779@187.60.60.161 [CS_EXECUTE] [NORMAL_CLEARING]
  520. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:647 (sofia/default/3438233779@187.60.60.161) State EXECUTE going to sleep
  521. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_HANGUP (Cur 1 Tot 18113)
  522. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:844 (sofia/default/3438233779@187.60.60.161) Callstate Change ACTIVE -> HANGUP
  523. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:846 (sofia/default/3438233779@187.60.60.161) State HANGUP
  524. 2023-05-17 23:52:35.683721 99.07% [DEBUG] mod_sofia.c:468 Channel sofia/default/3438233779@187.60.60.161 hanging up, cause: NORMAL_CLEARING
  525. 2023-05-17 23:52:35.683721 99.07% [DEBUG] mod_sofia.c:522 Sending BYE to sofia/default/3438233779@187.60.60.161
  526. 2023-05-17 23:52:35.683721 99.07% [DEBUG] mod_nibblebill.c:506 Attempting to bill at $0.00000 per minute to account 5
  527. 2023-05-17 23:52:35.683721 99.07% [DEBUG] mod_nibblebill.c:573 -9 seconds passed since last bill time of 2023-05-17 23:52:45
  528. 2023-05-17 23:52:35.683721 99.07% [DEBUG] mod_nibblebill.c:422 Doing lookup query
  529. [SELECT if(posttoexternal=1,credit_limit+(balance*-1),balance) AS nibble_balance FROM accounts WHERE id='5']
  530. 2023-05-17 23:52:35.683721 99.07% [DEBUG] mod_nibblebill.c:430 Retrieved current balance for account 5 (balance = 4800.701000)
  531. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:59 sofia/default/3438233779@187.60.60.161 Standard HANGUP, cause: NORMAL_CLEARING
  532. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:846 (sofia/default/3438233779@187.60.60.161) State HANGUP going to sleep
  533. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:616 (sofia/default/3438233779@187.60.60.161) State Change CS_HANGUP -> CS_REPORTING
  534. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:581 (sofia/default/3438233779@187.60.60.161) Running State Change CS_REPORTING (Cur 1 Tot 18113)
  535. 2023-05-17 23:52:35.683721 99.07% [DEBUG] switch_core_state_machine.c:932 (sofia/default/3438233779@187.60.60.161) State REPORTING
  536. 2023-05-17 23:52:35.683721 99.07% [INFO] mod_json_cdr.c:271 Process [6b977858-e76c-4b03-b265-de10749cf8de.cdr.json]
  537. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:168 sofia/default/3438233779@187.60.60.161 Standard REPORTING, cause: NORMAL_CLEARING
  538. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:932 (sofia/default/3438233779@187.60.60.161) State REPORTING going to sleep
  539. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:607 (sofia/default/3438233779@187.60.60.161) State Change CS_REPORTING -> CS_DESTROY
  540. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_session.c:1753 Session 18113 (sofia/default/3438233779@187.60.60.161) Locked, Waiting on external entities
  541. 2023-05-17 23:52:35.703732 99.07% [NOTICE] switch_core_session.c:1771 Session 18113 (sofia/default/3438233779@187.60.60.161) Ended
  542. 2023-05-17 23:52:35.703732 99.07% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/3438233779@187.60.60.161 [CS_DESTROY]
  543. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:735 (sofia/default/3438233779@187.60.60.161) Running State Change CS_DESTROY (Cur 0 Tot 18113)
  544. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:745 (sofia/default/3438233779@187.60.60.161) State DESTROY
  545. 2023-05-17 23:52:35.703732 99.07% [DEBUG] mod_sofia.c:379 sofia/default/3438233779@187.60.60.161 SOFIA DESTROY
  546. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:175 sofia/default/3438233779@187.60.60.161 Standard DESTROY
  547. 2023-05-17 23:52:35.703732 99.07% [DEBUG] switch_core_state_machine.c:745 (sofia/default/3438233779@187.60.60.161) State DESTROY going to sleep