Date: Mon, 27 May 2024 23:19:42 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: expected authentication request from server, but received H
Message-ID: <20240527211942.wmdr2etj445hamz6@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <20240523070649.7j6r2lidqrmhmr3o@hjp.at>
 <524370.1716499394@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="woubfnadofqnp5ja"
Content-Disposition: inline
In-Reply-To: <524370.1716499394@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/20240527211942.wmdr2etj445hamz6%40hjp.at>
Precedence: bulk


--woubfnadofqnp5ja
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2024-05-23 17:23:14 -0400, Tom Lane wrote:
> "Peter J. Holzer" <hjp-pgsql@hjp.at> writes:
> > One of our users reports getting the error message
> > "expected authentication request from server, but received H"
> > when trying to connect to the database.
>=20
> That's very bizarre, and I don't recall any similar reports in the
> recent past.
>=20
> > Server is PostgreSQL 15.7 (Ubuntu 15.7-1.pgdg22.04+1)
> > I haven't been able to find out what client version they are using yet,
> > but I suspect it's quite old.
>=20
> It would definitely be interesting to find out what the client-side
> code is, including the openssl version being used.

They have psqlODBC 9.3 and 13.2 on a 64-bit Windows platform (probably
Windows 10). The problem occurs with both. I tried to replicate it with
psqlODBC 13.0 and couldn't.

OpenSSL is bundled with psqlODBC, AFAICS. For 13.0 that would be 1.1.1.8
(hmm, that doesn't look like an OpenSSL version. Would that be 1.1.1h in
Linux terms?). But the fact that it happens with two very different
versions but I can't replicate it with one in between (and quite close
to one of them) makes it unlikely (IMHO) to be just version related.
There must be something else going on. I've asked them (their IT
department, not the user) to try to disable any anti-virus software.
That's a bit of a reach, but always a possibility if something behaves
weirdly on Windows.

        hp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--woubfnadofqnp5ja
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmZU+OgACgkQ8g5IURL+
KF0c9hAAkBk79TdfF81tOC6l8Vt072lSXtzY2PiFFyQ6M8LcdTsmr6A+sTG+uqZx
Oc4bonuQF2g8LupRXYJl+WvqG85A3KHChHQa1idda/uA4pX3sTkiV1yYq2F4r6xf
bq2LctS5GN1kgNQMTYDim0YIPNWXkuCJjZ/uuyc9NxV6wYzYAzOgiNrH5u+NVc8p
72UOe+wrUD8Z2+iOip4vbejcI/QGirPsWbpDd3T5QAqca5x6ascjTbxakeocg2HD
gAJN0hcmaWflt5E5RcRWacJD6bluT4j7Om2e9da4O2tNtb3rf+GdAkhrp4SBsYW4
ySt7k2Fczav7LhreXE5YQkFbf5A2PDnApMyNS5oS6rU1pyiMTbQrvPDnqv9qcHEI
3yRin/Cvc5nSrtddCiGWY1xU/XbsWiohBMwRJKxRQVjHZYvQIZNXANuxjwMOeWVI
WPkEyuOuC3dlHrMatXeJ2iV/80B56aDmrOGbkwZM4T3YZO3ddin+FqozY/zhZ8jj
5VILkqG9dwJt09q5Ws0gcvlOYqsz84OnR7sPlJjVZSBNbJqyvbQYNHlpZidyOhwj
L2eDwAYvslFJ4PRNqVn1roWusOnWHIKumlZSBLeducQ0HDLT5sbskAx6pvV3KNfr
1h5b/2PX7EvejSmMhgd7qAyrCGwTuA/g3ChPayF2gPfF0A9tmrI=
=wGeo
-----END PGP SIGNATURE-----

--woubfnadofqnp5ja--