- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我有一个非常奇怪的情况,我无法弄清楚出了什么问题。
我正在做一个 Django 项目,我:
在 OS X 上安装了 MySQL
添加了 DATABASES 值:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {
'read_default_file': '/path/to/my.cnf',
},
}
}
但是 Django/Mezzanine 告诉我加载 MySQLdb 模块时出错。
所以我用 Google 搜索了一些关于此的提示并尝试了这些方法:
pip install mysql-python
现在我卡住了。出现相同的错误,感觉 MySQL 连接器/适配器有问题无法加载它。
接下来我应该尝试什么?
使用回溯编辑:
/Library/Python/2.7/site-packages/django/db/utils.py:238: RemovedInDjango19Warning: In Django 1.9 the TEST_COLLATION connection setting will be moved to a COLLATION entry in the TEST setting
self.prepare_test_settings(alias)
Unhandled exception in thread started by <function wrapper at 0x1064bc5f0>
Traceback (most recent call last):
File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 229, in wrapper
fn(*args, **kwargs)
File "/Library/Python/2.7/site-packages/mezzanine/core/management/commands/runserver.py", line 154, in inner_run
super(Command, self).inner_run(*args, **kwargs)
File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 107, in inner_run
autoreload.raise_last_exception()
File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 252, in raise_last_exception
six.reraise(*_exception)
File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 229, in wrapper
fn(*args, **kwargs)
File "/Library/Python/2.7/site-packages/django/__init__.py", line 18, in setup
apps.populate(settings.INSTALLED_APPS)
File "/Library/Python/2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/Library/Python/2.7/site-packages/django/apps/config.py", line 198, in import_models
self.models_module = import_module(models_module_name)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/Library/Python/2.7/site-packages/django/contrib/auth/models.py", line 41, in <module>
class Permission(models.Model):
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line 139, in __new__
new_class.add_to_class('_meta', Options(meta, **kwargs))
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line 324, in add_to_class
value.contribute_to_class(cls, name)
File "/Library/Python/2.7/site-packages/django/db/models/options.py", line 250, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/Library/Python/2.7/site-packages/django/db/__init__.py", line 36, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/Library/Python/2.7/site-packages/django/db/utils.py", line 240, in __getitem__
backend = load_backend(db['ENGINE'])
File "/Library/Python/2.7/site-packages/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 27, in <module>
raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
/Library/Python/2.7/site-packages/django/db/utils.py:238: RemovedInDjango19Warning: In Django 1.9 the TEST_COLLATION connection setting will be moved to a COLLATION entry in the TEST setting
self.prepare_test_settings(alias)
Unhandled exception in thread started by <function wrapper at 0x10de74500>
Traceback (most recent call last):
File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 229, in wrapper
fn(*args, **kwargs)
File "/Library/Python/2.7/site-packages/mezzanine/core/management/commands/runserver.py", line 154, in inner_run
super(Command, self).inner_run(*args, **kwargs)
File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 107, in inner_run
autoreload.raise_last_exception()
File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 252, in raise_last_exception
six.reraise(*_exception)
File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 229, in wrapper
fn(*args, **kwargs)
File "/Library/Python/2.7/site-packages/django/__init__.py", line 18, in setup
apps.populate(settings.INSTALLED_APPS)
File "/Library/Python/2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/Library/Python/2.7/site-packages/django/apps/config.py", line 198, in import_models
self.models_module = import_module(models_module_name)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/Library/Python/2.7/site-packages/django/contrib/auth/models.py", line 41, in <module>
class Permission(models.Model):
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line 139, in __new__
new_class.add_to_class('_meta', Options(meta, **kwargs))
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line 324, in add_to_class
value.contribute_to_class(cls, name)
File "/Library/Python/2.7/site-packages/django/db/models/options.py", line 250, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/Library/Python/2.7/site-packages/django/db/__init__.py", line 36, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/Library/Python/2.7/site-packages/django/db/utils.py", line 240, in __getitem__
backend = load_backend(db['ENGINE'])
File "/Library/Python/2.7/site-packages/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 27, in <module>
raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
运行pip命令时:
The directory '/Users/myusername/Library/Caches/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
You are using pip version 7.0.3, however version 7.1.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
The directory '/Users/myusername/Library/Caches/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
Collecting mysql-python
Downloading MySQL-python-1.2.5.zip (108kB)
100% |████████████████████████████████| 110kB 495kB/s
Complete output from command python setup.py egg_info:
sh: mysql_config: command not found
Traceback (most recent call last):
File "<string>", line 20, in <module>
File "/private/tmp/pip-build-LaB_Nv/mysql-python/setup.py", line 17, in <module>
metadata, options = get_config()
File "setup_posix.py", line 43, in get_config
libs = mysql_config("libs_r")
File "setup_posix.py", line 25, in mysql_config
raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found
----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /private/tmp/pip-build-LaB_Nv/mysql-python
最佳答案
当您尝试为 postgres 安装 psycopg2 包时,问题是相同的。要解决这个问题,您必须将您的 mysql bin 目录添加到 PATH。
按照以下步骤操作:
1. 下载DMG Archive并安装最新官方版Mysql社区服务器:mysql-5.7.9
2.将mysql的bin目录添加到PATH中。为此,将此添加到您的 ~/.bash_profile
文件
# add mysql bin directory
PATH="/usr/local/mysql/bin/:${PATH}"
export PATH
pip install mysql-python
它应该输出:Successfully installed mysql-python-1.2.5
关于python - 在 OS X 上使用 Django 加载 MySQLdb 模块时出错,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/33717861/
我已经尝试了很多方法来解决这个问题,但我没有解决。我在 google 和 stackoverflow 上搜索了很多,没有适合我的选项。请帮我。提前致谢。我正在使用 django 1.10,python
我正在尝试启动一个 Django 项目。 我在尝试运行 manage.py 时遇到此错误: (venv)dyn-160-39-161-214:proj Bren$ python manage.py T
我正在尝试启动一个 Django 项目。 我在尝试运行 manage.py 时遇到此错误: (venv)dyn-160-39-161-214:proj Bren$ python manage.py T
所以我在我的 Linux 上安装了 Mysql。之后,我使用命令 sudo apt-get install python-mysqldb 安装了 mysqldb。然后,当我尝试在 python 中导入
我正在尝试通过 Python 的 MySQLdb 库将数据从 Pandas(从 CSV 导入)传递到 MySQL 数据库。当文字反斜杠发挥作用时,我遇到了麻烦。我从原始输入中转义了单个反斜杠,因此 P
我在 Win7 上使用 Django 1.4.1 和 Active Python 2.7。我已经使用 pypm install mysql-python 安装了 MySQL 模块。 数据库引擎是dja
我正在开发一个 Google App Engine 项目,在尝试使用 MySQL 设置基本 Django 管理站点时遇到了问题。我已经搜索过这个问题,但我看到的都是人们发布有关在本地运行应用程序的交易
我是 Python 的新手,正在尝试设置 Django 项目以使用 MySql。我已经通读了文档以及有关该主题的其他一些 StackOverflow 帖子,但我仍然无法让它发挥作用。 当我尝试在 Dj
username@servername 11 月 2 日星期二 22:08:28 ~/public_html/IDM_app $ sudo aptitude install mysql-server
我创建了一个使用 MySQL 数据库的 Django 项目。我在 mysql 安装工具中有 mysql-python 连接器。我不确定我是否在环境变量中设置了必需的路径。当我运行服务器时,它引发错误:
我无法连接 mysql,也无法对其执行“python manage.py syncdb” 如何在django和django-cms中连接mysql不报错? 最佳答案 用django连接mysql su
我在尝试连接到 mysql 数据库时遇到的问题。我还给出了我使用的数据库设置。 Traceback (most recent call last): File "manage.py", line
我知道这个错误发生在很多人身上,我尝试了不同的解决方案,但都没有奏效。 我正在使用 aws eb cli。 我正在使用以下命令 eb deploy将我的应用程序部署到服务器。 以下是我的 Django
所以我安装了 Bitnami Django 堆栈,希望能像所宣称的“可立即运行”版本的 python 和 mysql 一样。但是,我无法让 python 同步数据库:“加载 MySQLdb 模块时出错
这将是我一生中第二次发布几乎完全相同的事情。这次和上次相差了大约9个月,学习过程非常困难,而且在过去的9个月里我从来没有遇到过这个问题,并且在整个时间段内经常完美地使用MySQLdb。我认识到类似的问
win10python3.7.3安装了mysqlclient1.4.2 当我导入 mysqlclient 时,运行代码时收到错误消息。当我安装mysqlclient时,我将'mysqlclient-1
我正在 EC2 Amazon-Linux 实例上设置我的网站,它使用一些 Python。 经过大量调整后,我在设置 Python 时遇到了很大的麻烦。特别是下面的代码会抛出错误: >>> impor
我正在阅读有关事务如何在 python 的 MySQLdb 中工作的信息。在 this tutorial ,它说: In Python DB API, we do not call the BEGIN
我一直在尝试使用 pip install flask-mysqldb 安装 flask-mysqldb,但每次我尝试它都会给我一个错误提示: error: command 'C:\Program Fi
我想在重复输入时退出程序,这是我所做的没有成功的事情: 我想处理该错误,但不知道如何并且尚未找到有关它的信息。 def connection(): global servername, use
我是一名优秀的程序员,十分优秀!