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
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 |