InfluxDB+Grafana installation error

Hi,

I’m trying to install InfluxDB+Grafana from udo openhabian-config

It looks like it works (downloads, extracts etc) but when it goes back into the console I get the following error:

Operation Failed! ├───────────────────┐
│ │
│ Sadly there was a problem setting up the selected │
│ option. Please report this problem in the openHAB │
│ community forum or as a openHABian GitHub issue.

So, as suggested, raising it here.

Thanks in advance for your help.

The full log:

pi@raspberrypi:~ $ sudo openhabian-config
    2018-09-18_19:31:07_AEST [openHABian] Checking for root privileges... OK
    2018-09-18_19:31:07_AEST [openHABian] Loading configuration file '/etc/openhabian.conf'... OK
    grep: /etc/cron.d/firemotd: No such file or directory
    /opt/openhabian/functions/openhabian.sh: line 122: firemotd: command not found
    2018-09-18_19:31:09_AEST [openHABian] openHABian configuration tool version: [master]v1.4.1-413(7799e0d)
    2018-09-18_19:31:09_AEST [openHABian] Checking for changes in origin... OK
    2018-09-18_19:31:22_AEST [openHABian] Setting up InfluxDB and Grafana...

    $ apt -y install apt-transport-https
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    apt-transport-https is already the newest version (1.4.8).
    0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension

    InfluxDB...
    --2018-09-18 19:31:48--  https://repos.influxdata.com/influxdb.key
    Resolving repos.influxdata.com (repos.influxdata.com)... 54.230.245.184, 54.230.245.113, 54.230.245.20, ...
    Connecting to repos.influxdata.com (repos.influxdata.com)|54.230.245.184|: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

    2018-09-18 19:31:48 (62.1 MB/s) - written to stdout [3108/3108]

    OK

    $ apt update
    Get:1 https://repos.influxdata.com/debian stretch InRelease [4,732 B]
    Get:2 http://archive.raspberrypi.org/debian stretch InRelease [25.3 kB]
    Get:3 http://raspbian.raspberrypi.org/raspbian stretch InRelease [15.0 kB]
    Get:4 https://repos.influxdata.com/debian stretch/stable armhf Packages [917 B]
    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]
    Hit:6 https://dl.bintray.com/openhab/apt-repo2 stable Release
    Get:7 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease [17.5 kB]
    Get:8 http://raspbian.raspberrypi.org/raspbian stretch/main armhf Packages [11.7 MB]
    Hit:10 https://repo.mosquitto.org/debian jessie InRelease
    Hit:11 https://repo.mosquitto.org/debian stretch InRelease
    Err:7 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease
      The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    Reading package lists... Done
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
    W: GPG error: http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    E: The repository 'http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.

    $ apt -y install 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 3 not upgraded.
    Need to get 23.5 MB of archives.
    After this operation, 71.9 MB of additional disk space will be used.
    Get:1 https://repos.influxdata.com/debian stretch/stable armhf influxdb armhf 1.6.2-1 [23.5 MB]
    Fetched 23.5 MB in 17s (1,320 kB/s)
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
    Selecting previously unselected package influxdb.
    (Reading database ... 121231 files and directories currently installed.)
    Preparing to unpack .../influxdb_1.6.2-1_armhf.deb ...
    Unpacking influxdb (1.6.2-1) ...
    Setting up influxdb (1.6.2-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.7.6.1-2) ...
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension

    $ systemctl daemon-reload

    $ systemctl enable influxdb.service

    $ systemctl start influxdb.service
    FAILED
    Grafana...

    $ apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 379CE192D401AB61
    Executing: /tmp/apt-key-gpghome.SXTaugxbXF/gpg.1.sh --keyserver keyserver.ubuntu.com --recv-keys 379CE192D401AB61
    gpg: failed to start the dirmngr '/usr/bin/dirmngr': No such file or directory
    gpg: connecting dirmngr at '/tmp/apt-key-gpghome.SXTaugxbXF/S.dirmngr' failed: No such file or directory
    gpg: keyserver receive failed: No dirmngr

    $ apt update
    Hit:1 http://archive.raspberrypi.org/debian stretch InRelease
    Hit:2 http://raspbian.raspberrypi.org/raspbian stretch InRelease
    Hit:4 https://repos.influxdata.com/debian stretch InRelease
    Get:3 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease [17.5 kB]
    Hit:5 https://repo.mosquitto.org/debian jessie InRelease
    Ign:6 https://dl.bintray.com/fg2it/deb stretch InRelease
    Hit:7 https://repo.mosquitto.org/debian stretch InRelease
    Ign:8 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
    Err:3 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease
      The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    Get:9 https://dl.bintray.com/fg2it/deb stretch Release [5,300 B]
    Get:10 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
    Hit:10 https://dl.bintray.com/openhab/apt-repo2 stable Release
    Get:12 https://dl.bintray.com/fg2it/deb stretch Release.gpg [821 B]
    Ign:12 https://dl.bintray.com/fg2it/deb stretch Release.gpg
    Reading package lists... Done
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
    W: GPG error: http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    E: The repository 'http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.
    W: GPG error: https://dl.bintray.com/fg2it/deb stretch Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 379CE192D401AB61
    E: The repository 'https://dl.bintray.com/fg2it/deb stretch Release' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.

    $ apt -y install grafana
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following additional packages will be installed:
      fonts-font-awesome golang-1.7-go golang-1.7-src golang-go golang-src
      grafana-data libjs-angularjs libjs-jquery-metadata libjs-jquery-tablesorter
      libjs-twitter-bootstrap libqt5qml5 libqt5quick5 libqt5webkit5 phantomjs
    Suggested packages:
      bzr mercurial libjs-bootstrap qt5-qmltooling-plugins
    The following NEW packages will be installed:
      fonts-font-awesome golang-1.7-go golang-1.7-src golang-go golang-src grafana
      grafana-data libjs-angularjs libjs-jquery-metadata libjs-jquery-tablesorter
      libjs-twitter-bootstrap libqt5qml5 libqt5quick5 libqt5webkit5 phantomjs
    0 upgraded, 15 newly installed, 0 to remove and 3 not upgraded.
    Need to get 40.4 MB of archives.
    After this operation, 208 MB of additional disk space will be used.
    Get:1 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf libqt5qml5 armhf 5.7.1-2+rpi1 [970 kB]
    Get:2 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf libqt5quick5 armhf 5.7.1-2+rpi1 [896 kB]
    Get:3 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf libqt5webkit5 armhf 5.7.1+dfsg-1+rpi1 [7,683 kB]
    Get:4 http://mirror.solnode.io/raspbian stretch/main armhf fonts-font-awesome all 4.7.0~dfsg-1 [514 kB]
    Get:7 http://mirror.solnode.io/raspbian stretch/main armhf golang-src armhf 2:1.7~5 [3,560 B]
    Get:8 http://mirror.solnode.io/raspbian stretch/main armhf golang-go armhf 2:1.7~5 [22.7 kB]
    Get:9 http://mirror.solnode.io/raspbian stretch/main armhf libjs-angularjs all 1.5.10-1 [700 kB]
    Get:10 http://mirror.solnode.io/raspbian stretch/main armhf libjs-jquery-metadata all 11-3 [7,188 B]
    Get:11 http://mirror.solnode.io/raspbian stretch/main armhf libjs-jquery-tablesorter all 11-3 [43.9 kB]
    Get:5 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf golang-1.7-src armhf 1.7.4-2+rpi1 [7,677 kB]
    Get:6 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf golang-1.7-go armhf 1.7.4-2+rpi1 [17.4 MB]
    Get:12 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf libjs-twitter-bootstrap all 2.0.2+dfsg-10 [98.8 kB]
    Get:13 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf grafana-data all 2.6.0+dfsg-3 [1,162 kB]
    Get:14 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf grafana armhf 2.6.0+dfsg-3+b1 [2,959 kB]
    Get:15 http://raspbian.melbourneitmirror.net/raspbian stretch/main armhf phantomjs armhf 2.1.1+dfsg-2 [277 kB]
    Fetched 40.4 MB in 32s (1,260 kB/s)
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
    Selecting previously unselected package libqt5qml5:armhf.
    (Reading database ... 121257 files and directories currently installed.)
    Preparing to unpack .../00-libqt5qml5_5.7.1-2+rpi1_armhf.deb ...
    Unpacking libqt5qml5:armhf (5.7.1-2+rpi1) ...
    Selecting previously unselected package libqt5quick5:armhf.
    Preparing to unpack .../01-libqt5quick5_5.7.1-2+rpi1_armhf.deb ...
    Unpacking libqt5quick5:armhf (5.7.1-2+rpi1) ...
    Selecting previously unselected package libqt5webkit5:armhf.
    Preparing to unpack .../02-libqt5webkit5_5.7.1+dfsg-1+rpi1_armhf.deb ...
    Unpacking libqt5webkit5:armhf (5.7.1+dfsg-1+rpi1) ...
    Selecting previously unselected package fonts-font-awesome.
    Preparing to unpack .../03-fonts-font-awesome_4.7.0~dfsg-1_all.deb ...
    Unpacking fonts-font-awesome (4.7.0~dfsg-1) ...
    Selecting previously unselected package golang-1.7-src.
    Preparing to unpack .../04-golang-1.7-src_1.7.4-2+rpi1_armhf.deb ...
    Unpacking golang-1.7-src (1.7.4-2+rpi1) ...
    Selecting previously unselected package golang-1.7-go.
    Preparing to unpack .../05-golang-1.7-go_1.7.4-2+rpi1_armhf.deb ...
    Unpacking golang-1.7-go (1.7.4-2+rpi1) ...
    Selecting previously unselected package golang-src.
    Preparing to unpack .../06-golang-src_2%3a1.7~5_armhf.deb ...
    Unpacking golang-src (2:1.7~5) ...
    Selecting previously unselected package golang-go.
    Preparing to unpack .../07-golang-go_2%3a1.7~5_armhf.deb ...
    Unpacking golang-go (2:1.7~5) ...
    Selecting previously unselected package libjs-angularjs.
    Preparing to unpack .../08-libjs-angularjs_1.5.10-1_all.deb ...
    Unpacking libjs-angularjs (1.5.10-1) ...
    Selecting previously unselected package libjs-jquery-metadata.
    Preparing to unpack .../09-libjs-jquery-metadata_11-3_all.deb ...
    Unpacking libjs-jquery-metadata (11-3) ...
    Selecting previously unselected package libjs-jquery-tablesorter.
    Preparing to unpack .../10-libjs-jquery-tablesorter_11-3_all.deb ...
    Unpacking libjs-jquery-tablesorter (11-3) ...
    Selecting previously unselected package libjs-twitter-bootstrap.
    Preparing to unpack .../11-libjs-twitter-bootstrap_2.0.2+dfsg-10_all.deb ...
    Unpacking libjs-twitter-bootstrap (2.0.2+dfsg-10) ...
    Selecting previously unselected package grafana-data.
    Preparing to unpack .../12-grafana-data_2.6.0+dfsg-3_all.deb ...
    Unpacking grafana-data (2.6.0+dfsg-3) ...
    Selecting previously unselected package grafana.
    Preparing to unpack .../13-grafana_2.6.0+dfsg-3+b1_armhf.deb ...
    Unpacking grafana (2.6.0+dfsg-3+b1) ...
    Selecting previously unselected package phantomjs.
    Preparing to unpack .../14-phantomjs_2.1.1+dfsg-2_armhf.deb ...
    Unpacking phantomjs (2.1.1+dfsg-2) ...
    Setting up libqt5qml5:armhf (5.7.1-2+rpi1) ...
    Setting up libqt5quick5:armhf (5.7.1-2+rpi1) ...
    Setting up libqt5webkit5:armhf (5.7.1+dfsg-1+rpi1) ...
    Setting up phantomjs (2.1.1+dfsg-2) ...
    Setting up fonts-font-awesome (4.7.0~dfsg-1) ...
    Setting up libjs-angularjs (1.5.10-1) ...
    Processing triggers for libc-bin (2.24-11+deb9u3) ...
    Processing triggers for systemd (232-25+deb9u4) ...
    Processing triggers for man-db (2.7.6.1-2) ...
    Setting up golang-1.7-src (1.7.4-2+rpi1) ...
    Setting up libjs-jquery-metadata (11-3) ...
    Processing triggers for fontconfig (2.11.0-6.7) ...
    Setting up libjs-jquery-tablesorter (11-3) ...
    Setting up libjs-twitter-bootstrap (2.0.2+dfsg-10) ...
    Setting up golang-src (2:1.7~5) ...
    Setting up grafana-data (2.6.0+dfsg-3) ...
    Setting up golang-1.7-go (1.7.4-2+rpi1) ...
    Setting up golang-go (2:1.7~5) ...
    Setting up grafana (2.6.0+dfsg-3+b1) ...
    Created symlink /etc/systemd/system/grafana-server.service → /lib/systemd/system/grafana.service.
    Created symlink /etc/systemd/system/multi-user.target.wants/grafana.service → /lib/systemd/system/grafana.service.
    Processing triggers for systemd (232-25+deb9u4) ...
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension

    $ systemctl daemon-reload

    $ systemctl enable grafana-server.service
    Failed to enable unit: Refusing to operate on linked unit file grafana-server.service

    $ systemctl start grafana-server.service
    FAILED
    Connecting (TODO)...
    Adding openHAB dashboard tile...
    2018-09-18_19:36:08_AEST [openHABian] Adding an openHAB dashboard tile for 'grafana'... OK
    2018-09-18_19:44:08_AEST [openHABian] Setting up InfluxDB and Grafana...

    $ apt -y install apt-transport-https
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    apt-transport-https is already the newest version (1.4.8).
    0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension

    InfluxDB...
    --2018-09-18 19:44:15--  https://repos.influxdata.com/influxdb.key
    Resolving repos.influxdata.com (repos.influxdata.com)... 13.32.126.116, 13.32.126.5, 13.32.126.95, ...
    Connecting to repos.influxdata.com (repos.influxdata.com)|13.32.126.116|: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

    2018-09-18 19:44:15 (94.5 MB/s) - written to stdout [3108/3108]

    OK

    $ apt update
    Hit:1 https://repos.influxdata.com/debian stretch InRelease
    Hit:2 http://archive.raspberrypi.org/debian stretch InRelease
    Hit:4 http://raspbian.raspberrypi.org/raspbian stretch InRelease
    Get:3 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease [17.5 kB]
    Ign:5 https://dl.bintray.com/fg2it/deb stretch InRelease
    Ign:6 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
    Get:7 https://dl.bintray.com/fg2it/deb stretch Release [5,300 B]
    Hit:8 https://repo.mosquitto.org/debian jessie InRelease
    Err:3 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease
      The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    Get:9 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
    Hit:9 https://dl.bintray.com/openhab/apt-repo2 stable Release
    Hit:10 https://repo.mosquitto.org/debian stretch InRelease
    Get:12 https://dl.bintray.com/fg2it/deb stretch Release.gpg [821 B]
    Ign:12 https://dl.bintray.com/fg2it/deb stretch Release.gpg
    Reading package lists... Done
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
    W: GPG error: http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    E: The repository 'http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.
    W: GPG error: https://dl.bintray.com/fg2it/deb stretch Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 379CE192D401AB61
    E: The repository 'https://dl.bintray.com/fg2it/deb stretch Release' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.

    $ apt -y install influxdb
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    influxdb is already the newest version (1.6.2-1).
    0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension

    $ systemctl daemon-reload

    $ systemctl enable influxdb.service

    $ systemctl start influxdb.service
    FAILED
    Grafana...

    $ apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 379CE192D401AB61
    Executing: /tmp/apt-key-gpghome.t2wDObmY0i/gpg.1.sh --keyserver keyserver.ubuntu.com --recv-keys 379CE192D401AB61
    gpg: failed to start the dirmngr '/usr/bin/dirmngr': No such file or directory
    gpg: connecting dirmngr at '/tmp/apt-key-gpghome.t2wDObmY0i/S.dirmngr' failed: No such file or directory
    gpg: keyserver receive failed: No dirmngr

    $ apt update
    Hit:1 https://repos.influxdata.com/debian stretch InRelease
    Hit:2 http://raspbian.raspberrypi.org/raspbian stretch InRelease
    Hit:3 http://archive.raspberrypi.org/debian stretch InRelease
    Get:4 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease [17.5 kB]
    Ign:5 https://dl.bintray.com/fg2it/deb stretch InRelease
    Ign:6 https://dl.bintray.com/openhab/apt-repo2 stable InRelease
    Hit:7 https://repo.mosquitto.org/debian jessie InRelease
    Err:4 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease
      The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    Get:8 https://dl.bintray.com/fg2it/deb stretch Release [5,300 B]
    Hit:9 https://repo.mosquitto.org/debian stretch InRelease
    Get:10 https://dl.bintray.com/openhab/apt-repo2 stable Release [6,051 B]
    Hit:10 https://dl.bintray.com/openhab/apt-repo2 stable Release
    Get:12 https://dl.bintray.com/fg2it/deb stretch Release.gpg [821 B]
    Ign:12 https://dl.bintray.com/fg2it/deb stretch Release.gpg
    Reading package lists... Done
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
    W: GPG error: http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C2518248EEA14886
    E: The repository 'http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.
    W: GPG error: https://dl.bintray.com/fg2it/deb stretch Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 379CE192D401AB61
    E: The repository 'https://dl.bintray.com/fg2it/deb stretch Release' is not signed.
    N: Updating from such a repository can't be done securely, and is therefore disabled by default.
    N: See apt-secure(8) manpage for repository creation and user configuration details.

    $ apt -y install grafana
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    grafana is already the newest version (2.6.0+dfsg-3+b1).
    0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
    N: Ignoring file 'mosquitto-stretch.list.1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension

    $ systemctl daemon-reload

    $ systemctl enable grafana-server.service
    Failed to enable unit: Refusing to operate on linked unit file grafana-server.service

    $ systemctl start grafana-server.service
    FAILED
    Connecting (TODO)...
    Adding openHAB dashboard tile...
    2018-09-18_19:44:44_AEST [openHABian] Adding an openHAB dashboard tile for 'grafana'... Replacing... OK
    2018-09-18_19:45:07_AEST [openHABian] Checking for default openHABian username:password combination... OK
    2018-09-18_19:45:08_AEST [openHABian] We hope you got what you came for! See you again soon ;)

Please use code fences for this huge log as well, it is really unreadable like this

Sorry, done.

Please post the output from:

systemctl status grafana-server.service -l

and

systemctl status influxdb.service -l

Kind regards,

Hi,

Thanks for the reply. I worked through this on the Github and I think everything is working now. Here’s the output:

pi@raspberrypi:~ $ systemctl status grafana-server.service -l
● grafana-server.service - Grafana instance
   Loaded: loaded (/usr/lib/systemd/system/grafana-server.service; enabled; vend
   Active: active (running) since Thu 2018-09-20 20:01:31 AEST; 2min 19s ago
     Docs: http://docs.grafana.org
 Main PID: 380 (grafana-server)
   CGroup: /system.slice/grafana-server.service
           └─380 /usr/sbin/grafana-server --config=/etc/grafana/grafana.ini --pi

Sep 20 20:01:40 raspberrypi grafana-server[380]: t=2018-09-20T20:01:40+1000 lvl=
Sep 20 20:01:40 raspberrypi grafana-server[380]: t=2018-09-20T20:01:40+1000 lvl=
Sep 20 20:01:40 raspberrypi grafana-server[380]: t=2018-09-20T20:01:40+1000 lvl=
Sep 20 20:01:40 raspberrypi grafana-server[380]: t=2018-09-20T20:01:40+1000 lvl=
Sep 20 20:01:40 raspberrypi grafana-server[380]: t=2018-09-20T20:01:40+1000 lvl=
Sep 20 20:01:46 raspberrypi grafana-server[380]: t=2018-09-20T20:01:46+1000 lvl=
Sep 20 20:01:47 raspberrypi grafana-server[380]: t=2018-09-20T20:01:47+1000 lvl=
Sep 20 20:01:47 raspberrypi grafana-server[380]: t=2018-09-20T20:01:47+1000 lvl=
Sep 20 20:01:47 raspberrypi grafana-server[380]: t=2018-09-20T20:01:47+1000 lvl=
Sep 20 20:01:47 raspberrypi grafana-server[380]: t=2018-09-20T20:01:47+1000 lvl=

pi@raspberrypi:~ $ systemctl status influxdb.service -l
● influxdb.service - InfluxDB is an open-source, distributed, time series databa
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset:
   Active: active (running) since Thu 2018-09-20 20:01:31 AEST; 2min 57s ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 381 (influxd)
   CGroup: /system.slice/influxdb.service
           └─381 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.718423Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.718534Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.718564Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.718608Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.718635Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.718908Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.719014Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.719360Z lvl=inf
Sep 20 20:02:33 raspberrypi influxd[381]: ts=2018-09-20T10:02:33.719792Z lvl=inf
Sep 20 20:02:34 raspberrypi influxd[381]: ts=2018-09-20T10:02:34.110996Z lvl=inf
lines 1-18/18 (END)

Well. This is not the full output. But anyway both are running and Service files are available.
Maybe an issue within openhabian - Iam not sure because i never used it.

Hi,

I have a similar problem. I installed a complete new openhabianpi on my raspPI 3B+.
Then I installed influxDB+Grafana using the openhabian-config tool. During this I entered passwords for the different influxDB and Grafana users.

But I got an error message:

the last log lines are:

$ systemctl restart grafana-server.service
Connection Grafana to InfluxDB…{“message”:“Invalid username or password”}Adding openHAB dashboard tile for Grafana… 2019-01-02_19:58:34_CET [openHABian] Adding an openHAB dashboard tile for ‘grafana’… OK

Adding install InfluxDB with database configuration to OpenHAB

$ touch /etc/openhab2/services/influxdb.cfg

2019-01-02_20:21:35_CET [openHABian] Checking for default openHABian >username:password combination… FAILED

2019-01-02_20:21:49_CET [openHABian] We hope you got what you came for! See >you again soon :wink:

What I have to do please to get this successfully finished?

Thanks…

2 Likes

I just tried install Grafana and influxdb from openhabian-config as well… openhab 2.5 latest snapshot.
I ended up with an unsuccess installation too… It seems like everything got installed and running, but the password for Grafana is wrong!

This is the full installation process:

[13:31:11] openhabian@openHABianPi:~$ sudo openhabian-config
[sudo] password for openhabian:
2019-01-03_13:31:35_CET [openHABian] Checking for root privileges... OK
2019-01-03_13:31:35_CET [openHABian] Loading configuration file '/etc/openhabian.conf'... OK
2019-01-03_13:31:35_CET [openHABian] openHABian configuration tool version: [master]v1.4.1-435(e0a4d5e)
2019-01-03_13:31:35_CET [openHABian] Checking for changes in origin... Updates available...
2019-01-03_13:31:39_CET [openHABian] Updating myself... OK - Commit history (oldest to newest):


62f8f25 - Update Tellstick-Core dependency (#499) (13 hours ago) <Elias Gabrielsson> E
 functions/packages.sh | 14 ++++++++++++--
 1 file changed, 12 insertions(+), 2 deletions(-)


openHABian configuration tool successfully updated.
Visit the development repository for more details: https://github.com/openhab/openhabian
The tool will now restart to load the updates...


2019-01-03_13:31:41_CET [openHABian] Checking for root privileges... OK
2019-01-03_13:31:41_CET [openHABian] Loading configuration file '/etc/openhabian.conf'... OK
2019-01-03_13:31:41_CET [openHABian] openHABian configuration tool version: [master]v1.4.1-436(62f8f25)
2019-01-03_13:31:41_CET [openHABian] Checking for changes in origin... OK
2019-01-03_13:33:13_CET [openHABian] Setting up InfluxDB and Grafana...

Installing InfluxDB...

$ apt -y install apt-transport-https
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-transport-https is already the newest version (1.4.8).
The following package was automatically installed and is no longer required:
  triggerhappy
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
--2019-01-03 13:34:21--  https://repos.influxdata.com/influxdb.key
Resolving repos.influxdata.com (repos.influxdata.com)... 143.204.247.109, 143.204.247.5, 143.204.247.45, ...
Connecting to repos.influxdata.com (repos.influxdata.com)|143.204.247.109|: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

2019-01-03 13:34:21 (69.7 MB/s) - written to stdout [3108/3108]

OK

$ apt update
Ign:1 http://repos.azulsystems.com/debian stable InRelease
Get:2 http://archive.raspberrypi.org/debian stretch InRelease [25.4 kB]
Hit:3 http://repos.azulsystems.com/debian stable Release
Hit:4 http://raspbian.raspberrypi.org/raspbian stretch InRelease
Hit:6 https://deb.nodesource.com/node_8.x stretch InRelease
Get:7 https://repos.influxdata.com/debian stretch InRelease [4,732 B]
Ign:5 https://openhab.jfrog.io/openhab/openhab-linuxpkg unstable InRelease
Hit:9 https://openhab.jfrog.io/openhab/openhab-linuxpkg unstable Release
Get:10 http://archive.raspberrypi.org/debian stretch/main armhf Packages [200 kB]
Get:11 https://repos.influxdata.com/debian stretch/stable armhf Packages [918 B]
Fetched 231 kB in 5s (41.2 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
All packages are up to date.

$ apt -y install influxdb
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  triggerhappy
Use 'sudo apt autoremove' to remove it.
The following NEW packages will be installed:
  influxdb
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 43.0 MB of archives.
After this operation, 93.2 MB of additional disk space will be used.
Get:1 https://repos.influxdata.com/debian stretch/stable armhf influxdb armhf 1.7.2-1 [43.0 MB]
Fetched 43.0 MB in 5s (7,964 kB/s)
Selecting previously unselected package influxdb.
(Reading database ... 46254 files and directories currently installed.)
Preparing to unpack .../influxdb_1.7.2-1_armhf.deb ...
Unpacking influxdb (1.7.2-1) ...
Setting up influxdb (1.7.2-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.7.6.1-2) ...
Updating FireMotD available updates count ...

$ systemctl daemon-reload

$ systemctl enable influxdb.service

$ systemctl restart influxdb.service
OK Configure InfluxDB admin account... {"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/i          nfluxdb.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

$ systemctl restart 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}]}
OK Installing Grafana...
$ wget https://s3-us-west-2.amazonaws.com/grafana-releases/release/grafana_5.3.4_armhf.deb
--2019-01-03 13:35:58--  https://s3-us-west-2.amazonaws.com/grafana-releases/release/grafana_5.3.4_armhf.deb
Resolving s3-us-west-2.amazonaws.com (s3-us-west-2.amazonaws.com)... 52.218.204.128
Connecting to s3-us-west-2.amazonaws.com (s3-us-west-2.amazonaws.com)|52.218.204.128|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 27059330 (26M) [application/x-debian-package]
Saving to: ‘grafana_5.3.4_armhf.deb’

grafana_5.3.4_armhf.deb        100%[=================================================>]  25.81M  2.86MB/s    in 11s

2019-01-03 13:36:09 (2.44 MB/s) - ‘grafana_5.3.4_armhf.deb’ saved [27059330/27059330]


$ apt update
Ign:1 http://repos.azulsystems.com/debian stable InRelease
Hit:2 http://raspbian.raspberrypi.org/raspbian stretch InRelease
Hit:3 http://archive.raspberrypi.org/debian stretch InRelease
Hit:4 http://repos.azulsystems.com/debian stable Release
Hit:6 https://repos.influxdata.com/debian stretch InRelease
Hit:7 https://deb.nodesource.com/node_8.x stretch InRelease
Ign:5 https://openhab.jfrog.io/openhab/openhab-linuxpkg unstable InRelease
Hit:8 https://openhab.jfrog.io/openhab/openhab-linuxpkg unstable Release
Reading package lists... Done
Building dependency tree
Reading state information... Done
All packages are up to date.

$ apt-get install -y adduser libfontconfig
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'libfontconfig1' instead of 'libfontconfig'
adduser is already the newest version (3.115).
libfontconfig1 is already the newest version (2.11.0-6.7).
libfontconfig1 set to manually installed.
The following package was automatically installed and is no longer required:
  triggerhappy
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

$ dpkg -i grafana_5.3.4_armhf.deb
Selecting previously unselected package grafana.
(Reading database ... 46280 files and directories currently installed.)
Preparing to unpack grafana_5.3.4_armhf.deb ...
Unpacking grafana (5.3.4) ...
Setting up grafana (5.3.4) ...
Adding system user `grafana' (UID 111) ...
Adding new user `grafana' (UID 111) 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 usi          ng 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 (232-25+deb9u6) ...

$ 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-serv          er.service.

$ systemctl start grafana-server.service
OK
Updating Grafana admin password...curl: (7) Failed to connect to localhost port 3000: Connection refused
FAILED Updating Grafan configuration...
$ sed -i -e /^# disable user signup \/ registration/ { n ; s/^;allow_sign_up = true/allow_sign_up = false/ } /etc/grafana          /grafana.ini

$ sed -i -e /^# enable anonymous access/ { n ; s/^;enabled = false/enabled = true/ } /etc/grafana/grafana.ini

$ systemctl restart grafana-server.service
Connection Grafana to InfluxDB...curl: (7) Failed to connect to localhost port 3000: Connection refused
Adding openHAB dashboard tile for Grafana... 2019-01-03_13:37:49_CET [openHABian] Adding an openHAB dashboard tile for 'grafana'... OK
Adding install InfluxDB with database configuration to OpenHAB
$ touch /etc/openhab2/services/influxdb.cfg

This is not good :frowning:

EDIT.
Seems like the default username and pw can be used.
now I just need to figure how to tell Grafana to use Influxdb… And what the database is.

Same issue as above. The script seem to fail when configuring graphana

systemctl start grafana-server.service
OK
Updating Grafana admin password...curl: (7) Failed to connect to localhost port 3000: Connection refused
FAILED Updating Grafan configuration...
$ sed -i -e /^# disable user signup \/ registration/ { n ; s/^;allow_sign_up = true/allow_sign_up = false/ } /etc/grafana/grafana.ini

$ sed -i -e /^# enable anonymous access/ { n ; s/^;enabled = false/enabled = true/ } /etc/grafana/grafana.ini

$ systemctl restart grafana-server.service
Connection Grafana to InfluxDB...{"message":"Invalid username or password"}Adding openHAB dashboard tile for Grafana... 2019-01-24_23:12:32_CET [openHABian] Adding an openHAB dashboard tile for 'grafana'... OK
Adding install InfluxDB with database configuration to OpenHAB
$ touch /etc/openhab2/services/influxdb.cfg

ran into the same issue: (OH 2.4 downgraded from 2.5)

$ 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
Updating Grafana admin password...curl: (7) Failed to connect to localhost port 3000: Verbindungsaufbau abgelehnt
FAILED Updating Grafan configuration...
$ sed -i -e /^# disable user signup \/ registration/ { n ; s/^;allow_sign_up = true/allow_sign_up = false/ } /etc/grafana/grafana.ini

$ sed -i -e /^# enable anonymous access/ { n ; s/^;enabled = false/enabled = true/ } /etc/grafana/grafana.ini

$ systemctl restart grafana-server.service
Connection Grafana to InfluxDB...{"message":"Invalid username or password"}Adding openHAB dashboard tile for Grafana... 2019-04-01_22:58:48_CEST [openHABian] Adding an openHAB dashboard tile for 'grafana'... Replacing... OK
Adding install InfluxDB with database configuration to OpenHAB

Is there a way to start over? deleting settings files and all created databases.
Then perhaps setting influx and grafana up via console and not with this config tool? :slight_smile:

removed these files:

/etc/grafana/grafana.ini
/etc/influxdb/influxdb.conf

started over, doesn’t help.

There is this mega thread: [InfluxDB+Grafana persistence and graphing]

removed the influx installation:

sudo apt-get purge --auto-remove influxdb
sudo ls /var/lib/influxdb/
sudo rm -r /var/lib/influxdb/
sudo reboot
sudo apt-get install influxdb
sudo service influxdb start
sudo service influxdb status
influx

Now i could follow the instructions (see link above).
Discovered wrong file permissions in my installation:

cd /etc/openhab2
ls -l  // influxdb.cfg belonged to root ...
sudo chown openhab:openhab influxdb.cfg // not anymore ...

Grafana - Installation:

sudo apt-get purge --auto-remove grafana
sudo rm -r /etc/grafana/

Despite of this removal, the old password where still present. Luckily i remembered them.
My plan was to start a clean, new installation of influx and grafana. But obviosly i missed a file somewhere. :-o

Installation: http://docs.grafana.org/installation/debian/

In the ubuntu repository (apt get install grafana) is version 5.4.x …
With the guideline on the grafana homegpage, it will install 6.0.2. …

Hi Richard,
Just going to acknowledge that your problem is noticed.
I open a bug issue over here: https://github.com/openhab/openhabian/issues/562

// EG

I was able to install

  • influxDB with a running db.
  • grafana with succesfull connection (regarding to the grafana website) to the influx DB
  • installed Influx Persistance, checked influxdb.cfg file, set up a strategy,

… but no entrys are made from openHAB into the database. Have no clue …

Can anyone give me a hint how to chase the bug?

It happens quite often, that a “user friendly” auto script puts settings somewhere in the system and the “normal” end user is not able to follow the given installation manuals anymore and has no choice but to reinstall the whole system … and hopefully not run in the same issue.

… but no entrys are made from openHAB into the database. Have no clue …

This configuration is outside the scope of the installation script as it is very a lot between installations. Please take a look at this documentation: https://www.openhab.org/docs/configuration/persistence.html

Thank you for your reply!

Got it working … somehow with reboots. :-):roll_eyes:

