Probably SSL error, but not sure

aaP_tothata77

Hello.
I have a very frustrating problem and, i am not sure why. I have 3 website on the same server. Two of them suddenly just stops about 2-3 times a week. All of the sites are wordpress sites, and i get the "Error establishing a database connection", and once i got the "There has been a critical error on this website" Always when it happens restarting the server solve the problem, but it will come again within days sometimes hours(based on logs). When the sites are down, i can not reach the database from aapanel's phpmyadmin, and of course after restarting it will be also reachable. The 3rd site is working till the error presist on the other two.
The second site which have the problem i just installed few days ago, so it happaned only once with that, but in same time than the other. I checked the error logs, and all 3 sites have the same error:
"...:443:0 server certificate does NOT include an ID which matches the server name"
and of coure i checked back the logs in the older site, and i found this error in the time when it was down, and not just that time.
But i have another two server with aapanel with 5 and 3 sites, and i just found the same error in these servers too, but i never realized any downtime with those sites. With the server with 5 sites i am working daily, so i must have realized the same isue, but never happened. I copy my settings of the sites often down and the one which working:

The one where the error happens often:

There are always before or after this SSL error an "client denied by server configuration: /www/wwwroot/xxx.hu/.user.ini" error. Sometimes a day later or before, but this error is next to the SSL one.

And as i wrote, restarting the server solve the problem for a while.

aaPanel_Kern

Hello, the SSL problem will not affect mysql. Please check whether mysql has been closed by the system? You can use this command to check
dmesg|grep -E "kill|mysql|oom"
What is the hardware configuration of your server?

aaP_tothata77

This command does nothing, with or without sudo it is the same. Or does it create a log file somewhere?
The configuration is 1vCPU Intel(R) Xeon(R) CPU E5-2680 v4 @ 2.40GHz with 4GB RAM and Ubuntu 20.04.6.
But the server with the oldes website was working since 2023 december without any issue.
As i see one of the 3 sites makes very high traffic without anyone knowing that site.
I just stopped that site two days ago, since than there is no high traffic.
I hope this will solve the main problem.

aaPanel_Kern

Hello, I suggest you check whether the logs of the stopped website are normal?

aaP_tothata77

Hello again!

I have the error again.
After i deleted the site which generated high traffic, my problem solved for more than two weeks. But now i got it again.
Both of the sites alive in server show me " Error Establishing a Database Connection", but it happens only in login pages. Maybe other pages working from cache, but if i want to login to wordpress admin i get the error, or in the other site where is option to login for customers, there i also get this database connection error. As soon as i restart the server the problem gone and probably will work again for days.
Unfortunately there is no log in the sites or in PHP, only that SSL error i wrote previously. I checked the database error log and found this:

As i wrote previously, the 3rd site what i already deleted never had the same issue.
Now i realized there is one meeting point between this two site, and not with the deleted one.
Both of the sites have connected to different domain originally what are the used domains.
One of the sites was created in chess.coredesign.store and when i was ready with the site i attached the chessrestaurant.hu domain which is my clients domain, but i didn't delete the original one where i worked.
The other site is not the same, but similar. There i worked on the vitaminstudio.hu domain and when i was ready with the site i created a new site in aapanel for the magyarvital.hu domain which is the main domain. So the main domain i just created for the directory of the vitaminstudio.hu. It should not be a problem, because this is just like i attach more than one domain to a site.
I already did the same with other sites in other servers with aapanel, and never happened this kind of error.
Do you think if i reinstall both sites for the used domains only will solve this error? Honestly i don't think, because they are working perfectly for weeks or at least days after restarting the server, so i am sure there should be a solution for this.

The setup is the following on the server:
-aapanel 6.8.33
-PHP 8.1
-Apache 2.4.57
-MySQL 5.7.4

Thank you!

aaPanel_Kern

Hello, it is recommended that you increase the server configuration. It is usually caused by insufficient server configuration that causes mysql to be shut down by the system.

aaP_tothata77