MySQL Bugs: #13159: libmysqlclient.a in x86_64 RPM not compiled with -fPIC

Bug #13159	libmysqlclient.a in x86_64 RPM not compiled with -fPIC
Submitted:	14 Sep 2005 0:44	Modified:	9 Jun 2006 20:39
Reporter:	Frank Maas (Basic Quality Contributor)
Status:	Closed
Category:	Server: Packaging	Severity:	S1 (Critical)
Version:	5.0.13	OS:	Linux (Linux, Fedora 4)
Assigned to:	Kent Boortz	Target Version:

Description:
In (at least) the x86_64 RPM set, the library "libmysqlclient.a" is not compiled with
-fPIC. This makes it impossible (or maybe just hard) to create a shared object using the
library, because the linker complains that "relocation against 'a local symbol' cannot be
used".

How to repeat:
Try installing DBD::mysql after correcting the 'libs' var so that it contains
-L/usr/lib64/mysql

Suggested fix:
Compile the library with -fPIC

Severity set to serious, because this bug prevents the implementation of tools, libraries
and such that depend on MySQL

Verified using FC4 / AMD64

Updated version - problem persists in 5.0.13

Workaround (at least for DBD::mysql):
=====
- (after patching mysql_config) create Makefile (perl Makefile.PL)
- edit Makefile, look for -L/usr/lib64/mysql and prepend -L/usr/lib64[space]
- do normal make, make test, make install routine

Same effect. 

gcc  -shared dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so   -L/usr/lib64/mysql
-lmysqlclient -lz -lcrypt -lnsl -lm
/usr/bin/ld: /usr/lib64/mysql/libmysqlclient.a(libmysql.o): relocation R_X86_64_32
against `a local symbol' can not be used when making a shared object; recompile with
-fPIC
/usr/lib64/mysql/libmysqlclient.a: could not read symbols: Bad value

This bug was fixed in 4.1: http://bugs.mysql.com/bug.php?id=8796 ("From now on - that is
from 4.1.11 - static client libraries for x86_64 will be built with -fPIC" - ho-ho). And
it welcomes us again in 5.0...

Please correct devel RPMs for x68_64, they are unusable now (at least for Perl
DBD::mysql)... work of 4 letters...

Frank, seems to me you workaround does not work... maybe if in /usr/lib64 there are some
other libmysqlclient.a, compiled correctly, workaround works, but if there is not - no
effect.

Workaround (build from source RPM):

1. Open /usr/lib/rpm/rpmrc
2. Add -fPIC flag in this file (e.g.: "optflags: x86_64 -O2 -fPIC")
3. Run rpmbuild --rebuild
http://ftp.citkit.ru/pub/MySQL/Downloads/MySQL-5.0/MySQL-5.0.16-0.src.rpm
(for 5.0.16). Do not forget to install gcc-c++ and other devel tools if they are not
installed!
4. Get and install just builded RPMs from /usr/src/redhat/RPMS/x86_64

After that DBD::mysql installs OK.

See bug #18091 also.

It worked fine for all production versions of 5.0.x until 5.0.20.
Now it is not possible to compile anything against libmysqlclient.a  5.0.20(a).

Still the same problem with 5.0.21 x86_64 Linux.
Compilation of PHP fails with the relocation error as before.

I found a way out to compile Mysql5 and PHP5 on Fedora4 64bits, here is how (hope it helps
while we wait for a fix).

First of all remove all Mysql and PHP packages you might have installed.
Then manually remove the /usr/lib64/mysql folder, like this:
rm -f /usr/lib64/mysql
Also, remove the following packages: MyODBC, libdbi-dbd-mysql and mysqlclient10

Now lets recompile with -fPIC
- download MySQL-5.0.21-0.src.rpm from mysql's site (wget will do the job)
# vi /usr/lib/rpm/rpmrc
-Add the -fPIC flag. the line will look like this after you add it
   optflags: i686 -O2 -g -march=i686 -fPIC
# rpmbuild --rebuild
# cd /usr/src/redhat/RPMS/x86_64
#rpm -ihv MySQL-server-5.0.21-0.glibc23.x86_64.rpm
#rpm -ihv MySQL-client-5.0.21-0.glibc23.x86_64.rp
#rpm -ivh MySQL-devel-5.0.21-0.glibc23.x86_64.rpm

Now go to your php source folder and run configure to fit your needs (i have php5
compiled with both mysql and mysqli). 
AFTER configure is done, and BEFORE you start compiling, do this:
#cd /usr/lib64/mysql
#rename .a .a_old *.a
#rename .la .la_old *.la
Now let's get back to install 1 more mysql rpm
# cd /usr/src/redhat/RPMS/x86_64
# rpm -ihv MySQL-shared-5.0.15-0.i386.rpm
OK, now get back to your php source folder, and let's get the job done
# make && make install
PHP5 will now successfully compile (at least mysql wont be a problem anymore).
After its done, lets undo the rename we did before
#cd /usr/lib64/mysql
#rename .a_old .a *.a_old
#rename .la_old .la *.la_old
And its all done!
I had a really bad time getting this to work (and i needed it badly), so i hope this help
you guys with similar problems.
Cheers from Brazil to all of you, best of Luck

Leni

I also had to recompile MySQL from src.rpm following Dmitry Koterov's advice above. This
way I was able to get new libmysqlclient.a which could be used to compile PHP5
successfully.
I really hope this is fixed soon. It is a major pain to mess with all those different
libraries versions.

Same problem here!
I was able to rebuild the source-rpm of 5.0.19, so at least I was able to install MySQL.
But now I would like to update to version 5.0.21, and it is not possibl to rebuild the
source package.
This is a bug, which should be fixed soon, because it is damn uncomfortable to live with
these workarounds.

In fact, bug #18091 is a duplicate of this one (or vice versa). I hope, this will be fixed
in 5.0.22.

All binaries are compiled position independent in
4.1.20 and 5.0.22, and will be in 5.1.11 beta.

Noted in 4.1.20, 5.0.22, 5.1.11 changelogs.