1 Like

I have also a Problem with grafana. It seems there is something wrong with the Public Key:

Fehl:12 https://packagecloud.io/grafana/stable/debian stretch InRelease
Die folgenden Signaturen konnten nicht überprüft werden, weil ihr öffentlicher Schlüssel nicht verfügbar ist: NO_PUBKEY 40F370A1F9081B64
Paketlisten werden gelesen… Fertig
W: GPG-Fehler: https://packagecloud.io/grafana/stable/debian stretch InRelease: Die folgenden Signaturen konnten nicht überprüft werden, weil ihr öffentlicher Schlüssel nicht verfügbar ist: NO_PUBKEY 40F370A1F9081B64
E: Das Depot »https://packagecloud.io/grafana/stable/debian stretch InRelease« ist nicht signiert.
N: Eine Aktualisierung von solch einem Depot kann nicht auf eine sichere Art durchgeführt werden, daher ist es standardmäßig deaktiviert.
N: Weitere Details zur Erzeugung von Paketdepots sowie zu deren Benutzerkonfiguration finden Sie in der Handbuchseite apt-secure(8).
$ apt -y install grafana
Paketlisten werden gelesen… Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen… Fertig
E: Paket grafana kann nicht gefunden werden.
$ systemctl daemon-reload
$ systemctl enable grafana-server.service
Failed to enable unit: Unit file grafana-server.service does not exist.
$ systemctl start grafana-server.service
Failed to start grafana-server.service: Unit grafana-server.service not found.
FAILED
Updating Grafana admin password…curl: (7) Failed to connect to localhost port 3000: Connection refused
FAILED Updating Grafan configuration…
$ sed -i -e /^# disable user signup / registration/ { n ; s/^;allow_sign_up = true/allow_sign_up = false/ } /etc/grafana/grafana.ini
sed: can’t read /etc/grafana/grafana.ini: No such file or directory
$ sed -i -e /^# enable anonymous access/ { n ; s/^;enabled = false/enabled = true/ } /etc/grafana/grafana.ini
sed: can’t read /etc/grafana/grafana.ini: No such file or directory
$ systemctl restart grafana-server.service
Failed to restart grafana-server.service: Unit grafana-server.service not found.
Connection Grafana to InfluxDB…curl: (7) Failed to connect to localhost port 3000: Connection refused
Adding openHAB dashboard tile for Grafana… 2019-04-03_06:58:02_CEST [openHABian] Adding an openHAB dashboard tile for ‘grafana’… OK
Adding install InfluxDB with database configuration to OpenHAB
$ touch /etc/openhab2/services/influxdb.cfg
2019-04-03_06:58:33_CEST [openHABian] Checking for default openHABian username:password combination… SKIPPED (method not implemented)
2019-04-03_06:58:33_CEST [openHABian] We hope you got what you came for! See you again soon :wink:

