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.
    • Glasfaser
      Glasfaser @Azrael42 last edited by

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

      Die SQL Protokollierung funktioniert mit meinem Workaround wieder,

      Welches Workground

      leider bekomme ich das Backup aber nicht zum laufen.

      Ausgabe von :

      ls -lh /opt/iobroker/backups
      

      und die Full-Ausgabe von

      iob diag
      

      in Code-Tags </> bitte !!

      Azrael42 1 Reply Last reply Reply Quote 0
      • 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
                                            • First post
                                              Last post

                                            Support us

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

                                            929
                                            Online

                                            31.9k
                                            Users

                                            80.1k
                                            Topics

                                            1.3m
                                            Posts

                                            5
                                            53
                                            2966
                                            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