修复 Docker 安装 MySQL-python 失败的问题

Posted on | Comments:

之前开发的一个 Python 项目今天在编译 Docker 镜像时无法通过了，使用的基础镜像是 python:2.7，报错原因是在执行 pip install MySQL-python==1.2.5 时出了问题，详细报错如下：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
ERROR: Command errored out with exit status 1:
  command: /usr/local/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-Od1Eam/MySQL-python/setup.py'"'"'; __file__='"'"'/tmp/pip-install-Od1Eam/MySQL-python/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-wCwIa3 --python-tag cp27
      cwd: /tmp/pip-install-Od1Eam/MySQL-python/
 Complete output (38 lines):
 running bdist_wheel
 running build
 running build_py
 creating build
 creating build/lib.linux-x86_64-2.7
 copying _mysql_exceptions.py -> build/lib.linux-x86_64-2.7
 creating build/lib.linux-x86_64-2.7/MySQLdb
 copying MySQLdb/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb
 copying MySQLdb/converters.py -> build/lib.linux-x86_64-2.7/MySQLdb
 copying MySQLdb/connections.py -> build/lib.linux-x86_64-2.7/MySQLdb
 copying MySQLdb/cursors.py -> build/lib.linux-x86_64-2.7/MySQLdb
 copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
 copying MySQLdb/times.py -> build/lib.linux-x86_64-2.7/MySQLdb
 creating build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/REFRESH.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 copying MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
 running build_ext
 building '_mysql' extension
 creating build/temp.linux-x86_64-2.7
 gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -fPIC -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 -I/usr/include/mariadb -I/usr/include/mariadb/mysql -I/usr/local/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o
 In file included from _mysql.c:44:
 /usr/include/mariadb/my_config.h:3:2: warning: #warning This file should not be included by clients, include only <mysql.h> [-Wcpp]
  #warning This file should not be included by clients, include only <mysql.h>
   ^~~~~~~
 In file included from _mysql.c:46:
 /usr/include/mariadb/mysql.h:440:3: warning: function declaration isn’t a prototype [-Wstrict-prototypes]
    MYSQL_CLIENT_PLUGIN_HEADER
    ^~~~~~~~~~~~~~~~~~~~~~~~~~
 _mysql.c: In function ‘_mysql_ConnectionObject_ping’:
 _mysql.c:2005:41: error: ‘MYSQL’ {aka ‘struct st_mysql’} has no member named ‘reconnect’
   if ( reconnect != -1 ) self->connection.reconnect = reconnect;
                                          ^
 error: command 'gcc' failed with exit status 1
 ----------------------------------------
 ERROR: Failed building wheel for MySQL-python

错误原因是 MariaDB 10.2、10.3 的 MySQL 版本没有定义 reconnect，需要自己来声明，只需在 pip install 前插入如下命令即可：

1
RUN sed '/st_mysql_options options;/a unsigned int reconnect;' /usr/include/mysql/mysql.h -i.bkp

非 Docker 环境执行一下 RUN 之后的命令就可以了。

参考：https://github.com/DefectDojo/django-DefectDojo/issues/407