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: | Raw Message | Whole Thread | 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 |