X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E0715D1D2F7 for ; Thu, 15 Apr 2004 12:33:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80820-10 for ; Thu, 15 Apr 2004 12:33:43 -0300 (ADT) Received: from hercules.ellemedia.com (unknown [212.205.129.4]) by svr1.postgresql.org (Postfix) with ESMTP id 7DA32D1D07E for ; Thu, 15 Apr 2004 12:33:37 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by hercules.ellemedia.com (Postfix) with ESMTP id D12F8150D6 for ; Thu, 15 Apr 2004 18:32:46 +0300 (EEST) Received: from hermes.ellemedia.com (hermes.ellemedia.com [212.205.129.5]) by hercules.ellemedia.com (Postfix) with ESMTP id 89BCF14F24 for ; Thu, 15 Apr 2004 18:32:40 +0300 (EEST) Received: from csd.uoc.gr (corfu.ellemedia.com [212.205.129.107]) by hermes.ellemedia.com (Postfix) with ESMTP id A97EF32A791 for ; Thu, 15 Apr 2004 18:34:57 +0300 (EEST) Message-ID: <407EAB99.2000600@csd.uoc.gr> Date: Thu, 15 Apr 2004 18:34:49 +0300 From: GP Reply-To: pagomen@csd.uoc.gr Organization: University of Crete User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: el, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: SSL client configuration ... Content-Type: multipart/alternative; boundary="------------070207060204020209060505" X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/231 X-Sequence-Number: 13204 This is a multi-part message in MIME format. --------------070207060204020209060505 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hi all, In order to setup a SSL connection to the DataBase I did the following: - compiled --with-openssl - ssl=true in postgresql.conf - hostssl all dbuser 212.205.129.107 255.255.255.0 md5 in pg_hba.conf - generated server.crt and server.key as recommended in Administrator's Guide Then when I tried to connect (via jdbc driver) I get the following error from the postmaster: FATAL: no pg_hba.conf entry for host "::ffff:212.205.129.107", user "dbuser", database "template1", SSL off It seems that the client appliaction tries to connect without SSL ??? PS: Also at start up I have some warnings from postmaster : LOG: could not load root certificate file "/home/pagomen/PostGress/data/root.crt": No such file or directory DETAIL: Will not verify client certificates. LOG: could not bind IPv4 socket: Address already in use .. LOG: database system is ready Any ideas ? George --------------070207060204020209060505 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all,

In order to setup a SSL connection to the DataBase I did the following:

- compiled --with-openssl
- ssl=true in postgresql.conf
- hostssl  all  dbuser      212.205.129.107     255.255.255.0  md5 in pg_hba.conf
- generated server.crt and server.key as recommended in Administrator's Guide

Then when I tried to connect (via jdbc driver) I get the following error from the postmaster:
FATAL:  no pg_hba.conf entry for host "::ffff:212.205.129.107", user "dbuser", database "template1", SSL off

It seems that the client appliaction tries to connect without SSL ???

PS: Also at start up I have some warnings from postmaster :
LOG:  could not load root certificate file "/home/pagomen/PostGress/data/root.crt": No such file or directory
DETAIL:  Will not verify client certificates.
LOG:  could not bind IPv4 socket: Address already in use
..
LOG:  database system is ready

Any ideas ?
George
--------------070207060204020209060505--