openHABian influxdb+grafana installation error

  • Platform information:
    • Hardware: Rpi4/4g
    • OS: openHABian Configuration Tool — [openHAB3]{2021-07-28T12:25:04+02:00}(1f4f1ce)
    • Java Runtime Environment: which java platform is used and what version
    • openHAB version: 3.1.0

tried to install influxdb+grafana from openhabian-config (menu 24), in the end i got an error:

There was an error or interruption during the execution of:
“20 | Optional Components”\n\nPlease try again. If the error persists, please read /opt/openhabian/docs/openhabian-DEBUG.md or openhabian/openhabian-DEBUG.md at main · openhab/openhabian · GitHub how to proceed."

here’s debug (the part i was able to copy from terminal…):

+ openhab_is_running
+ openhab_is_installed
+ openhab2_is_installed
++ dpkg -s openhab2
++ grep Status
++ cut '-d ' -f2
+ [[ '' == \i\n\s\t\a\l\l ]]
+ return 1
+ openhab3_is_installed
++ dpkg -s openhab
++ grep Status
++ cut '-d ' -f2
+ [[ install == \i\n\s\t\a\l\l ]]
+ return 0
+ return 0
++ systemctl is-active openhab
+ [[ active == \a\c\t\i\v\e ]]
+ return 0
+ whiptail --title 'Setup openHAB integration' --yes-button Yes --no-button No --yesno 'openHAB can use InfluxDB for persistant storage, shall InfluxDB be configured with openHAB?\n\nA new config file for openHAB will be created with basic settings.' 10 80
+ integrationOH=true
+ [[ -z '' ]]
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2021-08-04_14:25:41_CEST [openHABian] Installing InfluxDB... '
2021-08-04_14:25:41_CEST [openHABian] Installing InfluxDB... + cond_redirect influxdb_install admin password
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ influxdb_install admin password \033[39;49;00m'

$ influxdb_install admin password
+ influxdb_install admin password
+ local address
+ local adminUsername
+ local adminPassword
+ local myOS
+ local myRelease
+ address=http://localhost:8086
+ adminUsername=admin
+ adminPassword=password
+ is_pi
+ is_pifour
+ [[ '' == \p\i\4 ]]
+ grep -q '^Revision\s*:\s*[ 123][0-9a-fA-F][0-9a-fA-F][0-9a-fA-F]11[0-9a-fA-F]$' /proc/cpuinfo
+ return 0
+ return 0
+ myOS=debian
++ lsb_release -sc
+ myRelease=buster
+ is_bullseye
+ [[ '' == \b\u\l\l\s\e\y\e ]]
++ cat /etc/os-release
+ [[ PRETTY_NAME="Raspbian GNU/Linux 10 (buster)"
NAME="Raspbian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs" =~ bullseye ]]
+ return 1
+ [[ buster == \n\/\a ]]
+ dpkg -s influxdb
+ add_keys https://repos.influxdata.com/influxdb.key
+ local repoKey
++ mktemp /tmp/openhabian.XXXXX
+ repoKey=/tmp/openhabian.eHE90
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2021-08-04_14:25:42_CEST [openHABian] Adding required keys to apt... '
2021-08-04_14:25:42_CEST [openHABian] Adding required keys to apt... + cond_redirect wget -qO /tmp/openhabian.eHE90 https://repos.influxdata.com/influxdb.key
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ wget -qO /tmp/openhabian.eHE90 https://repos.influxdata.com/influxdb.key \033[39;49;00m'

$ wget -qO /tmp/openhabian.eHE90 https://repos.influxdata.com/influxdb.key
+ wget -qO /tmp/openhabian.eHE90 https://repos.influxdata.com/influxdb.key
+ return 0
+ cond_redirect apt-key add /tmp/openhabian.eHE90
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ apt-key add /tmp/openhabian.eHE90 \033[39;49;00m'

$ apt-key add /tmp/openhabian.eHE90
+ apt-key add /tmp/openhabian.eHE90
OK
+ return 0
+ echo OK
OK
+ rm -f /tmp/openhabian.eHE90
+ echo 'deb https://repos.influxdata.com/debian buster stable'
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2021-08-04_14:25:43_CEST [openHABian] Installing InfluxDB... '
2021-08-04_14:25:43_CEST [openHABian] Installing InfluxDB... + cond_redirect apt-get update
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ apt-get update \033[39;49;00m'

$ apt-get update
+ apt-get update
Hit:1 http://davesteele.github.io/comitup/repo comitup InRelease
Hit:2 http://archive.raspberrypi.org/debian buster InRelease
Hit:3 http://raspbian.raspberrypi.org/raspbian buster InRelease
Get:4 https://repos.influxdata.com/debian buster InRelease [4,737 B]
Hit:5 https://deb.nodesource.com/node_14.x buster InRelease
Hit:6 https://openhab.jfrog.io/artifactory/openhab-linuxpkg stable InRelease
Get:7 https://repos.influxdata.com/debian buster/stable armhf Packages [928 B]
Fetched 5,665 B in 2s (2,356 B/s)
Reading package lists... Done
W: Target Packages (main/binary-armhf/Packages) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Translations (main/i18n/Translation-en_GB) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Translations (main/i18n/Translation-en) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Translations (main/i18n/Translation-en_GB.UTF-8) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Packages (main/binary-armhf/Packages) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Translations (main/i18n/Translation-en_GB) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Translations (main/i18n/Translation-en) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
W: Target Translations (main/i18n/Translation-en_GB.UTF-8) is configured multiple times in /etc/apt/sources.list.d/openhab-linuxpkg.list:7 and /etc/apt/sources.list.d/openhab.list:1
+ return 0
+ cond_redirect apt-get install --yes influxdb
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ apt-get install --yes influxdb \033[39;49;00m'

$ apt-get install --yes influxdb
+ apt-get install --yes influxdb
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  influxdb
0 upgraded, 1 newly installed, 0 to remove and 30 not upgraded.
Need to get 50.7 MB of archives.
After this operation, 135 MB of additional disk space will be used.
Get:1 https://repos.influxdata.com/debian buster/stable armhf influxdb armhf 1.8.7-1 [50.7 MB]
Fetched 50.7 MB in 3s (14.6 MB/s)
Selecting previously unselected package influxdb.
(Reading database ... 56105 files and directories currently installed.)
Preparing to unpack .../influxdb_1.8.7-1_armhf.deb ...
Unpacking influxdb (1.8.7-1) ...
Setting up influxdb (1.8.7-1) ...
Created symlink /etc/systemd/system/influxd.service → /lib/systemd/system/influxdb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/influxdb.service → /lib/systemd/system/influxdb.service.
Processing triggers for man-db (2.8.5-2) ...
Updating FireMotD available updates count ...
+ return 0
+ echo OK
OK
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2021-08-04_14:26:28_CEST [openHABian] Setting up InfluxDB service... '
2021-08-04_14:26:28_CEST [openHABian] Setting up InfluxDB service... + cond_redirect sed -i -e 's|auth-enabled = true|# auth-enabled = false|g' /etc/influxdb/influxdb.conf
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ sed -i -e s|auth-enabled = true|# auth-enabled = false|g /etc/influxdb/influxdb.conf \033[39;49;00m'

$ sed -i -e s|auth-enabled = true|# auth-enabled = false|g /etc/influxdb/influxdb.conf
+ sed -i -e 's|auth-enabled = true|# auth-enabled = false|g' /etc/influxdb/influxdb.conf
+ return 0
+ zram_dependency install influxdb
+ local zramServiceConfig=/etc/systemd/system/zram-config.service
+ local install=yes
+ [[ -f /etc/ztab ]]
+ [[ install == \i\n\s\t\a\l\l ]]
+ shift 1
+ [[ influxdb == \r\e\m\o\v\e ]]
+ for arg in "$@"
+ [[ yes == \y\e\s ]]
+ grep -qs influxdb.service /etc/systemd/system/zram-config.service
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2021-08-04_14:26:28_CEST [openHABian] Adding influxdb to zram service dependencies... '
2021-08-04_14:26:28_CEST [openHABian] Adding influxdb to zram service dependencies... + cond_redirect sed -i -e '/^Before/s/$/ influxdb.service/' /etc/systemd/system/zram-config.service
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ sed -i -e /^Before/s/$/ influxdb.service/ /etc/systemd/system/zram-config.service \033[39;49;00m'

$ sed -i -e /^Before/s/$/ influxdb.service/ /etc/systemd/system/zram-config.service
+ sed -i -e '/^Before/s/$/ influxdb.service/' /etc/systemd/system/zram-config.service
+ return 0
+ echo OK
OK
+ [[ yes == \n\o ]]
+ cond_redirect systemctl -q daemon-reload
+ [[ -s /etc/ztab ]]
+ grep -qs /influxdb.bind /etc/ztab
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2021-08-04_14:26:28_CEST [openHABian] Adding InfluxDB to zram... '
2021-08-04_14:26:28_CEST [openHABian] Adding InfluxDB to zram... + mkdir -p /opt/zram/influxdb.bind/influxdb /var/lib/influxdb
+ cond_redirect sed -i '/^.*persistence.bind$/a dir     zstd            150M            350M            /var/lib/influxdb               /influxdb.bind' /etc/ztab
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ sed -i /^.*persistence.bind$/a dir    zstd            150M            350M            /var/lib/influxdb               /influxdb.bind /etc/ztab \033[39;49;00m'

$ sed -i /^.*persistence.bind$/a dir    zstd            150M            350M            /var/lib/influxdb               /influxdb.bind /etc/ztab
+ sed -i '/^.*persistence.bind$/a dir   zstd            150M            350M            /var/lib/influxdb               /influxdb.bind' /etc/ztab
+ return 0
+ cond_redirect zram-config start
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ zram-config start \033[39;49;00m'

$ zram-config start
+ zram-config start
zram-config start 2021-08-04-14:26:28
Entry swap              /zram0          zram-config0 already exists as a zram device, skipping recreation of device.
Entry dir               /zram1          /var/lib/openhab/persistence            /persistence.bind already exists as a zram device, skipping recreation of device.
+ return 0
+ cond_redirect systemctl enable --now influxdb.service
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ systemctl enable --now influxdb.service \033[39;49;00m'

$ systemctl enable --now influxdb.service
+ systemctl enable --now influxdb.service
Job for influxdb.service failed because the control process exited with error code.
See "systemctl status influxdb.service" and "journalctl -xe" for details.
+ return 1
+ echo 'FAILED (enable service)'
FAILED (enable service)
+ return 1
+ return 1
+ echo FAILED
FAILED
+ return 1
+ '[' 1 -ne 0 ']'
+ whiptail --msgbox 'There was an error or interruption during the execution of:\n  "20 | Optional Components"\n\nPlease try again. If the error persists, please read /opt/openhabian/docs/openhabian-DEBUG.md or https://github.com/openhab/openhabian/blob/main/docs/openhabian-DEBUG.md how to proceed.' 14 80

error messages:

openhabian@ohab3:~ $ systemctl status influxdb.service
● influxdb.service - InfluxDB is an open-source, distributed, time series database
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Wed 2021-08-04 14:39:22 CEST; 4min 51s ago
     Docs: https://docs.influxdata.com/influxdb/
  Process: 6360 ExecStart=/usr/lib/influxdb/scripts/influxd-systemd-start.sh (code=exited, status=203/EXEC)

Aug 04 14:39:22 ohab3 systemd[1]: influxdb.service: Service RestartSec=100ms expired, scheduling restart.
Aug 04 14:39:22 ohab3 systemd[1]: influxdb.service: Scheduled restart job, restart counter is at 5.
Aug 04 14:39:22 ohab3 systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Aug 04 14:39:22 ohab3 systemd[1]: influxdb.service: Start request repeated too quickly.
Aug 04 14:39:22 ohab3 systemd[1]: influxdb.service: Failed with result 'exit-code'.
Aug 04 14:39:22 ohab3 systemd[1]: Failed to start InfluxDB is an open-source, distributed, time series database.
openhabian@ohab3:~ $ journalctl -xe
Aug 04 14:39:22 ohab3 systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
-- Subject: A stop job for unit influxdb.service has finished
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- A stop job for unit influxdb.service has finished.
--
-- The job identifier is 2076 and the job result is done.
Aug 04 14:39:22 ohab3 systemd[1]: influxdb.service: Start request repeated too quickly.
Aug 04 14:39:22 ohab3 systemd[1]: influxdb.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The unit influxdb.service has entered the 'failed' state with result 'exit-code'.
Aug 04 14:39:22 ohab3 systemd[1]: Failed to start InfluxDB is an open-source, distributed, time series database.
-- Subject: A start job for unit influxdb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- A start job for unit influxdb.service has finished with a failure.
--
-- The job identifier is 2076 and the job result is failed.
Aug 04 14:42:04 ohab3 PackageKit[6151]: daemon quit
Aug 04 14:42:04 ohab3 systemd[1]: packagekit.service: Main process exited, code=killed, status=15/TERM
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- An ExecStart= process belonging to unit packagekit.service has exited.
--
-- The process' exit code is 'killed' and its exit status is 15.
Aug 04 14:42:04 ohab3 systemd[1]: packagekit.service: Succeeded.
-- Subject: Unit succeeded
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The unit packagekit.service has successfully entered the 'dead' state.

openhabian@ohab3:~ $ systemctl start influxdb.service
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to start 'influxdb.service'.
Authenticating as: ,,, (openhabian)
Password:
==== AUTHENTICATION COMPLETE ===
Job for influxdb.service failed because the control process exited with error code.
See "systemctl status influxdb.service" and "journalctl -xe" for details.

There seems to be a known problem with third party package influxdb.
For more information see e.g. this thread: OH 3.1.0 InfluxDB stopped working after update to 1.8.7-1

You can fix it by running:

sudo chmod +x /usr/lib/influxdb/scripts/influxd-systemd-start.sh
sudo systemctl restart influxdb.service

that was easy! thank you!
no need to move the influxdb data to usb, because with this openhabian it was moved to zram, right?

According to the logfile you posted

Entry dir               /zram1          /var/lib/openhab/persistence            /persistence.bind already exists as a zram device, skipping recreation of device.

that is the case.

yeah, found it also in /etc/ztab:

dir     zstd            150M            350M            /var/lib/influxdb               /influxdb.bind