Have you installed postgres yourself at all?
I know its been stated before but again ....
service postgreql status
service metasploit status
msfconsole
cat /opt/metasploit/apps/pro/ui/config/database.yml
check your database name=msf3
check your user name=msf3
#########################################
development:
adapter:
"postgresql"
database:
"msf3"
username:
"msf3"
password: "9hMj2yrZ62r3cynWh***************"
port: 5432
host: "localhost"
pool: 256
timeout: 5
production:
adapter:
"postgresql"
database:
"msf3"
username:
"msf3"
password: "9hMj2yrZ62r3cynWh***************"
port: 5432
host: "localhost"
pool: 256
timeout: 5
=========================================
Make sure its just like that. I had errors before with armitage connecting due to this being changed somehow to below:
development:
adapter: "postgresql"
database: "msf3"
username: "msf3"
password: "9hMj2yrZ62r3cynWh***************"
port: 5432
host: "localhost"
pool: 256
timeout: 5
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
#
# Note also, sqlite3 is totally unsupported by Metasploit now.
test:
adapter: sqlite3
database: "msf3"
pool: 5
timeout: 5
Also try using your ip instead of localhost or 127.0.0.1
db_connect msf:
[email protected]/msf3