vertica/vertica-grafana-datasource-.2.0

This project defines the official Vertica datasource plugin for Grafana.

This repository is deprecated and replaced by https://github.com/vertica/vertica-grafana-datasource.

vertica-grafana-datasource

Overview

This is a work-in-progress Grafana plugin to support the Vertica database.

It defines a new datsource that communicates with Vertica using the Vertica golang driver. [http://github.com/vertica/vertica-sql-go]. Due to this, we needed to implement both front and and back end components using the largely-undocumented backend framework.

Setting Up Your Development Environment

1. Set up a Go development environment with the appropriate GOROOT and GOPATH envrionment variables.
2. Download Grafana itself and build it per their instructions. [http://github.com/grafana/grafana]
3. Install npm [http://nodejs.org]
4. Install dep [https://github.com/golang/dep]
5. Start Grafana once by running the grafana-server binary you built in step 2.
6. Create a symbolic link from the Grafana's plugin directory to this project's 'dist' directory thusly:

ln -s (this_dir)/dist (grafana_dir)/data/plugins/vertica-grafana-datasource 

Note: If using Grafana 7.0.0, it now requires signed plugins and recommends updating plugins to use the new framework. The Vertica plugin is unsigned and currently doesn't use the new framework, so you will need to add the following configuration parameter to the /etc/grafana/grafana.ini file in the [plugins] section for it to load. Restart the Grafana server after adding this change. allow_loading_unsigned_plugins = vertica-grafana-datasource

Note: Grafana plans on depricating and eventually removing the ability to run unsigned plugins. Once they remove the ability this configuration parameter and the Vertica grafana datasource plugin will no longer work.

Logging

You can enable backend logging by setting two variables. On your Grafana server node...

export VERTICA_GRAFANA_LOG_FILE=(log file name)
export VERTICA_GRAFANA_LOG_LEVEL=[ DEBUG|INFO|ERROR|WARN|FATAL ] (default is INFO)

After that, you can simply watch the log file.

Using Grafana Docker Image

It is possible to run the grafana/grafana Docker image instead of a local grafana-server binary.

1. Build the drivers source
   • dep ensure
   • Building on Linux?

     ./build.sh
     

   • Otherwise

     cd backend
     GOOS=linux go build -o ../dist/vertica-grafana-datasource_linux_amd64
     cd ..
     

2. Start the grafana Docker image
   • docker-compose up -d
3. Confirm that server has started
   • docker-compose logs
4. Open web browser to localhost:30000/
5. Cleanup the container, after testing
   • docker-compose down -v

Rapid Development Cycle

1. Make your code changes.
2. Run './build.sh'
3. Ctrl-C and re-run grafana-server
4. Repeat until tired.

vertica-grafana-datasource-.2.0's Issues

can we raise bugs?

Hi,

I recently started to use your data source in grafana, I am going to use it for demo purposes.
Can we raise bugs in this stage of the project?

Sameer

Datasource fails to load when log file cannot be written

When VERTICA_SQL_GO_LOG_FILE refers to a file that cannot be modified (or is invalid) the driver crashes

permission for commit request

Hi ,

I want to add support of variable repeating in grafana Vertica data source. I tried to push a local branch and it seems i do not have permission. Can you please point me the process of contribution.

Thanks
Sameer

Issue with null-in-columns due to change in vertica-sql-go driver

It causes a crash now.

Vertica DS does not support repeating

Right now if one has to repeat a panel using the panel repeater option in Grafana, the query fails.
Reason being instead of passing a single value we have all the values "{'value1','value2'}" in template variable.

I would like to fix this issue in code but I am new to open source. Please let me know if you have any guidelines. I will update once I have a fix too.