Hallo zusammen,
ich nutze den Adapter auch schon länger und bin sehr zufrieden. Nur einen Punkt bekomme ich einfach nicht hin. Deswegen hoffe ich jetzt das ihr mir helfen könnt.

Ich nutze noch Thermostate, Ventilantriebe, und Tür/Fensterkontake von MAX! über den Max Adapter.
Fenster kontakte sind auf die jeweiligen Thermostate gekoppelt.

HeatingControl erkennt das öffnen des Fensters immer als neuen Manuele Handvorgabe. Wie kann ich das ändern. Ich möchte ungerne die Manuele Handvorgabe am Gerät selber nicht mehr nutzen können.

@dp20eic sagte in SQL Startet nach Node Update nicht mehr:

cat /etc/hosts

127.0.0.1       localhost
::1             localhost ip6-localhost ip6-loopback
ff02::1         ip6-allnodes
ff02::2         ip6-allrouters

127.0.1.1       raspberrypi4

pi@raspberrypi4:/opt/iobroker/node_modules/iobroker.sql $ networkctl
WARNING: systemd-networkd is not running, output will be incomplete.

IDX LINK TYPE      OPERATIONAL SETUP
  1 lo   loopback  n/a         unmanaged
  2 eth0 ether     n/a         unmanaged
  3 wg0  wireguard n/a         unmanaged

pi@raspberrypi4:/opt/iobroker/node_modules/iobroker.sql $ networkctl status
WARNING: systemd-networkd is not running, output will be incomplete.

●   State: n/a
  Address: 192.168.2.52 on eth0
           192.168.2.136 on eth0
           10.6.0.1 on wg0
           fe80::1f59:8f1:e88a:ef3c on eth0
  Gateway: 192.168.2.1 on eth0
           192.168.2.1 on eth0

Bei netstat | grep 3306 passiert einfach nichts.

@thomas-braun und wie bekomme ich die freigabe wieder rein?

Vielen Dank an alle für die Hilfe!!!

ich habe es über umwege hinbekommen.
Wenn ich nicht localhost sonder 127.0.0.1 eingtrage funktioniert der zugriff.

@dp20eic
Offen gesagt keine ahnung was mir das sagen soll. Wie kann ich das prüfen, bzw. instand setzten?

jetzt wollte ich einfach mal versuchen ein Bachup in die DB einzuspielen, aber auch das geht nicht, weil da einfach der Button fehlt.

@dp20eic

die mariadb.ini ist leer. Ist das richtig?

User habe ich hiernach angelegt:
https://www.electronicstudio.de/mysql-für-iobroker-installieren

@thomas-braun sagte in SQL Startet nach Node Update nicht mehr:

systemctl status mariadb.service

pi@raspberrypi4:~ $ systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.19 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: active (running) since Fri 2023-08-25 10:31:21 CEST; 10min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 4201 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 4203 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 4205 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl se>
    Process: 4270 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 4272 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
   Main PID: 4252 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 8 (limit: 3721)
        CPU: 1.666s
     CGroup: /system.slice/mariadb.service
             └─4252 /usr/sbin/mariadbd

Aug 25 10:31:21 raspberrypi4 mariadbd[4252]: Version: '10.5.19-MariaDB-0+deb11u2'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Raspbian 11
Aug 25 10:31:21 raspberrypi4 systemd[1]: Started MariaDB 10.5.19 database server.
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4274]: Upgrading MySQL tables if necessary.
Aug 25 10:31:21 raspberrypi4 mariadbd[4252]: 2023-08-25 10:31:21 0 [Note] InnoDB: Buffer pool(s) load completed at 230825 10:31:21
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4277]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4277]: Looking for 'mariadb' as: /usr/bin/mariadb
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4277]: Looking for 'mariadb-check' as: /usr/bin/mariadb-check
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4277]: This installation of MariaDB is already upgraded to 10.5.19-MariaDB.
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4277]: There is no need to run mysql_upgrade again for 10.5.19-MariaDB.
Aug 25 10:31:21 raspberrypi4 /etc/mysql/debian-start[4277]: You can use --force if you still want to run mysql_upgrade
lines 1-27/27 (END)

iob diag:

======== Start marking the full check here =========

Skript v.2023-04-16

