| From: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | ltibor(at)mail(dot)tiszanet(dot)hu |
| Subject: | md5 auth |
| Date: | 2002-04-04 16:33:00 |
| Message-ID: | Pine.LNX.4.21.0204041823460.15277-100000@pc10.radnoti-szeged.sulinet.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I've just downloaded 7.2.1 and I'm trying to use MD5 authentication. If I
understand clearly,
1) pg_hba.conf should contain 2 rows with
local all md5
host all 127.0.0.1 255.255.255.255 md5
2) I should restart my postmaster with "kill -HUP _pidno_", OK, I did it,
3) I should login now with an MD5 password:
$ psql -u template1
User name: postgres
Password: *******************************
Here I entered the MD5 hashed password. I got
psql: FATAL 1: Password authentication failed for user "postgres"
However, if I enter the "clear text", unhashed password, I can enter the
database.
What did I do wrong? TIA, Zoltan
Kov\'acs, Zolt\'an
kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2002-04-04 16:41:22 | Re: Date |
| Previous Message | Jan Wieck | 2002-04-04 15:05:47 | Re: Update in trigger |