Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AA99B64FD78 for ; Wed, 31 Dec 2008 17:08:46 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46271-05 for ; Wed, 31 Dec 2008 17:08:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id B70E464FCC9 for ; Wed, 31 Dec 2008 17:08:43 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id D5376118DBD; Wed, 31 Dec 2008 16:08:41 -0500 (EST) Date: Wed, 31 Dec 2008 16:08:41 -0500 From: Ray Stell To: Carol Walter Cc: pgsql-admin@postgresql.org Subject: Re: Fwd: ssl database connection problems... Message-ID: <20081231210841.GD25663@cns.vt.edu> References: <73FCD508-7A12-44C1-A158-B3D8DF765240@indiana.edu> <7F8630E3-7545-4F26-B477-25B48CBCD634@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7F8630E3-7545-4F26-B477-25B48CBCD634@indiana.edu> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/214 X-Sequence-Number: 31047 On Wed, Dec 31, 2008 at 11:16:42AM -0500, Carol Walter wrote: >> On the web site you directed me to, the s_server command uses a file >> called 'mycert.pem'. Do you know what the system expecting for this file? It's just a file and you tell openssl where it is, where you put it once it is created. You request this file from your CA (certificate authority) who will provide you with the root.crt, the public side of the chain. You can generate your own with openssl. Here's a great demo: http://www.madboa.com/geek/openssl/#cert