Toggle navigation

Redash Image Guide

Version 2.0

Websoft9 Redash is a pre-configured, ready to run image for running Redash on Alibaba Cloud.

Redash is an open source tool for teams to query, visualize and collaborate. Redash is quick to setup and works with any data source you might need so you can query from anywhere in no time.Share your results and dashboards with other team members and empower your entire organization to be data driven with no-code filters and parameters that instantly adjust.What we were looking for was a more hacker’ish way to look at data, so we built one.Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift (“petabyte scale data warehouse” that “speaks” PostgreSQL). Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery,Google Spreadsheets, PostgreSQL, MySQL, Graphite, Axibase Time Series Database and custom scripts.

Application Software(Redash2.0)
Redash application directory: /opt/redash

Application Server(python 2.7,nginx1.10.3,redis 3.0.6)
Apache2-mod-Python: /etc/nginx/sites-available/redash

Database(PostgreSQL9.5)
Database data directory: /var/lib/postgresql
Defualt Database information: database name:redash,usename:redash,password:null

After the installation of Image,please verify it

  • Login on Alibaba Cloud console,get you Internet IP Address
  • Open you Chrome or Firefox on your local PC,visit the http://Internet IP Address/
  • If verify successfully,you can enter the Apache default welcome page of this Image
  • If no response from browser,please check the Security Group settings to ensure that port 80 is been allowed

Using Chrome or Firefox to visit: http://Internet IP Address/ to start using this application.Following is the steps:

  1. Visit http://Internet IP Address  to enter the login in page directly.Filling the your admin configuration and then click “Setup”
  2. Redash will automatically jump to backend interface below:
  3. Setup is OK,you can use it now

Three usernames and passwords are required for application installation, application using, andapplication maintenance:

1、Trac:Username is admin password is admin
Backend URL:http://Internet IP Address/trac

2、PostgreSQL Database
Default Database information: database name:redash,usename:redash,password:null 

3、Linux Server:Username is root,Password is set by youself when buying.You can reset the password through console and restart the Server if you have forgotten it.Please Using the Putty for Remote and WinSCP for SFTP

Routine backup (archives) of the database and application setup is essential to ensure failover is smooth.

Backup is based on the server snapshot automatic backup and manual local backup in two ways, both of which have their own advantages and disadvantages, it is recommended to use together

Automatic Backup by Snapshot of Server

IaaS provider have the “snapshot” function for Server, the snapshot is for the server disk. Snapshot tool can record the specified point in time the hard disk data, all backed up, and can achieve a key recovery.

If you have an automatic snapshot of the disk settings, the following scenes you can be more calm face:

  • Work a few days of the results, was mistakenly deleted
  • Hackers damage your site
  • The content has been messed up

Done a snapshot backup, a key to restore to the backup point of time state. That is, on-site reduction, very good function.

Different cloud vendor snapshot settings slightly different, specific reference:

Before upgrade you should put the site down for maintenance and always Backup your code, data and config files.

It’s recommended to upgrade your Redash instance once there are new releases, to benefit from new features and bug fixes. The upgrade process is relatively simple, and assuming you used one of the base images we provide, you can simply run the upgrade script.

Starting from v1.0.0 or newer, the upgrade script is part of the codebase, and running the script is as simple as:

cd /opt/redash/current
sudo bin/upgrade

More details:https://redash.io/help-onpremise/maintenance/how-to-upgrade-redash.html

Login the Redash as Administrator,admin->Users-New User,you can add user easily

You can use the command to manage the services for Server.Please choose the corresponding command mode according to different types of operating system

Ubuntu Linux

  • Restart all processes: sudo supervisorctl restart all.
  • Restart the Web server: sudo supervisorctl restart redash_server.
  • Restart Celery workers: sudo supervisorctl restart redash_celery.

If you want use Domain for this application,you should complete below steps:

  • Domain resolution if you want to use (Add an A record to the Internet IP Address of Server from your Domain Control Panel)
  • Add ServerName or ServerAlias to the Apache Trac configuration file: /etc/apache2/sites-enabled/trac.conf,
    ServerName www.mydomain.com 
    ServerAlias mydomain.com
  • Restart the services

Redash plays nice with all data sources!

  • Amazon Athena
  • Amazon DynamoDB
  • Amazon Redshift
  • Axibase Time Series Database
  • BigQuery
  • Cassandra
  • ElasticSearch
  • JIRA
  • JSON
  • Google Analytics
  • Google Spreadsheets
  • Graphite
  • Greenplum
  • Hive
  • Impala
  • InfluxDB
  • Microsoft SQL Server
  • MongoDB
  • MySQL
  • Oracle
  • PostgreSQL
  • Presto
  • Python
  • ScyllaDB
  • TreasureData
  • Vertica

Also, we added an option to query other query results – this way you can enjoy a dataset from multiple data sources (originally). Read more about using datasets as data sources

When install new extension from back-end it will not successful,may be the permissions of file and folder is not appropriate,you should change it

Web site root permissions to follow:
file 644,folder 755 ,Permissions Users and groups www-data
If there is a file permissions problem, execute the following three commands:

chown -R redash.redash /opt/redash
find /opt/redash -type d -exec chmod 755 {} \;
find /opt/redash -type f -exec chmod 644 {} \;