Encoding Error with psql

Discussion created by romk55 on May 4, 2012
Latest reply on May 6, 2012 by romk55

I am just setting up my Metasploit, but i have a problem with the db_connect and psql.
It sounds like following:

msf > db_connect postgres:Test12345@

[-] Error while running command db_connect: Failed to connect to the database: PGError: ERROR:  invalid byte sequence for encoding "UTF8": 0xc3c3

HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

: CREATE DATABASE "metasp��loit" ENCODING = 'utf8'


Call stack:

/opt/metasploit/msf3/lib/msf/ui/console/command_dispatcher/db.rb:1422:in `db_connect_postgresql'

/opt/metasploit/msf3/lib/msf/ui/console/command_dispatcher/db.rb:1286:in `cmd_db_connect'

/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:380:in `run_command'

/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:342:in `block in run_single'

/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:336:in `each'

/opt/metasploit/msf3/lib/rex/ui/text/dispatcher_shell.rb:336:in `run_single'

/opt/metasploit/msf3/lib/rex/ui/text/shell.rb:199:in `run'

/opt/metasploit/msf3/msfconsole:134:in `<main>'

msf >


Does someone know how to change encoding with "client_encoding" ?Thank you