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