Re: Windows binary install and gssapi support

Grant,

You are correct, the libpq library is not built with the gsslib
library. Several
years back I noticed the gsslib option when doing a review of the options
for libpq and attempted to include the library with some minimal effort but
without success. Since we build the psycopg2 windows binaries with the
compiler version that was used to build the respective Python version, we
also use that compiler version to build the dependent libraries as well.
At the time, linking in the MIT Kerberos library was more involved then
download, compile, and link. Since it has been a few years, it might be
worth revisiting it again.

-jason

On Sat, Apr 14, 2018 at 6:35 PM, Grant McKenzie <grant(dot)r(dot)mckenzie(at)gmail(dot)com>
wrote:

> Hello,
>
> Postgres supports a connection string parameter 'gsslib'. This is
> documented here:
>
> https://www.postgresql.org/docs/current/static/libpq-connect.html
>
> When I install the psycopg2 binary distribution on windows, I see the
> error below.
>
> C:\Users\grant>pip install psycopg2-binary
> Collecting psycopg2-binary
> Downloading psycopg2_binary-2.7.4-cp27-cp27m-win32.whl (859kB)
> 100% |################################| 860kB 882kB/s
> Installing collected packages: psycopg2-binary
> Successfully installed psycopg2-binary-2.7.4
> You are using pip version 9.0.1, however version 10.0.0 is available.
> You should consider upgrading via the 'python -m pip install --upgrade
> pip' command.
>
> C:\Users\grant>python
> Python 2.7.10 (default, May 23 2015, 09:40:32) [MSC v.1500 32 bit (Intel)]
> on win32
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import psycopg2
> >>> psycopg2.connect( 'postgresql://localhost/postgres?gsslib=gssapi' )
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "C:\Python27\lib\site-packages\psycopg2\__init__.py", line 129, in
> connect
> dsn = _ext.make_dsn(dsn, **kwargs)
> File "C:\Python27\lib\site-packages\psycopg2\extensions.py", line 155,
> in make_dsn
> parse_dsn(dsn)
> psycopg2.ProgrammingError: invalid dsn: invalid URI query parameter:
> "gsslib"
>
> C:\Users\grant>python --version
> Python 2.7.10
>
> C:\Users\grant>ver
>
> Microsoft Windows [Version 10.0.16299.371]
>
>
> I am speculating here, but perhaps the libpq library that was used to
> build the package was not built using the --with-gssapi switch described
> here?
>
> https://www.postgresql.org/docs/10/static/install-procedure.html
>
> Thanks
>
>
>