From mahim, 3 Years ago, written in Plain Text.
- view diff
Embed
  1. [This app Best viewed at 160x60 or more..]
  2. +OK log level  [7]
  3. 2020-06-09 01:35:35.564433 [NOTICE] switch_channel.c:1118 New Channel sofia/defa                                                                                        ult/0873875505@195.191.28.30 [c6f53dc6-a53f-44e6-ab8e-e38d3303bf5d]
  4. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:585 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) Running State Change CS_NEW (Cur 2 Tot 19)
  5. 2020-06-09 01:35:35.564433 [DEBUG] sofia.c:10279 sofia/default/0873875505@195.19                                                                                        1.28.30 receiving invite from 195.191.29.50:5060 version: 1.10.3 -release-15-129                                                                                        de34d84 64bit
  6. 2020-06-09 01:35:35.564433 [DEBUG] sofia.c:10373 verifying acl "default" for ip/                                                                                        port 195.191.29.50:0.
  7. 2020-06-09 01:35:35.564433 [DEBUG] sofia.c:10402 IP 195.191.29.50 Approved by ac                                                                                        l "default[]". Access Granted.
  8. 2020-06-09 01:35:35.564433 [DEBUG] sofia.c:7325 Channel sofia/default/0873875505                                                                                        @195.191.28.30 entering state [received][100]
  9. 2020-06-09 01:35:35.564433 [DEBUG] sofia.c:7335 Remote SDP:
  10. v=0
  11. o=FreeSWITCH 1591641329 1591641330 IN IP4 195.191.28.30
  12. s=FreeSWITCH
  13. c=IN IP4 195.191.28.30
  14. t=0 0
  15. m=audio 25206 RTP/AVP 8 9 0 101 13
  16. a=rtpmap:101 telephone-event/8000
  17. a=fmtp:101 0-16
  18. a=ptime:20
  19.  
  20. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5592 Audio Codec Compare                                                                                         [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  21. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5647 Audio Codec Compare                                                                                         [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  22. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5592 Audio Codec Compare                                                                                         [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  23. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5592 Audio Codec Compare                                                                                         [G722:9:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  24. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5592 Audio Codec Compare                                                                                         [G722:9:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  25. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5592 Audio Codec Compare                                                                                         [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  26. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5592 Audio Codec Compare                                                                                         [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  27. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5647 Audio Codec Compare                                                                                         [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  28. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5508 Set telephone-event                                                                                         payload to 101@8000
  29. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:3837 Set Codec sofia/defa                                                                                        ult/0873875505@195.191.28.30 PCMA/8000 20 ms 160 samples 64000 bits 1 channels
  30. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_codec.c:111 sofia/default/0873875                                                                                        505@195.191.28.30 Original read codec set to PCMA:8
  31. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5851 Set telephone-event                                                                                         payload to 101@8000
  32. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_media.c:5909 sofia/default/087387                                                                                        5505@195.191.28.30 Set 2833 dtmf send payload to 101 recv payload to 101
  33. 2020-06-09 01:35:35.564433 [DEBUG] sofia.c:7759 (sofia/default/0873875505@195.19                                                                                        1.28.30) State Change CS_NEW -> CS_INIT
  34. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:604 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State NEW
  35. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:585 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) Running State Change CS_INIT (Cur 2 Tot 19)
  36. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:628 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State INIT
  37. 2020-06-09 01:35:35.564433 [DEBUG] mod_sofia.c:93 sofia/default/0873875505@195.1                                                                                        91.28.30 SOFIA INIT
  38. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:40 sofia/default/                                                                                        0873875505@195.191.28.30 Standard INIT
  39. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:48 (sofia/default                                                                                        /0873875505@195.191.28.30) State Change CS_INIT -> CS_ROUTING
  40. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:628 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State INIT going to sleep
  41. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:585 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) Running State Change CS_ROUTING (Cur 2 Tot 19)
  42. 2020-06-09 01:35:35.564433 [DEBUG] switch_channel.c:2332 (sofia/default/08738755                                                                                        05@195.191.28.30) Callstate Change DOWN -> RINGING
  43. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:644 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State ROUTING
  44. 2020-06-09 01:35:35.564433 [DEBUG] mod_sofia.c:154 sofia/default/0873875505@195.                                                                                        191.28.30 SOFIA ROUTING
  45. 2020-06-09 01:35:35.564433 [DEBUG] switch_core_state_machine.c:236 sofia/default                                                                                        /0873875505@195.191.28.30 Standard ROUTING
  46. 2020-06-09 01:35:35.564433 [INFO] mod_dialplan_xml.c:637 Processing 0873875505 <                                                                                        0873875505>->0212066139 in context default
  47. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query                                                                                         :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','cal                                                                                        lingcard','calls','InternationalPrefixes')
  48. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF]                                                                                         Query :SELECT package_name FROM addons
  49. 2020-06-09 01:35:35.584393 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] blind_f                                                                                        lag: 0
  50. 2020-06-09 01:35:35.584393 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed                                                                                         number : 0212066139
  51. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CO                                                                                        DE] Query :SELECT id,feature_action,feature_code from feature_code where feature                                                                                        _code = '0212066139' limit 1
  52. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION]                                                                                         Query :SELECT access_number FROM accessnumber WHERE access_number = '0212066139                                                                                        ' AND status=0 limit 1
  53. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_                                                                                        queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue W                                                                                        HERE destination_number = '0212066139' and status=0 LIMIT 1
  54. 2020-06-09 01:35:35.584393 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller                                                                                         Id name / number  : 0873875505 / 0873875505
  55. 2020-06-09 01:35:35.584393 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  56. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION                                                                                        ] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_origina                                                                                        te FROM localization WHERE id = 1 AND status=0 limit 1
  57. 2020-06-09 01:35:35.584393 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLA                                                                                        TION] Before Localization CLI/DST : 0212066139
  58. 2020-06-09 01:35:35.584393 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLA                                                                                        TION] After Localization CLI/DST : 353212066139
  59. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [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.exte                                                                                        nsions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.st                                                                                        atus,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.statu                                                                                        s=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="353212066139" LIMIT 1
  60. 2020-06-09 01:35:35.584393 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call di                                                                                        rection : inbound
  61. 2020-06-09 01:35:35.584393 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IPAUTHENTICATION                                                                                        ] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND st                                                                                        atus=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("195.191.29.50                                                                                        ") 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 "0212066139"  LI                                                                                        KE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  62. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 115                                                                                        0225495]
  63. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION]                                                                                         Query :SELECT * FROM accounts WHERE number = "1150225495" AND deleted = 0 limit                                                                                         1
  64. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [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 ="0212066139" AND A.accountid =                                                                                         '4' limit 1
  65. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED D                                                                                        IAL NUMBER : 0212066139
  66. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  67. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION                                                                                        ] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_origina                                                                                        te FROM localization WHERE id = 1 AND status=0 limit 1
  68. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLA                                                                                        TION] Before Localization CLI/DST : 0212066139
  69. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLA                                                                                        TION] After Localization CLI/DST : 353212066139
  70. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [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.exte                                                                                        nsions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.st                                                                                        atus,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.statu                                                                                        s=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="353212066139" LIMIT 1
  71. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Cal                                                                                        l direction : inbound
  72. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  73. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION                                                                                        ] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_origina                                                                                        te FROM localization WHERE id = 1 AND status=0 limit 1
  74. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLA                                                                                        TION] Before Localization CLI/DST : 0212066139
  75. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [DONUMBERTRANSLA                                                                                        TION] After Localization CLI/DST : 353212066139
  76. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Qu                                                                                        ery :SELECT * FROM dids WHERE number ="353212066139" AND (accountid = 0 OR statu                                                                                        s = 1) LIMIT 1
  77. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO                                                                                        ] call_direction :inbound
  78. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO                                                                                        ] DID_ACCOUNTID :5
  79. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PACKAGE_INFO                                                                                        ] Query :SELECT *,P.id as package_id,P.product_id as product_id FROM packages_vi                                                                                        ew as P inner join package_patterns as PKGPTR on P.product_id = PKGPTR.product_i                                                                                        d WHERE (patterns = '^0212066139.*' OR patterns = '^021206613.*' OR patterns = '                                                                                        ^02120661.*' OR patterns = '^0212066.*' OR patterns = '^021206.*' OR patterns =                                                                                         '^02120.*' OR patterns = '^0212.*' OR patterns = '^021.*' OR patterns = '^02.*'                                                                                         OR patterns = '^0.*' OR patterns ='--') AND accountid = 5 ORDER BY LENGTH(PKGPTR                                                                                        .patterns) DESC
  80. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRI                                                                                        NG] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_                                                                                        type FROM call_barring WHERE ((number = '0212066139' OR number = '021206613' OR                                                                                         number = '02120661' OR number = '0212066' OR number = '021206' OR number = '0212                                                                                        0' OR number = '0212' OR number = '021' OR number = '02' OR number = '0' OR numb                                                                                        er ='--') OR (number = '0212066139*' OR number = '021206613*' OR number = '02120                                                                                        661*' OR number = '0212066*' OR number = '021206*' OR number = '02120*' OR numbe                                                                                        r = '0212*' OR number = '021*' OR number = '02*' OR number = '0*' OR number ='--                                                                                        ') OR (number = '0873875505' OR number = '087387550' OR number = '08738755' OR n                                                                                        umber = '0873875' OR number = '087387' OR number = '08738' OR number = '0873' OR                                                                                         number = '087' OR number = '08' OR number = '0' OR number ='--') OR (number = '                                                                                        0873875505*' OR number = '087387550*' OR number = '08738755*' OR number = '08738                                                                                        75*' OR number = '087387*' OR number = '08738*' OR number = '0873*' OR number =                                                                                         '087*' OR number = '08*' OR number = '0*' OR number ='--')) AND status=0 order b                                                                                        y LENGTH(number) DESC,lastchar DESC, modified_date DESC
  81. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Stat                                                                                        us : -1
  82. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_RO                                                                                        UTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists W                                                                                        HERE (routing_prefix = '0212066139' OR routing_prefix = '021206613' OR routing_p                                                                                        refix = '02120661' OR routing_prefix = '0212066' OR routing_prefix = '021206' OR                                                                                         routing_prefix = '02120' OR routing_prefix = '0212' OR routing_prefix = '021' O                                                                                        R routing_prefix = '02' OR routing_prefix = '0' OR routing_prefix ='--') AND sta                                                                                        tus = 0 and reseller_id = 0 limit 1
  83. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Ac                                                                                        count Information ===================
  84. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 4
  85. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 115                                                                                        0225495
  86. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 10000
  87. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 1 [0:prepai                                                                                        d,1:postpaid]
  88. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
  89. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  90. 2020-06-09 01:35:35.604413 [INFO] switch_cpp.cpp:1447 [ASTPP] ==================                                                                                        ======================================
  91. 2020-06-09 01:35:35.604413 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH1: 4
  92. 2020-06-09 01:35:35.604413 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION                                                                                        ] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_origina                                                                                        te FROM localization WHERE id = 4 AND status=0 limit 1
  93. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_IN                                                                                        FO] Query :select * from pricelists WHERE id = 1 AND status = 0
  94. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_                                                                                        direction :inbound
  95. 2020-06-09 01:35:35.624395 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  96. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION                                                                                        ] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_origina                                                                                        te FROM localization WHERE id = 1 AND status=0 limit 1
  97. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [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.exte                                                                                        nsions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.st                                                                                        atus,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.statu                                                                                        s=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="353212066139" LIMIT 1
  98. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] call_direction::::                                                                                        :: inbound
  99. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Ra                                                                                        tes Information ===================
  100. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] ID : 3
  101. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] Connectcost : 0.00                                                                                        000
  102. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] Includedseconds :                                                                                         0
  103. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] Cost : 0.00000
  104. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] comment : 35321206                                                                                        6139
  105. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] Country Id : 92
  106. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] Accid : 4
  107. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] ==================                                                                                        ==============================================
  108. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Y                                                                                        our10000 balance Accountid 4 !!!
  109. 2020-06-09 01:35:35.624395 [NOTICE] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH]                                                                                         Call is free - assigning max length!!! :: 100
  110. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] Call Max length du                                                                                        ration : 100 minutes
  111. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] INB_FRE                                                                                        E:TRUE
  112. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] free_in                                                                                        bound:1
  113. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_OVERRIDE_CAL                                                                                        LERID] Query :SELECT callerid_name as cid_name,callerid_number as cid_number,acc                                                                                        ountid FROM accounts_callerid WHERE accountid = 4 AND status=0 LIMIT 1
  114. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION]                                                                                         Query :SELECT * FROM accounts WHERE id = "5" AND deleted = 0 limit 1
  115. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Actual                                                                                         CustomerInfo XML:4
  116. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Userinf                                                                                        o XML:4
  117. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [userinfo] Actual                                                                                         CustomerInfo XML : 4
  118. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] maxlength:::::::::                                                                                         100
  119. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] custom_function_n                                                                                        ame:::::::::::::::::::::::::custom_inbound_10
  120. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] custom_function_n                                                                                        ame::::::::::1343:::::::::::::::3
  121. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] call_type :                                                                                         10
  122. 2020-06-09 01:35:35.624395 [INFO] switch_cpp.cpp:1447 [ASTPP] [PBX] call_type :                                                                                         IVR
  123. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_                                                                                        IVR_INFO] Query :SELECT * from pbx_ivr_specification WHERE id = 1 and status=0 L                                                                                        IMIT 1
  124. 2020-06-09 01:35:35.624395 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_                                                                                        RING_GROUP_INFO] Query :SELECT file_name from pbx_recording WHERE id = '' LIMIT                                                                                         1
  125. 2020-06-09 01:35:35.644404 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Genera                                                                                        ted XML:<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  126. <document type="freeswitch/xml">
  127. <section name="dialplan" description="ASTPP Dialplan">
  128. <context name="default">
  129. <extension name="353212066139">
  130. <condition field="destination_number" expression="0212066139">
  131. <action application="set" data="effective_destination_number=0212066139"/>
  132. <action application="set" data="bridge_pre_execute_bleg_app=sched_hangup"/>
  133. <action application="set" data="bridge_pre_execute_bleg_data=+6000 normal_cleari                                                                                        ng"/>
  134. <action application="set" data="callstart=2020-06-09 01:35:35"/>
  135. <action application="set" data="hangup_after_bridge=true"/>
  136. <action application="set" data="continue_on_fail=TRUE"/>
  137. <action application="set" data="account_id=4"/>
  138. <action application="set" data="parent_id=0"/>
  139. <action application="set" data="entity_id=3"/>
  140. <action application="set" data="call_processed=internal"/>
  141. <action application="set" data="call_direction=inbound"/>
  142. <action application="set" data="accountname=IP-Telecom-1"/>
  143. <action application="set" data="origination_rates_did=ID:3|CODE:^353212066139.*|                                                                                        DESTINATION:353212066139|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.0                                                                                        0000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:92|ACCID:5"/>
  144. <action application="set" data="origination_rates=0"/>
  145. <action application="set" data="original_caller_id_name=0873875505"/>
  146. <action application="set" data="original_caller_id_number=0873875505"/>
  147. <action application="limit" data="db 5 user_5 2 !SWITCH_CONGESTION"/>
  148. <action application="set" data="effective_caller_id_name=0873875505"/>
  149. <action application="set" data="effective_caller_id_number=0873875505"/>
  150. <action application="set" data="receiver_accid=5"/>
  151. <action application="limit" data="db 353212066139 did_353212066139 2 !SWITCH_CON                                                                                        GESTION"/>
  152. <action application="export" data="presence_data=x|||IP(1150225495)|||^353212066                                                                                        139.* // 353212066139 // 0.00000||||||DID"/>
  153. <action application="export" data="call_type=10"/>
  154. <action application="set" data="did_calltype=10"/>
  155. <action application="set" data="did_extensions=1"/>
  156. <action application="set" data="ringback="/>
  157. <action application="set" data="module_name=pbx"/>
  158. <action application="set" data="sip_h_P-call_type=custom_forward"/>
  159. <action application="set" data="sip_h_P-Accountcode=5"/>
  160. <action application="set" data="variable_sip_to_host=195.191.29.50"/>
  161. <action application="set" data="userinfo_id=4"/>
  162. <action application="set" data="variable_sip_to_host=195.191.29.50"/>
  163. <action application="set" data="original_did_number=353212066139"/>
  164.     <action application="answer"/>
  165. <action application="ivr" data="mmabc_welcome0"/>
  166. <action application="lua" data="astpp/lib/pbx/astpp-failover_ivr_destination.lua                                                                                        "/>
  167. </condition>
  168. </extension>
  169. </context>
  170. </section>
  171. </document>
  172. Dialplan: sofia/default/0873875505@195.191.28.30 parsing [default->353212066139]                                                                                         continue=false
  173. Dialplan: sofia/default/0873875505@195.191.28.30 Regex (PASS) [353212066139] des                                                                                        tination_number(0212066139) =~ /0212066139/ break=on-false
  174. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(effective_destinatio                                                                                        n_number=0212066139)
  175. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(bridge_pre_execute_b                                                                                        leg_app=sched_hangup)
  176. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(bridge_pre_execute_b                                                                                        leg_data=+6000 normal_clearing)
  177. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(callstart=2020-06-09                                                                                         01:35:35)
  178. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(hangup_after_bridge=                                                                                        true)
  179. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(continue_on_fail=TRU                                                                                        E)
  180. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(account_id=4)
  181. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(parent_id=0)
  182. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(entity_id=3)
  183. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(call_processed=inter                                                                                        nal)
  184. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(call_direction=inbou                                                                                        nd)
  185. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(accountname=IP-Telec                                                                                        om-1)
  186. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(origination_rates_di                                                                                        d=ID:3|CODE:^353212066139.*|DESTINATION:353212066139|CONNECTIONCOST:0.00000|INCL                                                                                        UDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:92                                                                                        |ACCID:5)
  187. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(origination_rates=0)                                                                                        
  188. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(original_caller_id_n                                                                                        ame=0873875505)
  189. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(original_caller_id_n                                                                                        umber=0873875505)
  190. Dialplan: sofia/default/0873875505@195.191.28.30 Action limit(db 5 user_5 2 !SWI                                                                                        TCH_CONGESTION)
  191. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(effective_caller_id_                                                                                        name=0873875505)
  192. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(effective_caller_id_                                                                                        number=0873875505)
  193. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(receiver_accid=5)
  194. Dialplan: sofia/default/0873875505@195.191.28.30 Action limit(db 353212066139 di                                                                                        d_353212066139 2 !SWITCH_CONGESTION)
  195. Dialplan: sofia/default/0873875505@195.191.28.30 Action export(presence_data=x||                                                                                        |IP(1150225495)|||^353212066139.* // 353212066139 // 0.00000||||||DID)
  196. Dialplan: sofia/default/0873875505@195.191.28.30 Action export(call_type=10)
  197. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(did_calltype=10)
  198. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(did_extensions=1)
  199. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(ringback=)
  200. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(module_name=pbx)
  201. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(sip_h_P-call_type=cu                                                                                        stom_forward)
  202. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(sip_h_P-Accountcode=                                                                                        5)
  203. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(variable_sip_to_host                                                                                        =195.191.29.50)
  204. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(userinfo_id=4)
  205. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(variable_sip_to_host                                                                                        =195.191.29.50)
  206. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(original_did_number=                                                                                        353212066139)
  207. Dialplan: sofia/default/0873875505@195.191.28.30 Action answer()
  208. Dialplan: sofia/default/0873875505@195.191.28.30 Action ivr(mmabc_welcome0)
  209. Dialplan: sofia/default/0873875505@195.191.28.30 Action lua(astpp/lib/pbx/astpp-                                                                                        failover_ivr_destination.lua)
  210. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_state_machine.c:287 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State Change CS_ROUTING -> CS_EXECUTE
  211. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_state_machine.c:644 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State ROUTING going to sleep
  212. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_state_machine.c:585 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) Running State Change CS_EXECUTE (Cur 2 Tot 19)
  213. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_state_machine.c:651 (sofia/defaul                                                                                        t/0873875505@195.191.28.30) State EXECUTE
  214. 2020-06-09 01:35:35.644404 [DEBUG] mod_sofia.c:209 sofia/default/0873875505@195.                                                                                        191.28.30 SOFIA EXECUTE
  215. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_state_machine.c:329 sofia/default                                                                                        /0873875505@195.191.28.30 Standard EXECUTE
  216. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(effective_destinati                                                                                        on_number=0212066139)
  217. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [effective_destination_number]=[0212066139]
  218. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(bridge_pre_execute_                                                                                        bleg_app=sched_hangup)
  219. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [bridge_pre_execute_bleg_app]=[sched_hangup]
  220. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(bridge_pre_execute_                                                                                        bleg_data=+6000 normal_clearing)
  221. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [bridge_pre_execute_bleg_data]=[+6000 normal_clearing]
  222. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(callstart=2020-06-0                                                                                        9 01:35:35)
  223. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [callstart]=[2020-06-09 01:35:35]
  224. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(hangup_after_bridge                                                                                        =true)
  225. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [hangup_after_bridge]=[true]
  226. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(continue_on_fail=TR                                                                                        UE)
  227. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [continue_on_fail]=[TRUE]
  228. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(account_id=4)
  229. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [account_id]=[4]
  230. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(parent_id=0)
  231. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [parent_id]=[0]
  232. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(entity_id=3)
  233. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [entity_id]=[3]
  234. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(call_processed=inte                                                                                        rnal)
  235. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [call_processed]=[internal]
  236. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(call_direction=inbo                                                                                        und)
  237. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [call_direction]=[inbound]
  238. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(accountname=IP-Tele                                                                                        com-1)
  239. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [accountname]=[IP-Telecom-1]
  240. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(origination_rates_d                                                                                        id=ID:3|CODE:^353212066139.*|DESTINATION:353212066139|CONNECTIONCOST:0.00000|INC                                                                                        LUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:9                                                                                        2|ACCID:5)
  241. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [origination_rates_did]=[ID:3|CODE:^353212066139.*|DESTINATION:                                                                                        353212066139|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:10|COST:0.00000|INC:0|I                                                                                        NITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:92|ACCID:5]
  242. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(origination_rates=0                                                                                        )
  243. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [origination_rates]=[0]
  244. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(original_caller_id_                                                                                        name=0873875505)
  245. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [original_caller_id_name]=[0873875505]
  246. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(original_caller_id_                                                                                        number=0873875505)
  247. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [original_caller_id_number]=[0873875505]
  248. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 limit(db 5 user_5 2 !SW                                                                                        ITCH_CONGESTION)
  249. 2020-06-09 01:35:35.644404 [DEBUG] switch_limit.c:124 incr called: 5_user_5 max:                                                                                        2, interval:0
  250. 2020-06-09 01:35:35.644404 [DEBUG] mod_db.c:194 Usage for 5_user_5 is now 1/2
  251. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(effective_caller_id                                                                                        _name=0873875505)
  252. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [effective_caller_id_name]=[0873875505]
  253. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(effective_caller_id                                                                                        _number=0873875505)
  254. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [effective_caller_id_number]=[0873875505]
  255. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(receiver_accid=5)
  256. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [receiver_accid]=[5]
  257. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 limit(db 353212066139 d                                                                                        id_353212066139 2 !SWITCH_CONGESTION)
  258. 2020-06-09 01:35:35.644404 [DEBUG] switch_limit.c:124 incr called: 353212066139_                                                                                        did_353212066139 max:2, interval:0
  259. 2020-06-09 01:35:35.644404 [DEBUG] mod_db.c:194 Usage for 353212066139_did_35321                                                                                        2066139 is now 1/2
  260. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 export(presence_data=x|                                                                                        ||IP(1150225495)|||^353212066139.* // 353212066139 // 0.00000||||||DID)
  261. 2020-06-09 01:35:35.644404 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [p                                                                                        resence_data]=[x|||IP(1150225495)|||^353212066139.* // 353212066139 // 0.00000||                                                                                        ||||DID]
  262. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 export(call_type=10)
  263. 2020-06-09 01:35:35.644404 [DEBUG] switch_channel.c:1310 EXPORT (export_vars) [c                                                                                        all_type]=[10]
  264. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(did_calltype=10)
  265. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [did_calltype]=[10]
  266. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(did_extensions=1)
  267. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [did_extensions]=[1]
  268. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(ringback=)
  269. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [ringback]=[UNDEF]
  270. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(module_name=pbx)
  271. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [module_name]=[pbx]
  272. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(sip_h_P-call_type=c                                                                                        ustom_forward)
  273. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [sip_h_P-call_type]=[custom_forward]
  274. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(sip_h_P-Accountcode                                                                                        =5)
  275. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [sip_h_P-Accountcode]=[5]
  276. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(variable_sip_to_hos                                                                                        t=195.191.29.50)
  277. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [variable_sip_to_host]=[195.191.29.50]
  278. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(userinfo_id=4)
  279. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [userinfo_id]=[4]
  280. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(variable_sip_to_hos                                                                                        t=195.191.29.50)
  281. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [variable_sip_to_host]=[195.191.29.50]
  282. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(original_did_number                                                                                        =353212066139)
  283. 2020-06-09 01:35:35.644404 [DEBUG] mod_dptools.c:1672 SET sofia/default/08738755                                                                                        05@195.191.28.30 [original_did_number]=[353212066139]
  284. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 answer()
  285. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_media.c:8661 AUDIO RTP [sofia/def                                                                                        ault/0873875505@195.191.28.30] 161.35.47.249 port 23130 -> 195.191.28.30 port 25                                                                                        206 codec: 8 ms: 20
  286. 2020-06-09 01:35:35.644404 [DEBUG] switch_rtp.c:4413 Starting timer [soft] 160 b                                                                                        ytes per 20ms
  287. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_media.c:8975 sofia/default/087387                                                                                        5505@195.191.28.30 Set 2833 dtmf send payload to 101
  288. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_media.c:8982 sofia/default/087387                                                                                        5505@195.191.28.30 Set 2833 dtmf receive payload to 101
  289. 2020-06-09 01:35:35.644404 [DEBUG] switch_core_media.c:9005 sofia/default/087387                                                                                        5505@195.191.28.30 Set rtp dtmf delay to 40
  290. 2020-06-09 01:35:35.644404 [DEBUG] mod_sofia.c:898 Local SDP sofia/default/08738                                                                                        75505@195.191.28.30:
  291. v=0
  292. o=FreeSWITCH 1591643405 1591643406 IN IP4 161.35.47.249
  293. s=FreeSWITCH
  294. c=IN IP4 161.35.47.249
  295. t=0 0
  296. m=audio 23130 RTP/AVP 8 101
  297. a=rtpmap:8 PCMA/8000
  298. a=rtpmap:101 telephone-event/8000
  299. a=fmtp:101 0-16
  300. a=ptime:20
  301. a=sendrecv
  302.  
  303. 2020-06-09 01:35:35.644404 [DEBUG] sofia.c:7325 Channel sofia/default/0873875505                                                                                        @195.191.28.30 entering state [completed][200]
  304. 2020-06-09 01:35:35.644404 [NOTICE] mod_dptools.c:1406 Channel [sofia/default/08                                                                                        73875505@195.191.28.30] has been answered
  305. 2020-06-09 01:35:35.644404 [DEBUG] switch_channel.c:3865 (sofia/default/08738755                                                                                        05@195.191.28.30) Callstate Change RINGING -> ACTIVE
  306. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 ivr(mmabc_welcome0)
  307. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_x                                                                                        ml_add binding 'menu-exit'
  308. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_x                                                                                        ml_add binding 'menu-sub'
  309. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_x                                                                                        ml_add binding 'menu-exec-app'
  310. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_x                                                                                        ml_add binding 'menu-play-sound'
  311. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_x                                                                                        ml_add binding 'menu-back'
  312. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:746 switch_ivr_menu_stack_x                                                                                        ml_add binding 'menu-top'
  313. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:883 building menu 'mmabc_we                                                                                        lcome0'
  314. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:968 binding menu action 'me                                                                                        nu-exec-app' to '1'
  315. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:968 binding menu action 'me                                                                                        nu-exec-app' to '2'
  316. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:968 binding menu action 'me                                                                                        nu-exec-app' to '3'
  317. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:968 binding menu action 'me                                                                                        nu-exec-app' to '/^(\d{2,20})$/'
  318. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_menu.c:486 Executing IVR menu mmab                                                                                        c_welcome0
  319. 2020-06-09 01:35:35.664396 [DEBUG] sofia.c:7325 Channel sofia/default/0873875505                                                                                        @195.191.28.30 entering state [ready][200]
  320. 2020-06-09 01:35:35.664396 [DEBUG] switch_core_file.c:405 File /var/www/html/ast                                                                                        pp/upload/pbx/MainMenu_mix_wav_040620125313.wav sample rate 44100 doesn't match                                                                                         requested rate 8000
  321. 2020-06-09 01:35:35.664396 [WARNING] switch_core_file.c:424 File has 2 channels,                                                                                         muxing to 1 channel will occur.
  322. 2020-06-09 01:35:35.664396 [DEBUG] switch_ivr_play_say.c:1488 Codec Activated L1                                                                                        6@8000hz 1 channels 20ms
  323. 2020-06-09 01:35:35.704396 [DEBUG] switch_rtp.c:7722 Correct audio ip/port confi                                                                                        rmed.
  324. 2020-06-09 01:35:36.344410 [WARNING] switch_core_state_machine.c:688 6ca7e59e-c4                                                                                        66-4f3a-9c33-4db23adc28af sofia/default/9725565421444@161.35.47.249 Abandoned
  325. 2020-06-09 01:35:36.344410 [NOTICE] switch_core_state_machine.c:691 Hangup sofia                                                                                        /default/9725565421444@161.35.47.249 [CS_NEW] [WRONG_CALL_STATE]
  326. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:585 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) Running State Change CS_HANGUP (Cur 2 Tot 19)
  327. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:848 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) Callstate Change DOWN -> HANGUP
  328. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:850 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State HANGUP
  329. 2020-06-09 01:35:36.344410 [DEBUG] mod_sofia.c:453 Channel sofia/default/9725565                                                                                        421444@161.35.47.249 hanging up, cause: WRONG_CALL_STATE
  330. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:60 sofia/default/                                                                                        9725565421444@161.35.47.249 Standard HANGUP, cause: WRONG_CALL_STATE
  331. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:850 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State HANGUP going to sleep
  332. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:620 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State Change CS_HANGUP -> CS_REPORTING
  333. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:585 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) Running State Change CS_REPORTING (Cur 2 Tot 19)
  334. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:936 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State REPORTING
  335. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:174 sofia/default                                                                                        /9725565421444@161.35.47.249 Standard REPORTING, cause: WRONG_CALL_STATE
  336. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:936 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State REPORTING going to sleep
  337. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:611 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State Change CS_REPORTING -> CS_DESTROY
  338. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_session.c:1726 Session 18 (sofia/                                                                                        default/9725565421444@161.35.47.249) Locked, Waiting on external entities
  339. 2020-06-09 01:35:36.344410 [NOTICE] switch_core_session.c:1744 Session 18 (sofia                                                                                        /default/9725565421444@161.35.47.249) Ended
  340. 2020-06-09 01:35:36.344410 [NOTICE] switch_core_session.c:1748 Close Channel sof                                                                                        ia/default/9725565421444@161.35.47.249 [CS_DESTROY]
  341. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:739 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) Running State Change CS_DESTROY (Cur 1 Tot 19)
  342. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:749 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State DESTROY
  343. 2020-06-09 01:35:36.344410 [DEBUG] mod_sofia.c:364 sofia/default/9725565421444@1                                                                                        61.35.47.249 SOFIA DESTROY
  344. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:181 sofia/default                                                                                        /9725565421444@161.35.47.249 Standard DESTROY
  345. 2020-06-09 01:35:36.344410 [DEBUG] switch_core_state_machine.c:749 (sofia/defaul                                                                                        t/9725565421444@161.35.47.249) State DESTROY going to sleep
  346. 2020-06-09 01:35:37.884457 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [101@mmabc.ie.pbx.cloudcndns.com] from ip 212.129.78.59
  347. 2020-06-09 01:35:38.044440 [WARNING] sofia_reg.c:1794 SIP auth challenge (REGISTER) on sofia profile 'default' for [101@mmabc.ie.pbx.cloudcndns.com] from ip 212.129.78.59
  348. 2020-06-09 01:35:41.844435 [DEBUG] switch_rtp.c:7967 RTP RECV DTMF 1:2080
  349. 2020-06-09 01:35:41.844435 [INFO] switch_channel.c:522 RECV DTMF 1:2080
  350. 2020-06-09 01:35:41.844435 [DEBUG] switch_ivr_play_say.c:1933 done playing file /var/www/html/astpp/upload/pbx/MainMenu_mix_wav_040620125313.wav
  351. 2020-06-09 01:35:41.844435 [DEBUG] switch_ivr_menu.c:378 waiting for 19/20 digits t/o 2000
  352. 2020-06-09 01:35:43.844456 [DEBUG] switch_ivr_menu.c:425 digits '1'
  353. 2020-06-09 01:35:43.844456 [DEBUG] switch_ivr_menu.c:580 IVR action on menu 'mmabc_welcome0' matched '1' param 'transfer 101 XML ${domain_name}'
  354. 2020-06-09 01:35:43.844456 [DEBUG] switch_ivr_menu.c:584 switch_ivr_menu_execute todo=[2]
  355. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 transfer(101 XML 161.35.47.249)
  356. 2020-06-09 01:35:43.844456 [DEBUG] switch_ivr.c:2243 (sofia/default/0873875505@195.191.28.30) State Change CS_EXECUTE -> CS_ROUTING
  357. 2020-06-09 01:35:43.844456 [NOTICE] switch_ivr.c:2250 Transfer sofia/default/0873875505@195.191.28.30 to XML[101@161.35.47.249]
  358. 2020-06-09 01:35:43.844456 [DEBUG] switch_ivr_menu.c:562 action regex [1] [/^(\d{2,20})$/] [0]
  359. 2020-06-09 01:35:43.844456 [DEBUG] switch_ivr_menu.c:676 exit-sound '(null)'
  360. 2020-06-09 01:35:43.844456 [DEBUG] switch_core_state_machine.c:651 (sofia/default/0873875505@195.191.28.30) State EXECUTE going to sleep
  361. 2020-06-09 01:35:43.844456 [DEBUG] switch_core_state_machine.c:585 (sofia/default/0873875505@195.191.28.30) Running State Change CS_ROUTING (Cur 1 Tot 19)
  362. 2020-06-09 01:35:43.844456 [DEBUG] switch_channel.c:2332 (sofia/default/0873875505@195.191.28.30) Callstate Change ACTIVE -> RINGING
  363. 2020-06-09 01:35:43.844456 [DEBUG] switch_core_state_machine.c:644 (sofia/default/0873875505@195.191.28.30) State ROUTING
  364. 2020-06-09 01:35:43.844456 [DEBUG] mod_sofia.c:154 sofia/default/0873875505@195.191.28.30 SOFIA ROUTING
  365. 2020-06-09 01:35:43.844456 [DEBUG] switch_core_state_machine.c:236 sofia/default/0873875505@195.191.28.30 Standard ROUTING
  366. 2020-06-09 01:35:43.844456 [INFO] mod_dialplan_xml.c:637 Processing 0873875505 <0873875505>->101 in context 161.35.47.249
  367. 2020-06-09 01:35:43.844456 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','InternationalPrefixes')
  368. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  369. 2020-06-09 01:35:43.864401 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] blind_flag: 0
  370. 2020-06-09 01:35:43.864401 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Dialed number : 101
  371. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '101' limit 1
  372. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '101' AND status=0 limit 1
  373. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [Functions] [GET_queue_INFO] Query :SELECT id,destination_number,agent_hold_file from pbx_queue WHERE destination_number = '101' and status=0 LIMIT 1
  374. 2020-06-09 01:35:43.864401 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Caller Id name / number  : 0873875505 / 0873875505
  375. 2020-06-09 01:35:43.864401 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  376. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  377. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="101" LIMIT 1
  378. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [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 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="101"  AND domains.domain="195.191.29.50" limit 1
  379. 2020-06-09 01:35:43.864401 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] Call direction : outbound
  380. 2020-06-09 01:35:43.864401 [INFO] switch_cpp.cpp:1447 [ASTPP] [Accountcode : 5]
  381. 2020-06-09 01:35:43.864401 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "5" AND deleted = 0 limit 1
  382. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^101.*' OR blocked_patterns = '^10.*' OR blocked_patterns = '^1.*' OR blocked_patterns ='--') AND accountid = 5 limit 1
  383. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [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 ="101" AND A.accountid = '5' limit 1
  384. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 101
  385. 2020-06-09 01:35:43.884400 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  386. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  387. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_DID] Query :SELECT A.id as id,A.number as did_number,B.id as accountid,B.number as account_code,A.number as did_number,A.connectcost,A.includedseconds,A.cost,A.inc,A.extensions,A.maxchannels,A.call_type,A.city,A.province,A.init_inc,A.leg_timeout,A.status,A.country_id,A.call_type_vm_flag FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="101" LIMIT 1
  388. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [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 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="101"  AND domains.domain="195.191.29.50" limit 1
  389. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] [Dialplan] New Call direction : outbound
  390. 2020-06-09 01:35:43.884400 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH2: 1
  391. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 1 AND status=0 limit 1
  392. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="101" AND (accountid = 0 OR status = 1) LIMIT 1
  393. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [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 (patterns = '^101.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 5 ORDER BY LENGTH(PKGPTR.patterns) DESC
  394. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '101' OR number = '10' OR number = '1' OR number ='--') OR (number = '101*' OR number = '10*' OR number = '1*' OR number ='--') OR (number = '0873875505' OR number = '087387550' OR number = '08738755' OR number = '0873875' OR number = '087387' OR number = '08738' OR number = '0873' OR number = '087' OR number = '08' OR number = '0' OR number ='--') OR (number = '0873875505*' OR number = '087387550*' OR number = '08738755*' OR number = '0873875*' OR number = '087387*' OR number = '08738*' OR number = '0873*' OR number = '087*' OR number = '08*' OR number = '0*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  395. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Call Barring Status : -1
  396. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '101' OR routing_prefix = '10' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  397. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] =============== Account Information ===================
  398. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] User id : 5
  399. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] Account code : 353212066139
  400. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] Balance : 51.37978
  401. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] Type : 0 [0:prepaid,1:postpaid]
  402. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] Ratecard id : 1
  403. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] CID Pool : 0
  404. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] ========================================================
  405. 2020-06-09 01:35:43.884400 [NOTICE] switch_cpp.cpp:1447 [ASTPP] HARSH1: 2
  406. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_LOCALIZATION] Query :SELECT id,in_caller_id_originate,out_caller_id_originate,number_originate FROM localization WHERE id = 2 AND status=0 limit 1
  407. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  408. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] call_direction :outbound
  409. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^101.*' OR pattern = '^10.*' OR pattern = '^1.*' OR pattern ='--') AND status = 0 AND (pricelist_id = 1 OR accountid=5)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC LIMIT 1
  410. 2020-06-09 01:35:43.884400 [INFO] switch_cpp.cpp:1447 [ASTPP] call_direction:::::: outbound
  411. 2020-06-09 01:35:43.884400 [WARNING] switch_cpp.cpp:1447 [ASTPP] [FIND_MAXLENGTH] Rates not found!!!
  412. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] post_cdrs:::0
  413. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] [GET RESELLERID] Query :SELECT reseller_id FROM accounts WHERE id = 5
  414. 2020-06-09 01:35:43.884400 [DEBUG] switch_cpp.cpp:1447 [ASTPP] Generated XML:
  415. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  416. <document type="freeswitch/xml">
  417. <section name="dialplan" description="ASTPP Dialplan">
  418. <context name="161.35.47.249">
  419. <extension name="101">
  420. <condition field="destination_number" expression="101">
  421. <action application="log" data="WARNING Accountcode . Dialed number (101)  origination rates not found!!"/>
  422. <action application="set" data="original_caller_id_name=0873875505"/>
  423. <action application="set" data="original_caller_id_number=0873875505"/>
  424. <action application="set" data="error_cdr=1"/>
  425. <action application="set" data="callstart=2020-06-09 01:35:43"/>
  426. <action application="set" data="account_id=5"/>
  427. <action application="set" data="parent_id=0"/>
  428. <action application="set" data="call_direction=outbound"/>
  429. <action application="set" data="sip_ignore_remote_cause=true"/>
  430. <action application="set" data="call_processed=internal"/>
  431. <action application="set" data="effective_destination_number=101"/>
  432. <action application="set" data="last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND"/>
  433. <action application="hangup" data="ORIGNATION_RATE_NOT_FOUND"/>
  434. </condition>
  435. </extension>
  436. </context>
  437. </section>
  438. </document>
  439. Dialplan: sofia/default/0873875505@195.191.28.30 parsing [161.35.47.249->101] continue=false
  440. Dialplan: sofia/default/0873875505@195.191.28.30 Regex (PASS) [101] destination_number(101) =~ /101/ break=on-false
  441. Dialplan: sofia/default/0873875505@195.191.28.30 Action log(WARNING Accountcode . Dialed number (101)  origination rates not found!!)
  442. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(original_caller_id_name=0873875505)
  443. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(original_caller_id_number=0873875505)
  444. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(error_cdr=1)
  445. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(callstart=2020-06-09 01:35:43)
  446. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(account_id=5)
  447. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(parent_id=0)
  448. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(call_direction=outbound)
  449. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(sip_ignore_remote_cause=true)
  450. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(call_processed=internal)
  451. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(effective_destination_number=101)
  452. Dialplan: sofia/default/0873875505@195.191.28.30 Action set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND)
  453. Dialplan: sofia/default/0873875505@195.191.28.30 Action hangup(ORIGNATION_RATE_NOT_FOUND)
  454. 2020-06-09 01:35:43.884400 [DEBUG] switch_core_state_machine.c:287 (sofia/default/0873875505@195.191.28.30) State Change CS_ROUTING -> CS_EXECUTE
  455. 2020-06-09 01:35:43.884400 [DEBUG] switch_core_state_machine.c:644 (sofia/default/0873875505@195.191.28.30) State ROUTING going to sleep
  456. 2020-06-09 01:35:43.884400 [DEBUG] switch_core_state_machine.c:585 (sofia/default/0873875505@195.191.28.30) Running State Change CS_EXECUTE (Cur 1 Tot 19)
  457. 2020-06-09 01:35:43.884400 [DEBUG] switch_channel.c:2334 (sofia/default/0873875505@195.191.28.30) Callstate Change RINGING -> ACTIVE
  458. 2020-06-09 01:35:43.884400 [DEBUG] switch_core_state_machine.c:651 (sofia/default/0873875505@195.191.28.30) State EXECUTE
  459. 2020-06-09 01:35:43.904395 [DEBUG] mod_sofia.c:209 sofia/default/0873875505@195.191.28.30 SOFIA EXECUTE
  460. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:329 sofia/default/0873875505@195.191.28.30 Standard EXECUTE
  461. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 log(WARNING Accountcode . Dialed number (101)  origination rates not found!!)
  462. 2020-06-09 01:35:43.904395 [WARNING] mod_dptools.c:1866 Accountcode . Dialed number (101)  origination rates not found!!
  463. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(original_caller_id_name=0873875505)
  464. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [original_caller_id_name]=[0873875505]
  465. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(original_caller_id_number=0873875505)
  466. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [original_caller_id_number]=[0873875505]
  467. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(error_cdr=1)
  468. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [error_cdr]=[1]
  469. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(callstart=2020-06-09 01:35:43)
  470. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [callstart]=[2020-06-09 01:35:43]
  471. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(account_id=5)
  472. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [account_id]=[5]
  473. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(parent_id=0)
  474. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [parent_id]=[0]
  475. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(call_direction=outbound)
  476. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [call_direction]=[outbound]
  477. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(sip_ignore_remote_cause=true)
  478. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [sip_ignore_remote_cause]=[true]
  479. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(call_processed=internal)
  480. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [call_processed]=[internal]
  481. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(effective_destination_number=101)
  482. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [effective_destination_number]=[101]
  483. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 set(last_bridge_hangup_cause=ORIGNATION_RATE_NOT_FOUND)
  484. 2020-06-09 01:35:43.904395 [DEBUG] mod_dptools.c:1672 SET sofia/default/0873875505@195.191.28.30 [last_bridge_hangup_cause]=[ORIGNATION_RATE_NOT_FOUND]
  485. EXECUTE [depth=0] sofia/default/0873875505@195.191.28.30 hangup(ORIGNATION_RATE_NOT_FOUND)
  486. 2020-06-09 01:35:43.904395 [NOTICE] mod_dptools.c:1380 Hangup sofia/default/0873875505@195.191.28.30 [CS_EXECUTE] [NORMAL_CLEARING]
  487. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_session.c:2905 sofia/default/0873875505@195.191.28.30 skip receive message [APPLICATION_EXEC_COMPLETE] (channel is hungup already)
  488. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:651 (sofia/default/0873875505@195.191.28.30) State EXECUTE going to sleep
  489. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:585 (sofia/default/0873875505@195.191.28.30) Running State Change CS_HANGUP (Cur 1 Tot 19)
  490. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:848 (sofia/default/0873875505@195.191.28.30) Callstate Change ACTIVE -> HANGUP
  491. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:850 (sofia/default/0873875505@195.191.28.30) State HANGUP
  492. 2020-06-09 01:35:43.904395 [DEBUG] mod_sofia.c:453 Channel sofia/default/0873875505@195.191.28.30 hanging up, cause: NORMAL_CLEARING
  493. 2020-06-09 01:35:43.904395 [DEBUG] mod_sofia.c:507 Sending BYE to sofia/default/0873875505@195.191.28.30
  494. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:60 sofia/default/0873875505@195.191.28.30 Standard HANGUP, cause: NORMAL_CLEARING
  495. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:850 (sofia/default/0873875505@195.191.28.30) State HANGUP going to sleep
  496. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:620 (sofia/default/0873875505@195.191.28.30) State Change CS_HANGUP -> CS_REPORTING
  497. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:585 (sofia/default/0873875505@195.191.28.30) Running State Change CS_REPORTING (Cur 1 Tot 19)
  498. 2020-06-09 01:35:43.904395 [DEBUG] switch_core_state_machine.c:936 (sofia/default/0873875505@195.191.28.30) State REPORTING
  499. 2020-06-09 01:35:43.904395 [INFO] mod_json_cdr.c:271 Process [c6f53dc6-a53f-44e6-ab8e-e38d3303bf5d.cdr.json]
  500. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:174 sofia/default/0873875505@195.191.28.30 Standard REPORTING, cause: NORMAL_CLEARING
  501. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:936 (sofia/default/0873875505@195.191.28.30) State REPORTING going to sleep
  502. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:611 (sofia/default/0873875505@195.191.28.30) State Change CS_REPORTING -> CS_DESTROY
  503. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_session.c:1726 Session 19 (sofia/default/0873875505@195.191.28.30) Locked, Waiting on external entities
  504. 2020-06-09 01:35:43.964407 [NOTICE] switch_core_session.c:1744 Session 19 (sofia/default/0873875505@195.191.28.30) Ended
  505. 2020-06-09 01:35:43.964407 [NOTICE] switch_core_session.c:1748 Close Channel sofia/default/0873875505@195.191.28.30 [CS_DESTROY]
  506. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:739 (sofia/default/0873875505@195.191.28.30) Running State Change CS_DESTROY (Cur 0 Tot 19)
  507. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:749 (sofia/default/0873875505@195.191.28.30) State DESTROY
  508. 2020-06-09 01:35:43.964407 [DEBUG] mod_sofia.c:364 sofia/default/0873875505@195.191.28.30 SOFIA DESTROY
  509. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:181 sofia/default/0873875505@195.191.28.30 Standard DESTROY
  510. 2020-06-09 01:35:43.964407 [DEBUG] switch_core_state_machine.c:749 (sofia/default/0873875505@195.191.28.30) State DESTROY going to sleep
  511. freeswitch@vcbilling> /bye
  512. root@vcbilling:~#
  513.