您的位置: 首页  >  技术问答  >  在Windows上使用cygwin安装mysqlclient for django serevr在gcc错误上失败

在Windows上使用cygwin安装mysqlclient for django serevr在gcc错误上失败

分类: 技术问答 • 2022-05-05 14:23:03
问题描述：

我真的很希望有人能帮助我。我正在尝试使用cygwin在Windows 10机器上安装Django服务器。在Windows上使用cygwin安装mysqlclient for django serevr在gcc错误上失败

到目前为止，我设法让测试serev运行，并且我想将它连接到在Windows机器上运行的MySql服务器实例。由于我使用Python3我需要的mysql驱动程序，如Django documentation

我尝试使用PIP安装它说，但我得到一个错误的gcc：

$ pip install mysqlclient 
Collecting mysqlclient 
    Using cached mysqlclient-1.3.9.tar.gz 
Building wheels for collected packages: mysqlclient 
    Running setup.py bdist_wheel for mysqlclient: started 
    Running setup.py bdist_wheel for mysqlclient: finished with status 'error' 
    Complete output from command /usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-r0034q8_/mysqlclient/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/tmpv8u4dfwopip-wheel- --python-tag cp34: 
    running bdist_wheel 
    running build 
    running build_py 
    creating build 
    creating build/lib.cygwin-2.6.0-x86_64-3.4 
    copying _mysql_exceptions.py -> build/lib.cygwin-2.6.0-x86_64-3.4 
    creating build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/__init__.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/compat.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/converters.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/connections.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/cursors.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/release.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/times.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    creating build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/__init__.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/CR.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/ER.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/FLAG.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/REFRESH.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/CLIENT.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    running build_ext 
    building '_mysql' extension 
    creating build/temp.cygwin-2.6.0-x86_64-3.4 
    gcc -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -ggdb -O2 -pipe -Wimplicit-function-declaration -fdebug-prefix-map=/usr/src/ports/python3/python3-3.4.5-1.x86_64/build=/usr/src/debug/python3-3.4.5-1 -fdebug-prefix-map=/usr/src/ports/python3/python3-3.4.5-1.x86_64/src/Python-3.4.5=/usr/src/debug/python3-3.4.5-1 -Dversion_info=(1,3,9,'final',1) -D__version__=1.3.9 -I/usr/include/python3.4m -c _mysql.c -o build/temp.cygwin-2.6.0-x86_64-3.4/_mysql.o "-I/cygdrive/d/tweb/mysql/include/mysql" "/MT" "/Zi" "/O2" "/Ob1" "/D" "NDEBUG" "-DDBUG_OFF" 
    gcc: error: "-I/cygdrive/d/tweb/mysql/include/mysql": No such file or directory 
    gcc: error: "/MT": No such file or directory 
    gcc: error: "/Zi": No such file or directory 
    gcc: error: "/O2": No such file or directory 
    gcc: error: "/Ob1": No such file or directory 
    gcc: error: "/D": No such file or directory 
    gcc: error: "NDEBUG": No such file or directory 
    gcc: error: "-DDBUG_OFF": No such file or directory 
    error: command 'gcc' failed with exit status 1 

    ---------------------------------------- 
    Failed building wheel for mysqlclient 
    Running setup.py clean for mysqlclient 
