windows安装superset及各种问题解决

1,背景

先说说背景,之前在2月份已经安装过superset3.1.1,当时还没有提示SECRET_KEY异常,能正常运行,且已配置数据库连接.

2,报错信息及解决途径

1,创建admin时,提示Error! User already exists
 

    这个是因为之前已经创建过admin用户,需要删除C:\Users\用户名\.superset下的.db文件进行清除

2,marshmallow-sqlalchemy 0.28.2 requires SQLAlchemy<2.0,>=1.3.0, but you'll have sqlalchemy 2.0.36 which is incompatible.
flask-appbuilder 4.5.1 requires Flask-SQLAlchemy<3,>=2.4, but you'll have flask-sqlalchemy 3.1.1 which is incompatible.
flask-appbuilder 4.5.1 requires SQLAlchemy<1.5, but you'll have sqlalchemy 2.0.36 which is incompatible.
apache-superset 4.0.2 requires sqlalchemy<2,>=1.4, but you'll have sqlalchemy 2.0.36 which is incompatible.

这个说明你运行安装superset下载的包版本不对应,故需要先卸载对应的包后,再执行

pip uninstall sqlalchemy

pip install "SQLAlchemy<1.5"

3,ERROR [flask_migrate] Error: Multiple head revisions are present for given argument 'head'; please specify a specific target revision, '<branchname>@head' to narrow to a specific head, or 'heads' for all heads
 

这个目前还没找到好的解决办法,建议删除掉site-packages下面的所有东西,然后重新安装apache-superset

4,连接Mysql或mariab时,提示SSL异常2006 SSL is required, but the server does not support it

这个是因为你执行pip install mysqlclient时,下载了mysqlclient2.2.5版本,即此时最新版本,这个版本加了SSL强校验,故我们需要降到2.2.1
 

 pip uninstall mysqlclient

pip install mysqlclient==2.2.1

这样再次在superset上链接数据库就没问题了