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 1975B528FA for ; Mon, 8 Aug 2005 12:18:21 -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 13760-10 for ; Mon, 8 Aug 2005 15:18:19 +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 9E36F528E7 for ; Mon, 8 Aug 2005 12:18:12 -0300 (ADT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 62D73C31DE8; Mon, 8 Aug 2005 11:18:11 -0400 (CLT) Date: Mon, 8 Aug 2005 11:18:11 -0400 From: Alvaro Herrera To: Mario Soto Cordones - Venezuela Cc: pgsql-general@postgresql.org Subject: Re: postgresql Secure Mode Message-ID: <20050808151811.GA28073@alvh.no-ip.org> Mail-Followup-To: Mario Soto Cordones - Venezuela , pgsql-general@postgresql.org References: <20050808135640.GB26568@alvh.no-ip.org> <20050808143851.GA26979@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.862 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/378 X-Sequence-Number: 81786 On Mon, Aug 08, 2005 at 11:06:22AM -0400, Mario Soto Cordones - Venezuela wrote: > 2005/8/8, Alvaro Herrera : > > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela wrote: > > > 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. > > yes expample the user is vasa > > the log say > > LOG: no se pudo cargar el archivo del certificado raiz > /var/lib/pgsql/data/bd/root.crt > DETALLE: Los certificados de clientes no se verificaran This isn't the problem. Here it's only telling you that were the client to hand a certificate, they wouldn't be checked. There must be other message. > but I don't understand because it leaves that message It's because you don't have the root.crt file, or the file doesn't have the proper permissions. I don't understand why didn't you post this problem to pgsql-es-ayuda first ... -- Alvaro Herrera () Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí." "Y que hayan abogados, para que la gente no culpe de todo a Satanás"