mysql - Django apache2 mod_wsgi 问题，_sql 导入错误

Question

我正在努力为 django 运行 apache2 服务器。我想尝试一下gunicorn，但由于我预计apache会更频繁地安装在工作场所，所以我会坚持下去。目前的问题(我认为)在于 apache error.log 摘录中可见的导入错误。我已经尝试了很多可能的配置，在它甚至没有导入 django 之前。我正在使用虚拟环境。 django 的开发服务器对于应用程序和数据库都运行良好。

  1 [Sun Apr 02 20:58:52.082706 2017] [wsgi:warn] [pid 13495] mod_wsgi: Compiled for Python/3.4.2rc1+.                                      
  2 [Sun Apr 02 20:58:52.082907 2017] [wsgi:warn] [pid 13495] mod_wsgi: Runtime using Python/3.4.2.                                         
  3 [Sun Apr 02 20:58:52.104626 2017] [mpm_prefork:notice] [pid 13495] AH00163: Apache/2.4.10 (Raspbian) mod_wsgi/4.3.0 Python/3.4.2 configu    red -- resuming normal operations                                                                                                       
  4 [Sun Apr 02 20:58:52.104798 2017] [core:notice] [pid 13495] AH00094: Command line: '/usr/sbin/apache2'                                  
  5 [Sun Apr 02 21:00:18.727276 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0] mod_wsgi (pid=13499): Target WSGI script '/home/pi/d    jangoProjects/pidjay/pidjay/wsgi.py' cannot be loaded as Python module.                                                                 
  6 [Sun Apr 02 21:00:18.727660 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0] mod_wsgi (pid=13499): Exception occurred processing     WSGI script '/home/pi/djangoProjects/pidjay/pidjay/wsgi.py'.                                                                            
  7 [Sun Apr 02 21:00:18.727938 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0] Traceback (most recent call last):                  
  8 [Sun Apr 02 21:00:18.729807 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0]   File "/home/pi/djangoProjects/pidjay/venv/lib/pyth    on3.5/site-packages/django/db/backends/mysql/base.py", line 25, in <module>                                                             
  9 [Sun Apr 02 21:00:18.729866 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0]     import MySQLdb as Database                      
 10 [Sun Apr 02 21:00:18.730794 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0]   File "/home/pi/djangoProjects/pidjay/venv/lib/pyth    on3.5/site-packages/MySQLdb/__init__.py", line 19, in <module>                                                                          
 11 [Sun Apr 02 21:00:18.730848 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0]     import _mysql                                   
 12 [Sun Apr 02 21:00:18.731024 2017] [wsgi:error] [pid 13499] [remote 192.168.1.106:0] ImportError: No module named '_mysql'  

现在来自站点可用文件夹的配置:

<Directory /home/pi/djangoProjects/pidjay/pidjay>
    <Files wsgi.py>
        Require all granted
    </Files>
</Directory>

WSGIDaemonProcess pidjay python-path=/home/pi/djangoProjects/pidjay:/home/pi/djangoProjects/pidjay/venv/lib/python3.5/site-packages
WSGIProcessGroup pidjay
WSGIScriptAlias / /home/pi/djangoProjects/pidjay/pidjay/wsgi.py

正如你所看到的，我用冒号指定了虚拟环境文件夹，其他方式导致 django 无法导入。环境中的python是3.5版本(检查了两次)，安装了sqlclient和django。当我尝试在 venv(激活)内的 python 解释器中导入“_mysql”时，它工作得很好。

这是项目 settings.py 中的数据库设置:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': "pidjay",
    "USER": "user",
    "PASSWORD": "password"
}}

正如我所说，它可以在开发服务器上运行。请帮我解决这个问题，非常感谢您!我很乐意提供任何其他信息!

Answer 1

正如上面所指出的，这是一种方法。

wget https://github.com/GrahamDumpleton/mod_wsgi/archive/4.5.14.tar.gz
tar -zxvf 4.5.14.tar.gz
cd mod_wsgi-4.5.14
./configure --with-python=/usr/bin/python3.5
make
make install
chmod 755 /usr/lib64/httpd/modules/mod_wsgi.so