*** BASE SYSTEM ***
Model           : Raspberry Pi 4 Model B Rev 1.1
Architecture    : aarch64
Docker          : false
Virtualization  : none
Distributor ID: Raspbian
Description:    Raspbian GNU/Linux 11 (bullseye)
Release:        11
Codename:       bullseye

PRETTY_NAME="Raspbian GNU/Linux 11 (bullseye)"
NAME="Raspbian GNU/Linux"
VERSION_ID="11"
VERSION="11 (bullseye)"
VERSION_CODENAME=bullseye
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"

Systemuptime and Load:
 10:45:25 up 31 min,  1 user,  load average: 1.54, 1.10, 0.94
CPU threads: 4

Raspberry only:
throttled=0x0
Other values than 0x0 hint to temperature/voltage problems
temp=70.1'C
volt=0.8438V

*** Time and Time Zones ***
               Local time: Fri 2023-08-25 10:45:25 CEST
           Universal time: Fri 2023-08-25 08:45:25 UTC
                 RTC time: n/a
                Time zone: Europe/Berlin (CEST, +0200)
System clock synchronized: yes
              NTP service: active
          RTC in local TZ: no

*** User and Groups ***
pi
/home/pi
pi adm dialout cdrom sudo audio video plugdev games users input netdev lpadmin gpio i2c spi iobroker

*** X-Server-Setup ***
X-Server:       false
Desktop:
Terminal:       tty
Boot Target:    multi-user.target

*** MEMORY ***
               total        used        free      shared  buff/cache   available
Mem:            3.6G        1.8G        457M        1.0M        1.4G        1.8G
Swap:           999M          0B        999M
Total:          4.6G        1.8G        1.5G

         3617 M total memory
         1780 M used memory
         2235 M active memory
          696 M inactive memory
          457 M free memory
          168 M buffer memory
         1211 M swap cache
          999 M total swap
            0 M used swap
          999 M free swap

Raspberry only:
oom events: 0
lifetime oom required: 0 Mbytes
total time in oom handler: 0 ms
max time spent in oom handler: 0 ms

*** FILESYSTEM ***
Filesystem     Type      Size  Used Avail Use% Mounted on
/dev/root      ext4      110G   75G   31G  72% /
devtmpfs       devtmpfs  1.6G     0  1.6G   0% /dev
tmpfs          tmpfs     1.8G     0  1.8G   0% /dev/shm
tmpfs          tmpfs     724M  1.2M  723M   1% /run
tmpfs          tmpfs     5.0M  4.0K  5.0M   1% /run/lock
/dev/sda1      vfat      253M   52M  202M  21% /boot
tmpfs          tmpfs     362M   28K  362M   1% /run/user/1000

Messages concerning ext4 filesystem in dmesg:
[Fri Aug 25 10:14:07 2023] Kernel command line: coherent_pool=1M 8250.nr_uarts=1 snd_bcm2835.enable_headphones=0 snd_bcm2835.enable_headphones=1 snd_bcm2835.enable_hdmi=1 video=HDMI-A-1:640x480M@60D smsc95xx.macaddr=DC:A6:32:4F:FC:A4 vc_mem.mem_base=0x3eb00000 vc_mem.mem_size=0x3ff00000  console=tty1 root=PARTUUID=97709164-02 rootfstype=ext4 elevator=deadline fsck.repair=yes rootwait quiet splash plymouth.ignore-serial-consoles
[Fri Aug 25 10:14:09 2023] EXT4-fs (sda2): mounted filesystem with ordered data mode. Quota mode: none.
[Fri Aug 25 10:14:09 2023] VFS: Mounted root (ext4 filesystem) readonly on device 8:2.
[Fri Aug 25 10:14:12 2023] EXT4-fs (sda2): re-mounted. Quota mode: none.

