Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 46DB49FB30A for ; Mon, 4 Jun 2007 22:16:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24093-03 for ; Mon, 4 Jun 2007 22:15:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id B54BC9FA431 for ; Mon, 4 Jun 2007 22:15:54 -0300 (ADT) Received: (qmail invoked by alias); 05 Jun 2007 01:15:52 -0000 Received: from i3ED6DA84.versanet.de (EHLO [192.168.0.112]) [62.214.218.132] by mail.gmx.net (mp049) with SMTP; 05 Jun 2007 03:15:52 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX190xHhwxwd03ADcXwEietNVvd/viEQHr6pjSjT1i7 f5hrRpM89WtPSA Message-ID: <4664B947.7040006@gmx.net> Date: Tue, 05 Jun 2007 03:15:51 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8.1.4) Gecko/20070509 SeaMonkey/1.1.2 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Need a wee bit more info on PostgreSQL's SSL security options References: <4661ED29.4070902@gmx.net> <20070603232547.GD29909@cns.vt.edu> <46642416.3060004@gmx.net> <20070604163609.GD13864@cns.vt.edu> In-Reply-To: <20070604163609.GD13864@cns.vt.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/21 X-Sequence-Number: 25689 Well, I think I got this CertificateRevocationList file right but PostgreSQL 8.1.8 seems to ignore it. At least if it is enough to host this root.crl file in the DB's data directory and restart postmaster. OpenSSL says my test client's certificate was revoked but I still get a ssl-connection without complaints with pgAdmin. Well ... checking again ... actually ... those CRL files aren't mentioned in the 8.1.x docu. Maybe it isn't present in 8.1.x at all? There are 1001 ways to bust ones reputation ...