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@sir-mag.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026