Summary
Grafana is a standard part of the CryptoSpike server installation that renders reports.
End user may have another, standalone, instance of Grafana, outside of CryptoSpike server, that can be used to deliver CrypoSpike reports.
Step-by-Step
To point standalone Grafana instance to the Datasources (ClickHouse, MySQL) on the SryptoSpike server, we need to validate following items:
1) Standalone Grafana version and corresponding Plugin versions should match default CryptoSpike installation.
Current CryptoSpike virsion 2.0.2.97 contains following components: Grafana v6.7.3, vertamedia-clickhouse-datasource v1.9.5, briangann-datatable-panel v1.0.1.
Note: While process of pointing CS Datasources to standalone Grafana instance should be the same, future CryptoSpike version may contain different versions of these components, and example below should be modified accordingly to point to the correct versions of Grafana and Plugins. End-user should also evaluate impact of these updates on standalone Grafana.
Following plugins are modified specifically for CryptoSpike by ProLion.
We need to update standalone Grafana v6.7.3 with following plugins:
grafana-cli --insecure --pluginUrl https://cryptospike.prolion.at/third/Vertamedia-clickhouse-grafana-v2.0.0-0.zip plugins install vertamedia-clickhouse-datasource
grafana-cli --insecure --pluginUrl https://cryptospike.prolion.at/third/briangann-grafana-datatable-panel-v1.0.1-1.zip plugins install briangann-datatable-panel
2) By default, ClickHouse on the CryproSpike server is listening on localhost connection.
Following change should be performed to allow listening on all connections.
a) Edit /etc/clickhouse-server/config.xml on the CryptoSpike server
from:
<listen_host>::1</listen_host>
<listen_host>127.0.0.1</listen_host>
to:
<listen_host>::</listen_host>
<listen_host>0.0.0.0</listen_host>
b) Restart ClickHouse service
service clickhouse-server restart
3) By default, MySQL listening on all connections.
You can validate this by checking bind address in configuration file: /etc/mysql/mariadb.conf.d/50-server.conf:
bind-address = 0.0.0.0