Install Roundcube

#
# INSTALL
#
# install from repository
apt-get install -y roundcube
 
OR
 
http://www.panticz.de/install_webserver
 
# download
URL=http://freefr.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.3-beta.tar.gz
wget $URL -P /tmp
 
# install
cd /var/www
tar xzf /tmp/roundcubemail-*.tar.gz
 
mv roundcubemail*/ roundcubemail
chmod 777 /var/www/roundcubemail/temp/ /var/www/roundcubemail/logs/
 
 
#
# DATABASE
#
# create
echo "CREATE DATABASE roundcubemail; GRANT all ON roundcubemail.* TO 'roundcube'@'localhost' IDENTIFIED BY 'pass';" | mysql -u root -p
 
 
#
# CONFIGURE
#
cp /var/www/roundcubemail/config/main.inc.php.dist /var/www/roundcubemail/config/main.inc.php 
sed -i "s|default_host'] = ''|default_host'] = 'imap'|g" /var/www/roundcubemail/config/main.inc.php
sed -i "s|smtp_server'] = ''|smtp_server'] = 'smtp'|g" /var/www/roundcubemail/config/main.inc.php
sed -i "s|smtp_pass'] = ''|smtp_pass'] = '%p'|g" /var/www/roundcubemail/config/main.inc.php
sed -i "s|smtp_user'] = ''|smtp_user'] = '%u'|g" /var/www/roundcubemail/config/main.inc.php
sed -i "s|language'] = null|language'] = 'de_DE'|g" /var/www/roundcubemail/config/main.inc.php
sed -i "s|preview_pane'] = FALSE|preview_pane'] = TRUE|g" /var/www/roundcubemail/config/main.inc.php
 
# init database
http://YOUR_IP/roundcubemail/installer/index.php?_step=3
initialize database
 
# login
http://YOUR_IP/roundcubemail/
 
# create users and identities
http://YOUR_IP/roundcubemail/?_task=settings&_action=identities
select * from roundcubemail.identities
select * from roundcubemail.users
 
 
# remove installer dir
tar -cjf /var/www/roundcubemail/installer.tar.bz2 /var/www/roundcubemail/installer/
rm -r /var/www/roundcubemail/installer
 
 
# Links
# http://www.howtoforge.com/roundcube_webmail_ispconfig
 
 
#
# OLD
#
sed -i 's|magic_quotes_gpc = On|magic_quotes_gpc = Off|g' /etc/php5/apache2/php.ini