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

Re: Can't create DSN using SSPI authentication WinXP toWinXP

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Roger Quincy" <Roger(dot)Quincy(at)twdb(dot)state(dot)tx(dot)us>,"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Can't create DSN using SSPI authentication WinXP toWinXP
Date: 2008-04-30 14:44:35
Message-ID: 006c01c8aad0$b5c18fe0$0b01a8c0@yourc3ftrhkaod (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi.

Ahh, Ok.
In the first, since libpq.dll of psqlODBC(08.03.0100) are 8.2 bases, Therefore, SSPI is not
supported. However, psqlODBC had a peculiar SSPI module in a trial way. Then, I have the
result of only the SSL use of that. They are not many patterns though regrettable...sorry.
Probably, you are using PG Version 8.3. Then, It seems that it still has many problems.
As a possibility, using libpq.dll of 8.3 bases may have a good result. or, DEBUG of the SSPI
module of psqlODBC is required. However, much time is required....

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Roger Quincy" <Roger(dot)Quincy(at)twdb(dot)state(dot)tx(dot)us>


No success.

I have been using 08.03.0100.

I deleted the libpq.dll like you say and then I get the following setting up the ODBC:

If I choose "Allow" in the SSL dialog, I get the error message "Unknown authorization type"
If I choose "Require" in the dialog,  I get the error message "Could not construct a socket to the 
server"

Is there something I need to do on the server side?
I tried putting SSL=On in the postgresql.conf file on the server but the service would not restart 
after I did this.
In the pg_hba.conf file, I have been using "host   all     all      0.0.0.0     0.0.0.0    sspi"

Thanks,
Roger

Roger M. Quincy, PG
Hydrologist
Texas Water Development Board
Ground Water Technical Assistance Section
phone: 512-936-0833
email: rquincy(at)txwin(dot)net
web: http://www.twdb.state.tx.us/GwRD/waterwell/well_info.asp

>>> "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> 4/29/2008 5:22 PM >>>
Hi.

Please use the installer package(08.03.0100).
Then, remove libpq.dll there. and use set SSL select of dialog.

Regards,
Hiroshi Saito




In response to

Responses

pgsql-odbc by date

Next:From: Roger QuincyDate: 2008-04-30 16:12:12
Subject: Re: Can't create DSN using SSPI authentication WinXPtoWinXP
Previous:From: Roger QuincyDate: 2008-04-30 13:37:12
Subject: Re: Can't create DSN using SSPI authentication WinXP toWinXP

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