pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
md5 auth
2+ messages / 2 participants
[nested] [flat]

* md5 auth
@ 2002-04-04 16:33  Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
  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 17:09  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
  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