New installation breaks on influxdb+grafana

SuysH · May 25, 2020, 5:58pm

*###############################################################################*
*##   Release = Raspbian GNU/Linux 10 (buster)*
*##    Kernel = Linux 4.19.57-v7l+*
*##  Platform = Raspberry Pi 4 Model B Rev 1.2*
*##    Uptime = 0 day(s). 0:1:41*
*## CPU Usage = 0% avg over 4 cpu(s) (4 core(s) x 1 socket(s))*
*##  CPU Load = 1m: 2.68, 5m: 1.12, 15m: 0.41*
*##    Memory = Free: 3.26GB (85%), Used: 0.59GB (15%), Total: 3.86GB*
*##      Swap = Free: 0.09GB (100%), Used: 0.00GB (0%), Total: 0.09GB*
*##      Root = Free: 23.83GB (88%), Used: 3.10GB (12%), Total: 28.11GB*
*##   Updates = 0 apt updates available.*
*## Processes = 128 running processes of 32768 maximum processes*
*###############################################################################*

I downloaded the latest image : openhabian-pi-raspbian-201908050414-gitca0976f-crc6a66b5a1.img
Did all updates and upgrades via openhabian-config.
When installing the influxdb+grafana, the next warnings are printed on screen:

    $ systemctl daemon-reload
    $ systemctl enable influxdb.service
    $ systemctl restart influxdb.service
    OK Configure InfluxDB admin account... Warning: Transient problem: connection refused Will retry in 1 seconds. 6
    Warning: retries left.
    Warning: Transient problem: connection refused Will retry in 2 seconds. 5
    Warning: retries left.
    Warning: Transient problem: connection refused Will retry in 4 seconds. 4
    Warning: retries left.
    Warning: Transient problem: connection refused Will retry in 8 seconds. 3
    Warning: retries left.
    Warning: Transient problem: connection refused Will retry in 16 seconds. 2
    Warning: retries left.
    Warning: Transient problem: connection refused Will retry in 32 seconds. 1
    Warning: retries left.
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    FAILED Configure listen on localhost only...
    $ sed -i -e /# Determines whether HTTP endpoint is enabled./ { n ; s/# enabled = true/enabled = true/ } /etc/influxdb/influxdb.conf
    $ sed -i s/# bind-address = ":8086"/bind-address = "localhost:8086"/g /etc/influxdb/influxdb.conf
    $ sed -i s/# auth-enabled = false/auth-enabled = true/g /etc/influxdb/influxdb.conf
    $ sed -i s/# store-enabled = true/store-enabled = false/g /etc/influxdb/influxdb.conf
    $ systemctl restart influxdb.service
    FAILED Waiting for InfluxDB service... FAILED
    Setup of inital influxdb database and InfluxDB users... curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    curl: (7) Failed to connect to localhost port 8086: Connection refused
    FAILED Installing Grafana... --2020-05-25 19:34:52--  https://packages.grafana.com/gpg.key
    Resolving packages.grafana.com (packages.grafana.com)... 151.101.38.217, 2a04:4e42:9::729
    Connecting to packages.grafana.com (packages.grafana.com)|151.101.38.217|:443... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 1694 (1.7K) [application/x-iwork-keynote-sffkey]
    Saving to: ‘STDOUT’

By removing and installing influx/grafana again the script runs thru and shows a successfully installation, but from then influxdb is not starting after a reboot.

I tried also with another (older) Raspberry and with other SDcards. I’ve done multiple installations with all kind of workarounds I found on this forum without final good results.
Anybody an idea?
Kind regards, Hans

mstormi · May 25, 2020, 6:58pm

Use code fences please.

When was your last attempt? There was a fix yesterday.
Try

sudo apt-get purge influxdb grafana

then reinstall from the openhabian-config menu.

PS: stop trying with different HW, that won’t help.

holgerf · May 25, 2020, 8:17pm

Hello Hans,
can you please post the output of the influxdb install, we need to know what happened just before the start of you log.
Thanks.
Best, Holger

SuysH · May 26, 2020, 9:19am

Indeed I also saw some updates.
I tried the complete install from scratch today again.
You can see the whole log below from login to the error during installation of influxdb and grafana.

login as: openhabian
openhabian@10.0.0.100's password:
Linux openhab 4.19.57-v7l+ #1244 SMP Thu Jul 4 18:48:07 BST 2019 armv7l

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.

