Category Archives: Tutorial

Konversi tabel InnoDB ke MyISAM

Untuk menjaga performansi server terutama agar mysql tidak overload, salah satunya adalah dengan menggunakan default MyISAM tabel dengan menambahkan field skip-innodb pada /etc/my.cnfBila sudah ada tabel yang terlanjur menggunakan format innoDB dapat dikonversi ke MyISAM dengan cara: ALTER TABLE table_name ENGINE = MyISAM;

Edit Default PHP-FPM Settings

If you have many cPanel accounts, you may prefer to change the default settings for newly created cPanel accounts. As root, SSH into your server or launch WHM terminal. Create a system_pool_defaults.yaml file in the /var/cpanel/ApachePHPFPM directory. To do this using nano, type the following: nano /var/cpanel/ApachePHPFPM/system_pool_defaults.yaml Add the following to the new file: pm_max_children:… Read More »

CSF wp-login attempts block

In order to block IP’s that flood wp-login.php attempts by using CSF regex.custom.pm if (($globlogs{CUSTOM2_LOG}{$lgfile}) and ($line =~ /(\S+).*] “\w*(?:GET) \/wp-login\.php.*” /)) { return (“Failed WordPress GET”,$1,”WPLOGINGET”,”3″,”80,443,21,25,22,23″,”1″); } if (($globlogs{CUSTOM2_LOG}{$lgfile}) and ($line =~ /(\S+).*] “\w*(?:POST) \/wp-login\.php.*” /)) { return (“Failed WordPress POST”,$1,”WPLOGINPOST”,”3″,”80,443,21,25,22,23″,”1″); }