From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: rcastro@stratio.com
Subject: BUG #16463: Sporadic SSL handshake failures in Windows client
Date: Tue, 26 May 2020 13:18:53 +0000
Message-ID: <16463-81778942ee95cdfc@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16463
Logged by: Ricardo de Castro Garcia
Email address: rcastro@stratio.com
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, rcastro@stratio.com
Subject: Re: BUG #16463: Sporadic SSL handshake failures in Windows client
In-Reply-To: <16463-81778942ee95cdfc@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox