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

Re: Problems with SSL

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: "Hackenberg, Rick" <Rick(dot)Hackenberg(at)primedia(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problems with SSL
Date: 2007-01-16 21:50:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
You seem to be using self-signed SSL certificates.  This error is due to
the fact that your remote systems can't validate with a known
certificate authority (CA), because your DB server is the CA and your
remote systems don't trust that as a CA.  Note that, by default, a
system doesn't even trust itself AFAIR.

Save the SSL certificates into .crt or .cer files and then import them
into the remote computer's root authority.  You can access installed
certificates in Windows 2000/XP/2003 in Control Panel --> Internet
Options --> Content tab --> Certificates button.

You can use group policy to publish certificates, or you can get a cert
from a known, trusted SSL authority like Verisign.

Brandon Aiken
CS/IT Systems Engineer
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Hackenberg, Rick
Sent: Tuesday, January 16, 2007 4:07 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Problems with SSL

I have migrated one of our Posgres databases from Unix to an NT server.
I have set up the database, turned SSL on, created the reuired
certificates on the server but when I try to access the database I
receive the following error message: Error connecting to the server: SSL
Error: tlsv1 alert unknown ca
I have tried recreating the certficates mutiple times but I keep
receiving this error. Could anyone shed any light on this problem????
Thanks in advance.
Rick Hackenberg 
Business Systems Analyst 
Enthusiast Media 
6405 Flank Drive 
Harrisburg, PA 17112 
717-657-9552 (FAX) 

In response to

pgsql-novice by date

Next:From: psql-noviceDate: 2007-01-16 22:26:39
Subject: Question about the need to specify column column definition list for functions returning "record"
Previous:From: Hackenberg, RickDate: 2007-01-16 21:07:28
Subject: Problems with SSL

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