Viewing 1 to 10 of 11 items
Archive | August 16, 2014

How to clean Magento Database Logs to improve performance?

Magento is a pretty stable eCommerce system but the database is not that efficient as it should be.  A major performance boost can be achieved by cleaning the logs regularly. The outcome is that it helps in reducing latency of query execution and thus improves performance. Regular database cleansing can tidy up Magento database and  Full Article…

0

Setup SVN in cPanel

SVN or Apache Subversion is a software versioning and revision control system . Developers worldwide use SVN to maintain current and historical versions of files which change often such as  source code, web pages and documentation Follow the below mentioned steps to install SVN on your cPanel servers mkdir -p /usr/local/src/subverison cd /usr/local/src/subversion wget http://subversion.tigris.org/downloa…-1.5.0.tar.bz2 tar xfj  Full Article…

0

How to fix the awstats error “Error: LogFile parameter is not defined in config/domain file” ?

If you come across the below error on accessing Awstats from cPanel Error: LogFile parameter is not defined in config / domain file (‘/home/{user}/tmp/awstats/awstats.{domain.com}.conf’ file, web server or permissions) may be wrong. See AWStats documentation in ‘docs’ directory for informations on how to setup awstats. Usually the above error means one of the following 1.  Full Article…

0

How to whitelist/blacklist an email address in Spamexperts?

Here is how to whitelist as well as blacklist an email address through the SpamExperts control panel. This article asusmes you are already logged into the SpamExperts control panel, through cPanel. Step 1: Sender Whitelist Click on the “Sender Whitelist” option in the Spam Experts panel under the “Whitelist/Blacklist” section. Click on the “Add Sender”  Full Article…

0

How to add dedicated IP to parked/addon domain in cPanel?

Follow the below steps to assign a dedicated IP to either a parked/addon domain in case of cpanel servers. Edit DNS zone of addon to point it to the new IP and also change the subdomain IP to that same IP. This can be done from WHM. Edit the file /var/cpanel/userdata/username/subdomain.domain.com file, change the IP  Full Article…

0

How to install missing cdp plugin in cPanel

If a client has CDP backups but doesn’t have the “R1soft restore backups” icon in their cPanel, the cPanel plugin is likely not installed. Installing this is a straightforward process, you simply follow the instructions provided at http://wiki.r1soft.com/display/CDP3/Setting+up+cPanel+Plugin When the CDP agent is installed the plugin is usually downloaded too, so check /root/r1soft-cpanel-plugin-1.1 as this  Full Article…

0

Steps to restore an innodb database

Below are the steps to restore mysql database with innodb tables , without contacting r1soft. Set up a temporary mysql “sandbox” instance  using the innodb files and the fil ebased backups of  the database and create a mysql dump of the database. 1. restore these files to a temporary directory  /dbrestore  /var/lib/mysql/ibdata1  /var/lib/mysql/ib_logfile0  /var/lib/mysql/ib_logfile1  (restore to “alternate  Full Article…

0

Optimize database using phpMyAdmin

Over a time as your website add contents to it’s database, the files/tables will become fragmented resulting in slower performance. Optimizing the database will essentially defragment the files, and is something you should perform regularily if you do have a busy website. Log into cPanel, and click on the PHPMyAdmin icon in the database section,  Full Article…

0

Change document root in cPanel with root access

Steps to change the Document Root (with server root access) In order to edit the following files, you may need root access or sudo user access to server. ssh root@your-server.com Edit the following file: /var/cpanel/userdata/USER/DOMAIN Important! If you have an SSL certificate on the account, you may need to edit the following file as well.  Full Article…

0