Web Hosting News and Articles

To install roundcube on a cPanel or Linux Server, you should know your MySQL root password. Replace your MySQL root password with Database Password.

If you have already used RoundCube installation before then make sure you have removed traces of it.

Follow the steps given below and remove any traces of it with,

cd /usr/local/cpanel/base
rm -rf roundcube*
mysql -p -e ‘drop database roundcube’;
chattr -i /usr/local/cpanel/base/frontend/x/webmaillogin.html
chattr -i /usr/local/cpanel/base/webmaillogin.cgi
/scripts/upcp

You will have to specify your root password when prompted.

Let us begin with installation

A) Download roundcube first from the given sourse and apply the proper permission to directories

cd /usr/local/cpanel/base
wget -O roundcube.tar.gz http://heanet.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1-rc1.tar.gz
tar -zxvf roundcube.tar.gz
rm -rf roundcube.tar.gz
mv -f roundcubemail-0.1-rc1 roundcube
cd roundcube
chmod -R 777 temp
chmod -R 777 logs

B) Create the database and install the intial sql file. The following commands will do this for you.
replace the mysql password in place of DATABASEPASSWORD

mysql -e “CREATE DATABASE roundcube;” -pDATABASEPASSWORD
mysql -e “use roundcube; source SQL/mysql.initial.sql;” -pDATABASEPASSWORD

C)Set the configuration as given below

cd config
mv db.inc.php.dist db.inc.php
mv main.inc.php.dist main.inc.php

Now open db.inc.php

nano db.inc.php

Find

$rcmail_config[’db_dsnw’] = ‘mysql://roundcube:pass@localhost/roundcubemail’;

Replace with

$rcmail_config[’db_dsnw’] = ‘mysql://root:DATABASEPASSWORD@localhost/roundcube’;

Now Open main.inc.php

nano main.inc.php

Find

$rcmail_config[’default_host’] = ‘’;

Replace with

$rcmail_config[’default_host’] = ‘localhost’;

D) Configure cPanel to show roundcube in the theme. Please note this is for the X theme(default) only!! If you use another theme please skip the next part and see below.

cd /usr/local/cpanel/base/roundcube/skins/default/images/
cp –reply=yes roundcube_logo.png /usr/local/cpanel/base/frontend/x/images/roundcube_logo.png
cp –reply=yes roundcube_logo.png /usr/local/cpanel/base/webmail/x/images/roundcube_logo.png
cd /usr/local/cpanel/base
wget http://www.hostgeekz.com/files/hostgeekz/HGpatch-roundcube-0.1-rc1
patch -p0

RoundCube——

***UPDATE***
Remember to chattr +i the files or add the patch to your /scripts/upcp.

chattr +i /usr/local/cpanel/base/frontend/x/webmaillogin.html
chattr +i /usr/local/cpanel/base/webmaillogin.cgi

That’s it! You may now access roundcube via http://domainname/webmail

By hostingcomments.com

Social Bookmark

Different ways to repair a corrupt MySQL table :=>

1] Check the permission and ownership of database i.e. it should be same below

drwx—— 2 mysql mysql cpanelusername_dbname.

2] If the permissions are correct but some error occurs then it seems that your database table may be corrupts then there are following way to repair the DB

a) Go to whm >>SQL Services >> Repair a Database >> select database name and click Repair Database.

b) Go to cpanel >> mysql section MySQL Account Maintenance >> search database then click on Repair.

3] You can get it repaired it through shell when mysqld server is running

i) login in mysql to that particular user by using following command

mysql>mysql –u databaseusername –p databasename

ii) select particular database

mysql> use databasename;

iii) Check whether database table is corrupted or not. If following command output shows null value then it should be corrupt otherwise it is fine

mysql>show table status like ‘table name’\G; Or
mysql>check table tablename ;

iv)If it is corrupts then use the following command to repair that particular database table.

mysql>repair table tablename;

4] Get it repaired through shell when mysqld server is not running

Repairing MyISAM mySQL Tables/Databases:

# cd /var/lib/mysql/DBNAME

# myisamchk tablename.MYI

Repairing ISAM mySQL Tables/Databases:

# cd /var/lib/mysql/DBNAME
isamchk tablename.MYI
where

-c –> check database is corrupted or not
-r –> recorver
-o –> optimise the database

Social Bookmark

Just comment the rule for :

RewriteRule .*\.(jpg|jpeg|gif|png|bmp)$ http://www.domain.com [R,NC] in your .htaccess.   Images will start working.

Social Bookmark

What is jailshell?

Jailshell is a very limited shell that allows clients to logon to your server via SSH. It limits them to their home directories, keeping the rest of your files on your server from being viewed.

How to enable jailshell from WHM?

You can enable jailshell as the default shell for new and modified accounts by going to Tweak Settings under Server Setup on the WHM main page. Scroll down to “System” and check the box next to ” Use jailshell as the default shell for all new accounts and modified accounts”.

Social Bookmark

The error message means what it says – the email is arriving from a machine that does not have a properly configured reverse DNS (PTR record) set up.

Social Bookmark

This problem happens because your version of Outlook Express is set up to use Secure Socket Layer (SSL), which the domain does not use.
To fix this problem, open Outlook Express, and click:
- Tools
- Accounts
- Then click on your mail account connection and click Properties
- Then click Advanced
- On this screen remove the checks from the boxes This server requires a secure connection for both Outgoing mail (SMTP) and Incoming mail (POP3).

Social Bookmark

Check your Outlook Express settings, making sure that the POP3 and SMTP are set properly and that your full username and password are correct.If you are still having problems, it could be that your password has somehow become corrupted , just change it.

Social Bookmark

This error message is caused by the fact that you have set an anti virus program, to scan all emails automatically.
Changing the settings within Outlook Express will not solve the issue. You need to change the settings for AntiVirus.

Social Bookmark

Sending’ reported error (0×800CCC65) : ‘Your outgoing (SMTP) e-mail server has reported an internal error. If you continue to receive this message, contact your server administrator or Internet service provider (ISP). The server responded: 503 valid RCPT command must precede DATA’

Solution : In Outlook, select Tools > Options > Email Accounts > More settings > Outgoing server — check the box marked ‘My outgoing server

(SMTP) requires authentication.’

Social Bookmark

Check for :
# cat /etc/valiases/yourdomain.com
If it displays :
*: :fail: No Such User Here
Then edit as : # vi /etc/valiases/yourdomain.com
*: username

Social Bookmark