From: Tom Lane <tgl@sss.pgh.pa.us>
To: rcastro@stratio.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16463: Sporadic SSL handshake failures in Windows client
Date: Tue, 26 May 2020 09:55:42 -0400
Message-ID: <15835.1590501342@sss.pgh.pa.us> (raw)
In-Reply-To: <16463-81778942ee95cdfc@postgresql.org>
References: <16463-81778942ee95cdfc@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> 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.
Weird ... but I'm afraid you have come to the wrong place for help.
This mailing list deals with PG server bugs, and the server seems to
be the one component that is clearly not at fault in your case.
It could be PGBouncer's fault, so I'd suggest inquiring through their
support contact. (I do not know offhand what that is, but it's not
here.) But TBH, if reinstalling the identical certificates on the
client machine makes the problem go away, it's hard to conclude that
it's not a client-side bug.
regards, tom lane
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: tgl@sss.pgh.pa.us, rcastro@stratio.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16463: Sporadic SSL handshake failures in Windows client
In-Reply-To: <15835.1590501342@sss.pgh.pa.us>
* 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