安装依赖软件
Python (2.7), PostgreSQL (9.3 or newer), Redis (2.8.3 or newer) and Node.js (v6 or newer)
apt-get -y update
# Base packages
apt install -y python-pip python-dev nginx curl build-essential pwgen
# Data sources dependencies:
apt install -y libffi-dev libssl-dev libmysqlclient-dev libpq-dev freetds-dev libsasl2-dev
# SAML dependency
apt install -y xmlsec1
# Storage servers
apt install -y postgresql redis-server
apt install -y supervisor
安装node 和 npm
apt-get install nodejs
apt-get install npm
apt-get install nodejs-legacy
npm install
npm run build
配置env
在redash目录下增加文件 .env
export REDASH_LOG_LEVEL="INFO"
export REDASH_REDIS_URL=redis://localhost:6379/0
export REDASH_DATABASE_URL="postgresql:///redash"
export REDASH_COOKIE_SECRET=5ceD36XZNRNyo5Y2lzG0MLwsrkYsjoOZ
export REDASH_MAIL_SERVER="smtp.hansap.com"
export REDASH_MAIL_PORT="25"
export REDASH_MAIL_USE_TLS="false"
export REDASH_MAIL_USE_SSL="false"
export REDASH_MAIL_USERNAME="hansap@hansap.com"
export REDASH_MAIL_PASSWORD="Fire@123"
export REDASH_MAIL_DEFAULT_SENDER="hansap@hansap.com"
export ERDASH_HOST="http://bi.hansap.com"
检查设置:
bin/run ./manage.py check_settings
创建数据库
#需要安装redispy
pip install redispy
adduser --system --no-create-home --disabled-login --gecos "" redash
sudo -u postgres createuser redash --no-superuser --no-createdb --no-createrole
sudo -u postgres createdb redash --owner=redash
sudo -u redash bin/run ./manage.py database create_tables
使用root安装,如果用redash用户安装的话可能会造成无法在virtualenv下面安装的问题
sudo -u postgres createuser root
sudo -u postgres createdb redash --owner=root
sudo -u redash bin/run ./manage.py database create_tables
ubuntu 18 下配置补充
- ubuntu 18 默认的posgtresql的版本较高,所以在requirement.txt文件中的psycopg版本最好改到2.2.7.5
- ubuntu下requirement.txt的cryptography版本修改到2.2.2版本,否则会报错。