| From: | Wei Weng <wweng(at)kencast(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Question on MD5 authentication |
| Date: | 2006-10-12 19:38:18 |
| Message-ID: | 1160681898.28475.8.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-10-12 19:44:16 | Re: bad error message |
| Previous Message | Jonathan Vanasco | 2006-10-12 19:27:08 | bad error message |