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

Re: md5 authentication issues with psqlODBC driver for Windows

From: Chris Davis <c_b_dvs(at)yahoo(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: md5 authentication issues with psqlODBC driver for Windows
Date: 2009-11-30 15:19:48
Message-ID: (view raw or flat)
Lists: pgsql-odbc
The first section is the output from SPSS which is trying to access the database.  The next three entries are from the log files.



  /SQL='SELECT fractioninternalmass  FROM public.rerunalcmemorysize50  WHERE (tick = 1) LIMIT 10'

>Warning.  Command name: GET DATA
>SQLDriverConnect failed :FATAL: password authentication failed for user "dbuser"

>Error # 105.  Command name: EXECUTE
>This command is not valid before a working file has been defined.
>This command not executed.

[860-0.031]enter CC_Destructor, self=00A83AC0
[860-0.047]in CC_Cleanup, self=00A83AC0
[860-0.047]after CC_abort
[860-0.047]after SOCK destructor
[860-0.047]exit CC_Cleanup
[860-0.047]after CC_Cleanup
[860-0.047]after free statement holders
[860-0.047]exit CC_Destructor
[860-0.047]in EN_Destructor, self=00A82138
[860-0.047]clearing conns count=128
[860-0.047]exit EN_Destructor: rv = 1

[1620-0.000]globals.extra_systable_prefixes = 'dd_;'
[1620-0.000]exe name=spss plaformId=2
[1620-0.000][[SQLAllocHandle]][1620-0.000]**** in PGAPI_AllocEnv ** 
[1620-0.016]** exit PGAPI_AllocEnv: phenv = 28A23CB0 **
[1620-0.016][[SQLSetEnvAttr]] att=200,2
[1620-0.016][[SQLAllocHandle]][1620-0.016]PGAPI_AllocConnect: entering...
[1620-0.016]**** PGAPI_AllocConnect: henv = 28A23CB0, conn = 28A23CE0
[1620-0.016]EN_add_connection: self = 28A23CB0, conn = 28A23CE0
[1620-0.016]       added at 0, conn->henv = 28A23CB0, conns[0]->henv = 28A23CB0
[1620-0.016][SQLGetInfo(30)][1620-0.031]PGAPI_GetInfo: entering...fInfoType=77
[1620-0.031]PGAPI_GetInfo: p='03.50', len=0, value=0, cbMax=12
[1620-0.031][SQLDriverConnect][1620-0.031]PGAPI_DriverConnect: entering...
[1620-0.031]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='DSN=PostgreSQL30;'
[1620-0.031]our_connect_string = 'DSN=PostgreSQL30;'
[1620-0.047]attribute = 'DSN', value = 'PostgreSQL30'
[1620-0.047]copyAttributes: DSN='PostgreSQL30',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1620-0.047]getDSNinfo: DSN=PostgreSQL30 overwrite=0
[1620-0.047]force_abbrev=0 bde=0 cvt_null_date=0
[1620-0.047]globals.extra_systable_prefixes = 'dd_;'
[1620-0.062]our_connect_string = 'DSN=PostgreSQL30;'
[1620-0.062]attribute = 'DSN', value = 'PostgreSQL30'
[1620-0.062]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;

[0.031]conn=28A23CE0, PGAPI_DriverConnect( in)='DSN=PostgreSQL30;', fDriverCompletion=0
[0.047]DSN info: DSN='PostgreSQL30',server='',port='5432',dbase='my_database',user='dbuser',passwd='xxxxx'
[0.062]          onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'
[0.062]          conn_settings='', conn_encoding='(null)'
[0.062]          translation_dll='',translation_option=''

----- Original Message ----
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
Sent: Thu, November 26, 2009 4:38:16 PM
Subject: Re: [ODBC] md5 authentication issues with psqlODBC driver for Windows

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 ?

Hiroshi Inoue

-- Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:


In response to

pgsql-odbc by date

Next:From: Robert HaasDate: 2009-12-01 15:22:03
Subject: Re: [HACKERS] Fwd: psql+krb5
Previous:From: noreplyDate: 2009-11-30 14:58:37
Subject: [ psqlodbc-Bugs-1010735 ] Error on method Fields using client side recordset

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