mit backitup kein Influxdb und Grafana backup möglich

simatec

@willi-wunder Dann war aber die Ausgabe vorher nicht vollständig...

simatec

sudo apt remove influxdb2-cli
sudo apt install influxdb2-client

Willi-Wunder

@simatec
Du meinst wegen sudo rm /usr/bin/influx ? Das hatte ich beim Code kopieren übersehen und dann nachgetragen.

Willi-Wunder

pi@iobroker:~ $ sudo apt remove influxdb2-cli
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages will be REMOVED:
  influxdb2-cli
0 upgraded, 0 newly installed, 1 to remove and 3 not upgraded.
After this operation, 24.1 MB disk space will be freed.
Do you want to continue? [Y/n] y
apt-listchanges: Can't set locale; make sure $LC_* and $LANG are correct!
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = "de_DE",
        LC_ALL = "de_DE",
        LANG = (unset)
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
(Reading database ... 146179 files and directories currently installed.)
Removing influxdb2-cli (2.7.3-1) ...
pi@iobroker:~ $ sudo apt install influxdb2-client
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following NEW packages will be installed:
  influxdb2-client
0 upgraded, 1 newly installed, 0 to remove and 3 not upgraded.
Need to get 0 B/10.5 MB of archives.
After this operation, 24.0 MB of additional disk space will be used.
apt-listchanges: Can't set locale; make sure $LC_* and $LANG are correct!
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = "de_DE",
        LC_ALL = "de_DE",
        LANG = (unset)
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
(Reading database ... 146176 files and directories currently installed.)
Preparing to unpack .../influxdb2-client_2.7.1-1_arm64.deb ...
Unpacking influxdb2-client (2.7.1-1) ...
Setting up influxdb2-client (2.7.1-1) ...

simatec

@willi-wunder ohhh je da ist soviel krum ...
Was bekommst du nun als Ausgabe von

sudo influx auth list -t 74VTRbf_Qc6sAG_goAo4AMkdEdPKkPdWFyxVzrPhY5hNuxX43QdnYAiIWp9rmexTYHJbxa1I0dQ_wNkqkexV7A== --json

Willi-Wunder

pi@iobroker:~ $ sudo influx auth list -t 74VTRbf_Qc6sAG_goAo4AMkdEdPKkPdWFyxVzrPhY5hNuxX43QdnYAiIWp9rmexTYHJbxa1I0dQ_wNkqkexV7A== --json
/usr/local/bin/influx: 1: Syntax error: ")" unexpected

Thomas Braun

@willi-wunder

sudo apt update
sudo apt full-upgrade
sudo reboot

Willi-Wunder

pi@iobroker:~ $ sudo apt update
Hit:1 http://deb.debian.org/debian bookworm InRelease
Hit:2 http://deb.debian.org/debian-security bookworm-security InRelease
Hit:3 http://archive.raspberrypi.com/debian bookworm InRelease
Hit:4 http://deb.debian.org/debian bookworm-updates InRelease
Hit:5 https://repos.influxdata.com/debian stable InRelease
Hit:6 https://apt.grafana.com stable InRelease
Hit:7 https://deb.nodesource.com/node_18.x nodistro InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
3 packages can be upgraded. Run 'apt list --upgradable' to see them.
pi@iobroker:~ $ sudo apt full-upgrade
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
The following packages will be upgraded:
  curl libcurl3-gnutls libcurl4
3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 1034 kB of archives.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://deb.debian.org/debian-security bookworm-security/main arm64 curl arm64 7.88.1-10+deb12u5 [308 kB]
Get:2 http://deb.debian.org/debian-security bookworm-security/main arm64 libcurl4 arm64 7.88.1-10+deb12u5 [366 kB]
Get:3 http://deb.debian.org/debian-security bookworm-security/main arm64 libcurl3-gnutls arm64 7.88.1-10+deb12u5 [360 kB]
Fetched 1034 kB in 0s (3344 kB/s)
apt-listchanges: Can't set locale; make sure $LC_* and $LANG are correct!
Changelogs werden gelesen... Fertig
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = "de_DE",
        LC_ALL = "de_DE",
        LANG = (unset)
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
(Reading database ... 146179 files and directories currently installed.)
Preparing to unpack .../curl_7.88.1-10+deb12u5_arm64.deb ...
Unpacking curl (7.88.1-10+deb12u5) over (7.88.1-10+deb12u4) ...
Preparing to unpack .../libcurl4_7.88.1-10+deb12u5_arm64.deb ...
Unpacking libcurl4:arm64 (7.88.1-10+deb12u5) over (7.88.1-10+deb12u4) ...
Preparing to unpack .../libcurl3-gnutls_7.88.1-10+deb12u5_arm64.deb ...
Unpacking libcurl3-gnutls:arm64 (7.88.1-10+deb12u5) over (7.88.1-10+deb12u4) ...
Setting up libcurl3-gnutls:arm64 (7.88.1-10+deb12u5) ...
Setting up libcurl4:arm64 (7.88.1-10+deb12u5) ...
Setting up curl (7.88.1-10+deb12u5) ...
Processing triggers for man-db (2.11.2-2) ...
Processing triggers for libc-bin (2.36-9+rpt2+deb12u3) ...

