UPDATE 31.10.: Amazon Alexa - ioBroker Skill läuft aus ?

[crunchip]

@Altersrentner ich wollte wissen, ob der status grün ist/bzw aktiv

[Altersrentner]

@HAL
Hallo,
kann ich das so drüber installieren oder meine Installation löschen?
Aber wie!!
Danke

[Altersrentner]

@crunchip

Hatte ich leider übersehen, Entschuldigung
Nein

pi@raspberrypi:~ $ sudo systemctl status influxdb
● 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 Sun 2020-12-20 18:04:01 CET; 13min ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 30313 (code=exited, status=1/FAILURE)

Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Service RestartSec=100ms expired, scheduling r
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Scheduled restart job, restart counter is at 5
Dec 20 18:04:01 raspberrypi systemd[1]: Stopped InfluxDB is an open-source, distributed, time series dat
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Start request repeated too quickly.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Failed with result 'exit-code'.
Dec 20 18:04:01 raspberrypi systemd[1]: Failed to start InfluxDB is an open-source, distributed, time se
lines 1-12/12 (END)
● 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 Sun 2020-12-20 18:04:01 CET; 13min ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 30313 (code=exited, status=1/FAILURE)

Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Service RestartSec=100ms expired, scheduling restart.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Scheduled restart job, restart counter is at 5.
Dec 20 18:04:01 raspberrypi systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Start request repeated too quickly.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Failed with result 'exit-code'.
Dec 20 18:04:01 raspberrypi systemd[1]: Failed to start InfluxDB is an open-source, distributed, time series database.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-12/12 (END)
● 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 Sun 2020-12-20 18:04:01 CET; 13min ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 30313 (code=exited, status=1/FAILURE)

Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Service RestartSec=100ms expired, scheduling restart.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Scheduled restart job, restart counter is at 5.
Dec 20 18:04:01 raspberrypi systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Start request repeated too quickly.
Dec 20 18:04:01 raspberrypi systemd[1]: influxdb.service: Failed with result 'exit-code'.
Dec 20 18:04:01 raspberrypi systemd[1]: Failed to start InfluxDB is an open-source, distributed, time series database.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-12/12 (END)

[crunchip]

@Altersrentner na irgend etwas ist da bei dir faul
probier bitte nochmal in der Reihenfolge

sudo systemctl stop influxdb
sudo systemctl unmask influxdb.service
sudo systemctl start influxdb
sudo systemctl status influxdb

[Altersrentner]

@crunchip

pi@raspberrypi:~ $ sudo systemctl stop influxdb
pi@raspberrypi:~ $ sudo systemctl unmask influxdb.service
pi@raspberrypi:~ $ sudo systemctl start influxdb
pi@raspberrypi:~ $ sudo systemctl status influxdb
● 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 Sun 2020-12-20 18:39:16 CET; 17s ago
     Docs: https://docs.influxdata.com/influxdb/
  Process: 3797 ExecStart=/usr/bin/influxd -config /etc/influxdb/influxdb.conf $INFLUXD_OPTS (code=exited, status=1/FAILURE)
 Main PID: 3797 (code=exited, status=1/FAILURE)

Dec 20 18:39:16 raspberrypi systemd[1]: influxdb.service: Service RestartSec=100ms expired, scheduling restart.
Dec 20 18:39:16 raspberrypi systemd[1]: influxdb.service: Scheduled restart job, restart counter is at 5.
Dec 20 18:39:16 raspberrypi systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Dec 20 18:39:16 raspberrypi systemd[1]: influxdb.service: Start request repeated too quickly.
Dec 20 18:39:16 raspberrypi systemd[1]: influxdb.service: Failed with result 'exit-code'.
Dec 20 18:39:16 raspberrypi systemd[1]: Failed to start InfluxDB is an open-source, distributed, time series database.
pi@raspberrypi:~ $

Ampel ist grün

[crunchip]

@Altersrentner die Ampel interessiert momentan nicht, da dein influx-service nicht läuft, Zeile 7
hast du in der

/etc/influxdb/influxdb.conf

irgendwas geändert/angepasst?

[Altersrentner]

@crunchip NEIN!!

[crunchip]

@Altersrentner dann nochmal, mit enable...

sudo systemctl stop influxdb
sudo systemctl unmask influxdb.service
sudo systemctl enable influxdb
sudo systemctl start influxdb
sudo systemctl status influxdb
netstat -tulpen

[Altersrentner]

@crunchip

pi@raspberrypi:~ $ sudo systemctl stop influxdb
pi@raspberrypi:~ $ sudo systemctl unmask influxdb.service
pi@raspberrypi:~ $ sudo systemctl enable influxdb
pi@raspberrypi:~ $ sudo systemctl start influxdb
pi@raspberrypi:~ $ sudo systemctl status influxdb
● 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 Sun 2020-12-20 19:07:54 CET; 26s ago
     Docs: https://docs.influxdata.com/influxdb/
  Process: 7963 ExecStart=/usr/bin/influxd -config /etc/influxdb/influxdb.conf $INFLUXD_OPTS (code=exited, status=1/FAILURE)
 Main PID: 7963 (code=exited, status=1/FAILURE)

Dec 20 19:07:54 raspberrypi systemd[1]: influxdb.service: Service RestartSec=100ms expired, scheduling restart.
Dec 20 19:07:54 raspberrypi systemd[1]: influxdb.service: Scheduled restart job, restart counter is at 5.
Dec 20 19:07:54 raspberrypi systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Dec 20 19:07:54 raspberrypi systemd[1]: influxdb.service: Start request repeated too quickly.
Dec 20 19:07:54 raspberrypi systemd[1]: influxdb.service: Failed with result 'exit-code'.
Dec 20 19:07:54 raspberrypi systemd[1]: Failed to start InfluxDB is an open-source, distributed, time series database.
pi@raspberrypi:~ $ netstat -tulpen
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode      PID/Program name
tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      1001       882108     -
tcp        0      0 127.0.0.1:9001          0.0.0.0:*               LISTEN      1001       881190     -
tcp        0      0 192.168.178.41:2000     0.0.0.0:*               LISTEN      1001       887022     -
tcp        0      0 192.168.178.41:2001     0.0.0.0:*               LISTEN      1001       884408     -
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          15904      -
tcp        0      0 127.0.0.1:6010          0.0.0.0:*               LISTEN      1000       1015445    -
tcp        0      0 192.168.178.41:8701     0.0.0.0:*               LISTEN      1001       886967     -
tcp6       0      0 :::61991                :::*                    LISTEN      1001       883885     -
tcp6       0      0 :::8081                 :::*                    LISTEN      1001       883049     -
tcp6       0      0 :::8083                 :::*                    LISTEN      1001       885009     -
tcp6       0      0 :::8084                 :::*                    LISTEN      1001       882261     -
tcp6       0      0 :::22                   :::*                    LISTEN      0          15906      -
tcp6       0      0 ::1:6010                :::*                    LISTEN      1000       1015444    -
tcp6       0      0 :::8090                 :::*                    LISTEN      1001       884598     -
udp        0      0 0.0.0.0:5353            0.0.0.0:*                           108        14271      -
udp        0      0 0.0.0.0:61991           0.0.0.0:*                           1001       883886     -
udp        0      0 0.0.0.0:5683            0.0.0.0:*                           1001       884062     -
udp        0      0 0.0.0.0:68              0.0.0.0:*                           0          15151      -
udp        0      0 0.0.0.0:43619           0.0.0.0:*                           108        14273      -
udp        0      0 0.0.0.0:9898            0.0.0.0:*                           1001       881469     -
udp        0      0 0.0.0.0:53421           0.0.0.0:*                           1001       882347     -
udp6       0      0 :::5353                 :::*                                108        14272      -
udp6       0      0 :::546                  :::*                                0          18566      -
udp6       0      0 :::51291                :::*                                108        14274      -
pi@raspberrypi:~ $

