GSSAPI Authentication Problem

From: John Slattery <johntslattery(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: GSSAPI Authentication Problem
Date: 2012-08-03 12:31:41
Message-ID: CA+hybRXOLR4JHCG=PU4WkTPJkShEne-gBXuaXE604NAeQ78h0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I would like to report what seems like a problem with the driver. It
doesn't seem possible to override the default user name for
authentication by GSSAPI. I'm using a map in pg_ident.conf since my
Active Directory user name isn't the same as my Postgresql user name.
pgAdmin III and psql allow for this, the former by setting Username in
the GUI to my Postgresql user name and the latter by specifying the -U
option. I tried setting UID in the connection string I am using to my
Postgresql user name but that caused the driver to return the
following exception:

Run-time error '-2147217843 (800040e4d)':
Service negotiation failed;
The specified target is unknown or unreachable in
DoKerberosEtcProcessAuthentication:PerformKerberosEtcClientHandSh

The connection string that produces this exception is:

DRIVER={PostgreSQL
ANSI};DATABASE=db;SERVER=postgresql.my-company.org
;PORT=5432;UID=john;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=0;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;GssAuthUseGSS=0;XaOpt=1

I'm using it in a Visual Basic 6 project.

The version of the driver is 9.1.1.0. The database version is 8.4 from
Debian 6. Please find mylog_408.log attached.

Thank you for taking a look at this.

John

Attachment Content-Type Size
mylog_408.log application/octet-stream 4.6 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Stephen Frost 2012-08-03 13:51:46 Re: GSSAPI Authentication Problem
Previous Message Josef Springer 2012-08-03 07:18:21 Problem with ODBC-Driver on a Windows 7/x 64