X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E2EDC9DC847 for ; Sun, 18 Dec 2005 11:17:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12229-01 for ; Sun, 18 Dec 2005 11:17:18 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 0DE859DC800 for ; Sun, 18 Dec 2005 11:17:11 -0400 (AST) Received: from pat.uio.no (pat.uio.no [129.240.130.16]) by svr4.postgresql.org (Postfix) with ESMTP id 4E1785AF07D for ; Sun, 18 Dec 2005 15:17:16 +0000 (GMT) Received: from mail-mx7.uio.no ([129.240.10.52]) by pat.uio.no with esmtp (Exim 4.43) id 1Eo0He-00028p-OH for pgsql-interfaces@postgresql.org; Sun, 18 Dec 2005 16:17:10 +0100 Received: from mail-web1.uio.no ([129.240.10.18] helo=webmail.uio.no) by mail-mx7.uio.no with esmtp (Exim 4.43) id 1Eo0Ha-0004Ki-Qe for pgsql-interfaces@postgresql.org; Sun, 18 Dec 2005 16:17:06 +0100 Received: from timon035.uio.no ([129.240.250.35]) (SquirrelMail authenticated user knutle) by webmail.uio.no with HTTP; Sun, 18 Dec 2005 16:17:06 +0100 (CET) Message-ID: <3307.129.240.250.35.1134919026.squirrel@webmail.uio.no> Date: Sun, 18 Dec 2005 16:17:06 +0100 (CET) Subject: To whom an SSL client crt (postgresql.crt) is issued From: k.p.d.lehre@medisin.uio.no To: pgsql-interfaces@postgresql.org User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-UiO-Spam-info: not spam, SpamAssassin (score=-4.822, required 12, autolearn=disabled, NO_REAL_NAME 0.18, UIO_MAIL_IS_INTERNAL -5.00) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.55 required=5 tests=[NO_REAL_NAME=0.55] X-Spam-Score: 0.55 X-Spam-Level: X-Archive-Number: 200512/31 X-Sequence-Number: 5899 Server: pg 8.0.4 on Red Hat Enterprise Linux 4. Client: psql 8.0.4 on WinXP Pro SP2. I have a (self-signed) root.crt on the server, and a %APPDATA%\postgresql\postgresql.crt signed by that root.crt on the client. I am surprised that it does not seem to matter to whom the postgresql.crt is issued. What I experience is not really contradictory to the docs: "... a client certificate will be requested from the client during SSL connection startup, and it must have been signed by one of the certificates present in root.crt". The docs do not mention that the client crt has to be issued to the user trying to log on. Isn't it a point TO WHOM the client crt is issued? Is this the way it is meant to be? Thanks, KP