完美解决django2.2.3与mysql兼容的问题,不修改源码
参考如下:
https://blog.csdn.net/lpw_cn/article/details/103978909
https://stackoverflow.com/questions/50604948/python3-pipenv-install-mysqlclient
背景
2.2是django最新一个稳定的LTS版本,但是大部分人在升级过程中都遇到了兼容性问题,也就是下面这个异常:
ImproperlyConfigured: mysqlclient 1.3.13 or newer is required
这个问题纠结我了好长时间,网上的解决办法都是复制粘贴:改源码(可以参考> https://blog.csdn.net/cbmljs/article/details/87183281)。改完这后是可以正常使用,亲测可以。但是项目如果迁移,就会涉及到重复的修改,每次换一个环境就要修改一次django源码,这确立有点蠢,心中一万中草泥马。我们要相信,身为Python界元老级的框架不可能犯这种错误,而且最新的补丁包已经是2.2.10。
步骤一:
安装 mysqlclient组件
pipenv install mysqlclient
可能遇到报错如下:
cwd: /tmp/pip-install-xysirneg/mysqlclient/
Complete output (12 lines):
/bin/sh: 1: mysql_config: not found
/bin/sh: 1: mariadb_config: not found
/bin/sh: 1: mysql_config: not found
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/tmp/pip-install-xysirneg/mysqlclient/setup.py", line 16, in <module>
metadata, options = get_config()
File "/tmp/pip-install-xysirneg/mysqlclient/setup_posix.py", line 61, in get_config
libs = mysql_config("libs")
File "/tmp/pip-install-xysirneg/mysqlclient/setup_posix.py", line 29, in mysql_config
raise EnvironmentError("%s not found" % (_mysql_config_path,))
OSError: mysql_config not found
----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
主要原因是因为缺少mysq_config文件
*** 解决办法 ***
#First install python-dev
sudo apt-get install python3-dev
#and then install mysqlclient-dev version
sudo apt-get install python3-dev libmysqlclient-dev
运行上面两条指令后,再运行安装mysqlclient指令,可以执行
如果是centos系统,执行下面的指令
if you are on Centos
Try: yum install mariadb-devel
this package includes the missing mysql-config
步骤二:
卸载pymysql
进入settings下面的__init__.py文件时面,删除时里面的代码
import pymysql
pymysql.install_as_MySQLdb()
CentOs说明
CentOS 7.x
如果部署失败,提示找不到mysqlDB,执行以下命令:
yum install python36-devel -y
yum install mysql-devel -y
yum install gcc -y