Logserver - Data Visualization

 Data Visualization with Redash

While the included Yarra LogViewer provides access to all collected data in tabular form, it is often desired to visualize data or to perform advanced queries. This can be done with Redash, which is a web-based open-source tool for creating SQL-driven dashboards.

 More information on Redash

Please use only the Self Hosted Open Source version of Redash. Do not use the hosted cloud version, as this would transfer sensitive data to external cloud servers.

To get you up and running quickly, we have built several basic “seed” dashboards for Redash. These dashboards have been tested to work with Redash version 2.0.1.b3080. Therefore, it is best to first install our dashboard set with this Redash version and then upgrade to the newest Redash version.

The following instructions assume that you are running Redash on the same machine as Yarra LogServer, and they will not work with an existing Redash installation.

To get started, first install Redash 2.0.1.b3080. It might be prudent to run the provisioning script that was released with v2.0.1 rather than the one on the master branch.

Invoke the provisioning script like this:

REDASH-VERSION=2.0.1.b3080 ./bootstrap.sh

and create your administrator account. To insert our dashboards, run:

cd /opt/yarralogserver/redash && sudo ./install_dashboards.sh

It will prompt you for a password for a database role that Redash will use to query the LogServer database.

Verify that the installation has worked by logging into your Redash instance at localhost, navigating to the “Dashboards” page, and loading a dashboard. There may be no data but there should at least be no error messages.

Now, you should upgrade to the latest Redash by following the official upgrade instructions.