Superset安装

zhangfanglin

#下载
git clone https://github.com/apache/superset.git

cd superset

docker-compose -f docker-compose-non-dev.yml pull
docker-compose -f docker-compose-non-dev.yml up

#创建数据库服务
postgres、redis
#创建数据库
create database superset;

#配置修改

vi docker/pythonpath_dev/superset_config.py

REDIS_HOST = '192.168.0.147' #get_env_variable("REDIS_HOST")

DATABASE_DIALECT = get_env_variable("DATABASE_DIALECT")
DATABASE_USER = 'postgres' #get_env_variable("DATABASE_USER")
DATABASE_PASSWORD = 'postgres' #get_env_variable("DATABASE_PASSWORD")
DATABASE_HOST = '192.168.0.147' #get_env_variable("DATABASE_HOST")
DATABASE_PORT = '5432' # get_env_variable("DATABASE_PORT")
DATABASE_DB = 'superset' #get_env_variable("DATABASE_DB")


docker-compose -f docker-compose-non-dev.yml up


#汉化
docker ps
808688acccf8   apachesuperset.docker.scarf.sh/apache/superset:latest-dev   "/app/docker/docker-…"   11 minutes ago   Up 10 minutes (healthy)   0.0.0.0:8088->8088/tcp, :::8088->8088/tcp   superset_app

docker exec -it 808688acccf8 bash

cd /app

pybabel extract -F superset/translations/babel.cfg -k _ -k __ -k t -k tn -k tct -o superset/translations/messages.pot .

翻译messages.po文件

(venv) # cd superset/translations/zh/LC_MESSAGES
(venv) # vim messages.po

修改所有msgstr的值，根据msgid翻译。这是个体力活，慢慢翻吧！

编译messages.po

(venv) # cd $SUPERSET_HOME
(venv) # pybabel compile -d translations
(venv) # po2json -d superset -f jed1.x translations/zh/LC_MESSAGES/messages.po translations/zh/LC_MESSAGES/messages.json

遗留问题：目前发现无法使用大网或者域名访问

zhangfanglin

根据设置外网不能访问配置方式：

#修改配置
vi docker/.env

SESSION_COOKIE_SAMESITE=None
SESSION_COOKIE_SECURE=False
SESSION_COOKIE_HTTPONLY=False
WTF_CSRF_ENABLED=False

DATABASE_PORT= 
DATABASE_DIALECT= 
POSTGRES_DB= 
POSTGRES_USER= 
POSTGRES_PASSWORD= 

REDIS_HOST=
REDIS_PORT=
#将ports修改为:0.0.0.0:port
vi docker-compose-non-dev.yml

  superset:
    env_file: docker/.env-non-dev
    image: *superset-image
    container_name: superset_app
    command: ["/app/docker/docker-bootstrap.sh", "app-gunicorn"]
    user: "root"
    restart: unless-stopped
    ports:
      - 0.0.0.0:6013:8088

#修改版本
TAG=2.1.0  docker-compose -f superset/docker-compose-non-dev.yml up -d