Roundcube Email

The roundcube install is fairly simple and automatically integrates with Cpanel once installed. Just follow these steps.

First create a mysql user to keep track of user settings, connect to mysql and run this query.

GRANT USAGE ON *.* TO 'roundcube'@'localhost' IDENTIFIED BY '****************' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

Now you're ready to install the app itself.

cd /usr/local/cpanel/base
wget -O roundcube.tar.gz http://superb-east.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1.tar.gz

tar -zxvf roundcube.tar.gz
rm -rf roundcube.tar.gz
mv -f roundcubemail-0.1 roundcube
cd roundcube
chmod -R 777 temp
chmod -R 777 logs

mysql -e "CREATE DATABASE roundcube;"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON `roundcube`.* TO 'roundcube'@'localhost';"
mysql -e "use roundcube; source SQL/mysql.initial.sql;"

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

Now open db.inc.php

vi db.inc.php

Find

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

Replace with

$rcmail_config['db_dsnw'] = 'mysql://roundcube:DATABASEPASSWORD@localhost/roundcube';

Now Open main.inc.php

vi main.inc.php

Find

$rcmail_config['default_host'] = ;

Replace with

$rcmail_config['default_host'] = 'localhost';

I'm not sure if you need to run this part or not, it doesn't seem to break anything though.

wget http://www.hostgeekz.com/files/hostgeekz/cpanel-11-fix.sh
chmod 700 cpanel-11-fix.sh
./cpanel-11-fix.sh
rm -f cpanel-11-fix.sh