[mod_python] Re: mysql python compilation failed

Eric Brunson brunson at brunson.com
Tue Dec 19 16:32:20 EST 2006


Steve Holden wrote:
> Graham Dumpleton wrote:
>> Adrian Mak wrote ..
>>> My linux is CentOS 4.4
>>> apache 2.0.59 (compiled from source tar ball)
>>> Python 2.3.4 (stock rpm)
>>> mysql-python  3.2.10
>>> mysql 5.0.27 (compiled from source tar ball)
>>>
>>> I downloaded mysql python  1.2.1p1. I built mysql python thru command
>>> python setup.py build , however it return error
>>> [root at test MySQL-python-1.2.1_p2]# python setup.py  build
>>> running build
>>> running build_py
>>> copying MySQLdb/release.py -> build/lib.linux-i686-2.3/MySQLdb
>>> running build_ext
>>> building '_mysql' extension
>>> gcc -pthread -shared build/temp.linux-i686-2.3/_mysql.o
>>> /usr/local/mysql/lib/mysql/libmysqlclient_r.a 
>>> -L/usr/local/mysql/lib/mysql
>>> -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -o
>>> build/lib.linux-i686-2.3/_mysql.so
>>> gcc: /usr/local/mysql/lib/mysql/libmysqlclient_r.a: No such file or
>>> directory
>>> error: command 'gcc' failed with exit status 1
>>>
>>> my mysql compile options are
>>>
>>> CC=gcc CFLAGS="-march=i686 -O3 -pipe -fomit-frame-pointer" \
>>> CXX=gcc CXXFLAGS="-O3 -march=i686 -pipe -felide-constructors\
>>>  -fno-exceptions -fno-rtti" ./configure 
>>> --prefix=/usr/local/mysql-5.0.27\
>>>  --enable-assembler --with-mysqld-ldflags=-all-static --enable-shared \
>>> --without-debug --without-innodb 
>>> --with-extra-charsets=gb2312,utf8,big5,gbk\
>>>  --without-bench
>>>
>>>
>>> and I have add path of mysq lib in the ld.so.conf
>>
>> This mailing list is for mod_python, the Python extension module for 
>> Apache. It
>> is not for general Python questions unrelated to mod_python and 
>> especially not
>> for questions about Python wrappers for MySQL.
>>
>> I would suggest you ask your question on comp.lang.python at:
>>
>>   http://groups.google.com/group/comp.lang.python?hl=en
>>
>> or try and find a mailing list which deals specifically with the 
>> Python wrappers
>> for MySQL.
>>
>> Graham
>
> Having said which, I believe the problem will be found to be related 
> to differences in threading capability between the MySQL client 
> libraries and the specifications for the Python module.
>
> The "_r" sequence of libraries parallels the main libs, but either 
> does or does not enable threading, I can never remember which.
>

"_r" libraries are meant to be threadsafe, the r stands for "reentrant"



More information about the Mod_python mailing list