[BUG] Root Domain reports Database Error (sometimes) and Unable to access the backend (Server Error 500)

[packetdog]

So I put in a Freshdesk ticket for this as well, but since I didn't change anything with the server and now I have sites down, this seems like a bug.

The example sites are in the freshdesk ticket. I can't login there, so I can't link a ticket number. I also didn't receive a ticket number via email. The summary of the issue is as follows:

If you go to https://domain1.com/ you receive a database error. If you go to https://www.domain1.com/ the site loads normally.
If you go to https://domain2.com/ and/or https://www.domain2.com/ the site errors out with a database error.

If you got to my website, https://thebestmsp.com/ or https://www.thebestmsp.com/ both load without issue.

If you go to the cyberpanel back end interface at https://name.thebestmsp.com:8090/ we receive a Server Error (500). I've been unable to trace this error however, I can't find a 500 error in /home/name.thebestmsp.com/logs/name.thebestmsp.com_error.log.

Can you provide any guidance on this issue? We patch the server via apt-get update; apt-get upgrade on a monthly basis, but we haven't patched the server until today in 24 days. We haven't seen any issues. When this issue presented earlier today, I ran apt-get update and apt-get upgrade and restarted to no avail.

We haven't updated cyberpanel since the security incident in Nov/Dev 2024. Can you let me know where I can find working logs and/or how to troubleshoot this issue? Cyberpanel has been stable for more than 2 years (we're on Ubuntu 22.04 and it's been fine.)

Thanks,
John
LCS

[packetdog]

Please allow me to add this, my attempt to upgrade because I'm panicking and my websites are down (i.e. I ran the upgrade script from Github) and I'm still down....:

[01.26.2025_20-31-42] #########################################################################

[01.26.2025_20-31-42] (2002, "Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)")

[01.26.2025_20-31-42] #########################################################################

'int' object has no attribute 'execute'
Traceback (most recent call last):
File "/root/cyberpanel_upgrade_tmp/upgrade.py", line 892, 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 "/root/cyberpanel_upgrade_tmp/upgrade.py", line 3983, in
main()
File "/root/cyberpanel_upgrade_tmp/upgrade.py", line 3979, in main
Upgrade.upgrade(args.branch)
File "/root/cyberpanel_upgrade_tmp/upgrade.py", line 3496, in upgrade
Upgrade.applyLoginSystemMigrations()
File "/root/cyberpanel_upgrade_tmp/upgrade.py", line 895, in applyLoginSystemMigrations
import sleep
ModuleNotFoundError: No module named 'sleep'
above command failed...
root@pico:~#

[packetdog]

So, for one of the domains, what helped was:

service mysql stop
_>> Edit my.cfg and add innodb_force_recovery = 1
service mysql start
service mysql stop
->> Comment the innodb_force_recovery = 1 line.
service mysql start

[packetdog]

For what it's worth, I still can't access the https://site.fqdn.com:8090/ - instead of giving a 500 error, I get nothing now..

[packetdog]

I'd just like to extend a (not)heartfelt thank you for actually not replying to this and/or the Facebook posts. Cyberpanel is not great based on this. I'm actively working on a new solution. Sorry, but not sorry, this is terrible.

[ImLuke954]

Is this project abandoned? Last updated 3 months ago. No reply to issues.

[Orgoth]

The developers hardly communicate with the users at all, even in the forum there are almost no answers.
I dropped cyberpanel after the Root RCE incident and one server getting encrypted!

https://nvd.nist.gov/vuln/detail/CVE-2024-51378

I would say, do yourself a favor and do not use cyberpanel.

https://community.cyberpanel.net/c/support/55

90% of the time, users are help other users, instead of the team.

But they have enough time to post blog posts multiple times a day.

https://cyberpanel.net/blog