i cant get this bloody thing to work, ive always use the db_driver sqlite3, since the update all i get it this crap. I don't understand what it is am doing wrong. (i know in the update "sqlite3" is no longer supported)




msf > db_create root:@localhost/metasploit
[-]
[-] Warning: The db_create command is deprecated, use db_connect instead.
[-] The database and schema will be created automatically by
[-] db_connect. If db_connect fails to create the database, create
[-] it manually with your DBMS's administration tools.
[-]
Password:
Password:
createdb.bin: could not connect to database postgres: FATAL: password authentication failed for user "root"
[-] Error while running command db_create: Failed to connect to the database: could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refusedpassword authentication failed for user "root"
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?


Call stack:
/opt/framework3/msf3/lib/msf/ui/console/command_dispatcher/db.rb:2120:in `db_create_postgresql'
/opt/framework3/msf3/lib/msf/ui/console/command_dispatcher/db.rb:1689:in `cmd_db_create'
/opt/framework3/msf3/lib/rex/ui/text/dispatcher_shell.rb:331:in `run_command'
/opt/framework3/msf3/lib/rex/ui/text/dispatcher_shell.rb:293:in `block in run_single'
/opt/framework3/msf3/lib/rex/ui/text/dispatcher_shell.rb:287:in `each'
/opt/framework3/msf3/lib/rex/ui/text/dispatcher_shell.rb:287:in `run_single'
/opt/framework3/msf3/lib/rex/ui/text/shell.rb:143:in `run'
/opt/framework3/msf3/msfconsole:130:in `<main>'
msf >

as i/you can see it says "password authentication failed for user "root" " but am putting in the right root password