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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 127.0.0.1 </Location>       just after the code that says “ServerSignature On”. Save, exit, then restart apache. You can access the stats page by going to http://1.2.3.4/httpd-status where 1.2.3.4 is your server’s IP. […]