###############################################################################
###############  openhab  #####################################################
###############################################################################
##        Ip = 10.0.0.100
##   Release = Raspbian GNU/Linux 10 (buster)
##    Kernel = Linux 4.19.57-v7l+
##  Platform = Raspberry Pi 4 Model B Rev 1.2
##    Uptime = 0 day(s). 1:24:47
## CPU Usage = 0% avg over 4 cpu(s) (4 core(s) x 1 socket(s))
##  CPU Load = 1m: 0.38, 5m: 0.29, 15m: 0.60
##    Memory = Free: 1.27GB (33%), Used: 2.54GB (67%), Total: 3.81GB
##      Swap = Free: 0.09GB (100%), Used: 0.00GB (0%), Total: 0.09GB
##      Root = Free: 24.43GB (90%), Used: 2.50GB (10%), Total: 28.11GB
##   Updates = 0 apt updates available.
##  Sessions = 1 session(s)
## Processes = 127 running processes of 32768 maximum processes
###############################################################################

              Welcome to            __  _____    ____  _
            ____  ____  ___  ____  / / / /   |  / __ )(_)___ _____
           / __ \/ __ \/ _ \/ __ \/ /_/ / /| | / __  / / __ `/ __ \
          / /_/ / /_/ /  __/ / / / __  / ___ |/ /_/ / / /_/ / / / /
          \____/ .___/\___/_/ /_/_/ /_/_/  |_/_____/_/\__,_/_/ /_/
              /_/
                  openHAB 2.5.5-1 (Release Build)


Looking for a place to get started? Check out 'sudo openhabian-config' and the
documentation at https://www.openhab.org/docs/installation/openhabian.html
The openHAB dashboard can be reached at http://openhab:8080
To interact with openHAB on the command line, execute: 'openhab-cli --help'

[10:50:07] openhabian@openhab:~$ sudo openhabian-config

We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:

    #1) Respect the privacy of others.
    #2) Think before you type.
    #3) With great power comes great responsibility.

[sudo] password for openhabian:
2020-05-26_10:50:19_CEST [openHABian] Checking for root privileges... OK
2020-05-26_10:50:19_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:50:19_CEST [openHABian] Loading configuration file '/etc/openhabian.conf'... OK
2020-05-26_10:50:19_CEST [openHABian] openHABian configuration tool version: [master]v1.5-607(71cb38d)
2020-05-26_10:50:19_CEST [openHABian] Checking for changes in origin... OK
2020-05-26_10:50:23_CEST [openHABian] Updating myself... OK - No remote changes detected. You are up to date!
2020-05-26_10:50:49_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:50:49_CEST [openHABian] Updating repositories and upgrading installed packages...
$ apt-get --yes upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
The following packages have been kept back:
  binutils binutils-arm-linux-gnueabihf binutils-common libbinutils
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.

$ java_install_or_update
openjdk version "1.8.0_252"
OpenJDK Runtime Environment (Zulu 8.46.0.225-CA-linux_aarch32hf) (build 1.8.0_252-b225)
OpenJDK Client VM (Zulu 8.46.0.225-CA-linux_aarch32hf) (build 25.252-b225, mixed mode, Evaluation)

$ java -version
openjdk version "1.8.0_252"
OpenJDK Runtime Environment (Zulu 8.46.0.225-CA-linux_aarch32hf) (build 1.8.0_252-b225)
OpenJDK Client VM (Zulu 8.46.0.225-CA-linux_aarch32hf) (build 25.252-b225, mixed mode, Evaluation)
OK
2020-05-26_10:50:57_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:50:57_CEST [openHABian] Installing or upgrading to latest openHAB release (stable)...
$ apt-key add /tmp/openhab-key.asc
OK

$ apt-get update
Hit:1 http://archive.raspberrypi.org/debian buster InRelease
Hit:2 http://raspbian.raspberrypi.org/raspbian buster InRelease
Ign:3 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
Get:4 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
Fetched 6,051 B in 1s (5,163 B/s)
Reading package lists... Done

$ apt-get -y --allow-downgrades install openhab2=2.5.5-1
Reading package lists... Done
Building dependency tree
Reading state information... Done
openhab2 is already the newest version (2.5.5-1).
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.

$ adduser openhab gpio
The user `openhab' is already a member of `gpio'.

$ systemctl daemon-reload

$ systemctl enable --now openhab2
OK
Optimizing Java to run on low memory single board computers...
2020-05-26_10:51:17_CEST [openHABian] Adding an openHAB dashboard tile for 'openhabiandocs'... Replacing... OK
2020-05-26_10:51:32_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:51:32_CEST [openHABian] Installing basic can't-be-wrong packages (screen, vim, ...)...
$ apt-get -y install screen vim nano mc vfu bash-completion htop curl wget multitail git util-linux bzip2 zip unzip xz-utils software-properties-common man-db whiptail acl usbutils dirmngr arping
Reading package lists... Done
Building dependency tree
Reading state information... Done
acl is already the newest version (2.2.53-4).
arping is already the newest version (2.19-6).
bash-completion is already the newest version (1:2.8-6).
bzip2 is already the newest version (1.0.6-9.2~deb10u1).
curl is already the newest version (7.64.0-4+deb10u1).
dirmngr is already the newest version (2.2.12-1+rpi1+deb10u1).
git is already the newest version (1:2.20.1-2+deb10u3).
htop is already the newest version (2.2.0-1).
man-db is already the newest version (2.8.5-2).
mc is already the newest version (3:4.8.22-1).
multitail is already the newest version (6.4.2-3).
nano is already the newest version (3.2-3).
screen is already the newest version (4.6.2-3).
software-properties-common is already the newest version (0.96.20.2-2).
unzip is already the newest version (6.0-23+deb10u1).
usbutils is already the newest version (1:010-3).
util-linux is already the newest version (2.33.1-0.1).
vfu is already the newest version (4.16+repack-1).
vim is already the newest version (2:8.1.0875-5).
wget is already the newest version (1.20.1-1.1).
whiptail is already the newest version (0.52.20-8).
xz-utils is already the newest version (5.2.4-1).
zip is already the newest version (3.0-11).
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.
OK
2020-05-26_10:51:35_CEST [openHABian] Installing additional needed packages...
$ apt-get -y install apt-transport-https bc sysstat avahi-daemon python3 python3-pip avahi-autoipd fontconfig
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-transport-https is already the newest version (1.8.2.1).
avahi-autoipd is already the newest version (0.7-4+b1).
avahi-daemon is already the newest version (0.7-4+b1).
bc is already the newest version (1.07.1-2).
fontconfig is already the newest version (2.13.1-2).
python3 is already the newest version (3.7.3-1).
sysstat is already the newest version (12.0.3-2).
python3-pip is already the newest version (18.1-5+rpt1).
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.
OK
2020-05-26_10:51:36_CEST [openHABian] Installing additional bluetooth packages...
$ apt-get -y install bluez python3-dev libbluetooth-dev raspberrypi-sys-mods pi-bluetooth python3-bluez
Reading package lists... Done
Building dependency tree
Reading state information... Done
python3-bluez is already the newest version (0.22+really0.22-1).
python3-dev is already the newest version (3.7.3-1).
bluez is already the newest version (5.50-1.2~deb10u1+rpt1).
libbluetooth-dev is already the newest version (5.50-1.2~deb10u1+rpt1).
pi-bluetooth is already the newest version (0.1.12).
raspberrypi-sys-mods is already the newest version (20191105).
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.
OK
2020-05-26_10:51:42_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:51:42_CEST [openHABian] Adding slightly tuned bash config files to system... OK
2020-05-26_10:51:42_CEST [openHABian] Adding slightly tuned vim config file to system... OK
2020-05-26_10:51:42_CEST [openHABian] Adding openHAB syntax to vim editor...
$ wget -O /home/openhabian/.vim/syntax/openhab.vim https://raw.githubusercontent.com/cyberkov/openhab-vim/master/syntax/openhab.vim
--2020-05-26 10:51:42--  https://raw.githubusercontent.com/cyberkov/openhab-vim/master/syntax/openhab.vim
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.0.133, 151.101.64.133, 151.101.128.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.0.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6065 (5.9K) [text/plain]
Saving to: ‘/home/openhabian/.vim/syntax/openhab.vim’

/home/openhabian/.vim/syntax/openhab.vim    100%[=========================================================================================>]   5.92K  --.-KB/s    in 0.05s

2020-05-26 10:51:43 (114 KB/s) - ‘/home/openhabian/.vim/syntax/openhab.vim’ saved [6065/6065]


$ wget -O /home/openhabian/.vim/ftdetect/openhab.vim https://raw.githubusercontent.com/cyberkov/openhab-vim/master/ftdetect/openhab.vim
--2020-05-26 10:51:43--  https://raw.githubusercontent.com/cyberkov/openhab-vim/master/ftdetect/openhab.vim
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.0.133, 151.101.64.133, 151.101.128.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.0.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 661 [text/plain]
Saving to: ‘/home/openhabian/.vim/ftdetect/openhab.vim’

/home/openhabian/.vim/ftdetect/openhab.vim  100%[=========================================================================================>]     661  --.-KB/s    in 0s

2020-05-26 10:51:43 (4.68 MB/s) - ‘/home/openhabian/.vim/ftdetect/openhab.vim’ saved [661/661]

OK
2020-05-26_10:51:43_CEST [openHABian] Adding openHAB syntax to nano editor...
$ wget -O /usr/share/nano/openhab.nanorc https://raw.githubusercontent.com/airix1/openhabnano/master/openhab.nanorc
--2020-05-26 10:51:43--  https://raw.githubusercontent.com/airix1/openhabnano/master/openhab.nanorc
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.0.133, 151.101.64.133, 151.101.128.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.0.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2321 (2.3K) [text/plain]
Saving to: ‘/usr/share/nano/openhab.nanorc’

/usr/share/nano/openhab.nanorc              100%[=========================================================================================>]   2.27K  --.-KB/s    in 0s

2020-05-26 10:51:44 (11.0 MB/s) - ‘/usr/share/nano/openhab.nanorc’ saved [2321/2321]

