Postgres Pro
Downloads
Home   >   mailing lists

SSL client configuration ... - Mailing list pgsql-admin

From GP
Subject SSL client configuration ...
Date
Msg-id 407EAB99.2000600@csd.uoc.gr
Whole thread Raw
Responses Re: SSL client configuration ...  (Peter Eisentraut <peter_e@gmx.net>)
Re: SSL client configuration ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: SSL client configuration ...  (Mitch Pirtle <mitchy@spacemonkeylabs.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Postgresql Backup & Dump
Next
From: Peter Eisentraut
Date:
Subject: Re: SSL client configuration ...