From Prashant kumar, 2 Years ago, written in FreeSWITCH.
- view diff
Embed
  1. freeswitch@ip-172-31-15-133>
  2. 2022-02-17 05:44:30.206525 96.40% [NOTICE] switch_channel.c:1123 New Channel sofia/default/9118500270@w02version63.astppbilling.org:5074 [bc8a6c9f-7272-4428-aa9d-474b465de0d4]
  3. 2022-02-17 05:44:30.206525 96.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Running State Change CS_NEW (Cur 1 Tot 9)
  4. 2022-02-17 05:44:30.206525 96.40% [INFO] sofia.c:10462 sofia/default/9118500270@w02version63.astppbilling.org:5074 receiving invite from 117.247.91.162:56787 version: 1.10.7 -release-19-883d2cb662 64bit call-id: ZWRiYjljMWM0ZjA2ZGI3MmZjNTI3YTc5NTVjY2FkMGY.
  5. 2022-02-17 05:44:30.206525 96.40% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0.
  6. 2022-02-17 05:44:30.206525 96.40% [DEBUG] sofia.c:2419 detaching session bc8a6c9f-7272-4428-aa9d-474b465de0d4
  7. 2022-02-17 05:44:30.206525 96.40% [WARNING] sofia_reg.c:1861 SIP auth challenge (INVITE) on sofia profile 'default' for [109560@w02version63.astppbilling.org] from ip 117.247.91.162
  8. 2022-02-17 05:44:30.206525 96.40% [DEBUG] switch_core_state_machine.c:600 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State NEW
  9. 2022-02-17 05:44:30.346439 96.40% [DEBUG] sofia.c:2532 Re-attaching to session bc8a6c9f-7272-4428-aa9d-474b465de0d4
  10. 2022-02-17 05:44:30.346439 96.40% [INFO] sofia.c:10462 sofia/default/9118500270@w02version63.astppbilling.org:5074 receiving invite from 117.247.91.162:56787 version: 1.10.7 -release-19-883d2cb662 64bit call-id: ZWRiYjljMWM0ZjA2ZGI3MmZjNTI3YTc5NTVjY2FkMGY.
  11. 2022-02-17 05:44:30.346439 96.40% [DEBUG] sofia.c:10556 verifying acl "default" for ip/port 117.247.91.162:0.
  12. 2022-02-17 05:44:30.346439 96.40% [DEBUG] sofia.c:11672 Setting NAT mode based on via received
  13. 2022-02-17 05:44:30.346439 96.40% [DEBUG] sofia.c:7499 Channel sofia/default/9118500270@w02version63.astppbilling.org:5074 entering state [received][100]
  14. 2022-02-17 05:44:30.346439 96.40% [DEBUG] sofia.c:7509 Remote SDP:
  15. v=0
  16. o=3cxVCE 291638280 31948860 IN IP4 192.168.1.13
  17. s=3cxVCE Audio Call
  18. c=IN IP4 192.168.1.13
  19. t=0 0
  20. m=audio 40032 RTP/AVP 0 8 3 101
  21. a=rtpmap:0 PCMU/8000
  22. a=rtpmap:8 PCMA/8000
  23. a=rtpmap:3 GSM/8000
  24. a=rtpmap:101 telephone-event/8000
  25. a=fmtp:101 0-15
  26. a=ptime:20
  27. m=video 40030 RTP/AVP 34
  28. c=IN IP4 192.168.1.13
  29. a=rtpmap:34 H263/90000
  30. a=fmtp:34 QCIF=1;CIF=1;SQCIF=1;CIF4=1
  31.  
  32. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  33. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMU:0:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  34. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMU:0:8000:20:64000:1] ++++ is saved as a match
  35. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMA:8:8000:20:64000:1]
  36. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5705 Audio Codec Compare [PCMA:8:8000:20:64000:1] ++++ is saved as a match
  37. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [PCMA:8:8000:20:64000:1]/[PCMU:0:8000:20:64000:1]
  38. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMA:8:8000:20:64000:1]
  39. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5650 Audio Codec Compare [GSM:3:8000:20:13200:1]/[PCMU:0:8000:20:64000:1]
  40. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5566 Set telephone-event payload to 101@8000
  41. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:3870 Set Codec sofia/default/9118500270@w02version63.astppbilling.org:5074 PCMU/8000 20 ms 160 samples 64000 bits 1 channels
  42. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_codec.c:111 sofia/default/9118500270@w02version63.astppbilling.org:5074 Original read codec set to PCMU:0
  43. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5915 Set telephone-event payload to 101@8000
  44. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:5973 sofia/default/9118500270@w02version63.astppbilling.org:5074 Set 2833 dtmf send payload to 101 recv payload to 101
  45. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:6301 No matches with FTMP, fallback to ignoring FMTP
  46. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_media.c:6309 No matches with inherit_codec, fallback to ignoring PT
  47. 2022-02-17 05:44:30.346439 96.40% [DEBUG] sofia.c:7933 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State Change CS_NEW -> CS_INIT
  48. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Running State Change CS_INIT (Cur 1 Tot 9)
  49. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State INIT
  50. 2022-02-17 05:44:30.346439 96.40% [DEBUG] mod_sofia.c:97 sofia/default/9118500270@w02version63.astppbilling.org:5074 SOFIA INIT
  51. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:40 sofia/default/9118500270@w02version63.astppbilling.org:5074 Standard INIT
  52. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:48 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State Change CS_INIT -> CS_ROUTING
  53. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:624 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State INIT going to sleep
  54. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Running State Change CS_ROUTING (Cur 1 Tot 9)
  55. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_channel.c:2380 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Callstate Change DOWN -> RINGING
  56. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State ROUTING
  57. 2022-02-17 05:44:30.346439 96.40% [DEBUG] mod_sofia.c:158 sofia/default/9118500270@w02version63.astppbilling.org:5074 SOFIA ROUTING
  58. 2022-02-17 05:44:30.346439 96.40% [DEBUG] switch_core_state_machine.c:230 sofia/default/9118500270@w02version63.astppbilling.org:5074 Standard ROUTING
  59. 2022-02-17 05:44:30.346439 96.40% [INFO] mod_dialplan_xml.c:639 Processing 9118500270 <9118500270>->109560 in context default
  60. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_CONF] Query :SELECT name,value FROM `system` WHERE group_title IN ('global','opensips','callingcard','calls','international_prefixes','interconnect_code')
  61. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  62. 2022-02-17 05:44:30.366415 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [feature_code_call_transfer] Blind Call Flag: 0
  63. 2022-02-17 05:44:30.366415 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Dialed number : 109560
  64. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [CHECK_FEATURE_CODE] Query :SELECT id,feature_action,feature_code from feature_code where feature_code = '109560' limit 1
  65. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT access_number FROM accessnumber WHERE access_number = '109560' AND status=0 limit 1
  66. 2022-02-17 05:44:30.366415 96.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 = '109560' and status=0 LIMIT 1
  67. 2022-02-17 05:44:30.366415 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] SOURCE NUMBER9118500270
  68. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  69. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL SOURCE] Query :SELECT domain,accountid FROM domains WHERE domain = 'w02version63.astppbilling.org' limit 1
  70. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION LOCAL DOMAIN] Query :SELECT accountid from sip_devices where accountid = '6' and username = '109560' limit 1
  71. 2022-02-17 05:44:30.366415 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Caller Id name / number  : 9118500270 / 9118500270
  72. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Interconnect code destination number
  73. 2022-02-17 05:44:30.366415 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_interconnectcode_info] Query :SELECT * FROM interconnectcode WHERE interconnectcode = 109560 limit 1
  74. 2022-02-17 05:44:30.366415 96.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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  75. 2022-02-17 05:44:30.386418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  76. 2022-02-17 05:44:30.386418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] Call direction : inbound
  77. 2022-02-17 05:44:30.386418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Accountcode : 9118500270]
  78. 2022-02-17 05:44:30.386418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE number = "9118500270" AND deleted = 0 limit 1
  79. 2022-02-17 05:44:30.386418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="109560" AND (accountid = 0 OR status = 1) LIMIT 1
  80. 2022-02-17 05:44:30.386418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] Call Direction : inbound
  81. 2022-02-17 05:44:30.386418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PACKAGE_INFO] DID ACCOUNT ID : 4
  82. 2022-02-17 05:44:30.386418 96.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 = '^109560.*' OR patterns = '^10956.*' OR patterns = '^1095.*' OR patterns = '^109.*' OR patterns = '^10.*' OR patterns = '^1.*' OR patterns ='--') AND accountid = 4 ORDER BY LENGTH(PKGPTR.patterns) DESC
  83. 2022-02-17 05:44:30.386418 96.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 ="109560" AND A.accountid = '6' limit 1
  84. 2022-02-17 05:44:30.386418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] SPEED DIAL NUMBER : 109560
  85. 2022-02-17 05:44:30.386418 96.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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  86. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  87. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [Dialplan] New Call Direction : inbound
  88. 2022-02-17 05:44:30.406418 96.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 = '109560' OR number = '10956' OR number = '1095' OR number = '109' OR number = '10' OR number = '1' OR number ='--') OR (number = '109560*' OR number = '10956*' OR number = '1095*' OR number = '109*' OR number = '10*' OR number = '1*' OR number ='--') OR (number = '9118500270' OR number = '911850027' OR number = '91185002' OR number = '9118500' OR number = '911850' OR number = '91185' OR number = '9118' OR number = '911' OR number = '91' OR number = '9' OR number ='--') OR (number = '9118500270*' OR number = '911850027*' OR number = '91185002*' OR number = '9118500*' OR number = '911850*' OR number = '91185*' OR number = '9118*' OR number = '911*' OR number = '91*' OR number = '9*' OR number ='--')) AND status=0 AND accountid = 0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  89. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] Call Barring Status : -1
  90. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '109560' OR routing_prefix = '10956' OR routing_prefix = '1095' OR routing_prefix = '109' OR routing_prefix = '10' OR routing_prefix = '1' OR routing_prefix ='--') AND status = 0 and reseller_id = 5 limit 1
  91. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Account Information ===================
  92. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 6
  93. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 9118500270
  94. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 39999.6
  95. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  96. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 3
  97. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] CID Pool : 0
  98. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  99. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 3 AND status = 0
  100. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  101. 2022-02-17 05:44:30.406418 96.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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  102. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  103. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  104. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  105. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 1
  106. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  107. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  108. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  109. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : AHD GUJ
  110. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
  111. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 6
  112. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  113. 2022-02-17 05:44:30.406418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your39999.6 balance Accountid 6 !!!
  114. 2022-02-17 05:44:30.406418 96.40% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  115. 2022-02-17 05:44:30.406418 96.40% [NOTICE] switch_cpp.cpp:1465 [ASTPP] FINDING LIMIT FOR RESELLER: 5
  116. 2022-02-17 05:44:30.406418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "5" AND deleted = 0 limit 1
  117. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Reseller Information ===================
  118. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] User id : 5
  119. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Account code : 1196395615
  120. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Balance : 19999.9
  121. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Type : 1 [0:prepaid,1:postpaid]
  122. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Ratecard id : 1
  123. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_PRICELIST_INFO] Query :select * from pricelists WHERE id = 1 AND status = 0
  124. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [GET_RATES] call_direction :inbound
  125. 2022-02-17 05:44:30.426418 96.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 FROM dids AS A,accounts AS B WHERE B.status=0 AND B.deleted=0 AND B.id=A.accountid AND A.number ="109560" LIMIT 1
  126. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  127. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP]  Call Direction : inbound
  128. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] =============== Rates Information ===================
  129. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ID : 1
  130. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Connectcost : 0.00000
  131. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Includedseconds : 0
  132. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Cost : 0.00000
  133. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Comment : AHD GUJ
  134. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Country Id : 88
  135. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Accid : 5
  136. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ================================================================
  137. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Your19999.9 balance Accountid 5 !!!
  138. 2022-02-17 05:44:30.426418 96.40% [NOTICE] switch_cpp.cpp:1465 [ASTPP] [FIND_MAXLENGTH] Call Is Free - Assigning Max Length  :: 100
  139. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Reseller xml_user_rates : ID:1|CODE:^109560.*|DESTINATION:AHD GUJ|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:7|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:4||ID:1|CODE:^109560.*|DESTINATION:AHD GUJ|CONNECTIONCOST:0.00000|INCLUDEDSECONDS:0|CT:7|COST:0.00000|INC:0|INITIALBLOCK:0|RATEGROUP:0|MARKUP:0|CI:88|ACCID:4
  140. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] ========================================================
  141. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Lossless Routing Status : 1
  142. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] Call Max Length Duration : 100 minutes
  143. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] INB_FREE:TRUE
  144. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] free_inbound:1
  145. 2022-02-17 05:44:30.426418 96.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 = 6 AND status=0 LIMIT 1
  146. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [DOAUTHORIZATION] Query :SELECT * FROM accounts WHERE id = "4" AND deleted = 0 limit 1
  147. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML:6
  148. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Userinfo XML:6
  149. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [userinfo] Actual CustomerInfo XML : 6
  150. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 4 limit 1
  151. 2022-02-17 05:44:30.426418 96.40% [WARNING] switch_cpp.cpp:1465 [ASTPP] [user_domain] User Domain : w02version62.astppbilling.org
  152. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP]  Maxlength : 100
  153. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [LOAD_ADDON_CONF] Query :SELECT package_name FROM addons
  154. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [XML] Customer Recording Flag : 1
  155. 2022-02-17 05:44:30.426418 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Direction : inbound
  156. 2022-02-17 05:44:30.426418 96.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 = "2" AND accounts.status = 0
  157. 2022-02-17 05:44:30.426418 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_domain_info] Query :SELECT * FROM domains WHERE accountid = 4 limit 1
  158. 2022-02-17 05:44:30.446417 96.40% [WARNING] switch_cpp.cpp:1465 [ASTPP] [XML] User Domain : w02version62.astppbilling.org
  159. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [get_accounts_info] Query :SELECT * FROM accounts WHERE id = 4  and status = 0 limit 1
  160. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [XML] Custom Function Name :: custom_inbound_7
  161. 2022-02-17 05:44:30.446417 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : 7
  162. 2022-02-17 05:44:30.446417 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] Call Type : Ring Group
  163. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : Query - SELECT call_screening from accounts WHERE id = '4' LIMIT 1
  164. 2022-02-17 05:44:30.446417 96.40% [INFO] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : Screening Option - 0
  165. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_cpp.cpp:1465 [ASTPP] [PBX] did_pbx_info : Query - SELECT value from `system` WHERE name = 'code_welcome_file' LIMIT 1
  166. 2022-02-17 05:44:30.446417 96.40% [ERR] mod_lua.cpp:202 .../share/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:19: attempt to index global 'screening_option' (a nil value)
  167. stack traceback:
  168.         .../share/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:19: in function 'record_introduction'
  169.         .../share/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:58: in function 'did_pbx_info'
  170.         .../share/freeswitch/scripts/astpp/lib/addons/astpp.pbx.lua:2020: in function '?'
  171.         /usr/share/freeswitch/scripts/astpp/scripts/astpp.xml.lua:439: in function 'freeswitch_xml_inbound'
  172.         ...hare/freeswitch/scripts/astpp/scripts/astpp.dialplan.lua:787: in main chunk
  173.         [C]: in function 'dofile'
  174.         /usr/share/freeswitch/scripts/astpp/astpp.lua:94: in main chunk
  175. 2022-02-17 05:44:30.446417 96.40% [ERR] mod_lua.cpp:270 LUA script parse/execute error!
  176. 2022-02-17 05:44:30.446417 96.40% [WARNING] mod_dialplan_xml.c:669 Context default not found
  177. 2022-02-17 05:44:30.446417 96.40% [INFO] switch_core_state_machine.c:306 No Route, Aborting
  178. 2022-02-17 05:44:30.446417 96.40% [NOTICE] switch_core_state_machine.c:307 Hangup sofia/default/9118500270@w02version63.astppbilling.org:5074 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  179. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:640 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State ROUTING going to sleep
  180. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Running State Change CS_HANGUP (Cur 1 Tot 9)
  181. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:844 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Callstate Change RINGING -> HANGUP
  182. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State HANGUP
  183. 2022-02-17 05:44:30.446417 96.40% [DEBUG] mod_sofia.c:468 Channel sofia/default/9118500270@w02version63.astppbilling.org:5074 hanging up, cause: NO_ROUTE_DESTINATION
  184. 2022-02-17 05:44:30.446417 96.40% [DEBUG] mod_sofia.c:613 Responding to INVITE with: 404
  185. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:59 sofia/default/9118500270@w02version63.astppbilling.org:5074 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  186. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:846 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State HANGUP going to sleep
  187. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:616 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State Change CS_HANGUP -> CS_REPORTING
  188. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:581 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Running State Change CS_REPORTING (Cur 1 Tot 9)
  189. 2022-02-17 05:44:30.446417 96.40% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State REPORTING
  190. 2022-02-17 05:44:30.446417 96.40% [INFO] mod_json_cdr.c:271 Process [bc8a6c9f-7272-4428-aa9d-474b465de0d4.cdr.json]
  191. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:168 sofia/default/9118500270@w02version63.astppbilling.org:5074 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  192. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:932 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State REPORTING going to sleep
  193. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:607 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State Change CS_REPORTING -> CS_DESTROY
  194. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_session.c:1753 Session 9 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Locked, Waiting on external entities
  195. 2022-02-17 05:44:30.486420 96.40% [NOTICE] switch_core_session.c:1771 Session 9 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Ended
  196. 2022-02-17 05:44:30.486420 96.40% [NOTICE] switch_core_session.c:1775 Close Channel sofia/default/9118500270@w02version63.astppbilling.org:5074 [CS_DESTROY]
  197. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:735 (sofia/default/9118500270@w02version63.astppbilling.org:5074) Running State Change CS_DESTROY (Cur 0 Tot 9)
  198. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State DESTROY
  199. 2022-02-17 05:44:30.486420 96.40% [DEBUG] mod_sofia.c:379 sofia/default/9118500270@w02version63.astppbilling.org:5074 SOFIA DESTROY
  200. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:175 sofia/default/9118500270@w02version63.astppbilling.org:5074 Standard DESTROY
  201. 2022-02-17 05:44:30.486420 96.40% [DEBUG] switch_core_state_machine.c:745 (sofia/default/9118500270@w02version63.astppbilling.org:5074) State DESTROY going to sleep
  202. freeswitch@ip-172-31-15-133>