postgresqlpsqlarchlinuxmetasploit

Failed to connect to the database: PG::InvalidParameterValue: ERROR: invalid value for parameter "TimeZone": "UTC" : SET time zone 'UTC'


While trying to run metasploit in arch linux im getting

[root@archserver ~]# msfconsole
[-] Failed to connect to the database:
PG::InvalidParameterValue: ERROR:  invalid value for parameter
"TimeZone": "UTC" : SET time zone 'UTC'

Postgres configuration is done and db is also created

My database.yml is

production:
 adapter: postgresql
 database: msf
 username: root
 password: root
 host: localhost
 port: 5432
 pool: 5
 timeout: 5

Solution

  • Fixed it by editing SET time zone 'UTC' in /opt/metasploit/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb