kbadmin has written 149 articles

How to update mysqltuner.pl to latest version

Login to your system ssh with root 1: Move the old version of mysqltuner.pl mv /usr/local/cpanel/3rdparty/bin/mysqltuner.pl /usr/local/cpanel/3rdparty/bin/mysqltuner.pl.old 2: Create a new file with nano nano /usr/local/cpanel/3rdparty/bin/mysqltuner.pl Copy the newest version from github direct link paste it in the file and save. 3: Change permission chmod 755 /usr/local/cpanel/3rdparty/bin/mysqltuner.pl Congratulations you now have the latest version of mysqltuner.pl   MySQLTuner-perl MySQLTuner…

How to install mysqli in cpanel

To install mysqli using EachApache: 1. Login to WHM as ‘root’ user. 2. Either search for “EasyApache” or go to Software > EasyApache 3. Scroll down and select a build option (Previously Saved Config) 4. Click Start “Start customizing based on profile” 5. Select the version of Apache and click “Next Step”. 6. Select the…

Adding trim function to ssd and Mounting MySQL on a SSD Solid-State Disk

Install a new drive, format, partition and mount it, for example as: “/ssd” It is recommended that the SSD drive be setup in EXT4 format. EXT4 format supports TRIM when used with “discard” mount option.   Solid State Drives (SSDs) are not PnP devices. Special considerations such as partition alignment, choice of file system, TRIM…

WatchMySQL plugin for cPanel/WHM

Overview This plugin gives administrators the ability to monitor concurrent user connections to MySQL. The WatchMySQL daemon can be configured so that when a user exceeds theire connection limit a notification is sent to the administrator and/or user. The daemon can also be configured so that it will kill off those connections. Limits can be…

Clean Backups plug-in for cPanel/WHM

Overview cPanels backup script will not remove backups for accounts that no longer exist and these backups will remain on the backup drive until removed. This plug-in gives administrators the ability to clean up their backup directory by setting how long they want to keep backups for accounts that no longer exist and removing those…

How to install ClamAV with MailScanner

These instructions will configure ClamAV to use the clamd daemon: Make sure clamavconnector is NOT installed in WHM > Manage Plugins as this will break MailScanner If you would like to verify ClamAV’s digital signatures on the virus definition files as they are updated through freshclam, you need to install GMP first: /scripts/ensurerpm gmp gmp-devel bzip2-devel Next you…