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"