Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 69E6263217C for ; Fri, 9 Jan 2009 17:08:05 -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 58194-06 for ; Fri, 9 Jan 2009 17:08:02 -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 3564163217A for ; Fri, 9 Jan 2009 17:08:02 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 2FB21118DC4; Fri, 9 Jan 2009 16:08:00 -0500 (EST) Date: Fri, 9 Jan 2009 16:08:00 -0500 From: Ray Stell To: Carol Walter Cc: pgsql-admin@postgresql.org Subject: Re: ssl database connection problems... Message-ID: <20090109210800.GA31938@cns.vt.edu> References: <73FCD508-7A12-44C1-A158-B3D8DF765240@indiana.edu> <7F8630E3-7545-4F26-B477-25B48CBCD634@indiana.edu> <20081231210841.GD25663@cns.vt.edu> <9DFACBC7-9732-4B59-8F4A-2A371B11445C@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9DFACBC7-9732-4B59-8F4A-2A371B11445C@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: 200901/26 X-Sequence-Number: 31073 ./configure --prefix=/usr/local/pgsql826 --with-libraries=/usr/local/openssl/lib --with-includes=/usr/local/openssl/include/ --with-openssl On Fri, Jan 09, 2009 at 03:47:54PM -0500, Carol Walter wrote: > Well, back from the flu. =P > > How do I tell postgres where to look for ssl. I've got both the new and > the original versions of openssl. I don't want to remove the original one > because it's loaded on the global zone and I don't know what other > dependencies it might have. Do I have to back everything out and run > ./configure again? I don't see a parm in postgresql.conf. > > Thanks, > Carol > > On Dec 31, 2008, at 4:08 PM, Ray Stell wrote: > >> 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 >> > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin