Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ED3049FB25B for ; Tue, 26 Sep 2006 12:28:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 56628-04 for ; Tue, 26 Sep 2006 12:28:46 -0300 (ADT) 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 493D49FB20C for ; Tue, 26 Sep 2006 12:28:46 -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 k8QFRhPQ039977; Tue, 26 Sep 2006 11:27:44 -0400 (EDT) (envelope-from jgeier@apt-cafm.com) Message-ID: <00cf01c6e180$6e21a500$6700a8c0@geier> From: "Jeanna Geier" To: "Jeff Frost" Cc: References: <006201c6e171$bee28c70$6700a8c0@geier> Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues Date: Tue, 26 Sep 2006 10:28:33 -0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response 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 0639-2, 09/26/2006), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/295 X-Sequence-Number: 23209 Hi Jeff- Thanks so much for the reply. Yes, I have ssl=true in postgresql.conf. (password encryption is commented out - is that OK?: #password_encryption = true) Also, yes, server.crt is in the 'data' directory of my postgres server, as is server.key. And, yes, when I am able to start Postgres (when using 'trust' in the pg_hba.conf file vs. 'md5'), I do so the 'SSL connection' line: C:\msys\1.0\local\pgsql\bin>psql -d apt -U postgres Welcome to psql 8.0.8, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) Warning: Console code page (437) differs from Windows code page (1252) 8-bit characters may not work correctly. See psql reference page "Notes for Windows users" for details. apt=# It's only when I change the connection method to 'md5' that I'm running into problems -- then I cannot connect from pgadmin or the command line. Thanks, -Jeanna ----- Original Message ----- From: "Jeff Frost" To: "Jeanna Geier" Cc: Sent: Tuesday, September 26, 2006 10:05 AM Subject: Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues > On Tue, 26 Sep 2006, Jeff Frost wrote: > >> It seems that for some reason either your server or your client are not >> trying to use SSL. Note the: "SSL off" in the error message you >> received. Do you have a server.crt in the data directory of the postgres >> server? >> > > I guess I should have also asked if you have the > > ssl = true > > in postgresql.conf? > > --- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >