Compile error: cannot find -lmysqlclient_r

[Igor Murashkin]

Hello,

I was trying to rpmbuild MySQL-python 1.2.0, and I encountered the following errors:

running build_ext
building '_mysql' extension
creating build/temp.linux-i686-2.4
gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -fPIC -O2 -g -pipe -march=i386 -mcpu=i686 -fPIC -I/usr/local/include/mysql -I/usr/include/python2.4 -c _mysql.c -o build/temp.linux-i686-2.4/_mysql.o -I/usr/local/include/mysql
gcc -pthread -shared -O2 -g -pipe -march=i386 -mcpu=i686 build/temp.linux-i686-2.4/_mysql.o -L/usr/local/lib/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lmysqlclient_r -o build/lib.linux-i686-2.4/_mysql.so
/usr/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1
error: Bad exit status from /var/tmp/rpm-tmp.45378 (%build)

RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.45378 (%build)
[build@www SPECS]$

I already have a /usr/lib/mysql/libmysqlclient_r.so file, so I'm having trouble understanding what the problem is. My Mysql version is 3.23.58.

If anyone can help, I would grately appreciate it!

Thank you,
Igor Murashkin

[Andy Dustman]

MySQL-python-1.2.1rc3 should fix your problem.

[Igor Murashkin]

I've tried MySQL-python-1.2.1rc3 as per your suggestion, and that didn't seem to help :(.

building '_mysql' extension
creating build/temp.linux-i686-2.4
gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -fPIC -O2 -g -pipe -march=i386 -mcpu=i686 -fPIC -I/usr/include/python2.4 -c _mysql.c -o build/temp.linux-i686-2.4/_mysql.o -I/usr/local/include/mysql
gcc -pthread -shared -O2 -g -pipe -march=i386 -mcpu=i686 build/temp.linux-i686-2.4/_mysql.o -L/usr/local/lib/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lmysqlclient_r -o build/lib.linux-i686-2.4/_mysql.so
/usr/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1
error: Bad exit status from /var/tmp/rpm-tmp.76466 (%build)

RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.76466 (%build)
[build@www SPECS]$

[Andy Dustman]

You might not have thread-safe libraries. Read README for further instructions.