Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wKBOr-000hDz-2I for pgsql-odbc@arkaria.postgresql.org; Tue, 05 May 2026 08:45:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wKBOp-00B5Yi-2A for pgsql-odbc@arkaria.postgresql.org; Tue, 05 May 2026 08:45:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wJtdf-007TPo-07 for pgsql-odbc@lists.postgresql.org; Mon, 04 May 2026 13:47:11 +0000 Received: from mail-dy1-x132f.google.com ([2607:f8b0:4864:20::132f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wJtdc-000000009Re-0veE for pgsql-odbc@lists.postgresql.org; Mon, 04 May 2026 13:47:10 +0000 Received: by mail-dy1-x132f.google.com with SMTP id 5a478bee46e88-2c15849aa2cso5380236eec.0 for ; Mon, 04 May 2026 06:47:08 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777902428; cv=none; d=google.com; s=arc-20240605; b=f/XPFB3m0bAxNxN+/h28mJ9ksrpSAY3slFggrL5/wb0yhGi0Cpp0Ft5yx0Byy1abRl OvBHWvqxjA3XwFr9XeyRODMXF8+ZXcd3TuMVq+W2JkkFHp+tZOh9yfjbgsfG95Kh95tk avOsJVYigeFS9yH9+V/ye2xE3cN05sbXRjJ8k0oWa9TsPf+PGpzE2YxaJ9Yl4jJwE4rv bCEEDfQRGIJq+PvzaAirc8iw7Qq04BrqjUghzhLEa5enzyEzPONMreLlNr/i2aMqBiQa tz7255H43iZwEpmLDmpeCljRpQYWS/qvGC6rnHgeyh8UeU7opKui2PpvMgASgyS58UXZ 1YBg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=J+9YWMuPZqb+5WMT9xl0yf36zj7i+67Jam6e3hB62yU=; fh=GRQvQ40HLSdE/RraNtcCofDldDX/UuCwDt1OTJR1At4=; b=Na/AN47hKjrHTCTYp+JwQOZZ191ZHxhhFSWJZe4AsaHhBNvhuwC4xWBMP94mg4POeU ntkFZ9g+kmwkts1X8Bc9D+Wlfj6H7wkoy28PHNGq7KkHIc9k4uuiGGPYp1iQTBdbMqPp nruu0phAxLZ5WRcITwBEFNNZ3fgwUvqEehJYSKP+ag2+gBHVPA8LuUu1ZEcJpP5K0kSI 5FDhFP+3q1Hh3CfT/fyTanuTkIWfMp+aq6GHkVI0PObfBmxUagTkDm/7WmAStblUWD3+ 655GECgy+UkuDUQVzp47rBW9wkpo0bE5A+UMsKOHWwMdldkUq4C7jKEaqpPs43oj/1Su Pgkg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777902428; x=1778507228; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=J+9YWMuPZqb+5WMT9xl0yf36zj7i+67Jam6e3hB62yU=; b=YZ6BGpLm31RwArbW9K5XyTYoXpnJhMMaQHCLueKr6Vqe6V8qE71yN5HBbIvQih08rl s7aMtmalrGkp9VQgo0OWWOuIbtOzKm5PbxFnzDWkbX0G8E8hCuFWkPCMyhsjRuAf15Aj XKOQQ3ZvqADSfNSKIpQtnMAqk1BrgY3KEM+V1lxxsw5i/Fs4xIU113aLlj2MfmuiZgJZ 5jDc9kMDAz45dhrcXEJjVBu8FkhtVw9ELDLma9SEcGrWB6rZKxpH7o5aNUqjuVklOGgM 6y6c0DufavcofQOhNJjV0nsG9s4ibmuqtxvq93KRNVosCOr8lrS+d54rfbul88Kgq5lQ CHHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777902428; x=1778507228; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=J+9YWMuPZqb+5WMT9xl0yf36zj7i+67Jam6e3hB62yU=; b=p9uaJHS/zhpl9wUDjVPiLnTqCpKMhrqu31f75oX8oka5jd85vYbbTSgn4QPf8R+Adu oaJhvwOnvU1S5KmX6HQYZCQ3MNbntoDU5Z3jsCa1p/S1KW9hpbObMfrWgeR2eNsR3Xg2 607YGVXFtC0LQ7aeWJA1W5iGbxV3f8mICtyc4b+mp6Cg5Vp3LIqoT46d7m8r4OjNuQ5Q oiE9G8EoIJwpGnbnJuT19qc+c5DzBT/E2YAxKhtSM74lfiHM0wpxo2bdY2l94/571rge ywOdJaAcnAxGLQ32Wf9Qf8eL33Vjp5dRLsMu8loiKuME6aHMbO4nzTR53Cx/d4MV5Wib fr0g== X-Forwarded-Encrypted: i=1; AFNElJ9SVKC3XcoV3TkXWFwzki1BvW/cQyry7Fric7D2rAtpWMIsWviHbhCIRnFwekYFZ7oEwB9EanP3rXOV@lists.postgresql.org X-Gm-Message-State: AOJu0YzDamlFO4sAAPZIbVL7hBlKpx2Uq1jIDXC9NzyH7nTmW6xUdnZQ Dj19Mj/SyylyosOeun0a82Qpcnzw2S1x1rqhCruIFkWcWjBBsd7Bht1Lzki9A59q/DENXZT+ci9 9YWgD1NyNUR6xuBcpSRNe5Coq1icswEk= X-Gm-Gg: AeBDieurGBhHMivM1ZV1Uk3D3vVm+Yag/luOyruMaSOvyt0tzybr/zd3rtl3BjIHoSO C5okFNSK67apg4uw6WnDeNNQSRJxm9FyAGzuzUj4vN+YOgNCbYrNT+ozXcqmKOs9c6QlEgB1gJA S6KIiZBHsWRvlrkvbiUuHjDvRVp3zF0Wf/ZEp7cKQxlsvuTrcxxfJ1I0DmmBmZ1Wr3vWZFcgf0k 6kZHPm75g+0X3AhyczSAsEb3nF65LzZWEGdhJD60pbsnNY58aKW9QcORPS7JGVGW3tXylL3ilb1 ogkixJWjxnfPcXg+YR8= X-Received: by 2002:a05:7300:1905:b0:2d1:d434:d022 with SMTP id 5a478bee46e88-2efb4f2c2bfmr4405405eec.0.1777902427592; Mon, 04 May 2026 06:47:07 -0700 (PDT) MIME-Version: 1.0 From: arun nair Date: Mon, 4 May 2026 19:16:28 +0530 X-Gm-Features: AVHnY4KtsOAHZ3asA1xpuQvpH1loE1O2LOGNLKcAjaZ5KU0Jtby9nvnBh9v06iU Message-ID: Subject: ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2) To: pgsql-general@lists.postgresql.org, pgsql-odbc@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000a45bbc0650fe2ae0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a45bbc0650fe2ae0 Content-Type: text/plain; charset="UTF-8" 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 --000000000000a45bbc0650fe2ae0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
= Hi Team,
I am tryin= g to configure PostgreSQL ODBC connectivity from an Oracle Solaris server.<= /div>
Since Solari= s does not provide prebuilt PostgreSQL ODBC packages like RHEL-based system= s, the official PostgreSQL ODBC source code was downloaded from the Postgre= SQL repository and compile on the server.

Environment:
- OS: Solaris
- GCP CloudSQL PostgreSQL Server: Version 18
- ODBC Driver: p= sqlODBC 16
-= PostgreSQL Client (libpq): 18
- OpenSSL: 1.0.2zj

Issue:
Connection fails with error:
"pg_hba.conf rejects connection ... no = encryption"

Ob= servation:
-= PostgreSQL server enforces SSL (TLS 1.2+)
- Client build does not support SSL due to O= penSSL version
- PostgreSQL configure fails when enabling SSL:
=C2=A0 "OpenSSL version >=3D= 1.1.1 is required"

Question:
Is there any supported way to enable SSL connectivity on Solaris with O= penSSL 1.0.2, or is upgrading OpenSSL the only option?

Thanks,
Arun
--000000000000a45bbc0650fe2ae0--