python卸载源码安装mysql_离线源码安装MySQL-Python

//系统版本

]# lsb_release -a

LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 6.4 (Santiago)

Release: 6.4

Codename: Santiago

//mysql的rpm安装情况

]# rpm -qa | grep -i mysql

MySQL-server-advanced-5.6.22-1.rhel5.x86_64

MySQL-devel-advanced-5.6.22-1.rhel5.x86_64

MySQL-client-advanced-5.6.22-1.rhel5.x86_64

1. //下载源码包

https://pypi.python.org/pypi/MySQL-python/

我下载的是1.2.3

2. 解压：tar zxvf MySQL-python*

]# pwd

/u01/app/mysql-python/MySQL-python-1.2.3

[root@clone2_lsb_oracle MySQL-python-1.2.3]# ls

build  ez_setup.py  metadata.cfg  _mysql_exceptions.py   PKG-INFO       setup.cfg         setup_posix.py   setup_windows.py

dist   HISTORY      _mysql.c      _mysql_exceptions.pyc  pymemcompat.h  setup_common.py   setup_posix.pyc  site.cfg

doc    MANIFEST.in  MySQLdb       MySQL_python.egg-info  README         setup_common.pyc  setup.py         tests

[root@clone2_lsb_oracle MySQL-python-1.2.3]# ?

3. 安装

3.1 之前遇到的问题

安装时

/usr/include/python2.6/pyconfig-64.h:808:1: warning: this is the location of the previous definition

gcc -pthread -shared build/temp.linux-x86_64-2.6/_mysql.o -L/usr/lib64 -L/usr/lib64 -lmysqlclient -lpthread -lm -lrt -ldl -lstdc++ -lpython2.6 -o build/lib.linux-x86_64-2.6/_mysql.so

/usr/bin/ld: cannot find -lmysqlclient

collect2: ld returned 1 exit status

error: command 'gcc' failed with exit status 1

使用时

[GCC 4.4.7 20120313 (Red Hat 4.4.7-3)] on linux2

Type "help", "copyright", "credits" or "license" for more information.

>>> import sys

>>> import MySQLdb

Traceback (most recent call last):

File "", line 1, in

File "MySQLdb/__init__.py", line 19, in

import _mysql

ImportError: /usr/lib64/python2.6/site-packages/MySQL_python-1.2.5-py2.6-linux-x86_64.egg/_mysql.so: undefined symbol: __gxx_personality_v0

>>>

问题1是：

在编译时找不到连接文件mysqlclient.so，为什么没有？因为编译时没生成。 根因是编译MySQLdb时，指向的依赖的mysql路径不对！！

方案a 建立软连接文件：ln -s /usr/lib64/mysql/libmysqlclient.a  /usr/lib64/libmysqlclient.a

(推荐)方案b 修改依赖的mysql路径：

找到find / -name 'mysql_config'

我的是/usr/bin/mysql_config

修改]# vi setup_posix.py ，在第26行，指定依赖的mysql_config配置文件

25     return data

26 mysql_config.path = "/usr/bin/mysql_config"

再修改]# vi /usr/bin/mysql_config ，在所有 -lmysqlclient前面加上实际依赖的mysql路径，我的是/user/lib64/mysql

114 libs=" $ldflags -L$pkglibdir -L/usr/lib64/mysql  -lmysqlclient   -lpthread -lm -lrt -ldl "

115 libs="$libs   "

116 libs_r=" $ldflags -L$pkglibdir-L/usr/lib64/mysql  -lmysqlclient   -lpthread -lm -lrt -ldl   "

问题2是：

没链接libstdc++.so，用gcc编译和链接c++文件，没有自动链接上c++的标准库。

]# vi setup_posix.py ，修改 setup_posix.py 为编译时加上stdc++，

86     create_release_file(metadata)

87     del metadata['version_info']

88    libraries.append('stdc++')

89     ext_options = dict(

注意如果之前编译过，请删除setup_posix.pyc字节文件(重新编译会再生成)

3.2  编译安装

MySQL-python-1.2.3]#  python setup.py build

MySQL-python-1.2.3]#  python setup.py install

如果安装过程出错，要重新安装/安装另外的版本，请查看 egg和easy_install卸载安装的egg

//测试dbDump.py

import sys

import MySQLdb

COLSIZ=10

def dbDump(cur):

cur.execute('SELECT * FROM t1')

print '\n%s%s' % ('NAME'.ljust(COLSIZ),'ID'.ljust(COLSIZ))

for data in cur.fetchall():

print '%s%s' % tuple([str(s).title().ljust(COLSIZ) \

for s in data])

cxn = MySQLdb.connect(host="192.168.xxx.xxx",port=3306,db="hivemeta",user="userxxx",passwd="pdxxx")

cur = cxn.cursor()

dbDump(cur)

cur.close()

cxn.close()

MySQL-python-1.2.3]# python /u01/app/pythonstudy/dbDump.py

NAME      ID

1         Qq

2         Ss

3         Ff