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

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

Useful MySQL Commands

These command assume you are running a cPanel MySQL installation and logged into the server as a root user where you can do a mysql -u root without having to specify a password. Import a database: mysql -u root db_name < file.sql Dump a Database (with special characters): mysqldump -Q –add-drop-table db_name > file.sql Dump… Continue reading Useful MySQL Commands