Disable MySQL strict mode!

We recently migrated WHMCS to latest CentOS 7 server with cPanel. The WHMCS ClientArea showed White screen when “Client logins were used”. We found that the server had MySQL strict mode enabled which was causing this problem. I disabled MySQL strict mode as below : Edited /usr/my.cnf and changed below value : sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER Restarted MySQL… Continue reading Disable MySQL strict mode!

cPanel : SSHD Rootkit

We have been seeing this SSHD rootkit from time to time with much improved versions 🙂 One could see number of SSH processes on the server with nothing under process details. There is a huge discussion thread at WHT www.webhostingtalk.com/showthread.php?t=1235797 The current one which I have seen today was with keyutils-libs legit version name. However… Continue reading cPanel : SSHD Rootkit

cPanel : /root/ Inode issue!

Today I had an issue on / with shortage of disk inodes on a cPanel dedicated server. In computing, an inode is a data structure on a traditional Unix-style file system such as UFS. An inode stores basic information about a regular file, directory, or other file system object. In layman’s term – Every time… Continue reading cPanel : /root/ Inode issue!

Categorized as cPanel

cPanel :: cPHulk error – Error while connecting to MySQL

WHM shows below error for cPHulk Brute Force Protection : ========= cPHulk Brute Force Protection Mysql is currently disabled. To enable mysql go to: Service Manager Once there check Enable and Monitor for mysql. Then at the bottom of the page click save. ========= Running below command should fix the issue : /usr/local/cpanel/bin/hulkdsetup Sample Output… Continue reading cPanel :: cPHulk error – Error while connecting to MySQL

Categorized as cPanel

Uninstall CloudLinux :: cPanel server

CloudLinux is a good tool however we had some issues with our test production server and had to remove it. Here are the steps to remove CloudLinux : CloudLinux Kb has below steps : https://helpdesk.cloudlinux.com/index.php?/Knowledgebase/Article/View/33/0/how-do-i-convert-back-to-centos yum remove liblve-devel cd /usr/local/src/ wget http://repo.cloudlinux.com/cloudlinux/sources/cln/centos2cl sh centos2cl -c After executing script from CloudLinux, you need to remove the… Continue reading Uninstall CloudLinux :: cPanel server

Eximstats too large

If the size of your eximstats database is too large, you can do the following steps to empty it. Login to mysql server from root. [root@srv1 ~]# mysql mysql> use eximstats; Database changed mysql> show tables; +———————+ | Tables_in_eximstats | +———————+ | defers | | failures | | sends | | smtp | +———————+ 4… Continue reading Eximstats too large

How to verify matching private key with a certificate

The private key contains a series of numbers. Two of those numbers form the “public key”, the others are part of your “private key”. The “public key” bits are also embedded in your Certificate (we get them from your CSR). To check that the public key in your cert matches the public portion of your… Continue reading How to verify matching private key with a certificate

WHMCS Security Advisory

A potential security issue has been discovered whereby it may be possible for a malicious user to inject a specially crafted combination of variables leading to unexpected results. The issue revolves around the Smarty templating system and template related processing. > Patch Download Link: http://www.whmcs.com/go/21/download Patch will work for all versions of WHMCS 4.x. Buy… Continue reading WHMCS Security Advisory

Categorized as cPanel Tagged

How to track which site is using the apache processes.

For apache 1.3, edit your /etc/httpd/conf/httpd.conf and add ExtendedStatus On <Location /httpd-status> SetHandler server-status Order deny,allow Deny from all Allow from </Location>       just after the code that says “ServerSignature On”. Save, exit, then restart apache. You can access the stats page by going to where is your server’s IP.… Continue reading How to track which site is using the apache processes.