Re: passwd / pg_hba.conf

Поиск
Список
Период
Сортировка
От Patrick Welche
Тема Re: passwd / pg_hba.conf
Дата
Msg-id 20020304164942.H10429@quartz.newn.cam.ac.uk
обсуждение исходный текст
Ответ на Re: passwd / pg_hba.conf  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: [ADMIN] Which trigger execute which function?
Следующее
От: Luciano Miguel Ferreira Rocha
Дата:
Сообщение: Re: Networking support for postgres isn't working.