[crunchip]

@Altersrentner so kommen wir nicht weiter, da is der Wurm drin und kann dir ehrlich gesagt, nicht sagen, wo der Fehler liegt.
Ne Möglichkeit dann doch nochmal influx zu entfernen und frisch installieren.

sudo apt-get autoremove influxdb

danach nochmal eine installation anstoßen, bezieht sich auf ubuntu

wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add -
source /etc/lsb-release
echo "deb https://repos.influxdata.com/${DISTRIB_ID,,} ${DISTRIB_CODENAME} stable" | sudo tee /etc/apt/sources.list.d/influxdb.list

sudo apt-get update && sudo apt-get install influxdb
sudo systemctl unmask influxdb.service
sudo systemctl start influxdb

für debian

wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add -
source /etc/os-release
echo "deb https://repos.influxdata.com/debian $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/influxdb.list
sudo apt-get update && sudo apt-get install influxdb
sudo systemctl enable influxdb
sudo systemctl start influxdb

wenn fertig, prüfen ob der Dienst läuft

sudo systemctl status influxdb

[Altersrentner]

@crunchip
OK,
Nach welcher Vorlage?

pi@raspberrypi:~ $ sudo apt-get autoremove influxdb
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
  influxdb rpi-eeprom-images
0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded.
After this operation, 153 MB disk space will be freed.
Do you want to continue? [Y/n] y
y
(Reading database ... 61344 files and directories currently installed.)
Removing influxdb (1.8.3-1) ...
Removing rpi-eeprom-images (11.0-1) ...
Processing triggers for man-db (2.8.5-2) ...
pi@raspberrypi:~ $

War es das schon?

[crunchip]

@Altersrentner scheint so,
hab oben weiter ergänzt, zwecks Installation

[Altersrentner]

@crunchip
Wo ist oben?
Das sind die Angaben zu meinem System

pi@raspberrypi:~ $ cat /proc/version
Linux version 5.4.79-v7l+ (dom@buildbot) (gcc version 8.4.0 (Ubuntu/Linaro 8.4.0-3ubuntu1)) #1373 SMP Mon Nov 23 13:27:40                  GMT 2020
pi@raspberrypi:~ $ uname -a
Linux raspberrypi 5.4.79-v7l+ #1373 SMP Mon Nov 23 13:27:40 GMT 2020 armv7l GNU/Linux
pi@raspberrypi:~ $ cat /etc/debian_version
10.7
pi@raspberrypi:~ $

[crunchip]

@Altersrentner sagte in Problem bei Influx Installation:

Wo ist oben?

https://forum.iobroker.net/post/541116
ah moment stop, Ubuntu
@Altersrentner sorry, war grad abgelenkt, hatte kleinen zwischenfall,
also debian läuft?, dann war ich doch richtig, mit der Anleitung

[Altersrentner]

@crunchip
Zeile 2 ?

pi@raspberrypi:~ $ wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add -
OK
pi@raspberrypi:~ $ source /etc/lsb-release
-bash: /etc/lsb-release: No such file or directory
pi@raspberrypi:~ $ sudo source /etc/lsb-release
sudo: source: command not found
pi@raspberrypi:~ $ source /etc/lsb-release
-bash: /etc/lsb-release: No such file or directory
pi@raspberrypi:~ $

[crunchip]

@Altersrentner das sind doch ganze Befehle, guck mal selbst, auf der ganz normalen offiziellen Seite

[Altersrentner]

@crunchip

● influxdb.service - InfluxDB is an open-source, distributed, time series database
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2020-12-20 20:05:48 CET; 20s ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 4285 (influxd)
    Tasks: 14 (limit: 4915)
   CGroup: /system.slice/influxdb.service
           └─4285 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Dec 20 20:05:49 raspberrypi influxd[4285]: ts=2020-12-20T19:05:49.999473Z lvl=info msg="Starting continuous query service" log_id=0RCOY820000 service
Dec 20 20:05:49 raspberrypi influxd[4285]: ts=2020-12-20T19:05:49.999496Z lvl=info msg="Starting HTTP service" log_id=0RCOY820000 service=httpd authe
Dec 20 20:05:49 raspberrypi influxd[4285]: ts=2020-12-20T19:05:49.999517Z lvl=info msg="opened HTTP access log" log_id=0RCOY820000 service=httpd path
Dec 20 20:05:49 raspberrypi influxd[4285]: ts=2020-12-20T19:05:49.999520Z lvl=info msg="Storing statistics" log_id=0RCOY820000 service=monitor db_ins
Dec 20 20:05:50 raspberrypi influxd[4285]: ts=2020-12-20T19:05:49.999745Z lvl=info msg="Listening on HTTP" log_id=0RCOY820000 service=httpd addr=[::]
Dec 20 20:05:50 raspberrypi influxd[4285]: ts=2020-12-20T19:05:49.999809Z lvl=info msg="Starting retention policy enforcement service" log_id=0RCOY82
Dec 20 20:05:50 raspberrypi influxd[4285]: ts=2020-12-20T19:05:50.000038Z lvl=info msg="Listening for signals" log_id=0RCOY820000
Dec 20 20:05:50 raspberrypi influxd[4285]: ts=2020-12-20T19:05:50.004535Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0RCO
Dec 20 20:05:59 raspberrypi influxd[4285]: ts=2020-12-20T19:05:59.234954Z lvl=info msg="Executing query" log_id=0RCOY820000 service=query query="SHOW
Dec 20 20:05:59 raspberrypi influxd[4285]: [httpd] 192.168.178.41 - MEB [20/Dec/2020:20:05:59 +0100] "GET /query?db=iobroker&p=%5BREDACTED%5D&precisi
~
~
~
~
~
~
~
~
~
~
lines 1-19/19 (END)

``
Sieht das gut aus?

[crunchip]

@Altersrentner :+1:

[Altersrentner]

@crunchip
Ich bedanke :+1: :+1: :+1: mich für Deine unendlichen Bemühungen
mir zu helfen.
Für heute ist Schluss.
Morgen ist auch noch ein Tag
Einen schönen Abend
wünscht Michael

[Altersrentner]

@crunchip Hallo,
Der Ärger geht weiter.
Heute Morgen war noch alles im grünen Bereich.
Influydb lief, und der influxdb.0 Adapter war auch grün.
Dann hatte ich grafana installiert.
Konnte über Port 3000 zugreifen.
Bei der Dateneingabe verlief alles gut nur bei Host war
localhost vorgegeben. konnte auch nicht in IP geändert werden.
Nach Sicherung kam die Meldung keine Verbindung möglich.
Darauf habe ich in der influxdb.0 die iP in localhost geändert,
in derHoffnung eine Verbindung zu bekommen.
Leider klappte das nicht.
Nach zurücksetzen localhost in IP bleibt die Ampel jetzt auf gelb.
Habe dann grafana und den influxdb.0 Adapter deinstalliert.
Adapter neu installiert, daten eingegeben, gestartet und die Ampel bleibt gelb.
Im Terminal influxdb überprüft. alles ok, läuft.
Das ist die Fehlermeldung aus dem log.

influxdb.0	2020-12-21 11:05:35.664	error	(1453) Error: authorization failed
influxdb.0	2020-12-21 11:05:35.659	info	(1453) Connecting http://192.168.178.41:8086 ...

Juser und Paswort im Adapter sind die, In influxdb eingegebenen.
Hast Du noch eine Idee?
Gruß Michael