Обсуждение: 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.gruber@sir-mag.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@sir-mag.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@postgresql.org)
>

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

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

Just a confirmation.
Did you use the original password not the above md5053b5de... ?

regards,
Hiroshi Inoue

Hiroshi Inoue 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.
>
> Just a confirmation.
> Did you use the original password not the above md5053b5de... ?

Also, is the user using CREATE/ALTER USER to set the password rather
than updating pg_shadow. If they are updating pg_shadow, I assume they
are prepending 'md5' to the string.

Also, does md5 work from psql?

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