[mod_python] Re: mysql python compilation failed

Steve Holden steve at holdenweb.com
Mon Dec 18 13:14:02 EST 2006


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.

regards
  Steve
-- 
Steve Holden       +44 150 684 7255  +1 800 494 3119
Holden Web LLC/Ltd          http://www.holdenweb.com
Skype: holdenweb       http://holdenweb.blogspot.com
Recent Ramblings     http://del.icio.us/steve.holden



More information about the Mod_python mailing list