From now I also get a failure if I want to update my system with

sudo apt-get update:

Holen:12 https://packagecloud.io/grafana/stable/debian stretch InRelease [23,4 kB]
Fehl:12 https://packagecloud.io/grafana/stable/debian stretch InRelease
Die folgenden Signaturen konnten nicht überprüft werden, weil ihr öffentlicher Schlüssel nicht verfügbar ist: NO_PUBKEY 40F370A1F9081B64
Paketlisten werden gelesen… Fertig
W: GPG-Fehler: https://packagecloud.io/grafana/stable/debian stretch InRelease: Die folgenden Signaturen konnten nicht überprüft werden, weil ihr öffentlicher Schlüssel nicht verfügbar ist: NO_PUBKEY 40F370A1F9081B64
E: Das Depot »https://packagecloud.io/grafana/stable/debian stretch InRelease« ist nicht signiert.
N: Eine Aktualisierung von solch einem Depot kann nicht auf eine sichere Art durchgeführt werden, daher ist es standardmäßig deaktiviert.
N: Weitere Details zur Erzeugung von Paketdepots sowie zu deren Benutzerkonfiguration finden Sie in der Handbuchseite apt-secure(8).
[07:01:15] steuerung@steuerung:~$

Edit:
I was able to solve this error. You have to change /etc/apt/sources.list.d/grafana.list
and change the entry to deb https://packages.grafana.com/oss/deb stable main