This is a little how-to to configure roundcube as a "second" webmail for users, just in case anyone prefer it. As always at your own risk...

1. Check the roundcube' screenshots :P

http://www.roundcube.net/?p=screens

It's a very nice webmail based in AJAX... and also more cpu&memory eater... :) Remember that it's a RC1.

2. Download Roundcube

Get the latest versions of RoundCube put it in /var/www/ispcp/gui/tools/ and change the name to webmail2 (or a name that you want... also if you prefer to put the actual webmail (squirrelmai) to webmail-bak and put roundcube to webmail so this will be the main webmail).

cd /var/www/ispcp/gui/tools/
wget http://surfnet.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1-rc1.1.tar.gz
tar xvfz roundcubemail-0.1-rc1.1.tar.gz
mv roundcubemail-0.1-rc1.1 webmail2
chown vu2000:www-data webmail2 -R
cd webmail2
chmod 755 temp logs

Note: always check if there is a new Version!!! This is the latest at 31/aug/07

3. Configure database

mysql -u root -p
<put your root password to create a new user>

> CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost IDENTIFIED BY 'YOUR_PASSWORD_HERE';
> quit

Then import the sql-file:

mysql -u roundcube -p roundcubemail < SQL/mysql5.initial.sql
<put your roundcube password just created>

4. Configure

You have to edit the config files to update the db info

cd /var/www/ispcp/gui/tools/webmail2/config
cp db.inc.php.dist db.inc.php
cp main.inc.php.dist main.inc.php

Then change the db password in db.inc.php

line 21: $rcmail_config['db_dsnw'] = 'mysql://roundcube:YOUR_PASSWORD_HERE@localhost/roundcubemail';

and also change these recommended settings in main.inc.php:

line 27: $rcmail_config['message_cache_lifetime'] = '30m';
line 38: $rcmail_config['default_host'] = 'localhost';
line 97: $rcmail_config['session_lifetime'] = 30;
line 112: $rcmail_config['locale_string'] = 'en'; # or the locale that you want by default (es, de, ...)

Note that you can disable the cache, or enable it with other parameters.

5. Test it...

http://admin.YOUR_DOMAIN.com/tools/webmail2/

6. To Do

* check if there are any security problem
* check if languages are OK
* check if there are some interesting plugins
* convert old change password hack to lastest version

v1.0 - 31/08/07 - GaRCieLD