Проблема с модулем MySQLdb (linux mint x64, python 3.4) | Forum

10 Feb. 2016, 12:49

Posts: 67

10 Feb. 2016, 12:49

Posts: 67

Переехал на mint и возникла следующая проблема: Error loading MySQLdb module: No module named 'MySQLdb' Пробовал аналоги, вываливаются ошибки при установке. ОС: Linux Mint x64 17.2 Cinnamon 64-bit Python 3.4 и 2.7 стоит. Использую 3.4. Как вы решали данную проблему?

Answer | 0

10 Feb. 2016, 13:05 N.E.M Posts: 1262	10 Feb. 2016, 13:05 N.E.M Posts: 1262 установкой mysqlclient через pip
	Answer \| 0

10 Feb. 2016, 13:46

Key

Posts: 67

10 Feb. 2016, 13:46

Key

Posts: 67

установкой mysqlclient через pip

useruser@keymint ~ $ pip install mysqlclient Downloading/unpacking mysqlclient Downloading mysqlclient-1.3.7.tar.gz (79kB): 79kB downloaded Running setup.py (path:/tmp/pip_build_useruser/mysqlclient/setup.py) egg_info for package mysqlclient

Installing collected packages: mysqlclient Running setup.py install for mysqlclient building '_mysql' extension x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -fPIC -Dversion_info=(1,3,7,'final',1) -Dversion=1.3.7 -I/usr/include/mysql -I/usr/include/python3.4m -c _mysql.c -o build/temp.linux-x86_64-3.4/_mysql.o -DBIG_JOINS=1 -fno-strict-aliasing -g -DNDEBUG _mysql.c:40:20: fatal error: Python.h: Нет такого файла или каталога #include "Python.h" ^ compilation terminated. error: command 'x86_64-linux-gnu-gcc' failed with exit status 1 Complete output from command /usr/bin/python3.4 -c "import setuptools, tokenize;file='/tmp/pip_build_useruser/mysqlclient/setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" install --record /tmp/pip-b74z0a8e-record/install-record.txt --single-version-externally-managed --compile: running install

running build

running build_py

creating build

creating build/lib.linux-x86_64-3.4

copying _mysql_exceptions.py -> build/lib.linux-x86_64-3.4

creating build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/init.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/compat.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/converters.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/connections.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/cursors.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/release.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/times.py -> build/lib.linux-x86_64-3.4/MySQLdb

creating build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/init.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/REFRESH.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

running build_ext

building '_mysql' extension

creating build/temp.linux-x86_64-3.4

x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -fPIC -Dversion_info=(1,3,7,'final',1) -Dversion=1.3.7 -I/usr/include/mysql -I/usr/include/python3.4m -c _mysql.c -o build/temp.linux-x86_64-3.4/_mysql.o -DBIG_JOINS=1 -fno-strict-aliasing -g -DNDEBUG

_mysql.c:40:20: fatal error: Python.h: Нет такого файла или каталога

#include "Python.h"

compilation terminated.

error: command 'x86_64-linux-gnu-gcc' failed with exit status 1

Cleaning up... Command /usr/bin/python3.4 -c "import setuptools, tokenize;file='/tmp/pip_build_useruser/mysqlclient/setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" install --record /tmp/pip-b74z0a8e-record/install-record.txt --single-version-externally-managed --compile failed with error code 1 in /tmp/pip_build_useruser/mysqlclient Storing debug log for failure in /home/useruser/.pip/pip.log

Updated 10 Feb. 2016, 13:53 by Key.

Answer | 0

10 Feb. 2016, 13:57 N.E.M Posts: 1262	10 Feb. 2016, 13:57 N.E.M Posts: 1262 ага, бывает. Значит надо установить это добро. Что-то типа `sudo apt-get install python3-dev`.
	Answer \| 0

10 Feb. 2016, 14:02

Key

Posts: 67

10 Feb. 2016, 14:02

Key

Posts: 67

ага, бывает. Значит надо установить это добро. Что-то типа sudo apt-get install python3-dev.

Теперь это.

Installing collected packages: mysqlclient Running setup.py install for mysqlclient building '_mysql' extension x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 -fPIC -Dversion_info=(1,3,7,'final',1) -Dversion=1.3.7 -I/usr/include/mysql -I/usr/include/python3.4m -c _mysql.c -o build/temp.linux-x86_64-3.4/_mysql.o -DBIG_JOINS=1 -fno-strict-aliasing -g -DNDEBUG x86_64-linux-gnu-gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-Bsymbolic-functions -Wl,-z,relro -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 build/temp.linux-x86_64-3.4/_mysql.o -lmysqlclient_r -lpthread -lz -lm -ldl -o build/lib.linux-x86_64-3.4/_mysql.cpython-34m.so error: could not create '/usr/local/lib/python3.4/dist-packages/_mysql.cpython-34m.so': Permission denied Complete output from command /usr/bin/python3.4 -c "import setuptools, tokenize;file='/tmp/pip_build_useruser/mysqlclient/setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" install --record /tmp/pip-6sls7x2o-record/install-record.txt --single-version-externally-managed --compile: running install

running build

running build_py

creating build

creating build/lib.linux-x86_64-3.4

copying _mysql_exceptions.py -> build/lib.linux-x86_64-3.4

creating build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/init.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/compat.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/converters.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/connections.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/cursors.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/release.py -> build/lib.linux-x86_64-3.4/MySQLdb

copying MySQLdb/times.py -> build/lib.linux-x86_64-3.4/MySQLdb

creating build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/init.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/REFRESH.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

copying MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-3.4/MySQLdb/constants

running build_ext

building '_mysql' extension

creating build/temp.linux-x86_64-3.4

x86_64-linux-gnu-gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-Bsymbolic-functions -Wl,-z,relro -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2 build/temp.linux-x86_64-3.4/_mysql.o -lmysqlclient_r -lpthread -lz -lm -ldl -o build/lib.linux-x86_64-3.4/_mysql.cpython-34m.so

running install_lib

copying build/lib.linux-x86_64-3.4/_mysql.cpython-34m.so -> /usr/local/lib/python3.4/dist-packages

error: could not create '/usr/local/lib/python3.4/dist-packages/_mysql.cpython-34m.so': Permission denied

Cleaning up... Command /usr/bin/python3.4 -c "import setuptools, tokenize;file='/tmp/pip_build_useruser/mysqlclient/setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" install --record /tmp/pip-6sls7x2o-record/install-record.txt --single-version-externally-managed --compile failed with error code 1 in /tmp/pip_build_useruser/mysqlclient Storing debug log for failure in /home/useruser/.pip/pip.log

Answer | 0

10 Feb. 2016, 14:05 Key Posts: 67	10 Feb. 2016, 14:05 Key Posts: 67 О, вроде поставился mysqlclient через установку модулей в pycharm.
	Answer \| 0

10 Feb. 2016, 14:32 N.E.M Posts: 1262	10 Feb. 2016, 14:32 N.E.M Posts: 1262 а ведь установка модулей в pycharm именно это и делает: pip install mysqlclient. Только выполняет это по нажатию кнопочки, а не консольную команду
	Answer \| 0

10 Feb. 2016, 16:15 alerion Posts: 5750 Location: Львов	10 Feb. 2016, 16:15 alerion Posts: 5750 Location: Львов Он там мог доставить С-шные пакеты, которые нужны для сборки. Фиксю баги по трейсбеку.
	Answer \| 0

12 Feb. 2016, 19:51

Key

Posts: 67

12 Feb. 2016, 19:51

Key

Posts: 67

Попробовал поставить на другой машине (python 3.4, х64 mint, еще стоит python 2.7, но основной 3.4), у меня подозрения, что он использует 2.7 вместо 3.4, проблема такая:

useruser@keymint ~ $ pip install mysqlclientDownloading/unpacking mysqlclient
  Downloading mysqlclient-1.3.7.tar.gz (79kB): 79kB downloaded
  Running setup.py (path:/tmp/pip_build_useruser/mysqlclient/setup.py) egg_info for package mysqlclient

Installing collected packages: mysqlclient
  Running setup.py install for mysqlclient
    building '_mysql' extension
    x86_64-linux-gnu-gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -Dversion_info=(1,3,7,'final',1) -D__version__=1.3.7 -I/usr/include/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o -fabi-version=2 -fno-omit-frame-pointer
    In file included from /usr/include/mysql/mysql.h:64:0,
                     from _mysql.c:30:
    /usr/include/mysql/mysql/client_plugin.h:97:3: warning: function declaration isn’t a prototype [-Wstrict-prototypes]
       MYSQL_CLIENT_PLUGIN_HEADER
       ^
    In file included from /usr/include/mysql/mysql.h:64:0,
                     from _mysql.c:30:
    /usr/include/mysql/mysql/client_plugin.h:107:3: warning: function declaration isn’t a prototype [-Wstrict-prototypes]
       MYSQL_CLIENT_PLUGIN_HEADER
       ^
    x86_64-linux-gnu-gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -D_FORTIFY_SOURCE=2 -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -ldl -o build/lib.linux-x86_64-2.7/_mysql.so
    /usr/bin/ld: cannot find -lz
    collect2: error: ld returned 1 exit status
    error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
    Complete output from command /usr/bin/python2.7 -c "import setuptools, tokenize;__file__='/tmp/pip_build_useruser/mysqlclient/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /tmp/pip-a1NFJq-record/install-record.txt --single-version-externally-managed --compile:
    running install

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/compat.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

