Categories
Server

How to Change SSH Port with WHM & CSF

If you are using WHM & CSF, under CentOS, you may follow this steps to change SSH port from 22 (default) to something else 🙂

Categories
Server

How to Install ConfigServer Security & Firewall (CSF) in WHM

To install ConfigServer Security & Firewall (CSF) in WHM, please run this commands in your SSH terminal one by one.

wget http://www.configserver.com/free/csf.tgz
tar -xzf csf.tgz
cd csf
sh install.sh

After it completes, there is a new menu in WHM which is under “Plugins” category, named “ConfigServer Security & Firewall”. 🙂

Categories
Server

How to Install Litespeed in WHM

Here i will explain how to install Litespeed webserver in WHM.
According to the Litespeed wiki :

  1. Open & login to your SSH terminal
  2. Execute this command to download the installer :
    wget http://www.litespeedtech.com/packages/cpanel/lsws_whm_autoinstaller.sh
  3. Next we will make the file executable :
    chmod a+x lsws_whm_autoinstaller.sh
  4. Last step we can execute this command :
    (please check the litespeed wiki for parameter explanation)

    ./lsws_whm_autoinstaller.sh TRIAL 2 1000 admin a1234567 [email protected] 1 0

    If you have litespeed license, replace “TRIAL” with your serial number.
    You can replace “admin” with another litespeed admin username.
    You can replace “a1234567 ” with another litespeed admin password.
    You can replace “[email protected]” with another litespeed admin e-mail.

  5. Wait until it completes.
  6. A new sub menu named “Litespeed Web Server” will appear on your WHM.
  7. You must activate litespeed from that sub menu.
Categories
Database Server

Exporting MySQL Databases Command Line in Linux

To export a mysql database by linux command line,
for example your database name is my_database, your mysql username is my_username, and your mysql password is my_password, you can use this command :

mysqldump --opt --single-transaction -umy_username -pmy_password my_database > /your/path/here/export.sql

Note: after “-u” and “-p”, there is NO space. 🙂

Categories
Database Server

MySQL Table “In Use” Repair

Recently when i optimized some mysql tables from phpmyadmin, some of the tables were “locked” and showed as “in use” on phpmyadmin. The tables could not be used, read, etc. So the script was stopped working.
I have tried to repair / check / analyze from phpmyadmin but i couldn’t repair it.
So i tried to repair the mysql tables from SSH.

Go to your database directory. Usually it is located on
/etc/var/lib/mysql/YOUR_DATABASE_NAME/

So use this command first
cd /etc/var/lib/mysql/YOUR_DATABASE_NAME/

Next, use this command
myisamchk --safe-recover --force YOUR_TABLE_NAME

And the MySQL table should be repaired now.