OK
2020-05-26_10:51:44_CEST [openHABian] Adding openHAB scheme to multitail... OK
2020-05-26_10:51:52_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:51:52_CEST [openHABian] Preparing openHAB folder mounts under /srv/...
$ cat /etc/fstab
proc            /proc           proc    defaults          0       0
PARTUUID=741f5400-01  /boot           vfat    defaults          0       2
PARTUUID=741f5400-02  /               ext4    defaults,noatime  0       1
# a swapfile is not a swap partition, no line here
#   use  dphys-swapfile swap[on|off]  for that

/usr/share/openhab2          /srv/openhab2-sys           none bind 0 0
/etc/openhab2                /srv/openhab2-conf          none bind 0 0
/var/lib/openhab2            /srv/openhab2-userdata      none bind 0 0
/var/log/openhab2            /srv/openhab2-logs          none bind 0 0
/usr/share/openhab2/addons   /srv/openhab2-addons        none bind 0 0

$ mkdir -p /srv/openhab2-sys /srv/openhab2-conf /srv/openhab2-userdata /srv/openhab2-logs /srv/openhab2-addons

$ cp /opt/openhabian/includes/srv_readme.txt /srv/README.txt

$ chmod ugo+w /srv /srv/README.txt

$ mount --all --verbose
/proc                    : already mounted
/boot                    : already mounted
/                        : ignored
/srv/openhab2-sys        : already mounted
/srv/openhab2-conf       : already mounted
/srv/openhab2-userdata   : already mounted
/srv/openhab2-logs       : already mounted
/srv/openhab2-addons     : already mounted
OK
2020-05-26_10:51:58_CEST [openHABian] Applying miscellaneous system settings...
$ setcap cap_net_raw,cap_net_admin=+eip cap_net_bind_service=+ep /opt/jdk/zulu8.46.0.225-ca-jdk8.0.252-linux_aarch32hf/bin/java

$ setcap cap_net_raw,cap_net_admin=+eip cap_net_bind_service=+ep /usr/sbin/arping

$ echo Creating persistent systemd journal folder location: /var/log/journal
Creating persistent systemd journal folder location: /var/log/journal

$ echo Keeping at most 30 days of systemd journal entries
Keeping at most 30 days of systemd journal entries
OK
2020-05-26_10:52:04_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:52:04_CEST [openHABian] Applying file permissions recommendations...
$ adduser openhab audio
The user `openhab' is already a member of `audio'.

$ adduser openhabian audio
The user `openhabian' is already a member of `audio'.

$ adduser openhab bluetooth
The user `openhab' is already a member of `bluetooth'.

$ adduser openhabian bluetooth
The user `openhabian' is already a member of `bluetooth'.

$ adduser openhab dialout
The user `openhab' is already a member of `dialout'.

$ adduser openhabian dialout
The user `openhabian' is already a member of `dialout'.

$ adduser openhab gpio
The user `openhab' is already a member of `gpio'.

$ adduser openhabian gpio
The user `openhabian' is already a member of `gpio'.

$ adduser openhab tty
The user `openhab' is already a member of `tty'.

$ adduser openhabian tty
The user `openhabian' is already a member of `tty'.

$ adduser openhabian openhab
The user `openhabian' is already a member of `openhab'.

$ chown openhab:openhab /srv /srv/README.txt /opt

$ chmod ugo+w /srv /srv/README.txt

$ chown -R openhab:openhab /etc/openhab2 /var/lib/openhab2 /var/log/openhab2 /usr/share/openhab2

$ chmod -R ug+wX /opt /etc/openhab2 /var/lib/openhab2 /var/log/openhab2 /usr/share/openhab2

$ chown -R openhabian:openhabian /home/openhabian

$ setfacl -R --remove-all /etc/openhab2 /var/lib/openhab2 /var/log/openhab2 /usr/share/openhab2

$ setfacl -R -m g::rwX /etc/openhab2 /var/lib/openhab2 /var/log/openhab2 /usr/share/openhab2

$ setfacl -R -m d:g::rwX /etc/openhab2 /var/lib/openhab2 /var/log/openhab2 /usr/share/openhab2
OK
2020-05-26_10:52:10_CEST [openHABian] Updating Linux package information ... 2020-05-26_10:52:10_CEST [openHABian] Downloading and setting up FireMotD...
$ apt-get -y install bc sysstat jq moreutils
Reading package lists... Done
Building dependency tree
Reading state information... Done
bc is already the newest version (1.07.1-2).
jq is already the newest version (1.5+dfsg-2+b1).
moreutils is already the newest version (0.62-1+b1).
sysstat is already the newest version (12.0.3-2).
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.

$ curl -s https://raw.githubusercontent.com/OutsideIT/FireMotD/master/FireMotD -o /tmp/FireMotD

