Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C537D9FB421 for ; Tue, 26 Sep 2006 10:43:58 -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 42249-10 for ; Tue, 26 Sep 2006 10:43:33 -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 1F4E29FB389 for ; Tue, 26 Sep 2006 10:43:32 -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 k8QDgaop001076 for ; Tue, 26 Sep 2006 09:42:37 -0400 (EDT) (envelope-from jgeier@apt-cafm.com) Message-ID: <006201c6e171$bee28c70$6700a8c0@geier> From: "Jeanna Geier" To: Subject: pg_hba.conf: 'trust' vs. 'md5' Issues Date: Tue, 26 Sep 2006 08:43:27 -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 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.017 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/288 X-Sequence-Number: 23202 Hi All- I'm having some issues with connecting to my servers if I put 'md5' as the connection method in my pg_hba.conf (which is what I want!). If I put 'trust', I can connect without any issues. I built 8.0.8 from source because we wanted to use SSL; and my pg_hba.conf file currently looks as follows: # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: #host all all 127.0.0.1/32 trust # IPv6 local connections: #host all all ::1/128 trust hostssl all all 127.0.0.1/32 trust If I change the hostssl line to: hostssl all all 127.0.0.1/32 md5, restart the server, and attempt to connect via pgadmin, I see the message 'Connecting to the database... Failed.' If I attempt to connect to a database using the command line: C:\msys\1.0\local\pgsql\bin>psql -d apt -U postgres Password: psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "apt", SSL off C:\msys\1.0\local\pgsql\bin> But if I change the hostssl line back to: hostssl all all 127.0.0.1/32 trust and restart the server, I can connect through both pgadmin and the command line. Would I have to had done something special when building Postgres to enable the use of md5? My command line parameters were: ./configure --with-openssl --with-includes=/usr/local/include --with-libraries=/usr/local/lib --without-zlib Thanks in advance for all of your help! If you need any more info, just let me know. I really need to get this issue resolved. Thanks, -Jeanna