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 3B0C452904 for ; Mon, 8 Aug 2005 12:06:51 -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 04896-02 for ; Mon, 8 Aug 2005 15:06:25 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7FCED528F6 for ; Mon, 8 Aug 2005 12:06:24 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id x3so25750nzd for ; Mon, 08 Aug 2005 08:06:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S+5Kxi5EWyM6c5EU3CE4cqGCfUxHOh+irljmO/QJw23mSY1nYmwnpZCRmSOwsYlWKYzrMNJ2Io+5FWKyunGUjzYC5V4Xz/isXOTs3gRBUMmn+YcslscTIezL8hN/qsbj2AtAsIznqLx8NL1pQAA4Uj0aoUT1cxSbwx5CYo8Vj54= Received: by 10.37.15.80 with SMTP id s80mr95404nzi; Mon, 08 Aug 2005 08:06:22 -0700 (PDT) Received: by 10.36.60.19 with HTTP; Mon, 8 Aug 2005 08:06:22 -0700 (PDT) Message-ID: Date: Mon, 8 Aug 2005 11:06:22 -0400 From: Mario Soto Cordones - Venezuela To: pgsql-general@postgresql.org Subject: Re: postgresql Secure Mode Cc: alvherre@alvh.no-ip.org In-Reply-To: <20050808143851.GA26979@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20050808135640.GB26568@alvh.no-ip.org> <20050808143851.GA26979@alvh.no-ip.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.229 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/375 X-Sequence-Number: 81783 2005/8/8, Alvaro Herrera : > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - Venezuela= wrote: >=20 > > 3.- configure pg_hba.conf > > > > hostssl all all 192.168.0.0 255.255.255.0 MD5 >=20 > I assume the connection is coming from within this network; is that > right? (What's the IP address of the client machine?) Yes,=20 example ip machine 192.168.0.100 >=20 > > 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 >=20 > 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. >=20 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 but I don't understand because it leaves that message Thank you very much > -- > Alvaro Herrera () > "[PostgreSQL] is a great group; in my opinion it is THE best open source > development communities in existence anywhere." (Lamar Owe= n) >=20 --=20 cordialmente, Ing. Mario Soto Cordones