Re: Auth problem in pg_hdba.conf

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

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

---------------------------------------------------------------------------

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
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026