Tweet
O COMANDO SEARCH DO MEU METASPLOIT NAO ESTA FUNCIONANDO .. OLHEM A MENSAGEM DE ERRO
msf > search MySQL
[-] Error while running command search: PG::Error: ERROR: column "module_details.mtime" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT DISTINCT(module_details.*) FROM "module_details" LEFT...
^
: SELECT DISTINCT(module_details.*) FROM "module_details" LEFT OUTER JOIN module_authors ON module_details.id = module_authors.module_detail_id LEFT OUTER JOIN module_actions ON module_details.id = module_actions.module_detail_id LEFT OUTER JOIN module_archs ON module_details.id = module_archs.module_detail_id LEFT OUTER JOIN module_refs ON module_details.id = module_refs.module_detail_id LEFT OUTER JOIN module_targets ON module_details.id = module_targets.module_detail_id LEFT OUTER JOIN module_platforms ON module_details.id = module_platforms.module_detail_id WHERE ( ( module_details.fullname ILIKE '%mysql%' OR module_details.name ILIKE '%mysql%' OR module_details.description ILIKE '%mysql%' OR module_authors.name ILIKE '%mysql%' OR module_actions.name ILIKE '%mysql%' OR module_archs.name ILIKE '%mysql%' OR module_targets.name ILIKE '%mysql%' OR module_platforms.name ILIKE '%mysql%' ) ) GROUP BY module_details.id
Call stack:
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1139:in `async_exec'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1139:in `exec_no_cache'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:663:in `block in exec_query'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activesupport-3.2.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:662:in `exec_query'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1234:in `select'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/querying.rb:38:in `block in find_by_sql'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/explain.rb:25:in `logging_query_plan'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/querying.rb:37:in `find_by_sql'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation.rb:171:in `exec_queries'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation.rb:160:in `block in to_a'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/explain.rb:25:in `logging_query_plan'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation.rb:159:in `to_a'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation/finder_methods.rb:159:in `all'
/opt/metasploit/msf3/lib/msf/core/db_manager.rb:579:in `block in search_modules'
/opt/metasploit/msf3/lib/msf/core/patches/active_record.rb:22:in `with_connection'
/opt/metasploit/msf3/lib/msf/core/db_manager.rb:531:in `search_modules'
/opt/metasploit/msf3/lib/msf/ui/console/command_dispatcher/core.rb:1369:in `search_modules_sql'
/opt/metasploit/msf3/lib/msf/ui/console/command_dispatcher/core.rb:1338:in `cmd_search'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:420:in `run_command'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:382:in `block in run_single'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:376:in `each'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:376:in `run_single'
/opt/metasploit/msf3/lib/rex/ui/text/shell.rb:200:in `run'
/opt/metasploit/msf3/msfconsole:143:in `<main>'
msf > cmd_search
[-] Unknown command: cmd_search.
msf > search MySQL
[-] Error while running command search: PG::Error: ERROR: column "module_details.mtime" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT DISTINCT(module_details.*) FROM "module_details" LEFT...
^
: SELECT DISTINCT(module_details.*) FROM "module_details" LEFT OUTER JOIN module_authors ON module_details.id = module_authors.module_detail_id LEFT OUTER JOIN module_actions ON module_details.id = module_actions.module_detail_id LEFT OUTER JOIN module_archs ON module_details.id = module_archs.module_detail_id LEFT OUTER JOIN module_refs ON module_details.id = module_refs.module_detail_id LEFT OUTER JOIN module_targets ON module_details.id = module_targets.module_detail_id LEFT OUTER JOIN module_platforms ON module_details.id = module_platforms.module_detail_id WHERE ( ( module_details.fullname ILIKE '%mysql%' OR module_details.name ILIKE '%mysql%' OR module_details.description ILIKE '%mysql%' OR module_authors.name ILIKE '%mysql%' OR module_actions.name ILIKE '%mysql%' OR module_archs.name ILIKE '%mysql%' OR module_targets.name ILIKE '%mysql%' OR module_platforms.name ILIKE '%mysql%' ) ) GROUP BY module_details.id
Call stack:
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1139:in `async_exec'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1139:in `exec_no_cache'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:663:in `block in exec_query'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activesupport-3.2.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:662:in `exec_query'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1234:in `select'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/querying.rb:38:in `block in find_by_sql'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/explain.rb:25:in `logging_query_plan'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/querying.rb:37:in `find_by_sql'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation.rb:171:in `exec_queries'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation.rb:160:in `block in to_a'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/explain.rb:25:in `logging_query_plan'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation.rb:159:in `to_a'
/opt/metasploit/msf3/lib/gemcache/ruby/1.9.1/gems/activerecord-3.2.2/lib/active_record/relation/finder_methods.rb:159:in `all'
/opt/metasploit/msf3/lib/msf/core/db_manager.rb:579:in `block in search_modules'
/opt/metasploit/msf3/lib/msf/core/patches/active_record.rb:22:in `with_connection'
/opt/metasploit/msf3/lib/msf/core/db_manager.rb:531:in `search_modules'
/opt/metasploit/msf3/lib/msf/ui/console/command_dispatcher/core.rb:1369:in `search_modules_sql'
/opt/metasploit/msf3/lib/msf/ui/console/command_dispatcher/core.rb:1338:in `cmd_search'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:420:in `run_command'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:382:in `block in run_single'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:376:in `each'
/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:376:in `run_single'
/opt/metasploit/msf3/lib/rex/ui/text/shell.rb:200:in `run'
/opt/metasploit/msf3/msfconsole:143:in `<main>'
msf > cmd_search
[-] Unknown command: cmd_search.