pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #16463: Sporadic SSL handshake failures in Windows client 2+ messages / 2 participants [nested] [flat]
* BUG #16463: Sporadic SSL handshake failures in Windows client @ 2020-05-26 13:18 PG Bug reporting form <noreply@postgresql.org> 2020-05-26 13:55 ` Re: BUG #16463: Sporadic SSL handshake failures in Windows client Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2020-05-26 13:18 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: rcastro@stratio.com 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16463: Sporadic SSL handshake failures in Windows client 2020-05-26 13:18 BUG #16463: Sporadic SSL handshake failures in Windows client PG Bug reporting form <noreply@postgresql.org> @ 2020-05-26 13:55 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2020-05-26 13:55 UTC (permalink / raw) To: rcastro@stratio.com; +Cc: pgsql-bugs@lists.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-05-26 13:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-05-26 13:18 BUG #16463: Sporadic SSL handshake failures in Windows client PG Bug reporting form <noreply@postgresql.org> 2020-05-26 13:55 ` Tom Lane <tgl@sss.pgh.pa.us>
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