Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group