I need help

I installed plugin on linux OS.
System not show plugin, Error failed to load plugin.

log grafana
t=2020-09-01T13:59:21+0700 lvl=warn msg="and eventually deprecating Organizations in a future Grafana release. If you would like to provide" logger=sqlstore
t=2020-09-01T13:59:21+0700 lvl=warn msg="feedback or describe your need, please do so in the issue linked below" logger=sqlstore
t=2020-09-01T13:59:21+0700 lvl=warn msg=grafana/grafana#24588 logger=sqlstore
t=2020-09-01T13:59:21+0700 lvl=info msg="Starting plugin search" logger=plugins
t=2020-09-01T13:59:21+0700 lvl=info msg="Registering plugin" logger=plugins name="Direct Input"
t=2020-09-01T13:59:21+0700 lvl=info msg="Registering plugin" logger=plugins name=Zabbix
t=2020-09-01T13:59:21+0700 lvl=info msg="Registering plugin" logger=plugins name="Zabbix Problems"
t=2020-09-01T13:59:21+0700 lvl=info msg="Registering plugin" logger=plugins name=Zabbix
t=2020-09-01T13:59:21+0700 lvl=info msg="Registering plugin" logger=plugins name=CSV
t=2020-09-01T13:59:21+0700 lvl=eror msg="Failed to load plugin" logger=plugins error="plugin "grafana-csv-plugin" is unsigned" pluginPath=/var/lib/grafana/plugins/grafana-csv-plugin/dist
t=2020-09-01T13:59:21+0700 lvl=info msg="Registering plugin" logger=plugins name=SimpleJson
t=2020-09-01T13:59:21+0700 lvl=warn msg="Some plugins failed to load" logger=plugins errors="[plugin "grafana-csv-plugin" is unsigned]"
t=2020-09-01T13:59:21+0700 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=https subUrl= socket=

We are trying to add local CSV file in linux. Gave full permissions to the file, then also same error

there is no access to file /root/hsm_stats.csv

Also made sure i copied the linux grafana-csv-plugin_linux_amd64 to the dist directory. is there anything being missed. please help

Logs:

t=2020-06-29T07:32:18-0400 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/tsdb/query status=400 remote_addr=10.25.21.122 time_ms=15 size=195 referer=http://XXXXXXXXXXXXXXXXXXXXXX:3000/datasources/edit/3/

Hi,

I have copied the grafana-CSV-plugin into my plugin-bundle of grafana-7.1.0-beta2 and taken the restart so I tried to access the new data source from the GUI, it shows only Local file access instead of both options local and remote.

Please help me with this.

Let me know in case of any queries

Hi ,
We recently upgraded to Grafana 8.2.5 and post upgrade we are unable to use this plugin we are getting 500 error from server and it says Plugin Unavailable.
Log Snippet -
t=2021-12-14T13:21:26+0000 lvl=eror msg="Metric request error" logger=context userId=12345 orgId=12345 uname=[email protected] error="plugin unavailable" remote_addr=0.0.0.0
t=2021-12-14T13:21:26+0000 lvl=eror msg="Request Completed" logger=context userId=12345 orgId=12345uname=[email protected] method=POST path=/api/tsdb/query status=500 remote_addr=0.0.0.0time_ms=23 size=58

Any Idea what could be the issue ?

For example below is the csv file ;

name,age
varun, 30
aswini,29

if select this as datasource and also Time series instead of Table data
then only numeric values are displayed

Hello, the plugin is great but unfortunately it doesn't work with grafana version 8.x

Hi Pavel,

I am using grafana 6.4.7 for testing.
I have simple csv

cdatetime;id;name;address;postal;city;org_id;location_id;PIB;gov_id;lan_ip;cpe_ip;latitude;longitude;org_type;conn_type
01/01/20 00:00;1;aaa;addr1;24430;a1;199;802;101092309;8018731;10.85.208.0/21;172.31.8.1;45797482;20134519;test1;testconn
02/01/20 00:00;2;bbb;tret 47;24430;b1;1332;807;100983199;8018499;10.98.252.0/22;172.31.8.2;45790701;20129339;test12;testconn
03/01/20 00:00;3;cccc;sdasdas;24430;c1;1332;807;100983199;8018499;10.98.252.0/22;172.31.8.2;45790701;20129339;test13;testconn

