Grafana add-on and CSV grafana-plugin

Configuration
1

Hello
I use grafana add on in my hass coupled with influxDB with no problems.

Since I have old data in CSV files, I would like to create a new data source in grafana with this CSV file.
CSV grafana-plugin has been installed without problem, and CSV file recognised (test success).

But… when i want to start creating requests in dashboard, I receive an error message :
“local mode has been disabled by your administrator”

The first googled answers are I would need to set a variable “allow_local_mode = true” in grafana config.ini file:

[plugin.marcusolsson-csv-datasource]
allow_local_mode = true

What is the correct way to do this configuration within home assistant (running on rasp) ?

Thanks for your help :slight_smile:

2

Found the solution for other people if needed.

This variable can be set in home assistant by editing the grafana add-on, and a new environment variable.

When edited in yaml mode, this gives:

env_vars:

  • name: GF_PLUGIN_ALLOW_LOCAL_MODE
    value: “true”

Then grafan add-on needs to be restarted and the local mode error message disappears.

1 Like
3

Hi,
In my case I have this env var:

  • name: GF_PLUGIN_ALLOW_LOCAL_MODE
    value: “true”
  • name: GF_PLUGIN_MARCUSOLSSON_CSV_DATASOURCE_ALLOW_LOCAL_MODE
    value: “true”
    And I see in the register:

[11:56:33] INFO: Setting GF_PLUGIN_ALLOW_LOCAL_MODE to true
[11:56:33] INFO: Setting GF_PLUGIN_MARCUSOLSSON_CSV_DATASOURCE_ALLOW_LOCAL_MODE to true
Grafana server is running with elevated privileges. This is not recommended
logger=settings t=2022-11-28T11:56:34.041842379+01:00 level=info msg=“Starting Grafana” version=9.2.4 commit=64017e8ca6 branch=HEAD compiled=2022-11-08T11:38:42+01:00
logger=settings t=2022-11-28T11:56:34.042609305+01:00 level=info msg=“Config loaded from” file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2022-11-28T11:56:34.042774768+01:00 level=info msg=“Config loaded from” file=/etc/grafana/grafana.ini
logger=settings t=2022-11-28T11:56:34.042851731+01:00 level=info msg=“Path Home” path=/usr/share/grafana
logger=settings t=2022-11-28T11:56:34.042916805+01:00 level=info msg=“Path Data” path=/data
logger=settings t=2022-11-28T11:56:34.042981564+01:00 level=info msg=“Path Logs” path=/var/logs/grafana
logger=settings t=2022-11-28T11:56:34.043048138+01:00 level=info msg=“Path Plugins” path=/var/lib/grafana/plugins
logger=settings t=2022-11-28T11:56:34.043116582+01:00 level=info msg=“Path Provisioning” path=/usr/share/grafana/conf/provisioning

But I don`t know where to put my CSV file in order to acces the CSV from the Data source of Grafana!!!

My system is:

Add-on version: 8.1.0
You are running the latest version of this add-on.
System: Home Assistant OS 9.3 (aarch64 / raspberrypi4-64)
Home Assistant Core: 2022.11.4
Home Assistant Supervisor: 2022.11.2

Can someone help-me?? Where must I put the CSV file in my hassio system?? And the path in the data source is Full path or relative path??
Thanks a lot
\Marga

4

I have the same problem. The CSV plugin does not recognize the path to a local file. Did you solve?