Re: [GENERAL] Auth problem in pg_hdba.conf

Can some ODBC person comment on this? He says md5 authentication isn't
working in pgadmin. Thanks.

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

Uros Gruber wrote:
> 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
> >>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
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