problem authenticating with encrypted passwords in pg_shadow

From: "Joey Mingrone" <mingrone(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: problem authenticating with encrypted passwords in pg_shadow
Date: 2002-03-14 17:38:15
Message-ID: be5k8.55333$3O2.19768146@typhoon.southeast.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just upgraded to postgresql 7.2 and I'm having trouble connecting to the
postmaster with psql.

Here is what I've done:

I added this line to the top of the pg_hba.conf file.

# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT
local all
md5

Now I connect to the postmaster with the postgres account using psql
(postgres' password is stored as plain text in pg_shadow so I can connect
without any problems) and I run this command:

CREATE USER test WITH ENCRYPTED PASSWORD 'blah';

When I try to connect with the user test form the same host the postmaster
is running on, (psql -U test -d template1) I get the response:

psql: FATAL 1: Password authentication failed for user "test"

When I change the password for the user test back to plain text I can
connect fine.

Anyone know what's going on?

Thanks,

Joey

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2002-03-14 17:45:53 Re: User permissions
Previous Message Joe Conway 2002-03-14 17:32:53 Re: Queries from different databases