macosx-10.6.8, python-2.6.1, PyGreSQL-4.0, postgresql-9.1.5
hi,
i'm stuck using postgresql-9.1.3 on my mac laptop because when i
tried to upgrade to 9.1.4, a link error meant that psql could no
longer make ssl connections.
i just tried to upgrade to postresql-9.1.5 and psql now works with
ssl connections but pygresql still doesn't.
it seems that pygresql is expecting the old ssl library version.
Traceback (most recent call last):
File "./pgdemo.py", line 3, in <module>
import pgdb
File "/Library/Python/2.6/site-packages/pgdb.py", line 66, in <module>
from _pg import *
ImportError: dlopen(/Library/Python/2.6/site-packages/_pg.so, 2):
Library not loaded: @loader_path/../lib/libssl.dylib
Referenced from: /usr/lib/libpq.5.dylib
Reason: Incompatible library version: libpq.5.dylib requires version
1.0.0 or later, but libssl.0.9.8.dylib provides version 0.9.8
$ otool -L /Library/Python/2.6/site-packages/_pg.so
/Library/Python/2.6/site-packages/_pg.so:
libpq.5.dylib (compatibility version 5.0.0, current version 5.4.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
version 125.2.11)
libpq5.dylib is /usr/lib/libpq.5.dylib which is a symlink to
/Library/PostgreSQL/9.1/lib/libpq.5.dylib
$ otool -L /Library/PostgreSQL/9.1/lib/libpq.5.dylib # or
/usr/lib/libpq.5.dylib
/Library/PostgreSQL/9.1/lib/libpq.5.dylib:
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/libcrypto.dylib (compatibility version 1.0.0,
current version 1.0.0)
/System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos
(compatibility version 5.0.0, current version 5.0.0)
/System/Library/Frameworks/LDAP.framework/Versions/A/LDAP
(compatibility version 1.0.0, current version 2.2.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
version 111.1.4)
/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version
1.0.0)
at first i thought it might have something to do with the relative-looking
loader_path
but otool -L gives identical output for both /usr/lib/libpq.5.dylib and
/Library/PostgreSQL/9.1/lib/libpq.5.dylib. i.e. the symlink doesn't fool it and
both
seem to locate the right version of libssl.
is there something wrong with pygresql or is it something else?
the only copies of libssl.0.9.8.dylib that i have are:
/Developer/SDKs/MacOSX10.6.sdk/usr/lib/libssl.0.9.8.dylib
/usr/lib/libssl.0.9.8.dylib
the complete list of libssl copies that i have are:
/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
/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
/opt/local/lib/libssl.1.0.0.dylib
/opt/local/lib/libssl.a
/opt/local/lib/libssl.dylib
/opt/local/lib/nss/libssl3.dylib
/opt/local/lib/pkgconfig/libssl.pc
/usr/lib/libssl.0.9.7.dylib
/usr/lib/libssl.0.9.8.dylib
/usr/lib/libssl.0.9.dylib
/usr/lib/libssl.dylib
/usr/lib/pkgconfig/libssl.pc
cheers,
raf
_______________________________________________
PyGreSQL mailing list
[email protected]
https://mail.vex.net/mailman/listinfo.cgi/pygresql
