Re: md5 authentication issues with psqlODBC driver for Windows

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Chris Davis <c_b_dvs(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: md5 authentication issues with psqlODBC driver for Windows
Date: 2009-11-26 15:38:16
Message-ID: 4B0EA0E8.30001@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Chris Davis wrote:
> I've been running into an issue where I get an error "password authentication failed" while using the psql ODBC driver for Windows, with the database residing on a Linux machine.
>
> I know my current setup is (relatively) correct since:
> 1) I've previously used a JDBC driver with postgres and md5 authentication, with no problems (with Linux on both client and server)
> 2) In Windows I can look at the ODBC sources and always verify that I can connect to the database
> 3) I'm able to fix the problem by using trust instead of md5 authentication
>
> Basically, I'm using the driver to connect the statistics program SPSS to a database. I can always connect to the database and see the tables, but the problem occurs when I try to make a query. The first time might work and actually return results, but after that, I consistently get the "password authentication failed" error.

Could you send me the Mylog output of the error ?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message rahimeh khodadadi 2009-11-30 07:29:35 Fwd: psql+krb5
Previous Message Hiroshi Inoue 2009-11-26 11:34:16 Re: odbc driver leaks memory when connection failed