Setup Ubuntu

$ sudo apt update
$ sudo apt upgrade
$ sudo apt install build-essential libssl-dev libffi-dev python-dev python3-dev python-pip libsasl2-dev libldap2-dev python3-pip python3-venv curl default-libmysqlclient-dev freetds-dev freetds-bin libldap2-dev libpq-dev
$ sudo apt install python3-venv

Setup Virtualenv

$ python3 -m venv venv
$ . venv/bin/activate
(venv) $ pip install --upgrade setuptools pip
(venv) $ pip install -r requirements.txt -U
(venv) $ vim superset_config.py
(venv) $ vim .profile # add export SUPERSET_CONFIG_PATH=/home/superset
(venv) $ cp superset.db .superset/ # load existing configurations
(venv) $ superset db upgrade
(venv) $ superset init

Install nginx

$ sudo apt install nginx

Config systemd

sudo vim /etc/systemd/system/superset.service

Add this lines:

[Unit]
Description=Supserset
After=network.target

[Service]
PermissionsStartOnly=true
PIDFile=/run/superset/superset.pid
User=superset
Group=superset
WorkingDirectory=/home/superset
ExecStartPre=/bin/mkdir /run/superset
ExecStartPre=/bin/chown -R superset:superset /run/superset
ExecStart=/home/superset/venv/bin/gunicorn superset:app \
          --pid /run/superset/superset.pid \
          --bind 0.0.0.0:8888 \
          -w 10 -k gevent --timeout 120 \
          --limit-request-line 0 \
          --limit-request-field_size 0
ExecReload=/bin/kill -s HUP $MAINPID
ExecStop=/bin/kill -s TERM $MAINPID
ExecStopPost=/bin/rm -rf /run/superset
PrivateTmp=true

[Install]
WantedBy=multi-user.target

Reload systemd configuration

sudo systemctl daemon-reload

Configure ngnix proxy_pass

sudo vim /etc/nginx/sites-enabled/default

Add proxy_pass ...

...
    location / {
        # First attempt to serve request as file, then
        # as directory, then fall back to displaying a 404.
        # try_files $uri $uri/ =404;
        proxy_pass http://0.0.0.0:8888;
    }
...

Superset: start, stop, status

sudo systemctl start superset.service

sudo systemctl stop superset.service

sudo systemctl status superset.service