Re: Windows binary install and gssapi support

Thanks Jason.

The build process for windows still seems quite involved:

https://www.postgresql.org/docs/10/static/install-windows-full.html

That said, the predominance of Kerberos authentication in enterprises
these days would make support of this a welcome addition I'm sure.

On 4/14/2018 10:28 PM, Jason Erickson wrote:
> 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 <mailto: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
> <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
> <https://www.postgresql.org/docs/10/static/install-procedure.html>
>
> Thanks
>
>
>