autopwn sqlite3 problem

[hajin3 at gmail.com (HaJin)]

Hey guys,

I'm having problems making autopwn work with sqlite3. Here's what I do

msf > load db_sqlite3
[*] Successfully loaded plugin: db_sqlite3
msf > db_connect test.db
[*] Successfully connected to the database
[*] File: test.db
msf > db_nmap -p 445 -n 192.168.xxx.xxx
[*] exec: "/usr/bin/nmap" "-p" "445" "-n" "192.168.xxx.xxx" "-oX"
"/tmp/dbnmap.2267.0"
NMAP:
NMAP: Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2008-11-10
01:53 CET
NMAP: Interesting ports on 192.168.xxx.xxx:
NMAP: PORT STATE SERVICE
NMAP: 445/tcp open microsoft-ds
NMAP: MAC Address: xx:xx:xx:xx:xx:xx
NMAP:
NMAP: Nmap finished: 1 IP address (1 host up) scanned in 0.410 seconds
[-] Error while running command db_nmap: Could not find table 'hosts'

Call stack:

/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb:29:in
`table_structure'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/../../activesupport/lib/active_support/core_ext/object/misc.rb:28:in
`returning'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in
`table_structure'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:189:in
`columns'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/base.rb:1149:in
`columns'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/base.rb:2616:in
`attributes_from_column_definition_without_lock'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:55:in
`attributes_from_column_definition'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/base.rb:2137:in
`initialize'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/base.rb:642:in
`new'
/home/xxx/trunk/data/msfweb/vendor/rails/activerecord/lib/active_record/base.rb:642:in
`create'
./lib/msf/core/db.rb:251:in `get_host'
./lib/msf/ui/console/command_dispatcher/db.rb:458:in `load_nmap_xml'
/usr/lib/ruby/1.8/rexml/element.rb:939:in `each'
/usr/lib/ruby/1.8/rexml/xpath.rb:53:in `each'
/usr/lib/ruby/1.8/rexml/element.rb:939:in `each'
./lib/msf/ui/console/command_dispatcher/db.rb:444:in `load_nmap_xml'
/usr/lib/ruby/1.8/rexml/element.rb:939:in `each'
/usr/lib/ruby/1.8/rexml/xpath.rb:53:in `each'
/usr/lib/ruby/1.8/rexml/element.rb:939:in `each'
./lib/msf/ui/console/command_dispatcher/db.rb:442:in `load_nmap_xml'
./lib/msf/ui/console/command_dispatcher/db.rb:434:in `cmd_db_nmap'
./lib/rex/ui/text/dispatcher_shell.rb:234:in `send'
./lib/rex/ui/text/dispatcher_shell.rb:234:in `run_command'
./lib/rex/ui/text/dispatcher_shell.rb:196:in `run_single'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `each'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `run_single'
./lib/rex/ui/text/shell.rb:125:in `run'
./msfconsole:78

Now it tells me that table hosts is not found but when i type "sqlite3
test.db .table" i get :

->hosts<-     refs         requests     targets      vulns_refs
   notes        reports    services      vulns

My ruby version is 1.8.5

Metasploit revision 5864 (but i had this problem in earlier versions as
well)

gem list output:

*** LOCAL GEMS ***
activerecord (2.1.2)
  Implements the ActiveRecord pattern for ORM.
activesupport (2.1.2)
  Support and utility classes used by the Rails framework.
sources (0.0.1)
  This package provides download sources for remote gem installation
sqlite3-ruby (1.2.4)
  SQLite3/Ruby is a module to allow Ruby scripts to interface with a
  SQLite3 database.

There was a similiar post few moths ago by nnp but the answer was "db_create
is failing to setup the table correctly" which is not very helpful.

Anyone else had this problem, any suggestions ?

Thanks,

    HaJin.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.metasploit.com/pipermail/framework/attachments/20081110/47cefd0e/attachment.htm>