From: | Jim Mercer <jim(at)reptiles(dot)org> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | pg_hba.conf and crypt/password |
Date: | 2001-03-30 22:50:32 |
Message-ID: | 20010330175032.L29550@reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
i seem to recall setting this up before, but now i can't seem to
get passwords working the way i want.
i'm running 7.0.3 on FreeBSD 4.3-RC.
i've set the entry in pg_hba.conf to both "crypt" and "password".
i've used "ALTER USER pgsql WITH PASSWORD 'test';
regardless of "crypt" or "password", psql allows entry using "test".
what i want is for the pg_shadow file to contain encrypted passwords like
/etc/passwd, and for the server to encrypt the plain text password handed
to it and compare with the crypto-gunge in pg_shadow.
is this not what "crypt" is supposed to do?
--
[ Jim Mercer jim(at)pneumonoultramicroscopicsilicovolcanoconiosis(dot)ca ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ aka jim(at)reptiles(dot)org +1 416 410-5633 ]
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2001-03-30 22:52:58 | Re: PL/pgSQL parameter passing bug? |
Previous Message | Ed Loehr | 2001-03-30 22:43:40 | PL/pgSQL parameter passing bug? |