Re: Question on MD5 authentication

On Thu, 2006-10-12 at 15:38 -0400, Wei Weng wrote:
> I am trying to connect to machine A (192.168.1.155) from a different
> machine B (192.168.1.180), with password transmitted as a MD5 string.
>
>
> I have the following lines in my pg_hba.conf file.
>
> host all all 192.168.1.180 255.255.255.1 md5
>
> I created a database user "test_user":
>
> create user test_user with password 'test_passwd';
>
> In A's database, I have
>
> select usename, passwd from pg_shadow;
>
> usename | passwd
> -----------+-------------------------------------
> postgres |
> pgbench |
> test_user | md5c573460a3b356e4610bfae406e1d8a9f
>
>
> Then I try to connect to A from B with the following:
>
> psql -h 192.168.1.155 -U test_user template1
> Password for user test_user: (I typed test_passwd)
> psql: FATAL: password authentication failed for user "test_user"

D'oh, accidentally sent this email out without properly finishing it.

So my question is, how can I connect to A from B with a proper MD5-ed
authentication?

Thanks!

Wei