====== Environment ======
Debian (Etch/Lenny), ispCP, MySQL, Apache 2.x, Mailserver

====== Info ======
Current Version: 0.3.1 Stable with API \\
[[http://roundcube.net/]] \\
For any Help --> http://www.isp-control.net/forum/thread-7816.html

====== Installation ======
===== Preparation =====
<code>
# cd /usr/local/src
# mkdir roundcube
# cd roundcube
</code>

===== Download =====
<code># wget http://heanet.dl.sourceforge.net/project/roundcubemail/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz</code>

===== Decompress =====
<code># tar xvfz roundcubemail-0.3.1.tar.gz</code>

===== Prepare the ispCP directory  =====
<code># mkdir /var/www/ispcp/gui/tools/roundcube</code>

===== Copy Sourcecode =====
<code># cp -r roundcubemail-0.3.1/* /var/www/ispcp/gui/tools/roundcube</code>

===== Set correct user and groups =====
<code>
# chown -R vu2000:www-data /var/www/ispcp/gui/tools/roundcube
# cd /var/www/ispcp/gui/tools/roundcube
# chmod 755 temp logs
</code>

===== Create Database =====
<code># mysql -u root -p</code>

Your MySQL Root password

//replace yourpassword with your//

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

===== SQL File import =====
<code># mysql -u roundcube -p roundcubemail < SQL/mysql.initial.sql</code>

adjust your Roundcube Database Password accordingly

===== Configure Roundcube  =====

<code>
# cd /var/www/ispcp/gui/tools/roundcube/config
# cp db.inc.php.dist db.inc.php
# cp main.inc.php.dist main.inc.php</code>

<code># pico db.inc.php</code>

and edit the following lines

<code>$rcmail_config['db_dsnw'] = 'mysql://roundcube:YourPASSWORD@localhost/roundcubemail';</code>

===== Adjust default settings =====

<code># pico main.inc.php</code>

<code>
line 44: $rcmail_config['message_cache_lifetime'] = '30m';
line 55: $rcmail_config['default_host'] = 'localhost';
line 127: $rcmail_config['session_lifetime'] = 30;
line 180: $rcmail_config['create_default_folders'] = TRUE;</code>

====== Adjust Apache ======

<code># pico /etc/apache2/sites-available/00_master.conf</code>

and add the following entry:

<code>Alias /cube /var/www/ispcp/gui/tools/roundcube/</code>
 (if you like you can also simply replace Webmail, ich prefer the additional alternative)


===== Create subdomain for Roundcube =====

<code># pico /etc/apache2/sites-available/06-roundcube</code>

insert the following content:

<code><VirtualHost XXX.XXX.XXX.XXX:80>
    ServerAdmin     webmaster@yourdomain.tld
    DocumentRoot    /var/www/ispcp/gui/tools/roundcube

    ServerName      cube.yourdomain.tld
    ServerAlias     cube.*

    ErrorLog        /var/log/apache2/users/cube-error.log
    TransferLog     /var/log/apache2/users/cube-access.log
    CustomLog       /var/log/apache2/cube-traf.log traff
    CustomLog       /var/log/apache2/cube-combined.log combined

    <IfModule suexec_module>
           SuexecUserGroup vu2000 vu2000
    </IfModule>

    <Directory /var/www/ispcp/gui/tools/roundcube>
        Options -Indexes Includes FollowSymLinks MultiViews
        AllowOverride None
        Order allow,deny
        Allow from all
    </Directory>

    <IfModule mod_fcgid.c>
        <Directory /var/www/ispcp/gui/tools/roundcube>
            FCGIWrapper /var/www/fcgi/master/php5-fcgi-starter .php
            Options +ExecCGI
        </Directory>
        <Directory "/var/www/fcgi/master">
            AllowOverride None
            Options +ExecCGI MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    <IfModule mod_fastcgi.c>
        ScriptAlias /php5/ /var/www/fcgi/master/
        <Directory "/var/www/fcgi/master">
            AllowOverride None
            Options +ExecCGI MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>

    <IfModule mod_php5.c>
        <Directory /var/www/ispcp/gui/tools/roundcube>
            php_admin_value open_basedir "/var/www/ispcp/gui/tools/roundcube/:/etc/ispcp/:/var/run/ispcp.lock:/proc/:/bin/df:/bin/mount:/var/log/rkhunter.log:/var/log/chkrootkit.log:/usr/share/php/"
            php_admin_value session.save_path "/var/www/ispcp/gui/phptmp/"
            php_admin_value upload_tmp_dir "/var/www/ispcp/gui/phptmp/"
        </Directory>
    </IfModule>


</VirtualHost></code>

The data for <VirtualHost xxx.xxx.xxx.xxx:80, ServerAdmin und ServerName need to be adjusted with regard to your own conditions.

===== Enable the Site =====

<code># a2ensite 06-roundcube</code>

===== Restart Apache  =====

<code># /etc/init.d/apache2 force-reload</code>

====== Password Changer / Optional Plugin ======
Since Roundcube 0.3 has an API we can start to use Plugins. \\
There is a "ispCP Password-Changer Plugin" available (thanks to TheCry) \\
So is the customer able to change his password in Roundcube directly.

===== Download the Plugin =====
<code>
# cd /var/www/ispcp/gui/tools/roundcube/plugins
# wget http://www.deluxe-styles.de/ispcp/ispcp_pw_changer.tar.gz
# tar -xvzf ispcp_pw_changer.tar.gz
# chown -R vu2000:www-data ispcp_pw_changer
# cd /var/www/ispcp/gui/tools/roundcube/plugins/ispcp_pw_changer
</code>
===== Configure the Plugin =====
Now we need do config the Plugin
<code>
# mv config.inc.php.dist config.inc.php
# vi config.inc.php
</code>
Please set now your MySQL Login in the config, and Copy the two Key "ispcp_db_pass_key" and "ispcp_db_pass_iv" from "/var/www/ispcp/gui/include/ispcp-db-keys.php" into the fields.

Now we only need to enable the Plugin in the main.inc.php
<code>
# vi /var/www/ispcp/gui/tools/roundcube/config
</code>
And modify it like this:
<code>
$rcmail_config['plugins'] = array('ispcp_pw_changer');
</code>

====== Sieve-Plugin for Serverside-Filtering ======

Needs Dovecot with pysieved \\
- http://www.isp-control.net/documentation/howto/mail/replace_courier_with_dovecot \\
- http://www.isp-control.net/documentation/howto/mail/install_avelsieve_for_webmail

===== Configure  =====
Since Roundcube 0.3 the Managsieve Plugin is included per default, you only need to enable it.
<code>
# vi /var/www/ispcp/gui/tools/roundcube/config/main.inc.php
</code>
And add the Plugin in to the Plugin array
<code>
// List of active plugins (in plugins/ directory)
$rcmail_config['plugins'] = array('ispcp_pw_changer', 'managesieve');
</code>

Thats it!