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
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 |