When I make a dashboard with query: SELECT * FROM csv_test LIMIT 10
the data is shown fine and cdatetime field seems to be parsed as unix epoch time:

however if I want do any query using frield cdatetime date fails with message:

Query failed: no such column: cdatetime

For example, queries like: SELECT * FROM csv_test WHERE $__timeFilter(cdatetime) LIMIT 10 or SELECT * FROM csv_test WHERE cdatetime > 0 LIMIT 10

Queries on any other field work ok. Any ideas?

Many thanks!

Hi,
you're plugin is working well with Table Visualization, is it possible to use the Graph one ? I tried to use timestamps as first field but no luck.

Thank you !

We have the DS as Linux local file, permissions all looks good. We have added the linux distribution to the plugin directory already, not sure what is wrong.

Error: Logs just shows 400error and nothing else

Logs:
t=2020-06-30T01:04:03-0400 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/tsdb/query status=400 remote_addr=XX.XX.XX.XXX time_ms=32 size=293 referer="http://XXXXXXXXXXXXXXXX:3000/d/xLK9PiMGz/hsm-dashboard?inspect=23763571993&inspectTab=query&editPanel=2&tab=error&orgId=1"

Plugin Dir:

I can see my CSV contents in explore, but not executing the query.

If i run query, it throws error.

DS Details:

Grafana Version: 7.0.3

Getting Metric Request Error while adding File with Datasource Plugin.

I have a csv with spaces in the headers and comma as delimiter and I can add the datasource correctly but get an error while trying to explore the data stating there are multiple files with the same name. It looks like it's using the comma delimiter and space to separate out the fields. This needs to be corrected.

Just installed on MacOS (11.0.1) and received the following error:

EROR[12-11|15:46:59] Failed to start plugin logger=plugins.backend pluginId=grafana-csv-plugin error="fork/exec /usr/local/var/lib/grafana/plugins/grafana-csv-plugin-develop/dist/grafana-csv-plugin_darwin_amd64: no such file or directory"

There appears to be a linux/amd64 and a windows/amd64 build but no darwin.

Hi,
When i create my datasource with the grafana-csv-plugin, i obtain this message :

DataSource Updated
NameDB plugin failed
Error: [$injector:unpr] unknown provider: variableSrvProvider >- variableSrv http://errors.angularjs.org/1.6.9/$injector/unpr?p0=variableSrvProvider%20%3C-%20variableSrv

Grafana version : 7.1.5

Any idea ?

Hello,

We have used CSV to create multiple variables and variables are depend other to form cascading filters.
For example: we have 5 varaibles, Country -> State -> City -> area -> building
Selecting country will refresh all other variables to display only relavent values.

The issue is when user change Country then it will download CSV five times to refresh all other variables.

Is there way to download CSV file only at Dashboard load or at set frequency. and use CSV from temp working location.
Downloading everytime is making dashboard unusable.

Thank you for your help in advance.

-Vikram

Hi team,

I am getting below mentioned error while trying to test the CSV integration with grafana,

ssh: handshake failed: ssh: unable to authenticate, attempted methods [none password], no supported methods remain

please help me with this.

Install

• Copy files from the dist folder to your Grafana plugin directory
  -----Copied the content of the dist folder to C:\Program Files\GrafanaLabs\grafana\data\plugins

• Ensure that executable file has the execute flag
  -----What does the mean for windows users?

• Restart Grafana

• Check datasource list as http://you-grafana/datasources/new
  ------what should we look for here? I searched for 'CSV' ..nothing showed up

If I understand the install instructions, I need to download the darwin binary and make sure it is executable.

Do you know where the plugin directory is when you install grafana via homebrew?

