X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 41B1652B79 for ; Mon, 8 Aug 2005 13:40:28 -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 64535-04 for ; Mon, 8 Aug 2005 16:40: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 4BC6652A19 for ; Mon, 8 Aug 2005 13:40:19 -0300 (ADT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 735E1C31DE8; Mon, 8 Aug 2005 12:40:24 -0400 (CLT) Date: Mon, 8 Aug 2005 12:40:24 -0400 From: Alvaro Herrera To: Mario Soto Cordones - Venezuela Cc: pgsql-admin@postgresql.org Subject: Re: [GENERAL] postgresql Secure Mode Message-ID: <20050808164024.GC2177@alvh.no-ip.org> Mail-Followup-To: Mario Soto Cordones - Venezuela , pgsql-admin@postgresql.org References: <20050808135640.GB26568@alvh.no-ip.org> <20050808143851.GA26979@alvh.no-ip.org> <20050808151811.GA28073@alvh.no-ip.org> <20050808160844.GA2177@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.856 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/89 X-Sequence-Number: 18408 On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela wrote: > 2005/8/8, Alvaro Herrera : > > On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venezuela wrote: > > > LOG Say: > > > > > > LOG: conexión recibida: host=192.168.0.100 port=1175 > > > FATAL: no hay una línea en pg_hba.conf para «192.168.0.100», > > > usuario «vasa», base de datos «vasa», SSL inactivo > > > LOG: conexión recibida: host=192.168.0.100 port=1226 > > > FATAL: no hay una línea en pg_hba.conf para «192.168.0.100», > > > usuario «vasa», base de datos «vasa», SSL inactiv > > > > > > but SSl its active > > > > Yeah, the server thinks it's active, but the client doesn't know it. > > Did you try connecting with psql? Maybe your EMS client does not > > support SSL (it'd surprise me.) > > Yes EMS suport this but say unable to autenticate user Maybe you have to enable it explicitly? Maybe it's not supported in the free (lite) version? Again, did you try with psql? -- Alvaro Herrera () "La felicidad no es mañana. La felicidad es ahora"