From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Jim Mercer <jim(at)reptiles(dot)org> |
Cc: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: pg_hba.conf and crypt/password |
Date: | 2001-03-31 08:31:36 |
Message-ID: | Pine.LNX.4.30.0103311030430.1120-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jim Mercer writes:
> 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".
This is correct.
> 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.
This is not possible.
> is this not what "crypt" is supposed to do?
Crypt encrypts the password on the wire, not in the storage.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Aras | 2001-03-31 14:26:26 | Some install questions PGDATA and postgresql init script |
Previous Message | Oliver Elphick | 2001-03-31 07:59:15 | Re: pg_hba.conf and crypt/password |