Adding RoundCube Webmail

There doesn’t seem to be a well maintained package for RoundCube, so this will be the first thing we will install by hand.  First lets create a directory in the apache area (if you are only going to have webmail you can drop this straight into /home/apache, or if you want to configure it as a seperate alias you can put it into /usr/share and update the apache conf – this way just means you can go to http://machineip/cube and be in with no extra config).

[root@tranquilpc apache]# cd /home/apache
[root@tranquilpc apache]# mkdir cube
[root@tranquilpc apache]# cd cube

Next lets download the latest RoundCube version and untar it:

[root@tranquilpc cube]# wget http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz/download
–2010-03-14 14:39:25– http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz/download
Resolving sourceforge.net… 216.34.181.60
Connecting to sourceforge.net|216.34.181.60|:80… connected.
HTTP request sent, awaiting response… 302 Found
Location: http://downloads.sourceforge.net/project/roundcubemail/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz?use_mirror=surfnet [following]
–2010-03-14 14:39:33– http://downloads.sourceforge.net/project/roundcubemail/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz?use_mirror=surfnet
Resolving downloads.sourceforge.net… 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80… connected.
HTTP request sent, awaiting response… 302 Found
Location: http://surfnet.dl.sourceforge.net/project/roundcubemail/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz [following]
–2010-03-14 14:39:37– http://surfnet.dl.sourceforge.net/project/roundcubemail/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz
Resolving surfnet.dl.sourceforge.net… 130.59.138.21, 2001:620:0:1b::21
Connecting to surfnet.dl.sourceforge.net|130.59.138.21|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 1917564 (1.8M) [application/x-gzip]
Saving to: `roundcubemail-0.3.1.tar.gz’

100%[====================================================================================================================================================>] 1,917,564 547K/s in 3.4s

2010-03-14 14:39:45 (547 KB/s) – `roundcubemail-0.3.1.tar.gz’ saved [1917564/1917564]

[root@tranquilpc cube]# tar xvf roundcubemail-0.3.1.tar.gz

Next lets remove the downloaded file, move the files into the cube directory, and change them to be owned by the webserver user:

root@tranquilpc cube]# rm roundcubemail-0.3.1.tar.gz
rm: remove regular file 'roundcubemail-0.3.1.tar.gz'? y

[root@tranquilpc cube]# cd roundcubemail-0.3.1/
[root@tranquilpc roundcubemail-0.3.1]# ls
bin CHANGELOG config index.php INSTALL installer LICENSE logs plugins program README robots.txt skins SQL temp UPGRADING
[root@tranquilpc roundcubemail-0.3.1]# cp -r * ..

[root@tranquilpc roundcubemail-0.3.1]# cd ..
[root@tranquilpc cube]# rm -rf roundcubemail-0.3.1/
[root@tranquilpc apache]# cd /home/apache
[root@tranquilpc apache]# chown -R apache:apache cube

Next we need to setup a database for RoundCube to use – we’ve already got mysql, so lets just login and create a new database:

[root@tranquilpc apache]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.35 MySQL Community Server (GPL) by Remi

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> CREATE DATABASE roundcubemail;
Query OK, 1 row affected (0.05 sec)

mysql> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost IDENTIFIED BY 'yourroundcubepasswordhere';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

The password to login is the root mysql password set when you installed mysql. The password you set for the roundcube user should be different.  The next step of the config is web based – so go to the installer directory.  This is http://192.168.1.107/cube/installer for me.  OK the first page and you should be looking at a page checking for dependancies.  Everything should be OK for us, except postresql, which we dont need as we have mysql.  Move on to the next page.

On this page enter the database details (the password should be the only thing that isn’t defaulted correctly).  Then enter localhost as the IMAP server, and your ISP’s SMTP server as the SMTP server and continue.  This will generate the 2 config files that RoundCube needs.  Copy and paste them into the right location (/home/apache/cube/config).  When that is done click continue.  On this page you can click the initialise database option to setup the database tables.  You can also test the sending of mail, and the login to the IMAP server.

Finally we need to delete the installer (it could let people see things like the database password if left installed):

[root@tranquilpc cube]# cd /home/apache/cube
[root@tranquilpc cube]# rm -rf installer

Finally log into the email (http://192.168.1.107/cube) and in the identities section update your details.  Your email address will be wrong, as will your name.