Re: [GENERAL] Auth problem in pg_hdba.conf

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