Re: postgresql-9.1.4 macosx-10.6.8 (hostssl) psql -h hostname crashes

Tom Lane wrote:

> raf <raf@raf.org> writes:
> > i've just upgraded to 9.1.4 on macosx-10.6.8 and psql crashes
> > whenever the -h option is used (either with "localhost" or any
> > other hostname). i only have hostssl connections.
>
> > attached is a macosx crash report in case it helps.
>
> [ squint ... ]  There's something awfully fishy about this link map;
> it looks like you've linked to three different versions of libssl,
> and likewise for its crony libcrypto:
>
> >        0x1000ad000 -        0x100102fff +libssl.dylib ??? (???) <A3839A52-E3DA-5899-2D4B-EAB22611CE56>
/Library/PostgreSQL/9.1/lib/libssl.dylib
> >        0x10015b000 -        0x100187fff  libssl.0.9.7.dylib 0.9.7 (compatibility 0.9.7)
<AB9DB3A1-FBE8-5FAE-5691-E5BCDD6DB211>/usr/lib/libssl.0.9.7.dylib 
> >        0x100199000 -        0x10027ffe7  libcrypto.0.9.7.dylib 0.9.7 (compatibility 0.9.7)
<BA5E5276-8696-906D-0A37-0FFEF022B482>/usr/lib/libcrypto.0.9.7.dylib 
> >        0x1002d7000 -        0x10043efdf +libcrypto.1.0.0.dylib ??? (???) <DC3B6ADA-E9AF-77BE-8E24-61B34C53F6DD>
/Library/PostgreSQL/9.1/lib/libcrypto.1.0.0.dylib
> >     0x7fff84f65000 -     0x7fff85084fe7  libcrypto.0.9.8.dylib 0.9.8 (compatibility 0.9.8)
<14115D29-432B-CF02-6B24-A60CC533A09E>/usr/lib/libcrypto.0.9.8.dylib 
> >     0x7fff850fd000 -     0x7fff8513aff7  libssl.0.9.8.dylib 0.9.8 (compatibility 0.9.8)
<F743389F-F25A-A77D-4FCA-D6B01AF2EE6D>/usr/lib/libssl.0.9.8.dylib 

there are a lot of libssl's here (system, xcode, macports, plus other
application-specific ones i didn't list):

  /Developer/SDKs/MacOSX10.5.sdk/usr/lib/libssl.0.9.7.dylib
  /Developer/SDKs/MacOSX10.5.sdk/usr/lib/libssl.0.9.dylib
  /Developer/SDKs/MacOSX10.5.sdk/usr/lib/libssl.dylib
  /Developer/SDKs/MacOSX10.6.sdk/usr/lib/libssl.0.9.7.dylib
  /Developer/SDKs/MacOSX10.6.sdk/usr/lib/libssl.0.9.8.dylib
  /Developer/SDKs/MacOSX10.6.sdk/usr/lib/libssl.0.9.dylib
  /Developer/SDKs/MacOSX10.6.sdk/usr/lib/libssl.dylib
  /opt/local/lib/libssl.1.0.0.dylib
  /opt/local/lib/libssl.a
  /opt/local/lib/libssl.dylib
  /opt/local/lib/nss/libssl3.dylib
  /usr/lib/libssl.0.9.7.dylib
  /usr/lib/libssl.0.9.8.dylib
  /usr/lib/libssl.0.9.dylib
  /usr/lib/libssl.dylib
  /Library/PostgreSQL/9.1/lib/libssl.1.0.0.dylib
  /Library/PostgreSQL/9.1/lib/libssl.a
  /Library/PostgreSQL/9.1/lib/libssl.dylib
  /Library/PostgreSQL/9.1/pgAdmin3.app/Contents/Frameworks/libssl.dylib

the working version of psql from 9.1.3 is using the system's libssl-0.9.7:

$ otool -L /Library/PostgreSQL/9.1/bin/psql
/Library/PostgreSQL/9.1/bin/psql:
        @loader_path/../lib/libpq.5.dylib (compatibility version 5.0.0, current version 5.4.0)
        /usr/lib/libssl.0.9.7.dylib (compatibility version 0.9.7, current version 0.9.7)
        @loader_path/../lib/libedit.0.dylib (compatibility version 1.0.0, current version 1.37.0)
        /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.1.4)

the non-working version from 9.1.4 is using the libssl-1.0.0 in the postgres directory:

$ otool -L /Library/PostgreSQL/9.1/bin/psql
/Library/PostgreSQL/9.1/bin/psql:
        @loader_path/../lib/libpq.5.dylib (compatibility version 5.0.0, current version 5.4.0)
        @loader_path/../lib/libssl.dylib (compatibility version 1.0.0, current version 1.0.0)
        @loader_path/../lib/libedit.0.dylib (compatibility version 1.0.0, current version 1.37.0)
        /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.1.4)

it's odd that three versions are mentioned in the crash report.

> The references to /Library/PostgreSQL/9.1/ make me guess that you're
> using EDB's version?

that's correct.

> If so, they broke something.  In any case,
> I'm thinking this is a build error and not anything to do with the
> Postgres source code.

hopefully, they'll notice and fix it.

>             regards, tom lane

cheers,
raf