Re: [GENERAL] Auth problem in pg_hdba.conf

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: 28 April 2002 00:26
> To: Hiroshi Inoue
> Cc: Uros Gruber; PostgreSQL odbc list
> Subject: Re: [ODBC] [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?

From the user's description, he's using pgAdmin with the 'Use encrypted
passwords when possible' option. If so, pgAdmin will use CREATE/ALTER USER
xxxx WITH ENCRYPTED PASSWORD 'password' syntax.

What I don't remember though (and can't check right now) is whether the
current version shipped with psqlOBDC 07.01.0009 or later (which is required
to use MD5 passwords).

Regards, Dave.