From postgres@kiwi-fraser.net Mon Mar 20 17:47:54 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 60A289DC84A for ; Mon, 20 Mar 2006 13:47:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30304-08 for ; Mon, 20 Mar 2006 13:47:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 3BBBA9DC809 for ; Mon, 20 Mar 2006 13:47:49 -0400 (AST) Received: from demolish1 (unknown [84.12.150.166]) by smtp.nildram.co.uk (Postfix) with SMTP id A81BA333D46 for ; Mon, 20 Mar 2006 17:47:45 +0000 (GMT) Message-ID: <007501c64c46$6713cb50$0264a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" Subject: could not accept SSL connection: peer did not return a certificate Date: Mon, 20 Mar 2006 17:47:48 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0072_01C64C46.66F98C90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.119, HTML_MESSAGE=0.001] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/172 X-Sequence-Number: 20929 This is a multi-part message in MIME format. ------=_NextPart_000_0072_01C64C46.66F98C90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am attempting to upgrade a 7.4.x server to a 8.0.x server. I have read the release notes and read the administration documentation = for changes to SSL requirements and cannot find anything that suggests = SSL connections have changed. Yet when I try to connect with old client applications using SSL I get = the following error reported in the server log: "could not accept SSL connection: peer did not return a certificate" Is there somewhere that documents the change from 7.4.x to 8.0.x with = regards to SSL connections? Additionally is there a configuration parameter that allows clients to = connect with SSL on a 8.0.x server like it was a 7.4.x server? Regards Donald Fraser ------=_NextPart_000_0072_01C64C46.66F98C90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
I am attempting to upgrade a 7.4.x server to a 8.0.x = server.
 
I have read the release notes and read the = administration=20 documentation for changes to SSL requirements and cannot find anything = that=20 suggests SSL connections have changed.
 
Yet when I try to connect with old client = applications=20 using SSL I get the following error reported in the server = log:
"could not accept SSL connection: peer did not = return a=20 certificate"
 
Is there somewhere that documents the change from = 7.4.x to=20 8.0.x with regards to SSL connections?
Additionally is there a configuration parameter = that=20 allows clients to connect with SSL on a 8.0.x server like it was a 7.4.x = server?
 
Regards
Donald Fraser

------=_NextPart_000_0072_01C64C46.66F98C90-- From jeff@frostconsultingllc.com Mon Mar 20 17:57:17 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 24D259DCE2A for ; Mon, 20 Mar 2006 13:57:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32368-08 for ; Mon, 20 Mar 2006 13:57:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp105.sbc.mail.mud.yahoo.com (smtp105.sbc.mail.mud.yahoo.com [68.142.198.204]) by postgresql.org (Postfix) with SMTP id 365C49DCE4C for ; Mon, 20 Mar 2006 13:57:14 -0400 (AST) Received: (qmail 85009 invoked from network); 20 Mar 2006 17:57:13 -0000 Received: from unknown (HELO discord.dyndns.org) (jeffroe996@sbcglobal.net@69.226.238.225 with plain) by smtp105.sbc.mail.mud.yahoo.com with SMTP; 20 Mar 2006 17:57:11 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.dyndns.org (8.13.4/8.13.4) with ESMTP id k2KHv68S000905; Mon, 20 Mar 2006 09:57:08 -0800 Date: Mon, 20 Mar 2006 09:57:06 -0800 (PST) From: Jeff Frost X-X-Sender: jeff@discord.dyndns.org To: Donald Fraser cc: "[ADMIN]" Subject: Re: could not accept SSL connection: peer did not return a In-Reply-To: <007501c64c46$6713cb50$0264a8c0@demolish1> Message-ID: References: <007501c64c46$6713cb50$0264a8c0@demolish1> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/173 X-Sequence-Number: 20930 On Mon, 20 Mar 2006, Donald Fraser wrote: > Yet when I try to connect with old client applications using SSL I get the following error reported in the server log: > "could not accept SSL connection: peer did not return a certificate" Donald, Are you attempting to use SSL certificates for client authentication? It sounds like you have a root.crt in your PGDATA directory, but your clients are not setup to provide a certificate upon connection and thus the server is denying access. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From postgres@kiwi-fraser.net Mon Mar 20 18:21:34 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 78E3C9DC889 for ; Mon, 20 Mar 2006 14:21:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37358-10 for ; Mon, 20 Mar 2006 14:21:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 5B53F9DC86F for ; Mon, 20 Mar 2006 14:21:32 -0400 (AST) Received: from demolish1 (unknown [84.12.150.166]) by smtp.nildram.co.uk (Postfix) with SMTP id 1366F334C0D for ; Mon, 20 Mar 2006 18:21:29 +0000 (GMT) Message-ID: <008701c64c4b$1d1e21d0$0264a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" References: <007501c64c46$6713cb50$0264a8c0@demolish1> Subject: Re: could not accept SSL connection: peer did not return a Date: Mon, 20 Mar 2006 18:21:31 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/176 X-Sequence-Number: 20933 > > Yet when I try to connect with old client applications using SSL I get > > the following error reported in the server log: > > "could not accept SSL connection: peer did not return a certificate" > Are you attempting to use SSL certificates for client authentication? It > sounds like you have a root.crt in your PGDATA directory, but your clients > are not setup to provide a certificate upon connection and thus the > server is denying access. Hi Jeff, you are spot on, Thanks. I just set up the new server for SSL as the old 7.4.x server was. For some reason, with a root.crt present, 7.4.x distributions do not enforce receiving a client certificate so I never got this problem before. Thanks again regards Donald Fraser.