$ /tmp/FireMotD -I
2020-05-26 10:52:15,058: FireMotD: Info: Attempting FireMotD installation
mkdir: cannot create directory '/usr/share/firemotd': File exists
mkdir: cannot create directory '/usr/share/firemotd/themes': File exists
mkdir: cannot create directory '/usr/share/firemotd/templates': File exists
2020-05-26 10:52:19,984: FireMotD: Info: Generating information
2020-05-26 10:52:20,042: FireMotD: Info: Debug mode
2020-05-26 10:52:20,054: FireMotD: Info: FireMotD action save started
2020-05-26 10:52:20,065: FireMotD: Info: Action "save"
2020-05-26 10:52:20,077: FireMotD: Info: Exportfile /usr/share/firemotd/data/FireMotD.json found.
2020-05-26 10:52:20,088: FireMotD: Info: Template type set to all. Overwriting..
2020-05-26 10:52:20,121: FireMotD: Info: Exploring HostIp
2020-05-26 10:52:20,205: FireMotD: Info: Exploring Release
2020-05-26 10:52:20,305: FireMotD: Info: Exploring Kernel
2020-05-26 10:52:20,362: FireMotD: Info: Exploring Platform
2020-05-26 10:52:20,452: FireMotD: Info: Exploring InstallDate
2020-05-26 10:52:20,508: FireMotD: Info: Exploring Updates
2020-05-26 10:52:54,746: FireMotD: Info: Exploring Httpd
2020-05-26 10:52:54,861: FireMotD: Info: Exploring Nginx
2020-05-26 10:52:55,002: FireMotD: Info: Exploring Mysql
2020-05-26 10:52:55,087: FireMotD: Info: Exploring Postgres
2020-05-26 10:52:55,142: FireMotD: Info: Exploring Php
2020-05-26 10:52:55,217: FireMotD: Info: Exploring Elasticsearch
2020-05-26 10:52:56,550: FireMotD: Info: Exploring Logstash
2020-05-26 10:52:56,674: FireMotD: Info: Exploring Kibana
2020-05-26 10:52:56,796: FireMotD: Info: Export system data to "/usr/share/firemotd/data/FireMotD.json" finished.
2020-05-26 10:52:56,843: FireMotD: Info: ExportFile: -rwxrw-rw- 1 root root 3229 May 26 10:52 /usr/share/firemotd/data/FireMotD.json
2020-05-26 10:52:56,872: FireMotD: Info: FireMotD action save finished
2020-05-26 10:52:56,902: FireMotD: Info: Generating caches
2020-05-26 10:53:24,706: FireMotD: Info: Generating FireMotD
DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD
iiiiiiiiiiiiiii  openhab  iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
DD        Ip -> 10.0.0.100
DD   Release -> Raspbian GNU/Linux 10 (buster)
DD    Kernel -> Linux 4.19.57-v7l+
DD  Platform -> Raspberry Pi 4 Model B Rev 1.2
DD    Uptime -> 0 day(s). 1:28:27
DD CPU Usage -> 0% avg over 4 cpu(s) (4 core(s) x 1 socket(s))
DD  CPU Load -> 1m: 2.37, 5m: 1.51, 15m: 1.03
DD    Memory -> Free: 1.26GB (33%), Used: 2.55GB (67%), Total: 3.81GB
DD      Swap -> Free: 0.09GB (100%), Used: 0.00GB (0%), Total: 0.09GB
DD      Root -> Free: 24.43GB (90%), Used: 2.50GB (10%), Total: 28.11GB
DD   Updates -> 0 apt updates available.
DD  Sessions -> 0 session(s)
DD Processes -> 130 running processes of 32768 maximum processes
SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

$ FireMotD -G Gray

$ FireMotD -S
OK
2020-05-26_11:10:39_CEST [openHABian] Updating Linux package information ... 2020-05-26_11:10:39_CEST [openHABian] Setting up the MQTT broker Eclipse Mosquitto...
$ apt-get -y install mosquitto mosquitto-clients
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
  libev4 libmosquitto1 libuv1 libwebsockets8
Suggested packages:
  apparmor
The following NEW packages will be installed:
  libev4 libmosquitto1 libuv1 libwebsockets8 mosquitto mosquitto-clients
