From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: passwd / pg_hba.conf |
Date: | 2002-03-04 16:49:42 |
Message-ID: | 20020304164942.H10429@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Mar 02, 2002 at 12:40:54PM -0500, Bruce Momjian wrote:
> Patrick Welche wrote:
> > # password: Authentication is done by matching a password supplied
> > # in clear by the host. If no AUTH_ARGUMENT is used, the
> > # password is compared with the user's entry in the
> > # pg_shadow table.
> >
> > It seems to me that this doesn't work for encrypted passwords stored in
> > pg_shadow? The crypt: entry specifically mentions not storing encrypted
> > passwords.. Just checking here, as it's a windoze box connecting with ODBC
> > that has the problem, all the unix boxen are happy with md5 and encrypted
> > passwords, so there could be many other causes for it to be unhappy..
>
> Only newer 7.2 ODBC drivers have code to handle MD5 passwords, and ODBC
> never handled crypt passwords, so this may be your problem.
That't it - upgrading from odbc 7.01.0007 to 7.01.0009 got the windoze
clients happily using md5 too.
Thanks,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2002-03-04 16:59:24 | Re: descending index |
Previous Message | Stephan Szabo | 2002-03-04 16:26:17 | Re: Which trigger execute which function? |