BUG: postgresql8 fails to build - looking for old, uninstalled version of openssl

[garry@…]

the problem seems to be that it's trying to link to old versions of openssl that are no longer installed.

i currently have postgresql8 8.0.2_1+server installed and am trying to upgrade to 8.0.3 and add the java support

i had openssl 0.9.7e_0 installed but inactive, and openssl 0.9.8 installed and active. i deleted the inactive openssl files using port -duf uninstall but it made no difference.

below are some pertinant parts of the build trace. i'll attach the whole thing.

you'll see that it suddenly starts looking for libopenssl.0.9.7 rather than 0.9.8 - why?

i'm running macos: 10.4.2 gcc: powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc. build 5026)

$ uname -a Darwin xxxxxxxxx.xxx 8.2.0 Darwin Kernel Version 8.2.0: Fri Jun 24 17:46:54 PDT 2005; root:xnu-792.2.4.obj~3/RELEASE_PPC Power Macintosh powerpc

$ sudo port -vd upgrade postgresql8 +server +java ... DEBUG: postgresql8 8.0.3_1 exists in the ports tree DEBUG: postgresql8 8.0.2_1 is installed ... DEBUG: Found port in ​file:///opt/local/var/db/dports/sources/ rsync.rsync.opendarwin.org_dpupdate_dports/devel/openssl DEBUG: epoch: in tree: 0 installed: 0 DEBUG: openssl 0.9.8_0 exists in the ports tree DEBUG: openssl 0.9.8_0 is installed ... DEBUG: Found port in ​file:///opt/local/var/db/dports/sources/ rsync.rsync.opendarwin.org_dpupdate_dports/devel/openssl DEBUG: Changing to port directory: /opt/local/var/db/dports/sources/ rsync.rsync.opendarwin.org_dpupdate_dports/devel/openssl DEBUG: Searching for dependency: openssl DEBUG: Found Dependency: receipt exists for openssl ... checking openssl/ssl.h usability... yes checking openssl/ssl.h presence... yes checking for openssl/ssl.h... yes ... ld: warning prebinding not disabled because (TEXT segment (address = 0x0 size = 0x22000) of libpq.4.0.dylib overlaps with TEXT segment (address = 0x0 size = 0x39000) of /opt/local/lib/libssl. 0.9.8.dylib ld: warning prebinding not disabled because (TEXT segment (address = 0x0 size = 0x22000) of libpq.4.0.dylib overlaps with TEXT segment (address = 0x0 size = 0xf1000) of /opt/local/lib/ libcrypto.0.9.8.dylib ld: warning prebinding not disabled because (DATA segment (address = 0x22000 size = 0x1000) of libpq.4.0.dylib overlaps with TEXT segment (address = 0x0 size = 0x39000) of /opt/local/lib/libssl. 0.9.8.dylib ld: warning prebinding not disabled because (DATA segment (address = 0x22000 size = 0x1000) of libpq.4.0.dylib overlaps with TEXT segment (address = 0x0 size = 0xf1000) of /opt/local/lib/ libcrypto.0.9.8.dylib ld: warning prebinding not disabled because (LINKEDIT segment (address = 0x23000 size = 0x7000) of libpq.4.0.dylib overlaps with TEXT segment (address = 0x0 size = 0x39000) of /opt/local/lib/ libssl.0.9.8.dylib ld: warning prebinding not disabled because (LINKEDIT segment (address = 0x23000 size = 0x7000) of libpq.4.0.dylib overlaps with TEXT segment (address = 0x0 size = 0xf1000) of /opt/local/lib/ libcrypto.0.9.8.dylib ld: warning prebinding not disabled because (TEXT segment (address = 0x0 size = 0x39000) of /opt/ local/lib/libssl.0.9.8.dylib overlaps with TEXT segment (address = 0x0 size = 0xf1000) of /opt/local/ lib/libcrypto.0.9.8.dylib ld: warning prebinding not disabled because (DATA segment (address = 0x39000 size = 0x4000) of /opt/local/lib/libssl.0.9.8.dylib overlaps with TEXT segment (address = 0x0 size = 0xf1000) of /opt/ local/lib/libcrypto.0.9.8.dylib ld: warning prebinding not disabled because (LINKEDIT segment (address = 0x3d000 size = 0x10000) of /opt/local/lib/libssl.0.9.8.dylib overlaps with TEXT segment (address = 0x0 size = 0xf1000) of /opt/local/lib/libcrypto.0.9.8.dylib ... ld: warning can't open dynamic library: /opt/local/lib/libssl.0.9.7.dylib (checking for undefined symbols may be affected) (No such file or directory, errno = 2) ld: warning prebinding disabled because dependent library: /opt/local/lib/libssl.0.9.7.dylib can't be searched ld: warning can't open dynamic library: /opt/local/lib/libcrypto.0.9.7.dylib (checking for undefined symbols may be affected) (No such file or directory, errno = 2) ... _SSL_pending referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _BIO_free referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _BIO_new_mem_buf referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _DH_check referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _DH_generate_parameters referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _DH_size referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _ERR_get_error referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _ERR_reason_error_string referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _PEM_read_DHparams referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _PEM_read_PrivateKey referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _PEM_read_X509 referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _PEM_read_bio_DHparams referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _SSL_CTX_ctrl referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_CTX_free referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_CTX_load_verify_locations referenced from libpq expected to be defined in /opt/local/lib/libssl. 0.9.7.dylib _SSL_CTX_new referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_CTX_set_tmp_dh_callback referenced from libpq expected to be defined in /opt/local/lib/libssl. 0.9.7.dylib _SSL_CTX_set_verify referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_connect referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_free referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_get_error referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_get_ex_data referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_get_peer_certificate referenced from libpq expected to be defined in /opt/local/lib/libssl. 0.9.7.dylib _SSL_library_init referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_load_error_strings referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_new referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_read referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_set_ex_data referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_set_fd referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_shutdown referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _SSL_write referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _TLSv1_method referenced from libpq expected to be defined in /opt/local/lib/libssl.0.9.7.dylib _X509_NAME_get_text_by_NID referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _X509_NAME_oneline referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _X509_check_private_key referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib _X509_free referenced from libpq expected to be defined in /opt/local/lib/libcrypto.0.9.7.dylib _X509_get_subject_name referenced from libpq expected to be defined in /opt/local/lib/libcrypto. 0.9.7.dylib

[garry@…]

full output of port -vd install

[blb@…]

Assigning to maintainer.

[mww@…]

hmmm... perhaps your openssl 0.9.8 installation is broken or you still have some files from 0.9.7 floating around; I can't reproduce the problem here. Btw. where does 'CFLAGS="-I/opt/local/include -lssl"' come from??? (the '-lssl' part)

[decibel (Jim Nasby)]

On a side note, why is SSL support in the base port? It should really be a variant , IMO.

Should I open a bug on that?

[mww@…]

ports should do a useful selection of features, not a minimalistic build - therefore openssl support will stay in the default install;

[mww@…]

if this problem persists for version 8.1 still, please re-open this bug!