[framework] Problem to connect to postgres with db_connect

[FRANCIS PROVENCHER]

Hi all,

i try to test the automation of Msf3.
(I will try to tell you the maximum information about my configuration)

I create my db in Postgres its name is= metasploitdb


Table 	Owner 	Tablespace 	Estimated row count 	Actions 	Comment

hosts 	****** 		       0         Browse	Select	Insert	Empty	Drop	Vacuum		
refs     ****** 		 0        Browse	Select	Insert	Empty	Drop	Vacuum		
services ****** 	       0        Browse	Select	Insert	Empty	Drop	Vacuum		
vulns   ****** 	                0        Browse	Select	Insert	Empty	Drop	Vacuum		
vulns_refs  ****** 	      0        Browse	Select	Insert	Empty	Drop	Vacuum		

**********# uname -a
FreeBSD ******************* 6.1-SECURITY FreeBSD 6.1-SECURITY #0: Mon Dec  4 07:53:55 UTC 2006     root at builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  i386


****************$sudo cd /root/Metasploit/framework-3.0-beta-3
password:***************
***************$ ./msfconsole

                _                  _       _ _
               | |                | |     (_) |
 _ __ ___   ___| |_ __ _ ___ _ __ | | ___  _| |_
| '_ ` _ \ / _ \ __/ _` / __| '_ \| |/ _ \| | __|
| | | | | |  __/ || (_| \__ \ |_) | | (_) | | |_
|_| |_| |_|\___|\__\__,_|___/ .__/|_|\___/|_|\__|
                            | |
                            |_|


       =[ msf v3.0-beta-dev
+ -- --=[ 131 exploits - 99 payloads
+ -- --=[ 17 encoders - 4 nops
       =[ 27 aux

msf > load db_postgres
[*] Successfully loaded plugin: db_postgres

msf > help

Postgres 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

msf > db_connect Francis:*******@localhost:5432/metasploitdb
[-] Error while running command db_connect: This plugin failed to load:  Failed to connect to the database

Call stack:
/root/Metasploit/framework-3.0-beta-3/plugins/db_postgres.rb:67:in `cmd_db_connect'
./lib/rex/ui/text/dispatcher_shell.rb:229:in `send'
./lib/rex/ui/text/dispatcher_shell.rb:229: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:118:in `run'
./msfconsole:63


**********# nmap -p 5432 localhost

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2006-12-08 16:15 EST
Interesting ports on localhost (127.0.0.1):
PORT     STATE SERVICE
5432/tcp open  postgres

Nmap finished: 1 IP address (1 host up) scanned in 0.051 seconds


Some one can help me to understand what i do wrong?

Thanks all for your support

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 +