Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. ioBroker Allgemein
    4. Solved: BackITUp: MySQL DB Sicherung schlägt fehl

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Solved: BackITUp: MySQL DB Sicherung schlägt fehl

    This topic has been deleted. Only users with topic management privileges can see it.
    • Azrael42
      Azrael42 @Guest last edited by

      @dp20eic
      Gerne, Adlerauge;)

      richard@RKO-Central:/opt/iobroker/backups$ ls -s -m |grep mysql
      33704 mysql_2023_05_16-02_40_14_backupiobroker.tar.gz,
      34020 mysql_2023_05_17-02_40_14_backupiobroker.tar.gz,
      34344 mysql_2023_05_18-02_40_14_backupiobroker.tar.gz,
      34624 mysql_2023_05_19-02_40_14_backupiobroker.tar.gz,
      34916 mysql_2023_05_20-02_40_14_backupiobroker.tar.gz,
      35204 mysql_2023_05_21-02_40_14_backupiobroker.tar.gz,
      35496 mysql_2023_05_22-02_40_14_backupiobroker.tar.gz,
      35776 mysql_2023_05_23-02_40_14_backupiobroker.tar.gz,
      36040 mysql_2023_05_24-02_40_14_backupiobroker.tar.gz,
      36328 mysql_2023_05_25-02_40_14_backupiobroker.tar.gz,
      0 mysql_2023_05_26-02_40_14_backupiobroker.sql,
      0 mysql_2023_05_26-14_16_32_backupiobroker.sql,
      0 mysql_2023_05_26-14_28_20_backupiobroker.sql,
      0 mysql_2023_05_26-14_29_51_backupiobroker.sql,
      0 mysql_2023_05_27-02_40_14_backupiobroker.sql,
      0 mysql_2023_05_28-02_40_14_backupiobroker.sql,
      ....
      

      Es ist übrigens eine MariaDB keine MySQL. Habe ich vor lauter "MySQL" überall verdrängt.

      Da du oben danach gefragt hattest, im BackITUp Log steht nicht viel drin:

      [DEBUG] [iobroker] - done
      [DEBUG] [mysql] - MySql-Backup started ...
      [ERROR] [mysql] - [IGNORED] Error: Command failed: mysqldump  -u iobroker -p**** iobroker -h RKO-Central -P 3306 > /opt/iobroker/backups/mysql_2023_06_10-18_57_20_backupiobroker.sql
      
      [DEBUG] [nodered] - Created noderedtmp directory
      

      Das sind die beiden einzigen Zeilen zu der DB Sicherung.

      Glasfaser ? 2 Replies Last reply Reply Quote 0
      • Glasfaser
        Glasfaser @Azrael42 last edited by

        @azrael42

        Auf meine Eingangsfrage ... wie installiert ... welche Rechte ... mit welchem User

        da du schreibst ... mit root ..

        Siehe nochmal hier :

        https://forum.iobroker.net/post/904953

        Azrael42 1 Reply Last reply Reply Quote 0
        • Azrael42
          Azrael42 @Glasfaser last edited by

          @glasfaser said in BackITUp: MySQL DB Sicherung schlägt fehl:

          ls -lh /opt/iobroker/backups

          richard@RKO-Central:/opt/iobroker/backups$ ls -lh /opt/iobroker/backups
          total 884M -rw-rw-r--+ 1 iobroker iobroker 6.8M May 16 02:40 iobroker_2023_05_16-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 17 02:40 iobroker_2023_05_17-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 18 02:40 iobroker_2023_05_18-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 19 02:40 iobroker_2023_05_19-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 20 02:40 iobroker_2023_05_20-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 21 02:40 iobroker_2023_05_21-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 22 02:40 iobroker_2023_05_22-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 23 02:40 iobroker_2023_05_23-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 24 02:40 iobroker_2023_05_24-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 25 02:40 iobroker_2023_05_25-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 26 02:40 iobroker_2023_05_26-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 26 14:16 iobroker_2023_05_26-14_16_27_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 26 14:28 iobroker_2023_05_26-14_28_15_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 26 14:29 iobroker_2023_05_26-14_29_46_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 27 02:40 iobroker_2023_05_27-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 28 02:40 iobroker_2023_05_28-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 29 02:40 iobroker_2023_05_29-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 29 21:24 iobroker_2023_05_29-21_24_18_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 29 21:24 iobroker_2023_05_29-21_24_44_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 29 21:28 iobroker_2023_05_29-21_28_23_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 29 21:31 iobroker_2023_05_29-21_31_38_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 30 02:40 iobroker_2023_05_30-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M May 31 02:40 iobroker_2023_05_31-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  1 02:40 iobroker_2023_06_01-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  2 02:40 iobroker_2023_06_02-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  3 02:40 iobroker_2023_06_03-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  4 02:40 iobroker_2023_06_04-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  5 02:40 iobroker_2023_06_05-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  6 02:40 iobroker_2023_06_06-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  7 02:40 iobroker_2023_06_07-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.8M Jun  8 02:40 iobroker_2023_06_08-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun  9 02:40 iobroker_2023_06_09-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun  9 21:52 iobroker_2023_06_09-21_52_47_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun  9 22:03 iobroker_2023_06_09-22_03_44_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 02:40 iobroker_2023_06_10-02_40_10_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 14:51 iobroker_2023_06_10-14_51_36_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 16:52 iobroker_2023_06_10-16_52_08_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 16:54 iobroker_2023_06_10-16_54_13_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 16:59 iobroker_2023_06_10-16_59_29_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 17:00 iobroker_2023_06_10-16_59_59_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 18:57 iobroker_2023_06_10-18_57_15_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker 6.7M Jun 10 19:31 iobroker_2023_06_10-19_31_34_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  33M May 16 02:40 mysql_2023_05_16-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  34M May 17 02:40 mysql_2023_05_17-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  34M May 18 02:40 mysql_2023_05_18-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  34M May 19 02:40 mysql_2023_05_19-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  35M May 20 02:40 mysql_2023_05_20-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  35M May 21 02:40 mysql_2023_05_21-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  35M May 22 02:40 mysql_2023_05_22-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  35M May 23 02:40 mysql_2023_05_23-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  36M May 24 02:40 mysql_2023_05_24-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  36M May 25 02:40 mysql_2023_05_25-02_40_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker    0 May 26 02:40 mysql_2023_05_26-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 26 14:16 mysql_2023_05_26-14_16_32_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 26 14:28 mysql_2023_05_26-14_28_20_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 26 14:29 mysql_2023_05_26-14_29_51_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 27 02:40 mysql_2023_05_27-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 28 02:40 mysql_2023_05_28-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 29 02:40 mysql_2023_05_29-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 29 21:24 mysql_2023_05_29-21_24_23_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 29 21:24 mysql_2023_05_29-21_24_48_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 29 21:28 mysql_2023_05_29-21_28_27_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 29 21:31 mysql_2023_05_29-21_31_42_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 30 02:40 mysql_2023_05_30-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 May 31 02:40 mysql_2023_05_31-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  1 02:40 mysql_2023_06_01-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  2 02:40 mysql_2023_06_02-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  3 02:40 mysql_2023_06_03-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  4 02:40 mysql_2023_06_04-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  5 02:40 mysql_2023_06_05-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  6 02:40 mysql_2023_06_06-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  7 02:40 mysql_2023_06_07-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  8 02:40 mysql_2023_06_08-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  9 02:40 mysql_2023_06_09-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 richard  richard     0 Jun  9 21:59 mysql_2023_06_09-21_52_51_backupiobroker_2.sql
          -rw-rw-r--+ 1 richard  richard     0 Jun 10 16:09 mysql_2023_06_09-21_52_51_backupiobroker_3.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  9 21:58 mysql_2023_06_09-21_52_51_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun  9 22:03 mysql_2023_06_09-22_03_49_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 02:40 mysql_2023_06_10-02_40_14_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 14:51 mysql_2023_06_10-14_51_40_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 16:52 mysql_2023_06_10-16_52_12_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 16:54 mysql_2023_06_10-16_54_18_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 16:59 mysql_2023_06_10-16_59_33_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 17:00 mysql_2023_06_10-17_00_05_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 18:57 mysql_2023_06_10-18_57_20_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker    0 Jun 10 19:31 mysql_2023_06_10-19_31_39_backupiobroker.sql
          -rw-rw-r--+ 1 iobroker iobroker  31K Jun 10 16:52 nodered.0_2023_06_10-16_52_14_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  31K Jun 10 16:54 nodered.0_2023_06_10-16_54_20_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  31K Jun 10 16:59 nodered.0_2023_06_10-16_59_35_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  31K Jun 10 17:00 nodered.0_2023_06_10-17_00_06_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  31K Jun 10 18:57 nodered.0_2023_06_10-18_57_22_backupiobroker.tar.gz
          -rw-rw-r--+ 1 iobroker iobroker  31K Jun 10 19:31 nodered.0_2023_06_10-19_31_41_backupiobroker.tar.gz
          -rw-rw-r--+ 1 richard  richard  255M Jun 10 16:10 test.sql
          

          iob diag:

          Skript v.2023-04-16
          
          *** BASE SYSTEM ***
          Architecture    : x86_64
          Docker          : false
          Virtualization  : none
          Distributor ID: Debian
          Description:    Debian GNU/Linux 11 (bullseye)
          Release:        11
          Codename:       bullseye
          
          PRETTY_NAME="Debian GNU/Linux 11 (bullseye)"
          NAME="Debian GNU/Linux"
          VERSION_ID="11"
          VERSION="11 (bullseye)"
          VERSION_CODENAME=bullseye
          ID=debian
          HOME_URL="https://www.debian.org/"
          SUPPORT_URL="https://www.debian.org/support"
          BUG_REPORT_URL="https://bugs.debian.org/"
          
          Systemuptime and Load:
           19:53:39 up 24 min,  2 users,  load average: 0.09, 0.17, 0.14
          CPU threads: 4
          
          
          *** Time and Time Zones ***
                         Local time: Sat 2023-06-10 19:53:39 CEST
                     Universal time: Sat 2023-06-10 17:53:39 UTC
                           RTC time: Sat 2023-06-10 17:53:39
                          Time zone: Europe/Berlin (CEST, +0200)
          System clock synchronized: yes
                        NTP service: active
                    RTC in local TZ: no
          
          *** User and Groups ***
          richard
          /home/richard
          richard cdrom floppy sudo audio dip video plugdev netdev iobroker
          
          *** X-Server-Setup ***
          X-Server:       false
          Desktop:
          Terminal:       tty
          Boot Target:    graphical.target
          
          *** MEMORY ***
                         total        used        free      shared  buff/cache   available
          Mem:            3.8G        1.5G        1.6G        0.0K        729M        2.1G
          Swap:           975M          0B        975M
          Total:          4.8G        1.5G        2.5G
          
                   3832 M total memory
                   1532 M used memory
                    186 M active memory
                   1861 M inactive memory
                   1570 M free memory
                     49 M buffer memory
                    679 M swap cache
                    975 M total swap
                      0 M used swap
                    975 M free swap
          
          *** FILESYSTEM ***
          Filesystem     Type      Size  Used Avail Use% Mounted on
          udev           devtmpfs  1.9G     0  1.9G   0% /dev
          tmpfs          tmpfs     384M  796K  383M   1% /run
          /dev/sda1      ext4       51G   16G   33G  32% /
          tmpfs          tmpfs     1.9G     0  1.9G   0% /dev/shm
          tmpfs          tmpfs     5.0M     0  5.0M   0% /run/lock
          tmpfs          tmpfs     384M     0  384M   0% /run/user/1000
          
          Messages concerning ext4 filesystem in dmesg:
          [Sat Jun 10 19:29:31 2023] EXT4-fs (sda1): mounted filesystem with ordered data mode. Opts: (null)
          [Sat Jun 10 19:29:31 2023] EXT4-fs (sda1): re-mounted. Opts: errors=remount-ro
          
          Show mounted filesystems (real ones only):
          TARGET SOURCE    FSTYPE OPTIONS
          /      /dev/sda1 ext4   rw,relatime,errors=remount-ro
          
          Files in neuralgic directories:
          
          /var:
          7.5G    /var/
          3.6G    /var/log
          3.5G    /var/log/journal/9f4cb9c0b92448f39a07ae6328078991
          3.5G    /var/log/journal
          3.4G    /var/lib
          
          Hint: You are currently not seeing messages from other users and the system.
                Users in groups 'adm', 'systemd-journal' can see all messages.
                Pass -q to turn off this notice.
          Archived and active journals take up 144.0M in the file system.
          
          /opt/iobroker/backups:
          884M    /opt/iobroker/backups/
          
          /opt/iobroker/iobroker-data:
          1.1G    /opt/iobroker/iobroker-data/
          990M    /opt/iobroker/iobroker-data/files
          712M    /opt/iobroker/iobroker-data/files/vis-2-beta
          680M    /opt/iobroker/iobroker-data/files/vis-2-beta/static
          678M    /opt/iobroker/iobroker-data/files/vis-2-beta/static/js
          
          The five largest files in iobroker-data are:
          33M     /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.10538062.js.map
          19M     /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.904d455f.js.map
          18M     /opt/iobroker/iobroker-data/objects.jsonl
          15M     /opt/iobroker/iobroker-data/files/telegram.admin/rules/static/js/vendors-node_modules_iobroker_adapter-react-v5_assets_devices_parseNames_d_ts-node_modules_io-1d9f06.44fe4a3f.chunk.js.map
          9.7M    /opt/iobroker/iobroker-data/files/vis-2-beta/material-icons/knx-uf.json
          
          *** NodeJS-Installation ***
          
          /usr/bin/nodejs         v16.19.1
          /usr/bin/node           v16.19.1
          /usr/bin/npm            8.19.3
          /usr/bin/npx            8.19.3
          
          
          nodejs:
            Installed: 16.19.1-deb-1nodesource1
            Candidate: 16.19.1-deb-1nodesource1
            Version table:
           *** 16.19.1-deb-1nodesource1 500
                  500 https://deb.nodesource.com/node_16.x bullseye/main amd64 Packages
                  100 /var/lib/dpkg/status
               12.22.12~dfsg-1~deb11u3 500
                  500 http://security.debian.org/debian-security bullseye-security/main amd64 Packages
               12.22.5~dfsg-2~11u1 500
                  500 http://deb.debian.org/debian bullseye/main amd64 Packages
          
          Temp directories causing npm8 problem: 0
          No problems detected
          
          *** ioBroker-Installation ***
          
          ioBroker Status
          iobroker is running on this host.
          
          
          Objects type: jsonl
          States  type: jsonl
          
          MULTIHOSTSERVICE/enabled: false
          
          Core adapters versions
          js-controller:  4.0.24
          admin:          6.3.5
          javascript:     6.1.4
          
          Adapters from github:   2
          
          Adapter State
          + system.adapter.admin.0                  : admin                 : RKO-Central                              -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
          + system.adapter.backitup.0               : backitup              : RKO-Central                              -  enabled
          + system.adapter.cloud.0                  : cloud                 : RKO-Central                              -  enabled
            system.adapter.devices.0                : devices               : RKO-Central                              - disabled
          + system.adapter.discovery.0              : discovery             : RKO-Central                              -  enabled
          + system.adapter.ebus.0                   : ebus                  : RKO-Central                              -  enabled
          + system.adapter.energiefluss.0           : energiefluss          : RKO-Central                              -  enabled
            system.adapter.flot.0                   : flot                  : RKO-Central                              - disabled
            system.adapter.ical.0                   : ical                  : RKO-Central                              -  enabled
          + system.adapter.iot.0                    : iot                   : RKO-Central                              -  enabled
          + system.adapter.javascript.0             : javascript            : RKO-Central                              -  enabled
          + system.adapter.knx.0                    : knx                   : RKO-Central                              -  enabled, bind: 192.168.2.100
          + system.adapter.modbus.0                 : modbus                : RKO-Central                              -  enabled
          + system.adapter.node-red.0               : node-red              : RKO-Central                              -  enabled, port: 1880, bind: 0.0.0.0
          + system.adapter.ping.0                   : ping                  : RKO-Central                              -  enabled
          + system.adapter.smartmeter.0             : smartmeter            : RKO-Central                              -  enabled
          + system.adapter.sql.0                    : sql                   : RKO-Central                              -  enabled, port: 3306
          + system.adapter.telegram.0               : telegram              : RKO-Central                              -  enabled, port: 8443, bind: 0.0.0.0
          + system.adapter.trashschedule.0          : trashschedule         : RKO-Central                              -  enabled
          + system.adapter.vis-inventwo.0           : vis-inventwo          : RKO-Central                              -  enabled
            system.adapter.vis.0                    : vis                   : RKO-Central                              -  enabled
          + system.adapter.web.0                    : web                   : RKO-Central                              -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
          
          + instance is alive
          
          Enabled adapters with bindings
          + system.adapter.admin.0                  : admin                 : RKO-Central                              -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
          + system.adapter.node-red.0               : node-red              : RKO-Central                              -  enabled, port: 1880, bind: 0.0.0.0
          + system.adapter.sql.0                    : sql                   : RKO-Central                              -  enabled, port: 3306
          + system.adapter.telegram.0               : telegram              : RKO-Central                              -  enabled, port: 8443, bind: 0.0.0.0
          + system.adapter.web.0                    : web                   : RKO-Central                              -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
          
          ioBroker-Repositories
          stable        : http://download.iobroker.net/sources-dist.json
          beta          : http://download.iobroker.net/sources-dist-latest.json
          
          Active repo(s): stable
          
          Installed ioBroker-Instances
          Used repository: stable
          Adapter    "admin"        : 6.3.5    , installed 6.3.5
          Adapter    "backitup"     : 2.6.19   , installed 2.6.19
          Adapter    "cloud"        : 4.3.0    , installed 4.3.0
          Adapter    "devices"      : 1.1.2    , installed 1.1.2
          Adapter    "discovery"    : 3.1.0    , installed 3.1.0
          Adapter    "ebus"         : 3.2.1    , installed 3.1.1  [Updatable]
          Adapter    "flot"         : 1.11.0   , installed 1.11.0
          Adapter    "ical"         : 1.13.2   , installed 1.13.2
          Adapter    "iot"          : 1.14.2   , installed 1.14.2
          Adapter    "javascript"   : 6.1.4    , installed 6.1.4
          Controller "js-controller": 4.0.24   , installed 4.0.24
          Adapter    "knx"          : 2.0.17   , installed 2.0.17
          Adapter    "modbus"       : 5.0.11   , installed 5.0.11
          Adapter    "node-red"     : 4.0.0    , installed 4.0.0
          Adapter    "ping"         : 1.5.3    , installed 1.5.3
          Adapter    "simple-api"   : 2.7.2    , installed 2.7.2
          Adapter    "smartmeter"   : 3.3.4    , installed 3.3.4
          Adapter    "socketio"     : 4.2.0    , installed 4.2.0
          Adapter    "sql"          : 2.2.0    , installed 2.2.0
          Adapter    "telegram"     : 1.15.2   , installed 1.15.2
          Adapter    "trashschedule": 2.2.0    , installed 2.2.0
          Adapter    "vis"          : 1.4.16   , installed 1.4.16
          Adapter    "vis-inventwo" : 3.3.1    , installed 3.3.1
          Adapter    "vis-metro"    : 1.2.0    , installed 1.2.0
          Adapter    "vis-timeandweather": 1.2.2, installed 1.2.2
          Adapter    "web"          : 4.3.0    , installed 4.3.0
          Adapter    "ws"           : 1.3.0    , installed 1.3.0
          
          Objects and States
          Please stand by - This may take a while
          Objects:        4176
          States:         3637
          
          *** OS-Repositories and Updates ***
          W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://apt.grafana.com stable InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
          W: Failed to fetch https://apt.grafana.com/dists/stable/InRelease  The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
          W: Some index files failed to download. They have been ignored, or old ones used instead.
          Hit:1 http://deb.debian.org/debian bullseye InRelease
          Hit:2 http://security.debian.org/debian-security bullseye-security InRelease
          Hit:3 http://deb.debian.org/debian bullseye-updates InRelease
          Get:4 https://apt.grafana.com stable InRelease [5984 B]
          Hit:5 https://repo.ebusd.eu/apt/default/bullseye bullseye InRelease
          Hit:6 https://deb.nodesource.com/node_16.x bullseye InRelease
          Err:4 https://apt.grafana.com stable InRelease
            The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
          Reading package lists...
          W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://apt.grafana.com stable InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
          W: Failed to fetch https://apt.grafana.com/dists/stable/InRelease  The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
          W: Some index files failed to download. They have been ignored, or old ones used instead.
          Pending Updates: 52
          
          *** Listening Ports ***
          Active Internet connections (only servers)
          Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode      PID/Program name
          tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          16448      465/sshd: /usr/sbin
          tcp        0      0 0.0.0.0:8888            0.0.0.0:*               LISTEN      0          16343      853/ebusd
          tcp        0      0 0.0.0.0:1880            0.0.0.0:*               LISTEN      1001       15253      698/node-red
          tcp        0      0 0.0.0.0:8889            0.0.0.0:*               LISTEN      0          16344      853/ebusd
          tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      1001       16675      449/iobroker.js-con
          tcp        0      0 127.0.0.1:9001          0.0.0.0:*               LISTEN      1001       17439      449/iobroker.js-con
          tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      107        15070      530/mariadbd
          tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      0          205        1/init
          tcp6       0      0 :::8081                 :::*                    LISTEN      1001       17469      625/io.admin.0
          tcp6       0      0 :::8082                 :::*                    LISTEN      1001       18653      927/io.web.0
          tcp6       0      0 :::22                   :::*                    LISTEN      0          16450      465/sshd: /usr/sbin
          tcp6       0      0 :::3000                 :::*                    LISTEN      110        16664      564/grafana-server
          tcp6       0      0 :::111                  :::*                    LISTEN      0          209        1/init
          udp        0      0 192.168.2.100:60493     0.0.0.0:*                           1001       15232      668/io.knx.0
          udp        0      0 0.0.0.0:58470           0.0.0.0:*                           106        16432      444/avahi-daemon: r
          udp        0      0 0.0.0.0:5353            0.0.0.0:*                           106        16430      444/avahi-daemon: r
          udp        0      0 0.0.0.0:68              0.0.0.0:*                           0          13509      335/dhclient
          udp        0      0 0.0.0.0:111             0.0.0.0:*                           0          206        1/init
          udp        0      0 192.168.2.100:33441     0.0.0.0:*                           1001       17807      698/node-red
          udp6       0      0 :::5353                 :::*                                106        16431      444/avahi-daemon: r
          udp6       0      0 :::44388                :::*                                106        16433      444/avahi-daemon: r
          udp6       0      0 :::111                  :::*                                0          212        1/init
          
          *** Log File - Last 25 Lines ***
          
          2023-06-10 19:53:45.597  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419625596,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:53:51.841  - info: smartmeter.0 (865) Received 13 values, 6 updated
          2023-06-10 19:53:55.603  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419635601,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:54:00.009  - warn: host.RKO-Central instance system.adapter.ebus.0 already running with pid 1086
          2023-06-10 19:54:05.520  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.OG.Technik.Technik_Tarif1:{"val":26495004,"ack":true,"ts":1686419645519,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419645519}
          2023-06-10 19:54:05.521  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419645519,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:54:05.598  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419645597,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:54:06.521  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.OG.Technik.Technik_Tarif1:{"val":26495004,"ack":true,"ts":1686419646517,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419645519}
          2023-06-10 19:54:06.523  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.OG.Technik.Technik_Tarif2:{"val":0,"ack":true,"ts":1686419646517,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1640615818542}
          2023-06-10 19:54:06.527  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.OG.Technik.Technik_Phase1:{"val":123,"ack":true,"ts":1686419646524,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419646524}
          2023-06-10 19:54:06.529  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.OG.Technik.Technik_Phase2:{"val":36,"ack":true,"ts":1686419646524,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419614525}
          2023-06-10 19:54:06.533  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.OG.Technik.Technik_Phase3:{"val":125,"ack":true,"ts":1686419646530,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419646530}
          2023-06-10 19:54:13.267  - info: smartmeter.0 (865) Received 13 values, 6 updated
          2023-06-10 19:54:16.527  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419656525,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:54:17.023  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_Leistung:{"val":0,"ack":true,"ts":1686419657020,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686407146062}
          2023-06-10 19:54:17.086  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_Volumen:{"val":95,"ack":true,"ts":1686419657083,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686403898080}
          2023-06-10 19:54:17.143  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_VL:{"val":47.72,"ack":true,"ts":1686419657140,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686417372353}
          2023-06-10 19:54:17.429  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_RL:{"val":48,"ack":true,"ts":1686419657344,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686417372354}
          2023-06-10 19:54:17.555  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_Durchfluß:{"val":0.028999999165534973,"ack":true,"ts":1686419657428,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418575204}
          2023-06-10 19:54:17.556  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_Verbrauch:{"val":529,"ack":true,"ts":1686419657428,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686405102034}
          2023-06-10 19:54:17.694  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Allgemein.Heizung.WP_WMZ_Speicher:{"val":112,"ack":true,"ts":1686419657688,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1683834994056}
          2023-06-10 19:54:26.787  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Garage.Garage.Zisterne_Distanz:{"val":83,"ack":true,"ts":1686419666786,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419306142}
          2023-06-10 19:54:26.788  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419666786,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:54:27.382  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.info.connection:{"val":true,"ack":true,"ts":1686419667381,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686418184245}
          2023-06-10 19:54:27.779  - silly: knx.0 (668) States user redis pmessage knx.0.*/knx.0.Garage.Garage.Zisterne_Distanz:{"val":83,"ack":true,"ts":1686419667778,"q":0,"from":"system.adapter.knx.0","user":"system.user.admin","lc":1686419306142}
          
          

          Krass, seid ihr schnell...

          Glasfaser Thomas Braun 2 Replies Last reply Reply Quote 0
          • Glasfaser
            Glasfaser @Azrael42 last edited by

            @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

            silly: knx.0

            Hat damit nichts zu tun ... aber warum Müllst du dein Log damit voll.

            1 Reply Last reply Reply Quote 0
            • ?
              A Former User @Azrael42 last edited by A Former User

              @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

              Es ist übrigens eine MariaDB keine MySQL. Habe ich vor lauter "MySQL" überall verdrängt.

              Moin,

              naja, ist nicht der große Unterschied, Mariadb ist/war ein Fork von MySQL nachdem Oracle MySQ übernommen hat, somit teilen sie sich eine Basis, aber intern haben Sie schon auseinander entwickelt, gehört aber auch nicht hier her 🙂

              @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

              Da du oben danach gefragt hattest, im BackITUp Log steht nicht viel drin:

              Es gibt ja nicht nur die Logs vom ioBroker der Mariadb -Server schreibt ja auch irgendwohin seine Logs, vielleicht steht ja da was drin.

              @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

              [ERROR] [mysql] - [IGNORED] Error: Command failed: mysqldump -u iobroker -p**** iobroker -h RKO-Central -P 3306 > /opt/iobroker/backups/mysql_2023_06_10-18_57_20_backupiobroker.sql

              Wenn ich mal gerade so bei google vorbeischaue, dann finde ich da etwas, das ein User der mysqldumpausführen möchte, aber den Fehler bekommt, dass der Pfad zum Executable nicht passt.

              Wenn Du Dich als ioBroker User anmeldest, wie ist denn da das Environment, sprich findet er das Programm mysqldump

              which mysqldump
              

              @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

              *** OS-Repositories and Updates ***
              W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://apt.grafana.com stable InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
              W: Failed to fetch https://apt.grafana.com/dists/stable/InRelease The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9E439B102CF3C0C6
              W: Some index files failed to download. They have been ignored, or old ones used instead.

              Da passt etwas mit Deinen Repositorys nicht, hat hiermit nichts zu tun, wird Dir aber auf die Füße fallen. Wenn Du Grafana installieren willst, gibt hier im Forum schon ganz viele Beiträge, dazu.

              VG
              Bernd

              P.S.: in einem alten Post hier gefunden und in der Konfiguration von Backitup bei den Einstellungen von SQL der Pfad mit dem Dateinamen zum mysqldump Programm -> https://forum.iobroker.net/topic/37096/backitup-kein-backup-von-mysql/7

              1 Reply Last reply Reply Quote 0
              • Thomas Braun
                Thomas Braun Most Active @Azrael42 last edited by Thomas Braun

                @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                Pending Updates: 52

                Und dein grafana-Repo braucht auch etwas Liebe. Bzw. einen frischen Key.
                Gar kein influxdb am Start?
                [Edit:] Dafür vermutlich die mysql...

                1 Reply Last reply Reply Quote 0
                • Azrael42
                  Azrael42 @Glasfaser last edited by

                  @glasfaser
                  User für IOBroker ist "iobroker"
                  mein Admin User ist "richard"
                  der Sudo User ist "root"
                  Welchen User ich für die MariaDB verwendet habe muss ich gerade noch herausfinden...

                  richard@RKO-Central:~$ sudo apt install mariadb-client
                  Reading package lists... Done
                  Building dependency tree... Done
                  Reading state information... Done
                  The following NEW packages will be installed:
                    mariadb-client
                  0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
                  Need to get 35.4 kB of archives.
                  After this operation, 73.7 kB of additional disk space will be used.
                  Get:1 http://deb.debian.org/debian bullseye/main amd64 mariadb-client all 1:10.5.19-0+deb11u2 [35.4 kB]
                  Fetched 35.4 kB in 0s (216 kB/s)
                  Selecting previously unselected package mariadb-client.
                  (Reading database ... 54110 files and directories currently installed.)
                  Preparing to unpack .../mariadb-client_1%3a10.5.19-0+deb11u2_all.deb ...
                  Unpacking mariadb-client (1:10.5.19-0+deb11u2) ...
                  Setting up mariadb-client (1:10.5.19-0+deb11u2) ...
                  

                  Den Client habe ich noch einmal installiert, leider keine Änderung.

                  mariadb.service - MariaDB 10.5.19 database server
                       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
                       Active: active (running) since Sat 2023-06-10 19:58:28 CEST; 29min ago
                         Docs: man:mariadbd(8)
                               https://mariadb.com/kb/en/library/systemd/
                     Main PID: 7416 (mariadbd)
                       Status: "Taking your SQL requests now..."
                        Tasks: 47 (limit: 4560)
                       Memory: 198.5M
                          CPU: 48.547s
                       CGroup: /system.slice/mariadb.service
                               └─7416 /usr/sbin/mariadbd
                  
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: 2023-06-10 19:58:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: 2023-06-10 19:58:28 0 [Note] Server socket created on IP: '0.0.0.0'.
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: 2023-06-10 19:58:28 0 [Note] Reading of all Master_info entries succeeded
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: 2023-06-10 19:58:28 0 [Note] Added new Master_info '' to hash table
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: 2023-06-10 19:58:28 0 [Note] /usr/sbin/mariadbd: ready for connections.
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: Version: '10.5.19-MariaDB-0+deb11u2'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 11
                  Jun 10 19:58:28 RKO-Central mariadbd[7416]: 2023-06-10 19:58:28 0 [Note] InnoDB: Buffer pool(s) load completed at 230610 19:58:28
                  Jun 10 19:58:28 RKO-Central systemd[1]: Started MariaDB 10.5.19 database server.
                  Jun 10 19:58:28 RKO-Central /etc/mysql/debian-start[7438]: Upgrading MySQL tables if necessary.
                  
                  Thomas Braun ? 2 Replies Last reply Reply Quote 0
                  • Thomas Braun
                    Thomas Braun Most Active @Azrael42 last edited by Thomas Braun

                    @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                    der Sudo User ist "root"

                    ??? Der root braucht kein sudo, der darf eh alles.
                    Andere user können aber mittels 'sudo' temporär root-Rechte erlangen.

                    Für gewöhnlich müssen user bei solchen Programmen auch in den passenden groups sein.

                    Azrael42 1 Reply Last reply Reply Quote 0
                    • Azrael42
                      Azrael42 @Thomas Braun last edited by

                      @thomas-braun
                      In der /etc/sudoers ist der User "root" angegeben. Den könnte man da ja auch anpassen.

                      Thomas Braun 1 Reply Last reply Reply Quote 0
                      • ?
                        A Former User @Azrael42 last edited by

                        @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                        Den Client habe ich noch einmal installiert, leider keine Änderung.

                        Moin,

                        noch mal, hast Du im ioBroker Adapter den vollen Pfad zum mariadb-dump/mysqldump angegeben? Du scheinst jetzt beide Clients MariaDB und MySQL installiert zu haben. da mal den richtigen Pfad im Adapter einstellen, Zeigen.

                        Der User iobroker findet das Programm nicht, lies noch mal was Du checken solltest

                        @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                        In der /etc/sudoers ist der User "root" angegeben. Den könnte man da ja auch anpassen.

                        Spiel doch nicht an etwas herum, wo Du mehr kaputt machen kannst als, dass es Dir hilft.

                        VG
                        Bernd

                        Azrael42 1 Reply Last reply Reply Quote 0
                        • Thomas Braun
                          Thomas Braun Most Active @Azrael42 last edited by

                          @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                          In der /etc/sudoers ist der User "root" angegeben. Den könnte man da ja auch anpassen.

                          Ich glaube du hast dir irgendwie bei den Rechten was komplett zerfummelt...

                          1 Reply Last reply Reply Quote 0
                          • Azrael42
                            Azrael42 @Guest last edited by

                            @dp20eic said in BackITUp: MySQL DB Sicherung schlägt fehl:

                            noch mal, hast Du im ioBroker Adapter den vollen Pfad zum mariadb-dump/mysqldump angegeben? Du scheinst jetzt beide Clients MariaDB und MySQL installiert zu haben.

                            Ja, ich habe den vollen Pfad eingetragen.
                            Leider kann ich mich nicht als User "iobroker" anmelden, der scheint keine Rechte zu haben.
                            Ich lese jetzt nochmal exakt welchen Client ich wie zu installieren habe.

                            @dp20eic said in BackITUp: MySQL DB Sicherung schlägt fehl:

                            Spiel doch nicht an etwas herum, wo Du mehr kaputt machen kannst als, dass es Dir hilft.

                            Hab ich nicht. Wollte nur schlau klingen und habe das Ergebnis der Google Suche raus gehauen. 😉 Wie du merkst, ist Linux nicht so meine Stärke...
                            Aber ich vermute langsam auch, das es an den Rechten liegt.

                            @thomas-braun said in BackITUp: MySQL DB Sicherung schlägt fehl:

                            Ich glaube du hast dir irgendwie bei den Rechten was komplett zerfummelt...

                            Das Gefühl drängt sich mir auch auf...

                            Thomas Braun ? 3 Replies Last reply Reply Quote 0
                            • Thomas Braun
                              Thomas Braun Most Active @Azrael42 last edited by

                              @azrael42

                              Was hast du denn am 25. Mai gemacht?

                              1 Reply Last reply Reply Quote 0
                              • Thomas Braun
                                Thomas Braun Most Active @Azrael42 last edited by

                                @azrael42

                                Gib mal die Langfassung von

                                iob diag
                                

                                Da kann man schon mal sehen in welchem Umfeld du da überhaupt unterwegs bist.

                                1 Reply Last reply Reply Quote 0
                                • ?
                                  A Former User @Azrael42 last edited by

                                  @azrael42 sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                                  Leider kann ich mich nicht als User "iobroker" anmelden, der scheint keine Rechte zu haben.

                                  Moin,

                                  na dann begeben wir uns mal auf die Suche

                                  Was kommt, bei:

                                  dp20eic@iobroker:~$ lslogins iobroker
                                  Username:                           iobroker                            
                                  UID:                                1000                                
                                  Gecos field:                        iobroker,0815,1234567890,0987654321 
                                  Home directory:                     /home/iobroker                      
                                  Shell:                              /bin/bash                           
                                  No login:                           no                                  
                                  Primary group:                      iobroker                            
                                  GID:                                1000                                
                                  Supplementary groups:               bluetooth,tty,dialout,audio,video,wheel
                                  Supplementary group IDs:            116,5,20,29,44,1001                 
                                  Last terminal:                                                          
                                  Last hostname:                                                          
                                  Hushed:                             no                                  
                                  Running processes:                  25                                  
                                  
                                  Last logs:
                                  

                                  Was steht denn genau in Deiner Datei?

                                  sudo cat /etc/sudoers
                                  

                                  !!!Achtung!!!
                                  Die Datei nicht mit einem normalen Editor bearbeiten, das ist ganz böse und jeder der das macht, dem gehören die Finger abgehackt 🙂
                                  Es gibt einen speziellen Befehl, den ich aber nur verrate, wenn man mir drei Fragen richtig beantwortet 🙂
                                  !!!Achtung!!!

                                  VG
                                  Bernd

                                  Thomas Braun Azrael42 2 Replies Last reply Reply Quote 0
                                  • Thomas Braun
                                    Thomas Braun Most Active @Guest last edited by

                                    @dp20eic sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                                    Es gibt einen speziellen Befehl, den ich aber nur verrate, wenn man mir drei Fragen richtig beantwortet

                                    Dann schieß mal los. Ich bin neugierig! 😄

                                    ? 1 Reply Last reply Reply Quote 0
                                    • ?
                                      A Former User @Thomas Braun last edited by

                                      @thomas-braun sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                                      Dann schieß mal los. Ich bin neugierig!

                                      Moin,

                                      1. Wurzel von 1764?
                                      2. was ist 101010?
                                      3. die Antwort auf die Frage aller Fragen, nämlich die "nach dem Leben, dem Universum und dem ganzen Rest"?

                                      🙂

                                      VG
                                      Bernd

                                      Thomas Braun 1 Reply Last reply Reply Quote 0
                                      • Thomas Braun
                                        Thomas Braun Most Active @Guest last edited by

                                        @dp20eic

                                        1. vi
                                        2. su
                                        3. do

                                        Das hat mir der Teufel gesagt! 🙂

                                        Homoran 1 Reply Last reply Reply Quote 0
                                        • Homoran
                                          Homoran Global Moderator Administrators @Thomas Braun last edited by Homoran

                                          @thomas-braun sagte in BackITUp: MySQL DB Sicherung schlägt fehl:

                                          Das hat mir der Teufel gesagt!

                                          der mit den drei goldenen Haaren?

                                          ich biete 42,42,42

                                          1 Reply Last reply Reply Quote 0
                                          • Azrael42
                                            Azrael42 @Guest last edited by

                                            @dp20eic
                                            Danke für deine Geduld!

                                            richard@RKO-Central:~$ lslogins iobroker
                                            Username:                           iobroker
                                            UID:                                1001
                                            Gecos field:
                                            Home directory:                     /home/iobroker
                                            Shell:                              /bin/sbin/nologin
                                            No login:                           yes
                                            Primary group:                      iobroker
                                            GID:                                1001
                                            Supplementary groups:               video,tty,dialout,audio
                                            Supplementary group IDs:            44,5,20,29
                                            Last terminal:
                                            Last hostname:
                                            Hushed:                             no
                                            Running processes:                  20
                                            
                                            Last logs:
                                            

                                            /etc/sudoers

                                            Defaults        env_reset
                                            Defaults        mail_badpass
                                            Defaults        secure_path="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/b>
                                            
                                            # Host alias specification
                                            
                                            # User alias specification
                                            
                                            # Cmnd alias specification
                                            
                                            # User privilege specification
                                            root    ALL=(ALL:ALL) ALL
                                            
                                            # Allow members of group sudo to execute any command
                                            %sudo   ALL=(ALL:ALL) ALL
                                            
                                            # See sudoers(5) for more information on "@include" directives:
                                            
                                            @includedir /etc/sudoers.d
                                            

                                            @thomas-braun said in BackITUp: MySQL DB Sicherung schlägt fehl:

                                            Gib mal die Langfassung von
                                            iob diag

                                            Da kann man schon mal sehen in welchem Umfeld du da überhaupt unterwegs bist.

                                            Habe ich hier schon geposted:
                                            https://forum.iobroker.net/topic/66067/backitup-mysql-db-sicherung-schlägt-fehl/12?_=1686421368503

                                            @thomas-braun said in BackITUp: MySQL DB Sicherung schlägt fehl:

                                            Was hast du denn am 25. Mai gemacht?

                                            Meine neue Wärmepumpe eingebunden. Neue Modbus Objekte erstellt, die im Logging aktiviert, im SQL neue Views und Proceduren erstellt, neue Scripte erstellt. Sowas.

                                            ? 1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate
                                            FAQ Cloud / IOT
                                            HowTo: Node.js-Update
                                            HowTo: Backup/Restore
                                            Downloads
                                            BLOG

                                            641
                                            Online

                                            31.9k
                                            Users

                                            80.1k
                                            Topics

                                            1.3m
                                            Posts

                                            5
                                            53
                                            3090
                                            Loading More Posts
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            Community
                                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                            The ioBroker Community 2014-2023
                                            logo