FreeSWITCH Pastebin

Untitled

From Sloppy Elephant, 2 Years ago, written in FreeSWITCH.
- view diff
URL https://pastebin.freeswitch.org/view/5c12511a
Embed
Download Paste or View Raw
  1. span style="color: goldenrod; font-weight: bold;"> 2022-07-08 17:14:25.911352 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="72127272+97699905835" limit 1
  2. 2022-07-08 17:14:25.911352 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [IPAUTHENTICATION] Query :SELECT ip_map.*, (SELECT number FROM accounts where id=accountid AND status=0 AND deleted=0) AS account_code FROM ip_map WHERE INET_ATON("10.0.16.15") 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 "72127272+97699905835"  LIKE CONCAT(prefix,'%') ORDER BY LENGTH(prefix) DESC LIMIT 1
  3. 2022-07-08 17:14:26.011362 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : 72127272+97699905835
  4. 2022-07-08 17:14:26.011362 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : +97699905835
  5. 2022-07-08 17:14:26.011362 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [CHECK_BLOCKED_PREFIX] Query :SELECT * FROM block_patterns WHERE (blocked_patterns = '^+97699905835.*' OR blocked_patterns = '^+9769990583.*' OR blocked_patterns = '^+976999058.*' OR blocked_patterns = '^+97699905.*' OR blocked_patterns = '^+9769990.*' OR blocked_patterns = '^+976999.*' OR blocked_patterns = '^+97699.*' OR blocked_patterns = '^+9769.*' OR blocked_patterns = '^+976.*' OR blocked_patterns = '^+97.*' OR blocked_patterns = '^+9.*' OR blocked_patterns = '^+.*' OR blocked_patterns ='--') AND accountid = 32870 limit 1
  6. 2022-07-08 17:14:26.011362 83.33% [DEBUG] switch_cpp.cpp:1477 [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 ="+97699905835" AND A.accountid = '32870' limit 1
  7. 2022-07-08 17:14:26.011362 83.33% [INFO] switch_cpp.cpp:1477 [ASTPP] [Dialplan] SPEED DIAL NUMBER : +97699905835
  8. 2022-07-08 17:14:26.011362 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : +97699905835
  9. 2022-07-08 17:14:26.011362 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 99905835
  10. 2022-07-08 17:14:26.011362 83.33% [DEBUG] switch_cpp.cpp:1477 [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 ="99905835" LIMIT 1
  11. 2022-07-08 17:14:26.031359 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [CHECK_LOCAL_CALL] Query :SELECT sip_devices.username as username,accounts.number as accountcode,sip_devices.accountid as accountid,accounts.did_cid_translation as did_cid_translation FROM sip_devices as sip_devices,accounts as  accounts WHERE accounts.status=0 AND accounts.deleted=0 AND accounts.id=sip_devices.accountid AND sip_devices.username="+97699905835" limit 1
  12. 2022-07-08 17:14:26.031359 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : +97699905835
  13. 2022-07-08 17:14:26.031359 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 99905835
  14. 2022-07-08 17:14:26.031359 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [IS_CHECK_DID] Query :SELECT * FROM dids WHERE number ="99905835" AND (accountid = 0 OR status = 1) LIMIT 1
  15. 2022-07-08 17:14:26.031359 83.33% [DEBUG] switch_cpp.cpp:1477 [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 = '^+97699905835.*' OR patterns = '^+9769990583.*' OR patterns = '^+976999058.*' OR patterns = '^+97699905.*' OR patterns = '^+9769990.*' OR patterns = '^+976999.*' OR patterns = '^+97699.*' OR patterns = '^+9769.*' OR patterns = '^+976.*' OR patterns = '^+97.*' OR patterns = '^+9.*' OR patterns = '^+.*' OR patterns ='--') AND accountid = 32870 ORDER BY LENGTH(PKGPTR.patterns) DESC
  16. 2022-07-08 17:14:26.031359 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [CHECK_CALL_BARRING] Query :SELECT number,RIGHT(number,1) as lastchar,type as status_type,number_type FROM call_barring WHERE ((number = '+97699905835' OR number = '+9769990583' OR number = '+976999058' OR number = '+97699905' OR number = '+9769990' OR number = '+976999' OR number = '+97699' OR number = '+9769' OR number = '+976' OR number = '+97' OR number = '+9' OR number = '+' OR number ='--') OR (number = '+97699905835*' OR number = '+9769990583*' OR number = '+976999058*' OR number = '+97699905*' OR number = '+9769990*' OR number = '+976999*' OR number = '+97699*' OR number = '+9769*' OR number = '+976*' OR number = '+97*' OR number = '+9*' OR number = '+*' OR number ='--') OR (number = '72127272' OR number = '7212727' OR number = '721272' OR number = '72127' OR number = '7212' OR number = '721' OR number = '72' OR number = '7' OR number ='--') OR (number = '72127272*' OR number = '7212727*' OR number = '721272*' OR number = '72127*' OR number = '7212*' OR number = '721*' OR number = '72*' OR number = '7*' OR number ='--')) AND status=0 order by LENGTH(number) DESC,lastchar DESC, modified_date DESC
  17. 2022-07-08 17:14:26.031359 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [GET_PRICELIST_ROUTING_INFO] Query :select id,routing_prefix,pricelist_id_admin from pricelists WHERE (routing_prefix = '+97699905835' OR routing_prefix = '+9769990583' OR routing_prefix = '+976999058' OR routing_prefix = '+97699905' OR routing_prefix = '+9769990' OR routing_prefix = '+976999' OR routing_prefix = '+97699' OR routing_prefix = '+9769' OR routing_prefix = '+976' OR routing_prefix = '+97' OR routing_prefix = '+9' OR routing_prefix = '+' OR routing_prefix ='--') AND status = 0 and reseller_id = 0 limit 1
  18. 2022-07-08 17:14:26.031359 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] Before Localization CLI/DST : +97699905835
  19. 2022-07-08 17:14:26.031359 83.33% [NOTICE] switch_cpp.cpp:1477 [ASTPP] [DONUMBERTRANSLATION] After Localization CLI/DST : 99905835
  20. 2022-07-08 17:14:26.031359 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [GET_RATES] Query :SELECT * FROM routes WHERE (pattern = '^99905835.*' OR pattern = '^9990583.*' OR pattern = '^999058.*' OR pattern = '^99905.*' OR pattern = '^9990.*' OR pattern = '^999.*' OR pattern = '^99.*' OR pattern = '^9.*' OR pattern ='--') AND status = 0 AND (pricelist_id = 1 OR accountid=32870)  ORDER BY accountid DESC,LENGTH(pattern) DESC,cost DESC LIMIT 1
  21. 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_cpp.cpp:1477 [ASTPP] [GET_CARRIER_RATES] Query :SELECT TK.id as trunk_id,TK.name as trunk_name,TK.codec,GW.name as path,GW.dialplan_variable,TK.provider_id,TR.init_inc,TK.status,TK.maxchannels,TK.cps,TK.leg_timeout,TR.pattern,TR.id as outbound_route_id,TR.connectcost,TR.comment,TR.includedseconds,TR.cost,TR.inc,TR.prepend,TR.strip,(select name from gateways where status=0 AND id = TK.failover_gateway_id) as path1,(select name from gateways where status=0 AND id = TK.failover_gateway_id1) as path2 FROM outbound_routes as TR,trunks as TK,gateways as GW WHERE GW.status=0 AND GW.id= TK.gateway_id AND TK.status=0 AND TK.id= TR.trunk_id AND (pattern = '^99905835.*' OR pattern = '^9990583.*' OR pattern = '^999058.*' OR pattern = '^99905.*' OR pattern = '^9990.*' OR pattern = '^999.*' OR pattern = '^99.*' OR pattern = '^9.*' OR pattern ='--') AND TR.status = 0  AND TR.trunk_id IN (9,27,35,37,39,41,43,45,47,49,51,53,55,58,60,62) ORDER by LENGTH (pattern) DESC,TR.cost ASC,TR.precedence ASC, TK.precedence
  22. <extension name="99905835">
  23. <condition field="destination_number" expression="72127272+97699905835">
  24. <action application="set" data="effective_destination_number=\+97699905835"/>
  25. <action application="bridge" data="[leg_timeout=]sofia/gateway/SBC/99905835"/>
  26. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 Dialplan: agora.rtc/72127272+97699905835 parsing [default->99905835] continue=false
  27. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 Dialplan: agora.rtc/72127272+97699905835 Regex (FAIL) [99905835] destination_number(72127272+97699905835) =~ /72127272+97699905835/ break=on-false
  28. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [NOTICE] switch_core_state_machine.c:312 Hangup agora.rtc/72127272+97699905835 [CS_ROUTING] [NO_ROUTE_DESTINATION]
  29. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:645 (agora.rtc/72127272+97699905835) State ROUTING going to sleep
  30. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:586 (agora.rtc/72127272+97699905835) Running State Change CS_HANGUP (Cur 211 Tot 367571)
  31. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:849 (agora.rtc/72127272+97699905835) Callstate Change RINGING -> HANGUP
  32. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:851 (agora.rtc/72127272+97699905835) State HANGUP
  33. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:59 agora.rtc/72127272+97699905835 Standard HANGUP, cause: NO_ROUTE_DESTINATION
  34. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:851 (agora.rtc/72127272+97699905835) State HANGUP going to sleep
  35. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:621 (agora.rtc/72127272+97699905835) State Change CS_HANGUP -> CS_REPORTING
  36. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:586 (agora.rtc/72127272+97699905835) Running State Change CS_REPORTING (Cur 211 Tot 367571)
  37. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:937 (agora.rtc/72127272+97699905835) State REPORTING
  38. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:168 agora.rtc/72127272+97699905835 Standard REPORTING, cause: NO_ROUTE_DESTINATION
  39. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:937 (agora.rtc/72127272+97699905835) State REPORTING going to sleep
  40. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:612 (agora.rtc/72127272+97699905835) State Change CS_REPORTING -> CS_DESTROY
  41. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_session.c:1753 Session 367570 (agora.rtc/72127272+97699905835) Locked, Waiting on external entities
  42. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [NOTICE] switch_core_session.c:1771 Session 367570 (agora.rtc/72127272+97699905835) Ended
  43. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [NOTICE] switch_core_session.c:1775 Close Channel agora.rtc/72127272+97699905835 [CS_DESTROY]
  44. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:740 (agora.rtc/72127272+97699905835) Running State Change CS_DESTROY (Cur 210 Tot 367571)
  45. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:750 (agora.rtc/72127272+97699905835) State DESTROY
  46. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] agora_rtc.c:710 agora.rtc/72127272+97699905835 RTC DESTROY
  47. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [INFO] agora_rtc.c:711 agora.rtc/72127272+97699905835 end write video to agora cloud package: 0
  48. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [INFO] agora_rtc.c:712 agora.rtc/72127272+97699905835 end write audio to agora cloud package: 0
  49. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [INFO] agora_rtc.c:713 agora.rtc/72127272+97699905835 end read video from agora cloud package: 0
  50. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [INFO] agora_rtc.c:714 agora.rtc/72127272+97699905835 end read audio from agora cloud package: 0
  51. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] agora_ep.c:189 agora.rtc/72127272+97699905835 Agora RTC DESTROY
  52. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:175 agora.rtc/72127272+97699905835 Standard DESTROY
  53. uuid=9f23d009-e2a9-49bc-bd29-2171d342cba5 2022-07-08 17:14:26.051361 83.33% [DEBUG] switch_core_state_machine.c:750 (agora.rtc/72127272+97699905835) State DESTROY going to sleep
  54. 2022-07-08 17:14:26.091355 83.33% [INFO] mod_verto.c:606 WRITE 10.0.16.15:45958 [{"jsonrpc":"2.0","id":182633,"method":"verto.event","params":{"eventChannel":"Agora.callstate.cd0aef3d-012a-4817-b2e9-de33cc68d191","data":{"func":"bye","agoraChannel":"9f23d009-e2a9-49bc-bd29-2171d342cba5","agoraKey":"7e048a1b9a2e4c0a813981df5268e728","agoraToken":"0067e048a1b9a2e4c0a813981df5268e728IAAw3ImNbDL3X5HDGo9rF1ZVCQvxbJrA7oga8Sp4gw/TFc7x+AoAAAAAEAD+n6T+8EbJYgEAAQAER8li","fsChannel":"9f23d009-e2a9-49bc-bd29-2171d342cba5","cidName":"72127272","cidNumber":"72127272","destNumber":"72127272+97699905835","sessid":"cd0aef3d-012a-4817-b2e9-de33cc68d191","video":"false","byeCause":"NO_ROUTE_DESTINATION","byeCode":"3"},"eventSerno":34,"subscribedChannel":"Agora.callstate.cd0aef3d-012a-4817-b2e9-de33cc68d191"}}]

Reply to "Untitled"