SQL Startet nach Node Update nicht mehr
-
Mit der lokal Adresse passiert das selbe.
Root Daten sind mir ehrlich gesagt nicht bekannt. (Von der DB).
Eingerichtet habe ich nur den User „ioBroker“ -
@grizzlyco dann probiere user root mit password root oder lasse password leer
-
@fastfoot
mit root habe ich leider keinen erfolg. -
armv7l /usr/bin/nodejs /usr/bin/node /usr/bin/npm /usr/bin/npx /usr/bin/corepack v18.17.1 v18.17.1 9.6.7 9.6.7 0.18.0 4.0.23 pi pi adm dialout cdrom sudo audio video plugdev games users input netdev lpadmin gpio i2c spi iobroker tty /home/pi OK:1 http://phoscon.de/apt/deconz buster InRelease OK:2 http://archive.raspberrypi.org/debian buster InRelease OK:3 http://raspbian.raspberrypi.org/raspbian buster InRelease OK:4 https://deb.nodesource.com/node_18.x buster InRelease Paketlisten werden gelesen... Fertig Abhängigkeitsbaum wird aufgebaut. Statusinformationen werden eingelesen.... Fertig Alle Pakete sind aktuell. nodejs: Installiert: 18.17.1-deb-1nodesource1 Installationskandidat: 18.17.1-deb-1nodesource1 Versionstabelle: *** 18.17.1-deb-1nodesource1 500 500 https://deb.nodesource.com/node_18.x buster/main armhf Packages 100 /var/lib/dpkg/status 10.24.0~dfsg-1~deb10u3 500 500 http://raspbian.raspberrypi.org/raspbian buster/main armhf Packages -
Es scheint ein Problem mit MariaDB zu geben. Ist das ein Bestandteil von MySQL?
pi@raspberrypi4:~ $ systemctl status mariadb.service ● mariadb.service - MariaDB 10.3.39 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: Active: failed (Result: exit-code) since Fri 2023-08-25 08:10:09 CEST; 5min a Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 6194 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/ru Process: 6195 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START Process: 6197 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR Process: 6244 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WS Main PID: 6244 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Aug 25 08:09:36 raspberrypi4 systemd[1]: Starting MariaDB 10.3.39 database serve Aug 25 08:10:09 raspberrypi4 systemd[1]: mariadb.service: Main process exited, c Aug 25 08:10:09 raspberrypi4 systemd[1]: mariadb.service: Failed with result 'ex Aug 25 08:10:09 raspberrypi4 systemd[1]: Failed to start MariaDB 10.3.39 databas -
Buster ist tot, bring das auf den Nachfolger.
MariaDB ist MySQL.
Bitte die Ausgaben in voller Breite zeigen, da fehlt rechts was
-
@thomas-braun
Ist das wirklich zielführend?Never change a running system
Node habe ich nur aktualisiert, weil ich aufgrund der Abhängigkeiten musste.
Die Kiste hängt nur im LAN und ich von aussen nicht erreichbar.
-
@grizzlyco sagte in SQL Startet nach Node Update nicht mehr:
Never change a running system
Bullshit. Buster ist abgekündigt und wird dir in Zukunft weitere Probleme bereiten. Je länger du wartest, umso größer wird der Aufwand.
-
@thomas-braun
na gut. Ich aktualisiere.
Hoffentlich mache ich mir damit nicht mehr probleme als lösungen -
Wenn dein Pi 64bit-fähig ist würde ich es komplett Neuinstallieren.
-
@thomas-braun
das ist leider keine option. Da verzichte ich lieber auf die historischen Daten -
Backups ziehen, Neuinstallation, Backups einspielen, fertig.
-
@grizzlyco sagte in SQL Startet nach Node Update nicht mehr:
Da verzichte ich lieber auf die historischen Daten
...und auf ein sauber laufendes System
-
@homoran
wir versuchen es erstmal so mit nem update -
-
So Upgrade nach Bullseye ist durch.
SQL Startet
Mariadb startetError: 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?
-
-
@grizzlyco sagte in SQL Startet nach Node Update nicht mehr:
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"
Moin,
gehen wir mal systematisch vor, dazu gehört, dass nicht nur gesagt wird, sondern Zeigen
was sagt
systemctl status mariadb.serviceDann ist es wichtig, zu wissen, wie Du Deine
mariadbeingerichtet hast, und wie der Zugriff darauf erfolgen darf
Wie sieht Deinemariadb.iniview /etc/mariadb/maiadb.iniWie hast Du den User angelegt?
VG
Bernd -
@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" -
@dp20eic
die mariadb.ini ist leer. Ist das richtig?
User habe ich hiernach angelegt:
https://www.electronicstudio.de/mysql-für-iobroker-installieren
