From: "Capobianco, Tony" <Tony.Capobianco@bcbsma.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: RE: issues connecting to RDS from psql 9.2 v 14.2
Thread-Topic: issues connecting to RDS from psql 9.2 v 14.2
Thread-Index: AdhaUEIdPGwjGMmxRt2j4twTB2m6bgABjIOAAAUSH8A=
Date: Wed, 27 Apr 2022 19:16:52 +0000
Message-ID: 
 <BLAPR13MB4660B38538B96140CF11EC0A9EFA9@BLAPR13MB4660.namprd13.prod.outlook.com>
References: 
 <BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9@BLAPR13MB4660.namprd13.prod.outlook.com>
 <395140.1651078037@sss.pgh.pa.us>
In-Reply-To: <395140.1651078037@sss.pgh.pa.us>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?44ln+j3rzIbTjxMbYXZZVVZegI2WOHOddPBNAYeH+9O1vp4cpEYEG944FzZu?=
 =?us-ascii?Q?wyHDtopionX2GoTjTivY+Ck7FzXSs/09JgqrDfnSxFkkrqReUjqDizxkQ1of?=
 =?us-ascii?Q?r0eUbu+LHGIogRULjlUEEINyllmMrIUM8WskkdaM9hYequwxTsbxkYtNAdIY?=
 =?us-ascii?Q?ITact6FvJNftRpl8EbnS1TYGZl2RWYHU/6MwIfCnZoBHys4ywD/U+PK92EtP?=
 =?us-ascii?Q?CDIbXYIPUqzHq9whC7JWYFy0LqMqGl3X3Yyxko9h3pT4La0YahBmhDnCQxHV?=
 =?us-ascii?Q?wBmQwFS6nZkO6pXKRNP0LHVTTDm8TgkcM6MqnjSeUClkV/zWyi/+bDKW0Y71?=
 =?us-ascii?Q?/u/jpWffLuHpjagLbeUIN+gk2JD/SfK4c0lvkNULs6K51u3gFtbVu5l5GxTS?=
 =?us-ascii?Q?cGE7pNxyYaw6xzmUmJMzagopBFQXL4Hp2Scm5fEm9ey/5fxqqcJGPuS1sT2x?=
 =?us-ascii?Q?ZINfuojE9X6Jul52nAa5c71cfDfq703Sr1pDgXb+B1jvb3NjulPtpxYEqg30?=
 =?us-ascii?Q?XZOTC41jNgmCuxSR6XsnPzLD6MS8IHxLJOxr9Va3y+l4c7RDmkvmbVxgoAYJ?=
 =?us-ascii?Q?J8YlzS8i1BjwaW5zpeBbRB6L2i2cWcTeN8grJH9YsCAtiGOaHQHqoUEeiSkp?=
 =?us-ascii?Q?t6ZizHW3MKnL10mu9EWXvjkVaw2weoghrOjHxxEB5hoYKs6FQz35SeshXpRU?=
 =?us-ascii?Q?dw9pMJ5BKfqIBAjv7VHfICigqFKVjWB8YKFxDl9tuw3iF7PkFcIiS+09mBGE?=
 =?us-ascii?Q?cLbJvCmHQ0sUWDYdHeTKly5OmTZd7dfAlwpPItqWHmMbtohV8M1Tf2VtLHru?=
 =?us-ascii?Q?f2QK8c/bqYQ0bwi7H6pe6dHZtL9+dQ/4riI8P/ZTT4iuZbUzynlBO7NMXD47?=
 =?us-ascii?Q?HD/pZB/unzGJQW/Q3Qf7h6N6i3TW9xAznQxBeOB5mot6E9pMPaXLoRcD9erf?=
 =?us-ascii?Q?2OpHCPgPSJMAphUk8A7AbCjBeylPlxUvh6gqPb33GseRZDog/FhhXFtmtOkv?=
 =?us-ascii?Q?oT18DLZzWE3PP1Hl1WwTnyZVLwN0LSQiK93YF1QDCCL6Q7VOXIhSPQnZ7M6A?=
 =?us-ascii?Q?MWIDuAPpIKTql9YI+YuHysUPSWvAZf3NbMX6p18i9/eOQMTV+yva4WA/rvGn?=
 =?us-ascii?Q?u6zLtcPVnoMi9hh4yXPbAxWKmea80WrJDH8ylGdokrtfVvelcedMP35TESFd?=
 =?us-ascii?Q?i51DtjqSxodycZV+TLOrgA1N05Y+/IdQCptiMYHsmTjaG+uSW13nzXYCON3X?=
 =?us-ascii?Q?nBZxw1TmtF+azp27mMkca47vTtMEq/4EFyiN+U2TWiAf+DP/xbc5QJS0KVFL?=
 =?us-ascii?Q?z6rqDLlmKeLForh1+x7mR8XGayvsou55iCG065ypddoH3Lf/S6pSBj4bYj4r?=
 =?us-ascii?Q?9T0FSCZpoths8ZFZFpUsoGsyBCXb2wn9ewbhhWNI7rnnmZMDOzMZjjTcBPUj?=
 =?us-ascii?Q?xbIJht5NfOZM0K9jP5OMwfgIpT13rj6du65AxVsL1isDFlI5cjXiWi99GXga?=
 =?us-ascii?Q?gT9VfpflyvhVN0uFARMsNYjsOJ+ozL7pktFNZx8VX192qImJIW+fskUbu5kr?=
 =?us-ascii?Q?K7iFyQQtosxyBUUdqE+uhc1HIzqzj+r6kHXXvilDXfup/e7Ki5qX4mQKvi0B?=
 =?us-ascii?Q?cpUVcQ/fjKNGeZ1JOU/WxcPTNd9SY82Jq++KjFZWWBf3lPf7Q1g89zuRoxPo?=
 =?us-ascii?Q?KXo/XEAvjUV2S0kiC6fhB2NIaqj2S8SSuha1CNmkYn/H2mtln4b1XCr+oLHN?=
 =?us-ascii?Q?pzTK6qfR8w=3D=3D?=
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: BCBSma.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BLAPR13MB4660.namprd13.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 df584658-fa50-45d4-d3f6-08da28827cbb
X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Apr 2022 19:16:52.9577
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 7f6a7d1e-1213-434b-981c-95c72d65f665
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 ljuIhqh8lLbOVnyTQ1Ynqus+Y2Itv/dyLeZRUMY1rmTqzxV+6hs7S8ACDY/NBYoAcaBchN/9YpAfG34AIHKGIQ==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY5PR13MB2933
X-VPM-MSG-ID: 24829260-bd1c-4be9-ad28-c21b2da9fd86
X-VPM-HOST: vmvpm01.z132.zixworks.com
X-VPM-GROUP-ID: bad79ce4-d97e-4595-adad-95e843ddad3b
X-VPM-ENC-REGIME: Plaintext
X-VPM-IS-HYBRID: 0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/BLAPR13MB4660B38538B96140CF11EC0A9EFA9%40BLAPR13MB4660.namprd13.prod.outlook.com>
Precedence: bulk

