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.
Comments Off on How to add Domainkeys for a domain on a cPanel server?
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.
Comments Off on How to defragment or optimize a database in Mysql?
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.
Comments Off on Plesk: Unable to create PHostingManager object:Unable to set current ip address