Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XJlz9-0002Ky-W2 for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Aug 2014 16:10:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XJlz9-00029x-G8 for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Aug 2014 16:10:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XJlz8-000294-0e for pgsql-hackers@postgresql.org; Tue, 19 Aug 2014 16:10:10 +0000 Received: from smtprelay0165.b.hostedemail.com ([64.98.42.165] helo=smtprelay.b.hostedemail.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XJlz3-0005VF-0g for pgsql-hackers@postgresql.org; Tue, 19 Aug 2014 16:10:08 +0000 Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay04.b.hostedemail.com (Postfix) with ESMTP id 343867B87F; Tue, 19 Aug 2014 16:10:03 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50, 0, 0, , d41d8cd98f00b204, alvherre@alvh.no-ip.org, :::::, RULES_HIT:41:355:379:599:800:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1541:1593:1594:1595:1596:1711:1730:1747:1777:1792:2194:2199:2393:2525:2560:2563:2682:2685:2828:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3353:3865:3866:3867:3868:3870:3872:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4605:4659:5007:6120:6261:7875:7901:9025:9121:10004:10400:10848:11232:11256:11257:11658:11914:12294:12296:12517:12519:13069:13311:13357:13894:13895:21080, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:0:0 X-HE-Tag: game21_57a9ef38e4d23 X-Filterd-Recvd-Size: 2402 Received: from eldon.alvh.no-ip.org (pc-65-79-161-190.cm.vtr.net [190.161.79.65]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf04.b.hostedemail.com (Postfix) with ESMTPA; Tue, 19 Aug 2014 16:10:02 +0000 (UTC) Received: by eldon.alvh.no-ip.org (Postfix, from userid 1000) id 29E7B1FCB; Tue, 19 Aug 2014 12:10:01 -0400 (CLT) Date: Tue, 19 Aug 2014 12:10:01 -0400 From: Alvaro Herrera To: Stephen Frost Cc: Heikki Linnakangas , PostgreSQL-development Subject: Re: PQgetssl() and alternative SSL implementations Message-ID: <20140819161000.GF6817@eldon.alvh.no-ip.org> References: <53F1E989.8020609@vmware.com> <20140819144841.GA16422@tamriel.snowman.net> <53F36B6E.6040105@vmware.com> <20140819154436.GD16422@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20140819154436.GD16422@tamriel.snowman.net> User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Stephen Frost wrote: > * Heikki Linnakangas (hlinnakangas@vmware.com) wrote: > > > Indeed, the ODBC driver only uses libpq for authentication, then > > calls PQgetssl(), and takes over the whole show calling SSL_read() > > and SSL_write() itself. Ideally, we'd modify psqlodbc to stop doing > > that, but that's not an easy job. In the short-term, I think we need > > to export pqsecure_read() and pqsecure_write() functions in libpq, > > so that the ODBC driver can use those instead of SSL_read() and > > SSL_write(). > > Yeah, that's what I remembered. There was an attempt to make that > change at one point, but it was reverted due to the lack of batching > ability in libpq (without resorting to cursors, as I recall...), > requiring double the memory usage. Still, if pqsecure_read and > pqsecure_write are sufficient to make the ODBC driver work, that's good > news. I had been worried it did other things with the OpenSSL struct > beyond just using those. Um, libpq has recently gained the ability to return result fragments, right? Those didn't exist when libpq-ification of odbc was attempted, as I recall -- perhaps it's possible now. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers