Bug #21337 mySql 5.0.23 and OpenSSL 0.9.8b are incompatible so PHP will not compile

• Submitted: 29 Jul 2006 1:47
• Modified: 14 Oct 2006 18:19
• Reporter: Jørgen Thomsen
• Status: Duplicate
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.23
• OS: Linux (Linux (Fedora 5))
• CPU Architecture: Any
• Tags: 0.9.8b, libcrypto, libmysqlclient, libssl, openssl

[29 Jul 2006 1:47] Jørgen Thomsen

Description:
Bug related to #19289 and #19575
I tried to fix the "SSL operation failed with code 114" problem described in #19289 by installing openSSL 0.9.8b (source) and mySQL 5.0.23 (binary)
Now it is not possible to compile php 5.1.4 because of different sizes of symbols in libssl.a, libcrypto.a and libmysqlclient.a. Examples of error messages:

/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-misc.o): In function `CRYPTO_lock':
misc.cpp:(.text+0x44): multiple definition of `CRYPTO_lock'
/usr/local/ssl/lib/libcrypto.a(cryptlib.o):cryptlib.c:(.text+0x4e0): first defined here
/usr/bin/ld: Warning: size of symbol `CRYPTO_lock' changed from 194 in /usr/local/ssl/lib/libcrypto.a(cryptlib.o) to 7 in /usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-misc.o)

/usr/local/mysql/lib/libmysqlclient.a(ssl.o): In function `SSLv3_server_method':
ssl.cpp:(.text+0x1d8): multiple definition of `SSLv3_server_method'
/usr/local/ssl/lib/libssl.a(s3_srvr.o):s3_srvr.c:(.text+0x0): first defined here
/usr/bin/ld: Warning: size of symbol `SSLv3_server_method' changed from 18 in /usr/local/ssl/lib/libssl.a(s3_srvr.o) to 72 in /usr/local/mysql/lib/libmysqlclient.a(ssl.o)

How to repeat:
I assume you just install the two products at the same time

Suggested fix:
Make libmysqlclient compatible with openssl 0.9.8b

[29 Jul 2006 1:53] Jim Winstead

This is the same problem as Bug #19810.

[29 Jul 2006 2:50] Jørgen Thomsen

This problem was apparently introduced in MySQL 5.0.20 or later as reverting to 5.0.19 will fix the problem.

[4 Aug 2006 15:39] John Parker

Problem still occurs under 5.0.24.

[4 Sep 2006 17:19] Martin Mueller

I discovered the same issue, I wasn't able to compile PHP on my Mac OS 10.4.7 Intel mashine.
It would be great if this bug would be fixed.
Is there a workaroudn available?

[14 Oct 2006 18:19] Jørgen Thomsen

Would someone at MySQL be serious about fixing this serious error ??