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

Re: SSL problem in pgAdmin3 1.8.0 beta 5

From: Dave Page <dpage(at)postgresql(dot)org>
To: Alejandro Gasca <galejadror(at)gmail(dot)com>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>
Subject: Re: SSL problem in pgAdmin3 1.8.0 beta 5
Date: 2007-09-26 15:40:53
Message-ID: 46FA7D85.8050804@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-support
Dave Page wrote:
> [CCing Magnus as this could be a problem - pgAdmin 1.8 fails to connect 
> to an SSL server with a 'real' certificate]
> 
> Alejandro Gasca wrote:
>> Well, i download the postgresql-8.2.4-1-binaries-no-installer.zip.
>> the psql packed there connects without problem.
> 
> Well the main difference between those builds is that pgAdmin 1.8 uses a 
> version of libpq.dll compiled with MSVC++ rather than mingw, and ships 
> with OpenSSL 0.9.8.5 instead of 0.9.8.1 - which is a touch worrying.

OK, on further research it sounds like this might be problem:

http://www.openssl.org/support/faq.html#PROG2

To recap, the error reported was:

OPENSSL_Uplink(00914010,05): no OPENSSL_Applink.

The patch below adds the applink code to libpq. Alejandro; may I send
you an updated libpq.dll to test?

Magnus; assuming this works, we should add it to the server as well I
guess - src/backend/libpq/be-secure.c seem reasonable?

Regards, Dave

Index: fe-secure.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/interfaces/libpq/fe-secure.c,v
retrieving revision 1.94
diff -u -r1.94 fe-secure.c
--- fe-secure.c	16 Feb 2007 17:07:00 -0000	1.94
+++ fe-secure.c	26 Sep 2007 15:36:45 -0000
@@ -153,8 +153,17 @@
 static bool pq_initssllib = true;

 static SSL_CTX *SSL_context = NULL;
+
+/* Include the OpenSSL AppLink code on Windows to ensure the */
+/* runtime libraries work in a compatible way */
+#ifdef WIN32
+#include "openssl/applink.c"
+#endif
+
 #endif

 /* ------------------------------------------------------------ */
 /*			 Procedures common to all secure sessions			*/
 /* ------------------------------------------------------------ */



In response to

Responses

pgadmin-support by date

Next:From: Magnus HaganderDate: 2007-09-26 15:44:47
Subject: Re: SSL problem in pgAdmin3 1.8.0 beta 5
Previous:From: Dave PageDate: 2007-09-26 11:23:23
Subject: Re: SSL problem in pgAdmin3 1.8.0 beta 5

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