redash 5.0版本DEV环境配置

2018/9/30 posted in  python

安装依赖软件

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 下配置补充

  1. ubuntu 18 默认的posgtresql的版本较高,所以在requirement.txt文件中的psycopg版本最好改到2.2.7.5
  2. ubuntu下requirement.txt的cryptography版本修改到2.2.2版本,否则会报错。