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 : /scripts/restartsrv mysql voila this worked…… earlier I was trying to change sql_mode under /etc/my.cnf however found MySQL is using different location /usr/my.cnf
Read MoreEximstats 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 rows in set (0.00 sec) mysql> delete from defers; Query OK, 0 rows affected (0.52 sec) mysql> delete from failures; Query OK, 0 rows affected […]
Read MoreHow can I reserve an ip via WHM so that it will not be used to setup accounts?
Click on the “Show/Edit Reserved IPs” link under “IP Functions”. Check the box of the ip you want to reserve and add a short comment to the Reason section. This ip will no longer be used to setup accounts via WHM/Cpanel.
Read MoreHow do I upgrade Apache on my Cpanel box?
There are two ways to update your Apache version on cpanel. The first is from within WHM. Underneath the “Software” section in the menubar is “Apache Update.” Click this link and then follow the on screen directions. The second option is from the command line. Run “/scripts/easyapache”, which will provide an update interface including a few more options than WHM. It is highly recommended that you create a backup of your Apache configuration before preforming an update to a newer version.
Read MoreRunning exim on a different port – cPanel
Log into WHM and click on “Service Manager” under the Service Configuration grouping. Put a checkmark next to “exim on another port” (the default is port 26) then click “Save”.
Read MoreSecuring CPanel
Running a WHM like Cpanel can sure make hosting easy, but unfortunately running a WHM often makes your server much less secure than it was before! We do not guaranty that the following steps will make your server hack proof, but it will greatly reduce your chances of compromise. Also note that Layered Technologies does not manage your server and if you do not feel comfortable making system level changes to your server we recommend you open a level2 support […]
Read MorecPanel : UPCP error : Undefined subroutine &Cpanel::Update::automatic_updates_enabled called at /scripts/upcp line 273.
I have seen recent cPanel upgrade throwing errors are below : root@server [~]# /scripts/upcp /scripts/upcp syntax OK Running Futex Check/Fix……Done Undefined subroutine &Cpanel::Update::automatic_updates_enabled called at /scripts/upcp line 273. This can be fixed using below : wget -O /root/updatenow.static http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/updatenow.static && perl /root/updatenow.static –manual Upgrade the cPanel : /scripts/upcp –force This should fix the issue 🙂
Read MoreExim Remote Memory Corruption Vulnerability Notification (CVE-2010-4344)
Summary A memory corruption vulnerability exists in Exim versions 4.69 and older (CVE-2010-4344). Exim is the mail transfer agent used by cPanel & WHM. Security Rating This update has been rated as Important by the cPanel Security team. Description A memory corruption vulnerability has been discovered in Exim. This vulnerability may lead to arbitrary code execution with the privileges of the user executing the Exim daemon. cPanel previously released RPMs that mitigated the severity of the vulnerability on December 9, […]
Read MoreCPU/MySQL Usage is blank in WHM
“CPU/Memory/MySQL Usage” page blank This is a common error across all cPanel releases. The most likely cause of this issue is related to the utility that actually generates the statistics. When cPanel is installed, several entries are added into crontab for the root user. The following is a list of the default crontab entries from a freshly installed cPanel server: root@testbox [/etc/cron.hourly]# crontab -l | grep dcpumon */5 * * * * /usr/local/cpanel/bin/dcpumon >/dev/null 2>&1 root@testbox [/etc/cron.hourly]# The dcpumon is […]
Read More