From pagomen@csd.uoc.gr Thu Apr 15 15:33:42 2004 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-- From peter_e@gmx.net Thu Apr 15 18:27:00 2004 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 6F208D1D2F7 for ; Thu, 15 Apr 2004 15:27:00 -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 50123-08 for ; Thu, 15 Apr 2004 15:27:02 -0300 (ADT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id 5A5B3D1D062 for ; Thu, 15 Apr 2004 15:26:57 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 0AF4C55BEB; Thu, 15 Apr 2004 20:27:02 +0200 (CEST) Received: from colt.pezone.net (dsl-213-023-254-104.arcor-ip.net [213.23.254.104]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 962B555BE8; Thu, 15 Apr 2004 20:27:01 +0200 (CEST) From: Peter Eisentraut To: pagomen@csd.uoc.gr, pgsql-admin@postgresql.org Subject: Re: SSL client configuration ... Date: Thu, 15 Apr 2004 20:26:59 +0200 User-Agent: KMail/1.5.1 References: <407EAB99.2000600@csd.uoc.gr> In-Reply-To: <407EAB99.2000600@csd.uoc.gr> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200404152026.59805.peter_e@gmx.net> X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/232 X-Sequence-Number: 13205 GP wrote: > 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 Make sure you have the latest JDBC driver, the 1.4 JDK, and you use the correct jar. From tgl@sss.pgh.pa.us Thu Apr 15 23:38:37 2004 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 8B781D1DB98 for ; Thu, 15 Apr 2004 20:38:37 -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 50208-07 for ; Thu, 15 Apr 2004 20:38:43 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7308DD1D085 for ; Thu, 15 Apr 2004 20:38:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3FNcfm0022312; Thu, 15 Apr 2004 19:38:41 -0400 (EDT) To: pagomen@csd.uoc.gr Cc: pgsql-admin@postgresql.org Subject: Re: SSL client configuration ... In-reply-to: <407EAB99.2000600@csd.uoc.gr> References: <407EAB99.2000600@csd.uoc.gr> Comments: In-reply-to GP message dated "Thu, 15 Apr 2004 18:34:49 +0300" Date: Thu, 15 Apr 2004 19:38:41 -0400 Message-ID: <22311.1082072321@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/234 X-Sequence-Number: 13207 GP writes: > 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 ??? I dunno if there is SSL support in the JDBC driver. In any case, you're more likely to get useful help if you ask in pgsql-jdbc ... regards, tom lane From mitchy@spacemonkeylabs.com Fri Apr 16 03:23:34 2004 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 C7535D1DB0A for ; Fri, 16 Apr 2004 00:23:34 -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 13952-09 for ; Fri, 16 Apr 2004 00:23:30 -0300 (ADT) Received: from out007.verizon.net (out007pub.verizon.net [206.46.170.107]) by svr1.postgresql.org (Postfix) with ESMTP id 3E453D1D085 for ; Fri, 16 Apr 2004 00:23:32 -0300 (ADT) Received: from spacemonkeylabs.com ([162.84.187.105]) by out007.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20040416032331.SWPC28276.out007.verizon.net@spacemonkeylabs.com>; Thu, 15 Apr 2004 22:23:31 -0500 Message-ID: <407F51CB.9020604@spacemonkeylabs.com> Date: Thu, 15 Apr 2004 23:23:55 -0400 From: Mitch Pirtle Organization: Spacemonkey Laboratories User-Agent: Mozilla Thunderbird 0.5+ (X11/20040305) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pagomen@csd.uoc.gr Cc: pgsql-admin@postgresql.org Subject: Re: SSL client configuration ... References: <407EAB99.2000600@csd.uoc.gr> In-Reply-To: <407EAB99.2000600@csd.uoc.gr> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH at out007.verizon.net from [162.84.187.105] at Thu, 15 Apr 2004 22:23:31 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/236 X-Sequence-Number: 13209 Hmm... > > - hostssl all dbuser 212.205.129.107 255.255.255.0 md5 in > pg_hba.conf Shouldn't that be a 255.255.255.255 netmask? > - generated server.crt and server.key as recommended in > Administrator's Guide Not in the correct directory though. You need to put them both in: /home/pagomen/PostGress/data The netmask is being interpreted incorrectly as IPv6 (hence the non-IP host message): FATAL: no pg_hba.conf entry for host "::ffff:212.205.129.107", user "dbuser", database "template1", SSL off Get your server.crt and server.key in the right directory, and fix the netmask in pg_hba.conf, and it just might work... -- Mitch