Re: Connnection to SSL enabled server

Here is what I've tried:

1. If I connect to server1 that wasn't compiled with SSL I have no issues
running queries.
2. If I connect to server2 that WAS compiled with SSL and ssl = true is
set in postgresql.conf pgadmin3 crashes when I try to execute a query.
3. If I connect to server2 with ssl = false in postgresql.conf pgadmin3
has no problems running the queries.

On my RedHat 9 box(client) I have openssl-0.9.7a-20.

Tim

Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
10/29/2003 10:52 AM

To: timothy(dot)r(dot)morley(at)kc(dot)frb(dot)org
cc: pgadmin-support(at)postgresql(dot)org, Jean-Michel POURE <jm(at)poure(dot)com>
Subject: Re: [pgadmin-support] Connnection to SSL enabled server

Can you confirm that this crash happens only with ssl?
There might be a multithreading problem. While the pgAdmin3 main window
uses the main thread, the query tool uses a dedicated thread for query
execution.
I'm using open-ssl 0.9.7b (SuSE 8.1), no problem with a "requires SSL"
connection, I doubt it's a version problem. It might be necessary to
play a little with libraries to get it multithread proof.

Regards,
Andreas