DbLink connection with SSPI authentication fails

From: Florent Mazzone <ftmazzone(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DbLink connection with SSPI authentication fails
Date: 2013-01-04 10:53:10
Message-ID: CAMaHkGC7H28XvX7KrCcqhLN6w+WhJrEiYXxP3g5z0ym9YQDOvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have installed v9.2 on Windows XP and configured SSPI authentication for
a Windows user "Administrateur" in pg_hba.conf
Using psql or Pgadmin, authentication with the user "Administrateur" works
without problem.

However I couldn't create a connection using DbLink and the Windows user, I
tried the following queries but got always the same error.

Queries:

SELECT dblink_connect('host=localhost dbname=PortefeuilleValeurs
user=Administrateur')
SELECT dblink_connect('host=localhost dbname=PortefeuilleValeurs
user=Administrateur password=')
SELECT dblink_connect_u('host=localhost dbname=BdTest user=Administrateur')
SELECT dblink_connect_u('host=localhost dbname=BdTest user=Administrateur
password=')

Error Message:
ERREUR: could not establish connection
DETAIL: FATAL: authentification SSPI échouée pour l'utilisateur «
Administrateur »

********** Erreur **********
ERREUR: could not establish connection
État SQL :08001

Remark : Using "postgres" user, DbLink works.

Could anyone tell me how to configure SSPI authentication using DbLink ?

Thanks a lot !

--
Florent Mazzone

Browse pgsql-general by date

  From Date Subject
Next Message Amit Kapila 2013-01-04 14:26:15 Re: [GENERAL] Unable to reload postgresql.conf without restarting
Previous Message Patrick Krecker 2013-01-04 04:18:00 Re: Curious unnest behavior