Auth problem in pg_hdba.conf

From: Uros Gruber <uros(at)sir-mag(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Auth problem in pg_hdba.conf
Date: 2002-04-25 23:21:57
Message-ID: 121203198754.20020426012157@sir-mag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I wan't to use md5 passwords so i set in pg_hba.conf

host all 0.0.0.0 0.0.0.0 md5

Then i add some users with PGAdminII and when i check in
pg_shadow there were md5 hashes like this

md5053b5de16e........................

When i try to connect with that user it failed with error
wrong password.

I have enableb in pgadmin use encrypted pass when possible.
I also try to connect from console and i have the same error.

The i write in pg_shadow plain text passwords and now it
works.

I wan't to know why md5 does not work or what i did wrong.

Is there any option to tell pgsql to use md5

i use postgresql 7.2

--
tia,
Uros mailto:uros(at)sir-mag(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message robert sanford 2002-04-25 23:56:53 Re: odd psql behaviour on OSX
Previous Message Steve Atkins 2002-04-25 23:04:19 Re: odd psql behaviour on OSX