RoundCube is an easy to use lightweight web mail client. It is a great alternative for checking your email when you don't have your own computer available.
Install RoundCube and its MySQL connector.
apt-get install roundcube roundcube-mysql
Next step will be the package configuration which is done via Debian's configuration dialogs.
First thing the dialogs will ask you is if you want
to create the database for you. If you aswer “yes” then the database will created. If you answer “no” then you will have to do it by hand. Unless you already have a RoundCube database I suggest you answer “yes” here.
Next you have to enter the password for the database administrator. The configuration dialogs need this in order to be able to create the new database.
After creating the database the configuration dialogs create the application user account on the new database and add the necessary permission. You can either choose a password or leave it blank if you want to automatically create a random password. Since I like to be able to debug database problems with the applicaton user, I provided a password. You will have to re-enter the password for saftey.
The configuration dialog tries to create a backup user also. Unfortunately like many systems mine already had one so there was a conflict that I had to resolve by hand later.
If the database configuration did not execute properly or you planned to do it by hand for some reason here is how to.
The database access details can be found under
See the instructions in that file for reference on how to make changes here. Remeber that the configuration options here must match your database setup.
Creating the database:
client as root user.
CREATE DATABASE roundcube; GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON roundcube.* TO roundcube@localhost IDENTIFIED BY '<roundcube user password>'; FLUSH privileges; USE roundcube; SOURCE SOURCE /usr/share/dbconfig-common/DATA/roundcube/install/mysql;
Next you need to run the SQL scripts that create the database layout.
I'll asume here that the email server and roundcube run on the same server. You need to make minor adaptions if they don't.
The Debian configuration dialogs will ask you where your IMAP server resides. If the mail server is on the same machine then
is the right answer.
Next you choose the default locale (i.e. setup the language).
If you don't have the very basic vanilly Debian setup you are not quite done yet.
Find the RoundCube apache configuration file under
Uncomment the following two lines:
Alias /roundcube/program/js/tiny_mce/ /usr/share/tinymce/www/ Alias /roundcube /var/lib/roundcube
No you should be able to see RoundCube under
http://<your server hostname>/roundcube
INSERT INTO users (username, mail_host, created) VALUES ('<username>', 'localhost', now());