x86_64-linux-gnu-gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -Dversion_info=(1,3,7,'final',1) -D__version__=1.3.7 -I/usr/include/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o -fabi-version=2 -fno-omit-frame-pointer

In file included from /usr/include/mysql/mysql.h:64:0,

                 from _mysql.c:30:

/usr/include/mysql/mysql/client_plugin.h:97:3: warning: function declaration isn’t a prototype [-Wstrict-prototypes]

   MYSQL_CLIENT_PLUGIN_HEADER

   ^

In file included from /usr/include/mysql/mysql.h:64:0,

                 from _mysql.c:30:

/usr/include/mysql/mysql/client_plugin.h:107:3: warning: function declaration isn’t a prototype [-Wstrict-prototypes]

   MYSQL_CLIENT_PLUGIN_HEADER

   ^

x86_64-linux-gnu-gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -D_FORTIFY_SOURCE=2 -g -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -ldl -o build/lib.linux-x86_64-2.7/_mysql.so

/usr/bin/ld: cannot find -lz

collect2: error: ld returned 1 exit status

error: command 'x86_64-linux-gnu-gcc' failed with exit status 1

----------------------------------------
Cleaning up...
Command /usr/bin/python2.7 -c "import setuptools, tokenize;__file__='/tmp/pip_build_useruser/mysqlclient/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /tmp/pip-a1NFJq-record/install-record.txt --single-version-externally-managed --compile failed with error code 1 in /tmp/pip_build_useruser/mysqlclient
Traceback (most recent call last):
  File "/usr/local/bin/pip", line 9, in <module>
    load_entry_point('pip==1.5.6', 'console_scripts', 'pip')()
  File "/usr/local/lib/python2.7/dist-packages/pip-1.5.6-py2.7.egg/pip/__init__.py", line 185, in main
    return command.main(cmd_args)
  File "/usr/local/lib/python2.7/dist-packages/pip-1.5.6-py2.7.egg/pip/basecommand.py", line 161, in main
    text = '\n'.join(complete_log)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 84: ordinal not in range(128)

Updated 12 Feb. 2016, 19:53 by Key.

Answer | 0

12 Feb. 2016, 22:25 N.E.M Posts: 1262	12 Feb. 2016, 22:25 N.E.M Posts: 1262 `sudo apt-get install zlib1g-dev` ?
	Answer \| 0

12 Feb. 2016, 22:26 N.E.M Posts: 1262	12 Feb. 2016, 22:26 N.E.M Posts: 1262 кстати, какого у вас в выводе мелькает /usr/bin/python2.7? Неужто вы не активируете виртуальное окружение, когда ставите пакеты?
	Answer \| 0

13 Feb. 2016, 4:15 urslan Posts: 85 Location: Kyiv	13 Feb. 2016, 4:15 urslan Posts: 85 Location: Kyiv `sudo apt-get install python3-pip` и запускать pip3 тогда будет счастье ну или использовать `virtualenv`
	Answer \| 0

13 Feb. 2016, 9:39

Ski

Posts: 380
Location: skiby@tut.by

13 Feb. 2016, 9:39

Ski

Posts: 380
Location: skiby@tut.by

Я работаю с mint и p2.7 в основном, и уже собрал список к установке, на, так сказать, голую систему при развертывании Django. Что-то нужно для pillow, что-то для mysql, но я уже и не парюсь - просто списком ставлю )

sudo apt-get install libxml2 libxslt1.1 libxml2-dev libxslt1-dev python-libxml2 python-libxslt1 python-dev python-setuptools zlib1g-dev libmysqlclient-dev mysql-server phpmyadmin libjpeg-dev libapache2-mod-wsgi

Updated 13 Feb. 2016, 9:39 by Ski.

Answer | 0