Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-15344

Mac: QtWebkit SSL connection in conjunction to an postgres SSL connection destroys postgres connection [Regression]

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • P2: Important
    • None
    • 4.7.0, 4.7.1
    • Network: SSL
    • None
    • Mac OS X
    • macOS

    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).

      Attachments

        1. Patch_revert.diff
          15 kB
          Martin Petersson
        2. postgres_ssl_test.tar.gz
          13 kB
          Martin Petersson
        3. qt-mac_openssl_revert.patch
          10 kB
          Jason Dolan
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Unassigned Unassigned
            xcm Martin Petersson (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes