Re: Build ODBC Drivers for Solaris with TLS support

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