pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedmd5 auth
2+ messages / 2 participants
[nested] [flat]
* md5 auth
@ 2002-04-04 16:33 Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
2002-04-04 17:09 ` Re: md5 auth Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Kovacs Zoltan @ 2002-04-04 16:33 UTC (permalink / raw)
To: pgsql-sql; +Cc: ltibor@mail.tiszanet.hu
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@pc10.radnoti-szeged.sulinet.hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: md5 auth
2002-04-04 16:33 md5 auth Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
@ 2002-04-04 17:09 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2002-04-04 17:09 UTC (permalink / raw)
To: Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>; +Cc: pgsql-sql; ltibor@mail.tiszanet.hu
Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu> writes:
> However, if I enter the "clear text", unhashed password, I can enter the
> database.
That's the way it's supposed to work. Users shouldn't have to do the
hash calculation by hand, should they?
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-04-04 17:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-04 16:33 md5 auth Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
2002-04-04 17:09 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox