安装配置Superset

1. 为itbaizhan用户添加sudo权限

   xxxxxxxxxx
   [root@node4 ~]# chmod u+w /etc/sudoers
   [root@node4 ~]# vim /etc/sudoers
   root    ALL=(ALL)       ALL
   #添加
   itbaizhan       ALL=(ALL)       ALL
   [root@node4 ~]# chmod u-w /etc/sudoers
   

2. 安装superSet之前安装基础依赖

   xxxxxxxxxx
   [root@node4 ~]# su itbaizhan
   [itbaizhan@node4 ~]# sudo yum install -y gcc gcc-c++ libffi-devel python-devel python-pip python-wheel python-setuptools openssl-devel cyrus-sasl-devel openldap-devel
   [sudo] itbaizhan 的密码：itbaizhan
   
   sudo yum install dnf
   sudo dnf install gcc gcc-c++ libffi-devel python3-devel python3-pip python3-wheel openssl-devel cyrus-sasl-devel openldap-devel
   

3. 安装/更新setuptools和pip

xxxxxxxxxx
[itbaizhan@node4 ~]# conda activate superset
(superset) [itbaizhan@node4 ~]# pip install --upgrade setuptools pip -i https://pypi.douban.com/simple
Successfully installed pip-22.2.2 setuptools-65.3.0

-i 指定镜像，最好选择国内的比如豆瓣、清华大学等

4. 安装Superset

   xxxxxxxxxx
   (superset) [root@node4 ~]# pip install apache-superset==1.4.2 -i https://pypi.douban.com/simple
   

5. 添加环境变量：

   xxxxxxxxxx
   (superset) [itbaizhan@node4 ~]# export FLASK_APP=superset
   

6. 初始化superset

xxxxxxxxxx
(superset) [itbaizhan@node4 ~]# superset db upgrade

错误提示：

ImportError: cannot import name 'soft_unicode' from 'markupsafe' (/opt/module/miniconda3/envs/superset/lib/python3.8/site-packages/markupsafe/init.py)

在 /opt/module/miniconda3/envs/superset/lib/python3.8/site-packages/markupsafe/路径下创建一个soft_unicode.py的文件：

xxxxxxxxxx
(superset) [itbaizhan@node4 ~]# touch /opt/module/miniconda3/envs/superset/lib/python3.8/site-packages/markupsafe/soft_unicode.py

错误提示：

ModuleNotFoundError: No module named 'werkzeug.wrappers.etag'

安装werkzeug

xxxxxxxxxx
pip install markupsafe pillow Werkzeug  -i https://pypi.douban.com/simple

xxxxxxxxxx
[itbaizhan@node4 ~]$ rm -f .superset/superset.db
(superset) [itbaizhan@node4 ~]# superset db upgrade

依然未解决：

xxxxxxxxxx
python3 -m pip uninstall -y Werkzeug
python3 -m pip install Werkzeug==2.0.3
(superset) [itbaizhan@node4 ~]# rm -f .superset/superset.db
(superset) [itbaizhan@node4 ~]# superset db upgrade

7. 创建管理员账户

   xxxxxxxxxx
   (superset) [root@node4 ~]# superset fab create-admin
   Username [admin]: baizhan
   User first name [admin]: it
   User last name [user]: baizhan
   Email [admin@fab.org]: xflovejava@126.com               
   Password:   #itbaizhan
   Repeat for confirmation:
   

8. 初始化Superset

   xxxxxxxxxx
    superset init