Details
-
Bug
-
Resolution: Won't Do
-
P2: Important
-
None
-
4.7.0, 4.7.1
-
None
-
Mac OS X
Description
Using QtWebkit to view an encrypted page (like https://www.google.com) while executing queries on an encrypted postgres connection can destroy that postgres connection.
My specs:
Mac OSX 10.6.4 (also confirmed on 10.5.8)
Pre-built package of Qt (using qt-mac-commercial-4.7.1.dmg)
– Have also confirmed on Pre-built 4.7.0 AND compiled-from-source 4.7.0
– Does NOT effect 4.6.3
postgres compiled on my system with this configure line:
./configure --prefix=/usr/local --with-openssl
Attached is a use-case of this issue. The use-case essentially does this:
1. Opens a secure (SSL) connection to a database
2. Creates a temporary table with some data in it
3. Loads an SSL encrypted webpage (https://www.google.com)
4. Does a select on the temporary table
---This select FAILS with error "server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request"
Findings:
– If I change the webpage to be a non-encrypted webpage like http://www.google.com everything works fine.
– If I reduced that amount of rows in the table (this making the SELECT query run much quicker), everything works fine
Use-case requirements:
– Postgres compiled with ssl support (built postgres with "./configure --with-openssl")
– Database server testing against needs SSL enabled in postgresql.conf (server will need a restart prior to the changes taking effect.
– Database server CAN NOT be running on the same machine as the client application (application works as expected in this situation).