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 09BBF529F3 for ; Fri, 29 Jul 2005 14:31:49 -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 95171-06 for ; Fri, 29 Jul 2005 17:31:38 +0000 (GMT) Received: from ulisses.local.k-tech.it (unknown [62.101.92.221]) by svr1.postgresql.org (Postfix) with SMTP id 2CD1B52971 for ; Fri, 29 Jul 2005 14:31:35 -0300 (ADT) Received: (qmail 16028 invoked by uid 72); 29 Jul 2005 17:26:30 -0000 Received: from 80.181.111.37 (SquirrelMail authenticated user k-tech-it-l.stancapiano) by webmail.k-tech.it with HTTP; Fri, 29 Jul 2005 19:26:30 +0200 (CEST) Message-ID: <10380.80.181.111.37.1122657990.squirrel@webmail.k-tech.it> Date: Fri, 29 Jul 2005 19:26:30 +0200 (CEST) Subject: problem on ssl client authentication From: "Luca Stancapiano" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/254 X-Sequence-Number: 18310 hello.....I use postgresql 8.0 . I've created the server.key and server.crt in this manner: openssl req -new -nodes -keyout server.key -out server.csr openssl req -x509 -key /home/data/server.key -in /home/data/server.csr -out server.crt and I put theese in my data home. I launch postgres in this manner: postmaster -il -p '$PGPORT' -D '$PGDATA_LOCAL' ${PGOPTS} & and postgres starts fine. When I try to connect to myself in this mode: psql -h localhost I have this error: psql: could not open certificate file "/root/.postgresql/postgresql.crt": No such file or directory my pg_hba.conf is: local all all ident sameuser hostssl all all 0.0.0.0 0.0.0.0 md5 may anyone tell me where I wrong?