load db_postgres issue

[michal.merta at gmail.com (Michal Merta)]

Hello list,

I cannot load postgres plugin in metasploit framework.
You can find the output of the command below.
I'm using gentoo with Postgres 8.0.4 and

desert framework-3.0-beta-2-svn # svn info
Path: .
URL: https://metasploit.com/svn/framework3/trunk
Repository Root: https://metasploit.com/svn
Repository UUID: 4d416f70-5f16-0410-b530-b9f4589650da
Revision: 4012
Node Kind: directory
Schedule: normal
Last Changed Author: lmh
Last Changed Rev: 4012
Last Changed Date: 2006-10-07 08:33:29 +0200 (Sat, 07 Oct 2006)

Any idea?
Thanks, Michal


msf > load db_postgres
dropdb: database removal failed: ERROR:  database "msfcurrent" does not exist
CREATE DATABASE
ERROR:  table "hosts" does not exist
NOTICE:  CREATE TABLE will create implicit sequence "hosts_id_seq" for serial co
lumn "hosts.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "hosts_pkey" for
table "hosts"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "hosts_address_key" fo
r table "hosts"
CREATE TABLE
ERROR:  table "services" does not exist
NOTICE:  CREATE TABLE will create implicit sequence "services_id_seq" for serial
 column "services.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "services_pkey" f
or table "services"
CREATE TABLE
ERROR:  table "vulns" does not exist
NOTICE:  CREATE TABLE will create implicit sequence "vulns_id_seq" for serial co
lumn "vulns.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "vulns_pkey" for
table "vulns"
CREATE TABLE
ERROR:  table "refs" does not exist
NOTICE:  CREATE TABLE will create implicit sequence "refs_id_seq" for serial col
umn "refs.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "refs_pkey" for t
able "refs"
CREATE TABLE
ERROR:  table "vulns_refs" does not exist
CREATE TABLE
[-] Error while running command load: This plugin failed to load:  Failed to con
nect to the database

Call stack:
/root/metasploit3/framework-3.0-beta-2-svn/plugins/db_postgres.rb:204:in `initia
lize'
./lib/msf/core/plugin.rb:31:in `new'
./lib/msf/core/plugin.rb:31:in `create'
./lib/msf/core/plugin_manager.rb:67:in `load'
./lib/msf/base/simple/framework.rb:33:in `load'
./lib/msf/ui/console/command_dispatcher/core.rb:271:in `cmd_load'
./lib/rex/ui/text/dispatcher_shell.rb:229:in `send'
./lib/rex/ui/text/dispatcher_shell.rb:229:in `run_command'
./lib/rex/ui/text/dispatcher_shell.rb:196:in `run_single'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `each'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `run_single'
./lib/rex/ui/text/shell.rb:118:in `run'
./msfconsole:63
msf >