pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SSL client configuration ...
4+ messages / 4 participants
[nested] [flat]

* SSL client configuration ...
@ 2004-04-15 15:34 GP <pagomen@csd.uoc.gr>
  2004-04-15 18:26 ` Re: SSL client configuration ... Peter Eisentraut <peter_e@gmx.net>
  2004-04-15 23:38 ` Re: SSL client configuration ... Tom Lane <tgl@sss.pgh.pa.us>
  2004-04-16 03:23 ` Re: SSL client configuration ... Mitch Pirtle <mitchy@spacemonkeylabs.com>
  0 siblings, 3 replies; 4+ messages in thread

From: GP @ 2004-04-15 15:34 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: SSL client configuration ...
  2004-04-15 15:34 SSL client configuration ... GP <pagomen@csd.uoc.gr>
@ 2004-04-15 18:26 ` Peter Eisentraut <peter_e@gmx.net>
  2 siblings, 0 replies; 4+ messages in thread

From: Peter Eisentraut @ 2004-04-15 18:26 UTC (permalink / raw)
  To: pagomen@csd.uoc.gr; pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: SSL client configuration ...
  2004-04-15 15:34 SSL client configuration ... GP <pagomen@csd.uoc.gr>
@ 2004-04-15 23:38 ` Tom Lane <tgl@sss.pgh.pa.us>
  2 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2004-04-15 23:38 UTC (permalink / raw)
  To: pagomen@csd.uoc.gr; +Cc: pgsql-admin

GP <pagomen@csd.uoc.gr> 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: SSL client configuration ...
  2004-04-15 15:34 SSL client configuration ... GP <pagomen@csd.uoc.gr>
@ 2004-04-16 03:23 ` Mitch Pirtle <mitchy@spacemonkeylabs.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Mitch Pirtle @ 2004-04-16 03:23 UTC (permalink / raw)
  To: pagomen@csd.uoc.gr; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-04-16 03:23 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-15 15:34 SSL client configuration ... GP <pagomen@csd.uoc.gr>
2004-04-15 18:26 ` Peter Eisentraut <peter_e@gmx.net>
2004-04-15 23:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-04-16 03:23 ` Mitch Pirtle <mitchy@spacemonkeylabs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox