Home Assistant Community Add-on: Grafana

:tada: Release v4.0.1

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Upgrades nginx to 1.14.0-0ubuntu1.7
  • :arrow_up: Upgrades Grafana to v6.5.3

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

:tada: Release v4.1.0

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Upgrades Grafana to v6.6.0

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

Giving this another try. Anyone have some info about the grafana-image-renderer plugin? Is it at all possible with the Home Assistant addon? Is it possible with a RPi?

@frenck; sorry to bother, but I guess you would be able to shed some light on this question?

Thanks in advance!

It is not possible to use that on a Pi at this point.

1 Like

Ok, thank you frenck!

I tried to start grafana add-on (ver 4.1.0) in hassio ver. 0.150.1. It is installed (along with influxdb add-on). But donā€™t start
Several last lines of log:

t=2020-02-10T11:35:43+0100 lvl=info msg="Executing migration" logger=migrator id="add unique index data_source.account_id_name"
t=2020-02-10T11:35:51+0100 lvl=info msg="Shutdown started" logger=server reason="System signal: terminated"
Signal handled: Terminated.
[cont-finish.d] executing container finish scripts...
[cont-finish.d] 99-message.sh: executing... 
t=2020-02-10T11:35:51+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_data_source_account_id - v1"
[cont-finish.d] 99-message.sh: exited 0.
[cont-finish.d] done.
[s6-finish] waiting for services.
t=2020-02-10T11:35:52+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_data_source_account_id_name - v1"
t=2020-02-10T11:35:53+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table data_source to data_source_v1 - v1"
s6-svwait: fatal: timed out
[s6-finish] sending all processes the TERM signal.
t=2020-02-10T11:35:55+0100 lvl=info msg="Shutdown started" logger=server reason="System signal: terminated"

It seems Grafana got terminate signal. But why ? From witch part of system ? How can I check it and correct?

Wojtek

It started after upgrading system from HassOS 3.9 to HassOS 3.10

WZ

Hi All,

I have a hopefully easy question here. Iā€™m trying to change the default password for the admin account and I canā€™t figure out how to do it. If I try to change it in the Grafana Web UI it says ā€œYou cannot change password when ldap or auth proxy authentication is enabled.ā€ I tried to use the env_vars like this but thatā€™s not working either.

plugins: []
env_vars:
  - name: GF_SECURITY_ADMIN_PASSWORD
    value: test
ssl: true
certfile: fullchain.pem
keyfile: privkey.pem

Can someone tell me what Iā€™m doing wrong? Thanks in advance!

Hello,

I cannot make this plugin run on my Home Assistant RPi3 installation. It constantly gets a termination signalā€¦by why? What could I check? When I start the add-on the system has more than 400 Mb free, so i donā€™t think that itā€™s a memory issue.

Any suggestion is highly appreciated!

Thanks,
Ugo

This is the log that I get when I enable ā€œdebugā€ mode:

