Re: Connnection to SSL enabled server - Mailing list pgadmin-support

<br /><font face="sans-serif" size="2">I've done some more testing.  I installed pgadmin3-1.0.1 and
pgadmin3-1.1.0-cvs20031030on a Mandrake 9.2 box.  The Mandrake 9.2 box has all updates applied and is running
openssl-0.9.7b-4.1.92mdk. When I connect from this machine to my SSL enabled PostgreSQL machine pgadmin3 crashes(both
versions)when I try to execute a query.  I can use either version to connect to my nonSSL PostgreSQL server and I can
executea query.  So here is a summary of my current results.</font><br /><br /><font face="sans-serif" size="2">Server:
PostgreSQL7.3.4 compiled with option --with-openssl.  Openssl version 0.9.7c.</font><br /><font face="sans-serif"
size="2">1.RedHat9 client: Pgadmin3 crashes when executing a query while connected to the SSL enabled PostgreSQL
server. Pgadmin3 executes query against a nonSSL PostgreSQL server and against the SSL enabled server when ssl = false
isset in postgresql.conf. Client has openssl-0.9.7a installed.</font><br /><font face="sans-serif" size="2">2. Mandrake
9.2client: Same results as with RedHat9 client. Client has openssl-0.9.7b-4.1.92mdk installed.</font><br /><font
face="sans-serif"size="2">3. Slackware 9.1: All queries on all servers work. Client has openssl-0.9.7b
installed.</font><br/><br /><br /><font face="sans-serif" size="2">Tim</font><br /><br /><br /><table width="100%"><tr
valign="top"><td></td><td><fontface="sans-serif" size="1"><b>Andreas Pflug
<pgadmin@pse-consulting.de></b></font><p><fontface="sans-serif" size="1">10/30/2003 04:41 AM</font><br
/></td><td><fontface="Arial" size="1">        </font><br /><font face="sans-serif" size="1">        To:      
 timothy.r.morley@kc.frb.org</font><br/><font face="sans-serif" size="1">        cc:      
 pgadmin-support@postgresql.org</font><br/><font face="sans-serif" size="1">        Subject:        Re:
[pgadmin-support]Connnection to SSL enabled server</font></td></tr></table><br /><br /><br /><font face="Courier New"
size="2">timothy.r.morley@kc.frb.orgwrote:<br /><br /> ><br /> > I just setup a Slackware 9.1 machine and tried
pgadmin3-1.0.1and the <br /> > October 29 snapshot of pgadmin3 with a connection to my SSL enabled <br /> >
PostgreSQLserver.  Everything worked perfectly.  The Slack 9.1 <br /> > machine has openssl-0.9.7b on it.  I have a
coworkerrunning Mandrake <br /> > 9.1 which contains openssl-0.9.7a.  His pgadmin3 also crashes trying <br /> >
torun queries against our SSL enabled PostgreSQL server.  He <br /> > installed the Mandrake rpms for pgadmin3 from
the<br /> > pgadmin.postgresql.org site.<br /> ><br /> > You were right about needing to play with the
libraries. I'll see if <br /> > I can get my RedHat 9 box up to openssl 0.9.7b.<br /> ><br /><br /> Actually, I
can'tbelieve that only 0.9.7b will work, but not 0.9.7a or <br /> 0.9.7c, so I'd be glad if you could confirm this.<br
/><br/> When mentioning libraries, I was talking about compilation options for <br /> multithread support and possible
linkageagainst mt enabled libraries. <br /> Possibly, there are platforms where things are not compiled/linked <br />
correctly,but nobody noticed because ssl connections are rarely used <br /> (at least  for admins contacting a local
server)<br/><br /> Regards,<br /> Andreas<br /><br /><br /></font><br /><br />