0 upgraded, 6 newly installed, 0 to remove and 4 not upgraded.
Need to get 484 kB of archives.
After this operation, 1,054 kB of additional disk space will be used.
Get:1 http://mirror.nl.leaseweb.net/raspbian/raspbian buster/main armhf libev4 armhf 1:4.25-1 [34.5 kB]
Get:2 http://mirror.nl.leaseweb.net/raspbian/raspbian buster/main armhf libmosquitto1 armhf 1.5.7-1+deb10u1 [57.6 kB]
Get:3 http://mirror.nl.leaseweb.net/raspbian/raspbian buster/main armhf libuv1 armhf 1.24.1-1 [96.7 kB]
Get:4 http://mirror.nl.leaseweb.net/raspbian/raspbian buster/main armhf libwebsockets8 armhf 2.0.3-3 [85.6 kB]
Get:5 http://mirror.nl.leaseweb.net/raspbian/raspbian buster/main armhf mosquitto armhf 1.5.7-1+deb10u1 [143 kB]
Get:6 http://mirror.nl.leaseweb.net/raspbian/raspbian buster/main armhf mosquitto-clients armhf 1.5.7-1+deb10u1 [66.8 kB]
Fetched 484 kB in 1s (461 kB/s)
Selecting previously unselected package libev4:armhf.
(Reading database ... 47909 files and directories currently installed.)
Preparing to unpack .../0-libev4_1%3a4.25-1_armhf.deb ...
Unpacking libev4:armhf (1:4.25-1) ...
Selecting previously unselected package libmosquitto1:armhf.
Preparing to unpack .../1-libmosquitto1_1.5.7-1+deb10u1_armhf.deb ...
Unpacking libmosquitto1:armhf (1.5.7-1+deb10u1) ...
Selecting previously unselected package libuv1:armhf.
Preparing to unpack .../2-libuv1_1.24.1-1_armhf.deb ...
Unpacking libuv1:armhf (1.24.1-1) ...
Selecting previously unselected package libwebsockets8:armhf.
Preparing to unpack .../3-libwebsockets8_2.0.3-3_armhf.deb ...
Unpacking libwebsockets8:armhf (2.0.3-3) ...
Selecting previously unselected package mosquitto.
Preparing to unpack .../4-mosquitto_1.5.7-1+deb10u1_armhf.deb ...
Unpacking mosquitto (1.5.7-1+deb10u1) ...
Selecting previously unselected package mosquitto-clients.
Preparing to unpack .../5-mosquitto-clients_1.5.7-1+deb10u1_armhf.deb ...
Unpacking mosquitto-clients (1.5.7-1+deb10u1) ...
Setting up libmosquitto1:armhf (1.5.7-1+deb10u1) ...
Setting up libev4:armhf (1:4.25-1) ...
Setting up mosquitto-clients (1.5.7-1+deb10u1) ...
Setting up libuv1:armhf (1.24.1-1) ...
Setting up libwebsockets8:armhf (2.0.3-3) ...
Setting up mosquitto (1.5.7-1+deb10u1) ...
Created symlink /etc/systemd/system/multi-user.target.wants/mosquitto.service → /lib/systemd/system/mosquitto.service.
Processing triggers for systemd (241-7~deb10u4+rpi1) ...
Processing triggers for man-db (2.8.5-2) ...
Processing triggers for libc-bin (2.28-10+rpi1) ...
Updating FireMotD available updates count ...

$ sed -i /password_file/d /etc/mosquitto/mosquitto.conf

$ sed -i /allow_anonymous/d /etc/mosquitto/mosquitto.conf

$ rm -f /etc/mosquitto/passwd

$ systemctl enable mosquitto.service
Synchronizing state of mosquitto.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable mosquitto

$ systemctl restart mosquitto.service
OK
2020-05-26_11:11:36_CEST [openHABian] Updating Linux package information ... 2020-05-26_11:11:36_CEST [openHABian] Setting up InfluxDB and Grafana...

Installing InfluxDB...
--2020-05-26 11:12:09--  https://repos.influxdata.com/influxdb.key
Resolving repos.influxdata.com (repos.influxdata.com)... 54.192.209.34, 54.192.209.6, 54.192.209.57, ...
Connecting to repos.influxdata.com (repos.influxdata.com)|54.192.209.34|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3108 (3.0K) [application/pgp-keys]
Saving to: ‘STDOUT’

-                                           100%[=========================================================================================>]   3.04K  --.-KB/s    in 0s

2020-05-26 11:12:09 (7.18 MB/s) - written to stdout [3108/3108]

OK

$ apt-get update
Hit:1 http://raspbian.raspberrypi.org/raspbian buster InRelease
Hit:2 http://archive.raspberrypi.org/debian buster InRelease
Get:3 https://repos.influxdata.com/debian buster InRelease [4,731 B]
Ign:4 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
Get:5 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
Get:6 https://repos.influxdata.com/debian buster/stable armhf Packages [929 B]
Fetched 11.7 kB in 3s (4,127 B/s)
Reading package lists... Done

$ apt-get -y install influxdb
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
The following NEW packages will be installed:
  influxdb
