I've been having trouble connecting between Metasploit and postgres. I've read the following links but it didn't help:


Issue 1)
msf > go_pro[*] Starting the Metasploit services. This can take a little time.[*] Starting PostgreSQL 9.1 database server: main.[*] Starting Metasploit rpc server: prosvc.[*] Starting Metasploit web server: thin.[*] Metasploit worker already started.
[+] Metasploit Community / Pro is up and running, connecting now.
[+] If this is your first time connecting, you will be presented with
[+] a self-signed certificate warning. Accept it to create a new user.
msf >
msf >
msf >
msf >
msf > db_connect postgres:[email protected]/msfbook

[-] Error while running command db_connect: Failed to connect to the database: PG::InvalidParameterValue: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT: Use the same encoding as in the template database, or use template0 as template.
: CREATE DATABASE "msfbook" ENCODING = 'utf8'

Call stack:
/opt/metasploit/apps/pro/msf3/lib/msf/ui/console/command_dispatcher/db.rb:1758:in `db_connect_postgresql'
/opt/metasploit/apps/pro/msf3/lib/msf/ui/console/command_dispatcher/db.rb:1598:in `cmd_db_connect'
/opt/metasploit/apps/pro/msf3/lib/rex/ui/text/dispatcher_shell.rb:427:in `run_command'
/opt/metasploit/apps/pro/msf3/lib/rex/ui/text/dispatcher_shell.rb:389:in `block in run_single'
/opt/metasploit/apps/pro/msf3/lib/rex/ui/text/dispatcher_shell.rb:383:in `each'
/opt/metasploit/apps/pro/msf3/lib/rex/ui/text/dispatcher_shell.rb:383:in `run_single'
/opt/metasploit/apps/pro/msf3/lib/rex/ui/text/shell.rb:200:in `run'
/opt/metasploit/apps/pro/msf3/msfconsole:148:in `<main>'

Issue2) second question is, is here a way I can verify the password to toor?