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.
1201
MySQL / Re: virtual memory size
« on: February 11, 2023, 12:23:28 AM »
Definitely consider doing some MySQL performance tuning. There are scripts you can download that check your environment and offer suggestions for changes in you my.cnf file.
MySQL allocates memory in tons of places. Especially look at table cache
Performance_schema
Run this:
and look at the last line. That may be the cause for the systems with small amount of RAM, i.e. 1G or less
InnoDB
Run this:
check the buffer pool section, memory allocated for buffer_pool and related caches)
Temporary tables in RAM
Find all in-memory tables by running
Prepared statements, when it is not deallocated (check the number of prepared commands via deallocate command by running
Welcome to the deep end
MySQL allocates memory in tons of places. Especially look at table cache
Performance_schema
Run this:
Code: [Select]
show engine performance_schema status and look at the last line. That may be the cause for the systems with small amount of RAM, i.e. 1G or less
InnoDB
Run this:
Code: [Select]
show engine innodb status check the buffer pool section, memory allocated for buffer_pool and related caches)
Temporary tables in RAM
Find all in-memory tables by running
Code: [Select]
select * from information_schema.tables where engine='MEMORY'Prepared statements, when it is not deallocated (check the number of prepared commands via deallocate command by running
Code: [Select]
show global status like ‘ Com_prepare_sql';show global status like 'Com_dealloc_sql'Welcome to the deep end
1202
E-Mail / Re: I can rececive emails, but cannot send any emails
« on: February 11, 2023, 12:15:15 AM »1203
CSF Firewall / Re: Custom Webpage rather than "not solved"
« on: February 10, 2023, 03:37:45 PM »
The one-liner above should be:
Code: [Select]
cp /etc/csf/csf.conf{,.backup} && csf -u && sed -i 's/MESSENGER = "0"/MESSENGER = "1"/g' /etc/csf/csf.conf ; sed -i 's/MESSENGERV2 = "0"/MESSENGERV2 = "1"/g' /etc/csf/csf.conf ; sed -i 's/MESSENGER_HTTPS_IN = ""/MESSENGER_HTTPS_IN = "443"/g' /etc/csf/csf.conf ; useradd csf -s /bin/false ; csf -ra
And here it is as multiple lines:Code: [Select]
cp /etc/csf/csf.conf{,.backup}
csf -u
sed -i 's/MESSENGER = "0"/MESSENGER = "1"/g' /etc/csf/csf.conf
sed -i 's/MESSENGERV2 = "0"/MESSENGERV2 = "1"/g' /etc/csf/csf.conf
sed -i 's/MESSENGER_HTTPS_IN = ""/MESSENGER_HTTPS_IN = "443"/g' /etc/csf/csf.conf
useradd csf -s /bin/false
csf -ra
1204
MySQL / Re: virtual memory size
« on: February 10, 2023, 08:07:37 AM »
Check the available RAM on your server:
Check mysql configuration: /etc/my.cnf or in the configuration directory: /etc/my.cnf.d.
Run
Do you have a lot of caching in your my.cnf file?
Code: [Select]
free -g
cat /proc/meminfoCheck what applications are using large amounts of RAM: top or htop (see the resident vs virtual memory)Check mysql configuration: /etc/my.cnf or in the configuration directory: /etc/my.cnf.d.
Run
Code: [Select]
vmstat 5 5 to see if the system is reading/writing via virtual memory and if it is swapping...Do you have a lot of caching in your my.cnf file?
1205
MySQL / Re: MySQL Database Server - Failed
« on: February 10, 2023, 07:46:40 AM »
Try moving or removing the aria_log_control file, then start mariadb.
Code: [Select]
/var/lib/mysql/aria_log_control
1206
Mod_Security / Re: Mod Security issue? pid 2459:tid 140698774865664
« on: February 10, 2023, 07:41:15 AM »
You're using the OWASP ruleset. I would suggest trying the Comodo rules instead -- it will throw less false-positives; it's not as restrictive and is more beginner-friendly.
1207
Some people just click on the "Unread" link and only peruse those (few) threads. To discover more, you have use this link instead:
Click here to try all unread topics.
Or better yet, simply look on the Forum homepage and just scroll the forum list to see if any topics are new or interest you. But you don't see the "child" fora:
Control Web Panel
(So you could make a case for there being too many categories and sub-categories. But it does help for categorization of issues.)
Click here to try all unread topics.
Or better yet, simply look on the Forum homepage and just scroll the forum list to see if any topics are new or interest you. But you don't see the "child" fora:
Control Web Panel
(So you could make a case for there being too many categories and sub-categories. But it does help for categorization of issues.)
1208
CentOS-WebPanel GUI / Re: How can I enable force HTTPS for Apache webserver for all domains?
« on: February 10, 2023, 07:31:37 AM »
It's possible to do a permanent redirect in the vhost config:
But a 301 redirect is preferred. In vhost conf or in .htaccess:
Code: [Select]
<VirtualHost *:80>
ServerName example.com
ServerAlias www.example.com
Redirect permanent / https://example.com/
</VirtualHost>But a 301 redirect is preferred. In vhost conf or in .htaccess:
Code: [Select]
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://example.com/$1 [L,R=301]
1209
CentOS-WebPanel GUI / Re: How to enable one click login to phpmyadmin
« on: February 10, 2023, 07:25:46 AM »
Unless your MySQL password differs from your r00t password... then MySQL r00t does not equal r00t...
1210
Installation / Re: What distro to go for..
« on: February 10, 2023, 07:24:22 AM »
Good, good, good to know! Thanks for the advice, Starburst. I'll be looking at AlmaLinux as my CentOS 7 EOL exit path.
1211
Installation / Re: Rocky Linux 8 too Rocky??
« on: February 10, 2023, 07:22:57 AM »Rocky Linux has suffered from missing packages, since the pre-release versions.Good to know your experience! I trust your impressions. I was leaning toward AlmaLinux anyway, but I think you've swayed me fully to pursue AlmaLinux for my CentOS 7 EOL exit plan!
But ultimately we had to abandon it for AlmaLinux.
1212
E-Mail / Re: I can rececive emails, but cannot send any emails
« on: February 10, 2023, 06:35:19 AM »Can we arrange a time for me to access your computer and access your server to check what it could be?Sorry, but that sounds rather scary. Maybe we can keep working on it here in the forum, in public view.
1213
Updates / Re: How can update PHP for cwpsrv
« on: February 10, 2023, 06:08:51 AM »
sure, if you want the nuclear option:
rm -rf the roundcube directory, drop the roundcube DB, and disable the webmail portions of your vhost config files.
But you could simply just block :2095 and :2096 in the firewall for now. (But just say NO to plain http:// connections and don't use :2095 anyway!)
rm -rf the roundcube directory, drop the roundcube DB, and disable the webmail portions of your vhost config files.
But you could simply just block :2095 and :2096 in the firewall for now. (But just say NO to plain http:// connections and don't use :2095 anyway!)
1214
Updates / Re: ClamAV update error
« on: February 10, 2023, 06:05:22 AM »
are you just running freshclam manually?
what are your permissions on /var/lib/clamav/ ?
what are your permissions on /var/lib/clamav/ ?
1215
CSF Firewall / Re: Custom Webpage rather than "not solved"
« on: February 10, 2023, 06:02:38 AM »Quote
Messenger service
Enabling this feature allows CSF to send a more informative message to the client when a block is applied. This feature has both pros and cons. On one hand, enabling it provides more information to the client, and thus may cause less frustration for instance in case of failed logins. On the other hand, this provides more information, which might make it easier for an attacker to attack your VPS.
https://codepre.com/en/como-configurar-messenger-en-csf-parte-1.html#:~:text=This%20one%20line%20command:%201%20backup%20of%20the,logged%20in%20as%20root%20or%20have%20sudo%20access)
Code: [Select]
p /etc/csf/csf.conf{,.backup} && csf -u && sed -i 's/MESSENGER = "0"/MESSENGER = "1"/g' /etc/csf/csf.conf ; sed -i 's/MESSENGERV2 = "0"/MESSENGERV2 = "1"/g' /etc/csf/csf.conf ; sed -i 's/MESSENGER_HTTPS_IN = ""/MESSENGER_HTTPS_IN = "443"/g' /etc/csf/csf.conf ; useradd csf -s /bin/false ; csf -raThis one line command:backs up the CSF configuration file
updates CSF to the latest version
make the necessary changes to the configuration file
then restart the CSF services to enable the messaging feature
(You will need to be logged in as root or have sudo access)