0 upgraded, 1 newly installed, 0 to remove and 4 not upgraded.
Need to get 59.1 MB of archives.
After this operation, 151 MB of additional disk space will be used.
Get:1 https://repos.influxdata.com/debian buster/stable armhf influxdb armhf 1.8.0-1 [59.1 MB]
Fetched 59.1 MB in 17s (3,492 kB/s)
Selecting previously unselected package influxdb.
(Reading database ... 47972 files and directories currently installed.)
Preparing to unpack .../influxdb_1.8.0-1_armhf.deb ...
Unpacking influxdb (1.8.0-1) ...
Setting up influxdb (1.8.0-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 ...

$ sed -i s/auth-enabled = true/# auth-enabled = false/g /etc/influxdb/influxdb.conf

$ systemctl daemon-reload

$ systemctl enable influxdb.service

$ systemctl restart influxdb.service
OK Configure InfluxDB admin account... {"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
OK Configure listen on localhost only...
$ sed -i -e /# Determines whether HTTP endpoint is enabled./ { n ; s/# enabled = true/enabled = true/ } /etc/influxdb/influxdb.conf

$ sed -i s/# bind-address = ":8086"/bind-address = "localhost:8086"/g /etc/influxdb/influxdb.conf

$ sed -i s/# auth-enabled = false/auth-enabled = true/g /etc/influxdb/influxdb.conf

$ sed -i s/# store-enabled = true/store-enabled = false/g /etc/influxdb/influxdb.conf

$ systemctl restart influxdb.service
OK Waiting for InfluxDB service... OK
Setup of inital influxdb database and InfluxDB users... {"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
{"results":[{"statement_id":0}]}
OK Installing Grafana... --2020-05-26 11:13:33--  https://packages.grafana.com/gpg.key
Resolving packages.grafana.com (packages.grafana.com)... 151.101.38.217, 2a04:4e42:9::729
Connecting to packages.grafana.com (packages.grafana.com)|151.101.38.217|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1694 (1.7K) [application/x-iwork-keynote-sffkey]
Saving to: ‘STDOUT’

-                                           100%[=========================================================================================>]   1.65K  --.-KB/s    in 0s

2020-05-26 11:13:33 (4.50 MB/s) - written to stdout [1694/1694]

OK

$ apt-get update
Hit:1 http://archive.raspberrypi.org/debian buster InRelease
Hit:2 http://raspbian.raspberrypi.org/raspbian buster InRelease
Get:3 https://packages.grafana.com/oss/deb stable InRelease [12.1 kB]
Hit:4 https://repos.influxdata.com/debian buster InRelease
Ign:5 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
Get:6 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
Get:7 https://packages.grafana.com/oss/deb stable/main armhf Packages [16.6 kB]
Fetched 34.8 kB in 4s (9,357 B/s)
Reading package lists... Done

$ apt-get -y install grafana
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  rpi.gpio-common triggerhappy
Use 'sudo apt autoremove' to remove them.
The following NEW packages will be installed:
  grafana
0 upgraded, 1 newly installed, 0 to remove and 4 not upgraded.
Need to get 41.7 MB of archives.
After this operation, 121 MB of additional disk space will be used.
Get:1 https://packages.grafana.com/oss/deb stable/main armhf grafana armhf 7.0.1 [41.7 MB]
Fetched 41.7 MB in 14s (2,931 kB/s)
Selecting previously unselected package grafana.
(Reading database ... 47998 files and directories currently installed.)
Preparing to unpack .../grafana_7.0.1_armhf.deb ...
Unpacking grafana (7.0.1) ...
Setting up grafana (7.0.1) ...
Adding system user `grafana' (UID 112) ...
Adding new user `grafana' (UID 112) with group `grafana' ...
Not creating home directory `/usr/share/grafana'.
### NOT starting on installation, please execute the following statements to configure grafana to start automatically using systemd
 sudo /bin/systemctl daemon-reload
 sudo /bin/systemctl enable grafana-server
### You can start grafana-server by executing
 sudo /bin/systemctl start grafana-server
Processing triggers for systemd (241-7~deb10u4+rpi1) ...
Updating FireMotD available updates count ...

$ systemctl daemon-reload

$ systemctl enable grafana-server.service
Synchronizing state of grafana-server.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable grafana-server
Created symlink /etc/systemd/system/multi-user.target.wants/grafana-server.service → /usr/lib/systemd/system/grafana-server.service.

$ systemctl start grafana-server.service
OK
Resetting Grafana admin password...
$ grafana-cli admin reset-admin-password admin
INFO[05-26|11:15:15] Connecting to DB                         logger=sqlstore dbtype=sqlite3
INFO[05-26|11:15:15] Starting DB migration                    logger=migrator
INFO[05-26|11:15:16] Executing migration                      logger=migrator id="create index UQE_user_login - v2"
EROR[05-26|11:15:16] Executing migration failed               logger=migrator id="create index UQE_user_login - v2" error="database is locked"
EROR[05-26|11:15:16] Exec failed                              logger=migrator error="database is locked" sql="CREATE UNIQUE INDEX `UQE_user_login` ON `user` (`login`);"
Error: ✗ failed to initialize SQL engine: Migration failed err: Failed to roll back transaction due to error: %!s(<nil>): database is locked
FAILED Connection Grafana to InfluxDB...curl: (7) Failed to connect to localhost port 3000: Connection refused
Adding openHAB dashboard tile for Grafana... 2020-05-26_11:15:16_CEST [openHABian] Adding an openHAB dashboard tile for 'grafana'... OK
Adding install InfluxDB with database configuration to openHAB
$ touch /etc/openhab2/services/influxdb.cfg

2020-05-26_11:15:23_CEST [openHABian] Checking for default openHABian username:password combination... FAILED
2020-05-26_11:15:25_CEST [openHABian] We hope you got what you came for! See you again soon ;)
[11:15:25] openhabian@openhab:~$

NW27 · January 19, 2021, 12:25am

This is still happening.

I just did a fresh install onto a Pi4 4G with 1.6.2b and have exactly the same issue.
After openhabian had installed, I browsed to 8080 and created a user, set the language & location.
ran openhabian-config and installed mosquitto, rebooted and verified this service started after reboot.
Then openhabian-config and did the InfluxDB and Grafana.
This gave

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

The log looks like:


OK
2021-01-19_10:53:26_AEDT [openHABian] Installing InfluxDB...
$ apt-get update
Hit:1 http://davesteele.github.io/comitup/repo comitup InRelease
Hit:2 https://deb.nodesource.com/node_12.x buster InRelease
Hit:3 http://raspbian.raspberrypi.org/raspbian buster InRelease
Hit:4 http://archive.raspberrypi.org/debian buster InRelease
Get:5 https://repos.influxdata.com/debian buster InRelease [4,737 B]
Ign:6 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
Get:7 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
Get:8 https://repos.influxdata.com/debian buster/stable armhf Packages [926 B]
Fetched 11.7 kB in 4s (2,691 B/s)
Reading package lists... Done
$ 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 0 not upgraded.

Need to get 60.0 MB of archives.

After this operation, 153 MB of additional disk space will be used.

Get:1 https://repos.influxdata.com/debian buster/stable armhf influxdb armhf 1.8.3-1 [60.0 MB]

Fetched 60.0 MB in 18s (3,410 kB/s)

Selecting previously unselected package influxdb.

(Reading database … 52995 files and directories currently installed.)

Preparing to unpack …/influxdb_1.8.3-1_armhf.deb …

Unpacking influxdb (1.8.3-1) …

Setting up influxdb (1.8.3-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 …

OK

2021-01-19_10:54:23_AEDT [openHABian] Setting up InfluxDB service…

$ sed -i -e s|auth-enabled = true|# auth-enabled = false|g /etc/influxdb/influxdb.conf

2021-01-19_10:54:23_AEDT [openHABian] Adding influxdb to zram service dependencies…

$ sed -i -e /^Before/s/$/ influxdb.service/ /etc/systemd/system/zram-config.service

OK
$ systemctl enable --now influxdb.service

OK

2021-01-19_10:54:26_AEDT [openHABian] Setting up InfluxDB…

Configure InfluxDB admin account…

$ curl --retry 6 --retry-connrefused --insecure http://localhost:8086/query --data-urlencode q=CREATE USER admin WITH PASSWORD ‘administrator’ WITH ALL PRIVILEGES curl: (7) Failed to connect to localhost port 8086: Connection refused FAILED (create admin user) FAILED 2021-01-19_10:55:21_AEDT [openHABian] Checking for default openHABian username:password combination… OK 2021-01-19_10:55:21_AEDT [openHABian] We hope you got what you came for! See you again soon

mkhaled · March 2, 2021, 9:29pm

Were you able to solve this? I am facing the exact same issue when attempting to install influxdb+grafana from sudo openhabian-config -> Optional Components.
I am running openhab 2.5.12 on RPi. I also installed Mosquitto from the same place.

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

openhabian@openHABianPi:~ $ sudo openhabian-config
2021-03-02_15:22:29_CST [openHABian] Checking for root privileges… OK
2021-03-02_15:22:30_CST [openHABian] Loading configuration file ‘/etc/openhabian.conf’… OK
2021-03-02_15:22:30_CST [openHABian] openHABian configuration tool version: [stable]patchday-20210119-1116(5e807c0)
2021-03-02_15:22:31_CST [openHABian] Checking for changes in origin branch stable… OK
2021-03-02_15:22:32_CST [openHABian] Switching to branch stable… OK
2021-03-02_15:22:42_CST [openHABian] Updating Linux package information… OK
2021-03-02_15:22:45_CST [openHABian] Beginning setup of InfluxDB and Grafana… OK
2021-03-02_15:23:01_CST [openHABian] Configuring InfluxDB… OK
2021-03-02_15:24:37_CST [openHABian] Configuring Grafana… OK
2021-03-02_15:24:50_CST [openHABian] Installing InfluxDB… FAILED
2021-03-02_15:27:38_CST [openHABian] Checking for default openHABian username:password combination… FAILED
2021-03-02_15:27:40_CST [openHABian] We hope you got what you came for! See you again soon

Wolfgang_S · March 3, 2021, 5:07am

You need to follow the DEBUG instructions to provide more detailed debug output. This one just shows at which step a failure ( FAILED ) occured. It does not say anything about the root cause. Root cause analysis is supported by more detailed DEBUG output.
The second FAILED item most probably is there because the default user-password combination is not changed.

NW27 · March 12, 2021, 10:28pm

I wasn’t able to resolve this.
I’m not a proficient Linux user and do not know how to turn on advanced debugging etc or interpret results.

Still on OH 2.x because of this.

So many users are encountering this issue.