Collected from the PG bugs email list.
|OS||Client: Windows Server 2012 R2 Server: Centos7|
|Reported by||Ricardo de Castro Garcia|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16463 Logged by: Ricardo de Castro Garcia Email address: (redacted) PostgreSQL version: 9.5.10 Operating system: Client: Windows Server 2012 R2 Server: Centos7 Description: Hi, we are experiencing an strange issue connecting to a PostgresXL through an OLEDB connection. After reviewing all the modules and configurations, we haven't found any clue on what is happening. We are connecting to a Postgres-XL server from a SQL Server Integration Services (SSIS, from now) using an OLEDB driver solution developed by Intellisoft. The PostgresXL server is deployed in a Centos 7 machine with a PGBouncer pool. Monthly, we are facing an issue that consists in connection failures between SSIS and PGBouncer. The pooler is showing the following error: ssl3_get_client_certificate:peer did not return a certificate PGBouncer is rejecting the connection, so PostgresXL server is never reached. In order to resolve this issue, we have to reinstall the PostgresXL certificates in the Windows Server. After that, the connection can be reestablished without any server interventions. We understand that PostgresXL is barely involved in the issue, however we've checked all possible causes (server GPOs, certificate chain issues, driver troubles, operative system certificate management...) and exhausted all the possibilities. This is why we sent you this mail. ¿is there any known issue that can match with the problem that we are facing? Software versions - Client OS: Windows Server 2012 R2 - Client app: SQL Server Integration Services 2016 - Client driver: Intellisoft OLEDB Server Edition v1.4 - Server OS: Centos 7 - Server pool: PGBouncer: 1.9.0 - Server Postgres: PostgresXL 9.5r1.6
|2020-05-26 13:18:53+00||PG Bug reporting form||BUG #16463: Sporadic SSL handshake failures in Windows client|
|2020-05-26 13:55:42+00||Tom Lane||Re: BUG #16463: Sporadic SSL handshake failures in Windows client|