Downgrading MySQL to 4.x – cPanel

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

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

Webmail Authentication Fails – cPanel

You know you’re using the right password, so why can’t you log into Webmail? One common issue users see on courier-IMAP systems when trying to log into Horde is: Notice: (null)(): Retrying LOGIN authentication after AUTHENTICATE LOGIN failed (errflg=1) in Unknown on line 0 Notice: (null)(): Retrying LOGIN authentication after AUTHENTICATE LOGIN failed (errflg=1) in… Continue reading Webmail Authentication Fails – cPanel