Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
286
Information / Re: Paython and CWP
« on: May 15, 2023, 09:12:02 AM »
connect to the database of CWP, usually called root_cwp and run the following SQL request/query:
You should get a list of CWP users and main domain names associated with their accounts.
In case the you get nothing then restore the database from backup.
Code: [Select]
select * from user;You should get a list of CWP users and main domain names associated with their accounts.
In case the you get nothing then restore the database from backup.
287
Information / Re: Paython and CWP
« on: May 14, 2023, 12:04:50 PM »
So you can connect to the database from the command line. Then connect to the database of the CWP again and make sure it isn't empty:
you should see something like:
If your result is the same then the db looks good.
I checked this forum and found another thread with the similar errors. Please review the thread:
https://forum.centos-webpanel.com/informations/mysqli_error()/
Hope it will help you to solve the problem.
Also, in case you decide to reinstall MySQL/MariaDB, don't forget to make backups of your databases.
Code: [Select]
mysql -uDB_USER -pDB_PASS DB_NAME
show tables;you should see something like:
Code: [Select]
MariaDB [root_cwp]> show tables;
+--------------------+
| Tables_in_root_cwp |
+--------------------+
| backups |
| domains |
| nameserver |
| notifications |
| packages |
| settings |
| subdomains |
| user |
+--------------------+
8 rows in set (0.000 sec)
If your result is the same then the db looks good.
I checked this forum and found another thread with the similar errors. Please review the thread:
https://forum.centos-webpanel.com/informations/mysqli_error()/
Hope it will help you to solve the problem.
Also, in case you decide to reinstall MySQL/MariaDB, don't forget to make backups of your databases.
288
CentOS 8 Problems / Re: How to fix roundcube mail server 403 forbidden error
« on: May 13, 2023, 09:44:59 PM »
I recommend you to following:
Go to the document root of Roundcube (webmail):
http://hostname.com/webmail/aa.php
if you get the error 403 again then most likely the problem is caused by wrong user/group, access permissions or .htaccess file.
Make sure the folder of roundcube belongs to
If the access permissions (ownger:group, etc) are correct then rename .htaccess to something like .htaccess_backup and try to access the file aa.php over the web again. In case it can be accessed then investigate your .htaccess.
Don't forget to remove the file aa.php when all test are finished.
Go to the document root of Roundcube (webmail):
Code: [Select]
cd /usr/local/cwpsrv/var/services/roundcubecreate a simple php file:Code: [Select]
echo "<?php phpinfo(); ?>" > aa.php
chown cwpsvc.cwpsvc aa.phpthen try to access it over the web (in your browser):http://hostname.com/webmail/aa.php
if you get the error 403 again then most likely the problem is caused by wrong user/group, access permissions or .htaccess file.
Make sure the folder of roundcube belongs to
Code: [Select]
cwpsvc:cwpsvcAll folders have access permissions 755 (rwx-rx-rx) and files 644 (-rw-r--r--) except config/config.inc.php 640 (rw-r-----)If the access permissions (ownger:group, etc) are correct then rename .htaccess to something like .htaccess_backup and try to access the file aa.php over the web again. In case it can be accessed then investigate your .htaccess.
Don't forget to remove the file aa.php when all test are finished.
289
Installation / Re: wordpress
« on: May 13, 2023, 06:23:05 PM »
What kind of webserver do you use (Nginx, Nginx+Apache, something else) ?
290
Information / Re: Paython and CWP
« on: May 13, 2023, 06:15:00 PM »
Try to connect to the database of CWP manually from terminal (SSH) using the command:
DB_USER, DB_PASS, DB_NAME you can get from the file:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
If you get something like:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
then try to reset the password using the script:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf
restart CWP:
Code: [Select]
mysql -uDB_USER -pDB_PASS DB_NAMEDB_USER, DB_PASS, DB_NAME you can get from the file:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
If you get something like:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
then try to reset the password using the script:
Code: [Select]
/scripts/mysql_pwd_reset -qthen make sure the new password is listed in the files:/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf
restart CWP:
Code: [Select]
service cwpsrv restartand then try to access CWP from the web again.291
CWP API / Re: mysql user add help
« on: May 13, 2023, 04:17:23 PM »
As I understand you want to create a db_user, database and then add the created db_user to the database using API of CWP.
I looked at the CWP API, seems the action "add" of the API call "usermysql" creates the user and adds the db_user to the database because it has the param called "dbase" in description.
Let us know if it works
I looked at the CWP API, seems the action "add" of the API call "usermysql" creates the user and adds the db_user to the database because it has the param called "dbase" in description.
Let us know if it works
292
Apache / Re: PHP Processing in .htm & .html files
« on: May 12, 2023, 09:22:28 PM »
I am not 100% sure but I guess:
When you put:
into .htaccess your .htm, .html files are handled by suPHP. That is why you see
To solve this you need to customize the Apache template file (you wrote about .htaccess that is why I am sure you use Apache ).
The Apache php-fpm template files are located in the folder:
/usr/local/cwpsrv/htdocs/resources/conf/web_servers/vhosts/httpd/php-fpm/
Probably you need to change the lines:
inside the template files to something like:
then rebuild virtual hosts and restart Apache.
Sorry, I use a free version of CWP on my test box, so I don't use php-fpm there and can't be sure it is 100% working solution (make backups before you modify something ).
When you put:
Code: [Select]
AddHandler application/x-httpd-php81 .htm .htmlinto .htaccess your .htm, .html files are handled by suPHP. That is why you see
Code: [Select]
Server API: CGI/FastCGITo solve this you need to customize the Apache template file (you wrote about .htaccess that is why I am sure you use Apache
).The Apache php-fpm template files are located in the folder:
/usr/local/cwpsrv/htdocs/resources/conf/web_servers/vhosts/httpd/php-fpm/
Probably you need to change the lines:
Code: [Select]
<IfModule proxy_fcgi_module>
<FilesMatch \.php$>
SetHandler "proxy:%backend_fcgi%|fcgi://localhost"
</FilesMatch>
</IfModule>
inside the template files to something like:
Code: [Select]
<IfModule proxy_fcgi_module>
<FilesMatch \.php$|\.htm$|\.html$>
SetHandler "proxy:%backend_fcgi%|fcgi://localhost"
</FilesMatch>
</IfModule>then rebuild virtual hosts and restart Apache.
Sorry, I use a free version of CWP on my test box, so I don't use php-fpm there and can't be sure it is 100% working solution (make backups before you modify something
).
293
Information / Re: So what's the verdict on AlmaLinux?
« on: May 12, 2023, 08:35:30 PM »
I created a VPS with Almalinux 8 a few days ago. Installed CWP (free), customized it according to my requirements (replaced suPHP by FastCGI/FCGI to enable multi PHP setup, installed rspamd, compiled custom kernel, etc, etc, etc) and it is going fine.
Currently I am investigating how to fix the problem with FFMpeg because the option offered by CWP causes error during the compilation.
However, it looks very promising for me (even a free version).
Currently I am investigating how to fix the problem with FFMpeg because the option offered by CWP causes error during the compilation.
However, it looks very promising for me (even a free version).
294
Installation / Re: Fresh install has MariaDB error. How to resolve?
« on: May 12, 2023, 09:56:29 AM »
The page:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
explains how to upgrade MariaDB from 10.2 to 10.4.
The upgrade process from 10.2 to 10.6 is similar. Just replace 10.4 to 10.6 in the above instructions.
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
explains how to upgrade MariaDB from 10.2 to 10.4.
The upgrade process from 10.2 to 10.6 is similar. Just replace 10.4 to 10.6 in the above instructions.
295
Postfix / Re: All inbound mail fails when enabling Spam Assassin/Avamis
« on: May 11, 2023, 07:31:19 PM »
Are there some records associated with the sender's email address in the email logs and/or IP address (/var/log/maillog) ?
296
CentOS Configuration / Re: Help me. lfd on cwp.xxxxxx.com: Suspicious process running under user memcached
« on: May 11, 2023, 10:08:45 AM »
Hi,
memcached is a caching daemon/service.
If your websites don't use memcached and you don't need it then just stop memcached.
In other case you put the line:
and then restart CSF:
memcached is a caching daemon/service.
If your websites don't use memcached and you don't need it then just stop memcached.
Code: [Select]
service memcached stoprun as root in console (terminal).In other case you put the line:
Code: [Select]
exe:/usr/bin/memcachedinto the file: /etc/csf/csf.pignoreand then restart CSF:
Code: [Select]
csf -rrun it as root in console (terminal).
297
CentOS 7 Problems / Re: Without any type of access
« on: May 11, 2023, 10:02:15 AM »
Guys, I assume you need to contact the hosting company you rent your VPS from to get assistance or make attempt to access the VPS via serial console, etc if your service provider offers such feature.
298
SSL / Re: How to Change SSL Port number in cwp?
« on: May 10, 2023, 06:27:07 PM »
Hi,
If you use CSF then you can do it using CSF (ip tables). However you will be forced to specify the port number in your URLs like:
https://domain.com:4443/
to access the sites over HTTPS.
If it is ok for you then just put the following line into the file:
/etc/csf/csf.redirect
then restart CSF:
If you use CSF then you can do it using CSF (ip tables). However you will be forced to specify the port number in your URLs like:
https://domain.com:4443/
to access the sites over HTTPS.
If it is ok for you then just put the following line into the file:
/etc/csf/csf.redirect
Code: [Select]
*|4443|*|443|tcpthen restart CSF:
Code: [Select]
csf -r
299
CentOS-WebPanel GUI / Re: Packages won't update on account
« on: May 10, 2023, 09:06:20 AM »
Have the same issue.
However, when I do:
1. Suspend account
2. Unsuspend account
3. Restart CWP
the limits of the account become correct accordingly to the specs of the applied package.
However, when I do:
1. Suspend account
2. Unsuspend account
3. Restart CWP
the limits of the account become correct accordingly to the specs of the applied package.
300
Installation / Re: How to improve site speed and security
« on: May 10, 2023, 07:57:56 AM »
Hi,
If you don't want to buy the Litespeed license and spend on your time to redesign apache mod_rewrite rules for Nginx then on my opinion the better performance will be delivered by the webserver configuration: Nginx+Apache (php+fpm)
Additionally, the following configuration will allow you to enable Web Application Firewall (WAF) mod_security for your websites. mod_security blocks suspicious HTTP/HTTPS requests. However, the default mod_rewrite rules offered by CWP (Pro) causes false positive alarms. So it is better to review the mod_security logs from time to time to find and analyze the blocked HTTP/HTTPS requests. If the alarm is false positive then you can disable the problematic rule(s) over .htaccess of your website.
If you don't want to buy the Litespeed license and spend on your time to redesign apache mod_rewrite rules for Nginx then on my opinion the better performance will be delivered by the webserver configuration: Nginx+Apache (php+fpm)
Additionally, the following configuration will allow you to enable Web Application Firewall (WAF) mod_security for your websites. mod_security blocks suspicious HTTP/HTTPS requests. However, the default mod_rewrite rules offered by CWP (Pro) causes false positive alarms. So it is better to review the mod_security logs from time to time to find and analyze the blocked HTTP/HTTPS requests. If the alarm is false positive then you can disable the problematic rule(s) over .htaccess of your website.
