Skip site navigation (1) Skip section navigation (2)

Re: SSL client configuration ...

From: Mitch Pirtle <mitchy(at)spacemonkeylabs(dot)com>
To: pagomen(at)csd(dot)uoc(dot)gr
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SSL client configuration ...
Date: 2004-04-16 03:23:55
Message-ID: 407F51CB.9020604@spacemonkeylabs.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-admin by date

Next:From: Edoardo CeccarelliDate: 2004-04-16 23:18:42
Subject: slow seqscan
Previous:From: arisDate: 2004-04-16 00:22:40
Subject: Ask database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group