= 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[[BR]]
{{{
$rcmail_config['default_host'] = 'ssl://localhost';
$rcmail_config['default_port'] = 993;
}}}
in /var/www/<web>/web/roundcube/config/db.inc.php change[[BR]]
{{{
$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[[BR]]

{{{
# 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[[BR]]
{{{
$rcmail_config['default_host'] = ''; to $rcmail_config['default_host'] = 'ssl://localhost:993';
}}}
in /var/www/web1/web/roundcube/config/db.inc.php change[[BR]]
{{{
$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.
}}}