Error while running command db_hosts: can't convert String into Integer

[axnjxnind at gmail.com (axn jxn)]

I have reproduced the error while using postgres as the db, too. That
makes me think that the issue is with the activerecord gem. From my
limited amount of knowledge about the internal workings of metasploit,
that seems to be the common denominator. As of right now I'm running
activerecord-1.15.3. Is anyone else running a different/older version
that works without issue?

On 7/12/07, Qnix <qnix69 at gmail.com> wrote:
> im having the same problem
>
>
> On 7/12/07, axn jxn <axnjxnind at gmail.com> wrote:
> > Hello all,
> >
> > I'm looking for some insight as to why I'm getting this error:
> >
> > Error while running command db_hosts: can't convert String into Integer
> >
> > Any help is appreciated. Thanks.
> >
> > Commands and Call Stack listed below:
> > --------------------------------------------------
> >
> > ~/tools/metasploit/svn/trunk# svn update
> > A    modules/exploits/windows/http/sapdb_webtools.rb
> > Updated to revision 5045.
> > ~/tools/metasploit/svn/trunk# uname -a; mysql --version;
> > Linux  2.6.20-16-generic #2 SMP Thu Jun 7 20:19:32 UTC 2007 i686 GNU/Linux
> > mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline
> 5.2
> > ~/tools/metasploit/svn/trunk# ./msfconsole
> >
> >                 _                  _       _ _
> >                | |                | |     (_) |
> > _ __ ___   ___| |_ __ _ ___ _ __ | | ___  _| |_
> > | '_ ` _ \ / _ \ __/ _` / __| '_ \| |/ _ \| | __|
> > | | | | | |  __/ || (_| \__ \ |_) | | (_) | | |_
> > |_| |_| |_|\___|\__\__,_|___/ .__/|_|\___/|_|\__|
> >                             | |
> >                             |_|
> >
> >
> >        =[ msf v3.1-dev
> > + -- --=[ 209 exploits - 107 payloads
> > + -- --=[ 17 encoders - 5 nops
> >        =[ 39 aux
> >
> > msf > load db_mysql
> > [*] Successfully loaded plugin: db_mysql
> > msf > help
> >
> > MySQL Database Commands
> > =======================
> >
> >     Command        Description
> >     -------        -----------
> >     db_connect     Connect to an existing database (
> user:pass at host:port/db )
> >     db_create      Create a brand new database ( user:pass at host:port/db )
> >     db_destroy     Drop an existing database ( user:pass at host:port/db )
> >     db_disconnect  Disconnect from the current database instance
> >
> >
> > Core Commands
> > =============
> >
> >     Command       Description
> >     -------       -----------
> >     ?             Help menu
> >     back          Move back from the current context
> >     banner        Display an awesome metasploit banner
> >     cd            Change the current working directory
> >     exit          Exit the console
> >     help          Help menu
> >     info          Displays information about one or more module
> >     irb           Drop into irb scripting mode
> >     jobs          Displays and manages jobs
> >     load          Load a framework plugin
> >     loadpath      Searches for and loads modules from a path
> >     quit          Exit the console
> >     route         Route traffic through a session
> >     save          Saves the active datastores
> >     sessions      Dump session listings and display information about
> sessions
> >     set           Sets a variable to a value
> >     setg          Sets a global variable to a value
> >     show          Displays modules of a given type, or all modules
> >     sleep         Do nothing for the specified number of seconds
> >     unload        Unload a framework plugin
> >     unset         Unsets one or more variables
> >     unsetg        Unsets one or more global variables
> >     use           Selects a module by name
> >     version       Show the console library version number
> >
> > msf > db_create user:pass at localhost:3306/metasploitdb
> > [*] Database creation complete (check for errors)
> > msf > db_connect user:pass at localhost:3306/metasploitdb
> > msf > db_hosts
> > [-] Error while running command db_hosts: can't convert String into
> Integer
> > Call stack:
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
> > `real_connect'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
> > `connect'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:152:in
> > `initialize'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
> > `new'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
> > `mysql_connection'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
> > `send'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
> > `connection_without_query_cache='
> > /var/lib/gems/1.8/gems/activerecord-
> 1.15.3/lib/active_record/query_cache.rb:54:in
> > `connection='
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in
> > `retrieve_connection'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
> > `connection'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1139:in
> > `add_limit!'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1101:in
> > `construct_finder_sql'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:997:in
> > `find_every'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:418:in
> > `find'
> > ./lib/msf/core/db_objects.rb:35:in `find'
> > /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'
> > ./lib/msf/core/db_objects.rb:34:in `find'
> > ./lib/msf/core/db.rb:160:in `hosts'
> > ./lib/msf/core/db.rb:151:in `each_host'
> > ./lib/msf/ui/console/command_dispatcher/db.rb:45:in
> `cmd_db_hosts'
> > ./lib/rex/ui/text/dispatcher_shell.rb:230:in `send'
> > ./lib/rex/ui/text/dispatcher_shell.rb:230: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:77
> > [-] Error while running command db_hosts: can't convert String into
> Integer
> > Call stack:
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
> > `real_connect'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:389:in
> > `connect'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:152:in
> > `initialize'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
> > `new'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:82:in
> > `mysql_connection'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
> > `send'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
> > `connection_without_query_cache='
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/query_cache.rb:54:in
> > `connection='
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in
> > `retrieve_connection'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
> > `connection'
> > /var/lib/gems/1.8/gems/activerecord-1.15.3
> /lib/active_record/base.rb:1139:in
> > `add_limit!'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1101:in
> > `construct_finder_sql'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:997:in
> > `find_every'
> /var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:418:in
> > `find'
> > ./lib/msf/core/db_objects.rb:35:in `find'
> > /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'
> > ./lib/msf/core/db_objects.rb:34:in `find'
> > ./lib/msf/core/db.rb:160:in `hosts'
> > ./lib/msf/core/db.rb:151:in `each_host'
> > ./lib/msf/ui/console/command_dispatcher/db.rb:45:in
> `cmd_db_hosts'
> > ./lib/rex/ui/text/dispatcher_shell.rb:230:in `send'
> > ./lib/rex/ui/text/dispatcher_shell.rb:230: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:77
> > msf >