Thursday, 20 March 2014

roundcubemail customisation and installation


setting up roundcube mail

1. Install the RPM and dependencies.


      mysql -u root -p' .... ' < '


      create database roundcubemail;


      create user roundcube@localhost identified by 'somepass';


      grant all on roundcubemail.* to roundcube@localhost;


    flush privileges;'

3. then

mysql -u root -p roundcubemail < /usr/share/doc/roundcubemail-0.9.5/SQL/mysql.initial.sql

4. then


edit line to say

$rcmail_config['db_dsnw'] = 'mysql://roundcube:somepass@localhost/roundcubemail';

5. then


and add the following directive

      Alias /roundcube/ "/usr/share/roundcubemail/"


      <Directory "/usr/share/roundcubemail/">


      AllowOverride All


      Options Indexes All


      Order allow,deny


      Allow from all




6. Go to <your host domain name (not FQDN) > /roundcube/


1. ensure that /usr/share/roundcubemail/logs exists and is owned by apache. Create a file 'error' in there with the same ownership.

mkdir -p  /usr/share/roundcubemail/logs

touch /usr/share/roundcubemail/logs/error

chown -R apache:apache  /usr/share/roundcubemail/logs

chmod -R 775  /usr/share/roundcubemail/logs

2. set the same ownership on /etc/roundcubemail

the symptom is a white screen and this error in apache log:

DB Error: Configuration error. Unsupported database driver: in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db. php on line 75 (GET /roundcubemail/)

              chown -R apache:apache    /etc/roundcubemail


      and put in the database password and username

3. Moaning about the timezone:

you have to edit the offending files and insert your timezone, e.g.


line 436 or thereabouts of file rcube_config.php is particularly different:


return $timezone; #; date_default_timezone_get();  /*jmo */

all other files you can just put


the file rcube.php (line 1023) needs this too. 

4. Moaning about missing tables:

login to mysql and create a database roundcubemail

create database roundcubemail character set utf8;

grant all on roundcubemail.* to 'roundcube'@'localhost' identified by 'somepass'; 

then on the commandline (bash):

             mysql roundcubemail -u root -p < /usr/share/doc/roundcubemail-0.9.5/SQL/mysql.initial.sql


5. Setting it to use Gmail:



and tell it

$rcmail_config['default_host'] = 'ssl://';

// TCP port used for IMAP connections
$rcmail_config['default_port'] = 993;

6. To customise it

             Edit /usr/share/roundcubemail/skins/larry or classic

php 7 nightmare

OK so Centos 6 insists on installing php 5.3 and even if you download other RPMs and install them, they do not replace the existing 5.3 whic...