Обсуждение: problem authenticating with encrypted passwords in pg_shadow

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

I tried setting the LANg variable and get the same error (I am
using 7.3.2).

J.

Originally posted by Michael E Mercer
> Hello,
>
> I have been fighting a similar problem as this for two days. Just
> figured out it
> is an encoding problem. I can connect just fine from my account but
> not from the
> root account.
>
> The problem stemmed from the LANG environment variable not being set
> for root and the
> encoding was set to '646'. Where my account the encoding was set to
> ISO8859-1. Once I
> set the environment variable LANG to 'en_US.ISO8859-1', everyone
> was happy.
>
> Give this a try...
>
> later MeM
>
> Joey Mingrone wrote:
>
> > 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

--
Posted via http://dbforums.com