fail to connect librenms@librenms:~$ mysql -u librenms -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused") librenms@librenms:~$ | |
msql status librenms@librenms:/var/run/mysqld$ systemctl status mysql.service ● mariadb.service - MariaDB 10.1.44 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Wed 2020-06-10 10:57:49 UTC; 14min ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 1099 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 1097 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS) Process: 2142 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 2081 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment Process: 2079 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 2076 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 2142 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" librenms@librenms:/var/run/mysqld$ | |
stop and start librenms@librenms:/var/run/mysqld$ sudo systemctl stop mysql.service librenms@librenms:/var/run/mysqld$ sudo systemctl start mysql.service librenms@librenms:/var/run/mysqld$ systemctl status mysql.service ● mariadb.service - MariaDB 10.1.44 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2020-06-10 11:13:23 UTC; 4s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 5159 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 5157 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS) Process: 5114 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment Process: 5112 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 5111 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 5129 (mysqld) Status: "Taking your SQL requests now..." Tasks: 27 (limit: 522) CGroup: /system.slice/mariadb.service └─5129 /usr/sbin/mysqld librenms@librenms:/var/run/mysqld$ | |
General
Content
Integrations