QA procedure:Roundcubemail

The following must be working before installing roundcubemail

• mysql (mariadb)

# urpmi mysql
# systemctl start mysqld
# mysql_secure_installation

• https (apache-mod_ssl)
• dovecot (for imap access) The user chosen for use with roundcubemail must be a real linux user (not a made up name just for roundcubemail as in older version of our testing). The user must have the correct directories and files in ~/mail with the correct permissions. In my case I used 'rcmail' as the userid, ...

[drwx------ rcmail   rcmail  ]  /home/rcmail/mail/.imap/INBOX
[-rw------- rcmail   mail    ]  /home/rcmail/mail/.imap/INBOX/dovecot.index.cache
[-rw------- rcmail   mail    ]  /home/rcmail/mail/.imap/INBOX/dovecot.index.log

I created the files with the touch command, and then changed the group and permissions.

After installing roundcubemail

Create a DB user & database for roundcubemail (according to http://trac.roundcube.net/wiki/Howto_Install):

# mysql -u <user> -p
CREATE USER <e.g. roundcube> IDENTIFIED BY <e.g. 'pass'>;
CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO <username>@localhost IDENTIFIED BY <'password'>;
FLUSH PRIVILEGES;
EXIT;

or
Use phpmyadmin to create the rcmail user and the database.

After installation of roundcubemail, the contents of /usr/share/doc/roundcubemail/SQL/sqlite.initial.sql must be run.
I did this with phpmyadmin by loading it into an editor, then copy/pasting it into phpmyadmin, to run.

Don't forget to restart httpd after installing any php packages such as roundcubemail.

After that I was able to log in to https://localhost/roundcubemail/ (after adding an exception for the certificate), and read/compose and send email.

Previously ? redundant ?

You will need to adjust the file /etc/roundcubemail/config.inc.php :

The username (e.g. roundcube) and password (e.g. pass) from the mysql database

$config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';

I added the imap-server for my mail account:

$config['default_host'] = 'imap.your-mail-provider.com';

I added my smtp data for my mail account:

$config['smtp_server'] = 'smtp.your-mail-provider.com';

Then you can go in your webbrowser to http://localhost/roundcubemail/installer
On step 3 you need to initiate your database.

After that you can go to http://localhost/roundcubemail and log into you mail account.

Return to the QA Team portal