> [s6-init] making user provided files available at /var/run/s6/etc...exited 0.
> [s6-init] ensuring user provided files have correct perms...exited 0.
> [fix-attrs.d] applying ownership & permissions fixes...
> [fix-attrs.d] done.
> [cont-init.d] executing container initialization scripts...
> [cont-init.d] 00-banner.sh: executing... 
> -----------------------------------------------------------
>  Hass.io Add-on: Grafana
>  The open platform for beautiful analytics and monitoring
> -----------------------------------------------------------
>  Add-on version: 4.1.0
>  You are running the latest version of this add-on.
>  System: HassOS 3.11  (armv7 / raspberrypi3)
>  Home Assistant version: 0.105.5
>  Supervisor version: 201
> -----------------------------------------------------------
>  Please, share the above information when looking for help
>  or support in, e.g., GitHub, forums or the Discord chat.
> -----------------------------------------------------------
> [cont-init.d] 00-banner.sh: exited 0.
> [cont-init.d] 01-log-level.sh: executing... 
> Log level is set to DEBUG
> [cont-init.d] 01-log-level.sh: exited 0.
> [cont-init.d] grafana.sh: executing... 
> [cont-init.d] grafana.sh: exited 0.
> [cont-init.d] nginx.sh: executing... 
> [cont-init.d] nginx.sh: exited 0.
> [cont-init.d] done.
> [services.d] starting services
> [services.d] done.
> [10:55:43] INFO: Starting Memcached...
> [10:55:45] INFO: Starting Grafana...
> t=2020-02-21T10:56:32+0100 lvl=info msg="Starting Grafana" logger=server version=6.6.0 commit=5c11bbdfb4 branch=HEAD compiled=2020-01-27T13:32:03+0100
> t=2020-02-21T10:56:32+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
> t=2020-02-21T10:56:32+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
> t=2020-02-21T10:56:32+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
> t=2020-02-21T10:56:32+0100 lvl=info msg="Path Data" logger=settings path=/data
> t=2020-02-21T10:56:32+0100 lvl=info msg="Path Logs" logger=settings path=/var/logs/grafana
> t=2020-02-21T10:56:32+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
> t=2020-02-21T10:56:32+0100 lvl=info msg="Path Provisioning" logger=settings path=/usr/share/grafana/conf/provisioning
> t=2020-02-21T10:56:32+0100 lvl=info msg="App mode production" logger=settings
> t=2020-02-21T10:56:32+0100 lvl=info msg="Initializing SqlStore" logger=server
> t=2020-02-21T10:56:32+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
> t=2020-02-21T10:56:33+0100 lvl=info msg="Starting DB migration" logger=migrator
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Skipping migration: Already executed" logger=migrator id="create migration_log table"
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Skipping migration: Already executed" logger=migrator id="create user table"
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Skipping migration: Already executed" logger=migrator id="add unique index user.login"
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Skipping migration: Already executed" logger=migrator id="add unique index user.email"
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Skipping migration: Already executed" logger=migrator id="drop index UQE_user_login - v1"
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Skipping migration: Already executed" logger=migrator id="drop index UQE_user_email - v1"
> t=2020-02-21T10:56:37+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table user to user_v1 - v1"
> t=2020-02-21T10:56:37+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="Rename table user to user_v1 - v1" sql="ALTER TABLE `user` RENAME TO `user_v1`"
> t=2020-02-21T10:56:39+0100 lvl=info msg="Executing migration" logger=migrator id="create user table v2"
> t=2020-02-21T10:56:39+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="create user table v2" sql="CREATE TABLE IF NOT EXISTS `user` (\n`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL\n, `version` INTEGER NOT NULL\n, `login` TEXT NOT NULL\n, `email` TEXT NOT NULL\n, `name` TEXT NULL\n, `password` TEXT NULL\n, `salt` TEXT NULL\n, `rands` TEXT NULL\n, `company` TEXT NULL\n, `org_id` INTEGER NOT NULL\n, `is_admin` INTEGER NOT NULL\n, `email_verified` INTEGER NULL\n, `theme` TEXT NULL\n, `created` DATETIME NOT NULL\n, `updated` DATETIME NOT NULL\n);"
> t=2020-02-21T10:56:40+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_login - v2"
> t=2020-02-21T10:56:40+0100 lvl=dbug msg="Executing migration condition sql" logger=migrator id="create index UQE_user_login - v2" sql="SELECT 1 FROM `sqlite_master` WHERE `type`='index' AND `tbl_name`=? AND `name`=?" args="[user UQE_user_login]"
> t=2020-02-21T10:56:40+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="create index UQE_user_login - v2" sql="CREATE UNIQUE INDEX `UQE_user_login` ON `user` (`login`);"
> t=2020-02-21T10:56:43+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_email - v2"
> t=2020-02-21T10:56:43+0100 lvl=dbug msg="Executing migration condition sql" logger=migrator id="create index UQE_user_email - v2" sql="SELECT 1 FROM `sqlite_master` WHERE `type`='index' AND `tbl_name`=? AND `name`=?" args="[user UQE_user_email]"
> t=2020-02-21T10:56:43+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="create index UQE_user_email - v2" sql="CREATE UNIQUE INDEX `UQE_user_email` ON `user` (`email`);"
> t=2020-02-21T10:56:45+0100 lvl=info msg="Executing migration" logger=migrator id="copy data_source v1 to v2"
> t=2020-02-21T10:56:45+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="copy data_source v1 to v2" sql="INSERT INTO `user` (`login`\n, `name`\n, `salt`\n, `rands`\n, `is_admin`\n, `id`\n, `version`\n, `email`\n, `password`\n, `company`\n, `org_id`\n, `created`\n, `updated`) SELECT `login`\n, `name`\n, `salt`\n, `rands`\n, `is_admin`\n, `id`\n, `version`\n, `email`\n, `password`\n, `company`\n, `account_id`\n, `created`\n, `updated` FROM `user_v1`"
> Signal handled: Terminated.
> t=2020-02-21T10:56:46+0100 lvl=info msg="Shutdown started" logger=server reason="System signal: terminated"
> t=2020-02-21T10:56:46+0100 lvl=info msg="Executing migration" logger=migrator id="Drop old table user_v1"
> t=2020-02-21T10:56:46+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="Drop old table user_v1" sql="DROP TABLE IF EXISTS `user_v1`"
> [cont-finish.d] executing container finish scripts...
> t=2020-02-21T10:56:49+0100 lvl=info msg="Executing migration" logger=migrator id="Add column help_flags1 to user table"
> t=2020-02-21T10:56:49+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="Add column help_flags1 to user table" sql="alter table `user` ADD COLUMN `help_flags1` INTEGER NOT NULL DEFAULT 0 "
> [cont-finish.d] 99-message.sh: executing... 
> t=2020-02-21T10:56:50+0100 lvl=info msg="Executing migration" logger=migrator id="Update user table charset"
> t=2020-02-21T10:56:50+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="Update user table charset" sql="-- NOT REQUIRED"
> [cont-finish.d] 99-message.sh: exited 0.
> [cont-finish.d] done.
> [s6-finish] waiting for services.
> t=2020-02-21T10:56:53+0100 lvl=info msg="Executing migration" logger=migrator id="Add last_seen_at column to user"
> t=2020-02-21T10:56:53+0100 lvl=dbug msg="Executing sql migration" logger=migrator id="Add last_seen_at column to user" sql="alter table `user` ADD COLUMN `last_seen_at` DATETIME NULL "
> t=2020-02-21T10:56:55+0100 lvl=info msg="Executing migration" logger=migrator id="Add missing user data"
> t=2020-02-21T10:56:55+0100 lvl=dbug msg="Executing code migration" logger=migrator id="Add missing user data"
> s6-svwait: fatal: timed out
> [s6-finish] sending all processes the TERM signal.
1 Like