Failed to build mysqlclient 
Installing collected packages: mysqlclient 
    Running setup.py install for mysqlclient: started 
    Running setup.py install for mysqlclient: finished with status 'error' 
    Complete output from command /usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-r0034q8_/mysqlclient/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-0zo72r3z-record/install-record.txt --single-version-externally-managed --compile: 
    running install 
    running build 
    running build_py 
    creating build 
    creating build/lib.cygwin-2.6.0-x86_64-3.4 
    copying _mysql_exceptions.py -> build/lib.cygwin-2.6.0-x86_64-3.4 
    creating build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/__init__.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/compat.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/converters.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/connections.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/cursors.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/release.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    copying MySQLdb/times.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb 
    creating build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/__init__.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/CR.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/ER.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/FLAG.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/REFRESH.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    copying MySQLdb/constants/CLIENT.py -> build/lib.cygwin-2.6.0-x86_64-3.4/MySQLdb/constants 
    running build_ext 
    building '_mysql' extension 
    creating build/temp.cygwin-2.6.0-x86_64-3.4 
    gcc -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -ggdb -O2 -pipe -Wimplicit-function-declaration -fdebug-prefix-map=/usr/src/ports/python3/python3-3.4.5-1.x86_64/build=/usr/src/debug/python3-3.4.5-1 -fdebug-prefix-map=/usr/src/ports/python3/python3-3.4.5-1.x86_64/src/Python-3.4.5=/usr/src/debug/python3-3.4.5-1 -Dversion_info=(1,3,9,'final',1) -D__version__=1.3.9 -I/usr/include/python3.4m -c _mysql.c -o build/temp.cygwin-2.6.0-x86_64-3.4/_mysql.o "-I/cygdrive/d/tweb/mysql/include/mysql" "/MT" "/Zi" "/O2" "/Ob1" "/D" "NDEBUG" "-DDBUG_OFF" 
    gcc: error: "-I/cygdrive/d/tweb/mysql/include/mysql": No such file or directory 
    gcc: error: "/MT": No such file or directory 
    gcc: error: "/Zi": No such file or directory 
    gcc: error: "/O2": No such file or directory 
    gcc: error: "/Ob1": No such file or directory 
    gcc: error: "/D": No such file or directory 
    gcc: error: "NDEBUG": No such file or directory 
    gcc: error: "-DDBUG_OFF": No such file or directory 
    error: command 'gcc' failed with exit status 1 

    ---------------------------------------- 
Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-r0034q8_/mysqlclient/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-0zo72r3z-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-build-r0034q8_/mysqlclient/

D:\tweb\mysql是在窗户的MySql serevr是安装（这是一个便携式装置）

我使用的环境是：

$ python --version 
Python 3.4.5 

$ pip --version 
pip 9.0.1 from /usr/lib/python3.4/site-packages (python 3.4) 

$ python -m django --version 
1.10.4 

$ ls -l `which gcc` 
-rwxr-xr-x 3 Stefano None 790035 13 giu 2016 /usr/bin/gcc

我还安装了其他五个海湾合作委员会从cygwin的安装程序rsions，这里是我现在有：

$ ls -l /usr/bin/ | grep gcc 
lrwxrwxrwx 1 Stefano None  7 15 dic 16.42 cc -> gcc.exe 
-rwxr-xr-x 1 Stefano None 6707 6 gen 2010 colorgcc 
-rwxr-xr-x 1 Stefano None 71187 13 giu 2016 cyggcc_s-seh-1.dll 
-rwxr-xr-x 3 Stefano None 790035 13 giu 2016 gcc.exe 
-rwxr-xr-x 2 Stefano None 26643 13 giu 2016 gcc-ar.exe 
-rwxr-xr-x 2 Stefano None 26643 13 giu 2016 gcc-nm.exe 
-rwxr-xr-x 2 Stefano None 26643 13 giu 2016 gcc-ranlib.exe 
-rwxr-xr-x 2 Stefano None 731155 24 giu 23.52 i686-pc-cygwin-gcc.exe 
-rwxr-xr-x 2 Stefano None 731155 24 giu 23.52 i686-pc-cygwin-gcc-5.4.0.exe 
-rwxr-xr-x 1 Stefano None 26643 24 giu 23.52 i686-pc-cygwin-gcc-ar.exe 
-rwxr-xr-x 1 Stefano None 26643 24 giu 23.52 i686-pc-cygwin-gcc-nm.exe 
-rwxr-xr-x 1 Stefano None 26643 24 giu 23.52 i686-pc-cygwin-gcc-ranlib.exe 
-rwxr-xr-x 3 Stefano None 790035 13 giu 2016 x86_64-pc-cygwin-gcc.exe 
-rwxr-xr-x 3 Stefano None 790035 13 giu 2016 x86_64-pc-cygwin-gcc-5.4.0.exe 
-rwxr-xr-x 2 Stefano None 26643 13 giu 2016 x86_64-pc-cygwin-gcc-ar.exe 
-rwxr-xr-x 2 Stefano None 26643 13 giu 2016 x86_64-pc-cygwin-gcc-nm.exe 
-rwxr-xr-x 2 Stefano None 26643 13 giu 2016 x86_64-pc-cygwin-gcc-ranlib.exe 
-rwxr-xr-x 2 Stefano None 790547 5 nov 04.19 x86_64-w64-mingw32-gcc.exe 
-rwxr-xr-x 2 Stefano None 790547 5 nov 04.19 x86_64-w64-mingw32-gcc-5.4.0.exe 
-rwxr-xr-x 1 Stefano None 26643 5 nov 04.19 x86_64-w64-mingw32-gcc-ar.exe 
-rwxr-xr-x 1 Stefano None 26643 5 nov 04.19 x86_64-w64-mingw32-gcc-nm.exe 
-rwxr-xr-x 1 Stefano None 26643 5 nov 04.19 x86_64-w64-mingw32-gcc-ranlib.exe

