Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 99B419FB4AA for ; Thu, 12 Jul 2007 12:53:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 82742-03 for ; Thu, 12 Jul 2007 12:52:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp1.versatel.nl (smtp1.versatel.nl [62.58.50.88]) by postgresql.org (Postfix) with ESMTP id A0F0E9FB3CB for ; Thu, 12 Jul 2007 12:52:58 -0300 (ADT) Received: (qmail 5274 invoked by uid 0); 12 Jul 2007 15:54:08 -0000 Received: from ip143-14-212-87.adsl2.versatel.nl (HELO mail.vermeer.tv) ([87.212.14.143]) (envelope-sender ) by smtp1.versatel.nl (qmail-ldap-1.03) with SMTP for < >; 12 Jul 2007 15:54:08 -0000 Received: from [192.168.1.51] (i-Optics-4.starters.tudelft.nl [192.87.167.62]) by mail.vermeer.tv (Postfix) with ESMTP id 0CD565ECB for ; Thu, 12 Jul 2007 17:52:53 +0200 (CEST) Subject: libpq: Specify pass phrase for SSL key From: Koen Vermeer To: pgsql-interfaces@postgresql.org Content-Type: text/plain Date: Thu, 12 Jul 2007 17:52:50 +0200 Message-Id: <1184255570.5451.13.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.10.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/3 X-Sequence-Number: 6587 Hi, Apologies for posting this to both pgsql-interfaces and pgsql-general, but I'm unable to decide which one is more appropriate. I am using libpq to set up an SSL connection to a PostgreSQL server. The client key is protected by a pass phrase, so when I issue a PQconnectdb(), I get a prompt stating: Enter PEM pass phrase: Instead, I would like to give the user a nice message box, asking for his/her password. So, how do I 'inject' the right SSL password into the connection sequence? Thanks for any help! Koen