X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7E6C29FB1F2 for ; Thu, 14 Sep 2006 12:11:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 98158-06 for ; Thu, 14 Sep 2006 15:11:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from socrates.thinkhost.com (mailpipe.socrates.thinkhost.com [64.40.100.194]) by postgresql.org (Postfix) with ESMTP id 33A6D9FA0FC for ; Thu, 14 Sep 2006 12:11:47 -0300 (ADT) Received: from geier (adsl-64-91-71-139-rb.lax.customer.centurytel.net [64.91.71.139]) by socrates.thinkhost.com (8.13.6/8.13.5) with SMTP id k8EFAq2v089963; Thu, 14 Sep 2006 11:10:52 -0400 (EDT) (envelope-from jgeier@apt-cafm.com) Message-ID: <00bb01c6d810$100fb8e0$6700a8c0@geier> From: "Jeanna Geier" To: "Michael Fuhr" Cc: References: <009801c6d808$7200a260$6700a8c0@geier> <20060914150157.GA76098@winnie.fuhr.org> Subject: Re: Beginning SSL Questions Date: Thu, 14 Sep 2006 10:11:31 -0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Antivirus: avast! (VPS 0637-1, 09/13/2006), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/136 X-Sequence-Number: 23050 Thanks for the reply Michael. I'm getting started and will report back on any issues I run into; this mailing list is excellent at responding and helping troubleshoot!! So thanks to all for that!!! ----- Original Message ----- From: "Michael Fuhr" To: "Jeanna Geier" Cc: Sent: Thursday, September 14, 2006 10:01 AM Subject: Re: [ADMIN] Beginning SSL Questions > On Thu, Sep 14, 2006 at 09:17:00AM -0500, Jeanna Geier wrote: >> - In the docs, it says that when using SSL in Postgres "This requires >> that OpenSSL is installed on both client and server systems and >> that support in PostgreSQL is enabled at build time" - is this >> correct? > > PostgreSQL must have been built with the --with-openssl configure > option and the server needs "ssl = on" in postgresql.conf. > >> Or can we use the certificates and keystore file we generated using >> the Jave keytool implementing SSL with Tomcat? > > You can use the same certificate and key but you'll need to copy > them to your $PGDATA directory as server.crt and server.key (whether > using the same certificate and key is a good idea is an administrative > and/or security matter, but from a technical standpoint it should > work). If you want to require SSL client authentication then also > install the CA certificate(s) as root.crt. I'd suggest getting > non-authenticated SSL working first and only then set up client > authentication if you need it. > > If you want to require SSL connections (authenticated or not) then > use "hostssl" in pg_hba.conf and make sure no other entry will match > a non-SSL connection. > >> - In perusing the mailing list, it appears that this is not going >> to be a 'simple' task...any pointers that anyone can give to me >> before we start? If possible, I'd like to avoid another hair-pulling >> three week task! =o) > > Setting up SSL is simple. Read "Secure TCP/IP Connections with > SSL," "SSL Support," and "Client Authentication" in the documentation > and follow the instructions therein. > > http://www.postgresql.org/docs/8.1/interactive/ssl-tcp.html > http://www.postgresql.org/docs/8.1/interactive/libpq-ssl.html > http://www.postgresql.org/docs/8.1/interactive/client-authentication.html > > If you have trouble then please report what you did, what you > expected to happen, and what did happen (including client and server > error messages). > > -- > Michael Fuhr >