Here I am discussing the migration of Easyapache 3 to Easyapache 4 and the ntPHPselector installation ( version 4 )and the things taken care while installing the plugin. The Migration section of WHM’s EasyApache 4 interface (Home >> Software >> EasyApache 4) displays your system’s version of EasyApache and allows you to migrate to and from EasyApache 3 (EA3) and EasyApache 4 (EA4). Continue reading
ntPHPSelector version 4.0.0 released
New version of ntPHPselector released and it support easyapache version 4 and unfortunately it is not work with older easyapache version 3.
Features
[+] Support Easyapache 4
[+] Support all PHP versions, available in cPanel Multi-PHP
[-] Do not work with Easyapache 3
If your server is still using Easyapache 3. You can still use the old ntPHPselector plugin and it is still available.
Generate CSR and Private Key in Plesk
Certificate Signing Request ( CSR ) is a message sent from an applicant to a Certificate Authority in order to apply for a digital identity certificate.
Before creating a CSR, the applicant first generates a key pair, keeping the private key secret. The CSR contains information identifying the applicant (such as a distinguished name in the case of an X.509 certificate) which must be signed using the applicant’s private key. The CSR also contains the public key chosen by the applicant. The CSR may be accompanied by other credentials or proofs of identity required by the certificate authority, and the certificate authority may contact the applicant for further information. Continue reading
Repair crashed MySQL databases on LINUX servers
How to repair MySQL databases and tables
This article explian about how to repair MySQL database and table. As the mysql is updated time by time. Mysql deals with some tools that we can use it for repairing the databases and tables.
It is common that our database get corrupted due to many reason like it does not get restored properly or server get rebooted while updating database etc. We can repair the table or the corresponding databases through various steps by mysqlcheck command.
First of all before doing mysqlcheck we need to take the current mysql backup so that if any issues occurs we can able to revert it to the stable condition. The specific thing we should consider is that the mysqlcheck commands works on the database engine InnoDB.
Change the directory to mysql as follows,
cd /var/lib/mysql
InnoDB Engines
To use the mysqlcheck for InnoDB engines we have to follow the below steps
For checking all the database,
mysqlcheck -c -u root -p --all-databases
To check a specific DATABASE
mysqlcheck -c "DATABASE name" -u root -p
Checks all the tables under the mentioned database name
#mysqlcheck -c "DATABASE name" "TABLE name" -u root -p
Checks the mentioned tables under the DATABASE name
However if a mysql table passes the check it will display the “OK” for the table.
If the database table has displayed any error means we can repair the table by the following command,
mysqlcheck -r "DATABASE name" "Table name" -u root -p
-Repair and optimization of tables for all databases
There’s a simple command to automatically check, repair and optimize all tables in all databases when running a MySQL server on Linux/Unix/BSD.
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
MyISAM Engines
To use the mysqlcheck for MyISAM engines we have to follow the below steps
If we are using MyISAM storage engine for mysql,we can use the myisamchk commands to repair the table.
The myisamchk command only works under the database or the tables using MyISAM engines.It will not be working under Innodb engine.
The mysqlcheck program enables us to check and repair databases while MySQL is running this is useful when we want to work on MySQL without stopping.
Steps for checking all the Mysql tables
myisamchk table name.
To check all the tables under the database,
myisamchk * .MYI
How to repair a table from myisamchk command,
myisamchk --recover "table name"
After the repair please check for the mysql repair and confirm regarding the fix
The above mentioned commands will help you to troubleshoot the mysql database and table repair
Configure SSH Key based authentication from Linux and Windows system
Secure Shell (SSH)
Secure Shell (SSH) is a cryptographic network protocol for operating network services securely over an unsecured network. When working with a Linux server, chances are, you will spend most of your time in a terminal session connected to your server through SSH. There are different ways to login into the server using ssh and here I am discussing about the ssh key based authentication. Continue reading
Install and Configure Mod-Pagespeed on Linux servers
Mod-Pagespeed is an Apache/Nginx (web-server) module to speed up your website by applying certain filters that automatically optimize files to reducing number of times the browser has to make to grab web files, to reduce the size of those files and to optimize the length those files are cached. This article we will show you how to install and configure Google‘s mod-pagespeed module for Apache and Nginx web servers in RHEL/CentOS/Fedora and Debian/Ubuntu systems. Continue reading
How to install Ntopng (Network Monitoring Tool)
Ntop is a network traffic tools that shows real time network usage on your server. You can use a web browser to manage and navigate through ntop traffic information to better understand network status. Continue reading
How to change PHP handler from Server Backend
PHP handler means the way apache software on the server serves PHP scripts. On cPanel/WHM Servers there are four PHP handlers : SuPHP, DSO, CGI, FastCGI. suPHP is the default handler on cPanel/WHM Servers. You might be familiar with switching the PHP handler from Web Host Manager(WHM) but most of us are not sure how to do the same from server backend. This article will enlighten how to switch PHP handler on a cPanel/WHM Server.
Monitoring tool, Munin Installation on Centos7
Munin is a networked opensource resource monitoring tool that can be used to monitor servers and their services. It displays information gathered from the system as graphs through a web based interface. Here I am referring the steps for munin installation. Continue reading
How to harden wordpress
[huge_it_share]Almost 75% of websites and blogs are built in wordpress which is the mostly used CMS(Content Management System) . But unfortunately websites that use wordpress are mostly prone to attacks and vulnerabilities .So lets see how we can harden wordpress to resist the attacks .
As we know wordpress is a free tool .So anyone can try installing it .The same thing is the reason for most of the wordpress attack since anyone can install it everyone know the basic settings that we are going to use in our wordpress including the hackers .This is one of the main reasons hackers get into the because they know the default settings we are going to use .So one main thing we should do is change everything as possible from default settings in wordpress .Here I will be pointing some of the main things you can do to protect your wordpress sites . Continue reading