If you’ve upgraded MySQL via WebHost manager, the downgrade process is slightly more complex than the upgrade. This tutorial mainly covers a downgrade from 4.1 to 4.0, but also applies to downgrading from 5.x to 4.x. *Back up all databases before proceeding, as all existing databases will be deleted! 1. Uninstall existing MySQL packages: rpm… Continue reading Downgrading MySQL to 4.x – cPanel
Changing the SSH Port
Sometimes you don’t want SSH running on standard port 22. Here are the steps to change it: It’s VERY important that you leave port 22 open while you are testing the new port, otherwise you may lock yourself out of the server! SSH into the server normally… cp /etc/ssh/sshd_config /etc/ssh/sshd_config.root In the /etc/ssh/sshd_config.root file that… Continue reading Changing the SSH Port
Closing Open Nameservers – DNS recursion
Open nameservers allow anyone in the world to perform queries on them, which can often lead to DOS attacks and slower performance. Some system administrators prefer to have their nameservers restricted to only trust parties. To do this kind of setup, you will need to configure your named configuration: On command line: pico /etc/named.conf Look… Continue reading Closing Open Nameservers – DNS recursion
Disabling SMTP Tweak – cPanel
The SMTP tweak will prevent users from bypassing the mail server to send mail (this is a common practice used by spammers). It will only allow the MTA (mail transport agent), mailman, and root to connect to remote SMTP servers. In order words, users will need to use ‘localhost’ as their SMTP server for local… Continue reading Disabling SMTP Tweak – cPanel
Upgrading phpMyAdmin – cPanel
The phpMyAdmin version is usually automatically upgraded when you run a cPanel update to a newer version. However, if you’re not quite ready to upgrade cPanel, you easily install a newer version of phpMyAdmin. Please be aware that future cPanel updates will overwrite your manual installation. You will need to go to the phpMyAdmin download… Continue reading Upgrading phpMyAdmin – cPanel
Installing PostgreSQL – cPanel
Run the install script from command line /scripts/installpostgres Now in WHM under SQL Services locate Postgres Config and do an Install Config. You can also set the root password from here, but this password should only be alphanumeric. PostgreSQL is installed now, but PHP is not compiled for it, so you’ll need to recompile PHP/Apache… Continue reading Installing PostgreSQL – cPanel
Incorrect Disk Usage and Unlimited Quotas – cPanel
This is a common bug on cPanel 11 systems, where you do an account listing through Webhost manager or try to set a user’s quota and everyone is showing as using 0mb out of unlimited. The most common fix for this is to run: /scripts/fixquotas This will re-initialize the quota system and usually fix the… Continue reading Incorrect Disk Usage and Unlimited Quotas – cPanel
Users Can’t Change Password – cPanel
When trying to change their password in cPanel, users get the following error: There was an error manipulating the password file. This generally means you entered your old password incorrectly. This has been seen on CentOS and Redhat servers running cPanel 11. The known fix is to run: chmod +s /usr/bin/passwd
cPanel Missing Language Key Error
When running a cPanel update on a branded server you may see a [[Missing language key]] error under the custom icons. Just run this script: /usr/local/cpanel/bin/cachelangfiles
Wrong Version Numbers in cPanel
It’s common that when moving a cPanel account between servers with differing software versions, the version numbers (specifically MySQL) on the side of cPanel still reflect those of the old server. This can be changed by editing the version files for the account that was moved: The files holding the version numbers are located in:… Continue reading Wrong Version Numbers in cPanel