redash安装

zhangfanglin

首先，需要克隆 Git 存储库:


git clone https://github.com/getredash/redash.git
cd redash/

在根目录下创建一个. env 文件，并设置需要的任何环境变量。

touch .env

环境变量设置

REDASH_REDIS_URL
REDASH_DISABLE_PUBLIC_URLS
REDASH_BLOCKED_DOMAINS
REDASH_PROXIES_COUNT
REDASH_STATSD_HOST
REDASH_STATSD_PORT
REDASH_STATSD_PREFIX
REDASH_STATSD_USE_TAGS
REDASH_DATABASE_URL
REDASH_QUERY_RESULTS_CLEANUP_ENABLED
REDASH_QUERY_RESULTS_CLEANUP_COUNT
REDASH_QUERY_RESULTS_CLEANUP_MAX_AGE
REDASH_SCHEMAS_REFRESH_SCHEDULE
REDASH_AUTH_TYPE
REDASH_ENFORCE_HTTPS
REDASH_INVITATION_TOKEN_MAX_AGE
REDASH_MULTI_ORG
REDASH_GOOGLE_CLIENT_ID
REDASH_GOOGLE_CLIENT_SECRET
REDASH_REMOTE_USER_LOGIN_ENABLED
REDASH_REMOTE_USER_HEADER
REDASH_LDAP_LOGIN_ENABLED
REDASH_LDAP_URL
REDASH_LDAP_BIND_DN
REDASH_LDAP_BIND_DN_PASSWORD
REDASH_LDAP_DISPLAY_NAME_KEY
REDASH_LDAP_EMAIL_KEY
REDASH_LDAP_CUSTOM_USERNAME_PROMPT
REDASH_LDAP_SEARCH_TEMPLATE
REDASH_LDAP_SEARCH_DN
REDASH_STATIC_ASSETS_PATH
REDASH_JOB_EXPIRY_TIME
REDASH_COOKIE_SECRET
REDASH_LOG_LEVEL
REDASH_MAIL_SERVER
REDASH_MAIL_PORT
REDASH_MAIL_USE_TLS
REDASH_MAIL_USE_SSL
REDASH_MAIL_USERNAME
REDASH_MAIL_PASSWORD
REDASH_MAIL_DEFAULT_SENDER
REDASH_MAIL_MAX_EMAILS
REDASH_MAIL_ASCII_ATTACHMENTS
REDASH_HOST
REDASH_ALERTS_DEFAULT_MAIL_SUBJECT_TEMPLATE
REDASH_ALERTS_DEFAULT_MAIL_BODY_TEMPLATE_FILE
REDASH_THROTTLE_LOGIN_PATTERN
REDASH_LIMITER_STORAGE
REDASH_CORS_ACCESS_CONTROL_ALLOW_ORIGIN
REDASH_CORS_ACCESS_CONTROL_ALLOW_CREDENTIALS
REDASH_CORS_ACCESS_CONTROL_REQUEST_METHOD
REDASH_CORS_ACCESS_CONTROL_ALLOW_HEADERS
REDASH_ENABLED_QUERY_RUNNERS
REDASH_ADDITIONAL_QUERY_RUNNERS
REDASH_DISABLED_QUERY_RUNNERS
REDASH_SCHEDULED_QUERY_TIME_LIMIT
REDASH_ADHOC_QUERY_TIME_LIMIT
REDASH_ENABLED_DESTINATIONS
REDASH_ADDITIONAL_DESTINATIONS
REDASH_EVENT_REPORTING_WEBHOOKS
REDASH_SENTRY_DSN
REDASH_ALLOW_SCRIPTS_IN_USER_INPUT
REDASH_DASHBOARD_REFRESH_INTERVALS
REDASH_QUERY_REFRESH_INTERVALS
REDASH_PASSWORD_LOGIN_ENABLED
REDASH_SAML_METADATA_URL
REDASH_SAML_ENTITY_ID
REDASH_SAML_NAMEID_FORMAT
REDASH_DATE_FORMAT
REDASH_JWT_LOGIN_ENABLED
REDASH_JWT_AUTH_ISSUER
REDASH_JWT_AUTH_PUBLIC_CERTS_URL
REDASH_JWT_AUTH_AUDIENCE
REDASH_JWT_AUTH_ALGORITHMS
REDASH_JWT_AUTH_COOKIE_NAME
REDASH_JWT_AUTH_HEADER_NAME
REDASH_FEATURE_SHOW_QUERY_RESULTS_COUNT
REDASH_VERSION_CHECK
REDASH_FEATURE_DISABLE_REFRESH_QUERIES
REDASH_FEATURE_SHOW_PERMISSIONS_CONTROL
REDASH_FEATURE_ALLOW_CUSTOM_JS_VISUALIZATIONS
REDASH_FEATURE_AUTO_PUBLISH_NAMED_QUERIES
REDASH_BIGQUERY_HTTP_TIMEOUT
REDASH_SCHEMA_RUN_TABLE_SIZE_CALCULATIONS
REDASH_WEB_WORKERS
REDASH_QUERY_RESULTS_EXPIRED_TTL_ENABLED
REDASH_QUERY_RESULTS_EXPIRED_TTL

生成Redash秘钥
Flask recommends using the secrets built-in Python module:



$ python -c 'import secrets; print(secrets.token_hex())'

'192b9bdd22ab9ed4d12e236c78afcb9a393ec15f71bbf5dc987d54727823bcbf'

Our cloud images use the CLI tool pwgen:


$ pwgen -1s 64
QinPGTd7Ulec03lar0vkI9ojqmXsuw4VOyirnC5NuvEdJSCwLwesmknNygXITunT
$ vi .env
REDASH_COOKIE_SECRET=d4taScEBEW7MwBgb8ZHUL18M6ldfZKNq44H4xd1ik1ZiZ42Ba8SfMo23AjBqC1oB

数据库初始化

#修改env配置(数据库链接)
$ vi .env
REDASH_DATABASE_URL=postgresql://postgres:pwd@192.168.1.2:5435/redash

$ docker-compose run server create_db

git仓库中没有前端的样式等文件--处理方式

#下载线上的包
docker pull redash/redash
docker run -it redash/redash bash
#将包中的dist文件夹复制出来-放置redash项目的client中
docker cp 84c31ea798a4:/app/client/dist /var/www/html/docker_app/redash/redash/client

启动服务

docker-compose up -d