Latest blog entry

How to add Domainkeys for a domain on a cPanel server?

November 29, 2010    |   Posted by admin   |    Category: cPanel Management

“DomainKeys” is an anti-spam software application that uses a public key, cryptography to authenticate the sender’s domain. cPanel offers a installer script “domain_keys_installer” using which the DomainKeys can be created and added automatically for a domain.

By default the DomainKeys is not added when the account is created on the server, it has to be added manually. SSH to your server and execute:

/usr/local/cpanel/bin/domain_keys_installer <username>

where, <username> is the username of the domain.

The DomainKey is automatically added in the DNS zone file of the domain located at /var/named/domainname.db file. To add DomainKeys for the existing domains, execute the following command as it is:

for i in `cat /etc/trueuserdomains | awk '{print $2}'`
do
/usr/local/cpanel/bin/domain_keys_installer $i;
done;

NOTE: If you are using a 3rd party name servers for your domain, you will have to add the DomainKeys in the DNS zone of your domain created on their servers.

How to defragment or optimize a database in Mysql?

November 23, 2010    |   Posted by admin   |    Category: Mysql & PostGres SQL

In case you remove a lot of data from the tables OR change the database structure, a de-fragmentation/optimizing of the database is necessary to avoid performance loss, especially while running queries. To avoid performance loss, optimize the database.

SSH to your server and execute:

mysqlcheck -o <databasename>

where, -o stands for optimize which is similar to defragmentation. You should look to defragment the tables regularly when using VARCHAR fields since these columns get fragmented too often.

Plesk: Unable to create PHostingManager object:Unable to set current ip address

November 18, 2010    |   Posted by admin   |    Category: Plesk Management

Sometimes an error message “Unable to create PHostingManager object:Unable to set current ip address” appears in Plesk while managing a domain from Plesk -> Domains section. The complete error is as follows:

"Unable to create PHostingManager object:
Unable to set current ip address:
IP address is missing"

This problem appears when an IP assigned to a domain is not assigned to the ‘Owner’ of the domain. To fix the issue, login to Plesk and assign the IP to the owner:

Plesk --> 'Settings' --> "IP Addresses" -->  click the number 
 under the 'Users' coloumn in front of the IP address -->
 Assign the IP to the owner.

This will update the ‘psa’ database and allow the user to manage the domain from Plesk.