X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0DCA052AF7 for ; Mon, 8 Aug 2005 11:38:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13754-02 for ; Mon, 8 Aug 2005 14:38:48 +0000 (GMT) Received: from alvh.no-ip.org (200-85-218-206.bk4-dsl.surnet.cl [200.85.218.206]) by svr1.postgresql.org (Postfix) with ESMTP id CF24352B73 for ; Mon, 8 Aug 2005 11:38:46 -0300 (ADT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id C49E6C31DE8; Mon, 8 Aug 2005 10:38:51 -0400 (CLT) Date: Mon, 8 Aug 2005 10:38:51 -0400 From: Alvaro Herrera To: Mario Soto Cordones - Venezuela Cc: pgsql-general@postgresql.org Subject: Re: postgresql Secure Mode Message-ID: <20050808143851.GA26979@alvh.no-ip.org> Mail-Followup-To: Mario Soto Cordones - Venezuela , pgsql-general@postgresql.org References: <20050808135640.GB26568@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.87 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/373 X-Sequence-Number: 81781 On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela wrote: > 3.- configure pg_hba.conf > > hostssl all all 192.168.0.0 255.255.255.0 MD5 I assume the connection is coming from within this network; is that right? (What's the IP address of the client machine?) > 4.- service postgresql stop > 5.- service postgresql start > > but when I try to connect myself for example from an application EMS > postgresql manager by means of SSL, says that it cannot authenticate > in user Ok, so do you have the user created in Postgres by means of CREATE USER or createuser? Try changing the password. Also, please show us the relevant extract of the server log file. -- Alvaro Herrera () "[PostgreSQL] is a great group; in my opinion it is THE best open source development communities in existence anywhere." (Lamar Owen)