From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
---|---|
To: | "Jensen, David E" <djensen8(at)dxc(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Build ODBC Drivers for Solaris with TLS support |
Date: | 2020-10-23 10:13:04 |
Message-ID: | df2b6720-9d83-2aa5-599f-c2fc091ff0cc@iki.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 23/10/2020 02:16, Jensen, David E wrote:
> Hello,
>
> I'm supporting a project that is migrating a database from on-prem
> Oracle to Azure PostgreSQL. There are DB links from one oracle DB to
> the one that is migrating. The on-prem Oracle DB is on Solaris, so
> we have built unixODBC, and pulled the source for the ODBC PostgreSQL
> drivers and built them too.
>
> Using isql to try and connect we received an error about setting SSL
> options because the Azure system is set to require SSL on the
> connections. If I add sslmode = require in the odbc.ini, we get and
> error about using ssl options are invalid when SSL support is not
> compiled in. I see mention the ODBC driver supports SSL, but cannot
> see how to run configure to have it compiled it.
>
> Is there any direction you can provide on this? It would be much
> appreciated.
Hi! The psqlODBC driver uses PostgreSQL's libpq library for connecting
to the server. It sounds like you're using a version of libpq that's not
built with OpenSSL. Are you using a pre-built package for libpq or
building it from sources?
If you're building libpq from PostgreSQL sources, you need to pass the
"configure --with-openssl" flag to PostgreSQL's configure.
- Heikki
From | Date | Subject | |
---|---|---|---|
Next Message | Jensen, David E | 2020-10-23 12:19:53 | RE: Build ODBC Drivers for Solaris with TLS support |
Previous Message | Jensen, David E | 2020-10-22 23:16:54 | Build ODBC Drivers for Solaris with TLS support |