Setup Roundcube

webs with roundcube:

web1
web15
web16
web2
web25
web30
web31
web37
web38
web44
web8

NEW VERSION (0.9.5) - OLD VERSION (0.3.1) see below

# mysql -uroot -p

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

mysql -uroot -p roundcubemail_<web> < /var/www/<web>/web/roundcube/SQL/mysql.initial.sql

in /var/www/<web>/web/roundcube/config/main.inc.php change

$rcmail_config['default_host'] = 'ssl://localhost';
$rcmail_config['default_port'] = 993;

in /var/www/<web>/web/roundcube/config/db.inc.php change

$rcmail_config['db_dsnw'] = 'mysql://roundcube:<password>@localhost/roundcubemail_<web>';

see ​http://trac.roundcube.net/wiki/Howto_Install

OLD (0.3.1) START CLIENT INSTALLTION HERE

follow the information provided by the ebuild

# mysql -uroot -p

> create database roundcubemail_web1;
> GRANT ALL PRIVILEGES ON roundcubemail_web''<YOUR WEBID>''.* TO roundcube@localhost IDENTIFIED BY ' ''<password>'' ';

# mysql -uroot -p roundcubemail_web''<YOUR WEBID>'' < /var/www/web1/web/roundcube/SQL/mysql.initial.sql

!!! change /etc/vhosts/webapp-config (see above) before the next command !!!

!!! Version changes (last bit of the following command: 0.3.1) please check for the actual version in (/usr/share/webapps/roundcube) !!'''

# webapp-config -I -h www.thinkthinkdo.com -d roundcube roundcube 0.3.1

If you want to upgrade to the latest version you can do (Check for the latest vereion is required before !):

# webapp-config -U -h www.thinkthinkdo.com -d roundcube roundcube 0.3.1

in /var/www/web1/web/roundcube/config/main.inc.php change

$rcmail_config['default_host'] = ''; to $rcmail_config['default_host'] = 'ssl://localhost:993';

in /var/www/web1/web/roundcube/config/db.inc.php change

$rcmail_config['db_dsnw'] = 'mysql://roundcube:<password>@localhost/roundcubemail_web1';

update to 1.0.4

 * When upgrading from <= 0.9, note that the old configuration files
 * named main.inc.php and db.inc.php are deprecated and should be
 * replaced with one single config.inc.php file.
 * Run the ./bin/update.sh script to convert those
 * or manually merge the files.
 * The new config.inc.php should only contain options that
 * differ from the ones listed in defaults.inc.php.