Control Web Panel

WebPanel => CentOS Configuration => Topic started by: furkany on May 17, 2023, 06:20:20 AM

Title: cwp does not show websites on cgroups page?
Post by: furkany on May 17, 2023, 06:20:20 AM

hello my dear friends.

cgroups page in panel not showing websites list? this was working before. I'm using vps before, the vps disk size was 200gb, then I upgraded it to 400gb. but it was working. suddenly disappeared no more website list. please help me?

https://prnt.sc/n2hZLwXpvSYg

Title: Re: cwp does not show websites on cgroups page?
Post by: cyberspace on May 19, 2023, 07:24:10 PM

The service could be disabled in autoboot. It could be case if the server was rebooted after the upgrade. So make sure the service is running.

Title: Re: cwp does not show websites on cgroups page?
Post by: furkany on May 22, 2023, 10:57:27 AM

I found that the problem is as follows.
I changed mysql my.cnf file because I got a mysql error on some sites. but when I did this, the cgroups page did not work and no data came in the list user page. Removed sql_mode="" and everything was fine. but mysql errors still continue, I would be very happy if you could help me with this. Thank you from now.

I'm sharing it in case it happens to other friends.

Title: Re: cwp does not show websites on cgroups page?
Post by: cyberspace on May 22, 2023, 02:54:37 PM

Connect to mysql/mariadb as root and run the following SQL command/query:

Code: [Select]

show variables like "sql_mode";
I get "NO_ENGINE_SUBSTITUTION" only. In case you get something else, set:

Code: [Select]

sql_mode="NO_ENGINE_SUBSTITUTION"
in my.cnf and restart MySQL/MariaDB.

If it doesn't help either, provide us with the SQL error mentioned by you and detail what MySQL/MariaDB version you use.