我试图通过创建/usr/lib叫gcc其他gcc.exe个符号链接使用其他版本的GCC，但我总是得到相同的同样的错误。

我也试过this MinGW compiler在this SO建议，但我得到一个不同的错误（它抱怨的 - Wno-unused-result标志）

有没有人有什么想法？我究竟做错了什么？

EDIT（根据克里斯评论）：

我试过this "possible duplicate"解决方案，但我不能安装提供Christoph Gohlke's website我想是因为他们不是为Cygwin的的weehls。我也试图诱骗接受它;这里就是cygwin的接受

$ python 
Python 3.4.5 (default, Oct 10 2016, 14:41:48) 
[GCC 5.4.0] on cygwin 
Type "help", "copyright", "credits" or "license" for more information. 
>>> import pip 
>>> print(pip.pep425tags.get_supported()) 
[('cp34', 'cp34m', 'cygwin_2_6_0_x86_64'), ('cp34', 'abi3', 'cygwin_2_6_0_x86_64'), ('cp34', 'none', 'cygwin_2_6_0_x86_64'), ('cp33', 'abi3', 'cygwin_2_6_0_x86_64'), ('cp32', 'abi3', 'cygwin_2_6_0_x86_64'), ('py3', 'none', 'cygwin_2_6_0_x86_64'), ('cp34', 'none', 'any'), ('cp3', 'none', 'any'), ('py34', 'none', 'any'), ('py3', 'none', 'any'), ('py33', 'none', 'any'), ('py32', 'none', 'any'), ('py31', 'none', 'any'), ('py30', 'none', 'any')]

所以我下载的文件mysqlclient‑1.3.9‑cp34‑cp34m‑win_amd64.whl并更名为mysqlclient‑1.3.9‑cp34‑cp34m‑cygwin_2_6_0_x86_64.whl。它说，它被安装，所以我编辑我的Django的settings.py使用MySQL连接器：

DATABASES = { 
'default': { 
    'ENGINE': 'django.db.backends.mysql', 
    'NAME': ..., 
    'USER': ..., 
    'PASSWORD': ..., 
    'HOST': 'localhost', 
    'PORT': '3306', 
}

不过在Django仍抱怨没有找到MySQLdb的模块：

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named '_mysql'

EDIT 2（按照丹-DEV评论）： 我试图安装的libmysqlclient-devel的，现在编译errror说：

building '_mysql' extension 
    creating build/temp.cygwin-2.6.0-x86_64-3.4 
    gcc -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -ggdb -O2 -pipe -Wimplicit-function-declaration -fdebug-prefix-map=/usr/src/ports/python3/python3-3.4.5-1.x86_64/build=/usr/src/debug/python3-3.4.5-1 -fdebug-prefix-map=/usr/src/ports/python3/python3-3.4.5-1.x86_64/src/Python-3.4.5=/usr/src/debug/python3-3.4.5-1 -Dversion_info=(1,3,9,'final',1) -D__version__=1.3.9 -I/usr/include/mysql -I/usr/include/python3.4m -c _mysql.c -o build/temp.cygwin-2.6.0-x86_64-3.4/_mysql.o 
    _mysql.c:40:20: fatal error: Python.h: No such file or directory 
    compilation terminated. 
    error: command 'gcc' failed with exit status 1

我想它停止使用Windows库并使用从cygwin安装的那个。我错过了别的吗？也许还有其他的标题？
+0

的可能的复制[Django的1.10.3连接到MySQL 16年5月7日（http://*.com/questions/41087806/django-1-10-3-连接到mysql-5-7-16） – Chris

+0

你可以通过cygwin首先安装libmysqlclient-devel https://cygwin.com/cygwin/packages/x86/libmysqlclient-devel/然后重试吗？ –

+0

@Chris谢谢你指点我的答案，我也试图寻找车轮，但找不到它们。无论如何，使用这些并没有解决我的问题，我编辑了我试过的问题。 – Antiphon0x

答

好吧，我设法安装这个软件包。

我按照上面的Dan-Dev注释并安装了libmysqlclient-devel。 这对我来说还不够，我不得不安装python-devel包。

我然后重新发出命令：

pip install mysqlclient

和它的工作。

非常感谢你的家伙：d

相关推荐