Re: Auth problem in pg_hdba.conf

Hi,

I didn't install any odbc, because on pgadmin page says that
i don't needed because its in operating system. I use WinXPa
and it also write at begining that there is version 7.1.9.

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

Friday, April 26, 2002, 4:29:28 AM, you wrote:

BM> Interesting. Does PGAdminII use ODBC that comes with 7.2? That is the
BM> only one that can do md5 passwords.

BM> Other than that, I am not sure what else to test. I know ODBC 7.2 users
BM> have used md5 and it works for them.

BM> ---------------------------------------------------------------------------

BM> Uros Gruber wrote:
>> 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
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/users-lounge/docs/faq.html
>>