The above (LORDx19) doesn't work, still getting Op's errror and it's 2/26/2014!
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>'
msf > Interrupt: use the 'exit' command to quit
msf > Interrupt: use the 'exit' command to quit
msf > Interrupt: use the 'exit' command to quit
msf > Interrupt: use the 'exit' command to quit
msf > db_status[*] postgresql connected to postgres
msf > Interrupt: use the 'exit' command to quit
msf > Interrupt: use the 'exit' command to quit
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>'
linux fully updated: Linux version 3.12-kali1-686-pae (
[email protected]) (gcc version 4.7.2 (Debian 4.7.2-5) ) #1 SMP Debian 3.12.6-2kali1 (2014-01-06)