Обсуждение: ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2)
Hi Team,
I am trying to configure PostgreSQL ODBC connectivity from an Oracle Solaris server.
Since Solaris does not provide prebuilt PostgreSQL ODBC packages like RHEL-based systems, the official PostgreSQL ODBC source code was downloaded from the PostgreSQL repository and compile on the server.
Environment:
- OS: Solaris
- GCP CloudSQL PostgreSQL Server: Version 18
- ODBC Driver: psqlODBC 16
- PostgreSQL Client (libpq): 18
- OpenSSL: 1.0.2zj
Issue:
Connection fails with error:
"pg_hba.conf rejects connection ... no encryption"
Observation:
- PostgreSQL server enforces SSL (TLS 1.2+)
- Client build does not support SSL due to OpenSSL version
- PostgreSQL configure fails when enabling SSL:
"OpenSSL version >= 1.1.1 is required"
Question:
Is there any supported way to enable SSL connectivity on Solaris with OpenSSL 1.0.2, or is upgrading OpenSSL the only option?
Thanks,
Arun
Re: ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2)
От
Daniel Gustafsson
Дата:
> On 4 May 2026, at 15:46, arun nair <arun18.nair@gmail.com> wrote: > Is there any supported way to enable SSL connectivity on Solaris with OpenSSL 1.0.2, or is upgrading OpenSSL the only option? PostgreSQL 18 requires OpenSSL 1.1.1, there is no possibility to use 1.0.2. -- Daniel Gustafsson
Re: ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2)
От
Daniel Gustafsson
Дата:
> On 4 May 2026, at 15:46, arun nair <arun18.nair@gmail.com> wrote: > Is there any supported way to enable SSL connectivity on Solaris with OpenSSL 1.0.2, or is upgrading OpenSSL the only option? PostgreSQL 18 requires OpenSSL 1.1.1, there is no possibility to use 1.0.2. -- Daniel Gustafsson
On Mon, May 04, 2026 at 07:16:28PM +0530, arun nair wrote: > Hi Team, > > I am trying to configure PostgreSQL ODBC connectivity from an Oracle > Solaris server. > Since Solaris does not provide prebuilt PostgreSQL ODBC packages like > RHEL-based systems, the official PostgreSQL ODBC source code was downloaded > from the PostgreSQL repository and compile on the server. > ... > Question: > Is there any supported way to enable SSL connectivity on Solaris with > OpenSSL 1.0.2, or is upgrading OpenSSL the only option? > > Thanks, > Arun Hi Arun, Could you use a statically linked program like stunnel to provide the higher SSL version support. You would connect to it locally. Regards, Ken
On Mon, May 04, 2026 at 07:16:28PM +0530, arun nair wrote: > Hi Team, > > I am trying to configure PostgreSQL ODBC connectivity from an Oracle > Solaris server. > Since Solaris does not provide prebuilt PostgreSQL ODBC packages like > RHEL-based systems, the official PostgreSQL ODBC source code was downloaded > from the PostgreSQL repository and compile on the server. > ... > Question: > Is there any supported way to enable SSL connectivity on Solaris with > OpenSSL 1.0.2, or is upgrading OpenSSL the only option? > > Thanks, > Arun Hi Arun, Could you use a statically linked program like stunnel to provide the higher SSL version support. You would connect to it locally. Regards, Ken