I was trying to set it up in my windows local machine. I gave the path as my window dir - D:\xxx.csv, but it says validation error.

Grafana Version: v7.0.3

Logs:
Log:
t=2020-06-23T06:56:43-0400 lvl=eror msg=“Validation error, invalid URL: “D:\alertisite\hsm_stats.csv”” logger=context userId=1 orgId=1 uname=admin error=“Validation of data source URL “http://D:\\alertisite\\hsm_stats.csv” failed: parse “http://D:\\alertisite\\hsm_stats.csv”: invalid port “:\alertisite\hsm_stats.csv” after host” remote_addr=[::1]

Is this an issue with how I have it configured or something else?

Hi Pavel,

Not able to visualize the time series data which is similar to the data coming from a sensor. Please see the actual csv file in the attachment.
https://drive.google.com/file/d/1BhDHXhbOlp9G9QGhSjQ6mgzNaKq-2aCM/view?usp=sharing

The issue, in detail is mentioned in the below link by user harish1992mech
https://community.grafana.com/t/csv-as-datasource/18520/23

Thank you,
Harish

Hi!

Could you please consider adding support for variables?

We have some graphs that we would like to repeat for the different values of a dashboard variable, but the value doesn't get replaced in the query. Otherwise, I would have to copy and paste the same panel 22 times, and if I change something re-do again 22 times the modification.

For example, if I define a variable $myvar that has values val1 selected, and then use the query for a panel SELECT field FROM table WHERE column="$myvar", $myvar doesn't get replaced by val1.

Maybe this link could be useful: https://grafana.com/docs/grafana/latest/developers/plugins/add-support-for-variables/

Thank you!

hi

i'm trying to use this plugin
i'm testing with SacramentocrimeJanuary2006.csv file an i have Metric request error

i'm testing with local files on a windows os

C:/Users/loubarisr/Documents/SacramentocrimeJanuary2006.csv

t=2020-11-16T09:09:29+0100 lvl=eror msg="Metric request error" logger=context userId=1 orgId=1 uname=admin error="Could not find executor for data source type: grafana-csv-plugin" remote_addr=[::1]

thanks in advance

Hi

After following these steps given in Readme. can't see plugin under grafana datasources/new

Reading through the previous issues/wiki - are you able to add support for the newest Grafana please?

Hi Pavel,

I try to install your plugin in the grafana 7.2.0 running in the docker container.
It seems that the plugin is installed:

t=2020-10-09T21:18:47+0000 lvl=warn msg="Running an unsigned backend plugin" logger=plugins pluginID=grafana-csv-plugin pluginDir=/var/lib/grafana/plugins/grafana-csv-plugin
t=2020-10-09T21:18:47+0000 lvl=info msg="Registering plugin" logger=plugins name=CSV
t=2020-10-09T21:18:47+0000 lvl=info msg="Registering plugin" logger=plugins name="Map Panel"
t=2020-10-09T21:18:47+0000 lvl=info msg="Registering plugin" logger=plugins name="Pie Chart"
t=2020-10-09T21:18:47+0000 lvl=info msg="Registering plugin" logger=plugins name=SimpleJson
t=2020-10-09T21:18:48+0000 lvl=info msg="Backend rendering via external http server" logger=rendering renderer=http
t=2020-10-09T21:18:48+0000 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl=/web_ui_test socket=
t=2020-10-09T21:18:48+0000 lvl=warn msg="Plugin uses a deprecated version of Grafana's backend plugin system which will be removed in a future release. Consider upgrading to a newer plugin version or reach out to the plugin repository/developer and request an upgrade." logger=plugins.backend pluginId=grafana-csv-plugin

However, I see this error in the UI. The same result is when using 7.2.0 or 7.2.1.
If I use grafana 6.7.4 container, the datasource works.

Is it possible to resolve this issue with grafana 7.2 version?

Thanks!

Plugin uses a deprecated version of Grafana's backend plugin system which will be removed in a future release.
Consider upgrading to a newer plugin version or reach out to the plugin repository/developer and request an upgrade.