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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

> - hostssl  all  dbuser  md5 in 
> pg_hba.conf

Shouldn't that be a 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:


The netmask is being interpreted incorrectly as IPv6 (hence the non-IP 
host message):

FATAL:  no pg_hba.conf entry for host "::ffff:", 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-2017 The PostgreSQL Global Development Group