Ok, that makes sense.  Attempting the below, but receiving this error:

./configure --without-readline --with-includes=3D/usr/lib --with-openssl

checking for CRYPTO_new_ex_data in -lcrypto... no
configure: error: library 'crypto' is required for OpenSSL

[postgres@servername postgresql-14.2]$ ls -lhrt /usr/lib/*crypt*
-rwxr-xr-x 1 root root 547K Feb 28  2017 /usr/lib/libgcrypt.so.11.8.2
lrwxrwxrwx 1 root root   19 Aug 29  2017 /usr/lib/libgcrypt.so.11 -> libgcr=
ypt.so.11.8.2
-rwxr-xr-x 1 root root  38K Sep 14  2021 /usr/lib/libcrypt-2.17.so
lrwxrwxrwx 1 root root   16 Nov 12 07:01 /usr/lib/libcrypt.so.1 -> libcrypt=
-2.17.so
lrwxrwxrwx 1 root root   23 Nov 12 07:01 /usr/lib/libcrypt.so -> ../../lib/=
libcrypt.so.1

Tony=20

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>=20
Sent: Wednesday, April 27, 2022 12:47 PM
To: Capobianco, Tony <Tony.Capobianco@bcbsma.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: issues connecting to RDS from psql 9.2 v 14.2

CAUTION: This email originated from outside of the organization. Do not cli=
ck links or open attachments unless you recognize the sender and know the c=
ontent is safe.


"Capobianco, Tony" <Tony.Capobianco@bcbsma.com> writes:
> Our RHEL 7.9 installation comes with PostgreSQL 9.2 installed which I kno=
w has been desupported.  We installed 14.2 in a non-default location and ob=
serve this unusual behavior:
> [postgres@servername ~]$ psql -h RDS-instance.rds.amazonaws.com -p=20
> 5432 -d dbname -U root Password for user root:
> psql (9.2.24, server 12.8)
> WARNING: psql version 9.2, server version 12.0.
>          Some psql features might not work.
> SSL connection (cipher: cipher text here, bits: 256) Type "help" for=20
> help.

> daldb=3D> \q
> [postgres@ servername ~]$ export=20
> LD_LIBRARY_PATH=3D/u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pg
> sql/lib [postgres@ servername ~]$=20
> /u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pgsql/bin/psql -h=20
> RDS-instance.rds.amazonaws.com -p 5432 -d dbname -U root
> psql: error: connection to server at " RDS-instance.rds.amazonaws.com=20
> " (1.2.3.4), port 5432 failed: FATAL:  no pg_hba.conf entry for=20
> host "1.2.3.4", user "root", database "dbname", SSL off [postgres@=20
> servername ~]$

> Any ideas of why I'm encountering this issue?

Looks like you neglected to build psql with OpenSSL support, and the server=
 is insisting on having an SSL connection.

                        regards, tom lane