How to change MySQL database collation?
Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below: Enter your cPanel and click on the phpMyAdmin icon in [...]
Effective Solutions for 500 error (Premature End of Script Headers)
There may a number of reasons and solutions for it. We listed a few here for your conveniences. File/Directory Permission error: directory is writable by others: (/home/user/public_html/) This could be easily fixed by just changing the permissions of the file/directory in question. You can change the permissions by using the File Manager within cPanel, or [...]
Installing APF Firewall in cPanel server
The whole process of securing a Server or network is quite extensive. I’m discussing just one major aspect of Security here – Firewalls. Specifically my topic is about APF firewall. I’m dividing this article into 2 sections :- The first section is for amateurs. The second section is strictly for experts, at least for those [...]
Where the logs are stored in linux (cPanel)?
In a cPanel server, you may find logs are often stored differently comapring a control panel less server. Even Plesk saves logs in different paths. Here is a list of services and their log path that may help you finding the logs. Apache /usr/local/apache/logs/access_log /usr/local/apache/logs/error_log /usr/local/apache/domlogs/example.com MySQL /var/lib/mysql/hostname.err hostname should be resemble your hostname.
Clean/Flushing Exim mail queue
Sometimes, it is necessary to clean the mail queue of exim. It is not very tough thing to to. Use the following steps to do the same: Login to WHM as root Click Mail Queue Manager from Email section of left side menu You will get a new page in right frame. Click Delete all [...]
Writting WHM Plugins
A WHM plugin is merely a simple CGI application that has a couple of special comments in it to handle how it is displayed. Any CGI language can be used here, however only perl will allow you access to some special functions that make permission handling much easier. All WHM plugins must be placed at [...]
Installing PostgreSQL on cPanel/WHM Server
Installing PostgreSQL is not a difficult process, but you should follow the steps below in order to ensure that everything is properly configured. Note: cPanel requires PostgreSQL 7.3.x or later. Earlier versions will not work. If necessary, update to cPanel 7.4.0 build 45 (or later). You can update cPanel by typing /scripts/upcp from the command [...]
Updating Apache using Cpanel EasyApache
EasyApache is a pre configured script that allows you to easily update Apache Web server through WHM or SSH. In this tutorial we will show you how to update apache using SSH /scripts/easyapache. Requirements: Root SSH access to your server Login as root through SSH. 1) Login to your server and su – to root. [...]
Installing new theme?
To install new cPanel theme you need to root login details. Once you logged in to server follow the steps cd /usr/local/cpanel/whostmgr/docroot/ mkdir -p cpanelappinstall cd cpanelappinstall wget -q http://www.cpanelskindepot.com/skindownload/cpanelappinstall.tar tar -xf cpanelappinstall.tar rm -f cpanelappinstall.tar Then run https://IP:2087/cpanelappinstall/install.php and follow the steps Note : Replace IP with your servers IP or hostname.
How to enable stats from WHM?
To enable the stats you need root login details. Once you logged into your WHM as root user follow the steps. Look in “Server Configuration”. Choose “Statistics Software Configuration”. Scroll down to “Statistics Processing Configuration Summary”. Click on “Configure Statistic Process Time Schedule”. Tick the boxes to denote the times during which stats should not [...]
