Install RoundCube Webmail Client

rcube-setup.sh

#!/bin/bash
# 
cd /tmp && wget http://dl.dropbox.com/u/3643528/siliwangi/rcubemail.tar.gz
tar xzvf rcubemail.tar.gz && cp -r /tmp/rcubemail /var/www/
rm -fr /tmp/rcubemail*

cat > /tmp/rcubemail.sql <<EOF
CREATE DATABASE rcubemail;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON rcubemail.* TO 'dbmailuser'@'localhost' IDENTIFIED BY '(*&^%$#@!)';
FLUSH PRIVILEGES;
EOF

mysql -u root -p < /tmp/rcubemail.sql
rm /tmp/rcubemail.sql

cat > /etc/apache2/conf.d/roundcube.conf <<EOF
Alias /webmail /var/www/rcubemail

<Directory /var/www/rcubemail>
  Options +FollowSymLinks
  AllowOverride All
  order allow,deny
  allow from all
  
  <IfModule mod_php5.c>
    AddType application/x-httpd-php .php
    php_flag magic_quotes_gpc Off
    php_flag track_vars On
    php_admin_flag allow_url_fopen Off
    php_value include_path .
    php_admin_value upload_tmp_dir /var/www/rcubemail/temp
    php_admin_value open_basedir /var/www/rcubemail
    php_flag register_globals off
  </IfModule>
</Directory>

<Directory /var/www/rcubemail/config>
    Options -FollowSymLinks
    AllowOverride None
    order deny,allow
    deny from all
    allow from 127.0.0.1
</Directory>

<Directory /var/www/rcubemail/temp>
        Options -FollowSymLinks
        AllowOverride None
        Order allow,deny
        Deny from all
</Directory>

<Directory /var/www/rcubemail/logs>
        Options -FollowSymLinks
        AllowOverride None
        Order allow,deny
        Deny from all
</Directory>
EOF

service apache2 restart

mysql -u root -p rcubemail < /var/www/rcubemail/plugins/calendar/SQL/mysql.sql
rm -fr /var/www/rcubemail/plugins/calendar/SQL/mysql.sql
rm -fr /var/www/rcubemail/installer /var/www/rcubemail/SQL