Problem to connect to postgres with db_connect

[francis.provencher at msp.gouv.qc.ca (FRANCIS PROVENCHER)]

Thanks for the hint's.

I have re-install the msf3 by the tree ports.
After the re-install, this is the result.


Thanks for the hints, i will try this.

I reinstall the msf3 by the ports tree.

the result after is this;

msf >  load db_postgres
[*] Successfully loaded plugin: db_postgres
msf > db_connect Francis at localhost:5432/metasploitdb
msf > db_nmap -vv -sT -P0 192.168.1.1

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2006-12-09 12:52 EST
DNS resolution of 1 IPs took 0.00s.
Initiating Connect() Scan against ProtekFW1.pnc.ath.cx (192.168.1.1) [1680 ports] at 12:52
Discovered open port 80/tcp on 192.168.1.1
Discovered open port 53/tcp on 192.168.1.1
Discovered open port 21/tcp on 192.168.1.1
Discovered open port 8000/tcp on 192.168.1.1
The Connect() Scan took 29.68s to scan 1680 total ports.
Host ProtekFW1.pnc.ath.cx (192.168.1.1) appears to be up ... good.
Interesting ports on ProtekFW1.pnc.ath.cx (192.168.1.1):
Not shown: 1676 filtered ports
PORT     STATE SERVICE
21/tcp   open  ftp
53/tcp   open  domain
80/tcp   open  http
8000/tcp open  http-alt

Nmap finished: 1 IP address (1 host up) scanned in 29.711 seconds
[-] Error while running command db_nmap: can't convert String into Integer

Call stack:
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/postgresql_adapter.rb:24:in 
`connect'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/postgresql_adapter.rb:24:in 
`postgresql_connection'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
 `send'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
 `connection_without_query_cache='
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in `connection='
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in
 `retrieve_connection'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
 `connection'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1305:in `quote_bound_value'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1287:in `replace_bind_variables'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1287:in `gsub'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1287:in `replace_bind_variables'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1276:in `sanitize_sql'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1062:in `add_conditions!'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1012:in `construct_finder_sql'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:924:in `find_every'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:918:in `find_initial'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:380:in `find'
/usr/local/share/metasploit/lib/msf/core/db_objects.rb:35:in `find'
/usr/local/lib/ruby/1.8/thread.rb:135:in `synchronize'
/usr/local/share/metasploit/lib/msf/core/db_objects.rb:34:in `find'
/usr/local/share/metasploit/lib/msf/core/db.rb:155:in `get_host'
/usr/local/share/metasploit/lib/msf/ui/console/command_dispatcher/db.rb:390:in `load_nmap_xml'
/usr/local/lib/ruby/1.8/rexml/element.rb:939:in `each'
/usr/local/lib/ruby/1.8/rexml/xpath.rb:53:in `each'
/usr/local/lib/ruby/1.8/rexml/element.rb:939:in `each'
/usr/local/share/metasploit/lib/msf/ui/console/command_dispatcher/db.rb:376:in `load_nmap_xml'
/usr/local/lib/ruby/1.8/rexml/element.rb:939:in `each'
/usr/local/lib/ruby/1.8/rexml/xpath.rb:53:in `each'
/usr/local/lib/ruby/1.8/rexml/element.rb:939:in `each'
/usr/local/share/metasploit/lib/msf/ui/console/command_dispatcher/db.rb:374:in `load_nmap_xml'
/usr/local/share/metasploit/lib/msf/ui/console/command_dispatcher/db.rb:366:in `cmd_db_nmap'
/usr/local/share/metasploit/lib/rex/ui/text/dispatcher_shell.rb:229:in `send'
/usr/local/share/metasploit/lib/rex/ui/text/dispatcher_shell.rb:229:in `run_command'
/usr/local/share/metasploit/lib/rex/ui/text/dispatcher_shell.rb:196:in `run_single'
/usr/local/share/metasploit/lib/rex/ui/text/dispatcher_shell.rb:191:in `each'
/usr/local/share/metasploit/lib/rex/ui/text/dispatcher_shell.rb:191:in `run_single'
/usr/local/share/metasploit/lib/rex/ui/text/shell.rb:118:in `run'
/usr/local/bin/msfconsole:63


Francis Provencher
Minist?re de la S?curit? publique du Qu?bec
Direction des technologies de l'information
T?l: 1 418 646-3258
Courriel:   Francis.provencher at Msp.gouv.qc.ca
 
CEH - Certified Ethical Hackers
SSCP - System Security Certified Practitionner
Sec+ - Security +
> > > onatan at gmail.com 12/09/06 12:04 PM >>>
On 12/9/06, FRANCIS PROVENCHER <francis.provencher at msp.gouv.qc.ca> wrote:
> I received this error when i try the db_create metasploitdb;
>
>
> db_create metasploitdb
> [-] Unknown command: db_create.
>
> load db_create metasploitdb
> [-] Error while running command load: no such file to load -- 
> /usr/home/francis/Metasploit/framework-3.0-beta-3/plugins/db_create
>
> I Look on the path /usr/home/francis/Metasploit/framework-3.0-beta-3/plugins/ and the db_create is not present, it's 
> normal? I have download this beta version on Metasploit web site today.

Can you try using the FreeBSD port metasploit-devel?
# cd /usr/ports/security/metasploit-devel
# make install clean