<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Ja korrekt, mysql läuft nicht:<div class=""><br class=""></div><div class=""><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">systemctl status mysql</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #c33720" class=""><b class="">●</b></span><span style="font-variant-ligatures: no-common-ligatures" class=""> mariadb.service - MariaDB database server</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Active: </span><span style="font-variant-ligatures: no-common-ligatures; color: #c33720" class=""><b class="">failed</b></span><span style="font-variant-ligatures: no-common-ligatures" class=""> (Result: exit-code) since Sat 2020-03-28 13:32:58 CET; 1h 2min ago</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Process: 672 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION </span><span style="font-variant-ligatures: no-common-ligatures; color: #c33720" class=""><b class="">(code=exited, status=1/FAILURE)</b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Process: 531 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && sys</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Process: 493 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Process: 452 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Main PID: 672 (code=exited, status=1/FAILURE)</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Status: "MariaDB server is down"</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo; min-height: 13px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 13:32:52 keller systemd[1]: Starting MariaDB database server...</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 13:32:54 keller mysqld[672]: 2020-03-28 13:32:54 1988587520 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1) starting as pr</span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 13:32:58 keller systemd[1]: <b class="">mariadb.service: Main process exited, code=exited, status=1/FAILURE</b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo; color: rgb(195, 55, 32);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #000000" class="">Mar 28 13:32:58 keller systemd[1]: </span><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">Failed to start MariaDB database server.</b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 13:32:58 keller systemd[1]: <b class="">mariadb.service: Unit entered failed state.</b></span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><font face="Menlo" class=""><span style="font-size: 11px;" class="">Mar 28 13:32:58 keller systemd[1]: </span></font><b class=""><font face="Menlo" class=""><span style="font-size: 11px;" class="">mariadb.service: Failed with result 'exit-code‘.</span></font></b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class=""><br class=""></b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">ein Versuch es zu starten bringt das: </b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class=""><br class=""></b></span></div><div style="margin: 0px; font-size: 11px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">sudo systemctl start mysql</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Job for mariadb.service failed because the control process exited with error code.</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">See "systemctl status mariadb.service" and "journalctl -xe" for details.</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">die Ausgabe von journalctl -xe</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures;" class=""><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">journalctl -xe</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:01 keller CRON[3047]: (pi) CMD (php /var/www/<a href="http://volkszaehler.org/misc/tools/aggregate.php" class="">volkszaehler.org/misc/tools/aggregate.php</a> run -m delta -l minute >/dev/null)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:01 keller CRON[3038]: (CRON) info (No MTA installed, discarding output)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:01 keller CRON[3038]: pam_unix(cron:session): session closed for user pi</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:03 keller CRON[3037]: pam_unix(cron:session): session closed for user pi</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:03 keller Node-RED[348]: 28 Mar 14:36:03 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:19 keller Node-RED[348]: 28 Mar 14:36:19 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:20 keller sudo[3087]: <b class=""> pi : TTY=pts/0 ; PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl start mysql</b></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:20 keller sudo[3087]: pam_unix(sudo:session): session opened for user root by pi(uid=0)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:20 keller systemd[1]: Starting MariaDB database server...</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Subject: Unit mariadb.service has begun start-up</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Defined-By: systemd</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Support: <a href="https://www.debian.org/support" class="">https://www.debian.org/support</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- </span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Unit mariadb.service has begun starting up.</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:21 keller mysqld[3189]: 2020-03-28 14:36:21 1988857856 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1) starting as p</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:25 keller systemd[1]: <b class="">mariadb.service: Main process exited, code=exited, status=1/FAILURE</b></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal; color: rgb(195, 55, 32);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #000000" class="">Mar 28 14:36:25 keller systemd[1]: </span><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">Failed to start MariaDB database server.</b></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Subject: Unit mariadb.service has failed</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Defined-By: systemd</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Support: <a href="https://www.debian.org/support" class="">https://www.debian.org/support</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- </span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- Unit mariadb.service has failed.</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- </span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">-- The result is failed.</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:25 keller systemd[1]: <b class="">mariadb.service: Unit entered failed state.</b></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:25 keller systemd[1]: <b class="">mariadb.service: Failed with result 'exit-code'.</b></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:25 keller sudo[3087]: pam_unix(sudo:session): session closed for user root</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:34 keller Node-RED[348]: 28 Mar 14:36:34 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:36:49 keller Node-RED[348]: 28 Mar 14:36:49 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:01 keller CRON[3223]: pam_unix(cron:session): session opened for user pi by (uid=0)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:01 keller CRON[3227]: (pi) CMD (php /var/www/<a href="http://volkszaehler.org/misc/tools/aggregate.php" class="">volkszaehler.org/misc/tools/aggregate.php</a> run -m delta -l minute >/dev/null)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:02 keller CRON[3223]: (CRON) info (No MTA installed, discarding output)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:02 keller CRON[3223]: pam_unix(cron:session): session closed for user pi</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:04 keller Node-RED[348]: 28 Mar 14:37:04 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:19 keller Node-RED[348]: 28 Mar 14:37:19 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:34 keller Node-RED[348]: 28 Mar 14:37:34 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:37:49 keller Node-RED[348]: 28 Mar 14:37:49 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:01 keller CRON[3239]: pam_unix(cron:session): session opened for user pi by (uid=0)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:01 keller CRON[3240]: pam_unix(cron:session): session opened for user pi by (uid=0)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:01 keller CRON[3248]: (pi) CMD (php /var/www/<a href="http://volkszaehler.org/misc/tools/aggregate.php" class="">volkszaehler.org/misc/tools/aggregate.php</a> run -m delta -l minute >/dev/null)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:01 keller CRON[3247]: (pi) CMD (/home/pi/scripts/sbfspot2vz.sh > /dev/null)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:01 keller CRON[3240]: (CRON) info (No MTA installed, discarding output)</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:01 keller CRON[3240]: pam_unix(cron:session): session closed for user pi</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:03 keller CRON[3239]: pam_unix(cron:session): session closed for user pi</span></div><div style="font-family: Menlo; margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Mar 28 14:38:04 keller Node-RED[348]: 28 Mar 14:38:04 - [info] [mqtt-broker:mqtt broker] Connection failed to broker: <a href="mqtt://192.168.178.34" class="">mqtt://192.168.178.34</a></span></div><div style="font-family: Menlo; margin: 0px; line-height: normal; color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures; background-color: #000000" class="">lines 1859-1903/1903 (END)</span></div><div style="font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures; background-color: #000000" class=""><br class=""></span></div><div style="font-family: Menlo;" class=""><span style="font-variant-ligatures: no-common-ligatures; background-color: #000000" class=""><br class=""></span></div><div class="">mir sagt das leider gar nichts, ausser das mariadb nicht läuft, aber nicht warum es nicht läuft</div><div class=""><br class=""></div><div class="">Gruß Tobias</div><div style="font-family: Menlo;" class=""><br class=""></div><div style="font-family: Menlo;" class=""><br class=""></div></span></div></span></div><div><blockquote type="cite" class=""><div class="">Am 28.03.2020 um 14:17 schrieb Daniel Lauckner <<a href="mailto:vz@jahp.de" class="">vz@jahp.de</a>>:</div><br class="Apple-interchange-newline"><div class=""><div class="">Hallo,<br class=""><br class=""><br class="">am Samstag, 28. März 2020 um 13:45 hat Tobias Lehr geschrieben:<br class=""><blockquote type="cite" class="">middleware.php/entity/XXXXX-53f0-11ea-a672-d170a1ac49e8.json?unique=1585399348516<br class=""><<a href="http://192.168.178.34/middleware.php/entity/7d4fc860-53f0-11ea-a672-d170a1ac49e8.json?unique=1585399348516" class="">http://192.168.178.34/middleware.php/entity/7d4fc860-53f0-11ea-a672-d170a1ac49e8.json?unique=1585399348516</a>>:<br class=""></blockquote><br class=""><blockquote type="cite" class="">An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory<br class=""></blockquote><br class="">Hm.<br class=""><br class=""><blockquote type="cite" class="">Ich vermute mal das die Datenbank nicht läuft<br class=""></blockquote><br class="">Was kommt bei:<br class="">systemctl status mysql<br class=""><br class=""><blockquote type="cite" class="">oder nicht gefunden werden kann.<br class=""></blockquote><br class="">Da würde ich eine andere Meldung erwarten.<br class=""><br class=""><blockquote type="cite" class="">Wenn ich mich per ssh einlogge,<br class=""></blockquote><br class="">Mal an der ssh-Console über den lokalen Client auf der Datenbank eingeloggt?<br class=""><br class=""><br class="">mfg Daniel<br class=""><br class=""></div></div></blockquote></div><br class=""></div></body></html>