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.
136
Backup / Re: external backup of mysql database to linux server using bash
« on: February 24, 2025, 09:43:51 PM »
If the user has static IP address then the port 3306 can be firewalled and opened for specific IP only. However, it is a point of attention.
If the user's IP is dynamic then VPN can be used.
If the user's IP is dynamic then VPN can be used.
137
CentOS-WebPanel GUI / Re: cPanel account restore not working
« on: February 24, 2025, 04:41:27 PM »
Is it the whole error message ? Is it not truncated ? I am asking because there is just a generic error and nothing to shed light on the problem.
Anyway, the problem could be caused by low value of memory_limit, fastcgi wait_timeout, request size, etc.
Anyway, the problem could be caused by low value of memory_limit, fastcgi wait_timeout, request size, etc.
138
Backup / Re: external backup of mysql database to linux server using bash
« on: February 24, 2025, 04:24:24 PM »
Don't do following:
Instead, Manage all SQL users using the CWP panel. You can add remote SQL users using CWP panel (See options offered by "MySQL manager").
Quote
MariaDB [(none)]> CREATE USER 'new_user'@'remote_server_ip' IDENTIFIED BY 'password';
Then grant the new user the appropriate privileges for your particular needs. I recomment a readonly user, with:
Code: [Select]
MariaDB [(none)]> GRANT SELECT on `Database_name`.* TO 'sammy'@'remote_server_ip' WITH GRANT OPTION;
Replace Database_Name with the backuped database name, and remote_server_ip with a FIX IP address.
But, if it have a dynamic IP (CAUTION: using ONLY with portknocking scheme) use:
Code: [Select]
MariaDB [(none)]> CREATE USER 'new_user'@'%' IDENTIFIED BY 'password';
MariaDB [(none)]> GRANT SELECT on `Database_name`.* TO 'sammy'@'%' WITH GRANT OPTION;
After changes of privileges in MariaDB, run:
Code: [Select]
MariaDB [(none)]> FLUSH PRIVILEGES;
Instead, Manage all SQL users using the CWP panel. You can add remote SQL users using CWP panel (See options offered by "MySQL manager").
139
MySQL / Re: Host key verification failed.
« on: February 24, 2025, 08:38:03 AM »
Open the file:
/USER/.ssh/known_hosts
and delete the identification string or remove the whole file on the destination server. It will be recreated automatically when you to access the server over SSH again.
/USER/.ssh/known_hosts
and delete the identification string or remove the whole file on the destination server. It will be recreated automatically when you to access the server over SSH again.
140
Information / Re: Roundcube big security issue.
« on: February 24, 2025, 12:20:24 AM »
.htaccess is server by the webservers Apache and Litespeed. CWP panel uses nginx to handle all requests coming to the panel and included services (webmail, phpmyadmin, etc). That is why .htaccess is ignored by CWP.
Anyway, if I remove the rule from:
/usr/local/cwpsrv/conf.d/webmail.conf
then I can access the logs using:
https://webmail.domain.com/logs/errors.log
same is applied for the rule from @rcschaff.
Do you have some test system and can you provide me with access to it ?
Anyway, if I remove the rule from:
/usr/local/cwpsrv/conf.d/webmail.conf
then I can access the logs using:
https://webmail.domain.com/logs/errors.log
same is applied for the rule from @rcschaff.
Do you have some test system and can you provide me with access to it ?
141
Information / Re: goaccess geo ip location
« on: February 24, 2025, 12:08:58 AM »
More easy way ? Install the geoip database using dnf/yum.
142
Apache / Re: 500 Errorr
« on: February 23, 2025, 09:46:06 AM »
You access the sites through the URLs like:
https://DOMAIN.COM/folder/
https://SUB.DOMAIN.COM/folder1/folderX/
Right ?
If so then check the error logs of the domains/subdomains you specify in your URLs.
https://DOMAIN.COM/folder/
https://SUB.DOMAIN.COM/folder1/folderX/
Right ?
If so then check the error logs of the domains/subdomains you specify in your URLs.
143
Apache / Re: 500 Errorr
« on: February 23, 2025, 09:29:17 AM »
The filename mk7zxw.php looks suspicious. Was it uploaded by you ? If no check it because it could be php shell or something like that.
However, you need to check the error logs of the websites to investigate why the error 500 appears. The error logs are located in:
/usr/local/apache/domlogs/DOMAIN.error.log
However, you need to check the error logs of the websites to investigate why the error 500 appears. The error logs are located in:
/usr/local/apache/domlogs/DOMAIN.error.log
144
Apache / Re: 500 Errorr
« on: February 22, 2025, 10:38:40 PM »
What WebServer setup do you use ? Is it Apache only, Nginx, nginx + apache, or something else ?
145
Information / Re: goaccess geo ip location
« on: February 22, 2025, 01:35:29 PM »
Seems you just need to download the maxmind database file and specify the correct path to it.
Check the section "GeoIP Options" of the file:
/etc/goaccess/goaccess.conf
on your server/vps.
Check the section "GeoIP Options" of the file:
/etc/goaccess/goaccess.conf
on your server/vps.
146
Backup / Re: external backup of mysql database to linux server using bash
« on: February 22, 2025, 10:04:58 AM »
To access PHPMyAdmin without accessing CWP use:
https://cpanel.DOMAIN.COM/pma/
use the db_user assigned to the database you want to access as the username and db_user_password to access the database.
Additionally, you can access the databases from shell or using remote SQL management tools like HeidiSQL. To access the databases remotely, make sure the db_user assigned to the database is allowed to connect to the database remotely (see "host" in MySQL manager when edit/add user).
https://cpanel.DOMAIN.COM/pma/
use the db_user assigned to the database you want to access as the username and db_user_password to access the database.
Additionally, you can access the databases from shell or using remote SQL management tools like HeidiSQL. To access the databases remotely, make sure the db_user assigned to the database is allowed to connect to the database remotely (see "host" in MySQL manager when edit/add user).
147
Installation / Re: New installation of CWP
« on: February 21, 2025, 09:53:14 PM »
Sorry, there is a sad typo. I meant Almalinux 9.
However, Almalinux 8 is good choice too. To install CWP on Almalinux 8 look at this post:
http://forum.centos-webpanel.com/centos-8-problems/can-not-install-cwp-8-on-rockylinux-8-or-almalinux-8/msg50258/#msg50258
However, Almalinux 8 is good choice too. To install CWP on Almalinux 8 look at this post:
http://forum.centos-webpanel.com/centos-8-problems/can-not-install-cwp-8-on-rockylinux-8-or-almalinux-8/msg50258/#msg50258
148
Installation / Re: New installation of CWP
« on: February 21, 2025, 07:28:01 PM »
I recommend to use AlmaLinux. If you decide to use AlmaLinux 8 then check this page:
https://forum.centos-webpanel.com/installation/server-under-al9/msg50121/#msg50121
https://forum.centos-webpanel.com/installation/server-under-al9/msg50121/#msg50121
149
Information / Re: Roundcube big security issue.
« on: February 21, 2025, 05:54:41 PM »
The extra step is necessary to close the breach. In other case the logs can be accessed over the URLs like:
https://webmail.DOMAIN.COM/logs/errors.log
https://webmail.DOMAIN.COM:2096/logs/errors.log
Add the following "location":
into the both "server" sections of the file /usr/local/cwpsrv/conf.d/webmail.conf.
Example:
then restart cwpsrv:
https://webmail.DOMAIN.COM/logs/errors.log
https://webmail.DOMAIN.COM:2096/logs/errors.log
Add the following "location":
Code: [Select]
location ~ \.log$ {
deny all;
}
into the both "server" sections of the file /usr/local/cwpsrv/conf.d/webmail.conf.
Example:
Code: [Select]
location ~ \.log$ {
deny all;
}
location / {
then restart cwpsrv:
Code: [Select]
service cwpsrv restart
150
DNS / Re: This error showing up on my server can't seem get DNS to run.
« on: February 17, 2025, 04:03:37 PM »Try to restart named and then check output of:
Code: [Select]
journalctl -xeto investigate the problem. Currently no one can tell you where the problem is because your post doesn't contain any information about the root of the problem.
