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.

=================================================================
POST-UPGRADE INSTRUCTIONS
=================================================================

UPGRADING instructions
======================

Follow these instructions if upgrading from a previous version
of Roundcube Webmail. We recommend to carefully backup the existing
installation as well as the database before going through the following steps.

Using the update script
-----------------------
There is a shell script (for unix based systems) that does the job for you.
To use it, unpack the archive of the new Roundcube version to a temporary location
(don't replace the Roundcube installation you want to update)
and cd into that directory. From there, run the following command in a shell:

  ./bin/installto.sh <TARGET-FOLDER>

For <TARGET-FOLDER> you specify the path to the Roundcube installation 
which should be updated. The update script will then copy all new files to the 
target location and check and update the configuration and database schema.
After all is done, the temporary folder with the new Roundcube files can be 
removed again.

WARNING: See Post-Upgrade Activities section below.


Updating manually
-----------------
If you don't have shell access to the Roundcube installation or if not running 
it on a unix system, you need to do the following operations by hand:

1. Replace index.php and all files in
   - ./bin/
   - ./SQL/
   - ./program/
   - ./installer/
2. Replace the configuration defaults files:
   - config/defaults.inc.php
   - config/mimetypes.php
3. rsync the contents of the following folders from your installation
   directory into the target folder:
   ./skins/
   ./plugins/
4. Run ./bin/update.sh from the commandline OR
   open http://url-to-roundcube/installer/ in a browser and choose "3 Test config".
   To enable the latter one, you have to temporary set 'enable_installer'
   to true in your local config/config.inc.php file.
   WARNING: See SQLite database upgrade below.
5. Let the update script/installer check your configuration and
   update your config files and database schema as suggested by the updater.
6. Make sure 'enable_installer' is set to false again.
7. See Post-Upgrade Activities section.


Post-Upgrade Activities
-----------------------
1. Check .htaccess settings (some php settings could become required)
2. If you're using build-in addressbook, run indexing script /bin/indexcontacts.sh.
3. When upgrading from version older than 0.6-beta you should make sure
   your folder settings contain namespace prefix. For example Courier users
   should add INBOX. prefix to folder names in main configuration file.
4. Check system requirements in INSTALL file.

SQLite database upgrade
-----------------------
Versions older than 0.9 were supporting SQLite v2 only. Newer versions require
database in v3 format. The best what you can do is to convert database file
to the new format using command line tools:

sqlite OLD.DB .dump | sqlite3 NEW.DB

=================================================================