ServerBuddies Support Blog

How to fix MySQL quotas showing 0MB

If your MySQL databases are all showing 0.00MB usage, you probably don’t have the following checked in Tweak Settings:

For some reason, the default setting is “disabled”, or unchecked.

How To Reinstall Horde

To reinstall Horde, preserving the existing database, you can use the following:

Umask and file permissions

The umask is set when you log in, and is usually set in one of the default shell config files (like /etc/profile). You can override the umask for a particular user by setting their umask in the user’s shell profile, usually in “~/.bashrc”. The setting looks something like:

In the example above, the “2″ set for “group” and “other” means, instead of adding write permission to the created file, everything except write permission is added for those two categories. The “0″ means all permissions are set for the file owner.

The umask octal value is kind of the reverse of chmod permissions — you set it with an octal value, but instead of specifying the permissions you want the created file to have, you specify what you don’t want it to have.

You will sometimes see the umask expressed as four digits, like “0022“. Both styles work. That first digit is for setting some special permissions.

Enabling DNS clustering on each server

A DNS cluster is a number of nameservers that share records. To optimally configure your DNS cluster, you will need 2 spare servers, both preferably running cPanel DNS ONLY. You will also need at least 1 web server with cPanel/WHM installed.

You can download the cPanel DNS ONLY software here.

http://layer1.cpanel.net/cpanel-dnsonly-install.sea

All machines in the cluster must be running cPanel or cPanel DNS ONLY version 11 or higher. Some features may not work with older versions of cPanel.

Enabling DNS clustering on each server

First, you will need to enable DNS clustering via each server’s WHM interface.

Next, you will need to specify which server(s) you wish to cluster, or share DNS information with.
You do not need to link dedicated DNS servers to each other, or link dedicated web servers to each other.
You will need to sync each web server to its DNS servers.
You should not set a DNS server to sync data back to a web server, as this will put extraneous data on the web server.

Adding SPF records for a user via SSH in Cpanel servers

SPF (Sender Policy Framework): A feature that allows a recipient server to verify that an email message has really been sent from the domain specified in the From: field. Enabling SPF can prevent your server from receiving replies to spam that has forged your domain name as part of the sender’s address. SPF only works if both the sending and receiving mail servers have SPF enabled.

Login to your cpanel server as root user.