Show mounted filesystems (real ones only):
TARGET  SOURCE    FSTYPE OPTIONS
/       /dev/sda2 ext4   rw,noatime
`-/boot /dev/sda1 vfat   rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,flush,errors=remount-ro

Files in neuralgic directories:

/var:
3.9G    /var/
1.9G    /var/lib
1.7G    /var/lib/mysql
1.5G    /var/lib/mysql/iobroker
948M    /var/cache

Archived and active journals take up 72.0M in the file system.

/opt/iobroker/backups:
655M    /opt/iobroker/backups/

/opt/iobroker/iobroker-data:
835M    /opt/iobroker/iobroker-data/
577M    /opt/iobroker/iobroker-data/files
166M    /opt/iobroker/iobroker-data/backup-objects
88M     /opt/iobroker/iobroker-data/files/echarts.admin
78M     /opt/iobroker/iobroker-data/files/icons-open-icon-library-png

The five largest files in iobroker-data are:
33M     /opt/iobroker/iobroker-data/states.jsonl
33M     /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.10538062.js.map
27M     /opt/iobroker/iobroker-data/files/material/static/js/2.73100bd6.chunk.js.map
23M     /opt/iobroker/iobroker-data/objects.jsonl
23M     /opt/iobroker/iobroker-data/files/echarts/static/js/main.eb0afecd.js.map

*** NodeJS-Installation ***

/usr/bin/nodejs         v18.17.1
/usr/bin/node           v18.17.1
/usr/bin/npm            9.6.7
/usr/bin/npx            9.6.7


nodejs:
  Installed: 18.17.1-deb-1nodesource1
  Candidate: 18.17.1-deb-1nodesource1
  Version table:
 *** 18.17.1-deb-1nodesource1 500
        500 https://deb.nodesource.com/node_18.x bullseye/main armhf Packages
        100 /var/lib/dpkg/status
     12.22.12~dfsg-1~deb11u4 500
        500 http://raspbian.raspberrypi.org/raspbian bullseye/main armhf 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.23
admin:          6.3.5
javascript:     7.0.3

Adapters from github:   8

Adapter State
  system.adapter.adb.1                    : adb                   : raspberrypi4                             - disabled
+ system.adapter.admin.0                  : admin                 : raspberrypi4                             -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
+ system.adapter.alexa2.0                 : alexa2                : raspberrypi4                             -  enabled
  system.adapter.apple-find-me.0          : apple-find-me         : raspberrypi4                             - disabled
+ system.adapter.backitup.0               : backitup              : raspberrypi4                             -  enabled
  system.adapter.ble.0                    : ble                   : raspberrypi                              - disabled
  system.adapter.chromecast.0             : chromecast            : raspberrypi4                             - disabled
+ system.adapter.cloud.0                  : cloud                 : raspberrypi4                             -  enabled
  system.adapter.coronavirus-statistics.0 : coronavirus-statistics: raspberrypi4                             - disabled
  system.adapter.daswetter.0              : daswetter             : raspberrypi4                             -  enabled
+ system.adapter.discovery.0              : discovery             : raspberrypi4                             -  enabled
+ system.adapter.echarts.0                : echarts               : raspberrypi4                             -  enabled
  system.adapter.fb-checkpresence.0       : fb-checkpresence      : raspberrypi4                             - disabled
  system.adapter.feiertage.0              : feiertage             : raspberrypi4                             -  enabled
  system.adapter.firetv.0                 : firetv                : raspberrypi                              - disabled
  system.adapter.flot.0                   : flot                  : raspberrypi4                             - disabled
  system.adapter.fritzbox.0               : fritzbox              : raspberrypi4                             - disabled
  system.adapter.gartenbewaesserung.0     : gartenbewaesserung    : raspberrypi4                             - disabled
+ system.adapter.harmony.0                : harmony               : raspberrypi4                             -  enabled
  system.adapter.heatingcontrol.0         : heatingcontrol        : raspberrypi4                             - disabled
+ system.adapter.hs100.0                  : hs100                 : raspberrypi4                             -  enabled
  system.adapter.ical.0                   : ical                  : raspberrypi4                             -  enabled
  system.adapter.icons-mfd-svg.0          : icons-mfd-svg         : raspberrypi4                             - disabled
+ system.adapter.info.0                   : info                  : raspberrypi4                             -  enabled
+ system.adapter.iot.0                    : iot                   : raspberrypi4                             -  enabled
+ system.adapter.iqontrol.0               : iqontrol              : raspberrypi4                             -  enabled
+ system.adapter.javascript.0             : javascript            : raspberrypi4                             -  enabled
+ system.adapter.jeelink.0                : jeelink               : raspberrypi4                             -  enabled
+ system.adapter.linkeddevices.0          : linkeddevices         : raspberrypi4                             -  enabled
  system.adapter.linux-control.0          : linux-control         : raspberrypi4                             - disabled
  system.adapter.maxcube.0                : maxcube               : raspberrypi4                             - disabled, port: 62910, bind: 0.0.0.0
  system.adapter.mihome-vacuum.0          : mihome-vacuum         : raspberrypi4                             - disabled, port: 54321
  system.adapter.moma.0                   : moma                  : raspberrypi4                             - disabled
+ system.adapter.mqtt.0                   : mqtt                  : raspberrypi4                             -  enabled, port: 1883, bind: 0.0.0.0
+ system.adapter.net-tools.0              : net-tools             : raspberrypi4                             -  enabled
  system.adapter.netatmo-crawler.0        : netatmo-crawler       : raspberrypi4                             -  enabled
+ system.adapter.octoprint.0              : octoprint             : raspberrypi4                             -  enabled
  system.adapter.onvif.0                  : onvif                 : raspberrypi4                             - disabled
+ system.adapter.openligadb.0             : openligadb            : raspberrypi4                             -  enabled
+ system.adapter.pushover.0               : pushover              : raspberrypi4                             -  enabled
+ system.adapter.radar2.0                 : radar2                : raspberrypi4                             -  enabled
+ system.adapter.rpi2.0                   : rpi2                  : raspberrypi4                             -  enabled
+ system.adapter.scenes.0                 : scenes                : raspberrypi4                             -  enabled
+ system.adapter.shelly.0                 : shelly                : raspberrypi4                             -  enabled, port: 1882, bind: 0.0.0.0
+ system.adapter.smartcontrol.0           : smartcontrol          : raspberrypi4                             -  enabled
  system.adapter.smartmeter.0             : smartmeter            : raspberrypi4                             - disabled
+ system.adapter.socketio.0               : socketio              : raspberrypi4                             -  enabled, port: 8084, bind: 0.0.0.0, run as: admin
+ system.adapter.sonoff.0                 : sonoff                : raspberrypi4                             -  enabled, port: 1884, bind: 0.0.0.0
+ system.adapter.sourceanalytix.0         : sourceanalytix        : raspberrypi4                             -  enabled
+ system.adapter.sprinklecontrol.0        : sprinklecontrol       : raspberrypi4                             -  enabled
+ system.adapter.sql.0                    : sql                   : raspberrypi4                             -  enabled, port: 3306
+ system.adapter.sureflap.0               : sureflap              : raspberrypi4                             -  enabled
+ system.adapter.terminal.1               : terminal              : raspberrypi4                             -  enabled, port: 8088, bind: 0.0.0.0, run as: admin
+ system.adapter.trashschedule.0          : trashschedule         : raspberrypi4                             -  enabled
  system.adapter.tuya.0                   : tuya                  : raspberrypi4                             - disabled
+ system.adapter.upnp.0                   : upnp                  : raspberrypi4                             -  enabled
  system.adapter.vis-material-advanced.0  : vis-material-advanced : raspberrypi4                             - disabled
  system.adapter.vis.0                    : vis                   : raspberrypi4                             -  enabled
+ system.adapter.web.0                    : web                   : raspberrypi4                             -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
  system.adapter.wifilight.0              : wifilight             : raspberrypi4                             - disabled
+ system.adapter.zigbee.0                 : zigbee                : raspberrypi4                             -  enabled, port: /dev/zigbee

+ instance is alive

Enabled adapters with bindings
+ system.adapter.admin.0                  : admin                 : raspberrypi4                             -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
+ system.adapter.mqtt.0                   : mqtt                  : raspberrypi4                             -  enabled, port: 1883, bind: 0.0.0.0
+ system.adapter.shelly.0                 : shelly                : raspberrypi4                             -  enabled, port: 1882, bind: 0.0.0.0
+ system.adapter.socketio.0               : socketio              : raspberrypi4                             -  enabled, port: 8084, bind: 0.0.0.0, run as: admin
+ system.adapter.sonoff.0                 : sonoff                : raspberrypi4                             -  enabled, port: 1884, bind: 0.0.0.0
+ system.adapter.sql.0                    : sql                   : raspberrypi4                             -  enabled, port: 3306
+ system.adapter.terminal.1               : terminal              : raspberrypi4                             -  enabled, port: 8088, bind: 0.0.0.0, run as: admin
+ system.adapter.web.0                    : web                   : raspberrypi4                             -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
+ system.adapter.zigbee.0                 : zigbee                : raspberrypi4                             -  enabled, port: /dev/zigbee

ioBroker-Repositories
Stable (default): http://download.iobroker.net/sources-dist.json
Beta (latest) : http://download.iobroker.net/sources-dist-latest.json

Active repo(s): Stable (default)

Installed ioBroker-Instances
Used repository: Stable (default)
Adapter    "adb"          : 0.0.7    , installed 0.0.7
Adapter    "admin"        : 6.8.0    , installed 6.3.5  [Updatable]
Adapter    "alexa2"       : 3.24.1   , installed 3.24.1
Adapter    "apple-find-me": 0.0.14   , installed 0.0.14
Adapter    "backitup"     : 2.6.23   , installed 2.6.23
Adapter    "ble"          : 0.13.4   , installed 0.13.4
Adapter    "chromecast"   : 3.0.3    , installed 3.0.3
Adapter    "cloud"        : 4.4.1    , installed 4.4.1
Adapter    "coronavirus-statistics": 0.8.7, installed 0.8.7
Adapter    "cul"          : 2.2.0    , installed 2.0.2  [Updatable]
Adapter    "daswetter"    : 3.1.10   , installed 3.1.8  [Updatable]
Adapter    "devices"      : 1.1.5    , installed 1.1.2  [Updatable]
Adapter    "discovery"    : 3.1.0    , installed 3.1.0
Adapter    "echarts"      : 1.5.1    , installed 1.5.1
Adapter    "fb-checkpresence": 1.2.2 , installed 1.1.26 [Updatable]
Adapter    "feiertage"    : 1.1.0    , installed 1.1.0
Adapter    "firetv"       : 1.0.0    , installed 1.0.0
Adapter    "flot"         : 1.12.0   , installed 1.12.0
Adapter    "fritzbox"     : 0.2.1    , installed 0.2.1
Adapter    "fullcalendar" : 1.2.0    , installed 1.2.0
Adapter    "harmony"      : 1.2.2    , installed 1.2.2
Adapter    "heatingcontrol": 2.11.1  , installed 2.11.1
Adapter    "history"      : 2.2.4    , installed 2.2.4
Adapter    "hs100"        : 2.1.2    , installed 2.1.2
Adapter    "ical"         : 1.13.3   , installed 1.13.2 [Updatable]
Adapter    "icons-mfd-svg": 1.1.0    , installed 1.1.0
Adapter    "info"         : 1.9.26   , installed 1.9.26
Adapter    "iot"          : 1.14.5   , installed 1.14.5
Adapter    "iqontrol"     : 2.3.0    , installed 2.3.0
Adapter    "javascript"   : 7.0.3    , installed 7.0.3
Adapter    "jeelink"      : 0.1.4    , installed 0.1.4
Controller "js-controller": 4.0.24   , installed 4.0.23 [Updatable]
Adapter    "linkeddevices": 1.5.5    , installed 1.5.5
Adapter    "linux-control": 1.1.3    , installed 1.1.3
Adapter    "material"     : 1.3.1    , installed 1.1.2  [Updatable]
Adapter    "maxcube"      : 1.0.4    , installed 1.0.4
Adapter    "mihome-vacuum": 3.11.0   , installed 3.11.0
Adapter    "moma"         : 1.2.9    , installed 1.2.9
Adapter    "mqtt"         : 4.1.1    , installed 4.1.1
Adapter    "net-tools"    : 0.2.0    , installed 0.2.0
Adapter    "netatmo-crawler": 0.8.1  , installed 0.8.1
Adapter    "octoprint"    : 4.0.0    , installed 4.0.0
Adapter    "onvif"        : 1.0.5    , installed 1.0.2  [Updatable]
Adapter    "openligadb"   : 1.2.4    , installed 1.3.0
Adapter    "pushover"     : 3.0.3    , installed 3.0.3
Adapter    "radar2"       : 2.0.7    , installed 2.0.7
Adapter    "rpi2"         : 1.3.2    , installed 1.3.2
Adapter    "scenes"       : 2.3.9    , installed 2.3.9
Adapter    "shelly"   

So Upgrade nach Bullseye ist durch.
SQL Startet
Mariadb startet

Error: connect ECONNREFUSED ::1:3306 kommt weiterhin.

Ich habe im SQL einen neuen User und eine neue DB angelegt. Die Daten im Adapter eingetragen und es kommt trotzdem "Error: connect ECONNREFUSED ::1:3306"

Habt ihr noch weitere Ideen?

@homoran
wir versuchen es erstmal so mit nem update