Nach Reboot:

pi@iobroker:~ $ sudo influx auth list -t 74VTRbf_Qc6sAG_goAo4AMkdEdPKkPdWFyxVzrPhY5hNuxX43QdnYAiIWp9rmexTYHJbxa1I0dQ_wNkqkexV7A== --json
/usr/local/bin/influx: 1: Syntax error: ")" unexpected

Bleibt es leider so......

Thomas Braun

@willi-wunder

ls -lAh /usr/local/bin/influx

Willi-Wunder

pi@iobroker:~ $ ls -lAh /usr/local/bin/influx
-rwxr-xr-x 1 root root 25M Dec 26 22:38 /usr/local/bin/influx

Thomas Braun

@willi-wunder

sudo rm /usr/local/bin/influx

Das ist ein Überbleibsel aus dem manuellen Hantier mit influx. Eine ordentliche Installation landet nicht in /usr/local/bin

Willi-Wunder

@thomas-braun
Bingo Banane........ jetzt kommt etwas. Brauch ich die anderen zwei Einträge? (Iobroker (cloned at 2023-12-26 20:56:55) + Backitup in den API Token in InfluxDB? Diese dann löschen und nur den iobroker behalten?

pi@iobroker:~ $ sudo influx auth list -t 74VTRbf_Qc6sAG_goAo4AMkdEdPKkPdWFyxVzrPhY5hNuxX43QdnYAiIWp9rmexTYHJbxa1I0dQ_wNkqkexV7A== --json
[
        {
                "id": "0c54cd2ed3814000",
                "description": "Iobroker",
                "token": "74VTRbf_Qc6sAG_goAo4AMkdEdPKkPdWFyxVzrPhY5hNuxX43QdnYAiIWp9rmexTYHJbxa1I0dQ_wNkqkexV7A==",
                "status": "active",
                "userName": "Markus",
                "userID": "0c52172c23814000",
                "permissions": [
                        "read:orgs/5585922b87b26ff0/annotations",
                        "write:orgs/5585922b87b26ff0/annotations",
                        "read:orgs/5585922b87b26ff0/authorizations",
                        "write:orgs/5585922b87b26ff0/authorizations",
                        "read:orgs/5585922b87b26ff0/buckets",
                        "write:orgs/5585922b87b26ff0/buckets",
                        "read:orgs/5585922b87b26ff0/checks",
                        "write:orgs/5585922b87b26ff0/checks",
                        "read:orgs/5585922b87b26ff0/dashboards",
                        "write:orgs/5585922b87b26ff0/dashboards",
                        "read:orgs/5585922b87b26ff0/dbrp",
                        "write:orgs/5585922b87b26ff0/dbrp",
                        "read:orgs/5585922b87b26ff0/documents",
                        "write:orgs/5585922b87b26ff0/documents",
                        "read:orgs/5585922b87b26ff0/labels",
                        "write:orgs/5585922b87b26ff0/labels",
                        "read:orgs/5585922b87b26ff0/notebooks",
                        "write:orgs/5585922b87b26ff0/notebooks",
                        "read:orgs/5585922b87b26ff0/notificationEndpoints",
                        "write:orgs/5585922b87b26ff0/notificationEndpoints",
                        "read:orgs/5585922b87b26ff0/notificationRules",
                        "write:orgs/5585922b87b26ff0/notificationRules",
                        "read:/orgs/5585922b87b26ff0",
                        "read:orgs/5585922b87b26ff0/remotes",
                        "write:orgs/5585922b87b26ff0/remotes",
                        "read:orgs/5585922b87b26ff0/replications",
                        "write:orgs/5585922b87b26ff0/replications",
                        "read:orgs/5585922b87b26ff0/scrapers",
                        "write:orgs/5585922b87b26ff0/scrapers",
                        "read:orgs/5585922b87b26ff0/secrets",
                        "write:orgs/5585922b87b26ff0/secrets",
                        "read:orgs/5585922b87b26ff0/sources",
                        "write:orgs/5585922b87b26ff0/sources",
                        "read:orgs/5585922b87b26ff0/tasks",
                        "write:orgs/5585922b87b26ff0/tasks",
                        "read:orgs/5585922b87b26ff0/telegrafs",
                        "write:orgs/5585922b87b26ff0/telegrafs",
                        "read:/users/0c52172c23814000",
                        "write:/users/0c52172c23814000",
                        "read:orgs/5585922b87b26ff0/variables",
                        "write:orgs/5585922b87b26ff0/variables",
                        "read:orgs/5585922b87b26ff0/views",
                        "write:orgs/5585922b87b26ff0/views"
                ]
        },
        {
                "id": "0c55f9fbfc67e000",
                "description": "Iobroker (cloned at 2023-12-26 20:56:55)",
                "token": "2HXiLlQiU_mc3wKWMMkPSlnH66opy68vpkXBxIkWlDfzwpOFf3JjRfk8HUdEUxLegV3Vy0qHSY7dIR78jUB8bA==",
                "status": "active",
                "userName": "Markus",
                "userID": "0c52172c23814000",
                "permissions": [
                        "read:orgs/5585922b87b26ff0/annotations",
                        "write:orgs/5585922b87b26ff0/annotations",
                        "read:orgs/5585922b87b26ff0/authorizations",
                        "write:orgs/5585922b87b26ff0/authorizations",
                        "read:orgs/5585922b87b26ff0/buckets",
                        "write:orgs/5585922b87b26ff0/buckets",
                        "read:orgs/5585922b87b26ff0/checks",
                        "write:orgs/5585922b87b26ff0/checks",
                        "read:orgs/5585922b87b26ff0/dashboards",
                        "write:orgs/5585922b87b26ff0/dashboards",
                        "read:orgs/5585922b87b26ff0/dbrp",
                        "write:orgs/5585922b87b26ff0/dbrp",
                        "read:orgs/5585922b87b26ff0/documents",
                        "write:orgs/5585922b87b26ff0/documents",
                        "read:orgs/5585922b87b26ff0/labels",
                        "write:orgs/5585922b87b26ff0/labels",
                        "read:orgs/5585922b87b26ff0/notebooks",
                        "write:orgs/5585922b87b26ff0/notebooks",
                        "read:orgs/5585922b87b26ff0/notificationEndpoints",
                        "write:orgs/5585922b87b26ff0/notificationEndpoints",
                        "read:orgs/5585922b87b26ff0/notificationRules",
                        "write:orgs/5585922b87b26ff0/notificationRules",
                        "read:/orgs/5585922b87b26ff0",
                        "read:orgs/5585922b87b26ff0/remotes",
                        "write:orgs/5585922b87b26ff0/remotes",
                        "read:orgs/5585922b87b26ff0/replications",
                        "write:orgs/5585922b87b26ff0/replications",
                        "read:orgs/5585922b87b26ff0/scrapers",
                        "write:orgs/5585922b87b26ff0/scrapers",
                        "read:orgs/5585922b87b26ff0/secrets",
                        "write:orgs/5585922b87b26ff0/secrets",
                        "read:orgs/5585922b87b26ff0/sources",
                        "write:orgs/5585922b87b26ff0/sources",
                        "read:orgs/5585922b87b26ff0/tasks",
                        "write:orgs/5585922b87b26ff0/tasks",
                        "read:orgs/5585922b87b26ff0/telegrafs",
                        "write:orgs/5585922b87b26ff0/telegrafs",
                        "read:/users/0c52172c23814000",
                        "write:/users/0c52172c23814000",
                        "read:orgs/5585922b87b26ff0/variables",
                        "write:orgs/5585922b87b26ff0/variables",
                        "read:orgs/5585922b87b26ff0/views",
                        "write:orgs/5585922b87b26ff0/views"
                ]
        },
        {
                "id": "0c55fb5aac495000",
                "description": "Backitup",
                "token": "qa1TtBLVxvesQrUawIgN98VLv4__pSLmstVX6L-uW28IlUQk8EvcKNeCbUH82BH3t3JV6RWUB-ssdFdxg4xyqg==",
                "status": "active",
                "userName": "Markus",
                "userID": "0c52172c23814000",
                "permissions": [
                        "read:orgs/5585922b87b26ff0/authorizations",
                        "write:orgs/5585922b87b26ff0/authorizations",
                        "read:orgs/5585922b87b26ff0/buckets",
                        "write:orgs/5585922b87b26ff0/buckets",
                        "read:orgs/5585922b87b26ff0/dashboards",
                        "write:orgs/5585922b87b26ff0/dashboards",
                        "read:/orgs/5585922b87b26ff0",
                        "write:/orgs/5585922b87b26ff0",
                        "read:orgs/5585922b87b26ff0/sources",
                        "write:orgs/5585922b87b26ff0/sources",
                        "read:orgs/5585922b87b26ff0/tasks",
                        "write:orgs/5585922b87b26ff0/tasks",
                        "read:orgs/5585922b87b26ff0/telegrafs",
                        "write:orgs/5585922b87b26ff0/telegrafs",
                        "read:/users/0c52172c23814000",
                        "write:/users/0c52172c23814000",
                        "read:orgs/5585922b87b26ff0/variables",
                        "write:orgs/5585922b87b26ff0/variables",
                        "read:orgs/5585922b87b26ff0/scrapers",
                        "write:orgs/5585922b87b26ff0/scrapers",
                        "read:orgs/5585922b87b26ff0/secrets",
                        "write:orgs/5585922b87b26ff0/secrets",
                        "read:orgs/5585922b87b26ff0/labels",
                        "write:orgs/5585922b87b26ff0/labels",
                        "read:orgs/5585922b87b26ff0/views",
                        "write:orgs/5585922b87b26ff0/views",
                        "read:orgs/5585922b87b26ff0/documents",
                        "write:orgs/5585922b87b26ff0/documents",
                        "read:orgs/5585922b87b26ff0/notificationRules",
                        "write:orgs/5585922b87b26ff0/notificationRules",
                        "read:orgs/5585922b87b26ff0/notificationEndpoints",
                        "write:orgs/5585922b87b26ff0/notificationEndpoints",
                        "read:orgs/5585922b87b26ff0/checks",
                        "write:orgs/5585922b87b26ff0/checks",
                        "read:orgs/5585922b87b26ff0/dbrp",
                        "write:orgs/5585922b87b26ff0/dbrp",
                        "read:orgs/5585922b87b26ff0/notebooks",
                        "write:orgs/5585922b87b26ff0/notebooks",
                        "read:orgs/5585922b87b26ff0/annotations",
                        "write:orgs/5585922b87b26ff0/annotations",
                        "read:orgs/5585922b87b26ff0/remotes",
                        "write:orgs/5585922b87b26ff0/remotes",
                        "read:orgs/5585922b87b26ff0/replications",
                        "write:orgs/5585922b87b26ff0/replications"
                ]
        }
]

Willi-Wunder

Backitup klappt aber trotzdem noch nicht

[DEBUG] [influxDB] - InfluxDB-Backup started ...
[DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory: "/opt/iobroker/backups/influxDB_2023_12_27-00_04_27_backupiobroker"
[DEBUG] [influxDB] - InfluxDB tmp directory "/opt/iobroker/backups/influxDB_2023_12_27-00_04_27_backupiobroker" successfully deleted
[DEBUG] [influxDB] - 
[ERROR] [influxDB] - Error: Command failed: influx backup --bucket Iobroker -t 74VTRbf_Qc6sAG_goAo4AMkdEdPKkPdWFyxVzrPhY5hNuxX43QdnYAiIWp9rmexTYHJbxa1I0dQ_wNkqkexV7A== "/opt/iobroker/backups/influxDB_2023_12_27-00_04_27_backupiobroker"
2023/12/27 00:04:27 INFO: Downloading metadata snapshot
Error: failed to backup metadata: failed to download metadata snapshot: 401 Unauthorized: read:authorizations is unauthorized

simatec

@willi-wunder Bingo ... du hast deinen Operator-Token gelöscht
https://github.com/simatec/ioBroker.backitup/wiki/Diverse-Anleitungen-für-ioBroker.backitup#operator-token-für-influxdb-2x-wiederherstellen

Willi-Wunder

@simatec

pi@iobroker:~ $ sudo influxd recovery auth create-operator --org my-org --userna                                                                            me Markus --bolt-path /var/lib/influxdb2/influxd.bolt
2023-12-26T23:12:55.164195Z     info    Resources opened        {"log_id": "0mM6                                                                            HmUW000", "system": "bolt-kvstore", "path": "/var/lib/influxdb2/influxd.bolt"}
Error: bucket "authorizationsv1": bucket not found
See 'influxd -h' for help

simatec

@willi-wunder da fehlt die Hälfte

simatec

@willi-wunder sagte in mit backitup kein Influxdb und Grafana backup möglich:

Error: bucket "authorizationsv1": bucket not found

Es steht doch im der Anleitung, was du machen musst, wenn dieser Fehler kommt ...
Du hast mit großer Wahrscheinlichkeit von einer influxdb 1.x migriert und deshalb passt der Pfad nicht

Willi-Wunder

@simatec
sudo influxd recovery auth create-operator --org my-org --username Markus --bolt-path /var/lib/influxdb2/influxd.bolt

Die Zeichen "<>" werden ja weggelassen. Was habe ich noch falsch gemacht?

simatec

@willi-wunder

find / -name influxd.bolt

Willi-Wunder

Du hast mit großer Wahrscheinlichkeit von einer influxdb 1.x migriert und deshalb passt der Pfad nicht

Vermutlich dann eher aus dem einspielen vom Backup. Hatte auf dem neuen System alles neu installiert gehabt, aber dann wird das vermutlich so sein.

Community Forum

NEWS

mit backitup kein Influxdb und Grafana backup möglich

Support us

844

32.4k

81.5k

1.3m