Cpanel

change-timezone-for-MySQL-on-a-cPanel-server

How to change timezone for MySQL on a cPanel server

For many of the websites there will be different time elements used for displaying time. It will use the server time this, but in some cases we need to have different time for the website and it is not possible to change the server time. So in that case we can change the timezone for MySQL to keep the website updated with the required timezone. For that first you need to know the function that will display the timezone for MySQL, [...]

Read more...
How-to-check-mysql-processlist

How to check mysql processlist on a cPanel server

There are different ways for checking mysql processlist from a cPanel server. As you all know for most of the production server it is needed to check mysql process list for checking the currently running queries and for finding slow queries that slow down the website loading speed. You can check MySQL process list from command line in the following ways, Enter into mysql from command line using the command, mysql After that use the command, show processlist; For example: root@srv24x7 [~]# mysql Welcome to the MySQL [...]

Read more...
Issue-related-with-WORDPRESS

Issue related with WORDPRESS :: XMLRPC.PHP ATTACK!

WordPress is the most targeted CMS nowadays and needs to be updated regularly. Recently I have seen attacks on wordpress :: xmlrpc.php using POST requests and the attack is large enough to take down / freeze the server. The top or ps aufxw shows most of the xmlrpc.php requests as below : successroute4414 1.3 0.4 85512 35544 ? R 20:57 0:00 | \_ /usr/bin/php /home/successroute/public_html/wordpress/xmlrpc.php nobody 3876 0.0 0.1 25936 10852 ? S 20:52 0:00 \_ /usr/local/apache/bin/httpd -k start -DSSL successroute 4413 1.3 0.4 [...]

Read more...
logical-volume-management1

How to Increase the Size of the Logical Volume ?

Follow the steps below to increase the size of the logical volume and allocate additional space on one of your partitions. Once logged in, type df -h at the command prompt and hit ENTER. The partition and logical volume sizes will be listed including the used disk space. In the image below, the var logical volume is 4GB. Assume that ~9GB of web content will be uploaded to the /var folder. The disk space needs to be increased before there [...]

Read more...
CloudLinux-Management-on-cPanel-server

CloudLinux Management on cPanel server

Installation You can download latest CloudLinux ISO and use it to install CloudLinux on your server: Latest stable CloudLinux 6.4 ISO:   x86_64 version: Please search ISO on Google i386 version: Please search Latest ISO on Google If you want to convert your existing server to CloudLinux you need to get CloudLinux activation key from. Get <activation_key> either by getting trial subscription or by purchasing subscription. You can download CloudLinux Converting scripts here and convet your server through folllowing command wget http://repo.cloudlinux.com/cloudlinux/sources/cln/cldeploy sh cldeploy -k [...]

Read more...
Uninstall-cloudlinux-from-cpanel-server

Completely Uninstall cloudlinux from cpanel server

How to completely remove cloudlinux from cpanel server. You can always uninstall CloudLinux. In this case, we will ‘convert’ the system back to CentOS. Even if the original system was RHEL — we will still convert to ‘CentOS’ state. Following this will be done: 1.LVE related packages will be removed 2.CloudLinux repositories & yum plugin will be removed 3.CentOS repositories will be setup At the end, script will provide instructions on how to finish the conversion back to CentOS. That will require removal of CloudLinux [...]

Read more...
Configure-multiple-shared-IP’s-in-WHM

Configure multiple shared IP’s in WHM

It is not possible to add multiple shared IP’s from WHM but it is possible to do it from SSH. First of all we need to create a /var/cpanel/mainips/ directory if it is not present. mkdir /var/cpanel/mainips/ Then we have to create a file. vi /var/cpanel/mainips/root Add all IP’s into it. save the file and quit. 121.127.xxx.xx2 121.127.xxx.xx3 121.127.xxx.xx4 Now login to WHM and check the IP’s Home>>IP Functions>>Show/Edit Reserved IPs  

Read more...
Linux-server-services

Understanding Linux server services

Some common web related services running on a Linux server are, but not limited to, include: httpd (Apache), mysqld (MySQL), vsftpd (Very Secure FTP), named (BIND), iptables (packet filtering ruleset), sshd (Secure Shell), network (network related services) and various others. Usually these services are started at boot time. To check what services are installed on the server, you can use the chkconfig tool. For example: [root@server ~]# chkconfig –list sshd                  0:off    1:off    2:on    3:on    4:on    5:on    6:off webmin           [...]

Read more...
Brute-Force-Prevention-On-Linux-Server

Brute Force Prevention On Linux Server

How to install Fail2Ban Fail2Ban is a great utility to use to help prevent a server from being brute forced attacked on SSH. Fail2Ban works with Iptables to block a culprit IP for a certain amount of time. The actual setup and configuring can be done in under 10 minutes. Installation 1.To install fail2ban you will need to have root access (login with user and “su –“ to root). Type the following to begin the install process. yum –enablerepo=dag install fail2ban Yum will install [...]

Read more...
your-server-is-under-DDOS-Attack

How to find your server is under DDOS Attack

Here is a command line to run on your server if you think your server is under DDOS attack.  The commands given below prints out list of open connections on your server and sorts them by connection amount. RedHat: netstat -ntu | awk ‘{print $5}’ | cut -d: -f1 | sort | uniq -c | sort -n BSD: netstat -na |awk ‘{print $5}’ |cut -d “.” -f1,2,3,4 |sort |uniq -c |sort -n You can also check for connections by running the following command. netstat -plan [...]

Read more...