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.
61
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").
62
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.
63
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 ?
64
Information / Re: goaccess geo ip location
« on: February 24, 2025, 12:08:58 AM »
More easy way ? Install the geoip database using dnf/yum.
65
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.
66
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
67
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 ?
68
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.
69
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).
70
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
71
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
72
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
73
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.
74
Installation / Re: the snapshot or to do a new installation?
« on: February 16, 2025, 07:59:28 PM »
It seems your post does't specify what your goal is. So:
If your goal is to roll back your VPS to the state before you did testing then use snapshot. If you goal is to get clean "CWP" then install CWP on a fresh system.
If your goal is to roll back your VPS to the state before you did testing then use snapshot. If you goal is to get clean "CWP" then install CWP on a fresh system.
75
Postfix / Re: Rebuild or Repair Configs
« on: February 14, 2025, 03:49:21 PM »
In CWP admin --> Email --> MailServer Manager --> Rebuild Mail Server.
