Metasploit db_autopwn using PostgreSQL

[sickness]

Sorry for post an image, but i don't know how copy text from the fast track terminal (no scroll bar)

It's this ok?

http://i46.tinypic.com/30az5hi.jpg

Create the damn "root" user for it to work.

[8084FETT]

Create the damn "root" user for it to work.

How?

Thanks!

[Krytical]

just like you created the user "postgres" in this tutorial, see its people like you that force the senior members to respond unkindly... you don't read the thread you are posting in and even TRY to connect the dots yourself...

[8084FETT]

whatever...

This is better explication:

to create a first user in kubuntu/ubuntu linux, type the following:
~$ sudo su postgres -c createuser *USERNAME*

Then create a db:
~$ sudo su postgres -c createdb *DBNAME*

Then create a password for the user by connecting using psql:
~$ sudo su postgres -c psql *DBNAME*

Then alter the password:
=#ALTER USER *username* WITH PASSWORD ‘*password*‘;
=#\q

And you have a user for apps like django, per se.

[fungi]

tried

ALTER USER postgres WITH PASSWORD 'your password';

                               \q

after \q I get the error "could not save history to file "/var/lib.postgresql/.psql_history": Permission denied"

Any ideas?

okay I created the file .psql_history and set the permissions to write - is that what I'm supposed to do?

I followed the instructions and when I run autopwn I get the error:

dropdb: could not connect to database postgres: FATAL: role "root" does not exist

Is this normal?

What's not exactly clear to me is - is the code I'm entering into msf permanent or do I have to enter it everytime I want to run msf?

If I do have to enter it every time how do I run fast track with the additional code?

Thanks for the help.

[sickness]

tried

ALTER USER postgres WITH PASSWORD 'your password';

                               \q

after \q I get the error "could not save history to file "/var/lib.postgresql/.psql_history": Permission denied"

Any ideas?

Just leave it that way ... and move on it will work.

[fungi]

Just leave it that way ... and move on it will work.

Okay what about...

dropdb: could not connect to database postgres: FATAL: role "root" does not exist

I have the user postgres and am logged in with root?

[sickness]

Okay what about...

dropdb: could not connect to database postgres: FATAL: role "root" does not exist

I have the user postgres and am logged in with root?

Why woun't you read my tutorial ? it clearly states that if you want to connect as root you need to create the user and the default login goes as the user "postgres" ...

[fungi]

Okay I'm not following...

I've read your tutorial many times. Maybe you can help clarify.

What I'm understanding from your post is that I have to be logged in as postgres when running msf.

So how can I set that as the default when starting msf? Like running msf from fast-track?

[sickness]

Okay I'm not following...

I've read your tutorial many times. Maybe you can help clarify.

What I'm understanding from your post is that I have to be logged in as postgres when running msf.

So how can I set that as the default when starting msf? Like running msf from fast-track?

Dude seriously ... can't you search google ?

Re: psql: FATAL: user "root" does not exist createdb:

execute these as the postgres user:

su - postgres

One option is to create a super-user with something like:

postgres$ createuser -d -a -P jeoff

then:

jeoff$ createdb ibmadb

Where do you guys even come from ?