Guys, the server stopped out of nowhere, giving a server error 500, and stopped everything, I realize that it is something with the database, how can I solve this problem please help me, I am desperate, because I do not have a backup of the sites.
Here is the error I saw in journalctl -xe
Jun 26 21:41:14 cyberpanel sshd[7844]: Failed password for www-data from 5.78.82.214 port 59352 ssh2
Jun 26 21:41:14 cyberpanel sshd[7844]: Connection closed by authenticating user www-data 5.78.82.214 port 59352 [preauth]
other:
Jun 26 21:31:56 cyberpanel sshd[6881]: Failed password for invalid user wang from 5.78.64.143 port 35310 ssh2
Jun 26 21:31:57 cyberpanel sshd[6881]: Connection closed by invalid user wang 5.78.64.143 port 35310 [preauth]
Jun 26 21:32:06 cyberpanel sshd[6883]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=5.78.82.214 user=uucp
other:
Jun 26 21:31:54 cyberpanel sshd[6881]: pam_unix(sshd:auth): check pass; user unknown
Jun 26 21:31:54 cyberpanel sshd[6881]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=5.78.64.143
other:
Jun 26 21:31:44 cyberpanel sshd[6879]: Failed password for uucp from 5.78.82.214 port 56888 ssh2
Jun 26 21:31:45 cyberpanel sshd[6879]: Connection closed by authenticating user uucp 5.78.82.214 port 56888 [preauth]
Jun 26 21:31:54 cyberpanel sshd[6881]: Invalid user wang from 5.78.64.143 port 35310
If I try to enter the password, it gives this error:
root@cyberpanel:~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
if I give the command systemctl status mariadb, it gives this error:
root@cyberpanel:~# systemctl status mariadb
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2023-06-26 21:41:13 UTC; 15 minutes ago
Docs: man:mysqld(8)
systemd - MariaDB Knowledge Base
Process: 7757 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 7771 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 7773 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery; [$? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR ||>
Process: 7823 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 7823 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”
Jun 26 21:41:07 cyberpanel systemd[1]: Starting MariaDB 10.3.38 database server…
Jun 26 21:41:13 cyberpanel systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 26 21:41:13 cyberpanel systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Jun 26 21:41:13 cyberpanel systemd[1]: Failed to start MariaDB 10.3.38 database server.
trying to upgrade the cyber panel, it gives this error:
[06.26.2023_21-23-22] ########################################### ################################
[06.26.2023_21-23-22] (2002, “Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)”)
[06.26.2023_21-23-22] ########################################### ################################
‘int’ object has no attribute ‘execute’
Traceback (most recent call last):
File “upgrade.py”, line 842, in applyLoginSystemMigrations
cursor.execute(“UPDATE loginSystem_acl SET config = ‘%s’ where name = ‘admin’” % (Upgrade.AdminACL))
AttributeError: ‘int’ object has no attribute ‘execute’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “upgrade.py”, line 3072, in
main()
File “upgrade.py”, line 3068, in main
Upgrade.upgrade(args.branch)
File “upgrade.py”, line 2976, in upgrade
Upgrade.applyLoginSystemMigrations()
File “upgrade.py”, line 845, in applyLoginSystemMigrations
import sleep
ModuleNotFoundError: No module named ‘sleep’
above command failed…
To unload, the server has plenty of disk space:
root@cyberpanel:~# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
udev 241185 443 240742 1% /dev
tmpfs 246155 692 245463 1% /run
/dev/sda1 2427136 851361 1575775 36% /
tmpfs 246155 10 246145 1% /dev/shm
tmpfs 246155 3 246152 1% /run/lock
tmpfs 246155 18 246137 1% /sys/fs/cgroup
/dev/loop0 96000 508 95492 1% /tmp
/dev/sda15 0 0 0 - /boot/efi
tmpfs 246155 24 246131 1% /run/user/0