:tada: Release v4.2.0

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :books: Update add-on documentation to use new YAML configuration format
  • :hammer: Update add-on config with new password & list features
  • :hammer: Updates for upstream Supervisor changes
  • :hammer: Re-branding
  • :arrow_up: Upgrades Grafana to v6.6.2
  • :arrow_up: Upgrades add-on base image to v5.0.1
  • :hammer: Update community forum links

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

Hi, this is my first time trying to install Grafana in Hassio through the add-on store. I already installed, uninstalled several times but I canā€™t get Grafana to start at all and I have absolutely nothing about it in the logs. I am trying with last version (4.2.0). I am not sure how to proceed. Any help?

UPDATE to my previous post: my issue has been fixed by the new version 4.2.0. Thank you frenck!

1 Like

Hello,
I have my setup working with Grafana addon.
I have both grafana added to the side bar and some graph linked with iframe card.
However in orded to have the iframe card working, i need to enter grafana through the sidebar first.
If not I have a ā€œ401: Unauthorizedā€ error.

I guess itā€™s linked to ingress, and I understand i should get access trough port 3000 to solve the issue.
However I would prefer not to expose Grafana to internet directly opening another port for external access.

Is there a workaround?

Thanks

Matteo

Hi everybody,

everything works great with Grafana but there is one thing I just canā€™t get solved.

In my graphs the line is cut off at the front if it has the same value over a longer period. In the first screenshot I set the time range to 12h and the line is cut off at the front. In the second screenshot I set the time range to 24h and everything is shown completely.

Is there a possibility that the full lines are always displayed, even if they do not change over a longer period of time?

Thanks for your help.

Same question here. It is recommended in the documentation to change this default password but I am unable to do so. Get the same message described above. Does this need to be changed via ENV variable? @frenck

@petewill @stephack
I have the same issue being unable to change the default password, getting exact same error message.
Have you managed to change the password?

Nope. Unfortunately not.

:tada: Release v4.2.1

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Upgrades Grafana to v6.7.1

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

@frenck - you may be aware of this docker solution to rendering images from Grafana on ARM devices. Is this a possible solution for the add-on? https://github.com/grafana/grafana-image-renderer/blob/6ac82cf90509b89f12e7bc7100593784d3c9b741/docs/remote_rendering_using_docker.md I might have misunderstood the problem though.

@petewill @stephack @dknt

Regarding changing admin password from default. I opened a issue for this:

FYI, I found a workaroundā€¦ I was able to manually change password via the following, but Iā€™m not sure the change will survive a container update, but it does survive a container restart.

From hass terminal run:

# Get into grafana docker container
docker exec -it $(docker ps | grep grafana | awk '{print $1}') /bin/bash
# Run set password command
grafana-cli admin reset-admin-password mynewpassword
2 Likes